search

orientechnologies / orientdb

OrientDB is the most versatile DBMS supporting Graph, Document, Reactive, Full-Text and Geospatial models in one Multi-Model product. OrientDB can run distributed (Multi-Master), supports SQL, ACID Transactions, Full-Text indexing and Reactive Queries.
https://orientdb.dev
Apache License 2.0
4.73k stars 870 forks source link

SErVER Can not change cache size in runtime because storage engine plocal was not registered #5482

Closed martingg88 closed 8 years ago

martingg88 commented 8 years ago

any idea for following issue when start orientdb server for 2.1.7 version.

SErVER Can not change cache size in runtime because storage engine plocal was not registered

StarpTech commented 8 years ago

@martingg88 I believe this issue was fixed in 2.1.8 please test.

martingg88 commented 8 years ago

fixed.

martingg88 commented 8 years ago

hey..do u have any idea on following issue. it worked before but now it can't connect to database at all.

Connecting to database [remote:localhost/voyage] with user 'root'... Error: com.orientechnologies.orient.core.exception.OStorageException: Cannot open local storage '/var/lib/orientdb/voyage' with mode=rw

StarpTech commented 8 years ago

Correct access rights for the db files and orientdb? When not please open a new issue.

luigidellaquila commented 8 years ago

Or trying to open a db created with a newer version of OrientDB?

martingg88 commented 8 years ago

access right fro the database folder is absolute correct and it work before.

@luigidellaquila the db is created before version 2.1.8 and have issue when open this database folder with 2.1.8 version. any idea how to solve this issue?

martingg88 commented 8 years ago

here is the stack ..'

Connecting to database [remote:localhost/voyage] with user 'root'... Error: com.orientechnologies.orient.core.exception.OStorageException: Cannot open local storage '/var/lib/orientdb/voyage' with mode=rw

Error: com.orientechnologies.common.concur.lock.OLockException: File '/var/lib/orientdb/voyage/internal.cpm' 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

StarpTech commented 8 years ago

@martingg88 Do you have open a orientdb console or another instance of orientdb?

martingg88 commented 8 years ago

i hv reboot my server and open console to connect the database. but doesn't work at all...faint like hell

StarpTech commented 8 years ago

@martingg88 You have only one connection open to the db (via console) ?

martingg88 commented 8 years ago

i dont' have any client connection to db yet.

StarpTech commented 8 years ago

ok then I don't know.

StarpTech commented 8 years ago

@martingg88 how do you open the db?

martingg88 commented 8 years ago

i run the following in order after reboot but have that issue.

  1. ./console.sh
  2. connect remote:localhost/voyage username password 3, db is locked

faint faint fain

martingg88 commented 8 years ago

1a. here is the log for start the server at initial stage.

2015-12-18 08:36:59:763 WARNI {db=voyage} Storage 'voyage' was not closed properly. Will try to recover from write ahead log [OLocalPaginatedStorage] 2015-12-18 08:36:59:763 INFO {db=voyage} Looking for last checkpoint... [OLocalPaginatedStorage] 2015-12-18 08:36:59:778 INFO {db=voyage} Found FUZZY checkpoint. [OLocalPaginatedStorage] 2015-12-18 08:36:59:780 INFO {db=voyage} Data restore procedure from FUZZY checkpoint is started. [OLocalPaginatedStorage] 2015-12-18 08:36:59:783 WARNI {db=voyage} Non tx operation was used during data modification we will need index rebuild. [OLocalPaginatedStorage] 2015-12-18 08:36:59:784 WARNI {db=voyage} Record OFuzzyCheckpointStartRecord{lsn=OLogSequenceNumber{segment=0, position=63020707}} com.orientechnologies.orient.core.storage.impl.local.paginated.wal.OFuzzyCheckpointStartRecord{lsn=null, previousCheckpoint=OLogSequenceNumber{segment=0, position=62880838}} will be skipped during data restore. [OLocalPaginatedStorage]

2a. use ./console.sh to conenct database and will have db is locked issue and following issue from server.

