"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

Reply via email to