Hi, We faced with LOB storage corruption when LOBS are stored inside database.
The problem is in LobStorage.addLob() method, which clears failed LOBs only in case of IOException. If any other exception is thrown (IllegalStateException from org.eclipse.jetty.io.nio.SslSelectChannelEndPoint while readFully() method execution in our case), then LOB storage gets corrupted and all further LOB saving operations fail with the following exception: Unique index or primary key violation: "PRIMARY_KEY_3 ON INFORMATION_SCHEMA.LOB_MAP(LOB, SEQ)"; SQL statement: INSERT INTO INFORMATION_SCHEMA.LOB_MAP(LOB, SEQ, HASH, BLOCK) VALUES(?, ?, ?, ?) Please correct this to clear failed LOBs (call deleteLob(lobId)) in case of any problems, not only IOException. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
