Restore Database

34 views
Skip to first unread message

Pugazharasan Thirumalai

unread,
Nov 13, 2017, 6:48:49 AM11/13/17
to OrientDB
Hai, 

We are using Orientdb 2.0.18 version

Our database has crashed, when we try to restart my database am getting error .
Provide proper solution to restore my database. Its very urgent please reply soon, all customers are waiting.


2017-11-13 03:55:23:538 INFO  OrientDB auto-config DISKCACHE=12,926MB (heap=910MB os=15,885MB disk=65,193MB) [orientechnologies]
2017-11-13 03:55:23:567 INFO  Loading configuration from: /home/jai/orientdb-community-2.0.18/config/orientdb-server-config.xml... [OServerConfigurationLoaderXml]
2017-11-13 03:55:23:712 INFO  OrientDB Server v2.0.18 (build 2.0.x@r; 2016-02-02 14:01:56+0000) is starting up... [OServer]
2017-11-13 03:55:23:715 INFO  Databases directory: /home/jai/orientdb-community-2.0.18/databases [OServer]
2017-11-13 03:55:23:736 INFO  Listening binary connections on 0.0.0.0:2424 (protocol v.28, socket=default) [OServerNetworkListener]
2017-11-13 03:55:23:737 INFO  Listening http connections on 0.0.0.0:2480 (protocol v.10, socket=default) [OServerNetworkListener]
2017-11-13 03:55:23:745 INFO  Installing dynamic plugin 'studio-2.0.zip'... [OServerPluginManager]
2017-11-13 03:55:23:802 INFO  Installing GREMLIN language v.2.6.0 - graph.pool.max=50 [OGraphServerHandler]
2017-11-13 03:55:23:803 INFO  [OVariableParser.resolveVariables] Error on resolving property: distributed [orientechnologies]
2017-11-13 03:55:23:804 INFO  Installing Script interpreter. WARN: authenticated clients can execute any kind of code into the server by using the following allowed languages: [sql] [OServerSideScriptInterpreter]
2017-11-13 03:55:23:806 INFO  Automatic backup plugin installed and active: delay=86400000ms, firstTime=null, targetDirectory=backup/ [OAutomaticBackup]
2017-11-13 03:55:23:807 INFO  OrientDB Server v2.0.18 is active. [OServer]
2017-11-13 03:56:04:429 WARNING {db=mio} segment file 'database.ocf' was not closed correctly last time [OSingleFileSegment]
2017-11-13 03:56:04:493 WARNING {db=mio} Storage mio was not closed properly. Will try to restore from write ahead log. [OLocalPaginatedStorage]
2017-11-13 03:56:04:493 INFO  {db=mio} Looking for last checkpoint... [OLocalPaginatedStorage]
2017-11-13 03:56:04:498 INFO  {db=mio} Found FUZZY checkpoint. [OLocalPaginatedStorage]
2017-11-13 03:56:04:596 INFO  {db=mio} Data restore procedure from FUZZY checkpoint is started. [OLocalPaginatedStorage]
2017-11-13 03:56:04:661 WARNING {db=mio} Non tx operation was used during data modification we will need index rebuild. [OLocalPaginatedStorage]{db=mio} Exception during storage data restore.
com.orientechnologies.orient.core.exception.OStorageException: File with id 1211 does not exist.
at com.orientechnologies.orient.core.index.hashindex.local.cache.OWOWCache.openFile(OWOWCache.java:420)
at com.orientechnologies.orient.core.index.hashindex.local.cache.OReadWriteDiskCache.openFile(OReadWriteDiskCache.java:183)
at com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.restoreAtomicUnit(OAbstractPaginatedStorage.java:2283)
at com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.restoreFrom(OAbstractPaginatedStorage.java:2216)
at com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.restoreFromFuzzyCheckPoint(OAbstractPaginatedStorage.java:2187)
at com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.restoreFromCheckPoint(OAbstractPaginatedStorage.java:2162)
at com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.restoreFromWAL(OAbstractPaginatedStorage.java:2095)
at com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.restoreIfNeeded(OAbstractPaginatedStorage.java:1469)
at com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.open(OAbstractPaginatedStorage.java:171)
at com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx.open(ODatabaseDocumentTx.java:244)
at com.orientechnologies.orient.server.OServer.openDatabase(OServer.java:636)
at com.orientechnologies.orient.server.OServer.openDatabase(OServer.java:618)
at com.orientechnologies.orient.server.network.protocol.http.command.OServerCommandAuthenticatedDbAbstract.authenticate(OServerCommandAuthenticatedDbAbstract.java:167)
at com.orientechnologies.orient.server.network.protocol.http.command.OServerCommandAuthenticatedDbAbstract.beforeExecute(OServerCommandAuthenticatedDbAbstract.java:127)
at com.orientechnologies.orient.server.network.protocol.http.command.get.OServerCommandGetConnect.beforeExecute(OServerCommandGetConnect.java:50)
at com.orientechnologies.orient.server.network.protocol.http.ONetworkProtocolHttpAbstract.service(ONetworkProtocolHttpAbstract.java:173)
at com.orientechnologies.orient.server.network.protocol.http.ONetworkProtocolHttpAbstract.execute(ONetworkProtocolHttpAbstract.java:581)
at com.orientechnologies.common.thread.OSoftThread.run(OSoftThread.java:69)

2017-11-13 03:56:04:697 SEVERE {db=mio} Internal server error:
com.orientechnologies.orient.core.exception.OStorageException: Cannot open local storage '/home/jai/orientdb-community-2.0.18/databases/mio' with mode=rw
--> com.orientechnologies.orient.core.exception.OStorageException: File with id 1211 does not exist. [ONetworkProtocolHttpDb]
2017-11-13 04:00:06:333 WARNING {db=mio} segment file 'database.ocf' was not closed correctly last time [OSingleFileSegment]
2017-11-13 04:00:06:341 WARNING {db=mio} Storage mio was not closed properly. Will try to restore from write ahead log. [OLocalPaginatedStorage]
2017-11-13 04:00:06:341 INFO  {db=mio} Looking for last checkpoint... [OLocalPaginatedStorage]
2017-11-13 04:00:06:344 INFO  {db=mio} Found FUZZY checkpoint. [OLocalPaginatedStorage]
2017-11-13 04:00:06:419 INFO  {db=mio} Data restore procedure from FUZZY checkpoint is started. [OLocalPaginatedStorage]{db=mio} Exception during storage data restore.
com.orientechnologies.common.concur.lock.OLockException: File '/home/jai/orientdb-community-2.0.18/databases/mio/customer_activity.email_id_store_id_is_deleted.sbt' is locked by another process, maybe the database is in use by another process. Use the remote mode with a OrientDB server to allow multiple access to the same database.
at com.orientechnologies.orient.core.storage.fs.OAbstractFile.lock(OAbstractFile.java:415)
at com.orientechnologies.orient.core.storage.fs.OAbstractFile.openChannel(OAbstractFile.java:676)
at com.orientechnologies.orient.core.storage.fs.OAbstractFile.open(OAbstractFile.java:150)
at com.orientechnologies.orient.core.index.hashindex.local.cache.OWOWCache.openFile(OWOWCache.java:874)
at com.orientechnologies.orient.core.index.hashindex.local.cache.OWOWCache.openFile(OWOWCache.java:422)
at com.orientechnologies.orient.core.index.hashindex.local.cache.OReadWriteDiskCache.openFile(OReadWriteDiskCache.java:183)
at com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.restoreAtomicUnit(OAbstractPaginatedStorage.java:2283)
at com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.restoreFrom(OAbstractPaginatedStorage.java:2216)
at com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.restoreFromFuzzyCheckPoint(OAbstractPaginatedStorage.java:2187)
at com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.restoreFromCheckPoint(OAbstractPaginatedStorage.java:2162)
at com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.restoreFromWAL(OAbstractPaginatedStorage.java:2095)
at com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.restoreIfNeeded(OAbstractPaginatedStorage.java:1469)
at com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.open(OAbstractPaginatedStorage.java:171)
at com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx.open(ODatabaseDocumentTx.java:244)
at com.orientechnologies.orient.server.OServer.openDatabase(OServer.java:636)
at com.orientechnologies.orient.server.OServer.openDatabase(OServer.java:618)
at com.orientechnologies.orient.server.network.protocol.http.command.OServerCommandAuthenticatedDbAbstract.authenticate(OServerCommandAuthenticatedDbAbstract.java:167)
at com.orientechnologies.orient.server.network.protocol.http.command.OServerCommandAuthenticatedDbAbstract.beforeExecute(OServerCommandAuthenticatedDbAbstract.java:127)
at com.orientechnologies.orient.server.network.protocol.http.command.get.OServerCommandGetConnect.beforeExecute(OServerCommandGetConnect.java:50)
at com.orientechnologies.orient.server.network.protocol.http.ONetworkProtocolHttpAbstract.service(ONetworkProtocolHttpAbstract.java:173)
at com.orientechnologies.orient.server.network.protocol.http.ONetworkProtocolHttpAbstract.execute(ONetworkProtocolHttpAbstract.java:581)
at com.orientechnologies.common.thread.OSoftThread.run(OSoftThread.java:69)

