On Jun 24, 5:37 pm, Thomas Mueller <[email protected]> wrote: > Hi, > > > Unfortunately the database is continously growing > > Is just the database file growing (the .h2.db file), or is the > directory .lobs.db growing, or both?
Thats the interesting part. h2.db is growing. There is no .logb.db. I didnt set h2.lobInDatabase but I am still not getting the lobfiles. I guess my blobs are too small, 1.3kb according to DbVisualizer which I use to look at it. > > > completely clear every table. > > How do you do that? Could you call this method after cleaning the > tables, to find out if there is still some data left? I dont do it myself - I get messages over JMS from ActiveMQ and it deletes messages from the table itself. My test is to send 10k messages, get the same 10k messages and repeat that over a few times. > > SCRIPT TO 'test.sql'; > > Maybe the problem is temporary tables, but I'm not sure. According to script its empty. I dont see anything. I will attach it in another post. > > > Whats special about ActiveMQ is heavy use of blobs. > > Do you use the 'lobs in database' feature (system property > h2.lobsInDatabase)? I don't think it will solve the problem, but if > you don't use it, and the problem is the .lobs.db directory, could you > try? I tried with and without h2.lobInDatabase as in the doc( and lobsInDatabase to be sure I dont run into a typo). No change. I dont get a a lob directory, and it still grows. Btw, why is lobInDatabase off by default ? I normally have a lot of blobs, and having hundreds of thousands of files is giving me a bit of problems. Regards Alex > > Regards, > Thomas -- 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.
