Firebird 6.0.0.2002 snapshot freezes or crashes while building an index

[Denis Simonov]

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]

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

should be fixed with
https://github.com/FirebirdSQL/firebird/commit/e0d62fab00618d1d5bb0e2d0b3163f7b9782429b

[Denis Simonov]

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: