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-automations opened this issue Nov 22, 2002 · 17 comments
Closed

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

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

Comments

@firebird-automations
Copy link
Collaborator

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

Modified by: @pcisar

assignee: Dmitry Yemanov [ dimitr ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 3.0 [ 10048 ]

SF_ID: 642411 =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 2.5 Alpha 1 [ 10224 ]

Fix Version: 3.0.0 [ 10048 ] =>

@firebird-automations
Copy link
Collaborator Author

Commented by: Dimitrios Chr. Ioannidis (dchri)

Use of the new Target Final Release Version field.

@firebird-automations
Copy link
Collaborator Author

Modified by: Dimitrios Chr. Ioannidis (dchri)

Target Final Release Version: 2.5.0 [ 10221 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

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

Fix Version: 2.5 Beta 1 [ 10251 ]

Fix Version: 2.5 Alpha 1 [ 10224 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

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

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @pcisar

Fix verified, no test added.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test

@firebird-automations
Copy link
Collaborator Author

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