search

FirebirdSQL / firebird

Firebird server, client and tools
https://www.firebirdsql.org/
1.22k stars 213 forks source link

Server hang up on drop database [CORE4695] #5003

Open firebird-automations opened 9 years ago

firebird-automations commented 9 years ago

Submitted by: vinogradniy (vinogradniy)

Server hang up when single client(SYSDBA) drop database (or database metadata change). Restart from service manager failed. Required process kill from task manager and manually remove database file. Server version 2.5.2 does not have this problem.

Server logs: {{{ K00375 (Server) Thu Feb 19 14:39:34 2015 INET/inet_error: read errno = 10054

K00375 (Client) Thu Feb 19 14:39:45 2015 "C:\Program Files\Firebird\Firebird_2_5\bin\fbserver.exe": terminated abnormally (4294967295)

K00375 (Client) Thu Feb 19 14:39:46 2015 Guardian starting: "C:\Program Files\Firebird\Firebird_2_5\bin\fbserver.exe"

K00375 (Client) Thu Feb 19 14:39:51 2015 Guardian starting: "C:\Program Files\Firebird\Firebird_2_5\bin\fbserver.exe"

K00375 (Server) Thu Feb 19 15:46:47 2015 INET/inet_error: read errno = 10054

K00375 (Client) Thu Feb 19 15:47:27 2015 Guardian starting: "C:\Program Files\Firebird\Firebird_2_5\bin\fbserver.exe" }}}

firebird-automations commented 9 years ago

Commented by: @AlexPeshkoff

Server hang is definitely severe issue and should be fixed but please be sure that we tested FB 2.5.3 before releasing it and in our tests server does not fail on drop database. I.e. it's necessary to examine _your_ particular case to fix this bug. So can you provide reproducible test case? If yes attach it to the ticket. If not look here: http://www.ibphoenix.com/resources/documents/development/doc_35 and follow the instructions.

firebird-automations commented 8 years ago

Commented by: vinogradniy (vinogradniy)

May be CORE4700 fix this problem. Require testing with Fb 2.5.4.

firebird-automations commented 7 years ago

Commented by: vinogradniy (vinogradniy)

For Firebird-2.5.6.27020_0_x64.exe dump file: https://cloud.mail.ru/public/2YyW/WXjqZQqAE

firebird-automations commented 7 years ago

Commented by: vinogradniy (vinogradniy)

For Firebird-2.5.6.27020_0_x64.exe ADPlus dump: https://cloud.mail.ru/public/CWU6/DWRzyeoZz

firebird-automations commented 7 years ago

Commented by: @hvlad

Both dumps shows that hangup happens when database is created (not dropped) over already existing database.

Thread 1:

00 ntdll!NtWaitForSingleObject+0xa 01 KERNELBASE!WaitForSingleObjectEx+0x9a 02 fbserver!CCH_init+0x271 03 fbserver!jrd8_attach_database+0xd02 04 fbserver!jrd8_create_database$catch$0+0x4c 05 msvcr80!tanhf+0x2a00 06 msvcr80!_is_exception_typeof+0x1ee 07 ntdll!RtlRestoreContext+0x304 08 fbserver!jrd8_create_database+0xb22 09 fbserver!isc_create_database+0x502 0a fbserver!attach_database2+0x3a7 0b fbserver!attach_database+0x386 0c fbserver!process_packet+0x17d 0d fbserver!loopThread+0x1a1

Thread 2:

00 ntdll!NtWaitForSingleObject+0xa 01 ntdll!RtlMultiAppendUnicodeStringBuffer+0x38e 02 ntdll!RtlInitializeCriticalSection+0x125 03 fbserver!cache_writer+0xc0 04 fbserver!`anonymous namespace'::threadStart+0x2b

thread 1: hold dbbSync and wait for dbb_writer_init semaphore thread 2: wait for dbbSync and can't signal dbb_writer_init semaphore

firebird-automations commented 7 years ago
Modified by: @hvlad assignee: Vlad Khorsun \[ hvlad \]
firebird-automations commented 7 years ago

Commented by: vinogradniy (vinogradniy)

> Both dumps shows that hangup happens when database is created (not dropped) over already existing database.

Hangup is reproduced only in that case (over already existing database).