--- In firebird-support@yahoogroups.com, Dmitry Yemanov <dimitr@...>
wrote:

>
> Could you please show us the complete stack trace?
>
>
> Dmitry
>

Okay here is a complete stack trace of all threads. It would seem
like Thread 7 is suspect? Did someone enter the stall without
releasing a critical section?

Callstack for Thread 1 (Thread Id: 5768 (0x1688)):
Index Function
----------
1 ntdll.dll!_KiFastSystemCallRet@0()
2 ntdll.dll!_ZwReadFile@36()
3 kernel32.dll!_ReadFile@20()
4 advapi32.dll!ScGetPipeInput()
5 advapi32.dll!ScDispatcherLoop()
6 advapi32.dll!_StartServiceCtrlDispatcherA@4()
7 fbserver.exe!WinMain()
8 fbserver.exe!__tmainCRTStartup()
9 kernel32.dll!_BaseProcessStart@4()

Callstack for Thread 2 (Thread Id: 5628 (0x15fc)):
Index Function
----------
1 ntdll.dll!_KiFastSystemCallRet@0()
2 ntdll.dll!_NtWaitForSingleObject@12()
3 kernel32.dll!_WaitForSingleObjectEx@12()
4 kernel32.dll!_WaitForSingleObject@8()
5 fbserver.exe!CNTL_main_thread()
6 advapi32.dll!ScSvcctrlThreadA()
7 kernel32.dll!_BaseThreadStart@8()

Callstack for Thread 3 (Thread Id: 3836 (0xefc)):
Index Function
----------
1 ntdll.dll!_KiFastSystemCallRet@0()
2 ntdll.dll!_NtDelayExecution@8()
3 kernel32.dll!_SleepEx@8()
4 kernel32.dll!_Sleep@4()
5 fbserver.exe!ThreadPriorityScheduler::schedulerMain()
6 msvcr80.dll!__endthreadex()
7 msvcr80.dll!__endthreadex()
8 kernel32.dll!_BaseThreadStart@8()

Callstack for Thread 4 (Thread Id: 1732 (0x6c4)):
Index Function
----------
1 ntdll.dll!_KiFastSystemCallRet@0()
2 ntdll.dll!_NtWaitForMultipleObjects@20()
3 kernel32.dll!_WaitForMultipleObjectsEx@20()
4 kernel32.dll!_WaitForMultipleObjects@16()
5 fbserver.exe!ISC_event_wait()
6 fbserver.exe!stall()
7 fbserver.exe!SCH_enter()
8 fbserver.exe!select_wait()
9 fbserver.exe!select_multi()
10 fbserver.exe!rem_port::select_multi()
11 fbserver.exe!SRVR_multi_thread()
12 fbserver.exe!inet_connect_wait_thread()
13 fbserver.exe!ThreadPriorityScheduler::run()
14 fbserver.exe!`anonymous namespace'::threadStart()
15 msvcr80.dll!__endthreadex()
16 msvcr80.dll!__endthreadex()
17 kernel32.dll!_BaseThreadStart@8()

Callstack for Thread 5 (Thread Id: 2552 (0x9f8)):
Index Function
----------
1 ntdll.dll!_KiFastSystemCallRet@0()
2 ntdll.dll!_ZwFsControlFile@40()
3 kernel32.dll!_ConnectNamedPipe@8()
4 fbserver.exe!WNET_connect()
5 fbserver.exe!wnet_connect_wait_thread()
6 fbserver.exe!ThreadPriorityScheduler::run()
7 fbserver.exe!`anonymous namespace'::threadStart()
8 msvcr80.dll!__endthreadex()
9 msvcr80.dll!__endthreadex()
10 kernel32.dll!_BaseThreadStart@8()

Callstack for Thread 6 (Thread Id: 1324 (0x52c)):
Index Function
----------
1 ntdll.dll!_KiFastSystemCallRet@0()
2 ntdll.dll!_NtWaitForSingleObject@12()
3 kernel32.dll!_WaitForSingleObjectEx@12()
4 kernel32.dll!_WaitForSingleObject@8()
5 fbserver.exe!connect_server()
6 fbserver.exe!XNET_connect()
7 fbserver.exe!xnet_connect_wait_thread()
8 fbserver.exe!ThreadPriorityScheduler::run()
9 fbserver.exe!`anonymous namespace'::threadStart()
10 msvcr80.dll!__endthreadex()
11 msvcr80.dll!__endthreadex()
12 kernel32.dll!_BaseThreadStart@8()

Callstack for Thread 7 (Thread Id: 7564 (0x1d8c)):
Index Function
----------
1 ntdll.dll!_KiFastSystemCallRet@0()
2 ntdll.dll!_NtWaitForSingleObject@12()
3 ntdll.dll!_RtlpWaitForCriticalSection@4()
4 ntdll.dll!_RtlEnterCriticalSection@4()
5 fbserver.exe!DYN_ddl()
6 fbserver.exe!jrd8_ddl()
7 fbserver.exe!isc_ddl()
8 fbserver.exe!DDL_execute()
9 fbserver.exe!execute_request()
10 fbserver.exe!dsql8_execute_immediate_common()
11 fbserver.exe!dsql8_execute_immediate()
12 fbserver.exe!isc_dsql_exec_immed3_m()
13 fbserver.exe!rem_port::execute_immediate()
14 fbserver.exe!process_packet2()
15 fbserver.exe!process_packet()
16 fbserver.exe!loopThread()
17 fbserver.exe!ThreadPriorityScheduler::run()
18 fbserver.exe!`anonymous namespace'::threadStart()
19 msvcr80.dll!__endthreadex()
20 msvcr80.dll!__endthreadex()
21 kernel32.dll!_BaseThreadStart@8()

Callstack for Thread 8 (Thread Id: 5428 (0x1534)):
Index Function
----------
1 ntdll.dll!_KiFastSystemCallRet@0()
2 ntdll.dll!_NtWaitForMultipleObjects@20()
3 kernel32.dll!_WaitForMultipleObjectsEx@20()
4 kernel32.dll!_WaitForMultipleObjects@16()
5 fbserver.exe!ISC_event_wait()
6 fbserver.exe!stall()
7 fbserver.exe!SCH_enter()
8 fbserver.exe!cache_writer()
9 fbserver.exe!ThreadPriorityScheduler::run()
10 fbserver.exe!`anonymous namespace'::threadStart()
11 msvcr80.dll!__endthreadex()
12 msvcr80.dll!__endthreadex()
13 kernel32.dll!_BaseThreadStart@8()

Callstack for Thread 9 (Thread Id: 3044 (0xbe4)):
Index Function
----------
1 ntdll.dll!_KiFastSystemCallRet@0()
2 ntdll.dll!_NtWaitForMultipleObjects@20()
3 kernel32.dll!_WaitForMultipleObjectsEx@20()
4 kernel32.dll!_WaitForMultipleObjects@16()
5 fbserver.exe!ISC_event_wait()
6 fbserver.exe!stall()
7 fbserver.exe!SCH_enter()
8 fbserver.exe!garbage_collector()
9 fbserver.exe!ThreadPriorityScheduler::run()
10 fbserver.exe!`anonymous namespace'::threadStart()
11 msvcr80.dll!__endthreadex()
12 msvcr80.dll!__endthreadex()
13 kernel32.dll!_BaseThreadStart@8()

Callstack for Thread 10 (Thread Id: 7644 (0x1ddc)):
Index Function
----------
1 ntdll.dll!_KiFastSystemCallRet@0()
2 ntdll.dll!_NtWaitForMultipleObjects@20()
3 kernel32.dll!_WaitForMultipleObjectsEx@20()
4 kernel32.dll!_WaitForMultipleObjects@16()
5 fbserver.exe!ISC_event_wait()
6 fbserver.exe!stall()
7 fbserver.exe!SCH_enter()
8 fbserver.exe!cache_writer()
9 fbserver.exe!ThreadPriorityScheduler::run()
10 fbserver.exe!`anonymous namespace'::threadStart()
11 msvcr80.dll!__endthreadex()
12 msvcr80.dll!__endthreadex()
13 kernel32.dll!_BaseThreadStart@8()

Callstack for Thread 11 (Thread Id: 1868 (0x74c)):
Index Function
----------
1 ntdll.dll!_KiFastSystemCallRet@0()
2 ntdll.dll!_NtWaitForMultipleObjects@20()
3 kernel32.dll!_WaitForMultipleObjectsEx@20()
4 kernel32.dll!_WaitForMultipleObjects@16()
5 fbserver.exe!ISC_event_wait()
6 fbserver.exe!stall()
7 fbserver.exe!SCH_enter()
8 fbserver.exe!garbage_collector()
9 fbserver.exe!ThreadPriorityScheduler::run()
10 fbserver.exe!`anonymous namespace'::threadStart()
11 msvcr80.dll!__endthreadex()
12 msvcr80.dll!__endthreadex()
13 kernel32.dll!_BaseThreadStart@8()

