[mythtv-users] mythfilldatabase fails on mariadb

[Darwin O'Connor]

I use mythtv on mac os x installed with macports.

When mythfilldatabase is run after it gets part way through (where it fails
varies) it gets errors saying "MySQL server has gone away". This started
when I replaced mysql with mariadb as required by the latest version of
mythtv (but before I upgraded to the latest version). I migrated the data
by dumping all databases from mysql and then loading them into mariadb.

When I stop mythbackend I can run mythfilldatabase successfully. I use
schedulesdirect as my data provider.

I noticed mariadb was very slow, even for the other databases I run, for
the first few hours after I installed it, but that seems to resolve itself
after a while.

Here is part of the mythfilldatabase log where the errors start:

2014-10-31 20:12:22.066755 I [99507/4103] CoreContext filldata.cpp:733
(Run) - Checking day @ offset 3, date: Tue Nov 4 2014
2014-10-31 20:12:22.066766 I [99507/4103] CoreContext filldata.cpp:747
(Run) - Data Refresh needed because of user request
2014-10-31 20:12:22.066771 N [99507/4103] CoreContext filldata.cpp:891
(Run) - Refreshing data for Tue Nov 4 2014
2014-10-31 20:12:22.155549 I [99507/4103] CoreContext filldata.cpp:212
(GrabDDData) - Retrieving datadirect data.
2014-10-31 20:12:22.156839 I [99507/4103] CoreContext filldata.cpp:230
(GrabDDData) - Grabbing data for Sat Nov 1 2014 offset 3
2014-10-31 20:12:22.156872 I [99507/4103] CoreContext filldata.cpp:233
(GrabDDData) - From 2014-11-04T00:00:00Z to 2014-11-05T00:00:00Z (UTC)
2014-10-31 20:12:22.156890 I [99507/4103] CoreContext datadirect.cpp:1177
(GrabData) - DataDirect: Grabbing listing data
2014-10-31 20:12:22.156935 I [99507/4103] CoreContext datadirect.cpp:1031
(DDPost) - Downloading DataDirect feed
2014-10-31 20:12:28.596950 I [99507/4103] CoreContext datadirect.cpp:1043
(DDPost) - Downloaded 500277 bytes
2014-10-31 20:12:28.596964 I [99507/4103] CoreContext datadirect.cpp:1045
(DDPost) - Uncompressing DataDirect feed
2014-10-31 20:12:28.615931 I [99507/4103] CoreContext datadirect.cpp:1050
(DDPost) - Uncompressed to 4449306 bytes
2014-10-31 20:12:29.098597 I [99507/4103] CoreContext datadirect.cpp:463
(characters) - DataDirect: Your subscription expires on Saturday Aug 22
(2015) 9:21 AM
2014-10-31 20:12:46.985537 I [99507/4103] CoreContext filldata.cpp:254
(GrabDDData) - Grab complete.  Actual data from 2014-11-04T00:00:00Z to
2014-11-05T00:00:00Z (UTC)
2014-10-31 20:12:47.443633 I [99507/4103] CoreContext filldata.cpp:258
(GrabDDData) - Main temp tables populated.
2014-10-31 20:12:48.401363 I [99507/4103] CoreContext filldata.cpp:291
(GrabDDData) - Clearing data for source.
2014-10-31 20:12:48.401394 I [99507/4103] CoreContext filldata.cpp:297
(GrabDDData) - Clearing from 2014-11-03T19:00:00 to 2014-11-04T19:00:00
(localtime)
2014-10-31 20:16:01.759090 E [99507/4103] CoreContext mythdbcon.cpp:844
(prepare) - Error preparing query: DELETE FROM programrating WHERE
starttime >= :FROM AND starttime < :TO AND chanid = :CHANID ;
2014-10-31 20:16:01.759112 E [99507/4103] CoreContext mythdbcon.cpp:846
(prepare) - Driver error was [2/2006]:
QMYSQL3: Unable to prepare statement
Database error was:
MySQL server has gone away

2014-10-31 20:16:01.759268 I [99507/4103] CoreContext mythdbcon.cpp:625
(exec) - MySQL server disconnected
2014-10-31 20:16:01.759397 I [99507/4103] CoreContext mythdbcon.cpp:822
(prepare) - MySQL server disconnected
2014-10-31 20:16:01.759525 I [99507/4103] CoreContext mythdbcon.cpp:625
(exec) - MySQL server disconnected
2014-10-31 20:16:01.759668 I [99507/4103] CoreContext mythdbcon.cpp:822
(prepare) - MySQL server disconnected
2014-10-31 20:16:01.759821 I [99507/4103] CoreContext mythdbcon.cpp:625
(exec) - MySQL server disconnected
2014-10-31 20:16:01.760116 I [99507/4103] CoreContext mythdbcon.cpp:822
(prepare) - MySQL server disconnected
2014-10-31 20:16:01.760246 I [99507/4103] CoreContext mythdbcon.cpp:625
(exec) - MySQL server disconnected
2014-10-31 20:16:01.760276 E [99507/4103] CoreContext mythdb.cpp:183
(DBError) - DB Error (Selecting channel/dtv_multiplex 1):
Query was:

No error type from QSqlError?  Strange...
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20141102/21ffcb5e/attachment.html>