search

FirebirdSQL / firebird

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

Unhandled: C0000005.ACCESS_VIOLATION [CORE5880] #6138

Closed firebird-automations closed 5 years ago

firebird-automations commented 5 years ago

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 commented 5 years ago

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 commented 5 years ago

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 commented 5 years ago

Commented by: @hvlad

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

http://ge.tt/8nrSJlq2

firebird-automations commented 5 years ago

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 commented 5 years ago

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 commented 5 years ago

Commented by: @hvlad

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

firebird-automations commented 5 years ago

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 commented 5 years ago

Commented by: @hvlad

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

firebird-automations commented 5 years ago

Commented by: Sorien (sorien)

it seems to be harder to crash server

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

firebird-automations commented 5 years ago

Commented by: @hvlad

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

firebird-automations commented 5 years ago

Commented by: Sorien (sorien)

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

firebird-automations commented 5 years ago

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 commented 5 years ago

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 commented 5 years ago

Commented by: @hvlad

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

firebird-automations commented 5 years ago

Commented by: Sorien (sorien)

firebird.log is inside zip archive

firebird-automations commented 5 years ago

Commented by: @hvlad

What archive ? ;)

firebird-automations commented 5 years ago

Commented by: Sorien (sorien)

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

(i edited my last post after server crashed)

firebird-automations commented 5 years ago

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 commented 5 years ago

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 commented 5 years ago

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 commented 5 years ago

Commented by: @hvlad

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

firebird-automations commented 5 years ago

Commented by: Sorien (sorien)

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

firebird-automations commented 5 years ago

Commented by: Sorien (sorien)

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

firebird-automations commented 5 years ago

Commented by: @hvlad

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

firebird-automations commented 5 years ago

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 commented 5 years ago

Commented by: Sorien (sorien)

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

firebird-automations commented 5 years ago

Commented by: @hvlad

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

firebird-automations commented 5 years ago

Commented by: Sorien (sorien)

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

firebird-automations commented 5 years ago

Commented by: @hvlad

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

firebird-automations commented 5 years ago
Modified by: @hvlad assignee: Vlad Khorsun \[ hvlad \]
firebird-automations commented 5 years ago
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 commented 5 years ago

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