[mythtv-users] DB Error (SimpleDBStorage::load()):

Stephen Robertson stephengrobertson at gmail.com
Tue Mar 31 11:19:24 UTC 2009


I'm still having real problems with the backend hanging/crashing.  I
am really at a loss to find out what is going on.  The backend log
shows a DB Error (I have also seen DB Error (Looking up chanID): ).

The mysql log doesnt seem to show anything.  This is happening when
there are no recordings or playback happening

Any suggestions on debugging this?  Other logging options to turn on
or things to try?

Thanks for all your help.

Stephen

Version Info:
MythTV Version   : 20239
MythTV Branch    : branches/release-0-21-fixes
Library API      : 0.21.20080304-1
Network Protocol : 40
Options compiled in:
 linux profile using_oss using_alsa using_jack using_backend
using_dbox2 using_dvb using_firewire using_frontend using_hdhomerun
using_iptv using_ivtv using_joystick_menu using_libfftw3 using_lirc
using_opengl_vsync using_opengl_video using_v4l using_x11 using_xrandr
using_xv using_xvmc using_xvmcw using_xvmc_vld using_glx_proc_addr_arb
using_bindings_perl using_bindings_python using_opengl
using_ffmpeg_threads using_libavc_5_3 using_live

mythbackend.log:
2009-03-31 11:37:28.584 EITCache: Wrote 1 modified entries of 281 for
channel 5668 to database.
2009-03-31 11:37:28.590 EITCache: Wrote 2 modified entries of 253 for
channel 9273 to database.
2009-03-31 11:37:28.598 EITCache: Wrote 2 modified entries of 253 for
channel 9325 to database.
2009-03-31 11:37:28.676 EITCache: Wrote 80 modified entries of 220 for
channel 9442 to database.
2009-03-31 11:37:29.097 EITScanner (1): Now looking for EIT data on
multiplex of channel 5
2009-03-31 11:37:29.100 EITCache: Pruning all entries that ended
before UTC 2009-03-30T11:42:44
2009-03-31 11:37:29.178 EITCache: Deleting old cache entries from the database
2009-03-31 11:37:30.430 EITScanner (1): Started passive scan.
2009-03-31 11:37:31.621 EITHelper: Added 1 events
2009-03-31 11:37:32.453 EITHelper: Added 1 events
2009-03-31 11:38:32.462 EITScanner (1): Added 2 EIT Events
2009-03-31 11:38:32.465 EITScanner: Rate limiting reschedules..
2009-03-31 11:40:04.255 DB Error (SimpleDBStorage::load()):
Query was:

No error type from QSqlError?  Strange...
2009-03-31 11:40:04.259 DB Error (SimpleDBStorage::load()):
Query was:

No error type from QSqlError?  Strange...
2009-03-31 11:40:04.260 DB Error (SimpleDBStorage::load()):
Query was:

No error type from QSqlError?  Strange...
2009-03-31 11:40:04.261 DB Error (SimpleDBStorage::load()):
Query was:

No error type from QSqlError?  Strange...
2009-03-31 11:40:04.262 DB Error (SimpleDBStorage::load()):
Query was:

No error type from QSqlError?  Strange...
2009-03-31 11:40:04.263 DB Error (SimpleDBStorage::load()):
Query was:

No error type from QSqlError?  Strange...
2009-03-31 11:40:04.264 DB Error (SimpleDBStorage::load()):
Query was:

No error type from QSqlError?  Strange...
2009-03-31 11:40:04.314 DB Error (SimpleDBStorage::load()):
Query was:

No error type from QSqlError?  Strange...
QDateTime::fromString: Parameter out of range
2009-03-31 11:41:07.067 Using runtime prefix = /usr
2009-03-31 11:41:07.075 Empty LocalHostName.
2009-03-31 11:41:07.076 Using localhost value of bressay
2009-03-31 11:41:07.637 Cannot find default UPnP backend
2009-03-31 11:41:07.653 New DB connection, total: 1
2009-03-31 11:41:07.659 Connected to database 'mythconverg' at host: 127.0.0.1
2009-03-31 11:41:07.662 Closing DB connection named 'DBManager0'
2009-03-31 11:41:07.663 Deleting UPnP client...
2009-03-31 11:41:08.433 Connected to database 'mythconverg' at host: 127.0.0.1
2009-03-31 11:41:08.438 New DB connection, total: 2
2009-03-31 11:41:08.440 Connected to database 'mythconverg' at host: 127.0.0.1
2009-03-31 11:41:08.444 Current Schema Version: 1214
Starting up as the master server.


More information about the mythtv-users mailing list