On 12/05/2011 03:49 PM, Martin Steigerwald wrote:

> > Am Freitag, 2. Dezember 2011 schrieb Michael Strobel:
>> >> InnoDB: Last MySQL binlog file position 0 2654, file name
>> >> ./mysql-bin.000003 111201 14:18:26  InnoDB: Started; log sequence
>> >> number 0 8713003 111201 14:18:26 [Warning] Can't open and lock time
>> >> zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying
>> >> to live without them 111201 14:18:26 [ERROR] Can't open and lock
>> >> privilege tables: Table 'mysql.servers' doesn't exist 111201 14:18:26
>> >> [Note] /usr/sbin/mysqld: ready for connections. Version:
>> >> '5.1.58-1'  socket:
>> >> '/home/michael/.local/share/akonadi/socket-MacBook/mysql.socket'  port
>> >> : 0  (Debian) InnoDB: Error: Removing element from mem pool free list
>> >> 64 though the InnoDB: element is not marked free!
>> >> InnoDB: Apparent memory corruption: mem dump  len 500; hex
>> >> 0000000000000000000000000000000000000000000000000000000000000000000000
> > […]
>> >> asc                                                                   
>> >>          |       P               =w_                                   
>> >>                                                                        
>> >>           0        t              1C              0|      (C       =w_ 
>> >>                                                                        
>> >>                                                                        
>> >>                                                                        
>> >>         ; InnoDB: Scanning backward trying to find previous allocated
>> >> mem blocks 111201 14:18:26 - mysqld got signal 11 ;
>> >> This could be because you hit a bug. It is also possible that this
>> >> binary or one of the libraries it was linked against is corrupt,
>> >> improperly built, or misconfigured. This error can also be caused by
>> >> malfunctioning hardware. We will try our best to scrape up some info
>> >> that will hopefully help diagnose the problem, but since we have
>> >> already crashed, something is definitely wrong and this may fail.
> > This and the following doesn´t look like a KDE problem at all.
> >
> > Did you have a sudden power outage or crash in the last time. I´ve heard 
> > reports that MySQL with the default configuration that Akonadi uses for it 
> > is prone to database corruptions after such occurences.
> >
> > Here Kontact works with KDE 4.7.2. But I am using a system-wide PostgreSQL 
> > database for it.
> >
> > As long as only contacts are stored in Akonadi it should be possible to 
> > do:
> >
> > 1) akonadictl stop
> > 2) mv .local/share/akonadi ls -l .local/share/akonadi-broken
> > 3) akonadictl start
> >
> > Otherwise you would need to repair the database manually for now. Maybe 
> > its sufficient to remove the binlog file(s) - in that case you will loose 
> > some changes to the databases.
> >
> > But AFAIR even with mail, there is nothing in there, that couldn´t be 
> > rebuilt from source.
> >
> > Ciao,
Hello,

indeed i had to do a hard reset some days ago your workaround helped.
Thank you very much.

regards
Michael


Reply via email to