From: Lars-Erik Bjørk
Date: July 16 2009 8:31am
Subject: Re: Possible reason for the eternal loop in addIndexEntry?
List-Archive: http://lists.mysql.com/falcon/795
Message-Id: <4A5EE572.9030802@sun.com>
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset=ISO-8859-1
Content-Transfer-Encoding: 8BIT

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