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

CS server crash altering SP in 2 connect [CORE210] #538

Closed
firebird-issue-importer opened this issue Nov 22, 2002 · 17 comments
Closed

CS server crash altering SP in 2 connect [CORE210] #538

firebird-issue-importer opened this issue Nov 22, 2002 · 17 comments

Comments

@firebird-issue-importer

Submitted by: ded (ded)

SFID: 642411#⁠
Submitted By: ded

If the same procedure is altered on Classic FB1 from
2 connections, undocumented exception "Procedure in
use" is raised or gds_inet crashes. It is depenedent on
transactions parameters. How to reproduce:

Start 2 instances of interactive tool (isql or any
GUI tool) and:

1-st instance

create procedure test
as
begin
exit;
end

Commit

2-nd instance

alter procedure test
as
declare variable a int;
begin
exit;
end

Commit

1-st instance again

alter procedure test
as
begin
exit;
end

Commit

At this point (namely Commit):

if transaction parameters are concurrency wait:

Statement failed, SQLCODE = -902
Error reading data from the connection.

in server log:
Fatal lock manager error: invalid lock id (0) errno: 2

after it if this connection is restarted alter will
be successfull, but if we try alter procedure back in
2-nd (living for this time) instance - it's connection
will be broken too with the same line in log but errno:
4.

Any other parameters of transactions results in
"Procedure in use" message instead of the crash of
gds_inet.

Alexander V.Nevsky.

Commits: c58544e

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 6, 2006

Modified by: @pcisar

assignee: Dmitry Yemanov [ dimitr ] =>

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 11, 2006

Modified by: @dyemanov

Fix Version: 3.0 [ 10048 ]

SF_ID: 642411 =>

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 16, 2006

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Nov 13, 2007

Modified by: @dyemanov

Fix Version: 2.5 Alpha 1 [ 10224 ]

Fix Version: 3.0.0 [ 10048 ] =>

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Nov 15, 2007

Commented by: Dimitrios Chr. Ioannidis (dchri)

Use of the new Target Final Release Version field.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Nov 15, 2007

Modified by: Dimitrios Chr. Ioannidis (dchri)

Target Final Release Version: 2.5.0 [ 10221 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 28, 2008

Modified by: @pcisar

Workflow: jira [ 10234 ] => Firebird [ 14461 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Feb 20, 2008

Modified by: @dyemanov

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

Fix Version: 2.5 Beta 1 [ 10251 ]

Fix Version: 2.5 Alpha 1 [ 10224 ] =>

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Aug 13, 2008

Modified by: @dyemanov

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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Aug 13, 2008

Modified by: @dyemanov

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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Aug 13, 2008

Modified by: @dyemanov

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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Aug 18, 2008

Modified by: @dyemanov

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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Aug 25, 2008

Modified by: @dyemanov

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

resolution: Fixed [ 1 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Nov 8, 2009

Commented by: @pcisar

Fix verified, no test added.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Nov 8, 2009

Modified by: @pcisar

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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 19, 2016

Modified by: @pavel-zotov

QA Status: No test

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 15, 2016

Modified by: @pavel-zotov

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

QA Status: No test => Done successfully

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