[mythtv-users] Upgrade issues.

[Marc Tousignant]

I just updated from 16407 to 20281. Yes I know. I go by the saying if it
works don't break it. That and I am married now and don't want my wife to
complain about it not working.

 

I ran into several issues during the upgrade.

Both my oldrecorded and people databases had to be truncated in order for
the database schema to be updated successfully.

In my oldrecorded table I was getting a "Duplicate entry '' for key 1"
error.

In my people table I was getting a "Duplicate entry 'Jos' for key 2" error.

 

Now that I am upgraded successfully, I am noticing something I had never
seen before in my log files. I have logging turned on and rotated nightly
and deleted monthly.

In my logs now I am having this spammed every second

2009-03-28 19:20:06.617 MSqlQuery::exec() "SELECT data FROM settings WHERE
value = 'WakeUpThreshold' AND hostname = 'niflheim' ;"

2009-03-28 19:20:06.635 MSqlQuery::exec() "SELECT data FROM settings WHERE
value = 'WakeUpThreshold' AND hostname IS NULL;"

2009-03-28 19:20:07.641 MSqlQuery::exec() "SELECT data FROM settings WHERE
value = 'WakeUpThreshold' AND hostname = 'niflheim' ;"

2009-03-28 19:20:07.660 MSqlQuery::exec() "SELECT data FROM settings WHERE
value = 'WakeUpThreshold' AND hostname IS NULL;"

2009-03-28 19:20:08.665 MSqlQuery::exec() "SELECT data FROM settings WHERE
value = 'WakeUpThreshold' AND hostname = 'niflheim' ;"

2009-03-28 19:20:08.680 MSqlQuery::exec() "SELECT data FROM settings WHERE
value = 'WakeUpThreshold' AND hostname IS NULL;"

2009-03-28 19:20:09.685 MSqlQuery::exec() "SELECT data FROM settings WHERE
value = 'WakeUpThreshold' AND hostname = 'niflheim' ;"

2009-03-28 19:20:09.701 MSqlQuery::exec() "SELECT data FROM settings WHERE
value = 'WakeUpThreshold' AND hostname IS NULL;"

-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 4618 bytes
Desc: not available
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20090328/a2a77ec4/attachment.bin>