[mythtv-users] mythfilldatabase fails on mariadb

[Mark Perkins]

> On 3 Nov 2014, at 2:00 pm, "Darwin O'Connor" <doconno at gmail.com> wrote:
> 
> 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

Wait, MythTV has replaced MySQL with mariadb? Did I miss something? Is that a requirement of Master (0.28) now?


> (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...
> 
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://www.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org