Home of the Squeezebox™ & Transporter® network music players.
Results 1 to 3 of 3
  1. #1
    Junior Member
    Join Date
    Feb 2020
    Posts
    8

    SQL problems with install

    So I just installed a clean LMS 7.9.3~1580910396

    But getting a bunch of SQL errors:

    MusicServer4Lox
    Log-View
    /VAR/LOG/SQUEEZEBOXSERVER/SERVER.LOG

    2020-02-11 20:34:44 squeezeboxserver_safe started.

    [20-02-11 20:34:45.4642] main::init (387) Starting Logitech Media Server (v7.9.2, 1578996832, Tue Jan 14 12:17:56 CET 2020) perl 5.022001 - x86_64-linux-gnu-thread-multi

    [20-02-11 20:34:45.7379] Slim::Utils::SQLiteHelper:ostConnect (377) Optimizing DB because of missing or empty sqlite_stat1 table

    [20-02-11 20:34:45.7426] Slim::Schema::forceCommit (2143) Warning: Trying to commit transactions before DB is initialized!

    [20-02-11 20:34:45.9152] Slim::Utils::SQLiteHelper:ostConnect (377) Optimizing DB because of missing or empty sqlite_stat1 table

    [20-02-11 20:34:45.9196] Slim::Schema::forceCommit (2143) Warning: Trying to commit transactions before DB is initialized!

    [20-02-11 20:34:45.9830] main::checkDataSource (1107) Warning: Schema updated or no media found in the database, initiating scan.

    [20-02-11 20:34:46.7843] Slim::Utils::SQLiteHelper:ostConnect (377) Optimizing DB because of missing or empty sqlite_stat1 table

    [20-02-11 20:34:46.7945] Slim::Schema::forceCommit (2143) Warning: Trying to commit transactions before DB is initialized!

    [20-02-11 20:39:43.6678] Slim::Utils::Timers::__ANON__ (272) Error: Timer Slim::Networking::SqueezeNetwork::__ANON__ failed:

    [20-02-11 20:39:44.2306] Slim::Utils::SQLiteHelper:ostConnect (377) Optimizing DB because of missing or empty sqlite_stat1 table

    [20-02-11 20:39:44.2356] Slim::Schema::forceCommit (2143) Warning: Trying to commit transactions before DB is initialized!

    [20-02-11 20:39:44.7981] Slim::Utils::SQLiteHelper:ostConnect (377) Optimizing DB because of missing or empty sqlite_stat1 table

    [20-02-11 20:39:44.8032] Slim::Schema::forceCommit (2143) Warning: Trying to commit transactions before DB is initialized!

    [20-02-11 20:39:49.5449] Slim::Networking::SqueezeNetwork::_error (500) Unable to login to SN: Timed out waiting for data

    [20-02-11 20:39:49.5455] Slim::Networking::SqueezeNetwork::_init_error (180) Unable to login to mysqueezebox.com, sync is disabled: Timed out waiting for data (www . mysqueezebox . com)

    [20-02-11 20:39:49.5461] Slim::Networking::SqueezeNetwork::_init_error (196) mysqueezebox.com sync init failed: Timed out waiting for data, will retry in 300 (www . mysqueezebox . com)

    2020-02-11 20:45:58 squeezeboxserver_safe stopped.

    [20-02-11 20:45:58.4394] Slim::Schema::forceCommit (2143) Warning: Trying to commit transactions before DB is initialized!

    [20-02-12 17:39:01.3623] main::init (387) Starting Logitech Media Server (v7.9.3, 1580910396, Thu Feb 6 04:15:54 CET 2020) perl 5.022001 - x86_64-linux-gnu-thread-multi

    [20-02-12 17:39:01.3644] main::changeEffectiveUserAndGroup (1004) Warning: Logitech Media Server must not be run as root! Trying user squeezeboxserver instead.

    [20-02-12 17:39:01.7153] Slim::Utils::SQLiteHelper:ostConnect (377) Optimizing DB because of missing or empty sqlite_stat1 table

    [20-02-12 17:39:01.7289] Slim::Schema::forceCommit (2143) Warning: Trying to commit transactions before DB is initialized!

    [20-02-12 17:39:01.7714] Slim::Utils::SQLiteHelper:ostConnect (377) Optimizing DB because of missing or empty sqlite_stat1 table

    [20-02-12 17:39:01.7790] Slim::Schema::forceCommit (2143) Warning: Trying to commit transactions before DB is initialized!

    [20-02-12 17:39:01.9740] Slim::Utils::SQLiteHelper:ostConnect (377) Optimizing DB because of missing or empty sqlite_stat1 table

    [20-02-12 17:39:01.9787] Slim::Schema::forceCommit (2143) Warning: Trying to commit transactions before DB is initialized!

    [20-02-12 17:39:02.0502] main::checkDataSource (1107) Warning: Schema updated or no media found in the database, initiating scan.

    [20-02-12 17:39:02.7340] Slim::Utils::SQLiteHelper:ostConnect (377) Optimizing DB because of missing or empty sqlite_stat1 table

    [20-02-12 17:39:02.7389] Slim::Schema::forceCommit (2143) Warning: Trying to commit transactions before DB is initialized!

  2. #2
    Babelfish's Best Boy mherger's Avatar
    Join Date
    Apr 2005
    Location
    Switzerland
    Posts
    20,367

    SQL problems with install

    > But getting a bunch of SQL errors:
    ....
    >> [20-02-11 20:34:45.7379] Slim::Utils::SQLiteHelper:ostConnect (377)
    >> Optimizing DB because of missing or empty sqlite_stat1 table
    >>
    >> [20-02-11 20:34:45.7426] Slim::Schema::forceCommit (2143) Warning:
    >> Trying to commit transactions before DB is initialized!


    It says "Warning", not "Error" :-). It's always printed when you start
    with an empty library. Nothing to be worried about.


    --

    Michael

  3. #3
    Senior Member paul-'s Avatar
    Join Date
    Jan 2013
    Posts
    2,788
    On the other hand, I would be worried about this Warning
    Code:
    [20-02-12 17:39:01.3644] main::changeEffectiveUserAndGroup (1004) Warning: Logitech Media Server must not be run as root! Trying user squeezeboxserver instead.
    piCorePlayer a small player for the Raspberry Pi in RAM.
    Homepage: https://www.picoreplayer.org

    Please donate if you like the piCorePlayer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •