OrientDB restore -> database is closed

Question

I have a db.zip archive (with .cpm, .pcl, .irs,.sbt, .wal, ... files) I like to restore

create database plocal:mydb admin admin
restore database /path/to/db.zip

Restoring database database /path/to/db.zip...
- Uncompressing file $FILE1_IN_ARCHIVE [...snip...]
- [...snip...]
Database restored in 0.19 seconds

To me, it seems as the restore was successful. However, whatever next command I use (e.g. select * from V) I get the following error:

Error: com.orientechnologies.orient.core.exception.ODatabaseException: Database 'mydb' is closed

Am I doing something wrong? Why is the DB closed? How could I open it?

Hi, did you execute an EXPORT or a BACKUP of your original DB ? — LucaS

LucaS LucaS · Accepted Answer · 2016-03-10T01:26:17

I tried your case with OrientDB version 2.1.11 following these steps (previously I created a backup copy of a DB with the new name mydb.zip).

Create the new DB:

create database plocal:/path/to/db/newDB admin admin

Creating database [plocal:/path/to/db/newDB] using the storage type [plocal]...

Database created successfully.

Restore mydb.zip:

restore database C:/path/to/db/mydb.zip

Restoring database database C:/path/to/db/mydb.zip...
...
Database restored in 0,29 seconds

Select all vertices from V (I get your same exception):

orientdb {db=newDB}> select * from V

Error: com.orientechnologies.orient.core.exception.ODatabaseException: Database 'newDB'
       is closed

This (your) problem seems to be related to this issue where it's explained that the access to a DB in plocal mode with another running OrientDB instance generates a conflict. If you shutdown the opened OrientDB instance and try to connect to the DB in plocal mode, you'll be able to access to the DB.

Shutdown the running OrientDB instance and re-connect in plocal mode:

orientdb> connect plocal:/path/to/db/newDB admin admin

Connecting to database [plocal:/path/to/db/newDB] with user 'admin'...OK

Select again all vertices from V:

orientdb {db=newDB}> select * from V

----+-----+-------+------+--------
#   |@RID |@CLASS |name  |category
----+-----+-------+------+--------
0   |#12:0|Station|First |#13:0
1   |#12:1|Station|Second|#13:1
2   |#12:2|Station|Third |#13:2
----+-----+-------+------+--------

Anyway, I tried also with the new OrientDB 2.2.0 beta and, with this version, this behaviour doesn't happen:

    Restoring database 'database C:/path/to/db/mydb.zip' from full backup...
    ...
    Database restored in 0,75 seconds

    orientdb {db=newDB}> select * from V

    ----+-----+-------+------+--------
    #   |@RID |@CLASS |name  |category
    ----+-----+-------+------+--------
    0   |#12:0|Station|First |#13:0
    1   |#12:1|Station|Second|#13:1
    2   |#12:2|Station|Third |#13:2
    ----+-----+-------+------+--------

Hope it helps

OrientDB restore -> database is closed

1 Answers