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
