Firebird 6.0.0.2002 snapshot freezes or crashes while building an index

19 views
Skip to first unread message

Denis Simonov

unread,
Jun 11, 2026, 3:59:45 AM (4 days ago) Jun 11
to firebird-devel
Windows 10 Firebird 6.0.0.2002

CREATE TABLE BOOM (
  ID BIGINT NOT NULL,
  BYDATE TIMESTAMP NOT NULL
);

COMMIT;

INSERT INTO BOOM (ID, BYDATE)
SELECT S.N, cast('now' as timestamp)
from generate_series(1, 1000000) s(n);

commit;

-- inifiniti wait
create index idx_boom_bydate on boom(bydate);

commit;

Alex Peshkoff

unread,
Jun 11, 2026, 6:00:36 AM (4 days ago) Jun 11
to firebir...@googlegroups.com
On 6/11/26 10:59, Denis Simonov wrote:
Windows 10 Firebird 6.0.0.2002

CREATE TABLE BOOM (
  ID BIGINT NOT NULL,
  BYDATE TIMESTAMP NOT NULL
);

COMMIT;

INSERT INTO BOOM (ID, BYDATE)
SELECT S.N, cast('now' as timestamp)
from generate_series(1, 1000000) s(n);

commit;

-- inifiniti wait

Denis Simonov

unread,
Jun 11, 2026, 6:41:49 AM (4 days ago) Jun 11
to firebird-devel
I tested it on the artifacts https://github.com/FirebirdSQL/firebird/commit/94c649eed1c66d3697c763bf829e8e20093a6c83

The issue has been resolved. Thank you.

четверг, 11 июня 2026 г. в 13:00:36 UTC+3, Alex Peshkoff:
Reply all
Reply to author
Forward
0 new messages