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

Unhandled: C0000005.ACCESS_VIOLATION [CORE5880] #6138

Closed
firebird-automations opened this issue Jul 26, 2018 · 32 comments
Closed

Unhandled: C0000005.ACCESS_VIOLATION [CORE5880] #6138

firebird-automations opened this issue Jul 26, 2018 · 32 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Sorien (sorien)

while testing CORE5844 I got few server crashes, dumps below

http://www.merkuris.sk/files/firebird_3.zip (3.0.4.33014 64Bit)
http://www.merkuris.sk/files/firebird_av_1.zip (3.0.4.33011 32Bit)

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

firebird_3 dump is related with events processing
Reproducible test case could help us to investigate issue

firebird_av_1 is produced by 32-bit build which i don't have.
Without .pdb and .exe\.dll files it is impossible to analyze memory dump

@firebird-automations
Copy link
Collaborator Author

Commented by: Sorien (sorien)

here is your's 32bit version https://www.merkuris.sk/files/Firebird-3.0.4.33011-0_Win32.zip with pdb as i see

on our end there is just

simple query that is fetching users and permissions from our table in separate connection

and database trigger

RECREATE TRIGGER DISCONNECT_SHEDULER
ACTIVE ON DISCONNECT POSITION 0
AS
DECLARE VARIABLE param INTEGER = 0;
BEGIN
SELECT COUNT(*) FROM SHEDULER s INNER JOIN MON$ATTACHMENTS a ON s.client = a.MON$ATTACHMENT_ID into param;
IF (param = 0) then
POST_EVENT 'EVENT_SHEDULER';
END ^^

but app is not listening for event EVENT_SHEDULER

and occasionally server will crash, i'll try to create simple demo but don't thing that it will be reproducible easily

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

Could you test this patched build (Win64), please ?

http://ge.tt/8nrSJlq2

@firebird-automations
Copy link
Collaborator Author

Commented by: Sorien (sorien)

i have tried that version and there is still same server crash, if you need dump just let me know

i'll try to remove that database trigger, it looks like its causing our problems and it's not so important

@firebird-automations
Copy link
Collaborator Author

Commented by: Sorien (sorien)

disabling that trigger did not help

crash dump (for your build http://ge.tt/8nrSJlq2)

http://merkuris.sk/files/firebird.exe_180730_093046.zip

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

Another races and new build to test http://ge.tt/7wKaGpq2

@firebird-automations
Copy link
Collaborator Author

Commented by: Sorien (sorien)

still crashing

dump https://www.merkuris.sk/files/firebird.exe_180731_084234.zip

maybe it will help, for testing i'm force terminating our app during these queries https://gist.github.com/Sorien/558c028ee20157a3976b2c283f356a0b

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

New build here: http://ge.tt/8P16bqq2

@firebird-automations
Copy link
Collaborator Author

Commented by: Sorien (sorien)

it seems to be harder to crash server

https://www.merkuris.sk/files/firebird.exe_180801_084732.zip

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

Could you also provide us with firebird.log, if it is not empy ?

@firebird-automations
Copy link
Collaborator Author

Commented by: Sorien (sorien)

this shoud be from testing
https://gist.github.com/Sorien/c2939cbdd8b60878a7f45d4ac917c20a

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

This build contains some extra logging :
http://ge.tt/5Op3qsq2

Please, remove (or clear) firebird.log before run this build and provide me with both memory dump and firebird.log on next crash

@firebird-automations
Copy link
Collaborator Author

Commented by: Sorien (sorien)

after 2 hours of testing i'm not able crash that build, will try to find more testers and provide logs when it happens

Edit: dump (firebird.log) is inside archive
http://www.merkuris.sk/files/firebird.exe_180803_103833.zip

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

Seems that logging makes harder to reproduce the issue, sad.
Anyway, could you provide firebird.log to me ?

@firebird-automations
Copy link
Collaborator Author

Commented by: Sorien (sorien)

firebird.log is inside zip archive

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

What archive ? ;)

@firebird-automations
Copy link
Collaborator Author

Commented by: Sorien (sorien)

http://www.merkuris.sk/files/firebird.exe_180803_103833.zip

(i edited my last post after server crashed)

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

Thanks, log helped, but i need a bit more info

A new build with more logging: http://ge.tt/6f5e2wq2

BTW, have you cleaned all INET errors from the firebird.log before put it into archive with dump ?

@firebird-automations
Copy link
Collaborator Author

Commented by: Sorien (sorien)

that one was from my colleague, it was not changed in any way, on his machine he is able to reproduce it without killing our software

@firebird-automations
Copy link
Collaborator Author

Commented by: Sorien (sorien)

after few tries server did not crashed but can't attach to db anymore

and in firebird.log i have

PC Tue Aug 07 11:04:01 2018
Authentication error
connection shutdown

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

There should be much more messages in the log...

@firebird-automations
Copy link
Collaborator Author

Commented by: Sorien (sorien)

here you are https://gist.github.com/Sorien/9027b757396e80818213a1c4062db54a

@firebird-automations
Copy link
Collaborator Author

Commented by: Sorien (sorien)

and https://gist.github.com/Sorien/a2c435642a9d5954667a8eb87801cf5d (server slill not crashed)

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

Found mine error, i'm sorry
Please, try fixed build http://ge.tt/9IUM6wq2

@firebird-automations
Copy link
Collaborator Author

Commented by: Sorien (sorien)

here is crash dump + log (for your last build)

http://merkuris.sk/files/firebird.exe_180807_123834.zip

in firebird.log i just replaced db name to FOO.fdb

@firebird-automations
Copy link
Collaborator Author

Commented by: Sorien (sorien)

and one more http://merkuris.sk/files/firebird.exe_180807_135337.zip

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

Thanks, looks like i found a bug reason.
New build: http://ge.tt/5gKNfwq2

@firebird-automations
Copy link
Collaborator Author

Commented by: Sorien (sorien)

it looks good so far no crash, i'll test more and report back

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

If there is no more issues, i going to commit patch and close the ticket.
Thanks for the testing !

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

assignee: Vlad Khorsun [ hvlad ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 4.0 Beta 1 [ 10750 ]

Fix Version: 3.0.4 [ 10863 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: Sorien (sorien)

I can confirm there are no more such issues. May I ask if there are any plans to release 3.0.4 stable version anytime soon?, cause it fixes our stability issues and it's its i bit difficult to ask admins update to nightly :)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants