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

Server bugchecks or crashes on exception in calculated index [CORE4075] #4403

Closed
firebird-automations opened this issue Apr 9, 2013 · 15 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Thomas Beckmann (thbeckmann)

Is duplicated by CORE4603
Is related to QA604

Consider the following example:

create table TEST (BIT smallint);
create index IDX_TEST_BIT on TEST computed by (bin_shl(1, TEST.BIT-1));

insert into test values (0);

Of course, insertion should lead to an exception. Unfortunately, it crashes the server.

Commits: 8d28efe 0c6f0f9 FirebirdSQL/fbt-repository@5085235 FirebirdSQL/fbt-repository@782d91a

@firebird-automations
Copy link
Collaborator Author

Modified by: Thomas Beckmann (thbeckmann)

environment: W7/63, WI-T3.0.0.30317 Firebird 3.0 Unstable => W7/64, WI-T3.0.0.30317 Firebird 3.0 Unstable

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

I see the following error:

expression evaluation not supported.
expression evaluation not supported.
Argument for BIN_SHL must be zero or positive.
internal Firebird consistency check (error during savepoint backout (290), file: exe.cpp line: 4133).

It could lead to abort in the debug build, but not in the release one.

The problem, however, is that v2.5.3 behaves the same way while v2.5.2 don't throw the bugcheck. Something has changed and this should be investigated.

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

status: Open [ 1 ] => In Progress [ 3 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: Thomas Beckmann (thbeckmann)

Hm, we've been trying this with a non debug version and it still crashes the server.

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

Perhaps you have BugcheckAbort = 1 in firebird.conf?

@firebird-automations
Copy link
Collaborator Author

Commented by: Thomas Beckmann (thbeckmann)

No, it was actually left to the default settings. The error persists even if I uncomment the line
BugcheckAbort = 0
in firebird.conf (and restart the server, of course).

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Version: 3.0 Initial [ 10301 ]

Version: 3.0 Alpha 1 [ 10331 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

status: In Progress [ 3 ] => Open [ 1 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Version: 2.5.3 [ 10461 ]

summary: Server crashes on exception in calculated index => Server buchecks on exception in calculated index

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

summary: Server buchecks on exception in calculated index => Server bugchecks or crashes on exception in calculated index

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Link: This issue is duplicated by CORE4603 [ CORE4603 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

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

resolution: Fixed [ 1 ]

Fix Version: 2.5.4 [ 10585 ]

Fix Version: 3.0 Beta 2 [ 10586 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: Done successfully

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Link: This issue is related to QA604 [ QA604 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment