Server crashes and DB becomes corrupt when updating against tables that have
been ALTERED
-----------------------------------------------------------------------------------------
Key: CORE-4981
URL: http://tracker.firebirdsql.org/browse/CORE-4981
Project: Firebird Core
Issue Type: Bug
Affects Versions: 3.0 RC 1
Reporter: Tim Kelly
Priority: Critical
I have noticed that Firebird 3 is not stable and can crash after I perform a
large number of ALTER statements to my tables / views. The crash doesn't happen
immediately but at some point later when an INSERT/UPDATE is performed
(presumably against the altered tables). This is a serious problem since the
database actually becomes corrupt and unusable, although can usually be fixed
by a backup and restore.
I wonder if perhaps the cause of the problem is that some internal caches are
not getting flushed after database structure has been ALTER'ed.
I'm sorry I am unable to produce a simple test-case at this time or be specific
about exactly what alteration is causing the problem.
Here is the corruption error I get when I reconnect to the database and perform
operations:
internal Firebird consistency check (applied differences will not fit in record
(177), file: sqz.cpp line: 127)
> Request generated error: internal Firebird consistency check (applied
> differences will not fit in record (177), file: sqz.cpp line: 127)
--
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