7}} will be skipped during data restore. [OLocalPaginatedStorage] 2015-12-18 08:36:59:808 SEVER {db=voyage} Invalid WAL record type was passed class com.orientechnologies.orient.core.storage.impl.local.paginated.wal.OFileTruncatedWALRecord. Given record will be skipped. [OLocalPaginatedStorage] 2015-12-18 08:36:59:810 SEVER {db=voyage} Invalid WAL record type was passed class com.orientechnologies.orient.core.storage.impl.local.paginated.wal.OFileTruncatedWALRecord. Given record will be skipped. [OLocalPaginatedStorage] 2015-12-18 08:36:59:928 SEVER {db=voyage} Invalid WAL record type was passed class com.orientechnologies.orient.core.storage.impl.local.paginated.wal.OFileTruncatedWALRecord. Given record will be skipped. [OLocalPaginatedStorage] 2015-12-18 08:36:59:929 SEVER {db=voyage} Invalid WAL record type was passed class com.orientechnologies.orient.core.storage.impl.local.paginated.wal.OFileTruncatedWALRecord. Given record will be skipped. [OLocalPaginatedStorage] 2015-12-18 08:36:59:941 SEVER {db=voyage} Invalid WAL record type was passed class com.orientechnologies.orient.core.storage.impl.local.paginated.wal.OFileTruncatedWALRecord. Given record will be skipped. [OLocalPaginatedStorage] 2015-12-18 08:36:59:942 SEVER {db=voyage} Invalid WAL record type was passed class com.orientechnologies.orient.core.storage.impl.local.paginated.wal.OFileTruncatedWALRecord. Given record will be skipped. [OLocalPaginatedStorage] 2015-12-18 08:36:59:948 SEVER {db=voyage} Invalid WAL record type was passed class com.orientechnologies.orient.core.storage.impl.local.paginated.wal.OFileTruncatedWALRecord. Given record will be skipped. [OLocalPaginatedStorage] 2015-12-18 08:36:59:949 SEVER {db=voyage} Invalid WAL record type was passed class com.orientechnologies.orient.core.storage.impl.local.paginated.wal.OFileTruncatedWALRecord. Given record will be skipped. [OLocalPaginatedStorage] 2015-12-18 08:36:59:953 SEVER {db=voyage} Invalid WAL record type was passed class com.orientechnologies.orient.core.storage.impl.local.paginated.wal.OFileTruncatedWALRecord. Given record will be skipped. [OLocalPaginatedStorage] 2015-12-18 08:36:59:954 SEVER {db=voyage} Invalid WAL record type was passed class com.orientechnologies.orient.core.storage.impl.local.paginated.wal.OFileTruncatedWALRecord. Given record will be skipped. [OLocalPaginatedStorage] 2015-12-18 08:36:59:958 SEVER {db=voyage} Invalid WAL record type was passed class com.orientechnologies.orient.core.storage.impl.local.paginated.wal.OFileTruncatedWALRecord. Given record will be skipped. [OLocalPaginatedStorage] 2015-12-18 08:36:59:959 SEVER {db=voyage} Invalid WAL record type was passed class com.orientechnologies.orient.core.storage.impl.local.paginated.wal.OFileTruncatedWALRecord. Given record will be skipped. [OLocalPaginatedStorage] 2015-12-18 08:36:59:966 SEVER {db=voyage} Invalid WAL record type was passed class com.orientechnologies.orient.core.storage.impl.local.paginated.wal.OFileTruncatedWALRecord. Given record will be skipped. [OLocalPaginatedStorage] 2015-12-18 08:36:59:971 SEVER {db=voyage} Invalid WAL record type was passed class com.orientechnologies.orient.core.storage.impl.local.paginated.wal.OFileTruncatedWALRecord. Given record will be skipped. [OLocalPaginatedStorage] 2015-12-18 08:36:59:978 SEVER {db=voyage} Invalid WAL record type was passed class com.orientechnologies.orient.core.storage.impl.local.paginated.wal.OFileTruncatedWALRecord. Given record will be skipped. [OLocalPaginatedStorage] 2015-12-18 08:36:59:979 SEVER {db=voyage} Invalid WAL record type was passed class com.orientechnologies.orient.core.storage.impl.local.paginated.wal.OFileTruncatedWALRecord. Given record will be skipped. [OLocalPaginatedStorage] 2015-12-18 08:36:59:982 SEVER {db=voyage} Invalid WAL record type was passed class com.orientechnologies.orient.core.storage.impl.local.paginated.wal.OFileTruncatedWALRecord. Given record will be skipped. [OLocalPaginatedStorage] 2015-12-18 08:36:59:983 SEVER {db=voyage} Invalid WAL record type was passed class com.orientechnologies.orient.core.storage.impl.local.paginated.wal.OFileTruncatedWALRecord. Given record will be skipped. [OLocalPaginatedStorage] 2015-12-18 08:36:59:987 SEVER {db=voyage} Invalid WAL record type was passed class com.orientechnologies.orient.core.storage.impl.local.paginated.wal.OFileTruncatedWALRecord. Given record will be skipped. [OLocalPaginatedStorage] 2015-12-18 08:36:59:994 SEVER {db=voyage} Invalid WAL record type was passed class com.orientechnologies.orient.core.storage.impl.local.paginated.wal.OFileTruncatedWALRecord. Given record will be skipped. [OLocalPaginatedStorage] 2015-12-18 08:36:59:996 SEVER {db=voyage} Invalid WAL record type was passed class com.orientechnologies.orient.core.storage.impl.local.paginated.wal.OFileTruncatedWALRecord. Given record will be skipped. [OLocalPaginatedStorage] 2015-12-18 08:37:00:000 SEVER {db=voyage} Invalid WAL record type was passed class com.orientechnologies.orient.core.storage.impl.local.paginated.wal.OFileTruncatedWALRecord. Given record will be skipped. [OLocalPaginatedStorage] 2015-12-18 08:37:00:007 SEVER {db=voyage} Invalid WAL record type was passed class com.orientechnologies.orient.core.storage.impl.local.paginated.wal.OFileTruncatedWALRecord. Given record will be skipped. [OLocalPaginatedStorage] 2015-12-18 08:37:00:007 SEVER {db=voyage} Invalid WAL record type was passed class com.orientechnologies.orient.core.storage.impl.local.paginated.wal.OFileTruncatedWALRecord. Given record will be skipped. [OLocalPaginatedStorage] 2015-12-18 08:37:00:015 SEVER {db=voyage} Invalid WAL record type was passed class com.orientechnologies.orient.core.storage.impl.local.paginated.wal.OFileTruncatedWALRecord. Given record will be skipped. [OLocalPaginatedStorage]

