SQLCODE: -902 - internal Firebird consistency check (can't continue after
bugcheck)
-----------------------------------------------------------------------------------
Key: CORE-6378
URL: http://tracker.firebirdsql.org/browse/CORE-6378
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.4, 3.0.3, 3.0.2, 3.0.1, 3.0.0
Environment: Debian 9.12 (stretch) amd64, firebird-3.0.4.33054-0
Reporter: Russell Stuart
Every few months we get this error:
Error while rolling back transaction:
- SQLCODE: -902
- internal Firebird consistency check (can't continue after bugcheck)
You get it when you do a select on a table; it's almost always the same table
(the database has about 200 tables). The problem can be usually worked around
by dropping that table, and reloading old data from a backup.
Background information: it's been happening for literally years, probably going
back to version 2.5 or possibly even earlier. ServerMode is "Classic".
The access pattern of the database is unusual. It is a replica of a (non-SQL)
database. Updates from the replica happen every few minutes. These updates
are large, and happen in a single transaction. Those updates are the only way
the database is changed, and there is only ever one happening at any one time,
so there is only ever one writer. There up to 200 people reading from the
database simultaneously while the updates are happening. Overnight the entire
database (the .fdb is 7GB .. 8GB) is discarded and rebuilt from scratch. There
are several other firebird databases in use simultaneously by the same
application that see similar loads, but have a more typical usage pattern. They
don't have a problem.
I am a experienced C programmer (and some C++), and am happy to instrument &
recompile the server as required.
The database is hosted on a dual Xeon Dell 740, and lives on a mirrored SSD.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
