id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc	mlocked
1886	mythbackend gets stuck when the database disappears	chrisb@…	Isaac Richards	"Sorry if this bug has already been reported, but I was unable to find it using the search..

Using mythtv version: 0.19.20060121-2

If the MySQL server goes down while mythbackend is running, it appears to get stuck in an infinite loop. It fills the log with the following message repeated every few  milliseconds:

2006-05-28 16:41:44.730 DB Error (insert_program -- lock):
Query was:
LOCK TABLES recorded WRITE
No error type from QSqlError?  Strange...
QSqlQuery::prepare: database not open
QSqlQuery::exec: database not open
2006-05-28 16:41:44.741 DB Error (insert_program -- lock):
Query was:
LOCK TABLES recorded WRITE
No error type from QSqlError?  Strange...
QSqlQuery::prepare: database not open
QSqlQuery::exec: database not open
2006-05-28 16:41:44.754 DB Error (insert_program -- lock):
Query was:
LOCK TABLES recorded WRITE
No error type from QSqlError?  Strange...
QSqlQuery::prepare: database not open
QSqlQuery::exec: database not open

Even after the database comes back up, the situation is not resolved. From the looks of it, at no point does it attempt to reconnect to the database, but instead just retries the same query over and over again on the old dead database connection.

"	defect	closed	critical	unknown	mythtv	0.19	high	fixed			0