[mythtv-users] URGENT: No TV shows after 0.21 upgrade :-(

Warpme warpme at o2.pl
Sat Mar 29 09:47:55 UTC 2008


OK,
Here is log from upgrade process done on simulated enviroment:

----------------------------------------------------------
2008-03-29 02:15:19.590 Using runtime prefix = /usr, libdir = /usr/lib
2008-03-29 02:15:19.603 DPMS is disabled.
2008-03-29 02:15:19.604 Unable to read configuration file mysql.txt
2008-03-29 02:15:19.605 Empty LocalHostName.
2008-03-29 02:15:19.605 Using localhost value of R5F27
2008-03-29 02:15:19.763 New DB connection, total: 1
2008-03-29 02:15:19.900 Connected to database 'mythconverg' at host: 
localhost
2008-03-29 02:15:19.930 Closing DB connection named 'DBManager0'
2008-03-29 02:15:19.930 Total desktop dim: 1024x768, with 1 screen[s].
2008-03-29 02:15:19.933 Connected to database 'mythconverg' at host: 
localhost
2008-03-29 02:15:20.016 Using screen 0, 1024x768 at 0,0
2008-03-29 02:15:20.099 New DB connection, total: 2
2008-03-29 02:15:20.101 Connected to database 'mythconverg' at host: 
localhost
2008-03-29 02:15:20.109 Current Schema Version: 1160
2008-03-29 02:15:20.173 DB Error (StorageGroup::StorageGroup()):
Query was:
SELECT DISTINCT dirname FROM storagegroup WHERE groupname = 'DB Backups' 
AND hostname = 'R5F27'
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.storagegroup' doesn't exist

2008-03-29 02:15:20.174 New DB connection, total: 3
2008-03-29 02:15:20.184 Connected to database 'mythconverg' at host: 
localhost
2008-03-29 02:15:20.202 SG(DB Backups) Error: Directory value for 
Default Storage Group is empty.  Using old 'RecordFilePrefix' value of 
'/mnt/store/'
2008-03-29 02:15:20.205 SG(DB Backups) Error: FindNextDirMostFree: 
'/mnt/store/' does not exist!
2008-03-29 02:15:20.206 Backing up database to file: 
/tmp/mythconverg-1160-20080329021520.sql
2008-03-29 02:15:26.526 Compressing database backup file.
2008-03-29 02:15:30.016 Database Backup filename: 
/tmp/mythconverg-1160-20080329021520.sql.gz
2008-03-29 02:15:30.017 Database Backup complete.
2008-03-29 02:15:30.132 Total desktop dim: 1024x768, with 1 screen[s].
2008-03-29 02:15:30.135 Using screen 0, 1024x768 at 0,0
2008-03-29 02:15:30.149 The theme (blootube-wide) is missing a 
themeinfo.xml file
2008-03-29 02:15:30.152 Switching to wide mode (blootube-wide)
2008-03-29 02:15:30.185 Could not find theme: Default - Switching to default
2008-03-29 02:15:31.328 Using the Qt painter
mythtv: could not connect to socket
mythtv: Connection refused
2008-03-29 02:15:31.334 lirc_init failed for mythtv, see preceding messages
2008-03-29 02:15:31.334 JoystickMenuClient Error: Joystick disabled - 
Failed to read /root/.mythtv/joystickmenurc
2008-03-29 02:15:47.925 Newest Schema Version : 1214
2008-03-29 02:15:47.926 Upgrading to schema version 1161
2008-03-29 02:15:48.103 Upgrading to schema version 1162
2008-03-29 02:15:48.107 Upgrading to schema version 1163
2008-03-29 02:15:48.108 New DB connection, total: 4
2008-03-29 02:15:48.110 Connected to database 'mythconverg' at host: 
localhost
2008-03-29 02:15:48.113 Upgrading to schema version 1164
2008-03-29 02:15:48.151 Upgrading to schema version 1165
2008-03-29 02:15:48.423 Upgrading to schema version 1166
2008-03-29 02:15:48.430 Upgrading to schema version 1167
2008-03-29 02:15:48.433 Upgrading to schema version 1168
2008-03-29 02:15:48.436 Upgrading to schema version 1169
2008-03-29 02:15:48.438 Upgrading to schema version 1170
2008-03-29 02:15:48.441 Upgrading to schema version 1171
2008-03-29 02:15:48.538 Upgrading to schema version 1172
2008-03-29 02:15:48.543 Upgrading to schema version 1173
2008-03-29 02:15:48.555 Upgrading to schema version 1174
2008-03-29 02:15:48.558 Upgrading to schema version 1175
2008-03-29 02:15:48.563 Upgrading to schema version 1176
2008-03-29 02:15:48.566 Upgrading to schema version 1177
2008-03-29 02:15:48.577 Upgrading to schema version 1178
2008-03-29 02:15:49.438 Upgrading to schema version 1179
2008-03-29 02:15:50.176 Upgrading to schema version 1180
2008-03-29 02:15:50.182 Upgrading to schema version 1181
2008-03-29 02:15:55.964 Upgrading to schema version 1182
2008-03-29 02:15:55.967 Upgrading to schema version 1183
2008-03-29 02:15:55.974 Upgrading to schema version 1184
2008-03-29 02:15:55.981 Upgrading to schema version 1185
2008-03-29 02:15:55.985 Upgrading to schema version 1186
2008-03-29 02:15:55.990 Upgrading to schema version 1187
2008-03-29 02:15:56.001 Upgrading to schema version 1188
2008-03-29 02:15:56.027 Upgrading to schema version 1189
2008-03-29 02:15:56.043 Upgrading to schema version 1190
2008-03-29 02:15:56.050 Upgrading to schema version 1191
2008-03-29 02:15:56.065 Upgrading to schema version 1192
2008-03-29 02:15:56.079 Upgrading to schema version 1193
2008-03-29 02:15:56.093 Upgrading to schema version 1194
2008-03-29 02:15:56.101 Upgrading to schema version 1195
2008-03-29 02:15:56.105 Upgrading to schema version 1196
2008-03-29 02:15:56.107 Upgrading to schema version 1197
2008-03-29 02:15:56.112 Upgrading to schema version 1198
2008-03-29 02:15:56.116 Upgrading to schema version 1199
2008-03-29 02:15:56.156 Upgrading to schema version 1200
2008-03-29 02:15:56.162 Upgrading to schema version 1201
2008-03-29 02:15:56.166 Upgrading to schema version 1202
2008-03-29 02:15:56.218 Upgrading to schema version 1203
2008-03-29 02:15:56.229 Upgrading to schema version 1204
2008-03-29 02:15:56.264 Upgrading to schema version 1205
2008-03-29 02:15:56.279 Upgrading to schema version 1206
2008-03-29 02:15:56.286 Upgrading to schema version 1207
2008-03-29 02:15:56.307 Upgrading to schema version 1208
2008-03-29 02:15:56.322 Upgrading to schema version 1209
2008-03-29 02:15:56.352 Upgrading to schema version 1210
2008-03-29 02:15:57.285 Upgrading to schema version 1211
2008-03-29 02:15:57.961 Upgrading to schema version 1212
2008-03-29 02:15:57.963 Upgrading to schema version 1213
2008-03-29 02:15:57.970 In 1213 upg
2008-03-29 02:15:57.971 Upgrading to schema version 1214
2008-03-29 02:15:57.972 Database Schema upgrade complete, unlocking.
2008-03-29 02:15:57.974 Total desktop dim: 1024x768, with 1 screen[s].
2008-03-29 02:15:57.977 Using screen 0, 1024x768 at 0,0
2008-03-29 02:15:57.981 The theme (blootube-wide) is missing a 
themeinfo.xml file
2008-03-29 02:15:57.981 Switching to wide mode (blootube-wide)
2008-03-29 02:15:58.102 Using the Qt painter
mythtv: could not connect to socket
mythtv: Connection refused
2008-03-29 02:15:58.265 lirc_init failed for mythtv, see preceding messages
2008-03-29 02:15:58.266 JoystickMenuClient Error: Joystick disabled - 
Failed to read /root/.mythtv/joystickmenurc
2008-03-29 02:16:30.801 Loading from: 
/usr/share/mythtv/themes/blootube-wide/base.xml
2008-03-29 02:16:30.938 Loading from: 
/usr/share/mythtv/themes/default/base.xml
2008-03-29 02:16:31.000 MythThemedMenuPrivate: Unknown tag image in 
background
---------------------------------------------------------

Table recorded hasn't column "watched" - so issue is reproductable in my 
enviroment

Schema versions before upgrade:

+----------------------------------------------------+--------------------------------------+
| value                                              | 
data                                 |
+----------------------------------------------------+--------------------------------------+
| DBSchemaVer                                        | 
1160                                 |
| GalleryDBSchemaVer                                 | 
1000                                 |
| GameDBSchemaVer                                    | 
1012                                 |
| MusicDBSchemaVer                                   | 
1006                                 |
| PhoneDBSchemaVer                                   | 
1001                                 |
| mythvideo.DBSchemaVer                              | 1010 
                                |
| ArchiveDBSchemaVer                                 | 1000  
                              |
| upnp:UDN:urn:schemas-upnp-org:device:MediaServer:1 | 
f5b2089c-907f-491f-abe2-c862ff2afe82 |
| WebDBSchemaVer                                     | 
2                                    |
+----------------------------------------------------+--------------------------------------+
11 rows in set (0.04 sec)

Schema versions after upgrade

+----------------------------------------------------+--------------------------------------+
| value                                              | 
data                                 |
+----------------------------------------------------+--------------------------------------+
| DBSchemaVer                                        | 
1214                                 |
| GalleryDBSchemaVer                                 | 
1000                                 |
| GameDBSchemaVer                                    | 
1012                                 |
| MusicDBSchemaVer                                   | 
1013                                 |
| PhoneDBSchemaVer                                   | 
1001                                 |
| mythvideo.DBSchemaVer                              | 
1016                                 |
| ArchiveDBSchemaVer                                 | 
1001                                 |
| upnp:UDN:urn:schemas-upnp-org:device:MediaServer:1 | 
f5b2089c-907f-491f-abe2-c862ff2afe82 |
| WebDBSchemaVer                                     | 
2                                    |
| FlixDBSchemaVer                                    | 
1001                                 |
| WeatherDBSchemaVer                                 | 
1000                                 |
+----------------------------------------------------+--------------------------------------+
11 rows in set (0.04 sec)


-------------- next part --------------
A non-text attachment was scrubbed...
Name: warpme.vcf
Type: text/x-vcard
Size: 83 bytes
Desc: not available
Url : http://mythtv.org/pipermail/mythtv-users/attachments/20080329/bed1f6d5/attachment.vcf 


More information about the mythtv-users mailing list