Error During Savepoint Backout 290
Zsombor Cserna Votes: 0 Watchers: 1 Operations If you were logged in you would be able to see more operations. Firebird Core Consistency check error when invalid data inserted (file: exe.cpp line: 4097) Created: 11/Nov/14 06:04 AM Updated: 12/Nov/14 11:01 AM Component/s: Engine Affects Version/s: 3.0 Alpha 2, 2.5.3 Fix Version/s: None Environment: Any platform (linux, win) Issue Links: Duplicate This issue duplicates: CORE-4075 Server bugchecks or crashes on exception in calculated index Description « Hide Follow the next instructions: 1. create table T_TABLE ( F_YEAR varchar(4), F_MONTH_DAY varchar(5) ) 2. create index T_INDEX on T_TABLE computed by (cast(F_YEAR || '.' || F_MONTH_DAY as date)) 3. insert into T_TABLE (F_YEAR, F_MONTH_DAY) values ('2014', '02.33') --------------- conversion error from string "2014.02.33". internal Firebird consistency check (error during savepoint backout (290), file: exe.cpp line: 4097). Description Follow the next instructions: 1. create table T_TABLE ( F_YEAR varchar(4), F_MONTH_DAY varchar(5) ) 2. create index T_INDEX on T_TABLE computed by (cast(F_YEAR || '.' || F_MONTH_DAY as date)) 3. insert into T_TABLE (F_YEAR, F_MONTH_DAY) values ('2014', '02.33') --------------- conversion error from string "2014.02.33". internal Firebird consistency check (error during savepoint backout (290), file: exe.cpp line: 4097). Show » All Comments Change History Subversion Commits Sort Order: There are no comments yet on this issue. Powered by a free Atlassian JIRA open source license for Firebird (RDBMS). Try JIRA - bug tracking software for your team. Atlassian JIRA the Professional Issue Tracker. (Enterprise Edition, Version: 3.13.5-#360) - Bug/feature request - Atlassian news - Contact Administrators
savepoint backout (290)". Application is written in C++Builder 5, for backend IB 5.6 is used. App is multithreaded and runs on the same PC as Interbase server 24/7. Remote TCP/IP database path is used. Forced writes are on. From time to time we get this error on our database server. It happened on multiple machines. If we stop App and do database validation immediately after error - no errors are found in the database. Backup and restore runs just fine as well. The worst part about http://tracker.firebirdsql.org/browse/CORE-4603 this error is, that no more database operations can be performed after it has been raised. App or IB should be restarted. Does anybody have any input why it's happening? Thanks, Saulius Vabalas Craig Stuntz [TeamB Delphi Developer Mon, 10 Jan 2005 01:29:49 GMT Re:error during savepoint backout (290) In article <3d3ee06f$1_2@dnews>, supp...@glds.com says... Quote> We have one product which http://www.delphigroups.info/2/05/285576.html experiencing Interbase "error during savepoint > backout (290)". Is that the entire message? There's usually more text preceding this. How many generators are in the DB? -Craig -- Craig Stuntz (TeamB) Vertex Systems Corp. Columbus, OH Delphi/InterBase WebLog: http://delphi.weblogs.com InterBase PLANalyzer (Free IB optimization tool): http://delphi.weblogs.com/IBPLANalyzer Saulius Vabala Delphi Developer Mon, 10 Jan 2005 01:46:32 GMT Re:error during savepoint backout (290) Here are full error messages: SERVER (Server) Wed Jul 24 09:31:39 2002 Database: D:\TEST\\DATABASE\DATABASE.GDB internal gds software consistency check (error during savepoint backout (290)) SERVER (Server) Wed Jul 24 09:31:39 2002 Database: D:\TEST\\DATABASE\DATABASE.GDB internal gds software consistency check (error during savepoint backout (290)) Database has 79 Generators. Database Page size is 8192. Current test database I got error on has 4000+ database pages. Saulius "Craig Stuntz [TeamB]"
messages Antti Nivala Reply | Threaded Open this post in threaded view ♦ ♦ | Report Content as Inappropriate ♦ ♦ FB 1.5.3 RC3 bugcheck: internal gds software http://firebird.1100200.n4.nabble.com/FB-1-5-3-RC3-bugcheck-internal-gds-software-consistency-check-error-during-savepoint-backout-290-td1109926.html consistency check (error during savepoint backout (290)) I encountered the following errors when running multiple concurrent transactions with Firebird 1.5.3 RC3. I do not know the severity of this http://comments.gmane.org/gmane.comp.db.firebase.portuguese/102085 issue but I am reporting this on the devel list because I think that no normal failure during SQL processing should leave the database in the "can't continue after bugcheck" error during state. I am not sure in which order these errors appeared, but probably as follows: Execute SQL statement failed. SQLCODE=-913: deadlock IBCODE=isc_deadlock Execute SQL statement failed. SQLCODE=-913: deadlock internal gds software consistency check (error during savepoint backout (290)) IBCODE=isc_deadlock Transaction start failed. SQLCODE=-902: internal gds software consistency check (can't continue after bugcheck) IBCODE=isc_bug_check I had multiple (between 2 and 15) error during savepoint concurrent or almost concurrent transactions running so I cannot say for sure which operation caused which error. Anyway, the database ended up in the state where all operations returned the last error (can't continue after bugcheck). The operations where normal SQL operations, INSERT, UPDATE, SELECT and DELETE. So far I haven't been able to reproduce the problem. Is there something specific I should suspect or check? Is this kind of error "expected" in certain circumstances, or does it indicate a bug in Firebird 1.5.3 RC3 or corruption in the database file? Best regards, Antti Nivala ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_idv37&alloc_id865&op=clickFirebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel dimitr Reply | Threaded Open this post in threaded view ♦ ♦ | Report Content as Inappropriate ♦ ♦ Re: FB 1.5.3 RC3 bugcheck: internal gds software consistency check (error during savepoint backout (290)) "Antti