Callstack for Thread 12 (Thread Id: 6928 (0x1b10)):
Index Function
----------
1 ntdll.dll!_KiFastSystemCallRet@0()
2 ntdll.dll!_NtWaitForMultipleObjects@20()
3 kernel32.dll!_WaitForMultipleObjectsEx@20()
4 kernel32.dll!_WaitForMultipleObjects@16()
5 fbserver.exe!ISC_event_wait()
6 fbserver.exe!stall()
7 fbserver.exe!SCH_enter()
8 fbserver.exe!loopThread()
9 fbserver.exe!ThreadPriorityScheduler::run()
10 fbserver.exe!`anonymous namespace'::threadStart()
11 msvcr80.dll!__endthreadex()
12 msvcr80.dll!__endthreadex()
13 kernel32.dll!_BaseThreadStart@8()

Callstack for Thread 13 (Thread Id: 3740 (0xe9c)):
Index Function
----------
1 ntdll.dll!_KiFastSystemCallRet@0()
2 ntdll.dll!_NtWaitForMultipleObjects@20()
3 kernel32.dll!_WaitForMultipleObjectsEx@20()
4 kernel32.dll!_WaitForMultipleObjects@16()
5 fbserver.exe!ISC_event_wait()
6 fbserver.exe!stall()
7 fbserver.exe!SCH_enter()
8 fbserver.exe!loopThread()
9 fbserver.exe!ThreadPriorityScheduler::run()
10 fbserver.exe!`anonymous namespace'::threadStart()
11 msvcr80.dll!__endthreadex()
12 msvcr80.dll!__endthreadex()
13 kernel32.dll!_BaseThreadStart@8()

Callstack for Thread 14 (Thread Id: 6148 (0x1804)):
Index Function
----------
1 ntdll.dll!_KiFastSystemCallRet@0()
2 ntdll.dll!_NtWaitForMultipleObjects@20()
3 kernel32.dll!_WaitForMultipleObjectsEx@20()
4 kernel32.dll!_WaitForMultipleObjects@16()
5 fbserver.exe!ISC_event_wait()
6 fbserver.exe!stall()
7 fbserver.exe!SCH_enter()
8 fbserver.exe!PIO_write()
9 fbserver.exe!write_page()
10 fbserver.exe!write_buffer()
11 fbserver.exe!CCH_release()
12 fbserver.exe!TRA_start()
13 fbserver.exe!jrd8_start_multiple()
14 fbserver.exe!jrd8_start_transaction()
15 fbserver.exe!isc_start_multiple()
16 fbserver.exe!isc_start_transaction()
17 fbserver.exe!rem_port::start_transaction()
18 fbserver.exe!ThreadData::putSpecific()
19 fbserver.exe!Firebird::MemoryPool::addFreeBlock()
20 00000013()

Callstack for Thread 15 (Thread Id: 6136 (0x17f8)):
Index Function
----------
1 ntdll.dll!_KiFastSystemCallRet@0()
2 ntdll.dll!_NtWaitForMultipleObjects@20()
3 kernel32.dll!_WaitForMultipleObjectsEx@20()
4 kernel32.dll!_WaitForMultipleObjects@16()
5 fbserver.exe!ISC_event_wait()
6 fbserver.exe!stall()
*7 fbserver.exe!SCH_enter()
8 fbserver.exe!PIO_read()
9 fbserver.exe!CCH_fetch_page()
10 fbserver.exe!CCH_handoff()
11 fbserver.exe!BTR_find_page()
12 fbserver.exe!BTR_evaluate()
13 fbserver.exe!EVL_bitmap()
14 fbserver.exe!RSE_open()
15 fbserver.exe!looper()
16 fbserver.exe!execute_looper()
17 fbserver.exe!EXE_send()
18 fbserver.exe!check_unique_name()
19 fbserver.exe!DYN_define_relation()
20 fbserver.exe!DYN_execute()
21 fbserver.exe!DYN_ddl()
22 fbserver.exe!jrd8_ddl()
23 fbserver.exe!isc_ddl()
24 fbserver.exe!DDL_execute()
25 fbserver.exe!execute_request()
26 fbserver.exe!dsql8_execute_immediate_common()
27 fbserver.exe!dsql8_execute_immediate()
28 fbserver.exe!isc_dsql_exec_immed3_m()
29 fbserver.exe!rem_port::execute_immediate()
30 fbserver.exe!process_packet2()
31 fbserver.exe!process_packet()
32 fbserver.exe!loopThread()
33 fbserver.exe!ThreadPriorityScheduler::run()
34 fbserver.exe!`anonymous namespace'::threadStart()
35 msvcr80.dll!__endthreadex()
36 msvcr80.dll!__endthreadex()
37 kernel32.dll!_BaseThreadStart@8()