Hi, We are using 1.3.163 version of h2db as an embedded db in a single thread mode.
I have encounter a problem that it is impossible to stop application while 'BACKUP TO' sql statement is in execution. It is a big problem for our project. Our clients databases can be around 1GB size and backup procedure takes sensible time. Our product works as a service and could not be gracefully be stopped through windows services control while backup is running (it runs on a scheduled basis). It is crucial when client performing upgrade of our project to newer version (while an upgrade we stop a service, install new files and than start the service) because if upgrade performs when backup being executed upgrade fails. I have dived into this problem and found that source of problem is that application context could not stop datasource. It happens due to backup operation is synchronized on the Database object and Database.removeSession(...) method is a synchronized method, so datasource could not be stopped until backup completes. I have also noticed that in Session.close() method there is a call to Database.checkPowerOff(), may be I utilize it to reach needed behavior, but I don't know will it help and is it safe. Is there a way to interrupt execution of the backup query? May be there is some options that we could specify in database url when setup datasource? Thanks! -- 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
