[mythtvnz] Corrupt database?

[Nick Rout]

On Wed, Jan 23, 2013 at 8:35 PM, Paulgir <paulgir at gmail.com> wrote:

>
> When I checked Mythtv (Mythbuntu)today I found it showing a language set
> up window that I had not seen before.I closed this window and was on the
> xfce desktop,I tried to start Myth frontend or mythbackend setup it reverts
> to the language set-up window.
> I tried to do a database restore but I get this message:
>
>
What makes you think there is a database problem. Check systematically that:

1. mysql is running on the backend
2. mythbackend ditto
3. you have network connectivity to the backend.
4. whether there are any crashed database tables that need repair. HINT if
you are on mythbuntu run /etc/cron.weekly/mythtv-database
5. whether your ~/.mythtv/mysql.txt and ~/.mythtv/config.xml files have the
right info.
6. Look, yes look, at the logging file - particularly
/var/log/mythtv/mythfrontend.log, or start mythfrontend from the command
line and read the output.




> Database Information:
>          DBHostName: localhost
>              DBPort: 3306
>          DBUserName: mythtv
>          DBPassword: XXX
>              DBName: mythconverg
>         DBSchemaVer:
>   DBBackupDirectory: /var/lib/mythtv/db_backups
>    DBBackupFilename: mythconverg-1299-**20130122184502.sql.gz
>       drop_database: no
>     create_database: no
>
> Executables:
>        mysql_client: mysql
>          uncompress: gzip -d
>
> Miscellaneous:
>     partial_restore: no
>    restore_xmltvids: no
>     change_hostname: no
>
> Checking database.
>
> Found 105 tables in the database.
> WARNING: Database not empty.
>
> ERROR: Unable to do a full restore. The database contains data
>
>
>
>
>
> So what am I doing wrong - any suggestions?
>
> The reason I tried to do a db restore was because I got some error
> messages when I tried myth_fill_database:
>
>
>
>
>
>
>
> This version of MythTV requires an updated database. (schema is 1299
> versions behind)
>
> Please run mythtv-setup or mythbackend to update your database.
>
> Database Host: localhost
> Database Name: mythconverg
>
> 2013-01-23 19:49:17.500860 C  ERROR: Unable to acquire database upgrade
> lock
> 2013-01-23 19:49:17.500869 C  Waiting for Database Upgrade to complete.
> 2013-01-23 19:49:17.500880 C  Timed out waiting.
> 2013-01-23 19:49:17.500919 E  Not allowed to upgrade the database.
> 2013-01-23 19:49:17.502557 E  Incorrect database schema
> 2013-01-23 19:49:17.503042 E  Error preparing query: INSERT INTO logging
>   (host, application, pid, tid, thread, filename,      line, function,
> msgtime, level, message) VALUES (:HOST, :APP, :PID, :TID, :THREAD,
> :FILENAME,         :LINE, :FUNCTION, :MSGTIME, :LEVEL, :MESSAGE)
> mythfilldatabase
>
>
>
>
> Or is this a good time to install Mythbuntu 12.04?
>
> ______________________________**_________________
> mythtvnz mailing list
> mythtvnz at lists.linuxnut.co.nz
> http://lists.ourshack.com/**mailman/listinfo/mythtvnz<http://lists.ourshack.com/mailman/listinfo/mythtvnz>
> Archives http://www.gossamer-threads.**com/lists/mythtv/mythtvnz/<http://www.gossamer-threads.com/lists/mythtv/mythtvnz/>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ourshack.com/pipermail/mythtvnz/attachments/20130123/7e6e6f24/attachment.html>