firebird icon indicating copy to clipboard operation
firebird copied to clipboard

Published 20 hours ago • verified publisher icon FirebirdSQL

SELECT crashes the server

Open tomaszdubiel18 opened this issue 1 year ago • 5 comments

Hello. Firebird 3.0.11 Superserver Windows. A statement below crashes the server: select list(distinct(select sum(MK.ILOSC) from MELDUNEKKART MK where MK.ID_MELDUNEK = M.ID_MELDUNEK and MK.ID_PRODUKTZP is not null), '') from MELDUNEK M where M.ID_MELDUNEK = 10376 group by 1; It's dependent on the data. Such a row in a table MELDUNEK must exist. In Firebird log: Access violation. The code attempted to access a virtual address without privilege to do so. This exception will cause the Firebird server to terminate abnormally. Any additional info will be useful? For example, crash dump? Best regards, Tomasz.

tomaszdubiel18 avatar Feb 19 '24 12:02 tomaszdubiel18

Did you check is with latest snapshot build ? Crash dump is required of course. If it was produced with non-release build, provide also debug information of that build.

hvlad avatar Feb 22 '24 12:02 hvlad

I tried the latest snapshot. Here is the dump: firebird.exe.14464.dmp.7z.zip It's 7zip archive.

tomaszdubiel18 avatar Feb 22 '24 13:02 tomaszdubiel18

It is useless without debug info.

hvlad avatar Feb 22 '24 17:02 hvlad

You are lucky, it is from latest snapshot that is still available. Next time, please, provide both dump and snapshot build (or .pdb files at least)

hvlad avatar Feb 22 '24 17:02 hvlad

The query is syntactically wrong, it should return error

Cannot use an aggregate or window function in a GROUP BY clause.

Just remove GROUP BY and it will work. The crash, anyway, should and will be fixed.

hvlad avatar Feb 22 '24 19:02 hvlad