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-automations opened this issue Dec 7, 2013 · 15 comments

Comments

@firebird-automations
Copy link
Collaborator

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-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

Attachment: einstein_task.zip [ 12391 ]

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

@firebird-automations
Copy link
Collaborator Author

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-automations
Copy link
Collaborator Author

Commented by: @pavel-zotov

Sean, as you like.

@firebird-automations
Copy link
Collaborator Author

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-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Link: This issue is related to CORE3076 [ CORE3076 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ]

@firebird-automations
Copy link
Collaborator Author

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-automations
Copy link
Collaborator Author

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-automations
Copy link
Collaborator Author

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-automations
Copy link
Collaborator Author

Commented by: @pavel-zotov

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

Please see added stack traces (five samples).

@firebird-automations
Copy link
Collaborator Author

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-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

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

resolution: Fixed [ 1 ]

Fix Version: 3.0 Alpha 2 [ 10560 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

@firebird-automations
Copy link
Collaborator Author

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