List:Falcon Storage Engine« Previous MessageNext Message »
From:Ann W. Harrison Date:November 5 2008 9:21pm
Subject:deadlock between Falcon logging and server logging
View as plain text  
The attached file (assuming it doesn't get stripped) is
the "deadlock" I found last week between the Falcon
logging system and the server logging.  The situation was
completely trivial.  I had two connections, each with an
active transaction.  Both were using a single table with
three or four simple records.  One attempted to commit,
and the server froze.

The problem is between threads 1504, 3640, and 784.

784 is in Log::logMessage, trying to write out its commit message. It
can't get the critical section because

3640 has the critical section and is trying to execute an _unlock
after having written out scavenge statistics.  It can't move because

1504 is finishing an fflush and trying to _unlock_file after a server
write.

The attached file may have better formatting, given the wrap induced
by Thunderbird.

What I think we need to do is figure out how InnoDB writes its
messages and use that.

Best,

Ann




Here are the traces, etc. from the deadlock I found last week.  The situation
was remarkably simple.  



Thread states:

3652  main                                 _getptd                  Below Normal     0
940   io_handler_thread                    os_event_wait_multiple   Highest          0
2644  io_handler_thread                    os_event_wait_multiple   Highest          0
248   io_handler_thread                    os_event_wait_multiple   Highest          0
1800  io_handler_thread                    os_event_wait_multiple   Highest          0
2132  srv_lock_timeout_and_monitor_thread  os_thread_sleep          Highest          0

1504  srv_error_monitor_thread             _unlock_file             Highest          0

576   srv_master_thread                    os_event_wait_low        Highest          0
2568  Thread::thread                       Synchronize::sleep       Normal           0
3496  Thread::thread                       Synchronize::sleep       Normal           0
2760  Thread::thread                       Synchronize::sleep       Normal           0
3748  Thread::thread                       Synchronize::sleep       Normal           0
3160  Thread::thread                       Synchronize::sleep       Normal           0
3308  Thread::thread                       Synchronize::sleep       Normal           0
3908  Thread::thread                       Synchronize::sleep       Normal           0
3852  Thread::thread                       Synchronize::sleep       Normal           0
3116  Thread::thread                       Synchronize::sleep       Normal           0
3456  Thread::thread                        _write_lk               Normal           0
3460  Thread::thread                       Synchronize::sleep       Normal           0
204   Win32 Thread                         7c90e4f4                 Normal           0
1404  Win32 Thread                         7c90e4f4                 Normal           0
2192  _threadstart                         handle_shutdown          Normal           0

3640  _threadstart                         _unlock                  Normal           0

984   _threadstart                         _heap_alloc_dbg          Normal           0

784   _threadstart                         Log::logMessage          Highest          0

2244  _threadstart                         vio_read                 Normal           0



Thread call stacks

Thread 3652
 	ntdll.dll!7c90e4f4() 	
 	ntdll.dll!7c90df2c() 	
 	kernel32.dll!7c809574() 	
>	mysqld.exe!_getptd()  Line 319	C
 	kernel32.dll!7c80a105() 	
 	mysqld.exe!pthread_cond_timedwait(pthread_cond_t * cond=0x00f4fde0,
_RTL_CRITICAL_SECTION * mutex=0x00f4f6d8, timespec * abstime=0x00000000)  Line 124 +
0x17	C
 	mysqld.exe!pthread_cond_wait(pthread_cond_t * cond=0x00f4fde0, _RTL_CRITICAL_SECTION *
mutex=0x00f4f6d8)  Line 71 + 0xf	C
 	mysqld.exe!handle_connections_methods()  Line 4429 + 0xf	C++
 	mysqld.exe!win_main(int argc=30, char * * argv=0x015639d0)  Line 4699	C++
 	mysqld.exe!mysql_service(void * p=0x00000000)  Line 4749 + 0x12	C++
 	mysqld.exe!main(int argc=30, char * * argv=0x015639d0)  Line 4922 + 0x7	C++
 	mysqld.exe!mainCRTStartup()  Line 259 + 0x19	C
 	kernel32.dll!7c817067() 	

Thread 940
 	ntdll.dll!7c90e4f4() 	
 	ntdll.dll!7c90df2c() 	
 	kernel32.dll!7c809574() 	
 	kernel32.dll!7c80a105() 	
>	mysqld.exe!os_event_wait_multiple(unsigned long n=32, void * *
> native_event_array=0x02642d70)  Line 499 + 0x14	C
 	mysqld.exe!os_aio_windows_handle(unsigned long segment=0, unsigned long pos=0,
fil_node_struct * * message1=0x033cff90, void * * message2=0x033cff84, unsigned long *
type=0x033cff78)  Line 3718 + 0x1a	C
 	mysqld.exe!fil_aio_wait(unsigned long segment=0)  Line 4236 + 0x17	C
 	mysqld.exe!io_handler_thread(void * arg=0x00f66340)  Line 435 + 0x9	C
 	kernel32.dll!7c80b713() 	

Thread 2644
 	ntdll.dll!7c90e4f4() 	
 	ntdll.dll!7c90df2c() 	
 	kernel32.dll!7c809574() 	
 	kernel32.dll!7c80262a() 	
 	kernel32.dll!7c80262a() 	
 	kernel32.dll!7c802600() 	
 	kernel32.dll!7c80a105() 	
>	mysqld.exe!os_event_wait_multiple(unsigned long n=32, void * *
> native_event_array=0x02644568)  Line 499 + 0x14	C
 	mysqld.exe!os_aio_windows_handle(unsigned long segment=0, unsigned long pos=0,
fil_node_struct * * message1=0x034cff90, void * * message2=0x034cff84, unsigned long *
type=0x034cff78)  Line 3718 + 0x1a	C
 	mysqld.exe!fil_aio_wait(unsigned long segment=1)  Line 4236 + 0x17	C
 	mysqld.exe!io_handler_thread(void * arg=0x00f66344)  Line 435 + 0x9	C
 	kernel32.dll!7c80b713() 	

Thread 248
 	ntdll.dll!7c90e4f4() 	
 	ntdll.dll!7c90df2c() 	
 	kernel32.dll!7c809574() 	
 	kernel32.dll!7c80a105() 	
>	mysqld.exe!os_event_wait_multiple(unsigned long n=32, void * *
> native_event_array=0x02645d68)  Line 499 + 0x14	C
 	mysqld.exe!os_aio_windows_handle(unsigned long segment=0, unsigned long pos=0,
fil_node_struct * * message1=0x035cff90, void * * message2=0x035cff84, unsigned long *
type=0x035cff78)  Line 3718 + 0x1a	C
 	mysqld.exe!fil_aio_wait(unsigned long segment=2)  Line 4236 + 0x17	C
 	mysqld.exe!io_handler_thread(void * arg=0x00f66348)  Line 435 + 0x9	C
 	kernel32.dll!7c80b713() 	

Thread 1800
 	ntdll.dll!7c90e4f4() 	
 	ntdll.dll!7c90df2c() 	
 	kernel32.dll!7c809574() 	
 	kernel32.dll!7c80a105() 	
>	mysqld.exe!os_event_wait_multiple(unsigned long n=32, void * *
> native_event_array=0x02647560)  Line 499 + 0x14	C
 	mysqld.exe!os_aio_windows_handle(unsigned long segment=0, unsigned long pos=0,
fil_node_struct * * message1=0x036cff90, void * * message2=0x036cff84, unsigned long *
type=0x036cff78)  Line 3718 + 0x1a	C
 	mysqld.exe!fil_aio_wait(unsigned long segment=3)  Line 4236 + 0x17	C
 	mysqld.exe!io_handler_thread(void * arg=0x00f6634c)  Line 435 + 0x9	C
 	kernel32.dll!7c80b713() 	

Thread 2132
 	ntdll.dll!7c90e4f4() 	
 	ntdll.dll!7c90d1fc() 	
 	kernel32.dll!7c8023f1() 	
 	kernel32.dll!7c802455() 	
>	mysqld.exe!os_thread_sleep(unsigned long tm=1000000)  Line 272 + 0x15	C
 	mysqld.exe!srv_lock_timeout_and_monitor_thread(void * arg=0x00000000)  Line 1916 + 0xa	C
 	kernel32.dll!7c80b713() 	

Thread 1504
 	ntdll.dll!7c90e4f4() 	
 	ntdll.dll!7c90d1fc() 	
 	kernel32.dll!7c8023f1() 	
>	mysqld.exe!_unlock_file(void * pf=0x038cffdc)  Line 305 + 0x14	C
 	mysqld.exe!fflush(_iobuf * stream=0x00000000)  Line 72 + 0x9	C
 	kernel32.dll!7c802455() 	
 	mysqld.exe!os_thread_sleep(unsigned long tm=1000000)  Line 272 + 0x15	C
 	mysqld.exe!srv_error_monitor_thread(void * arg=0x00000000)  Line 2142 + 0xa	C
 	kernel32.dll!7c80b713() 	

Thread 576
 	ntdll.dll!7c90e4f4() 	
 	ntdll.dll!7c90df3c() 	
 	kernel32.dll!7c8025db() 	
 	kernel32.dll!7c802542() 	
>	mysqld.exe!os_event_wait_low(os_event_struct * event=0x015ed7e8, __int64
> reset_sig_count=0)  Line 389 + 0x10	C
 	mysqld.exe!srv_master_thread(void * arg=0x00000000)  Line 2631 + 0xd	C
 	kernel32.dll!7c80b713() 	

Thread 2568
 	ntdll.dll!7c90e4f4() 	
 	ntdll.dll!7c90df3c() 	
 	kernel32.dll!7c8025db() 	
 	kernel32.dll!7c802542() 	
>	mysqld.exe!Synchronize::sleep()  Line 100 + 0x14	C++
 	mysqld.exe!Cache::ioThread()  Line 953 + 0x13	C++
 	mysqld.exe!Cache::ioThread(void * arg=0x03e90b88)  Line 767	C++
 	mysqld.exe!Thread::thread()  Line 167 + 0xf	C++
 	mysqld.exe!Thread::thread(void * parameter=0x03e90ec8)  Line 147	C++
 	kernel32.dll!7c80b713() 	

Thread 3496
 	ntdll.dll!7c90e4f4() 	
 	ntdll.dll!7c90df3c() 	
 	kernel32.dll!7c8025db() 	
 	kernel32.dll!7c802542() 	
>	mysqld.exe!Synchronize::sleep()  Line 100 + 0x14	C++
 	mysqld.exe!Cache::ioThread()  Line 953 + 0x13	C++
 	mysqld.exe!Cache::ioThread(void * arg=0x03e90b88)  Line 767	C++
 	mysqld.exe!Thread::thread()  Line 167 + 0xf	C++
 	mysqld.exe!Thread::thread(void * parameter=0x03e90f78)  Line 147	C++
 	kernel32.dll!7c80b713() 	

Thread 2760
 	ntdll.dll!7c90e4f4() 	
 	ntdll.dll!7c90df3c() 	
 	kernel32.dll!7c8025db() 	
 	kernel32.dll!7c802542() 	
>	mysqld.exe!Synchronize::sleep(int milliseconds=1000, Mutex * callersMutex=0x00000000)
>  Line 147 + 0x13	C++
 	mysqld.exe!Synchronize::sleep(int milliseconds=1000)  Line 136 + 0x13	C++
 	mysqld.exe!Database::ticker()  Line 1886 + 0x12	C++
 	mysqld.exe!Database::ticker(void * database=0x03c80678)  Line 1876	C++
 	mysqld.exe!Thread::thread()  Line 167 + 0xf	C++
 	mysqld.exe!Thread::thread(void * parameter=0x03e98158)  Line 147	C++
 	kernel32.dll!7c80b713() 	

Thread 3748
 	ntdll.dll!7c90e4f4() 	
 	ntdll.dll!7c90df3c() 	
 	kernel32.dll!7c8025db() 	
 	kernel32.dll!7c802542() 	
>	mysqld.exe!Synchronize::sleep()  Line 100 + 0x14	C++
 	mysqld.exe!PageWriter::writer()  Line 171 + 0x13	C++
 	mysqld.exe!PageWriter::writer(void * arg=0x03e921d8)  Line 161	C++
 	mysqld.exe!Thread::thread()  Line 167 + 0xf	C++
 	mysqld.exe!Thread::thread(void * parameter=0x03e98208)  Line 147	C++
 	kernel32.dll!7c80b713() 	

Thread 3160
 	ntdll.dll!7c90e4f4() 	
 	ntdll.dll!7c90df3c() 	
 	kernel32.dll!7c8025db() 	
 	kernel32.dll!7c802542() 	
>	mysqld.exe!Synchronize::sleep()  Line 100 + 0x14	C++
 	mysqld.exe!Gopher::gopherThread()  Line 58 + 0x13	C++
 	mysqld.exe!Gopher::gopherThread(void * arg=0x03e921b0)  Line 38	C++
 	mysqld.exe!Thread::thread()  Line 167 + 0xf	C++
 	mysqld.exe!Thread::thread(void * parameter=0x03e98cb8)  Line 147	C++
 	kernel32.dll!7c80b713() 	

Thread 3308
 	ntdll.dll!7c90e4f4() 	
 	ntdll.dll!7c90df3c() 	
 	kernel32.dll!7c8025db() 	
 	kernel32.dll!7c802542() 	
>	mysqld.exe!Synchronize::sleep()  Line 100 + 0x14	C++
 	mysqld.exe!Gopher::gopherThread()  Line 58 + 0x13	C++
 	mysqld.exe!Gopher::gopherThread(void * arg=0x03e92188)  Line 38	C++
 	mysqld.exe!Thread::thread()  Line 167 + 0xf	C++
 	mysqld.exe!Thread::thread(void * parameter=0x03e98d68)  Line 147	C++
 	kernel32.dll!7c80b713() 	

Thread 3908
 	ntdll.dll!7c90e4f4() 	
 	ntdll.dll!7c90df3c() 	
 	kernel32.dll!7c8025db() 	
 	kernel32.dll!7c802542() 	
>	mysqld.exe!Synchronize::sleep()  Line 100 + 0x14	C++
 	mysqld.exe!Gopher::gopherThread()  Line 58 + 0x13	C++
 	mysqld.exe!Gopher::gopherThread(void * arg=0x03e92160)  Line 38	C++
 	mysqld.exe!Thread::thread()  Line 167 + 0xf	C++
 	mysqld.exe!Thread::thread(void * parameter=0x03e98e18)  Line 147	C++
 	kernel32.dll!7c80b713() 	

Thread 3852
 	ntdll.dll!7c90e4f4() 	
 	ntdll.dll!7c90df3c() 	
 	kernel32.dll!7c8025db() 	
 	kernel32.dll!7c802542() 	
>	mysqld.exe!Synchronize::sleep()  Line 100 + 0x14	C++
 	mysqld.exe!Gopher::gopherThread()  Line 58 + 0x13	C++
 	mysqld.exe!Gopher::gopherThread(void * arg=0x03e92138)  Line 38	C++
 	mysqld.exe!Thread::thread()  Line 167 + 0xf	C++
 	mysqld.exe!Thread::thread(void * parameter=0x03e98ec8)  Line 147	C++
 	kernel32.dll!7c80b713() 	

Thread 3116
 	ntdll.dll!7c90e4f4() 	
 	ntdll.dll!7c90df3c() 	
 	kernel32.dll!7c8025db() 	
 	kernel32.dll!7c802542() 	
>	mysqld.exe!Synchronize::sleep()  Line 100 + 0x14	C++
 	mysqld.exe!Gopher::gopherThread()  Line 58 + 0x13	C++
 	mysqld.exe!Gopher::gopherThread(void * arg=0x03e92110)  Line 38	C++
 	mysqld.exe!Thread::thread()  Line 167 + 0xf	C++
 	mysqld.exe!Thread::thread(void * parameter=0x03e98f78)  Line 147	C++
 	kernel32.dll!7c80b713() 	

Thread 3456
 	ntdll.dll!7c90e4f4() 	
 	ntdll.dll!7c90dacc() 	
 	ntdll.dll!7c912dc8() 	
 	kernel32.dll!7c81cbe6() 	
 	kernel32.dll!7c835669() 	
 	kernel32.dll!7c81cc23() 	
 	kernel32.dll!7c81cc23() 	
 	kernel32.dll!7c81cc5d() 	
 	kernel32.dll!7c81cc71() 	
 	kernel32.dll!7c810ea6() 	
 	kernel32.dll!7c810ea6() 	
>	mysqld.exe!_write_lk(int fh=1, const void * buf=0x026d4ed0, unsigned int cnt=105) 
> Line 180 + 0x3f	C
 	mysqld.exe!_write(int fh=1, const void * buf=0x026d4ed0, unsigned int cnt=105)  Line 79
+ 0x11	C
 	mysqld.exe!_flush(_iobuf * str=0x00f06c90)  Line 163 + 0x17	C
 	mysqld.exe!_ftbuf(int flag=1, _iobuf * str=0x00f06c90)  Line 153 + 0x9	C
 	mysqld.exe!printf(const char * format=0x00d115d8, ...)  Line 65 + 0xe	C
 	mysqld.exe!StorageInterface::logger(int mask=4, const char * text=0x066df9e4, void *
arg=0x00000000)  Line 2389 + 0xe	C++
 	mysqld.exe!Log::logMessage(int mask=4, const char * text=0x066df9e4)  Line 285 +
0x1d	C++
 	mysqld.exe!Log::log(int mask=4, const char * text=0x00d2bd40, char * args=0x066dfe14) 
Line 212 + 0x10	C++
 	mysqld.exe!Log::log(int mask=4, const char * txt=0x00d2bd40, ...)  Line 139 + 0x11	C++
 	mysqld.exe!TransactionManager::reportStatistics()  Line 403 + 0x35	C++
 	mysqld.exe!Database::scavenge()  Line 1757	C++
 	mysqld.exe!Scavenger::scavenge()  Line 64	C++
 	mysqld.exe!Scavenger::execute(Scheduler * scheduler=0x03e97520)  Line 69	C++
 	mysqld.exe!Scheduler::schedule()  Line 137 + 0x11	C++
 	mysqld.exe!Scheduler::schedule(void * lpParameter=0x03e97520)  Line 160	C++
 	mysqld.exe!Thread::thread()  Line 167 + 0xf	C++
 	mysqld.exe!Thread::thread(void * parameter=0x03ea9040)  Line 147	C++
 	kernel32.dll!7c80b713() 	

Thread 3460
 	ntdll.dll!7c90e4f4() 	
 	ntdll.dll!7c90df3c() 	
 	kernel32.dll!7c8025db() 	
 	kernel32.dll!7c802542() 	
>	mysqld.exe!Synchronize::sleep()  Line 100 + 0x14	C++
 	mysqld.exe!Scheduler::schedule()  Line 152 + 0xd	C++
 	mysqld.exe!Scheduler::schedule(void * lpParameter=0x03e97488)  Line 160	C++
 	mysqld.exe!Thread::thread()  Line 167 + 0xf	C++
 	mysqld.exe!Thread::thread(void * parameter=0x03ea9480)  Line 147	C++
 	kernel32.dll!7c80b713() 	
 	mysqld.exe!__InlineInterlockedCompareExchangePointer(void * volatile * Destination=,
void * ExChange=, void * Comperand=)  Line 1490 + 0x14	C++


Thread 204
>	ntdll.dll!7c90e4f4() 	
 	ntdll.dll!7c90da2c() 	
 	kernel32.dll!7c80a7d6() 	
 	vlsp.dll!10001cf3() 	
 	ntdll.dll!7c91b095() 	
 	kernel32.dll!7c80b713() 

Thread 1404
>	ntdll.dll!7c90e4f4() 	
 	ntdll.dll!7c90d1fc() 	
 	ws2help.dll!71aa2b67() 	


Thread 2192
 	ntdll.dll!7c90e4f4() 	
 	ntdll.dll!7c90df3c() 	
 	kernel32.dll!7c8025db() 	
 	kernel32.dll!7c802542() 	
>	mysqld.exe!handle_shutdown(void * arg=0x00000000)  Line 3119 + 0x11	C++
 	mysqld.exe!pthread_start(void * param=0x0156fca8)  Line 86 + 0x9	C
 	mysqld.exe!_threadstart(void * ptd=0x015e9898)  Line 196 + 0xd	C
 	kernel32.dll!7c80b713() 	

Thread 3640
 	ntdll.dll!7c90e4f4() 	
 	ntdll.dll!7c90df2c() 	
 	kernel32.dll!7c809574() 	
>	mysqld.exe!_unlock(int locknum=2)  Line 347	C
 	kernel32.dll!7c80a105() 	
 	mysqld.exe!pthread_cond_timedwait(pthread_cond_t * cond=0x00f54968,
_RTL_CRITICAL_SECTION * mutex=0x00f5494c, timespec * abstime=0x06bdff44)  Line 124 +
0x17	C
 	mysqld.exe!handle_manager(void * arg=0x00000000)  Line 91 + 0x13	C++
 	mysqld.exe!pthread_start(void * param=0x027101b8)  Line 86 + 0x9	C
 	mysqld.exe!_threadstart(void * ptd=0x02713758)  Line 196 + 0xd	C
 	kernel32.dll!7c80b713() 	

Thread 984
 	ntdll.dll!7c90e4f4() 	
 	ntdll.dll!7c90df3c() 	
 	mswsock.dll!71a5402b() 	
 	mswsock.dll!71a55fa7() 	
 	ntdll.dll!7c91925d() 	
 	ntdll.dll!7c9192ef() 	
 	ws2help.dll!71aa150c() 	
 	ws2_32.dll!71ab4387() 	
 	vlsp.dll!100041b9() 	
 	ntdll.dll!7c96c6a7() 	
 	ntdll.dll!7c96d160() 	
 	ntdll.dll!7c9192ef() 	
 	ntdll.dll!7c96d160() 	
 	ntdll.dll!7c96c6a7() 	
 	ntdll.dll!7c9192ef() 	
 	ntdll.dll!7c96d160() 	
 	ntdll.dll!7c96d144() 	
 	ntdll.dll!7c96d144() 	
 	ntdll.dll!7c949564() 	
 	ntdll.dll!7c949a41() 	
 	ntdll.dll!7c91925d() 	
 	ntdll.dll!7c9192ef() 	
 	ntdll.dll!7c949564() 	
 	ntdll.dll!7c9192ef() 	
 	ntdll.dll!7c949a41() 	
 	ntdll.dll!7c91925d() 	
 	ntdll.dll!7c9192ef() 	
 	kernel32.dll!7c81ad74() 	
 	kernel32.dll!7c81ad04() 	
 	ntdll.dll!7c910303() 	
 	kernel32.dll!7c80b79d() 	
 	kernel32.dll!7c80b7a9() 	
 	ntdll.dll!7c949a41() 	
 	ntdll.dll!7c949a41() 	
 	ntdll.dll!7c91925d() 	
 	ntdll.dll!7c9192ef() 	
 	ntdll.dll!7c949a41() 	
 	ntdll.dll!7c949a41() 	
 	ntdll.dll!7c91925d() 	
 	ntdll.dll!7c9192ef() 	
 	ntdll.dll!7c91925d() 	
 	ntdll.dll!7c949a41() 	
 	ntdll.dll!7c9192ef() 	
 	ntdll.dll!7c9192ef() 	
 	ntdll.dll!7c96d160() 	
 	ntdll.dll!7c96d144() 	
 	ntdll.dll!7c96c6a7() 	
 	ntdll.dll!7c96d160() 	
 	ntdll.dll!7c96d144() 	
 	ntdll.dll!7c949564() 	
 	ntdll.dll!7c9192ef() 	
 	ntdll.dll!7c90fc97() 	
 	ntdll.dll!7c90fda2() 	
 	ntdll.dll!7c90fdbd() 	
 	ntdll.dll!7c90dacc() 	
 	ntdll.dll!7c912dc8() 	
 	kernel32.dll!7c810634() 	
 	kernel32.dll!7c810693() 	
 	ntdll.dll!7c9192ef() 	
 	ntdll.dll!7c96d144() 	
 	ntdll.dll!7c949564() 	
 	ntdll.dll!7c9192ef() 	
 	ntdll.dll!7c9192ef() 	
 	ntdll.dll!7c9101bb() 	
 	ntdll.dll!7c96c6a7() 	
 	ntdll.dll!7c9192ef() 	
 	ntdll.dll!7c918f01() 	
 	ntdll.dll!7c9101bb() 	
 	ntdll.dll!7c949380() 	
 	ntdll.dll!7c9276ea() 	
 	ntdll.dll!7c927764() 	
 	ntdll.dll!7c9192ef() 	
 	mswsock.dll!71a55efe() 	
 	ntdll.dll!7c927764() 	
 	ntdll.dll!7c96c6a7() 	
 	ntdll.dll!7c96d9b0() 	
 	ntdll.dll!7c96d994() 	
 	ntdll.dll!7c91925d() 	
 	ntdll.dll!7c9192ef() 	
>	mysqld.exe!_heap_alloc_dbg(unsigned int nSize=17380984, int nBlockUse=114161796,
> const char * szFileName=0x00ad2b64, int nLine=4)  Line 359 + 0x1e	C
 	mysqld.exe!_unlock(int locknum=)  Line 347	C

Thread 784
 	ntdll.dll!7c90e4f4() 	
 	ntdll.dll!7c90df3c() 	
 	ntdll.dll!7c91b22b() 	
 	ntdll.dll!7c901046() 	
>	mysqld.exe!Log::logMessage(int mask=1024, const char * text=0x06dddea0)  Line 271 +
> 0xd	C++
 	mysqld.exe!Log::log(int mask=1024, const char * text=0x00d1f41c, char * args=0x06dde2d0)
 Line 212 + 0x10	C++
 	mysqld.exe!Log::log(int mask=1024, const char * txt=0x00d1f41c, ...)  Line 139 +
0x11	C++
 	mysqld.exe!Transaction::commit()  Line 253 + 0x23	C++
 	mysqld.exe!Connection::commit()  Line 273	C++
 	mysqld.exe!StorageConnection::commit()  Line 150 + 0x13	C++
 	mysqld.exe!StorageInterface::commit(handlerton * hton=0x026d4df0, THD * thd=0x026e7178,
bool all=true)  Line 1211 + 0xd	C++
 	mysqld.exe!ha_commit_one_phase(THD * thd=0x026e7178, bool all=true)  Line 1212 +
0x14	C++
 	mysqld.exe!ha_commit_trans(THD * thd=0x026e7178, bool all=true)  Line 1181 + 0xd	C++
 	mysqld.exe!trans_commit(THD * thd=0x026e7178)  Line 100 + 0xb	C++
 	mysqld.exe!mysql_execute_command(THD * thd=0x026e7178)  Line 3919 + 0x9	C++
 	mysqld.exe!mysql_parse(THD * thd=0x026e7178, const char * inBuf=0x02739ac8, unsigned int
length=6, const char * * found_semicolon=0x06ddfd08)  Line 5634 + 0x9	C++
 	mysqld.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x026e7178,
char * packet=0x027319f9, unsigned int packet_length=6)  Line 1009 + 0x1e	C++
 	mysqld.exe!do_command(THD * thd=0x026e7178)  Line 689 + 0x1b	C++
 	mysqld.exe!handle_one_connection(void * arg=0x026e7178)  Line 1156 + 0x9	C++
 	mysqld.exe!pthread_start(void * param=0x027101b8)  Line 86 + 0x9	C
 	mysqld.exe!_threadstart(void * ptd=0x026e9398)  Line 196 + 0xd	C
 	kernel32.dll!7c80b713() 	

