Mailing List Archive: MythTV: Users

Mythconverg_restore corrupted my database?

Index | Next | Previous | View Threaded

widget at stdin

Jun 18, 2010, 10:47 AM

Post #1 of 6 (557 views)
Permalink

Mythconverg_restore corrupted my database?

Hi all,

I've got a database problem I'm hoping you can shed light on. It revolves
around a failed 0.23 upgrade. Right now I don't care why the upgrade failed,
but mythfrontend segfaults instead of playing video. I will provide
backtraces some other time.

I'm running 0.22-fixes (r24255) on a Gentoo machine that's running the proper
utf8 mysql database. I partial restored to upgrade from 0.21 to 0.22 so
that's all sorted.

I take backups nightly of the db and I performed the upgrade on Monday which
took another one. As I've said 0.23 (r23069) didn't work so I dropped the
database and restored the backup. I had another go today, with an upgraded
and rebuilt Qt (4.6.3) and it still didn't work, so I dropped and tried to
restore.

All the backups taken since my failed upgrade on Monday will not restore due
to duplicate keys of foreign names such as "ERROR 1062 (23000) at line 1667:
Duplicate entry 'Zin?dine Zidane' for key 2". The dumps all have two entries
for Zinadine Zidane now, as opposed to the dump from Monday which did not.

I can restore Monday's backup and lose DB changes since Monday, but all the
duplicate entries will presumably return, and all backups taken will be
corrupt and therefore useless.

Appended are the database re-creation script I used and the status of the
failed restore.

Help!

Widget.

--
CREATE DATABASE IF NOT EXISTS mythconverg;
GRANT ALL ON mythconverg.* TO mythtv [at] localhos IDENTIFIED BY "mythtv";
FLUSH PRIVILEGES;
GRANT CREATE TEMPORARY TABLES ON mythconverg.* TO mythtv [at] localhos IDENTIFIED
BY "mythtv";
FLUSH PRIVILEGES;
ALTER DATABASE mythconverg DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

--
Connection id: 225700
Current database: mythconverg
Current user: mythtv [at] localhos
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.0.90 Gentoo Linux mysql-5.0.90-r2
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: utf8
Client characterset: latin1
Conn. characterset: latin1
UNIX socket: /var/run/mysqld/mysqld.sock
Uptime: 42 days 6 hours 22 min 4 sec
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

kkuphal at gmail

Jun 18, 2010, 11:31 AM

Post #2 of 6 (526 views)
Permalink

Re: Mythconverg_restore corrupted my database? [In reply to]

On Fri, Jun 18, 2010 at 12:47 PM, Stephen Bridges <widget [at] stdin>wrote:

> Hi all,
>
> I've got a database problem I'm hoping you can shed light on. It revolves
> around a failed 0.23 upgrade. Right now I don't care why the upgrade
> failed,
> but mythfrontend segfaults instead of playing video. I will provide
> backtraces some other time.
>

Not to ignore your other problems but I had this issue when upgrading and I
simply removed all libmyth* from my system and reinstalled 0.23 and it
worked fine after that. If you didn't clear out the 0.22 files, it seems
this can happen.

Kevin

widget at stdin

Jun 18, 2010, 2:28 PM

Post #3 of 6 (507 views)
Permalink

Re: Mythconverg_restore corrupted my database? [In reply to]

On Friday 18 June 2010 19:31:34 Kevin Kuphal wrote:
> On Fri, Jun 18, 2010 at 12:47 PM, Stephen Bridges <widget [at] stdin>wrote:
> > Hi all,
> >
> > I've got a database problem I'm hoping you can shed light on. It
> > revolves around a failed 0.23 upgrade. Right now I don't care why the
> > upgrade failed,
> > but mythfrontend segfaults instead of playing video. I will provide
> > backtraces some other time.
>
> Not to ignore your other problems but I had this issue when upgrading and I
> simply removed all libmyth* from my system and reinstalled 0.23 and it
> worked fine after that. If you didn't clear out the 0.22 files, it seems
> this can happen.

Was it a segfault in QtCore you had? I don't quite understand your solution -
is that just emerge -C mythtv && emerge mythtv to cleanly remove and install?

It's pretty academic though unfortunately as I'm not going to try an upgrade
as at the moment I can't undo it if it goes wrong now. I don't quite
understand how a table that doesn't allow duplicates can have duplicates in
it?

W.

