List:Falcon Storage Engine« Previous MessageNext Message »
From:Lars-Erik Bjørk Date:July 16 2009 8:31am
Subject:Re: Possible reason for the eternal loop in addIndexEntry?
View as plain text  
Well, I can't seem to get a core file from this. If I run it in the 
debugger, it clams we get a segmentation fault
with the following odd looking stack:

#0  handle_segfault (sig=32697) at mysqld.cc:2568
#1  <signal handler called>
#2  0x00000000009b6a98 in Sync::lock (this=0x7fb9a51a9e10, 
type=Exclusive) at Sync.cpp:58
#3  0x0000000000a51d22 in PriorityScheduler::finished 
(this=0x7fb9a3da8d58, priority=1) at PriorityScheduler.cpp:66
#4  0x0000000000a51c6b in Priority::finished (this=0x7fb9a51a9fa0) at 
Priority.cpp:40
#5  0x00000000009e56b8 in Cache::ioThread (this=0x7fb9a3fd4408) at 
Cache.cpp:916
#6  0x00000000009e5b6f in Cache::ioThread (arg=0x7fb9a3fd4408) at 
Cache.cpp:780
#7  0x00000000009cce5d in Thread::thread (this=0x7fb9a3da8e38) at 
Thread.cpp:167
#8  0x00000000009cd0a1 in Thread::thread (parameter=0x7fb9a3da8e38) at 
Thread.cpp:146
#9  0x00007fb9a63243ba in start_thread () from /lib/libpthread.so.0
#10 0x00007fb9a5290fcd in clone () from /lib/libc.so.6
#11 0x0000000000000000 in ?? ()

If I run it outside the debugger, we get the following message from 
mysqld 3 minutes and 15 seconds into the
recovery (the last lines):

090716 10:20:57 [ERROR] Can't open the mysql.plugin table. Please run 
mysql_upgrade to create it.
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
090716 10:24:09  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
090716 10:24:10  InnoDB: Log file ./ib_logfile0 did not exist: new to be 
created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
090716 10:24:10  InnoDB: Log file ./ib_logfile1 did not exist: new to be 
created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
090716 10:24:10  InnoDB: Started; log sequence number 0 0
090716 10:24:10 [ERROR] Fatal error: Can't open and lock privilege 
tables: Table 'mysql.host' doesn't exist

Any idea?


Ann W. Harrison wrote:
> Lars-Erik Bjørk wrote:
>> Hi all,
>>
>> ...
>>
>> Does this sound like a plausible theory?
>>
>
> YES!
>
> Now tell us about the next crash...
>
>
> Cheers,
>
> Ann

Thread
Possible reason for the eternal loop in addIndexEntry?Lars-Erik Bjørk14 Jul
  • Re: Possible reason for the eternal loop in addIndexEntry?Kevin Lewis14 Jul
  • Gold Star for LarsJim Starkey14 Jul
    • Re: Gold Star for LarsLars-Erik Bjørk15 Jul
Re: Possible reason for the eternal loop in addIndexEntry?Lars-Erik Bjørk16 Jul