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

FB crashes on SELECT with long/complex list of compound AND/OR'd predicates [CORE4293] #4616

Closed
firebird-issue-importer opened this issue Dec 7, 2013 · 15 comments

Comments

@firebird-issue-importer
Copy link

firebird-issue-importer commented Dec 7, 2013

Submitted by: @pavel-zotov

Is related to CORE3076

Attachments:
einstein_task.zip
einstein-task-stack-traces.zip
stack_traces_einstein_trouble_LI-T3.0.0.30787_oel64.zip

Plan of execution is appeared instantly.
But execution itself ends with abend - see attach for DDL, query and stack traces.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Dec 7, 2013

Modified by: @pavel-zotov

Attachment: einstein_task.zip [ 12391 ]

Attachment: einstein-task-stack-traces.zip [ 12392 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Dec 7, 2013

Commented by: Sean Leyne (seanleyne)

"Einstein's task" is a great phrase, but is not ... ideal for a bug tracker description. So, I would like to edit the case to better reflect the problem/issue.

Would a better term for this case be "complex query" or "long WHERE case"?

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Dec 7, 2013

Commented by: @pavel-zotov

Sean, as you like.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Dec 8, 2013

Commented by: @dyemanov

Looking at the backtrace, the root of the problem is related to how compound ORed predicates are optimized and executed (regression for CORE3076).

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Dec 8, 2013

Modified by: @dyemanov

Link: This issue is related to CORE3076 [ CORE3076 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Dec 8, 2013

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Dec 8, 2013

Commented by: @dyemanov

The problem, however, that I cannot reproduce the crash. The query successfully returns zero rows in both debug and release configurations.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Dec 9, 2013

Modified by: Sean Leyne (seanleyne)

summary: FB crashes when attempts to solve Einstein's task => FB crashes on SELECT with long/complex list of AND/OR'd predicates

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Dec 9, 2013

Modified by: Sean Leyne (seanleyne)

summary: FB crashes on SELECT with long/complex list of AND/OR'd predicates => FB crashes on SELECT with long/complex list of compound AND/OR'd predicates

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Dec 11, 2013

Commented by: @pavel-zotov

I still *can* reproduce on LI-T3.0.0.30787.

Please see added stack traces (five samples).

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Dec 11, 2013

Commented by: @pavel-zotov

ISQL Version: LI-T3.0.0.30780 Firebird 3.0 Alpha 1
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-T3.0.0.30787 Firebird 3.0 Alpha 1"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-T3.0.0.30787 Firebird 3.0 Alpha 1/tcp (oel64)/P13"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-T3.0.0.30780 Firebird 3.0 Alpha 1/tcp (oel64)/P13"
on disk structure version 12.0

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Dec 11, 2013

Modified by: @pavel-zotov

Attachment: stack_traces_einstein_trouble_LI-T3.0.0.30787_oel64.zip [ 12396 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Dec 12, 2013

Modified by: @dyemanov

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

resolution: Fixed [ 1 ]

Fix Version: 3.0 Alpha 2 [ 10560 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 27, 2014

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 18, 2016

Modified by: @pavel-zotov

status: Closed [ 6 ] => Closed [ 6 ]

QA Status: No test

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