"BLOB not found" error caused by "exception not defined" exception ------------------------------------------------------------------
Key: CORE-4390 URL: http://tracker.firebirdsql.org/browse/CORE-4390 Project: Firebird Core Issue Type: Bug Affects Versions: 3.0 Alpha 2, 2.5.2 Update 1 Reporter: prenosil In my database there is one table I am UPDATing (works fine), and another table that has trigger referencing first table. By mistake I run ALTER TRIGGER which referenced non existing exception, which raised (as excpected) error: Statement failed, SQLCODE = -104 invalid request BLR at offset 34 -exception ... not defined However, since this moment I am not able to update the first table, attempt to prepare the UPDATE will raise error Statement failed, SQLCODE = -901 BLOB not found Note 1 - there are no blobs in either of tables Note 2 - the problem disappears after closing all connections (i.e. no permanent damage to the database) Note 3 - tried with latest snapshots (FB2.5, FB3) Note 4 - I was not able to create simple test script, however I will send database for testing (fresh/empty one) -- 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 ------------------------------------------------------------------------------ Put Bad Developers to Shame Dominate Development with Jenkins Continuous Integration Continuously Automate Build, Test & Deployment Start a new project now. Try Jenkins in the cloud. http://p.sf.net/sfu/13600_Cloudbees Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel