Hi, I found this information in H2 roadmap (Version 1.3.x: Planned Changes, Priority 2): http://www.h2database.com/html/roadmap.html?highlight=mvcc&search=MVCC#firstFound
• MVCC: support transactionally consistent backups using SCRIPT Could you please also clarify the behaviour of BACKUP SQL statement? What will happen with new and existing connections if BACKUP statement will lock the database? Will these connections be rejected or will they wait until lock will be removed or will they wait for some timeout? Thank you very much, Alex On Jun 28, 8:55 am, Thomas Mueller <[email protected]> wrote: > Hi, > > > I can't use SCRIPT SQL statement because > > it provides transactionally inconsistent backup in case of MVCC mode. > > No, it shouldn't. Is that documented somewhere? Could you post the link? > > > > > According to H2 roadmap: > > >>> MVCC: support transactionally consistent backups using SCRIPT > > > As I know another way to backup H2 database online is to use BACKUP > > SQL statement. As far as I understand the statement locks database > > before coping db files. Could you please clarify how locking of > > database is performed in this case? What will happen with new and > > existing connections if BACKUP statement will lock the database? Will > > these connections be rejected or will they wait until lock will be > > removed? It's required for me to use backup method which doesn't > > reject other connections (new or existing connections must wait until > > backup is finished). > > > Thank you, > > Alex > > > -- > > 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.- Hide quoted text - > > - Show quoted text - -- 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.
