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

[Jerry]

On Sat, Aug 31, 2013 at 7:14 PM, Mike McMullin <mwmcmlln at mnsi.net> wrote:

> 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
>
>
I'd try running the optimize_mythdb.pl script.  In my system, it's located
at /usr/share/doc/mythtv-docs-0.26.0/contrib/maintenance/optimize_mythdb.pl

http://v2kblog.blogspot.com/2009/03/fixing-mythtv-database-table.html is a
page of a guy who was saved by this program with a similar situation to
yours.

I run it every night around 3 AM as a cron job.

HTH,
Jerry
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20130831/510ea127/attachment.html>