[mythtv-users] Are these SQL errors something to worry about?

David Liana dliana.mythtv at gmail.com
Tue Jan 12 14:31:40 UTC 2010


On Tue, Jan 12, 2010 at 5:24 AM, Jeffrey J. Kosowsky <mythtv at kosowsky.org>wrote:

> I seem to get the following types of errors when watching LiveTV or
> recording shows:
>
> 2010-01-12 04:55:39.561 DB Error (aspect ratio change insert):
> Query was:
> INSERT INTO recordedmarkup (chanid, starttime, mark, type, data) VALUES (
> ?, ?, ?, ?, ?);
> Bindings were:
> :CHANID=2071, :DATA=0, :MARK=15, :STARTTIME=2010-01-12T04:55:38, :TYPE=12
> No error type from QSqlError?  Strange...
> 2010-01-12 04:55:39.595 Error preparing query: INSERT INTO recordedmarkup
>  (chanid, starttime, mark, type, data)    VALUES ( :CHANID, :STARTTIME,
> :MARK, :TYPE, :DATA);
> 2010-01-12 04:55:39.619 Driver error was [2/1054]:
> QMYSQL3: Unable to prepare statement
> Database error was:
> Unknown column 'data' in 'field list'
>
> Originally, I feared that maybe they were caused by my recent editing
> of the sql database to copy over frontend profiles or maybe due to
> incompatibilities between revisions on my Linux vs. Windows
> frontends. But looking back in my logs, the error *precede* either of
> those situations.
>
> But they *all* seem to have occurred since upgrading from 0.21 to
> 0.22. It makes me wonder whether the database was updated properly.
>
> Looking back, I may have done the following:
> - Sourced in new blank database:
>        mysql -u root -p < /usr/share/doc/mythtv-docs-0.22/database/mc.sql
> - Ran mythtv-setup and mythfrontend on that blank database to
>  customize my setup
> - Sourced in my program data tables (record, recorded, oldrecorded,
>  recordedprogram, recordedrating, recordedmarkup, recordedseek) from
>  my latest dump of the old Version 0.21
>            mysql -u mythtv -pmythtv mythconverg < myth-0.21-programdata.sql
>
> Having learned a little sql over the past few days, I now realize that
> the program-related tables may not have been compatible and that
> sourcing the old dump first erased the 0.22 version of the program
> data tables and then replaced it with the 0.21 version of the tables.
>
> - Is this likely to be the source of my problems?
> - Whether or not that was the source of the problem, what can I do to
>  fix things now?
> - Will this lead to corruption, data loss, or issues down the road?
> - Are there any other changed/added/deleted fields in the above tables
>  in moving from 0.21 to 0.22 that I need to fix?
>
> -------------------------------------------------------------------------
> Here are some more of the errors...
>
> 2010-01-12 04:55:39.354 Error preparing query: INSERT INTO recordedmarkup
> (chanid, starttime, mark, type, data) VALUES ( :CHANID, :STARTTIME, :MARK,
> :TYPE, :DATA);
> 2010-01-12 04:55:39.535 Driver error was [2/1054]:
> QMYSQL3: Unable to prepare statement
> Database error was:
> Unknown column 'data' in 'field list'
>
> 2010-01-12 04:55:39.561 DB Error (aspect ratio change insert):
> Query was:
> INSERT INTO recordedmarkup (chanid, starttime, mark, type, data) VALUES (
> ?, ?, ?, ?, ?);
> Bindings were:
> :CHANID=2071, :DATA=0, :MARK=15, :STARTTIME=2010-01-12T04:55:38, :TYPE=12
> No error type from QSqlError?  Strange...
> 2010-01-12 04:55:39.595 Error preparing query: INSERT INTO recordedmarkup
>  (chanid, starttime, mark, type, data)    VALUES ( :CHANID, :STARTTIME,
> :MARK, :TYPE, :DATA);
> 2010-01-12 04:55:39.619 Driver error was [2/1054]:
> QMYSQL3: Unable to prepare statement
> Database error was:
> Unknown column 'data' in 'field list'
>
> 2010-01-12 04:55:39.644 DB Error (Resolution insert):
> Query was:
> INSERT INTO recordedmarkup    (chanid, starttime, mark, type, data)
>  VALUES ( ?, ?, ?, ?, ?);
> Bindings were:
> :CHANID=2071, :DATA=1920, :MARK=15, :STARTTIME=2010-01-12T04:55:38,
> :TYPE=30
> No error type from QSqlError?  Strange...
> 2010-01-12 04:55:39.686 Error preparing query: INSERT INTO recordedmarkup
>  (chanid, starttime, mark, type, data)    VALUES ( :CHANID, :STARTTIME,
> :MARK, :TYPE, :DATA);
> 2010-01-12 04:55:39.712 Driver error was [2/1054]:
> QMYSQL3: Unable to prepare statement
> Database error was:
> Unknown column 'data' in 'field list'
>
> 2010-01-12 04:55:39.737 DB Error (Resolution insert):
> Query was:
> INSERT INTO recordedmarkup    (chanid, starttime, mark, type, data)
>  VALUES ( ?, ?, ?, ?, ?);
> Bindings were:
> :CHANID=2071, :DATA=1080, :MARK=15, :STARTTIME=2010-01-12T04:55:38,
> :TYPE=31
> No error type from QSqlError?  Strange...
> 2010-01-12 04:55:41.850 RecBase(1:/dev/dvb/adapter0/frontend0):
> GetKeyframePositions(75,9223372036854775807,#1) out of 6
> 2010-01-12 04:55:41.893 RecBase(1:/dev/dvb/adapter0/frontend0):
> GetKeyframePositions(75,9223372036854775807,#1) out of 6
> 2010-01-12 04:55:51.198 TVRec(1): Changing from Watching WatchingLiveTV to
> None
> 2010-01-12 04:55:51.426 Error preparing query: SELECT recordedmarkup.DATA
> FROM recordedmarkup WHERE recordedmarkup.chanid = :CHANID AND
> recordedmarkup.starttime = :STARTTIME AND recordedmarkup.type = 30 GROUP BY
> recordedmarkup.data ORDER BY SUM((SELECT IFNULL(rm.mark,
> recordedmarkup.mark) FROM recordedmarkup AS rm WHERE rm.chanid =
> recordedmarkup.chanid AND rm.starttime = recordedmarkup.starttime AND
> rm.type = recordedmarkup.type AND rm.mark > recordedmarkup.mark ORDER BY
> rm.mark ASC LIMIT 1) - recordedmarkup.mark) DESC LIMIT 1;
> 2010-01-12 04:55:51.458 Driver error was [2/1054]:
> QMYSQL3: Unable to prepare statement
> Database error was:
> Unknown column 'recordedmarkup.DATA' in 'field list'
>
> 2010-01-12 04:55:51.484 Unknown type, recording width was 0
> 2010-01-12 04:55:52.013 Finished recording Early Today: channel 2071
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>


I think I got these errors when I dumped my 0.21 database and (improperly)
loaded it over a 0.22 database.  But, that was back in November.


Did you try doing a proper dump/restore with the correct versions?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20100112/7e85e660/attachment.htm>


More information about the mythtv-users mailing list