Ticket #2180: schema_upgrade.txt

File schema_upgrade.txt, 8.0 KB (added by stuart@…, 18 years ago)

Uncompressed version of the posted log

Line 
1[root@localhost mythtv]# mythbackend
22006-08-15 17:10:01.284 Using runtime prefix = /usr
32006-08-15 17:10:01.410 New DB connection, total: 1
42006-08-15 17:10:01.436 Connected to database 'mythconverg' at host: localhost
52006-08-15 17:10:01.461 Current Schema Version: 1123
62006-08-15 17:10:01.484 Newest Schema Version : 1155
72006-08-15 17:10:01.485 New DB connection, total: 2
82006-08-15 17:10:01.486 Connected to database 'mythconverg' at host: localhost
92006-08-15 17:10:01.487 Setting Lock for Database Schema upgrade. If you see a long pause here it means the Schema is already locked and is being upgraded by another Myth process.
102006-08-15 17:10:01.489 New DB connection, total: 3
112006-08-15 17:10:01.489 Connected to database 'mythconverg' at host: localhost
122006-08-15 17:10:01.491 Upgrading to schema version 1124
132006-08-15 17:10:01.582 New DB connection, total: 4
142006-08-15 17:10:01.583 Connected to database 'mythconverg' at host: localhost
152006-08-15 17:10:01.601 Upgrading to schema version 1125
162006-08-15 17:10:01.632 Upgrading to schema version 1126
172006-08-15 17:10:01.660 Upgrading to schema version 1127
182006-08-15 17:10:01.684 Upgrading to schema version 1128
192006-08-15 17:10:01.719 Upgrading to schema version 1129
202006-08-15 17:10:01.761 New DB connection, total: 5
212006-08-15 17:10:01.762 Connected to database 'mythconverg' at host: localhost
222006-08-15 17:10:01.764 Upgrading to schema version 1130
232006-08-15 17:10:01.774 Upgrading to schema version 1131
242006-08-15 17:10:01.791 Upgrading to schema version 1132
252006-08-15 17:10:01.808 Upgrading to schema version 1133
262006-08-15 17:10:01.828 Upgrading to schema version 1134
272006-08-15 17:10:01.830 Upgrading to schema version 1135
282006-08-15 17:10:01.888 Upgrading to schema version 1136
292006-08-15 17:10:06.395 Upgrading to schema version 1137
302006-08-15 17:10:06.643 Upgrading to schema version 1138
312006-08-15 17:10:06.645 Upgrading to schema version 1139
322006-08-15 17:10:06.707 Upgrading to schema version 1140
332006-08-15 17:10:06.709 Upgrading to schema version 1141
342006-08-15 17:10:06.813 Upgrading to schema version 1142
352006-08-15 17:10:06.814 DB Error (Performing database upgrade):
36Query was: CREATE TABLE customexample (  rulename VARCHAR(64) NOT NULL PRIMARY KEY,   fromclause text NOT NULL DEFAULT '',  whereclause text NOT NULL DEFAULT '');
37Error was: Driver error was [2/1050]:
38QMYSQL3: Unable to execute query
39Database error was:
40Table 'customexample' already exists
41 
42new version: 1142
432006-08-15 17:10:06.814 Database Schema upgrade failed, unlocking.
442006-08-15 17:10:06.815 Couldn't upgrade database to new schema
45[root@localhost mythtv]# mythbackend
462006-08-15 17:10:30.566 Using runtime prefix = /usr
472006-08-15 17:10:30.601 New DB connection, total: 1
482006-08-15 17:10:30.610 Connected to database 'mythconverg' at host: localhost
492006-08-15 17:10:30.615 Current Schema Version: 1141
502006-08-15 17:10:30.616 Newest Schema Version : 1155
512006-08-15 17:10:30.617 New DB connection, total: 2
522006-08-15 17:10:30.618 Connected to database 'mythconverg' at host: localhost
532006-08-15 17:10:30.619 Setting Lock for Database Schema upgrade. If you see a long pause here it means the Schema is already locked and is being upgraded by another Myth process.
542006-08-15 17:10:30.620 New DB connection, total: 3
552006-08-15 17:10:30.621 Connected to database 'mythconverg' at host: localhost
562006-08-15 17:10:30.623 Upgrading to schema version 1142
572006-08-15 17:10:30.624 DB Error (Performing database upgrade):
58Query was: CREATE TABLE customexample (  rulename VARCHAR(64) NOT NULL PRIMARY KEY,   fromclause text NOT NULL DEFAULT '',  whereclause text NOT NULL DEFAULT '');
59Error was: Driver error was [2/1050]:
60QMYSQL3: Unable to execute query
61Database error was:
62Table 'customexample' already exists
63 
64new version: 1142
652006-08-15 17:10:30.625 Database Schema upgrade failed, unlocking.
662006-08-15 17:10:30.625 Couldn't upgrade database to new schema
67
68[root@localhost mythtv]# mysql -p mythconverg                                   
69Enter password:
70Reading table information for completion of table and column names
71You can turn off this feature to get a quicker startup with -A
72
73Welcome to the MySQL monitor.  Commands end with ; or \g.
74Your MySQL connection id is 43 to server version: 4.1.20
75
76Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
77
78mysql> drop table customexample;
79Query OK, 0 rows affected (0.01 sec)
80
81mysql> quit
82Bye
83[root@localhost mythtv]# mythbackend                                     
842006-08-15 17:11:26.037 Using runtime prefix = /usr
852006-08-15 17:11:26.073 New DB connection, total: 1
862006-08-15 17:11:26.081 Connected to database 'mythconverg' at host: localhost
872006-08-15 17:11:26.087 Current Schema Version: 1141
882006-08-15 17:11:26.088 Newest Schema Version : 1155
892006-08-15 17:11:26.089 New DB connection, total: 2
902006-08-15 17:11:26.090 Connected to database 'mythconverg' at host: localhost
912006-08-15 17:11:26.091 Setting Lock for Database Schema upgrade. If you see a long pause here it means the Schema is already locked and is being upgraded by another Myth process.
922006-08-15 17:11:26.092 New DB connection, total: 3
932006-08-15 17:11:26.093 Connected to database 'mythconverg' at host: localhost
942006-08-15 17:11:26.095 Upgrading to schema version 1142
952006-08-15 17:11:26.134 New DB connection, total: 4
962006-08-15 17:11:26.135 Connected to database 'mythconverg' at host: localhost
972006-08-15 17:11:26.137 Upgrading to schema version 1143
982006-08-15 17:11:26.168 Upgrading to schema version 1144
992006-08-15 17:11:26.180 Upgrading to schema version 1145
1002006-08-15 17:11:26.191 Upgrading to schema version 1146
1012006-08-15 17:11:26.196 Upgrading to schema version 1147
1022006-08-15 17:11:34.780 Upgrading to schema version 1148
1032006-08-15 17:11:34.952 Upgrading to schema version 1149
1042006-08-15 17:11:35.023 Upgrading to schema version 1150
1052006-08-15 17:11:35.038 Upgrading to schema version 1151
1062006-08-15 17:11:35.096 Upgrading to schema version 1152
1072006-08-15 17:11:36.316 Upgrading to schema version 1153
1082006-08-15 17:11:40.010 DB Error (Performing database upgrade):
109Query was: INSERT INTO recordedseek (chanid, starttime, mark, offset, type) SELECT chanid, starttime, mark, offset, type FROM recordedmarkup WHERE type in (6, 7, 9);
110Error was: Driver error was [2/1062]:
111QMYSQL3: Unable to execute query
112Database error was:
113Duplicate entry '1151-2006-08-05 08:30:00-6-1830' for key 1
114 
115new version: 1153
1162006-08-15 17:11:40.010 Database Schema upgrade failed, unlocking.
1172006-08-15 17:11:40.011 Couldn't upgrade database to new schema
118
119[root@localhost mythtv]# mythbackend                                 
1202006-08-15 17:14:53.217 Using runtime prefix = /usr
1212006-08-15 17:14:53.363 New DB connection, total: 1
1222006-08-15 17:14:53.388 Connected to database 'mythconverg' at host: localhost
1232006-08-15 17:14:53.418 Current Schema Version: 1152
1242006-08-15 17:14:53.425 Newest Schema Version : 1155
1252006-08-15 17:14:53.426 New DB connection, total: 2
1262006-08-15 17:14:53.427 Connected to database 'mythconverg' at host: localhost
1272006-08-15 17:14:53.428 Setting Lock for Database Schema upgrade. If you see a long pause here it means the Schema is already locked and is being upgraded by another Myth process.
1282006-08-15 17:14:53.437 New DB connection, total: 3
1292006-08-15 17:14:53.438 Connected to database 'mythconverg' at host: localhost
1302006-08-15 17:14:53.441 Upgrading to schema version 1153
1312006-08-15 17:14:56.618 DB Error (Performing database upgrade):
132Query was: INSERT INTO recordedseek (chanid, starttime, mark, offset, type) SELECT chanid, starttime, mark, offset, type FROM recordedmarkup WHERE type in (6, 7, 9);
133Error was: Driver error was [2/1062]:
134QMYSQL3: Unable to execute query
135Database error was:
136Duplicate entry '1168-2006-08-09 00:00:00-6-4538' for key 1
137 
138new version: 1153
1392006-08-15 17:14:56.618 Database Schema upgrade failed, unlocking.
1402006-08-15 17:14:56.619 Couldn't upgrade database to new schema
141[root@localhost mythtv]#