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

recreation of collation for utf8 from unicode with option 'NUMERIC-SORT=1' leads to FB "death" [CORE3650] #4001

Closed
firebird-automations opened this issue Nov 4, 2011 · 5 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @pavel-zotov

Is related to QA603

recreate table tns(f int); -- drop dependencies if any
commit;
set term ^;
execute block as
begin
execute statement 'drop collation ns_coll;';
when any do begin end
end^
set term ;^
commit;
create collation ns_coll for utf8 from unicode 'NUMERIC-SORT=1';
recreate table tns(s varchar(50) character set utf8 collate ns_coll);
commit;

recreate table tns(f int); -- drop dependencies if any
commit;
set term ^;
execute block as
begin
execute statement 'drop collation ns_coll;';
when any do begin end
end^
set term ;^
commit;
create collation ns_coll for utf8 from unicode 'NUMERIC-SORT=1';
rollback; -- !!NB!!

set term ^;
execute block as
begin
execute statement 'drop collation ns_coll;';
when any do begin end
end^
set term ;^
commit; -- this commit kills FB service

The following messages apear in ISQL:
-------------------------------------------------------
Statement failed, SQLSTATE = 08006
Unable to complete network request to host "localhost".
-Error reading data from the connection.

The following messages appear in firebird.log:
--------------------------------------------------------------
BALAHA Fri Nov 04 07:38:05 2011
Fatal lock manager error: invalid lock id (0), errno: 0

BALAHA (Client) Fri Nov 04 07:38:05 2011
INET/inet_error: read errno = 10054

BALAHA Fri Nov 04 07:38:05 2011
INET/inet_error: select in packet_receive errno = 10093

BALAHA (Client) Fri Nov 04 07:38:16 2011
REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
Uncommitted work may have been lost

Commits: a460334 8ffb3f5

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

Something looks wrong with the collation existence lock management. It's unexpectedly unlocked at the moment when a convertion is attempted.

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

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

resolution: Fixed [ 1 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

Fix Version: 2.5.2 [ 10450 ]

@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 QA603 [ QA603 ]

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