Skip to content

Instantly share code, notes, and snippets.

@Gremlyn
Created December 14, 2012 19:45
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Gremlyn/4288070 to your computer and use it in GitHub Desktop.
Save Gremlyn/4288070 to your computer and use it in GitHub Desktop.
Error with mythbackend after restarting Ubuntu 11.10. The mythbackend process is definitely starting when the computer boots up.
Dec 14 10:40:32 gremyth mythbackend[2280]: E CoreContext mythdbcon.cpp:823 (prepare) Error preparing query: SELECT data FROM settings WHERE value = :KEY AND hostname = :HOSTNAME
Dec 14 10:40:32 gremyth mythbackend[2280]: E CoreContext mythdbcon.cpp:825 (prepare) Driver error was [2/2006]:#012QMYSQL3: Unable to prepare statement#012Database error was:#012MySQL server has gone away
Dec 14 10:40:32 gremyth mythbackend[2280]: I CoreContext mythdbcon.cpp:611 (exec) MySQL server disconnected
Dec 14 10:40:32 gremyth mythbackend[2280]: I CoreContext mythdbcon.cpp:808 (prepare) MySQL server disconnected
Dec 14 10:40:32 gremyth mythbackend[2280]: I CoreContext mythdbcon.cpp:611 (exec) MySQL server disconnected
Dec 14 10:40:32 gremyth mythbackend[2280]: E CoreContext mythdbcon.cpp:213 (OpenDatabase) Unable to connect to database!
Dec 14 10:40:32 gremyth mythbackend[2280]: E CoreContext mythdbcon.cpp:214 (OpenDatabase) Driver error was [1/2002]:#012QMYSQL: Unable to connect#012Database error was:#012Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Dec 14 10:40:32 gremyth mythbackend[2280]: E CoreContext mythdb.cpp:623 (GetSettingOnHost) Database not open while trying to load setting: backendserverip
Dec 14 10:40:32 gremyth mythbackend[2280]: E CoreContext mythdbcon.cpp:213 (OpenDatabase) Unable to connect to database!
Dec 14 10:40:32 gremyth mythbackend[2280]: E CoreContext mythdbcon.cpp:214 (OpenDatabase) Driver error was [1/2002]:#012QMYSQL: Unable to connect#012Database error was:#012Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Dec 14 10:40:32 gremyth mythbackend[2280]: E CoreContext mythdb.cpp:623 (GetSettingOnHost) Database not open while trying to load setting: backendserverip6
Dec 14 10:40:32 gremyth mythbackend[2280]: N CoreContext main_helpers.cpp:664 (run_backend) MythBackend exiting
Dec 14 10:40:32 gremyth mythbackend[2280]: E DBLogger mythdb.cpp:192 (DBError) DB Error (DBLogging):#012Query was:#012INSERT INTO logging (host, application, pid, tid, thread, filename, line, function, msgtime, level, message) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)#012Bindings were:#012:APP="mythbackend", :FILENAME="mythdbcon.cpp", :FUNCTION="prepare",#012:HOST="gremyth", :LEVEL=3, :LINE=823,#012:MESSAGE="Error preparing query: SELECT data FROM settings WHERE value = :KEY AND hostname = :HOSTNAME",#012:MSGTIME="2012-12-14 10:40:32", :PID=2280, :THREAD="CoreContext", :TID=2280#012Driver error was [2/2006]:#012QMYSQL3: Unable to reset statement#012Database error was:#012MySQL server has gone away
Dec 14 10:40:32 gremyth mythbackend[2280]: E DBLogger mythdbcon.cpp:213 (OpenDatabase) Unable to connect to database!
Dec 14 10:41:07 gremyth mythbackend[24788]: C thread_unknown mythcommandlineparser.cpp:2534 (ConfigureLogging) mythbackend version: fixes/0.25 [v0.25.3-23-g0b60406] www.mythtv.org
Dec 14 10:41:07 gremyth mythbackend[24788]: C thread_unknown mythcommandlineparser.cpp:2536 (ConfigureLogging) Qt version: compile: 4.7.4, runtime: 4.7.4
Dec 14 10:41:07 gremyth mythbackend[24788]: N thread_unknown mythcommandlineparser.cpp:2538 (ConfigureLogging) Enabled verbose msgs: general
Dec 14 10:41:07 gremyth mythbackend[24788]: N thread_unknown logging.cpp:1176 (logStart) Setting Log Level to LOG_INFO
Dec 14 10:41:07 gremyth mythbackend[24788]: I thread_unknown logging.cpp:229 (FileLogger) Added logging to the console
Dec 14 10:41:07 gremyth mythbackend[24788]: I thread_unknown logging.cpp:369 (SyslogLogger) Added syslogging to facility local7
Dec 14 10:41:07 gremyth mythbackend[24788]: I thread_unknown logging.cpp:425 (DatabaseLogger) Added database logging to table logging
Dec 14 10:41:07 gremyth mythbackend[24788]: N thread_unknown logging.cpp:1215 (logStart) Setting up SIGHUP handler
Dec 14 10:41:07 gremyth mythbackend[24788]: N thread_unknown mythdirs.cpp:51 (InitializeMythDirs) Using runtime prefix = /usr
Dec 14 10:41:07 gremyth mythbackend[24788]: N thread_unknown mythdirs.cpp:64 (InitializeMythDirs) Using configuration directory = /home/mythtv/.mythtv
Dec 14 10:41:07 gremyth mythbackend[24788]: I CoreContext mythcorecontext.cpp:227 (Init) Assumed character encoding: en_US.UTF-8
Dec 14 10:41:07 gremyth mythbackend[24788]: N CoreContext mythcontext.cpp:477 (LoadDatabaseSettings) Empty LocalHostName.
Dec 14 10:41:07 gremyth mythbackend[24788]: I CoreContext mythcontext.cpp:481 (LoadDatabaseSettings) Using localhost value of gremyth
Dec 14 10:41:07 gremyth mythbackend[24788]: N CoreContext mythcorecontext.cpp:1270 (InitLocale) Setting QT default locale to EN_US
Dec 14 10:41:07 gremyth mythbackend[24788]: I CoreContext mythcorecontext.cpp:1303 (SaveLocaleDefaults) Current locale EN_US
Dec 14 10:41:07 gremyth mythbackend[24788]: N CoreContext mythlocale.cpp:121 (LoadDefaultsFromXML) Reading locale defaults from /usr/share/mythtv//locales/en_us.xml
Dec 14 10:41:07 gremyth mythbackend[24788]: I CoreContext schemawizard.cpp:117 (Compare) Current MythTV Schema Version (DBSchemaVer): 1299
Dec 14 10:41:07 gremyth mythbackend[24788]: I CoreContext mythtranslation.cpp:66 (load) Loading en_us translation for module mythfrontend
Dec 14 10:41:07 gremyth mythbackend[24788]: N CoreContext main_helpers.cpp:556 (run_backend) MythBackend: Starting up as the master server.
Dec 14 10:41:08 gremyth mythbackend[24788]: I CoreContext programinfo.cpp:2052 (CheckProgramIDAuthorities) Found 1 distinct programid authorities
Dec 14 10:41:08 gremyth mythbackend[24788]: I Scheduler mythdbcon.cpp:422 (getStaticCon) New static DB connectionSchedCon
Dec 14 10:41:08 gremyth mythbackend[24788]: I CoreContext serverpool.cpp:395 (listen) Listening on TCP 127.0.0.1:6544
Dec 14 10:41:08 gremyth mythbackend[24788]: I CoreContext serverpool.cpp:395 (listen) Listening on TCP 192.168.0.151:6544
Dec 14 10:41:08 gremyth mythbackend[24788]: I CoreContext serverpool.cpp:395 (listen) Listening on TCP [0:0:0:0:0:0:0:1]:6544
Dec 14 10:41:08 gremyth mythbackend[24788]: I CoreContext serverpool.cpp:395 (listen) Listening on TCP [fe80:0:0:0:230:67ff:fecd:1a3a%eth0]:6544
Dec 14 10:41:08 gremyth mythbackend[24788]: N CoreContext mediaserver.cpp:169 (Init) MediaServer:: Loopback address specified - localhost. Disabling UPnP
Dec 14 10:41:08 gremyth mythbackend[24788]: I CoreContext main_helpers.cpp:626 (run_backend) Main::Registering HttpStatus Extension
Dec 14 10:41:08 gremyth mythbackend[24788]: E CoreContext serverpool.cpp:407 (listen) Failed listening on TCP 127.0.0.1:6543 - Error 8: The bound address is already in use
Dec 14 10:41:08 gremyth mythbackend[24788]: C CoreContext main_helpers.cpp:639 (run_backend) Backend exiting, MainServer initialization error.
Dec 14 10:41:18 gremyth mythbackend[24788]: I HouseKeeping housekeeper.cpp:225 (RunHouseKeeping) Running housekeeping thread
Dec 14 10:42:58 gremyth mythbackend[1831]: C thread_unknown mythcommandlineparser.cpp:2534 (ConfigureLogging) mythbackend version: fixes/0.25 [v0.25.3-23-g0b60406] www.mythtv.org
Dec 14 10:42:58 gremyth mythbackend[1831]: C thread_unknown mythcommandlineparser.cpp:2536 (ConfigureLogging) Qt version: compile: 4.7.4, runtime: 4.7.4
Dec 14 10:42:58 gremyth mythbackend[1831]: N thread_unknown mythcommandlineparser.cpp:2538 (ConfigureLogging) Enabled verbose msgs: general
Dec 14 10:42:58 gremyth mythbackend[1831]: N thread_unknown logging.cpp:1176 (logStart) Setting Log Level to LOG_INFO
Dec 14 10:42:58 gremyth mythbackend[1831]: I thread_unknown logging.cpp:229 (FileLogger) Added logging to the console
Dec 14 10:42:58 gremyth mythbackend[1831]: I thread_unknown logging.cpp:369 (SyslogLogger) Added syslogging to facility local7
Dec 14 10:42:58 gremyth mythbackend[1831]: I thread_unknown logging.cpp:425 (DatabaseLogger) Added database logging to table logging
Dec 14 10:42:58 gremyth mythbackend[1831]: N thread_unknown logging.cpp:1215 (logStart) Setting up SIGHUP handler
Dec 14 10:42:58 gremyth mythbackend[1831]: N thread_unknown mythdirs.cpp:51 (InitializeMythDirs) Using runtime prefix = /usr
Dec 14 10:42:58 gremyth mythbackend[1831]: N thread_unknown mythdirs.cpp:64 (InitializeMythDirs) Using configuration directory = /home/mythtv/.mythtv
Dec 14 10:42:58 gremyth mythbackend[1831]: I CoreContext mythcorecontext.cpp:227 (Init) Assumed character encoding: en_US.UTF-8
Dec 14 10:42:58 gremyth mythbackend[1831]: N CoreContext mythcontext.cpp:477 (LoadDatabaseSettings) Empty LocalHostName.
Dec 14 10:42:58 gremyth mythbackend[1831]: I CoreContext mythcontext.cpp:481 (LoadDatabaseSettings) Using localhost value of gremyth
Dec 14 10:42:58 gremyth mythbackend[1831]: N CoreContext mythcorecontext.cpp:1270 (InitLocale) Setting QT default locale to EN_US
Dec 14 10:42:58 gremyth mythbackend[1831]: I CoreContext mythcorecontext.cpp:1303 (SaveLocaleDefaults) Current locale EN_US
Dec 14 10:42:58 gremyth mythbackend[1831]: N CoreContext mythlocale.cpp:121 (LoadDefaultsFromXML) Reading locale defaults from /usr/share/mythtv//locales/en_us.xml
Dec 14 10:42:58 gremyth mythbackend[1831]: I CoreContext schemawizard.cpp:117 (Compare) Current MythTV Schema Version (DBSchemaVer): 1299
Dec 14 10:42:58 gremyth mythbackend[1831]: I CoreContext mythtranslation.cpp:66 (load) Loading en_us translation for module mythfrontend
Dec 14 10:42:58 gremyth mythbackend[1831]: N CoreContext main_helpers.cpp:556 (run_backend) MythBackend: Starting up as the master server.
Dec 14 10:42:58 gremyth mythbackend[1831]: I CoreContext programinfo.cpp:2052 (CheckProgramIDAuthorities) Found 1 distinct programid authorities
Dec 14 10:42:58 gremyth mythbackend[1831]: I Scheduler mythdbcon.cpp:422 (getStaticCon) New static DB connectionSchedCon
Dec 14 10:42:58 gremyth mythbackend[1831]: I CoreContext serverpool.cpp:395 (listen) Listening on TCP 127.0.0.1:6544
Dec 14 10:42:58 gremyth mythbackend[1831]: I CoreContext serverpool.cpp:395 (listen) Listening on TCP 192.168.0.151:6544
Dec 14 10:42:58 gremyth mythbackend[1831]: I CoreContext serverpool.cpp:395 (listen) Listening on TCP [0:0:0:0:0:0:0:1]:6544
Dec 14 10:42:58 gremyth mythbackend[1831]: E CoreContext serverpool.cpp:407 (listen) Failed listening on TCP [fe80:0:0:0:230:67ff:fecd:1a3a%eth0]:6544 - Error 9: The address is not available
Dec 14 10:42:58 gremyth mythbackend[1831]: E CoreContext mediaserver.cpp:86 (Init) MediaServer::HttpServer Create Error
Dec 14 10:42:58 gremyth mythbackend[1831]: I CoreContext serverpool.cpp:395 (listen) Listening on TCP 127.0.0.1:6543
Dec 14 10:42:58 gremyth mythbackend[1831]: I CoreContext serverpool.cpp:395 (listen) Listening on TCP 192.168.0.151:6543
Dec 14 10:42:58 gremyth mythbackend[1831]: I CoreContext serverpool.cpp:395 (listen) Listening on TCP [0:0:0:0:0:0:0:1]:6543
Dec 14 10:42:58 gremyth mythbackend[1831]: E CoreContext serverpool.cpp:407 (listen) Failed listening on TCP [fe80:0:0:0:230:67ff:fecd:1a3a%eth0]:6543 - Error 9: The address is not available
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment