| View previous topic :: View next topic |
| Author |
Message |
mkyrylen
Joined: 11 Dec 2009
Posts: 14
Location: Adelaide, Australia
|
 Posted: Sat Mar 06, 2010 3:05 pm Post subject: |
 |
|
I am having similar issues. After getting to this stage:
| Code: | Starting the backend. This will automatically update the schema.
I'll launch an xterm so you watch output backend log.
Once the schema updates are complete, switch back to this xterm.
When you see "Upgrading to MythTV schema version 1244"
You can switch back to this xterm.
Note:After pressing <ENTER>, I'll be asleep for 30 secs...
This will give the schema time to upgrade.
Press <ENTER> to continue...
Press <ENTER> to continue once the schema upgrade is complete. |
I get an endless repetition of the following (mainly the second and third lines):
| Code: | 2010-03-07 09:28:17.150 Reschedule requested for id -1.
2010-03-07 09:28:17.290 MainServer::HandleVersion - Client speaks protocol version 40 but we speak 50!
2010-03-07 09:28:17.484 MainServer, Warning: Unknown socket closing MythSocket(0xffffffffa72d8300)
2010-03-07 09:28:17.510 Scheduled 12 items in 0.4 = 0.32 match + 0.03 place |
Any ideas!!!! |
|
| Back to top |
|
 |
RacerX
Joined: 05 Sep 2004
Posts: 245
|
| Posted: Sat Mar 06, 2010 3:45 pm Post subject: |
|
|
Graysky
The problem that you are having is that the sql schema upgrade is failing. This didn't happen when I ran the upgrade. However, it has to finish properly in order for the db to work. I did some digging and here is what I found.
http://www.gossamer-threads.com/lists/mythtv/users/406111#406111
Here is another theory, what if the thing is common is changing the host name of your machine. It touches the database all over the place. Have you ever done this? How old are the oldest shows in myth/tv ?
Lots of ideas on gossamer regarding Schema upgrade failure
What do you think?
Last edited by RacerX on Sat Mar 06, 2010 4:11 pm; edited 1 time in total |
|
| Back to top |
|
|
graysky
Joined: 10 Dec 2003
Posts: 1754
Location: /dev/null
|
| Posted: Sat Mar 06, 2010 4:07 pm Post subject: |
|
|
@RacerX - thanks for the tip. I can't do the partial restore:
I can drop the db okay:
| Code: | $ mysql -umythtv -p mythconverg
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 535
Server version: 5.0.75 Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> DROP DATABASE IF EXISTS mythconverg;
Query OK, 54 rows affected (0.01 sec)
mysql> CREATE DATABASE IF NOT EXISTS mythconverg;
Query OK, 1 row affected (0.00 sec)
mysql> ALTER DATABASE mythconverg DEFAULT CHARACTER SET latin1;
Query OK, 1 row affected (0.01 sec)
mysql> quit
Bye |
I can restore the blank one okay:
| Code: | [mythtv@mythtv ~]$ /usr/share/mythtv/mythconverg_restore.pl --dir=$HOME --file=mythconverg-1214-blank.sql.gz --verbose
Configuring environment:
- username: mythtv
- HOME: /home/mythtv
- MYTHCONFDIR: /home/mythtv/.mythtv
Parsing configuration files:
- checking: /home/mythtv/.mythtv/config.xml
parsing: /home/mythtv/.mythtv/config.xml
- checking: /home/mythtv/.mythtv/backuprc
Applying command-line arguments.
Checking configuration.
Database Information:
DBHostName: localhost
DBPort: 0
DBUserName: mythtv
DBPassword: XXX
DBName: mythconverg
DBSchemaVer:
DBBackupDirectory: /home/mythtv
DBBackupFilename: mythconverg-1214-blank.sql.gz
create_database:
Executables:
mysql_client: mysql
uncompress: gzip -d
Miscellaneous:
partial_restore: no
restore_xmltvids: no
change_hostname: no
Checking database.
Found 0 tables in the database.
Backup file is compressed.
- Uncompressing backup file with IO::Uncompress::Gunzip.
Attempting to use supplied password for mysql command-line client.
Any [client] or [mysql] password specified in the MySQL options file will
take precedence.
Executing command:
'mysql' --defaults-extra-file='/tmp/RCfj5LUMX4' --host='localhost' --user='mythtv' 'mythconverg'
mysql exited with status: 0
Restored 1553 of 1553 lines.
Successfully restored backup. |
But I can't restore my backup:
| Code: | [mythtv@mythtv ~]$ /usr/share/mythtv/mythconverg_restore.pl --dir=$HOME --file=mythconverg-1215-20100306190349.sql.gz --verbose
Configuring environment:
- username: mythtv
- HOME: /home/mythtv
- MYTHCONFDIR: /home/mythtv/.mythtv
Parsing configuration files:
- checking: /home/mythtv/.mythtv/config.xml
parsing: /home/mythtv/.mythtv/config.xml
- checking: /home/mythtv/.mythtv/backuprc
Applying command-line arguments.
Checking configuration.
Database Information:
DBHostName: localhost
DBPort: 0
DBUserName: mythtv
DBPassword: XXX
DBName: mythconverg
DBSchemaVer:
DBBackupDirectory: /home/mythtv
DBBackupFilename: mythconverg-1215-20100306190349.sql.gz
create_database:
Executables:
mysql_client: mysql
uncompress: gzip -d
Miscellaneous:
partial_restore: no
restore_xmltvids: no
change_hostname: no
Checking database.
Found 54 tables in the database.
WARNING: Database not empty.
ERROR: Unable to do a full restore. The database contains data. |
_________________
KM user since R4 |
|
| Back to top |
|
|
graysky
Joined: 10 Dec 2003
Posts: 1754
Location: /dev/null
|
| Posted: Sat Mar 06, 2010 5:04 pm Post subject: |
|
|
Seems like the missing step was to use the --partial_restore switch when doing Mike's steps...
| Code: | $ ./mythconverg_restore.pl --dir=$HOME --file=mythconverg-1214-20100307062803.sql.gz --partial_restore --verbose
Configuring environment:
- username: mythtv
- HOME: /home/mythtv
- MYTHCONFDIR: /home/mythtv/.mythtv
Parsing configuration files:
- checking: /home/mythtv/.mythtv/config.xml
parsing: /home/mythtv/.mythtv/config.xml
- checking: /home/mythtv/.mythtv/backuprc
parsing: /home/mythtv/.mythtv/backuprc
Applying command-line arguments.
Checking configuration.
Database Information:
DBHostName: localhost
DBPort: 0
DBUserName: mythtv
DBPassword: XXX
DBName: mythconverg
DBSchemaVer:
DBBackupDirectory: /home/mythtv
DBBackupFilename: mythconverg-1214-20100307062803.sql.gz
create_database:
Executables:
mysql_client: mysql
uncompress: gzip -d
Miscellaneous:
partial_restore: yes
with_plugin_data: no
restore_xmltvids: no
change_hostname: no
Checking database.
Found 54 tables in the database.
Backup file is compressed.
- Uncompressing backup file with IO::Uncompress::Gunzip.
Attempting to use supplied password for mysql command-line client.
Any [client] or [mysql] password specified in the MySQL options file will
take precedence.
Restoring partial backup with filter:
(40101 SET NAMES |^INSERT INTO \`?(oldrecorded|record|recorded|recordedmarkup|recordedprogram|recordedrating|recordedseek)\`? )
Executing command:
'mysql' --defaults-extra-file='/tmp/kUypOugWIw' --host='localhost' --user='mythtv' 'mythconverg'
mysql exited with status: 0
Restored 13 of 3383 lines.
Successfully restored backup. |
I'd still like to know why my rsync restore failed: Can anyone give me a clue as to why this is happening or what I can do to fix it?
| graysky wrote: | After rsyncing back the backup of my / partition and rebooting, The box is just stuck in an endless loop of:
| Code: | Starting Hal [BKGD]
Starting SSH [BKGD]
Starting Mysql [BKGD]
Starting lighttpd [BKGD]
Starting Avahi [BKGD]
Starting Hal [BKGD]
Starting SSH [BKGD]
Starting Mysql [BKGD]
Starting lighttpd [BKGD]
Starting Avahi [BKGD]
Starting Hal [BKGD]
Starting SSH [BKGD]
Starting Mysql [BKGD]
Starting lighttpd [BKGD]
Starting Avahi [BKGD]
etc. |
|
_________________
KM user since R4 |
|
| Back to top |
|
|
djb61230
Joined: 23 Jun 2006
Posts: 106
|
| Posted: Sun Mar 07, 2010 4:19 am Post subject: |
|
|
Sorry to hear you having so much troubles upgrading. You have worked so hard on this and I have to say I don't know how to solve your specific problem.
But how about a plan like this:
1) Backup your best 0.21 data base.
2) Backup any recordings that you really care about.
3) Install fresh 0.22/R6.
When I flipped to 0.22 last summer, I had been running R5E50 (yeah really old) and I just assumed keeping the database was a long shot - so I didn't bother. I followed this page to get my "previously recorded" data into 0.22.
http://www.mythpvr.com/mythtv/tips/migrate-recordings.html
I followed that page and it partially worked. My history was remembered but I never got my old recordings playable as TV recordings. I ended up having to put them in mythvideo so we could watch and then delete them from there.
Yes I had to re-do my recording rules but at least the new system did not record old episodes recorded before because that data was migrated. Overall a solution that worked and with probably less work than what you have done so far. |
|
| Back to top |
|
|
graysky
Joined: 10 Dec 2003
Posts: 1754
Location: /dev/null
|
| Posted: Sun Mar 07, 2010 5:17 am Post subject: |
|
|
I summarized the steps taken to get this NEARLY fixed in this howto. I still can't get mythvideo working though, nor was I able to run cesman's script /usr/LH/bin/update_schema_021_to_022.sh
If you can help, please post in that howto.
_________________
KM user since R4 |
|
| Back to top |
|
|
RacerX
Joined: 05 Sep 2004
Posts: 245
|
| Posted: Sun Mar 07, 2010 8:48 am Post subject: |
|
|
Graysky
Glad to see that you made more progress, in .22 there is some depreciation of the functions. For example when you are in the main window you select escape. It will show you a menu to exit, exit and reboot, exit and shutdown. Also scanning for new videos is now done inside of myth video in a menu.
Here is a transition guide that explains some of the changes in mythvideo .22
http://www.mythtv.org/wiki/MythVideo_.22_Transition_Guide |
|
| Back to top |
|
|
graysky
Joined: 10 Dec 2003
Posts: 1754
Location: /dev/null
|
| Posted: Sun Mar 07, 2010 8:54 am Post subject: |
|
|
| RacerX wrote: | Graysky
Glad to see that you made more progress, in .22 there is some depreciation of the functions. For example when you are in the main window you select escape. It will show you a menu to exit, exit and reboot, exit and shutdown. Also scanning for new videos is now done inside of myth video in a menu.
Here is a transition guide that explains some of the changes in mythvideo .22
http://www.mythtv.org/wiki/MythVideo_.22_Transition_Guide |
Thanks for the tips, RacerX. This upgrade has really broken me down. I just reverted to R6.01 and am in the process or getting it setup to my liking again. I don't want to upgrade to R6.02 now. R6.01 just worked for me. R6.02 with my database has caused nothing be problems. That's not to say that R6.02 is the problem, but with my database... I just don't know.
_________________
KM user since R4 |
|
| Back to top |
|
|
RacerX
Joined: 05 Sep 2004
Posts: 245
|
| Posted: Sun Mar 07, 2010 9:14 am Post subject: |
|
|
My advice is setup a test from scratch under 6.02. This will allow you more time to test it out to clearly understand your requirements and how that pertains to myth .22. Also read the transition doc because I know you are big into myth video and there are significant differences in playback if you using programs other than internal.
I really like the changes because it seemed to me that the front end was really old looking compared to XMBC. I'm looking forward to .myth .23. |
|
| Back to top |
|
|
Big boy stan
Joined: 04 Jan 2006
Posts: 169
Location: South New Jersey, USA
|
| Posted: Sun Mar 07, 2010 11:41 am Post subject: |
|
|
Well looks like I just fell into the same tar pit but I dont have a full image backup. My database upgrade made it a bit further then graysky's. It is trying to upgrade from 1230 to 1231 and is stuck in the endless loop.
I have not rebooted or anything since doing the upgrade for fear of corrupting something. I am updating from R5.5 to 6.02. Any advice would be greatly appreciated.
Is the blank database fix as suggested by http://www.gossamer-threads.com/lists/mythtv/users/406111#406111 something I should try?
_________________
LINHES 6.02 BE/FE - MSI K9N6SGM-V with AMD A64 X2 4600+, 1GB Ram. 120GB Seagate+1.5TB WD. (2) PVR150 card. Nvidia 7200 with DVI and STV out. Silver remote. / Diskless FE - Dell Inspiron 5150 notebook Mobile P4 2.8Ghz, Integrated NVidia fx5200. |
|
| Back to top |
|
|
Big boy stan
Joined: 04 Jan 2006
Posts: 169
Location: South New Jersey, USA
|
| Posted: Mon Mar 08, 2010 8:30 am Post subject: |
|
|
Well an update for anyone out there.
I followed the blank database fix as suggested in the earlier post (and executed by Graysky) which seemed to work. I used the mythconverg backup that was stored in /myth/backup. After that mythbackend started up, told me that it needed to upgrade the schema, and got to the same point before endlessly looping again.
I repeated the fix a second time but wound up with an error stating that the database was not blank(???). I proceeded but this time went to myth-setup instead of starting the backend and it told me it would upgrade the schema. I got no further messages about the database after that and was able to start the backend multiple times without any error messages.
I guess that means that I am up to the latest schema since the backend is working. Can someone confirm that or tell me how to check what schema is running?
_________________
LINHES 6.02 BE/FE - MSI K9N6SGM-V with AMD A64 X2 4600+, 1GB Ram. 120GB Seagate+1.5TB WD. (2) PVR150 card. Nvidia 7200 with DVI and STV out. Silver remote. / Diskless FE - Dell Inspiron 5150 notebook Mobile P4 2.8Ghz, Integrated NVidia fx5200. |
|
| Back to top |
|
|
jams
Site Admin
Joined: 11 Jun 2004
Posts: 164
|
| Posted: Mon Mar 08, 2010 8:35 am Post subject: |
|
|
| Quote: | | Can someone confirm that or tell me how to check what schema is running? |
mysql> select * from settings where value='DBSchemaVer'; |
|
| Back to top |
|
|
techman83
Joined: 22 Aug 2006
Posts: 127
Location: Perth
|
| Posted: Tue May 18, 2010 8:49 am Post subject: |
|
|
I've had this issue as well. I tried methods listed here:
http://ubuntuforums.org/showpost.php?p=8244404&postcount=8
But in the end, I just watched the errors and altered the mythconverg tables by hand until the schema upgrade behaved.
_________________
DRM 'manages access' in the same way that jail 'manages freedom.'
_________________
Intel P4 2.6
Intel Desktop Board
2GB DDR400
nVidia 6600GT
Dvico HDTV+
Dvico Dual 4
200GB WD for Swap /boot & /
2x 500GB WD with LVM & XFS for /myth/tv |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
