[mythtv-users] mysql seems crashed, and logging crashed

Mike McMullin mwmcmlln at MNSi.net
Sat Aug 31 23:14:48 UTC 2013


MythTV Version : v0.25.2-15-g46cab93
MythTV Branch : fixes/0.25
Network Protocol : 72
Library API : 0.25.20120506-1
QT Version : 4.8.1


I don't have a mythconverg directory nor does a locate indicate anything
like ./mythconverg/logging, mythfrontend staus indicates that there is
no current data for the program guide.

Where should I be able to find the logging, and how do I tell if the
mysql databse is crashed or fine?

Aug 31 18:58:28 front-main mythbackend[1921]: 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
(:HOST, :APP, :PID, :TID, :THREAD, :FILENAME,         :LINE, :FUNCTION, :MSGTIME, :LEVEL, :MESSAGE)#012Bindings were:#012:APP="mythbackend", :FILENAME="mythcommandlineparser.cpp",#012:FUNCTION="ConfigureLogging", :HOST="front-main", :LEVEL=2, :LINE=2534,#012:MESSAGE="mythbackend version: fixes/0.25 [v0.25.2-15-g46cab93] www.mythtv.org",#012:MSGTIME="2013-08-31 00:21:21", :PID=1921, :THREAD="CoreContext", :TID=1921#012Driver error was [2/1064]:#012QMYSQL: Unable to execute query#012Database error was:#012You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':HOST, :APP, :PID, :TID, :THREAD, :FILENAME,         :LINE, :FUNCTION, :MSGTIME,' at line 1
Aug 31 18:58:28 front-main mythbackend[1921]: E DBLogger
mythdbcon.cpp:823 (prepare) Error preparing query: INSERT INTO logging
(host, application, pid, tid, thread, filename,      line, function,
msgtime, level, message) VALUES
(:HOST, :APP, :PID, :TID, :THREAD, :FILENAME,         :LINE, :FUNCTION, :MSGTIME, :LEVEL, :MESSAGE)
Aug 31 18:58:28 front-main mythbackend[1921]: E DBLogger
mythdbcon.cpp:825 (prepare) Driver error was [2/144]:#012QMYSQL3: Unable
to prepare statement#012Database error was:#012Table
'./mythconverg/logging' is marked as crashed and last (automatic?)
repair failed



More information about the mythtv-users mailing list