martingg88 commented 8 years ago

is there possible the server is locking for the db for recovering process while i'm try to connect db from console.sh?

martingg88 commented 8 years ago

it's urgent please help for this issue otherwise our server will be down forever.

StarpTech commented 8 years ago

Yes, you cannot open a connection in console if your server is running.

luigidellaquila commented 8 years ago

Hi @martingg88

does it open correctly with 2.1.7?

martingg88 commented 8 years ago

yes it work for 2.1.7 and work for 2.1.8 few times then corrupted.

luigidellaquila commented 8 years ago

@martingg88 I tried to reproduce the problem locally, but without success. How big is your db? Can you share it or something that allows me to reproduce it?

Thanks

Luigi

luigidellaquila commented 8 years ago

just another thing: when you say that it works a few times, do you mean that if you stop and restart the server then it reconnetcts for a while?

Thanks

Luigi

luigidellaquila commented 8 years ago

and again, how did you stop the db? If you hard killed the process, are you giving it time to do the full recovery?

martingg88 commented 8 years ago

yes...the server try to hard kiled the orientdb process that cause my database corrupted. so what i should to to resolve this issue?

luigidellaquila commented 8 years ago

ah, so the server is killing OrientDB process? Did it happen once or is it happening every time you restart the server? This could be a matter of low memory.

Does the db recovery succeed? Could you please post the full console log?

Thanks

Luigi

martingg88 commented 8 years ago

yes.. the server kill orientdb due to low memory. i don't think it run db recovery succeed. sorry i didn't keep the log. in case of db recovery fail and corrupt the db, what should i should do to recover the db

martingg88 commented 8 years ago

in between what is the recommend memory needed to run this orientdb? 1024mb should be enough?

martingg88 commented 8 years ago

any update on this?

andrii0lomakin commented 8 years ago

Hi @martingg88 ,

Let's do all steps one by one to recognize reason of your issue. Do you use Linux/Windows/Mac OS ?

martingg88 commented 8 years ago

yes...i'm using Linux centos 7 with 2 cores and 512mb RAM

andrii0lomakin commented 8 years ago

OK. And if you right now open database you get exception that file is blocked, do not you ?

Do you open this data database using server and remote: connection or plocal: connection ?

On Tue, Dec 22, 2015 at 5:02 AM martingg88 notifications@github.com wrote:

yes...i'm using Linux centos 7 with 2 cores and 512mb RAM

— Reply to this email directly or view it on GitHub https://github.com/orientechnologies/orientdb/issues/5482#issuecomment-166490072 .

Best regards, Andrey Lomakin, R&D lead. OrientDB Ltd

twitter:@Andrey_Lomakin linkedin:https://ua.linkedin.com/in/andreylomakin

martingg88 commented 8 years ago

i have not idea what cause the issue. The issue was gone after i restart my server few times. Anyway, what is the recommended hardward specification to run your orientdb at linux server?

andrii0lomakin commented 8 years ago

Fixed in latest 2.1.x version