I misread initially. You are using the script command to produce an SQL
script?
I'm not sure if that would work ? Wouldn't the MVCC isolate so the
changes don't propagate through to the other session?
On 8/05/2015 1:42 PM, Thomas Mueller wrote:
Hi,
> Should I still take my database offline when doing a backup?
Either this, or use the "backup" SQL statement. With the MVStore
storage, this should work very well. With the PageStore, it should
also work, but I didn't test as much.
Regards,
Thomas
On Friday, May 8, 2015, Ryan How <[email protected]
<mailto:[email protected]>> wrote:
I think you have to turn off the space re-using or something like
that while running the backup?
Maybe that should happen automatically as part of the script tool?
On 8/05/2015 7:48 AM, Rami Ojares wrote:
I tested it out and it seems that the backup becomes completely
corrupted.
So one should reserve the db exclusively for himself and only
then try the backup.
- rami
On 7.5.2015 21:24, Rami Ojares wrote:
Hi,
Now when I have moved to mvcc+multithreaded and do my backup
using Script tool the database stays responsive.
I think before every object was locked during backup.
But I started wondering about the consistency of the backup.
Consider the following scenario.
- Table T1 that has FK referring to T2.
- Backup has already processed T1
- Delete on T2 happens that with cascade mechanism removes a row
from T1
- Backup now processes T2
The backup is now inconsistent because T1 has a row that refers
to a non-existent row in T2.
Is this possible?
Should I still take my database offline when doing a backup?
- Rami
--
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]
<javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');>.
To post to this group, send email to [email protected]
<javascript:_e(%7B%7D,'cvml','[email protected]');>.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
--
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]
<mailto:[email protected]>.
To post to this group, send email to [email protected]
<mailto:[email protected]>.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
--
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/d/optout.
