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-issue-importer opened this issue Apr 9, 2013 · 15 comments

Comments

@firebird-issue-importer
Copy link

@firebird-issue-importer firebird-issue-importer commented Apr 9, 2013

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Apr 9, 2013

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Apr 9, 2013

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Apr 9, 2013

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Apr 9, 2013

Modified by: @dyemanov

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Apr 10, 2013

Commented by: Thomas Beckmann (thbeckmann)

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Apr 10, 2013

Commented by: @dyemanov

Perhaps you have BugcheckAbort = 1 in firebird.conf?

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Apr 10, 2013

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jun 26, 2013

Modified by: @dyemanov

Version: 3.0 Initial [ 10301 ]

Version: 3.0 Alpha 1 [ 10331 ] =>

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Apr 24, 2014

Modified by: @dyemanov

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Nov 11, 2014

Modified by: @dyemanov

Version: 2.5.3 [ 10461 ]

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Nov 11, 2014

Modified by: @dyemanov

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Nov 11, 2014

Modified by: @dyemanov

Link: This issue is duplicated by CORE4603 [ CORE4603 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Feb 3, 2015

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented May 29, 2015

Modified by: @pavel-zotov

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

QA Status: Done successfully

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Sep 25, 2015

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
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants