Hi, It is possible, based on this huge DB, to see if some transaction are not commited (I have the DB of 12GB)? Can I add some debug settings on customer side?
Thanks. On 16 fév, 10:44, Thomas Mueller <[email protected]> wrote: > Hi, > > I would first analyze why it grows so much. Possibly an uncommitted > transaction? > > Regards, > Thomas > > > > > > > > On Thu, Feb 16, 2012 at 10:06 AM, Wolfgang Pedot <[email protected]> wrote: > > I have a related question: > > > Triggered by this request I tried what happens if I execute "shutdown > > compact" but do not close my connection-pool as well and as one > > could have expected the database was reopened at the first query after > > the shutdown without a problem. I also tried starting a new > > transaction while > > the compact was busy and that worked as well. > > > I guess this is not quite so different from what you are trying to > > implement (DB-Lock), are there any dangers to this aproach? > > The nice thing is that I dont have to restart my application, I just > > let it reopen the database. It does block all access to the database > > during operation but thats fine with me. > > > regards > > Wolfgang Pedot > > > -- > > 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 > > athttp://groups.google.com/group/h2-database?hl=en. -- 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.
