Hi Guys,
it took me some time to start testing this change, but it doesn't seem to work as i expected. After deploying our System with the H2 Database Version 1.3.174 (2013-10-19) the same problem occurs. Our System works complete transactional, although commits do not clean the internal h2 LOB Tables after their corresponding data record is deleted. The only way to stop the Database Files from growing is the use a shutdown compact regularly. I hope someone finds the time to take a look at this again or give me a hint what we are doing wrong. Thank you very much in advance, dresa dresa_ wrote > 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-tp4027264p4028398.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.