2017-11-13 04:00:06:434 SEVERE {db=mio} Internal server error:
com.orientechnologies.orient.core.exception.OStorageException: Cannot open local storage '/home/jai/orientdb-community-2.0.18/databases/mio' with mode=rw
--> com.orientechnologies.common.concur.lock.OLockException: File '/home/jai/orientdb-community-2.0.18/databases/mio/customer_activity.email_id_store_id_is_deleted.sbt' is locked by another process, maybe the database is in use by another process. Use the remote mode with a OrientDB server to allow multiple access to the same database. [ONetworkProtocolHttpDb]
2017-11-13 04:02:36:320 WARNING {db=mio} segment file 'database.ocf' was not closed correctly last time [OSingleFileSegment]
2017-11-13 04:02:36:327 WARNING {db=mio} Storage mio was not closed properly. Will try to restore from write ahead log. [OLocalPaginatedStorage]
2017-11-13 04:02:36:327 INFO  {db=mio} Looking for last checkpoint... [OLocalPaginatedStorage]
2017-11-13 04:02:36:329 INFO  {db=mio} Found FUZZY checkpoint. [OLocalPaginatedStorage]
2017-11-13 04:02:36:406 INFO  {db=mio} Data restore procedure from FUZZY checkpoint is started. [OLocalPaginatedStorage]{db=mio} Exception during storage data restore.
com.orientechnologies.common.concur.lock.OLockException: File '/home/jai/orientdb-community-2.0.18/databases/mio/customer_activity.email_id_store_id_is_deleted.sbt' is locked by another process, maybe the database is in use by another process. Use the remote mode with a OrientDB server to allow multiple access to the same database.
at com.orientechnologies.orient.core.storage.fs.OAbstractFile.lock(OAbstractFile.java:415)
at com.orientechnologies.orient.core.storage.fs.OAbstractFile.openChannel(OAbstractFile.java:676)
at com.orientechnologies.orient.core.storage.fs.OAbstractFile.open(OAbstractFile.java:150)
at com.orientechnologies.orient.core.index.hashindex.local.cache.OWOWCache.openFile(OWOWCache.java:874)
at com.orientechnologies.orient.core.index.hashindex.local.cache.OWOWCache.openFile(OWOWCache.java:422)
at com.orientechnologies.orient.core.index.hashindex.local.cache.OReadWriteDiskCache.openFile(OReadWriteDiskCache.java:183)
at com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.restoreAtomicUnit(OAbstractPaginatedStorage.java:2283)
at com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.restoreFrom(OAbstractPaginatedStorage.java:2216)
at com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.restoreFromFuzzyCheckPoint(OAbstractPaginatedStorage.java:2187)
at com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.restoreFromCheckPoint(OAbstractPaginatedStorage.java:2162)
at com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.restoreFromWAL(OAbstractPaginatedStorage.java:2095)
at com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.restoreIfNeeded(OAbstractPaginatedStorage.java:1469)
at com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.open(OAbstractPaginatedStorage.java:171)
at com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx.open(ODatabaseDocumentTx.java:244)
at com.orientechnologies.orient.server.OServer.openDatabase(OServer.java:636)
at com.orientechnologies.orient.server.OServer.openDatabase(OServer.java:618)
at com.orientechnologies.orient.server.network.protocol.http.command.OServerCommandAuthenticatedDbAbstract.authenticate(OServerCommandAuthenticatedDbAbstract.java:167)
at com.orientechnologies.orient.server.network.protocol.http.command.OServerCommandAuthenticatedDbAbstract.beforeExecute(OServerCommandAuthenticatedDbAbstract.java:127)
at com.orientechnologies.orient.server.network.protocol.http.command.get.OServerCommandGetConnect.beforeExecute(OServerCommandGetConnect.java:50)
at com.orientechnologies.orient.server.network.protocol.http.ONetworkProtocolHttpAbstract.service(ONetworkProtocolHttpAbstract.java:173)
at com.orientechnologies.orient.server.network.protocol.http.ONetworkProtocolHttpAbstract.execute(ONetworkProtocolHttpAbstract.java:581)
at com.orientechnologies.common.thread.OSoftThread.run(OSoftThread.java:69)

