Hi all.
I'm attempting to upgrade R5F27 to R5.5 and am not achieving any success. cesman has been a big help in working with me so far in IRC but I still get errors during the auto upgrade.
My setup is a standalone box with two PVR-150 tuners, single 500gb hard drive, and snapstream remote. I've run and rerun the auto upgrade several times now and it seems to do the same thing. I have tried burning new cd media and even used the media verifier during the install.
Currently I am downloading the R6 iso but was wondering if we can save R5.5 while that is happening.
Thoughts? Thanks.
Code:
2009-07-09 09:00:03.707 Using runtime prefix = /usr
2009-07-09 09:00:03.774 Empty LocalHostName.
2009-07-09 09:00:03.775 Using localhost value of htpc
2009-07-09 09:00:03.828 New DB connection, total: 1
2009-07-09 09:00:03.834 Connected to database 'mythconverg' at host: localhost
2009-07-09 09:00:03.835 Closing DB connection named 'DBManager0'
2009-07-09 09:00:03.836 Connected to database 'mythconverg' at host: localhost
2009-07-09 09:00:03.860 New DB connection, total: 2
2009-07-09 09:00:03.861 Connected to database 'mythconverg' at host: localhost
2009-07-09 09:00:03.863 Current Schema Version:
2009-07-09 09:00:03.864 DataDirectProcessor::FixProgramIDs() -- begin
2009-07-09 09:00:03.865 New DB DataDirect connection
2009-07-09 09:00:03.866 Connected to database 'mythconverg' at host: localhost
2009-07-09 09:00:03.867 DB Error (Fixing program ids in recorded):
Query was:
UPDATE recorded SET programid=CONCAT(SUBSTRING(programid, 1, 2), '00', SUBSTRING(programid, 3)) WHERE length(programid) = 12
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.recorded' doesn't exist
2009-07-09 09:00:03.868 DB Error (Clear setting):
Query was:
DELETE FROM settings WHERE value = 'BackupDBLastRunStart' AND hostname is NULL;
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.settings' doesn't exist
2009-07-09 09:00:03.869 DB Error (SaveSettingOnHost query failure: ):
Query was:
INSERT INTO settings (value,data,hostname ) VALUES ( 'BackupDBLastRunStart', '2009-07-09 09:00:03', NULL );
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.settings' doesn't exist
2009-07-09 09:00:03.870 DB Error (StorageGroup::StorageGroup()):
Query was:
SELECT DISTINCT dirname FROM storagegroup WHERE groupname = 'DB Backups' AND hostname = 'htpc'
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.storagegroup' doesn't exist
2009-07-09 09:00:03.871 New DB connection, total: 3
2009-07-09 09:00:03.872 Connected to database 'mythconverg' at host: localhost
2009-07-09 09:00:03.873 SG(DB Backups) Error: Directory value for Default Storage Group is empty. Using hardcoded default value of '/mnt/store'
2009-07-09 09:00:03.895 SG(DB Backups) Error: FindNextDirMostFree: '/mnt/store' does not exist!
2009-07-09 09:00:04.006 Database Backup filename: /tmp/mythconverg--20090709090003.sql.gz
2009-07-09 09:00:04.034 Database Backup complete.
2009-07-09 09:00:04.043 DB Error (Clear setting):
Query was:
DELETE FROM settings WHERE value = 'BackupDBLastRunEnd' AND hostname is NULL;
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.settings' doesn't exist
2009-07-09 09:00:04.046 DB Error (SaveSettingOnHost query failure: ):
Query was:
INSERT INTO settings (value,data,hostname ) VALUES ( 'BackupDBLastRunEnd', '2009-07-09 09:00:04', NULL );
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.settings' doesn't exist
2009-07-09 09:00:04.058 No current database version. Auto upgrading
2009-07-09 09:00:04.059 Newest Schema Version : 1214
2009-07-09 09:00:04.068 Inserting MythTV initial database information.
2009-07-09 09:00:04.080 Upgrading to schema version 1112
2009-07-09 09:00:04.318 New DB connection, total: 4
2009-07-09 09:00:04.337 Connected to database 'mythconverg' at host: localhost
2009-07-09 09:00:04.344 Upgrading to schema version 1113
2009-07-09 09:00:04.351 Upgrading to schema version 1114
2009-07-09 09:00:04.353 Upgrading to schema version 1115
2009-07-09 09:00:04.357 Upgrading to schema version 1116
2009-07-09 09:00:04.359 Upgrading to schema version 1117
2009-07-09 09:00:04.364 Upgrading to schema version 1118
2009-07-09 09:00:04.379 Upgrading to schema version 1119
2009-07-09 09:00:04.382 Upgrading to schema version 1120
2009-07-09 09:00:04.385 Upgrading to schema version 1121
2009-07-09 09:00:04.388 Upgrading to schema version 1122
2009-07-09 09:00:04.392 Upgrading to schema version 1123
2009-07-09 09:00:04.399 Upgrading to schema version 1124
2009-07-09 09:00:04.403 Upgrading to schema version 1125
2009-07-09 09:00:04.409 Upgrading to schema version 1126
2009-07-09 09:00:04.414 Upgrading to schema version 1127
2009-07-09 09:00:04.421 Upgrading to schema version 1128
2009-07-09 09:00:04.427 Upgrading to schema version 1129
2009-07-09 09:00:04.435 Upgrading to schema version 1130
2009-07-09 09:00:04.437 Upgrading to schema version 1131
2009-07-09 09:00:04.441 Upgrading to schema version 1132
2009-07-09 09:00:04.446 Upgrading to schema version 1133
2009-07-09 09:00:04.450 Upgrading to schema version 1134
2009-07-09 09:00:04.453 Upgrading to schema version 1135
2009-07-09 09:00:04.459 Upgrading to schema version 1136
2009-07-09 09:00:04.463 Upgrading to schema version 1137
2009-07-09 09:00:04.468 Upgrading to schema version 1138
2009-07-09 09:00:04.471 Upgrading to schema version 1139
2009-07-09 09:00:04.482 Upgrading to schema version 1140
2009-07-09 09:00:04.484 Upgrading to schema version 1141
2009-07-09 09:00:04.490 Upgrading to schema version 1142
2009-07-09 09:00:04.494 Upgrading to schema version 1143
2009-07-09 09:00:04.498 Upgrading to schema version 1144
2009-07-09 09:00:04.510 Upgrading to schema version 1145
2009-07-09 09:00:04.531 Upgrading to schema version 1146
2009-07-09 09:00:04.533 Upgrading to schema version 1147
2009-07-09 09:00:04.540 Upgrading to schema version 1148
2009-07-09 09:00:04.547 Upgrading to schema version 1149
2009-07-09 09:00:04.559 Upgrading to schema version 1150
2009-07-09 09:00:04.562 Upgrading to schema version 1151
2009-07-09 09:00:04.568 Upgrading to schema version 1152
2009-07-09 09:00:04.656 Upgrading to schema version 1153
2009-07-09 09:00:04.698 Upgrading to schema version 1154
2009-07-09 09:00:04.707 Upgrading to schema version 1155
2009-07-09 09:00:04.717 Upgrading to schema version 1156
2009-07-09 09:00:04.724 Upgrading to schema version 1157
2009-07-09 09:00:04.727 Upgrading to schema version 1158
2009-07-09 09:00:04.738 Upgrading to schema version 1159
2009-07-09 09:00:04.744 Upgrading to schema version 1160
2009-07-09 09:00:04.746 Upgrading to schema version 1161
2009-07-09 09:00:04.749 Upgrading to schema version 1162
2009-07-09 09:00:04.752 Upgrading to schema version 1163
2009-07-09 09:00:04.753 Upgrading to schema version 1164
2009-07-09 09:00:04.768 Upgrading to schema version 1165
2009-07-09 09:00:04.774 Upgrading to schema version 1166
2009-07-09 09:00:04.781 Upgrading to schema version 1167
2009-07-09 09:00:04.783 Upgrading to schema version 1168
2009-07-09 09:00:04.787 Upgrading to schema version 1169
2009-07-09 09:00:04.789 Upgrading to schema version 1170
2009-07-09 09:00:04.790 Upgrading to schema version 1171
2009-07-09 09:00:04.802 Upgrading to schema version 1172
2009-07-09 09:00:04.804 Upgrading to schema version 1173
2009-07-09 09:00:04.808 Upgrading to schema version 1174
2009-07-09 09:00:04.811 Upgrading to schema version 1175
2009-07-09 09:00:04.813 Upgrading to schema version 1176
2009-07-09 09:00:04.814 Upgrading to schema version 1177
2009-07-09 09:00:04.817 Upgrading to schema version 1178
2009-07-09 09:00:04.854 Upgrading to schema version 1179
2009-07-09 09:00:04.883 Upgrading to schema version 1180
2009-07-09 09:00:04.889 Upgrading to schema version 1181
2009-07-09 09:00:04.895 Upgrading to schema version 1182
2009-07-09 09:00:04.897 Upgrading to schema version 1183
2009-07-09 09:00:04.902 Upgrading to schema version 1184
2009-07-09 09:00:04.907 Upgrading to schema version 1185
2009-07-09 09:00:04.911 Upgrading to schema version 1186
2009-07-09 09:00:04.914 Upgrading to schema version 1187
2009-07-09 09:00:04.920 Upgrading to schema version 1188
2009-07-09 09:00:04.943 Upgrading to schema version 1189
2009-07-09 09:00:04.958 Upgrading to schema version 1190
2009-07-09 09:00:04.961 Upgrading to schema version 1191
2009-07-09 09:00:04.965 Upgrading to schema version 1192
2009-07-09 09:00:04.971 Upgrading to schema version 1193
2009-07-09 09:00:04.976 Upgrading to schema version 1194
2009-07-09 09:00:05.076 Upgrading to schema version 1195
2009-07-09 09:00:05.082 Upgrading to schema version 1196
2009-07-09 09:00:05.100 Upgrading to schema version 1197
2009-07-09 09:00:05.104 Upgrading to schema version 1198
2009-07-09 09:00:05.105 Upgrading to schema version 1199
2009-07-09 09:00:05.106 Upgrading to schema version 1200
2009-07-09 09:00:05.108 Upgrading to schema version 1201
2009-07-09 09:00:05.110 Upgrading to schema version 1202
2009-07-09 09:00:05.152 Upgrading to schema version 1203
2009-07-09 09:00:05.156 Upgrading to schema version 1204
2009-07-09 09:00:05.159 Upgrading to schema version 1205
2009-07-09 09:00:05.180 Upgrading to schema version 1206
2009-07-09 09:00:05.196 Upgrading to schema version 1207
2009-07-09 09:00:05.233 Upgrading to schema version 1208
2009-07-09 09:00:05.245 Upgrading to schema version 1209
2009-07-09 09:00:05.249 Upgrading to schema version 1210
2009-07-09 09:00:05.268 Upgrading to schema version 1211
2009-07-09 09:00:05.286 Upgrading to schema version 1212
2009-07-09 09:00:05.289 Upgrading to schema version 1213
2009-07-09 09:00:05.291 In 1213 upg
2009-07-09 09:00:05.293 Upgrading to schema version 1214
2009-07-09 09:00:05.293 Database Schema upgrade complete, unlocking.
No setting found for this machine's BackendServerIP.
Please run setup on this machine and modify the first page
of the general settings.
2009-07-09 09:43:38.371 Using runtime prefix = /usr
2009-07-09 09:43:38.396 Empty LocalHostName.
2009-07-09 09:43:38.402 Using localhost value of htpc
2009-07-09 09:43:38.446 New DB connection, total: 1
2009-07-09 09:43:38.457 Unable to connect to database!
2009-07-09 09:43:38.464 Driver error was [1/2002]:
QMYSQL3: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2009-07-09 09:43:38.819 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError? Strange...
2009-07-09 09:44:43.674 Using runtime prefix = /usr
2009-07-09 09:44:43.728 Empty LocalHostName.
2009-07-09 09:44:43.740 Using localhost value of htpc
2009-07-09 09:44:43.827 New DB connection, total: 1
2009-07-09 09:44:43.835 Connected to database 'mythconverg' at host: localhost
2009-07-09 09:44:43.837 Closing DB connection named 'DBManager0'
2009-07-09 09:44:43.838 Connected to database 'mythconverg' at host: localhost
2009-07-09 09:44:43.859 New DB connection, total: 2
2009-07-09 09:44:43.860 Connected to database 'mythconverg' at host: localhost
2009-07-09 09:44:43.874 Current Schema Version: 1214
2009-07-09 09:44:43.875 DataDirectProcessor::FixProgramIDs() -- begin
2009-07-09 09:44:43.876 New DB DataDirect connection
2009-07-09 09:44:43.877 Connected to database 'mythconverg' at host: localhost
2009-07-09 09:44:43.878 DataDirectProcessor::FixProgramIDs() -- end
No setting found for this machine's BackendServerIP.
Please run setup on this machine and modify the first page
of the general settings.
2009-07-09 10:01:07.274 Using runtime prefix = /usr
2009-07-09 10:01:07.293 Empty LocalHostName.
2009-07-09 10:01:07.294 Using localhost value of htpc
2009-07-09 10:01:07.336 New DB connection, total: 1
2009-07-09 10:01:07.345 Unable to connect to database!
2009-07-09 10:01:07.347 Driver error was [1/2013]:
QMYSQL3: Unable to connect
Database error was:
Lost connection to MySQL server at 'sending password information', system error: 32
QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2009-07-09 10:01:07.399 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError? Strange...
................................................................................
2009-07-09 10:01:09.900 UPnPautoconf() - No UPnP backends found
2009-07-09 10:01:09.901 No UPnP backends found
No UPnP backends found
Would you like to configure the database connection now? [yes]
[console is not interactive, using default 'yes']
Database host name: [localhost]
[console is not interactive, using default 'localhost']
Should I test connectivity to this host using the ping command? [yes]
[console is not interactive, using default 'yes']
Database non-default port: [0]
[console is not interactive, using default '0']
Database name: [mythconverg]
[console is not interactive, using default 'mythconverg']
Database user name: [mythtv]
[console is not interactive, using default 'mythtv']
Database password: [mythtv]
[console is not interactive, using default 'mythtv']
Unique identifier for this machine (if empty, the local host name will be used):
[console is not interactive, using default '']
Would you like to use Wake-On-LAN to retry database connections? [no]
[console is not interactive, using default 'no']
2009-07-09 10:01:09.909 Writing settings file /home/mythtv/.mythtv/mysql.txt
2009-07-09 10:01:09.910 Closing DB connection named 'DBManager0'
2009-07-09 10:01:09.911 Unable to connect to database!
2009-07-09 10:01:09.911 Driver error was [1/2002]:
QMYSQL3: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2009-07-09 10:01:09.962 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError? Strange...
2009-07-09 10:01:10.013 Cannot login to database?
2009-07-09 10:01:10.013 Cannot login to database?
Cannot login to database?
Would you like to configure the database connection now? [yes]
[console is not interactive, using default 'yes']
Database host name: [localhost]
[console is not interactive, using default 'localhost']
Should I test connectivity to this host using the ping command? [yes]
[console is not interactive, using default 'yes']
Database non-default port: [0]
[console is not interactive, using default '0']
Database name: [mythconverg]
[console is not interactive, using default 'mythconverg']
Database user name: [mythtv]
[console is not interactive, using default 'mythtv']
Database password: [mythtv]
[console is not interactive, using default 'mythtv']
Unique identifier for this machine (if empty, the local host name will be used):
[console is not interactive, using default '']
Would you like to use Wake-On-LAN to retry database connections? [no]
[console is not interactive, using default 'no']
2009-07-09 10:01:10.021 Unable to connect to database!
2009-07-09 10:01:10.021 Driver error was [1/2002]:
QMYSQL3: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2009-07-09 10:01:10.073 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError? Strange...
2009-07-09 10:01:10.123 Cannot login to database?
2009-07-09 10:01:10.124 Cannot login to database?
Cannot login to database?
Would you like to configure the database connection now? [yes]
[console is not interactive, using default 'yes']
Database host name: [localhost]
[console is not interactive, using default 'localhost']
Should I test connectivity to this host using the ping command? [yes]
[console is not interactive, using default 'yes']
Database non-default port: [0]
[console is not interactive, using default '0']
Database name: [mythconverg]
[console is not interactive, using default 'mythconverg']
Database user name: [mythtv]
[console is not interactive, using default 'mythtv']
Database password: [mythtv]
[console is not interactive, using default 'mythtv']
Unique identifier for this machine (if empty, the local host name will be used):
[console is not interactive, using default '']
Would you like to use Wake-On-LAN to retry database connections? [no]
[console is not interactive, using default 'no']
2009-07-09 10:01:10.132 Unable to connect to database!
2009-07-09 10:01:10.132 Driver error was [1/2002]:
QMYSQL3: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2009-07-09 10:01:10.183 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError? Strange...
2009-07-09 10:01:10.234 Cannot login to database?
2009-07-09 10:01:10.234 Cannot login to database?
Cannot login to database?
Would you like to configure the database connection now? [yes]
[console is not interactive, using default 'yes']
Database host name: [localhost]
[console is not interactive, using default 'localhost']
Should I test connectivity to this host using the ping command? [yes]
[console is not interactive, using default 'yes']
Database non-default port: [0]
[console is not interactive, using default '0']
Database name: [mythconverg]
[console is not interactive, using default 'mythconverg']
Database user name: [mythtv]
[console is not interactive, using default 'mythtv']
Database password: [mythtv]
[console is not interactive, using default 'mythtv']
Unique identifier for this machine (if empty, the local host name will be used):
[console is not interactive, using default '']
Would you like to use Wake-On-LAN to retry database connections? [no]
[console is not interactive, using default 'no']
2009-07-09 10:01:10.242 Unable to connect to database!
2009-07-09 10:01:10.243 Driver error was [1/2002]:
QMYSQL3: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2009-07-09 10:01:10.295 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError? Strange...
2009-07-09 10:01:10.345 Cannot login to database?
2009-07-09 10:01:10.346 Cannot login to database?
Cannot login to database?
Would you like to configure the database connection now? [yes]
[console is not interactive, using default 'yes']
Database host name: [localhost]
[console is not interactive, using default 'localhost']
Should I test connectivity to this host using the ping command? [yes]
[console is not interactive, using default 'yes']
Database non-default port: [0]
[console is not interactive, using default '0']
Database name: [mythconverg]
[console is not interactive, using default 'mythconverg']
Database user name: [mythtv]
[console is not interactive, using default 'mythtv']
Database password: [mythtv]
[console is not interactive, using default 'mythtv']
Unique identifier for this machine (if empty, the local host name will be used):
[console is not interactive, using default '']
Would you like to use Wake-On-LAN to retry database connections? [no]
[console is not interactive, using default 'no']
2009-07-09 10:01:10.354 Unable to connect to database!
2009-07-09 10:01:10.354 Driver error was [1/2002]:
QMYSQL3: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2009-07-09 10:01:10.405 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError? Strange...
2009-07-09 10:01:10.456 Cannot login to database?
2009-07-09 10:01:10.457 Cannot login to database?
Cannot login to database?
Would you like to configure the database connection now? [yes]
[console is not interactive, using default 'yes']
Database host name: [localhost]
[console is not interactive, using default 'localhost']
Should I test connectivity to this host using the ping command? [yes]
[console is not interactive, using default 'yes']
Database non-default port: [0]
[console is not interactive, using default '0']
Database name: [mythconverg]
[console is not interactive, using default 'mythconverg']
Database user name: [mythtv]
[console is not interactive, using default 'mythtv']
Database password: [mythtv]
[console is not interactive, using default 'mythtv']
Unique identifier for this machine (if empty, the local host name will be used):
[console is not interactive, using default '']
Would you like to use Wake-On-LAN to retry database connections? [no]
[console is not interactive, using default 'no']
2009-07-09 10:01:10.475 Unable to connect to database!
2009-07-09 10:01:10.476 Driver error was [1/2002]:
QMYSQL3: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
[/code]