mythbuntu-bugs team mailing list archive

[Bug Watch Updater <330272@xxxxxxxxxxxxxxxxxx>]

** Changed in: mythtv
       Status: New => Confirmed

-- 
mythbackend silently fails with QSqlQuery::exec: empty query
https://bugs.launchpad.net/bugs/330272
You received this bug notification because you are a member of Mythbuntu
Bug Team, which is subscribed to mythtv in ubuntu.

Status in MythTV: Confirmed
Status in “mythtv” package in Ubuntu: Triaged

Bug description:
Binary package hint: mythtv-backend

Hi,

Randomly and without warning, mythbackend will silently fail without actually exiting. From the moment of failure onwards, it is unable to perform any database queries, but will continue to serve data to some functions. 

The log will switch from normal logging, to errors pertaining to QSqlQuery::exec: failures, and Query failures. Such as - 

2009-01-23 20:40:14.676 Scheduled 76 items in 0.4 = 0.02 match + 0.40 place
2009-01-23 20:42:15.071 MainServer::HandleAnnounce Monitor
2009-01-23 20:42:15.075 adding: flat as a client (events: 0)
QSqlQuery::exec: empty query
QSqlQuery::exec: empty query
QSqlQuery::exec: empty query

I have been unable to ascertain the source of the problem, as it appears to happen whilst the system is not in use (ie, whilst at work, or late at night). I have aattached a more comprehensive log in case it may be useful.

Regards

Kyle

The following information may apply...

ii  libmyth-0.21-0                             0.21.0+fixes16838-0ubuntu3.1 Common library code for MythTV and add-on mo
ii  libmyth-perl                               0.21.0+fixes16838-0ubuntu3.1 A PERL library to access some MythTV feature
ii  mythtv-backend                             0.21.0+fixes16838-0ubuntu3.1 A personal video recorder application (serve
ii  mythtv-backend-master                      0.21.0+fixes16838-0ubuntu3.1 Metapackage to setup and configure a "Master
ii  mythtv-common                              0.21.0+fixes16838-0ubuntu3.1 A personal video recorder application (commo
ii  mythtv-database                            0.21.0+fixes16838-0ubuntu3.1 A personal video recorder application (datab
ii  mythtv-transcode-utils                     0.21.0+fixes16838-0ubuntu3.1 Utilities used for transcoding MythTV tasks
ii  mythweb                                    0.21.0+fixes16838-0ubuntu2.1 Web interface add-on module for MythTV

Linux flat 2.6.24-23-generic #1 SMP Mon Jan 26 00:13:11 UTC 2009 i686 GNU/Linux

Description:	Ubuntu 8.04.2
Release:	8.04

ii  libdbd-mysql-perl                          4.005-1                      A Perl5 database interface to the MySQL data
ii  libmysqlclient15off                        5.0.51a-3ubuntu5.4           MySQL database client library
ii  libqt3-mt-mysql                            3:3.3.8-b-0ubuntu3           MySQL database driver for Qt3 (Threaded)
ii  mysql-client                               5.0.51a-3ubuntu5.4           MySQL database client (meta package dependin
ii  mysql-client-5.0                           5.0.51a-3ubuntu5.4           MySQL database client binaries
ii  mysql-common                               5.0.51a-3ubuntu5.4           MySQL database common files
ii  mysql-server                               5.0.51a-3ubuntu5.4           MySQL database server (meta package dependin
ii  mysql-server-5.0                           5.0.51a-3ubuntu5.4           MySQL database server binaries