[mythtv-users] mysql hangs after upgrade to 0.23.1

Jonas Kvinge linuxtv at closetothewind.net
Wed Aug 18 22:43:05 UTC 2010


Please attach all output as a file in bug reports.
MythTV Version   : 0.23.1
MythTV Branch    : tags/release-0-23-1
Network Protocol : 23056
Library API      : 0.23.1.201000710-1
QT Version       : 4.6.3
Options compiled in:
 linux release using_oss using_alsa using_pulse using_jack
using_pulseoutput using_backend using_dvb using_firewire using_frontend
using_hdhomerun using_hdpvr using_iptv using_ivtv using_joystick_menu
using_libfftw3 using_lirc using_mheg using_opengl_video
using_opengl_vsync using_qtdbus using_qtwebkit using_v4l using_x11
using_xrandr using_xv using_xvmc using_xvmc_vld using_xvmcw
using_bindings_perl using_bindings_python using_opengl using_vdpau
using_ffmpeg_threads using_libavc_5_3 using_live using_mheg


mysql  Ver 14.14 Distrib 5.1.46, for suse-linux-gnu (x86_64) using
readline 6.1


Running mythfrontend in verbose all this is the last thing thats going on:


2010-08-19 00:27:22.519 MSqlQuery::next(DBManager0) Result: "name =
RTjpeg/MPEG4, id = 21"
2010-08-19 00:27:22.519 MSqlQuery::next(DBManager0) Result: "name =
MPEG2, id = 22"
2010-08-19 00:27:22.519 MSqlQuery::next(DBManager0) Result: "name = High
Quality, id = 27"
2010-08-19 00:27:22.519 MSqlQuery::next(DBManager0) Result: "name =
Medium Quality, id = 28"
2010-08-19 00:27:22.519 MSqlQuery::next(DBManager0) Result: "name = Low
Quality, id = 29"
2010-08-19 00:27:22.520 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'userjobdesc1' AND hostname = 'linuxtv' <<<<
Returns 0 row(s)
2010-08-19 00:27:22.520 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'userjobdesc1' AND hostname IS NULL <<<< Returns
1 row(s)
2010-08-19 00:27:22.520 MSqlQuery::next(DBManager0) Result: "data = User
Job #1"
2010-08-19 00:27:22.520 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'userjobdesc2' AND hostname = 'linuxtv' <<<<
Returns 0 row(s)
2010-08-19 00:27:22.521 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'userjobdesc2' AND hostname IS NULL <<<< Returns
1 row(s)
2010-08-19 00:27:22.521 MSqlQuery::next(DBManager0) Result: "data = User
Job #2"
2010-08-19 00:27:22.521 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'userjobdesc3' AND hostname = 'linuxtv' <<<<
Returns 0 row(s)
2010-08-19 00:27:22.521 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'userjobdesc3' AND hostname IS NULL <<<< Returns
1 row(s)
2010-08-19 00:27:22.521 MSqlQuery::next(DBManager0) Result: "data = User
Job #3"
2010-08-19 00:27:22.521 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'userjobdesc4' AND hostname = 'linuxtv' <<<<
Returns 0 row(s)
2010-08-19 00:27:22.522 MSqlQuery::exec(DBManager0) SELECT data FROM
settings WHERE value = 'userjobdesc4' AND hostname IS NULL <<<< Returns
1 row(s)
2010-08-19 00:27:22.522 MSqlQuery::next(DBManager0) Result: "data = User
Job #4"
^C


More information about the mythtv-users mailing list