2017-11-13 04:02:36:430 SEVERE {db=mio} Internal server error:
com.orientechnologies.orient.core.exception.OStorageException: Cannot open local storage '/home/jai/orientdb-community-2.0.18/databases/mio' with mode=rw
--> com.orientechnologies.common.concur.lock.OLockException: File '/home/jai/orientdb-community-2.0.18/databases/mio/customer_activity.email_id_store_id_is_deleted.sbt' is locked by another process, maybe the database is in use by another process. Use the remote mode with a OrientDB server to allow multiple access to the same database. [ONetworkProtocolHttpDb]
2017-11-13 04:06:59:509 WARNING {db=mio} segment file 'database.ocf' was not closed correctly last time [OSingleFileSegment]
2017-11-13 04:06:59:514 WARNING {db=mio} Storage mio was not closed properly. Will try to restore from write ahead log. [OLocalPaginatedStorage]
2017-11-13 04:06:59:515 INFO  {db=mio} Looking for last checkpoint... [OLocalPaginatedStorage]
2017-11-13 04:06:59:518 INFO  {db=mio} Found FUZZY checkpoint. [OLocalPaginatedStorage]
2017-11-13 04:06:59:587 INFO  {db=mio} Data restore procedure from FUZZY checkpoint is started. [OLocalPaginatedStorage]{db=mio} Exception during storage data restore.
com.orientechnologies.common.concur.lock.OLockException: File '/home/jai/orientdb-community-2.0.18/databases/mio/customer_activity.email_id_store_id_is_deleted.sbt' is locked by another process, maybe the database is in use by another process. Use the remote mode with a OrientDB server to allow multiple access to the same database.
at com.orientechnologies.orient.core.storage.fs.OAbstractFile.lock(OAbstractFile.java:415)
at com.orientechnologies.orient.core.storage.fs.OAbstractFile.openChannel(OAbstractFile.java:676)
at com.orientechnologies.orient.core.storage.fs.OAbstractFile.open(OAbstractFile.java:150)
at com.orientechnologies.orient.core.index.hashindex.local.cache.OWOWCache.openFile(OWOWCache.java:874)
at com.orientechnologies.orient.core.index.hashindex.local.cache.OWOWCache.openFile(OWOWCache.java:422)
at com.orientechnologies.orient.core.index.hashindex.local.cache.OReadWriteDiskCache.openFile(OReadWriteDiskCache.java:183)
at com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.restoreAtomicUnit(OAbstractPaginatedStorage.java:2283)
at com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.restoreFrom(OAbstractPaginatedStorage.java:2216)
at com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.restoreFromFuzzyCheckPoint(OAbstractPaginatedStorage.java:2187)
at com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.restoreFromCheckPoint(OAbstractPaginatedStorage.java:2162)
at com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.restoreFromWAL(OAbstractPaginatedStorage.java:2095)
at com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.restoreIfNeeded(OAbstractPaginatedStorage.java:1469)
at com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.open(OAbstractPaginatedStorage.java:171)
at com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx.open(ODatabaseDocumentTx.java:244)
at com.orientechnologies.orient.server.OServer.openDatabase(OServer.java:636)
at com.orientechnologies.orient.server.OServer.openDatabase(OServer.java:618)
at com.orientechnologies.orient.server.network.protocol.http.command.OServerCommandAuthenticatedDbAbstract.authenticate(OServerCommandAuthenticatedDbAbstract.java:167)
at com.orientechnologies.orient.server.network.protocol.http.command.OServerCommandAuthenticatedDbAbstract.beforeExecute(OServerCommandAuthenticatedDbAbstract.java:127)
at com.orientechnologies.orient.server.network.protocol.http.command.get.OServerCommandGetConnect.beforeExecute(OServerCommandGetConnect.java:50)
at com.orientechnologies.orient.server.network.protocol.http.ONetworkProtocolHttpAbstract.service(ONetworkProtocolHttpAbstract.java:173)
at com.orientechnologies.orient.server.network.protocol.http.ONetworkProtocolHttpAbstract.execute(ONetworkProtocolHttpAbstract.java:581)
at com.orientechnologies.common.thread.OSoftThread.run(OSoftThread.java:69)

2017-11-13 04:06:59:605 SEVERE {db=mio} Internal server error:
com.orientechnologies.orient.core.exception.OStorageException: Cannot open local storage '/home/jai/orientdb-community-2.0.18/databases/mio' with mode=rw
--> com.orientechnologies.common.concur.lock.OLockException: File '/home/jai/orientdb-community-2.0.18/databases/mio/customer_activity.email_id_store_id_is_deleted.sbt' is locked by another process, maybe the database is in use by another process. Use the remote mode with a OrientDB server to allow multiple access to the same database. [ONetworkProtocolHttpDb]


Thanks and Regards,
T.Pugazhaarasan

Oleksandr Gubchenko

unread,
Nov 14, 2017, 2:34:31 AM11/14/17
to OrientDB
The version that you are using is old, try to run it with the latest 2.2.x and if it doesn't help on the latest version you can also try REPAIR DATABASE command.
Reply all
Reply to author
Forward
0 new messages