View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 15 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
PostPosted: Fri Sep 07, 2012 2:50 pm 
Offline
Joined: Mon May 29, 2006 4:58 pm
Posts: 58
I did an upgrade from 6.04 to 7.4 with the .iso. When it reboots and starts the database upgrade it just creates backup databases in /tmp untill the disk is full. I can reboot and delete the backups and it just fills it up again. How do I fix it?
Edit: Log for each database backup ends with "Couldn't upgrade database to new schema"
My current schema is 1276 and it's attempting to upgrade to 1299. 1276 is a newer version than what I had so I guess it goes through several stages in upgrading and 1276 is where it fails.

_________________
R7.4 Master Backend/Frontend 1 Ceton InfiniTV 4 AMD x4 9850/4GB/nVidia210 60GB SSD 5x2TB RAID5
Slave Backend/Frontend 1 Ceton InfiniTV 4 AMD 1050x6/4GB/NVidia 9500 40GB SSD 2x500GB SATA Maxtor
(Can't get 2nd Ceton tuner to work)


Top
 Profile  
 
PostPosted: Fri Sep 07, 2012 6:02 pm 
Offline
Joined: Tue Aug 15, 2006 11:14 am
Posts: 1293
Location: Orlando FL
use gparted on a ubuntu cd to increase your partition size.

_________________
My System


Top
 Profile  
 
PostPosted: Fri Sep 07, 2012 6:14 pm 
Offline
Joined: Mon Dec 24, 2007 9:47 am
Posts: 535
Location: Ottawa, Canada
I think we need a little more log information to know why it is failing.

It could be something like this though your schema version is more recent.
viewtopic.php?f=22&t=22430&p=134240&hilit=database+upgrade#p134240

If the schema failed for some reason then the version and schema might be out of sync but the logs will tell you where exactly it is getting stuck.

If this is the issue then you will need to look in the mythtv schema upgrade code to see what tables not be deleted or version number incremented depending on the exact issue.


Top
 Profile  
 
PostPosted: Fri Sep 07, 2012 10:17 pm 
Offline
Joined: Mon May 29, 2006 4:58 pm
Posts: 58
The mythbackend log has a bunch of thread_unknown then later on it has "MythTV database schema is old. Waiting to see if DB is being upgraded." Then several compare lines where the DBSchemaVer is 1276, then a CompareAndWait Timed out waiting.
Several FindNextDirMostFree lines that complain about my storage directories not being present. (they aren't)
CreateTemporaryDBConf DBUtil Error closing '/tmp/mythtv_db_backup_conf_j6qXlK' No space left on device
I'm assuming this is because of all the db backups it constantly runs.
Read from stdin failed shows up 2 times and then Couldn't upgrade database to new schema
No reason listed for this last error.
???
I didn't see anything helpful like that post you sent me to.
Thanks!

_________________
R7.4 Master Backend/Frontend 1 Ceton InfiniTV 4 AMD x4 9850/4GB/nVidia210 60GB SSD 5x2TB RAID5
Slave Backend/Frontend 1 Ceton InfiniTV 4 AMD 1050x6/4GB/NVidia 9500 40GB SSD 2x500GB SATA Maxtor
(Can't get 2nd Ceton tuner to work)


Top
 Profile  
 
PostPosted: Sat Sep 08, 2012 7:30 am 
Offline
Joined: Mon Dec 24, 2007 9:47 am
Posts: 535
Location: Ottawa, Canada
Here is another link I found when I googled some of your errors.
http://www.mythtv.org/pipermail/mythtv- ... 31349.html

I also noted someone else who failed at the same schema version and the link indicated that 1276 to 1277 is not at a release boundary so it failed on a specific table. Again depending on how you got here if you think the db should be correct you may just need to delete the offending table that is causing the problem. You will need to check the upgrade code to see what it does for schema version 1277 and the logs likely tell you what table is failing.
http://www.mentby.com/Group/mythtv-user ... o-025.html

It might be something like these too but without seeing the log, I'm shooting in the dark.

Can you not put the relevant sections of the log into your post? Just use the "Code" construct so it will be legible.

In any event, so far this look like a pure mythtv issue so you may get better and faster responses by posting to the mythtv users list.

Hopefully you have db backup.


Top
 Profile  
 
PostPosted: Sat Sep 08, 2012 10:29 am 
Offline
Joined: Mon May 29, 2006 4:58 pm
Posts: 58
Here's a log. Hopefully you will see something I didn't. Thanks again!
Code:
2012-09-07T18:42:20.081845-05:00 Greed mythbackend[2421]: C thread_unknown mythcommandlineparser.cpp:2534 (ConfigureLogging) mythbackend version: fixes/0.25 [v0.25.2-9-ga72e341] www.mythtv.org
2012-09-07T18:42:20.081864-05:00 Greed mythbackend[2421]: C thread_unknown mythcommandlineparser.cpp:2536 (ConfigureLogging) Qt version: compile: 4.7.3, runtime: 4.7.3
2012-09-07T18:42:20.081879-05:00 Greed mythbackend[2421]: N thread_unknown mythcommandlineparser.cpp:2538 (ConfigureLogging) Enabled verbose msgs:  general
2012-09-07T18:42:20.081884-05:00 Greed mythbackend[2421]: N thread_unknown logging.cpp:1176 (logStart) Setting Log Level to LOG_INFO
2012-09-07T18:42:20.081888-05:00 Greed mythbackend[2421]: I thread_unknown logging.cpp:229 (FileLogger) Added logging to the console
2012-09-07T18:42:20.081892-05:00 Greed mythbackend[2421]: I thread_unknown logging.cpp:369 (SyslogLogger) Added syslogging to facility local6
2012-09-07T18:42:20.081896-05:00 Greed mythbackend[2421]: I thread_unknown logging.cpp:425 (DatabaseLogger) Added database logging to table logging
2012-09-07T18:42:20.081900-05:00 Greed mythbackend[2421]: N thread_unknown logging.cpp:1215 (logStart) Setting up SIGHUP handler
2012-09-07T18:42:20.081904-05:00 Greed mythbackend[2421]: N thread_unknown mythdirs.cpp:51 (InitializeMythDirs) Using runtime prefix = /usr
2012-09-07T18:42:20.081909-05:00 Greed mythbackend[2421]: N thread_unknown mythdirs.cpp:64 (InitializeMythDirs) Using configuration directory = /home/mythtv/.mythtv
2012-09-07T18:42:20.081923-05:00 Greed mythbackend[2421]: I CoreContext mythcorecontext.cpp:227 (Init) Assumed character encoding: en_US.utf-8
2012-09-07T18:42:20.182031-05:00 Greed mythbackend[2421]: N CoreContext mythcontext.cpp:477 (LoadDatabaseSettings) Empty LocalHostName.
2012-09-07T18:42:20.182052-05:00 Greed mythbackend[2421]: I CoreContext mythcontext.cpp:481 (LoadDatabaseSettings) Using localhost value of Greed
2012-09-07T18:42:20.182056-05:00 Greed mythbackend[2421]: E CoreContext configuration.cpp:112 (Save) Could not open settings file /home/mythtv/.mythtv/config.xml for writing
2012-09-07T18:42:20.182060-05:00 Greed mythbackend[2421]: N CoreContext mythcorecontext.cpp:1354 (InitLocale) Setting QT default locale to EN_US
2012-09-07T18:42:20.182064-05:00 Greed mythbackend[2421]: I CoreContext mythcorecontext.cpp:1387 (SaveLocaleDefaults) Current locale EN_US
2012-09-07T18:42:20.182067-05:00 Greed mythbackend[2421]: N CoreContext mythlocale.cpp:121 (LoadDefaultsFromXML) Reading locale defaults from /usr/share/mythtv//locales/en_us.xml
2012-09-07T18:42:20.182071-05:00 Greed mythbackend[2421]: I CoreContext schemawizard.cpp:117 (Compare) Current MythTV Schema Version (DBSchemaVer): 1276
2012-09-07T18:42:20.182074-05:00 Greed mythbackend[2421]: C CoreContext schemawizard.cpp:135 (CompareAndWait) MythTV database schema is old. Waiting to see if DB is being upgraded.
2012-09-07T18:42:21.182848-05:00 Greed mythbackend[2421]: I CoreContext schemawizard.cpp:117 (Compare) Current MythTV Schema Version (DBSchemaVer): 1276
2012-09-07T18:42:22.183585-05:00 Greed mythbackend[2421]: I CoreContext schemawizard.cpp:117 (Compare) Current MythTV Schema Version (DBSchemaVer): 1276
2012-09-07T18:42:23.184399-05:00 Greed mythbackend[2421]: I CoreContext schemawizard.cpp:117 (Compare) Current MythTV Schema Version (DBSchemaVer): 1276
2012-09-07T18:42:24.185232-05:00 Greed mythbackend[2421]: I CoreContext schemawizard.cpp:117 (Compare) Current MythTV Schema Version (DBSchemaVer): 1276
2012-09-07T18:42:25.186058-05:00 Greed mythbackend[2421]: I CoreContext schemawizard.cpp:117 (Compare) Current MythTV Schema Version (DBSchemaVer): 1276
2012-09-07T18:42:25.186077-05:00 Greed mythbackend[2421]: C CoreContext schemawizard.cpp:179 (CompareAndWait) Timed out waiting.
2012-09-07T18:42:25.186083-05:00 Greed mythbackend[2421]: E CoreContext storagegroup.cpp:680 (FindNextDirMostFree) SG(Default): FindNextDirMostFree: '/mnt/seagate15/recordings' does not exist!
2012-09-07T18:42:25.186087-05:00 Greed mythbackend[2421]: E CoreContext storagegroup.cpp:680 (FindNextDirMostFree) SG(Default): FindNextDirMostFree: '/media/sbe0/recordings' does not exist!
2012-09-07T18:42:25.186091-05:00 Greed mythbackend[2421]: E CoreContext storagegroup.cpp:680 (FindNextDirMostFree) SG(Default): FindNextDirMostFree: '/media/sbe1/recordings' does not exist!
2012-09-07T18:42:25.186094-05:00 Greed mythbackend[2421]: E CoreContext dbutil.cpp:558 (CreateTemporaryDBConf) DBUtil: Error closing '/tmp/mythtv_db_backup_conf_ae8rLV'#012#011#011#011eno: No space left on device (28)
2012-09-07T18:42:25.186100-05:00 Greed mythbackend[2421]: E CoreContext dbutil.cpp:603 (DoBackup) Backing up database with script: '/usr/share/mythtv/mythconverg_backup.pl'
2012-09-07T18:42:25.186104-05:00 Greed mythbackend[2421]: I SystemManager system-unix.cpp:263 (run) Starting process manager
2012-09-07T18:42:25.186114-05:00 Greed mythbackend[2421]: I SystemSignalManager system-unix.cpp:485 (run) Starting process signal handler
2012-09-07T18:42:25.186119-05:00 Greed mythbackend[2421]: I SystemIOHandlerW system-unix.cpp:90 (run) Starting IO manager (write)
2012-09-07T18:42:25.186131-05:00 Greed mythbackend[2421]: I SystemIOHandlerR system-unix.cpp:90 (run) Starting IO manager (read)
2012-09-07T18:42:25.386311-05:00 Greed mythbackend[2421]: E CoreContext dbutil.cpp:619 (DoBackup) DBUtil: Error backing up database: /usr/share/mythtv/mythconverg_backup.pl  /tmp/mythtv_db_backup_conf_ae8rLV (255)
2012-09-07T18:42:25.386332-05:00 Greed mythbackend[2421]: C CoreContext dbutil.cpp:250 (BackupDB) Script-based database backup failed. Retrying with internal backup.
2012-09-07T18:42:25.386336-05:00 Greed mythbackend[2421]: E CoreContext storagegroup.cpp:680 (FindNextDirMostFree) SG(Default): FindNextDirMostFree: '/mnt/seagate15/recordings' does not exist!
2012-09-07T18:42:25.386340-05:00 Greed mythbackend[2421]: E CoreContext storagegroup.cpp:680 (FindNextDirMostFree) SG(Default): FindNextDirMostFree: '/media/sbe0/recordings' does not exist!
2012-09-07T18:42:25.386343-05:00 Greed mythbackend[2421]: E CoreContext storagegroup.cpp:680 (FindNextDirMostFree) SG(Default): FindNextDirMostFree: '/media/sbe1/recordings' does not exist!
2012-09-07T18:42:25.386347-05:00 Greed mythbackend[2421]: E CoreContext dbutil.cpp:558 (CreateTemporaryDBConf) DBUtil: Error closing '/tmp/mythtv_db_backup_conf_yvTcHw'#012#011#011#011eno: No space left on device (28)
2012-09-07T18:42:25.386352-05:00 Greed mythbackend[2421]: C CoreContext dbutil.cpp:710 (DoBackup) Backing up database to file: '/tmp/mythconverg-1276-20120907184225.sql'
2012-09-07T18:42:25.452433-05:00 Greed mythbackend[2421]: E CoreContext dbutil.cpp:721 (DoBackup) DBUtil: Error backing up database: 'mysqldump --defaults-extra-file='/tmp/mythtv_db_backup_conf_yvTcHw' --host='localhost' --port='3306' --user='mythtv' --add-drop-table --add-locks --allow-keywords --complete-insert --extended-insert --lock-tables --no-create-db --quick 'mythconverg' > '/tmp/mythconverg-1276-20120907184225.sql' 2>/dev/null' (1)
2012-09-07T18:42:25.452459-05:00 Greed mythbackend[2421]: E CoreContext mythmiscutil.cpp:1035 (getResponse) Read from stdin failed
2012-09-07T18:42:25.452463-05:00 Greed mythbackend[2421]: E CoreContext mythmiscutil.cpp:1035 (getResponse) Read from stdin failed
2012-09-07T18:42:25.452470-05:00 Greed mythbackend[2421]: E CoreContext main_helpers.cpp:529 (run_backend) Couldn't upgrade database to new schema

_________________
R7.4 Master Backend/Frontend 1 Ceton InfiniTV 4 AMD x4 9850/4GB/nVidia210 60GB SSD 5x2TB RAID5
Slave Backend/Frontend 1 Ceton InfiniTV 4 AMD 1050x6/4GB/NVidia 9500 40GB SSD 2x500GB SATA Maxtor
(Can't get 2nd Ceton tuner to work)


Top
 Profile  
 
PostPosted: Sat Sep 08, 2012 10:43 am 
Offline
Joined: Mon Dec 24, 2007 9:47 am
Posts: 535
Location: Ottawa, Canada
In this log segment it is not doing the upgrade specifically because it can't do a backup due to the disk being full.

Can you show a run when the disk is not full and where it does a successful backup?


Top
 Profile  
 
PostPosted: Sat Sep 08, 2012 10:49 am 
Offline
Joined: Mon May 29, 2006 4:58 pm
Posts: 58
My database has all the tables listed in the link you posted. Does that mean I need to delete them even though the log says nothing about them? Am I looking at the wrong log?
If I do need to delete them how do I stop the database auto upgrade that is constantly running so that I can restore the old db and delete the tables?
Should I restore the whole box and delete the tables before I run the upgrade or will that cause other problems?

_________________
R7.4 Master Backend/Frontend 1 Ceton InfiniTV 4 AMD x4 9850/4GB/nVidia210 60GB SSD 5x2TB RAID5
Slave Backend/Frontend 1 Ceton InfiniTV 4 AMD 1050x6/4GB/NVidia 9500 40GB SSD 2x500GB SATA Maxtor
(Can't get 2nd Ceton tuner to work)


Top
 Profile  
 
PostPosted: Sat Sep 08, 2012 11:04 am 
Offline
Joined: Mon Dec 24, 2007 9:47 am
Posts: 535
Location: Ottawa, Canada
We don't know yet if you need to delete those tables. Can you free up space on the partition so we can get a log that shows the actual upgrade from schema 1276 failing? Your current log doesn't get to that part because the partition is full.

Before you do anything with the databases stop mythbackend with
Code:
sv stop mythbackend


Do you have a backup of your database?


Top
 Profile  
 
PostPosted: Sat Sep 08, 2012 12:42 pm 
Offline
Joined: Mon May 29, 2006 4:58 pm
Posts: 58
The very first log gives the space error even though it has 4GB free. I need to figure out how to stop the db upgrade so I can make sense of what is going on. I did find a log with a little more info.
012Duplicate column name 'filter'

Code:
2012-09-08T06:35:09.425666-05:00 Greed mythbackend[18778]: C thread_unknown mythcommandlineparser.cpp:2534 (ConfigureLogging) mythbackend version: fixes/0.25 [v0.25.2-9-ga72e341] www.mythtv.org
2012-09-08T06:35:09.425686-05:00 Greed mythbackend[18778]: C thread_unknown mythcommandlineparser.cpp:2536 (ConfigureLogging) Qt version: compile: 4.7.3, runtime: 4.7.3
2012-09-08T06:35:09.425700-05:00 Greed mythbackend[18778]: N thread_unknown mythcommandlineparser.cpp:2538 (ConfigureLogging) Enabled verbose msgs:  general
2012-09-08T06:35:09.425705-05:00 Greed mythbackend[18778]: N thread_unknown logging.cpp:1176 (logStart) Setting Log Level to LOG_INFO
2012-09-08T06:35:09.425709-05:00 Greed mythbackend[18778]: I thread_unknown logging.cpp:229 (FileLogger) Added logging to the console
2012-09-08T06:35:09.425713-05:00 Greed mythbackend[18778]: I thread_unknown logging.cpp:369 (SyslogLogger) Added syslogging to facility local6
2012-09-08T06:35:09.425717-05:00 Greed mythbackend[18778]: I thread_unknown logging.cpp:425 (DatabaseLogger) Added database logging to table logging
2012-09-08T06:35:09.425721-05:00 Greed mythbackend[18778]: N thread_unknown logging.cpp:1215 (logStart) Setting up SIGHUP handler
2012-09-08T06:35:09.425726-05:00 Greed mythbackend[18778]: N thread_unknown mythdirs.cpp:51 (InitializeMythDirs) Using runtime prefix = /usr
2012-09-08T06:35:09.425737-05:00 Greed mythbackend[18778]: N thread_unknown mythdirs.cpp:64 (InitializeMythDirs) Using configuration directory = /home/mythtv/.mythtv
2012-09-08T06:35:09.425741-05:00 Greed mythbackend[18778]: I CoreContext mythcorecontext.cpp:227 (Init) Assumed character encoding: en_US.utf-8
2012-09-08T06:35:09.525822-05:00 Greed mythbackend[18778]: N CoreContext mythcontext.cpp:477 (LoadDatabaseSettings) Empty LocalHostName.
2012-09-08T06:35:09.525841-05:00 Greed mythbackend[18778]: I CoreContext mythcontext.cpp:481 (LoadDatabaseSettings) Using localhost value of Greed
2012-09-08T06:35:09.525853-05:00 Greed mythbackend[18778]: E CoreContext configuration.cpp:112 (Save) Could not open settings file /home/mythtv/.mythtv/config.xml for writing
2012-09-08T06:35:09.525858-05:00 Greed mythbackend[18778]: N CoreContext mythcorecontext.cpp:1354 (InitLocale) Setting QT default locale to EN_US
2012-09-08T06:35:09.525862-05:00 Greed mythbackend[18778]: I CoreContext mythcorecontext.cpp:1387 (SaveLocaleDefaults) Current locale EN_US
2012-09-08T06:35:09.525866-05:00 Greed mythbackend[18778]: N CoreContext mythlocale.cpp:121 (LoadDefaultsFromXML) Reading locale defaults from /usr/share/mythtv//locales/en_us.xml
2012-09-08T06:35:09.525869-05:00 Greed mythbackend[18778]: I CoreContext schemawizard.cpp:117 (Compare) Current MythTV Schema Version (DBSchemaVer): 1276
2012-09-08T06:35:09.525873-05:00 Greed mythbackend[18778]: C CoreContext schemawizard.cpp:135 (CompareAndWait) MythTV database schema is old. Waiting to see if DB is being upgraded.
2012-09-08T06:35:10.526659-05:00 Greed mythbackend[18778]: I CoreContext schemawizard.cpp:117 (Compare) Current MythTV Schema Version (DBSchemaVer): 1276
2012-09-08T06:35:11.527475-05:00 Greed mythbackend[18778]: I CoreContext schemawizard.cpp:117 (Compare) Current MythTV Schema Version (DBSchemaVer): 1276
2012-09-08T06:35:12.528311-05:00 Greed mythbackend[18778]: I CoreContext schemawizard.cpp:117 (Compare) Current MythTV Schema Version (DBSchemaVer): 1276
2012-09-08T06:35:13.529146-05:00 Greed mythbackend[18778]: I CoreContext schemawizard.cpp:117 (Compare) Current MythTV Schema Version (DBSchemaVer): 1276
2012-09-08T06:35:14.529988-05:00 Greed mythbackend[18778]: I CoreContext schemawizard.cpp:117 (Compare) Current MythTV Schema Version (DBSchemaVer): 1276
2012-09-08T06:35:14.530010-05:00 Greed mythbackend[18778]: C CoreContext schemawizard.cpp:179 (CompareAndWait) Timed out waiting.
2012-09-08T06:35:14.530015-05:00 Greed mythbackend[18778]: E CoreContext storagegroup.cpp:680 (FindNextDirMostFree) SG(Default): FindNextDirMostFree: '/mnt/seagate15/recordings' does not exist!
2012-09-08T06:35:14.530020-05:00 Greed mythbackend[18778]: E CoreContext storagegroup.cpp:680 (FindNextDirMostFree) SG(Default): FindNextDirMostFree: '/media/sbe0/recordings' does not exist!
2012-09-08T06:35:14.530025-05:00 Greed mythbackend[18778]: E CoreContext storagegroup.cpp:680 (FindNextDirMostFree) SG(Default): FindNextDirMostFree: '/media/sbe1/recordings' does not exist!
2012-09-08T06:35:14.530029-05:00 Greed mythbackend[18778]: E CoreContext dbutil.cpp:603 (DoBackup) Backing up database with script: '/usr/share/mythtv/mythconverg_backup.pl'
2012-09-08T06:35:14.530033-05:00 Greed mythbackend[18778]: I SystemManager system-unix.cpp:263 (run) Starting process manager
2012-09-08T06:35:14.530038-05:00 Greed mythbackend[18778]: I SystemSignalManager system-unix.cpp:485 (run) Starting process signal handler
2012-09-08T06:35:14.530042-05:00 Greed mythbackend[18778]: I SystemIOHandlerR system-unix.cpp:90 (run) Starting IO manager (read)
2012-09-08T06:35:14.530046-05:00 Greed mythbackend[18778]: I SystemIOHandlerW system-unix.cpp:90 (run) Starting IO manager (write)
2012-09-08T06:35:39.317622-05:00 Greed mythbackend[18778]: C CoreContext dbutil.cpp:624 (DoBackup) Database Backup complete.
2012-09-08T06:35:39.317643-05:00 Greed mythbackend[18778]: C CoreContext dbutil.cpp:655 (DoBackup) Backed up database to file: '/tmp/mythconverg-1276-20120908063514.sql.gz'
2012-09-08T06:35:39.317657-05:00 Greed mythbackend[18778]: E CoreContext mythmiscutil.cpp:1035 (getResponse) Read from stdin failed
2012-09-08T06:35:39.317661-05:00 Greed mythbackend[18778]: C CoreContext dbcheck.cpp:495 (UpgradeTVDatabaseSchema) Newest MythTV Schema Version : 1299
2012-09-08T06:35:39.317666-05:00 Greed mythbackend[18778]: C CoreContext dbcheck.cpp:399 (performActualUpdate) Upgrading to MythTV schema version 1277
2012-09-08T06:35:39.317670-05:00 Greed mythbackend[18778]: E CoreContext dbcheck.cpp:414 (performActualUpdate) DB Error (Performing database upgrade): #012Query was: ALTER TABLE record ADD COLUMN filter INT UNSIGNED NOT NULL DEFAULT 0; #012Error was: Driver error was [2/1060]:#012QMYSQL: Unable to execute query#012Database error was:#012Duplicate column name 'filter'#012 #012new version: 1277
2012-09-08T06:35:39.317676-05:00 Greed mythbackend[18778]: E CoreContext dbcheck.cpp:509 (UpgradeTVDatabaseSchema) Database Schema upgrade FAILED, unlocking.
2012-09-08T06:35:39.317681-05:00 Greed mythbackend[18778]: E CoreContext main_helpers.cpp:529 (run_backend) Couldn't upgrade database to new schema
2012-09-08T08:18:36.758966-05:00 Greed mythbackend[18778]: C thread_unknown mythcommandlineparser.cpp:2534 (ConfigureLogging) mythbackend version: fixes/0.25 [v0.25.2-9-ga72e341] www.mythtv.org
2012-09-08T08:18:36.758990-05:00 Greed mythbackend[18778]: C thread_unknown mythcommandlineparser.cpp:2536 (ConfigureLogging) Qt version: compile: 4.7.3, runtime: 4.7.3
2012-09-08T08:18:36.759003-05:00 Greed mythbackend[18778]: N thread_unknown mythcommandlineparser.cpp:2538 (ConfigureLogging) Enabled verbose msgs:  general
2012-09-08T08:18:36.759008-05:00 Greed mythbackend[18778]: N thread_unknown logging.cpp:1176 (logStart) Setting Log Level to LOG_INFO
2012-09-08T08:18:36.759012-05:00 Greed mythbackend[18778]: I thread_unknown logging.cpp:229 (FileLogger) Added logging to the console
2012-09-08T08:18:36.759016-05:00 Greed mythbackend[18778]: I thread_unknown logging.cpp:369 (SyslogLogger) Added syslogging to facility local6
2012-09-08T08:18:36.759020-05:00 Greed mythbackend[18778]: I thread_unknown logging.cpp:425 (DatabaseLogger) Added database logging to table logging
2012-09-08T08:18:36.759025-05:00 Greed mythbackend[18778]: N thread_unknown logging.cpp:1215 (logStart) Setting up SIGHUP handler
2012-09-08T08:18:36.759030-05:00 Greed mythbackend[18778]: N thread_unknown mythdirs.cpp:51 (InitializeMythDirs) Using runtime prefix = /usr
2012-09-08T08:18:36.759035-05:00 Greed mythbackend[18778]: N thread_unknown mythdirs.cpp:64 (InitializeMythDirs) Using configuration directory = /home/mythtv/.mythtv
2012-09-08T08:18:36.759040-05:00 Greed mythbackend[18778]: I CoreContext mythcorecontext.cpp:227 (Init) Assumed character encoding: en_US.utf-8
2012-09-08T08:18:36.859141-05:00 Greed mythbackend[18778]: N CoreContext mythcontext.cpp:477 (LoadDatabaseSettings) Empty LocalHostName.
2012-09-08T08:18:36.859163-05:00 Greed mythbackend[18778]: I CoreContext mythcontext.cpp:481 (LoadDatabaseSettings) Using localhost value of Greed
2012-09-08T08:18:36.859169-05:00 Greed mythbackend[18778]: E CoreContext configuration.cpp:112 (Save) Could not open settings file /home/mythtv/.mythtv/config.xml for writing
2012-09-08T08:18:36.859174-05:00 Greed mythbackend[18778]: N CoreContext mythcorecontext.cpp:1354 (InitLocale) Setting QT default locale to EN_US
2012-09-08T08:18:36.859178-05:00 Greed mythbackend[18778]: I CoreContext mythcorecontext.cpp:1387 (SaveLocaleDefaults) Current locale EN_US
2012-09-08T08:18:36.859182-05:00 Greed mythbackend[18778]: N CoreContext mythlocale.cpp:121 (LoadDefaultsFromXML) Reading locale defaults from /usr/share/mythtv//locales/en_us.xml
2012-09-08T08:18:36.859186-05:00 Greed mythbackend[18778]: I CoreContext schemawizard.cpp:117 (Compare) Current MythTV Schema Version (DBSchemaVer): 1276
2012-09-08T08:18:36.859190-05:00 Greed mythbackend[18778]: C CoreContext schemawizard.cpp:135 (CompareAndWait) MythTV database schema is old. Waiting to see if DB is being upgraded.
2012-09-08T08:18:37.860021-05:00 Greed mythbackend[18778]: I CoreContext schemawizard.cpp:117 (Compare) Current MythTV Schema Version (DBSchemaVer): 1276
2012-09-08T08:18:38.860845-05:00 Greed mythbackend[18778]: I CoreContext schemawizard.cpp:117 (Compare) Current MythTV Schema Version (DBSchemaVer): 1276
2012-09-08T08:18:39.861695-05:00 Greed mythbackend[18778]: I CoreContext schemawizard.cpp:117 (Compare) Current MythTV Schema Version (DBSchemaVer): 1276
2012-09-08T08:18:40.862526-05:00 Greed mythbackend[18778]: I CoreContext schemawizard.cpp:117 (Compare) Current MythTV Schema Version (DBSchemaVer): 1276
2012-09-08T08:18:41.863344-05:00 Greed mythbackend[18778]: I CoreContext schemawizard.cpp:117 (Compare) Current MythTV Schema Version (DBSchemaVer): 1276
2012-09-08T08:18:41.863366-05:00 Greed mythbackend[18778]: C CoreContext schemawizard.cpp:179 (CompareAndWait) Timed out waiting.
2012-09-08T08:18:41.863371-05:00 Greed mythbackend[18778]: E CoreContext storagegroup.cpp:680 (FindNextDirMostFree) SG(Default): FindNextDirMostFree: '/mnt/seagate15/recordings' does not exist!
2012-09-08T08:18:41.863387-05:00 Greed mythbackend[18778]: E CoreContext storagegroup.cpp:680 (FindNextDirMostFree) SG(Default): FindNextDirMostFree: '/media/sbe0/recordings' does not exist!
2012-09-08T08:18:41.863392-05:00 Greed mythbackend[18778]: E CoreContext storagegroup.cpp:680 (FindNextDirMostFree) SG(Default): FindNextDirMostFree: '/media/sbe1/recordings' does not exist!
2012-09-08T08:18:41.863396-05:00 Greed mythbackend[18778]: E CoreContext dbutil.cpp:558 (CreateTemporaryDBConf) DBUtil: Error closing '/tmp/mythtv_db_backup_conf_FO8MnQ'#012#011#011#011eno: No space left on device (28)
2012-09-08T08:18:41.863403-05:00 Greed mythbackend[18778]: E CoreContext dbutil.cpp:603 (DoBackup) Backing up database with script: '/usr/share/mythtv/mythconverg_backup.pl'
2012-09-08T08:18:41.863407-05:00 Greed mythbackend[18778]: I SystemManager system-unix.cpp:263 (run) Starting process manager
2012-09-08T08:18:41.863411-05:00 Greed mythbackend[18778]: I SystemSignalManager system-unix.cpp:485 (run) Starting process signal handler
2012-09-08T08:18:41.863415-05:00 Greed mythbackend[18778]: I SystemIOHandlerR system-unix.cpp:90 (run) Starting IO manager (read)
2012-09-08T08:18:41.863419-05:00 Greed mythbackend[18778]: I SystemIOHandlerW system-unix.cpp:90 (run) Starting IO manager (write)
2012-09-08T08:18:42.122498-05:00 Greed mythbackend[18778]: E CoreContext dbutil.cpp:619 (DoBackup) DBUtil: Error backing up database: /usr/share/mythtv/mythconverg_backup.pl  /tmp/mythtv_db_backup_conf_FO8MnQ (255)
2012-09-08T08:18:42.122519-05:00 Greed mythbackend[18778]: C CoreContext dbutil.cpp:250 (BackupDB) Script-based database backup failed. Retrying with internal backup.
2012-09-08T08:18:42.122525-05:00 Greed mythbackend[18778]: E CoreContext storagegroup.cpp:680 (FindNextDirMostFree) SG(Default): FindNextDirMostFree: '/mnt/seagate15/recordings' does not exist!
2012-09-08T08:18:42.122530-05:00 Greed mythbackend[18778]: E CoreContext storagegroup.cpp:680 (FindNextDirMostFree) SG(Default): FindNextDirMostFree: '/media/sbe0/recordings' does not exist!
2012-09-08T08:18:42.122535-05:00 Greed mythbackend[18778]: E CoreContext storagegroup.cpp:680 (FindNextDirMostFree) SG(Default): FindNextDirMostFree: '/media/sbe1/recordings' does not exist!
2012-09-08T08:18:42.122539-05:00 Greed mythbackend[18778]: E CoreContext dbutil.cpp:558 (CreateTemporaryDBConf) DBUtil: Error closing '/tmp/mythtv_db_backup_conf_GuwNmC'#012#011#011#011eno: No space left on device (28)
2012-09-08T08:18:42.122546-05:00 Greed mythbackend[18778]: C CoreContext dbutil.cpp:710 (DoBackup) Backing up database to file: '/tmp/mythconverg-1276-20120908081842.sql'
2012-09-08T08:18:42.122550-05:00 Greed mythbackend[18778]: E CoreContext dbutil.cpp:721 (DoBackup) DBUtil: Error backing up database: 'mysqldump --defaults-extra-file='/tmp/mythtv_db_backup_conf_GuwNmC' --host='localhost' --port='3306' --user='mythtv' --add-drop-table --add-locks --allow-keywords --complete-insert --extended-insert --lock-tables --no-create-db --quick 'mythconverg' > '/tmp/mythconverg-1276-20120908081842.sql' 2>/dev/null' (1)
2012-09-08T08:18:42.122555-05:00 Greed mythbackend[18778]: E CoreContext mythmiscutil.cpp:1035 (getResponse) Read from stdin failed
2012-09-08T08:18:42.122558-05:00 Greed mythbackend[18778]: E CoreContext mythmiscutil.cpp:1035 (getResponse) Read from stdin failed
2012-09-08T08:18:42.122562-05:00 Greed mythbackend[18778]: E CoreContext main_helpers.cpp:529 (run_backend) Couldn't upgrade database to new schema

_________________
R7.4 Master Backend/Frontend 1 Ceton InfiniTV 4 AMD x4 9850/4GB/nVidia210 60GB SSD 5x2TB RAID5
Slave Backend/Frontend 1 Ceton InfiniTV 4 AMD 1050x6/4GB/NVidia 9500 40GB SSD 2x500GB SATA Maxtor
(Can't get 2nd Ceton tuner to work)


Top
 Profile  
 
PostPosted: Sat Sep 08, 2012 1:11 pm 
Offline
Joined: Mon May 29, 2006 4:58 pm
Posts: 58
It looks like the error in the last log I posted was due to a partially upgraded db. I have a pre-upgrade copy of the database. How do I restore it? I've seen info on restores but they are all assuming you are restoring the same db schema version as the installed MythTV. My db is around 275MB. How much free space do I need for the db upgrade to run? I have 1.9GB free (I know I said 4GB earlier. No idea where that came from.)

_________________
R7.4 Master Backend/Frontend 1 Ceton InfiniTV 4 AMD x4 9850/4GB/nVidia210 60GB SSD 5x2TB RAID5
Slave Backend/Frontend 1 Ceton InfiniTV 4 AMD 1050x6/4GB/NVidia 9500 40GB SSD 2x500GB SATA Maxtor
(Can't get 2nd Ceton tuner to work)


Top
 Profile  
 
PostPosted: Sat Sep 08, 2012 2:16 pm 
Offline
Joined: Mon Dec 24, 2007 9:47 am
Posts: 535
Location: Ottawa, Canada
To stop the upgrade you stop mythbackend per my earlier note. To do anything with the database, you need to ensure nothing else is accessing it so stop mythbackend.

To restore the database, you don't need the old software. Use the restore capabilities documented on mythtv.org's wiki (http://www.mythtv.org/wiki/Database_Bac ... se_Restore). It usually involves dropping the bad mythconvergdatabase, recreating mythconverg and then doing a restore of your mysql back up file.

Once this is done, if you run mythtv-setup or mythbackend it will attempt to upgrade the database again.

If it fails in the same place then you have something corrupt in your database from the past and we will need to manually fix it.

My suspicion is something bad happened when it was updating the schema at change set 1277 and so part of 1277 was applied. Now when 1277 runs again it gets confused because some of its changes have been applied already.

If the backup is failing due to disk full but you say that the disk has lots of free space then you need to find out where backup is writing to and why that partition is full. Perhaps "df -H" will show us why.


Top
 Profile  
 
PostPosted: Sat Sep 08, 2012 3:41 pm 
Offline
Joined: Mon May 29, 2006 4:58 pm
Posts: 58
I'll give restoring the db a try. I had to kill mysql to get it to quit the update attempts. /tmp was the only place it was filling as far as I can tell. If it's also writing to something else I don't know how to find out. df -h doesn't show anything full.

_________________
R7.4 Master Backend/Frontend 1 Ceton InfiniTV 4 AMD x4 9850/4GB/nVidia210 60GB SSD 5x2TB RAID5
Slave Backend/Frontend 1 Ceton InfiniTV 4 AMD 1050x6/4GB/NVidia 9500 40GB SSD 2x500GB SATA Maxtor
(Can't get 2nd Ceton tuner to work)


Top
 Profile  
 
PostPosted: Sat Sep 08, 2012 4:52 pm 
Offline
Joined: Mon May 29, 2006 4:58 pm
Posts: 58
Restoring the db fixed it. It seems to have upgraded fine this time. The main thing I did differently is let the upgrade run in the background on it's own instead of answering yes to the prompt to upgrade. After the upgrade was complete (verified in the log). It prompted me to upgrade again and I said yes and nothing happened. ??? I now have issues with the backend not working when I boot up. Alt+1 doesn't fix it but Alt+3 does. I'll start another thread. Thanks for all the help!

_________________
R7.4 Master Backend/Frontend 1 Ceton InfiniTV 4 AMD x4 9850/4GB/nVidia210 60GB SSD 5x2TB RAID5
Slave Backend/Frontend 1 Ceton InfiniTV 4 AMD 1050x6/4GB/NVidia 9500 40GB SSD 2x500GB SATA Maxtor
(Can't get 2nd Ceton tuner to work)


Top
 Profile  
 
PostPosted: Sat Sep 08, 2012 6:06 pm 
Offline
Joined: Mon Dec 24, 2007 9:47 am
Posts: 535
Location: Ottawa, Canada
Super!

There are actually two parts to the database upgrade. The main mythtv data is upgrated by either mythtv-setup or mythbackend. Once this is done and you start the front end, the additional plug ins will want upgrading which is the prompt you are seeing.


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 15 posts ] 


All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu