LinHES Forums
http://forums.linhes.org/

Unable to Restore Database
http://forums.linhes.org/viewtopic.php?f=21&t=23793		 Page 1 of 2
Author:  RacerX [ Tue Jul 16, 2013 12:57 am ]
Post subject:  Unable to Restore Database
Trying to restore the database. I go thru the link in mythweb/system heath/select database and chose restore then press go. The script starts but then stops with this error


Code:
<type 'exceptions.NameError'>   Python 2.7.3: /usr/bin/python2
Tue Jul 16 01:49:44 2013
A problem occurred in a Python script. Here is the sequence of function calls leading up to the error, in the order they occurred.

 /data/srv/httpd/htdocs/process.py in ()
    315
    316     #print mainpage % body
=>  317     selection=radio
    318     myhost=hidden.lower()
    319
selection undefined, radio undefined
<type 'exceptions.NameError'>: name 'radio' is not defined
      args = ("name 'radio' is not defined",)
      message = "name 'radio' is not defined"

Kinda stuck, I have the backups just no way to restore
Author:  jams [ Tue Jul 16, 2013 7:54 am ]
Post subject:  Re: Unable to Restore Database
Do you get the same error when attempting to use the other radio buttons..like maybe WOL ? (it's harmless)


Also the restore can be run from the command line.

/usr/LH/bin/lh_system_restore_job $filename cleanup

$filename is the name or the file to restore WITHOUT the full path, just the filename
The file must be in /data/storage/disk0/backup/system_backups
Author:  jams [ Tue Jul 16, 2013 8:11 am ]
Post subject:  Re: Unable to Restore Database
Looks like that error is showing up because the submitted form is blank. What browser are you using?
Author:  RacerX [ Tue Jul 16, 2013 11:00 am ]
Post subject:  Re: Unable to Restore Database
Using command line instead of Chromium Mythweb

as root
Code:
/usr/LH/bin/lh_system_restore_job backup.2013-07-13_21-50.tgz cleanup


script works fine but when I reboot "Waiting for connection to MythBackend" over and over

manually run
Code:
mythfrontend 


the select your country flags come out

In the command line it says

Code:
2013-07-16 11:43:12.955105 E  Error preparing query: SELECT data FROM settings WHERE value = :KEY AND hostname IS NULL
2013-07-16 11:43:12.955124 E  Driver error was [2/1146]:
QMYSQL3: Unable to prepare statement
Database error was:
Table 'mythconverg.settings' doesn't exist
Author:  jams [ Tue Jul 16, 2013 11:12 am ]
Post subject:  Re: Unable to Restore Database
So either the database didn't restore or it's pointing to the wrong address.
What do these commands show
mysql -e "show databases"

mysql mythconverg -e "show tables"
Author:  RacerX [ Tue Jul 16, 2013 11:34 am ]
Post subject:  Re: Unable to Restore Database
Code:
mysql -e "show databases


Code:
Database            |
+---------------------+
| information_schema  |
| #mysql50#lost+found |
| mysql               |
| mythconverg         |
| ncid                |
| performance_schema  |
| test                |
+---------------------+


Code:
mysql mythconverg -e "show tables"

Code:
+---------------------------+
| Tables_in_mythconverg     |
+---------------------------+
| archiveitems              |
| callsignnetworkmap        |
| capturecard               |
| cardinput                 |
| channel                   |
| channelgroup              |
| channelgroupnames         |
| channelscan               |
| channelscan_channel       |
| channelscan_dtv_multiplex |
| codecparams               |
| credits                   |
| customexample             |
| diseqc_config             |
| diseqc_tree               |
| displayprofilegroups      |
| dtv_multiplex             |
| dtv_privatetypes          |
| dvdbookmark               |
| dvdinput                  |
| dvdtranscode              |
| eit_cache                 |
| filemarkup                |
| gallerymetadata           |
| gamemetadata              |
| gameplayers               |
| housekeeping              |
| inputgroup                |
| internetcontent           |
| internetcontentarticles   |
| inuseprograms             |
| jobqueue                  |
| jumppoints                |
| jumppoints_default_1      |
| jumppoints_default_2      |
| jumppoints_user1          |
| jumppoints_user2          |
| jumppoints_user3          |
| keybindings               |
| keybindings_default_1     |
| keybindings_default_2     |
| keybindings_user1         |
| keybindings_user2         |
| keybindings_user3         |
| keyword                   |
| livestream                |
| logging                   |
| schemalock                |
+---------------------------+
Author:  jams [ Tue Jul 16, 2013 11:40 am ]
Post subject:  Re: Unable to Restore Database
The mythconverg database looks like half the tables are there which is the problem.
Do you have another file that you could restore from?
Author:  RacerX [ Tue Jul 16, 2013 12:24 pm ]
Post subject:  Re: Unable to Restore Database
/usr/LH/bin/lh_system_restore_job backup.2013-07-08_01-03.tgz cleanup

Code:
mysql -e "show databases


Code:
+---------------------+
| Database            |
+---------------------+
| information_schema  |
| #mysql50#lost+found |
| mysql               |
| mythconverg         |
| ncid                |
| performance_schema  |
| test                |
+---------------------+


Code:
mysql mythconverg -e "show tables"

Code:
+---------------------------+
| Tables_in_mythconverg     |
+---------------------------+
| archiveitems              |
| callsignnetworkmap        |
| capturecard               |
| cardinput                 |
| channel                   |
| channelgroup              |
| channelgroupnames         |
| channelscan               |
| channelscan_channel       |
| channelscan_dtv_multiplex |
| codecparams               |
| credits                   |
| customexample             |
| diseqc_config             |
| diseqc_tree               |
| displayprofilegroups      |
| displayprofiles           |
| dtv_multiplex             |
| dtv_privatetypes          |
| dvdbookmark               |
| dvdinput                  |
| dvdtranscode              |
| eit_cache                 |
| filemarkup                |
| gallerymetadata           |
| gamemetadata              |
| gameplayers               |
| housekeeping              |
| inputgroup                |
| internetcontent           |
| internetcontentarticles   |
| inuseprograms             |
| jobqueue                  |
| jumppoints                |
| jumppoints_default_1      |
| jumppoints_default_2      |
| jumppoints_user1          |
| jumppoints_user2          |
| jumppoints_user3          |
| keybindings               |
| keybindings_default_1     |
| keybindings_default_2     |
| keybindings_user1         |
| keybindings_user2         |
| keybindings_user3         |
| keyword                   |
| livestream                |
| logging                   |
| schemalock                |
+---------------------------+

Code:
ls -l /data/storage/disk0/backup/system_backups/

Code:
total 10963096
drwxr-xr-x 5 root root        130 Jul 14 22:56 2013-07-14_22-56
-rw-r--r-- 1 root root 1217402008 Jul  3 22:26 backup.2013-07-03_22-23.tgz
-rw-r--r-- 1 root root 1218068004 Jul  4 21:15 backup.2013-07-04_21-13.tgz
-rw-r--r-- 1 root root 1755212081 Jul  6 22:20 backup.2013-07-06_22-16.tgz
-rw-r--r-- 1 root root 1755015631 Jul  8 01:07 backup.2013-07-08_01-03.tgz
-rw-r--r-- 1 root root 1757406802 Jul 13 21:54 backup.2013-07-13_21-50.tgz
-rw-r--r-- 1 root root 1761941667 Jul 16 01:12 backup.2013-07-16_01-08.tgz
-rw-r--r-- 1 root root 1761145209 Jul 16 01:21 backup.2013-07-16_01-17.tgz
-rw-r--r-- 1 root root         20 Jul 16 01:29 backup.2013-07-16_01-26.tgz
drwxr-xr-x 3 root root        125 Jul 16 13:05 restore


still stuck
Author:  RacerX [ Wed Jul 17, 2013 4:36 pm ]
Post subject:  Re: Unable to Restore Database
Update

Today completely reloaded my system from scratch. Then restored backup.2013-07-04_21-13,tgz
This is what occurs at the beginning of the system restore.


Code:
/usr/LH/bin/lh_system_restore_job backup.2013-07-04_21-13.tgz cleanup

Full restore
---------------------------------

    Stopping mythbackend

Restoring database  2013-07-04_21-13
Restore of mythconverg complete

ERROR 1008 (HY000) at line 1: Can't drop database 'ncid'; database doesn't exist
Restoring database  2013-07-04_21-13
Restore of ncid complete

    Starting mythbackend

***    WILL RUN ALL MODULES   ***
____Start of network____
    Setting up the network
    Checking nss-mdns for install
    nss-mdns is already installed, will not install


Unfortunately doesn't work and wrecks mythconverge.

Back to the flags again UGH!

Next I decided to restore today's backup. This one has nothing in the database and it restores correctly. So still unable to restore database :cry:
Author:  jams [ Thu Jul 18, 2013 7:44 am ]
Post subject:  Re: Unable to Restore Database
Would you be able to send me one of the backup files that doesn't work?
Author:  RacerX [ Thu Jul 18, 2013 12:23 pm ]
Post subject:  Re: Unable to Restore Database
Point me to the link then I will upload the backup to you....
Author:  jams [ Thu Jul 18, 2013 2:05 pm ]
Post subject:  Re: Unable to Restore Database
Assuming the file is less the 50MB Email it to jams at linhes.org
Author:  RacerX [ Thu Jul 18, 2013 2:55 pm ]
Post subject:  Re: Unable to Restore Database
Code:
[quote]Select all
    total 10963096
    drwxr-xr-x 5 root root        130 Jul 14 22:56 2013-07-14_22-56
    -rw-r--r-- 1 root root 1217402008 Jul  3 22:26 backup.2013-07-03_22-23.tgz
    -rw-r--r-- 1 root root 1218068004 Jul  4 21:15 backup.2013-07-04_21-13.tgz
    -rw-r--r-- 1 root root 1755212081 Jul  6 22:20 backup.2013-07-06_22-16.tgz
    -rw-r--r-- 1 root root 1755015631 Jul  8 01:07 backup.2013-07-08_01-03.tgz
    -rw-r--r-- 1 root root 1757406802 Jul 13 21:54 backup.2013-07-13_21-50.tgz
    -rw-r--r-- 1 root root 1761941667 Jul 16 01:12 backup.2013-07-16_01-08.tgz
    -rw-r--r-- 1 root root 1761145209 Jul 16 01:21 backup.2013-07-16_01-17.tgz
    -rw-r--r-- 1 root root         20 Jul 16 01:29 backup.2013-07-16_01-26.tgz
    drwxr-xr-x 3 root root        125 Jul 16 13:05 restore[/quote]
Author:  jams [ Thu Jul 18, 2013 3:42 pm ]
Post subject:  Re: Unable to Restore Database
if you unzip one of those files how large is mythconverg ?
Author:  RacerX [ Thu Jul 18, 2013 4:48 pm ]
Post subject:  Re: Unable to Restore Database
Code:
total 1268240
-rw-r--r--  1 root root   44500545 Jul  5 02:13 all_databases
drwxrwxr-x 88 root root       8192 Jun 24 17:20 etc
-rw-r--r--  1 root root 1209651649 Jul  5 02:14 home_dir.tar.gz
-rw-r--r--  1 root root    2964319 Jul  5 02:13 mysql_table
-rw-r--r--  1 root root   41537003 Jul  5 02:13 mythconverg
-rw-r--r--  1 root root       2018 Jul  5 02:13 ncid
drwxr-xr-x  3 root root         23 Jun  8 19:37 pki
drwxr-xr-x  4 root root         45 Jun  8 19:37 settings
Page 1 of 2 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/