Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Server hang up on drop database [CORE4695] #5003

Open
firebird-automations opened this issue Feb 19, 2015 · 7 comments
Open

Server hang up on drop database [CORE4695] #5003

firebird-automations opened this issue Feb 19, 2015 · 7 comments
Assignees
@hvlad
Labels
affect-version: 2.5.3 component: engine priority: major type: bug

Comments

@firebird-automations
Copy link
Collaborator

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
Copy link
Collaborator Author

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
Copy link
Collaborator Author

Commented by: vinogradniy (vinogradniy)

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

@firebird-automations
Copy link
Collaborator Author

Commented by: vinogradniy (vinogradniy)

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

@firebird-automations
Copy link
Collaborator Author

Commented by: vinogradniy (vinogradniy)

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

@firebird-automations
Copy link
Collaborator Author

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
Copy link
Collaborator Author

Modified by: @hvlad

assignee: Vlad Khorsun [ hvlad ]

@firebird-automations
Copy link
Collaborator Author

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).

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@hvlad hvlad

Labels
affect-version: 2.5.3 component: engine priority: major type: bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@hvlad @firebird-automations