Hello, we have issues with a steadily growing database file. I've already used the recovery tool and tracked the problem down to the internal LOB management.
here some basic information: - Database size after shutdown compact is only about 1 MB and it keeps growing over time ( it reached 1GB a few days ago ) - INFORMATION_SCHEMA.IN_DOUBT without entries - H2 version 1.3.171 - USED DB URL PARAMETER: MODE=Oracle;AUTO_SERVER=TRUE - h2.lobInDatabase is set true Cause of the problem is a table that is used for messaging between multiple systems and has one field with the type long raw ( which is stored in the lob table ). After an entry of this messaging table gets deleted the corresponding lob remains in the table INFORMATION_SCHEMA.LOB_DATA. Is there a way to get rid of this no longer required LOBs without executing and shutdown compact? Thank you very much in advance, dresa -- View this message in context: http://h2-database.66688.n3.nabble.com/h2-DB-File-growth-internal-LOB-tables-are-not-cleaned-up-tp4027264.html Sent from the H2 Database mailing list archive at Nabble.com. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