Thread 2244
 	ntdll.dll!7c90e4f4() 	
 	ntdll.dll!7c90df3c() 	
 	mswsock.dll!71a5402b() 	
 	mswsock.dll!71a557c9() 	
 	vlsp.dll!10003c00() 	
 	ws2_32.dll!71ab67de() 	
>	mysqld.exe!vio_read(st_vio * vio=0x027387c8, unsigned char * buf=0x02747bd0, unsigned
> int size=4)  Line 41 + 0x18	C
 	mysqld.exe!my_real_read(st_net * net=0x02735aec, unsigned int * complen=0x01d8fef4) 
Line 838 + 0x1b	C++
 	mysqld.exe!my_net_read(st_net * net=0x02735aec)  Line 1021 + 0xd	C++
 	mysqld.exe!do_command(THD * thd=0x02735a58)  Line 635 + 0x9	C++
 	mysqld.exe!handle_one_connection(void * arg=0x02735a58)  Line 1156 + 0x9	C++
 	mysqld.exe!pthread_start(void * param=0x0156fca8)  Line 86 + 0x9	C
 	mysqld.exe!_threadstart(void * ptd=0x027389b0)  Line 196 + 0xd	C
 	kernel32.dll!7c80b713() 	
 	ntdll.dll!7c9192ef() 	


 

Thread
deadlock between Falcon logging and server loggingAnn W. Harrison5 Nov
  • RE: deadlock between Falcon logging and server loggingVladislav Vaintroub5 Nov