I am running hsqldb 220.127.116.11 embedded and I have a text table which is mapped to a csv file.
Sometimes (although very few times) I receive a DuplicateException after restarting my application and I have noticed that some lines that are already at the csv are also at .script file.
I am doing shutdown compact. I also have noticed that sometimes after another restart it recovers.
Can you help explaining the cause of this duplication ? The database was not shut down properly ?
It is possibly due to a lack of proper shutdown.
The implementation has changed in 1.9 and it should not write any rows to the .script or .log file during operation. It writes all the rows to .script only at shutdown compact.
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.