Server crash on create index [CORE1049] #1468
Comments
|
Commented by: @hvlad Can you attach sample database with inserted record but without index ? |
|
Commented by: mbabuskov (mbabuskov) FWIW, I tried with embedded RC5, it doesn't crash and gives a little bit more useful error message: internal gds software consistency check (index key too big (174), file: idx.cpp line: 438) |
|
Commented by: @asfernandes This (key too big) is the same problem of CORE997, and I believe the crash is also fixed too. |
|
Commented by: @asfernandes Well, the crash problem was introduced in HEAD, so we need another test case. |
|
Commented by: Jan Hamann (jhamann) Database with table "test" but without index |
Modified by: Jan Hamann (jhamann)Attachment: TEST1.zip [ 10181 ] |
|
Commented by: @asfernandes Jan, where is the crash? This is exactly CORE997 error. |
|
Commented by: @dyemanov Maybe BugcheckAbort = 1? |
|
Commented by: Jan Hamann (jhamann) Can't reproduce the crash on my home machine. Will test tomorrow at work. |
|
Commented by: Jan Hamann (jhamann) Can't reproduce the crash. Sorry, false alarm. |
Modified by: @hvladstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Duplicate [ 3 ] Fix Version: 2.0.1 [ 10090 ] Fix Version: 2.1 [ 10041 ] |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
|
Commented by: @pcisar Reopened to update ticket information. |
Modified by: @pcisarWorkflow: jira [ 11386 ] => Firebird [ 15246 ] |
Modified by: @pavel-zotovQA Status: No test |
Submitted by: Jan Hamann (jhamann)
Is related to QA20
Duplicates CORE997
Attachments:
TEST1.zip
The Firebird server crashes on a CREATE INDEX statement. Seen also on database restore.
The index is created on a varchar field. The field has a collation order, is fully filled and has umlauts.
Steps to reproduce:
Create a database with default character set win1252 (page size 4096).
create table test
(
id integer not null,
txt varchar(50) collate pxw_intl850,
constraint pk_test primary key (id)
);
insert into test values (1, 'Kompaktseminar Prozessorganisation f?r F?hrungskr?');
commit;
Before creating the index you have to disconnect and connect because "object test is in use"-error.
create index testtxt on test(txt);
The server crashes with following error message:
ISC ERROR CODE:335544333
ISC ERROR MESSAGE:
internal gds software consistency check (can't continue after bugcheck)
The text was updated successfully, but these errors were encountered: