Forum: Building VoltDB Applications

Post: Problems performing @SnapshotSave and @SnapshotRestore

Problems performing @SnapshotSave and @SnapshotRestore
Ivo Abeloos
Jul 15, 2015
Hi,

I'm testing the snapshot save/restore calls: @SnapshotSave and @SnapshotRestore

I created two java tests starting an in-memory server:

ServerThread server = new ServerThread(config);
server.start();
server.waitForInitialization();

The first test creates a table A and inserts some data in it via jdbc and performs a @SnapshotSave. There is data written to disk:
test.jar
test-A.vpt
test-host_0.digest
test-host_0.finished
test-host_0.hash

The second test attempts to restore the snapshot using @SnapshotRestore. The restore call itself does not fail but no tables are being restored, hence I always get the following error when trying the access the table:

user lacks privilege or object not found: A

Any ideas what I am doing wrong?

Thanks,

--Ivo
pzhao
Jul 15, 2015
Ivo,

It appears the table 'A' does not exist in your schema. Please try to reload your schema prior to using @SnapshotRestore.
Here is documentation on saving and restoring VoltDB Database.

Peter Zhao