--
Program received signal SIGSEGV, Segmentation fault.
0x00007ffff4a966a4 in QMutex::lock() () from /usr/lib64/qt4/libQtCore.so.4
(gdb) backtrace full
#0 0x00007ffff4a966a4 in QMutex::lock() () from /usr/lib64/qt4/libQtCore.so.4
No symbol table info available.
#1 0x00007ffff76b2b81 in QMutexLocker::relock (testbuf=0x7fffffef8f00 "G@",
filename=..., testbufsize=2048) at /usr/include/qt4/QtCore/qmutex.h:120
No locals.
#2 QMutexLocker (testbuf=0x7fffffef8f00 "G@", filename=..., testbufsize=2048)
at /usr/include/qt4/QtCore/qmutex.h:102
No locals.
#3 AvFormatDecoder::CanHandle (testbuf=0x7fffffef8f00 "G@", filename=...,
testbufsize=2048) at avformatdecoder.cpp:1007
locker = {val = 23729008}
probe = {filename = 0x800 <Address 0x800 out of bounds>, buf =
0x288e6b0 "\360\003\332\367\377\177", buf_size = 1}
fname = {static shared_null = {ref = {_q_value = 8}, alloc = 0, size =
0, data = 0x7ffff4e8c738 "", array = ""}, static shared_empty = {ref =
{_q_value = 4}, alloc = 0, size = 0, data = 0x7ffff4e8c758 "", array = ""}, d
= 0x20424c0}
score = <value optimized out>
#4 0x00007ffff767e982 in NuppelVideoPlayer::OpenFile (this=0x288e6b0,
skipDsp=<value optimized out>, retries=<value optimized out>,
allow_libmpeg2=<value optimized out>) at NuppelVideoPlayer.cpp:1205
testbuf =
"G@\000\024\000\000\260\r\a\372\305\000\000\000\001\341\003\006\201\0
25\360\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\
377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377
\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\37
7\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\3
77\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\
377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377GA\003\026\000\002\260\332\000\001\341\000\000\351\001\360\000\002\351\001\360\017R\001\001_\004OTV\000\376\004VID1\004\351\002\360\025\n\004eng\000_\004OTV\000\376\004AUD1R\001\224\004\351\003\360\t\n\004NAR\000R\001\225\006\351\004\360\017V\neng\020\210eng\t\000R\001A\006\351\005\360\rY\beng\020\000\002\000\002R\001\021\005\351\006\360\017_\004OTV\000\220\001\227\376\004TGT\000\005\357\000\360\fR\001Q_\004FSAT\321\001\a\005\357\001\360\rR\001R_\004FSAT\321\002\003\004\005\357\002\360\fR\001S_\004FSAT\321\001\001\005G\001\003\027\357\003\360\fR\001T_\004FSAT\321\001\002\005\357\004\360\rR\001U_\004FSAT\321\002\005"...
testreadsize = 2048
ret = <value optimized out>
#5 0x00007ffff7698287 in PlayerContext::CreateNVP (this=0x268eb90,
tv=0x26505a0, widget=<value optimized out>,
desiredState=kState_WatchingPreRecorded, embedwinid=0, embedbounds=0x268ed28,
muted=<value optimized out>) at playercontext.cpp:485
exact_seeking = <value optimized out>
_nvp = 0x288e6b0
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

widget at stdin

Jun 21, 2010, 12:15 PM

Post #4 of 6 (481 views)
Permalink

Re: Testing UTF-8 [In reply to]

> It's pretty academic though unfortunately as I'm not going to try an
> upgrade as at the moment I can't undo it if it goes wrong now. I don't
> quite understand how a table that doesn't allow duplicates can have
> duplicates in it?

Given the lack of any other ideas, I've upgraded to 0.23 but not let Gentoo
keep old libraries back as part of its preserved-rebuild, and lo and behold it
works.

Still have multiple entries in it. I notice that whenever text appears
anywhere in the application that's supposed to have an accent on it, or other
extended character, it isn't visible. It never has been. Is this correct?

I also can't see which of the duplicates are correct as mysql set to latin1
can't differ between them.

Does setting the locale affect either the front or backend?

Widget.
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

mtdean at thirdcontact

Jun 21, 2010, 12:33 PM

Post #5 of 6 (475 views)
Permalink

Re: Testing UTF-8 [In reply to]

On 06/21/2010 03:15 PM, Stephen Bridges wrote:
>> It's pretty academic though unfortunately as I'm not going to try an
>> upgrade as at the moment I can't undo it if it goes wrong now. I don't
>> quite understand how a table that doesn't allow duplicates can have
>> duplicates in it?
>>
> Given the lack of any other ideas, I've upgraded to 0.23 but not let Gentoo
> keep old libraries back as part of its preserved-rebuild, and lo and behold it
> works.
>
> Still have multiple entries in it. I notice that whenever text appears
> anywhere in the application that's supposed to have an accent on it, or other
> extended character, it isn't visible. It never has been. Is this correct?
>
> I also can't see which of the duplicates are correct as mysql set to latin1
> can't differ between them.
>
> Does setting the locale affect either the front or backend?
>

If you're currently on 0.22-fixes or higher, you shouldn't have any
problems related to character encoding.

If you're saying you reverted back to 0.21-fixes after a failed
0.22-fixes upgrade, you may.

Note, also, that you can /not/ use a partial restore to "merge" data
from multiple databases into a single database. There is no supported
procedure for merging the data. Instead, you would need to use
MythArchive to do "native" exports of the recordings you want to keep
from one system (the one with fewer recordings) and then import them
back into MythTV.

If that doesn't answer your question, there are so many possible bad
things that could have happened to your DB that the only way (and the
easiest way) to tell you what's wrong and how to fix it is for you to
send me (directly--off list) a link to the database backup. I may not
be able to get time to analyze it for a day or 2, but I will take a look.

Mike
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

widget at stdin

Jun 28, 2010, 2:42 PM

Post #6 of 6 (429 views)
Permalink

Re: Testing UTF-8 [In reply to]

> If you're currently on 0.22-fixes or higher, you shouldn't have any
> problems related to character encoding.
>
> If you're saying you reverted back to 0.21-fixes after a failed
> 0.22-fixes upgrade, you may.

When I originally posted I was on 0.22-fixes. I'm now on 0.23-fixes.

> Note, also, that you can /not/ use a partial restore to "merge" data
> from multiple databases into a single database. There is no supported
> procedure for merging the data. Instead, you would need to use
> MythArchive to do "native" exports of the recordings you want to keep
> from one system (the one with fewer recordings) and then import them
> back into MythTV.

Noted. I don't think I've done that. The only partial restore I did was when
going from 0.21 to 0.22 due to the problems with default Gentoo MySQL configs.
Which I've fixed.

> If that doesn't answer your question, there are so many possible bad
> things that could have happened to your DB that the only way (and the
> easiest way) to tell you what's wrong and how to fix it is for you to
> send me (directly--off list) a link to the database backup. I may not
> be able to get time to analyze it for a day or 2, but I will take a look.

Yes, I will mail you one soon. Thanks for your time.

Widget.
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads