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-issue-importer opened this issue Jul 26, 2018 · 32 comments
Closed

Unhandled: C0000005.ACCESS_VIOLATION [CORE5880] #6138

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

Comments

@firebird-issue-importer

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-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 26, 2018

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-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 26, 2018

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-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 27, 2018

Commented by: @hvlad

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

http://ge.tt/8nrSJlq2

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 30, 2018

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-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 30, 2018

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-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 30, 2018

Commented by: @hvlad

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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 31, 2018

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-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 31, 2018

Commented by: @hvlad

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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Aug 1, 2018

Commented by: Sorien (sorien)

it seems to be harder to crash server

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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Aug 1, 2018

Commented by: @hvlad

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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Aug 1, 2018

Commented by: Sorien (sorien)

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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Aug 3, 2018

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-issue-importer
Copy link
Author

firebird-issue-importer commented Aug 3, 2018

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-issue-importer
Copy link
Author

firebird-issue-importer commented Aug 3, 2018

Commented by: @hvlad

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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Aug 3, 2018

Commented by: Sorien (sorien)

firebird.log is inside zip archive

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Aug 3, 2018

Commented by: @hvlad

What archive ? ;)

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Aug 3, 2018

Commented by: Sorien (sorien)

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

(i edited my last post after server crashed)

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Aug 7, 2018

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-issue-importer
Copy link
Author

firebird-issue-importer commented Aug 7, 2018

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-issue-importer
Copy link
Author

firebird-issue-importer commented Aug 7, 2018

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-issue-importer
Copy link
Author

firebird-issue-importer commented Aug 7, 2018

Commented by: @hvlad

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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Aug 7, 2018

Commented by: Sorien (sorien)

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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Aug 7, 2018

Commented by: Sorien (sorien)

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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Aug 7, 2018

Commented by: @hvlad

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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Aug 7, 2018

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-issue-importer
Copy link
Author

firebird-issue-importer commented Aug 7, 2018

Commented by: Sorien (sorien)

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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Aug 8, 2018

Commented by: @hvlad

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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Aug 8, 2018

Commented by: Sorien (sorien)

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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Aug 10, 2018

Commented by: @hvlad

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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Aug 27, 2018

Modified by: @hvlad

assignee: Vlad Khorsun [ hvlad ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Aug 27, 2018

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-issue-importer
Copy link
Author

firebird-issue-importer commented Aug 31, 2018

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