orientechnologies/orientdb

OrientDB document graph NoSQL dbms

PVJ Pavan Kumar

@pvjpavankumar

Hi, I am trying to execute unionall query in server-side function

var db = orient.getDatabase();
var queryStmt = "select expand($d) ";
queryStmt = queryStmt + "\n" + "let $a = (SELECT content_id, description as Description, user_id, 'description' as search_type from Content WHERE SEARCH_FIELDS(['description'],'description:'"+keywords+"'') = true), $b = (SELECT content_id, user_tags as Topic, user_id, 'topic' as search_type from Content WHERE SEARCH_FIELDS(['user_tags'],'user_tags:'"+keywords+"'') = true), $c = (SELECT user_id, username, full_name, in('userFollow').size() as followers, out('userContent').size() as videos, 'hashtags' as search_type from User WHERE SEARCH_CLASS('"+keywords+"'*') = true), $d = unionAll($a,$b,$c)"

var result = db.command('sql',queryStmt);
return result;

But I am getting the below error

{
"errors": [
{
"reason": 400,
"code": 400,
"content": "Error parsing query:\nsql\n ^\nEncountered \" <IDENTIFIER> \"sql \"\" at line 1, column 1.\nWas expecting one of:\n <LET> ...\n <EXPLAIN> ...\n \r\n\tDB name=\"talkiez\"\r\n\tError Code=\"1\""
}
]
}

not sure what is wrong in the above function

can someone help me ?

VikramShityalkar

@VikramShityalkar

try following statement, or you can print the statement in logs and check OrientDB server console log.
var result = db.command(queryStmt);

PVJ Pavan Kumar

@pvjpavankumar

thanks Vikram, it didnt work

Willians Vivanco

@williansvi

Hi, i'm having this error...
com.orientechnologies.orient.core.exception.OSecurityAccessException: User 'app-api-recommendations' does not have permission to execute the operation 'Update' against the resource: ResourceGeneric [name=CLUSTER, legacyName=database.cluster].internal DB name="api-recommendations"

Any suggestion about which permission should i activate ?

PVJ Pavan Kumar

@pvjpavankumar

I guess write permissions for the user "app-api-recommendations"

Naseem Mahasneh

@naseem91

Hi
I have a problem while committing edges in OrientDB version (3.1.2)?? Any help

com.orientechnologies.orient.core.exception.OStorageException: Exception during execution of component operation inside component collections_22.sbc in storage DemoDB

msbomrel2020

@msbomrel2020

Hi All, When I run and stop the scala application as service. I got this error:
"Not more resources available in pool. Requested resource
P.S: I am using orientdb 1.6.6

Paul Agron

@nimzi

Ping

Hi Everyone, investigating the product on a mac but getting "Cannot find default script language for javascript" warning

Javascript is unavailable as an option in the studio

dang3rdud3

@dang3rdud3

Hi all, is there any way in the Java API to monitor the number of

all connections
all available (i.e. free) connections
all currently used connections

stoica-florian

@stoica-florian

Hi all, did anyone else encounter this issue before ? orientechnologies/orientdb#9431

edmonfrank

@EdmondFrank

hi all , when i try to use command "repair database --fix-links" to fix a database error, i got some some java.lang.NullPointerException. does anyone ever met the same problem?

emmanuel-ma

@emmanuel-ma

Hi all, I am trying to upgrade the OrientGo driver so that it supports OrientDB 3.0. Currently, it supports OrientDB 2.1 but I already implemented the support for OrientDB 2.2 and the next step is to implement the support for OrientDB 3.0 version. However, I did not find the documentation related with the binary protocol version 37 (It is used in OrientDB-3.0) in the official documentation (http://orientdb.com/docs/3.1.x/internals/Network-Binary-Protocol.html). Does someone know where I can find that documentation? I only have found in the Java and NodeJS drivers that there have been many changes in the network binary protocol from the Protocol version 37 but I think all is implemented in the code and there is not documentation. Some hints?

3ezdin-debug

@3ezdin-debug

Hi! I'm looking for the documentation of the access token in orient db to use it in application user authetication but can't find it.

Can anyone put the token documentation link please.

Thanks

Ps: rest api usage not binary

3ezdin-debug

@3ezdin-debug

Could not find the documentation on how to set up the /token/<db> but I did activated it by using the configuration 'network.http.useToken' set to 'true' in the bin/server.sh startup file by adding the argument -Dnetwork.http.useToken="true"
now I can authenticate using the /token/<db> endpoint and I receive access token.
I want to use orientdb to authenticate application users and by validating their token afterward in the application. (You think this is possible? scaling problems maybe one day?)
meanwhile to retrieve data from db I will make a technical user that will use the normal basic authentification OsessionId.
any thoughts? Thanks !

Ghost

@ghost~5fec2640d73408ce4ff7a57b

Hi, I am little new to OrientDB, can you tell me how to connect to OrientDB Cluster (Multi-Master) using pyorient

3ezdin-debug

@3ezdin-debug

@emmanuel-ma are you working on a specific open repo ?

I'm working on an app that uses rest api to communicate with orientdb.. the binary protocol will be a good step forward for go/orientdb community

Marcelo D. Ré

@mdre

Hi. Anyone is fighting with the huge sbc files?
I'am trying to find the way to reduce it but the OrientDB code is poorly documented, so is very hard to dive in.
I want to make a tool to shrink that files.

Bartosz Żbikowski

@bzbikowski

Hello, I'm having a problem with upgrading orientDB from 3.1.7 to 3.1.9 in a distributed configuration.

What I'm trying to do:

Stop orientdb
Delete old orientdb files except for orientdb-server-config.xml, databases and backups (that are being kept in separate folders)
Unpack new orientdb, add encryption key, correct backup setting, change permissions
Start OrientDB

But after starting the database, I'm receiving the following error:

Mar 01 16:15:09 xxx server.sh[75199]: 2021-03-01 16:15:09:251 INFO  [node1611150122103] Reassignment of clusters for database 'databasename' completed (classes=25) [OHazelcastPlugin][node1611150122103] Error on starting distributed plugin
Mar 01 16:15:09 xxx server.sh[75199]: java.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.Integer
Mar 01 16:15:09 xxx server.sh[75199]:         at com.orientechnologies.orient.server.distributed.ODistributedMomentum.getLSN(ODistributedMomentum.java:59)
Mar 01 16:15:09 xxx server.sh[75199]:         at com.orientechnologies.orient.server.distributed.ODistributedSyncConfiguration.load(ODistributedSyncConfiguration.java:101)
Mar 01 16:15:09 xxx server.sh[75199]:         at com.orientechnologies.orient.server.distributed.ODistributedSyncConfiguration.<init>(ODistributedSyncConfiguration.java:61)
Mar 01 16:15:09 xxx server.sh[75199]:         at com.orientechnologies.orient.server.distributed.impl.ODistributedDatabaseImpl.getSyncConfiguration(ODistributedDatabaseImpl.java:867)
Mar 01 16:15:09 xxx server.sh[75199]:         at com.orientechnologies.orient.server.hazelcast.OHazelcastPlugin$4.call(OHazelcastPlugin.java:898)
Mar 01 16:15:09 xxx server.sh[75199]:         at com.orientechnologies.orient.server.hazelcast.OHazelcastPlugin$4.call(OHazelcastPlugin.java:875)
Mar 01 16:15:09 xxx server.sh[75199]:         at com.orientechnologies.orient.server.distributed.impl.ODistributedAbstractPlugin.executeInDistributedDatabaseLock(ODistributedAbstractPlugin.java:1963)
Mar 01 16:15:09 xxx server.sh[75199]:         at com.orientechnologies.orient.server.hazelcast.OHazelcastPlugin.loadLocalDatabases(OHazelcastPlugin.java:871)
Mar 01 16:15:09 xxx server.sh[75199]:         at com.orientechnologies.orient.server.hazelcast.OHazelcastPlugin.startup(OHazelcastPlugin.java:317)
Mar 01 16:15:09 xxx server.sh[75199]:         at com.orientechnologies.orient.server.OServer.registerPlugins(OServer.java:1258)
Mar 01 16:15:09 xxx server.sh[75199]:         at com.orientechnologies.orient.server.OServer.activate(OServer.java:500)
Mar 01 16:15:09 xxx server.sh[75199]:         at com.orientechnologies.orient.server.OServerMain$1.run(OServerMain.java:49)
Mar 01 16:15:09 xxx server.sh[75199]: 2021-03-01 16:15:09:256 INFO  OrientDB Server is shutting down... [OServer]
Mar 01 16:15:09 xxx server.sh[75199]: 2021-03-01 16:15:09:256 INFO  Shutting down listeners: [OServer]

Does anyone know what can be the issue here?

Mauro Mariuzzo

@mmariuzzo

Hi, after a file system crash some OrientDB files were corrupted and removed by fsck. Fortunately they were indexes not tables. Unfortunately the last customer backup is too old.
Without these files I'm unable to connect to the database to do a repair.
There is a way to remove these file from the database metadata? Or recreate it empty? Or ignore on database connection?
I'm using 3.0.37

msbomrel2020

@msbomrel2020

OrienrDB V 2.2.0
This is working-> select from #22:0;
But not this -> select from Classname;

Does anybody have any idea?

Error log:

Error: com.orientechnologies.orient.core.sql.OCommandSQLParsingException: Error parsing query:
select from vertex
          ^
Encountered " <FROM> "from "" at line 1, column 8.
Was expecting one of:
    <NULL> ...
    "true" ...
    "false" ...
    "{" ...
    <NULL> ...
    "{" ...
    "true" ...
    "false" ...

msbomrel2020

@msbomrel2020

is Vertex reserved word in orient db v2.2.0 because it worked before in version 1.6.6

Luca Garulli

@lvca

try using `vertex `

Tim Whittington

@timw

Can anyone clarify what the future for manual indexes is, as the current state of code/docs is a bit confusing...

We've got an automatic index that we're querying directly , e.g. using SELECT COUNT(*) AS size FROM INDEX: syntax.
This triggers the "Manual indexes are deprecated and will be removed" warning, but this is for an automatic index.
The docs at http://orientdb.com/docs/3.1.x/indexing/Indexes.html are silent on deprecation of any of the direct index queries.

Is the intention that direct query of indexes is also deprecated and will be removed, or just the manual management of indexes?

rezab2

@rezab2

hi body.i want connect remote:localhost/dbname root root but i got error

anybody can help me?

Error: com.orientechnologies.orient.core.exception.ODatabaseException: Cannot open database

6 replies

this is message

rezab2

@rezab2

i run orientedb via docker

michele-pinto-kensu

@michele-pinto-kensu

Hello everyone, we are facing some issues with the performance of ODB, can someone help with this question related to how ODB applies the indexes when going through the edges? Thanks in advantage! https://discourse.orientdb.org/t/what-data-is-scanned-when-indexes-are-used-when-going-through-the-edges/1459

Marcelo D. Ré

@mdre

Hello everyone. I have create a java-function that return the full path between two OElement but I do not found the correct way to return it results.
Actually it collect all the path in ArraList<ArrayList<OElement>> but it is not shown in the Studio. I suppose that I should use something like OResultSet but I don't found anythig about its.

FilipStefaniuk

@FilipStefaniuk

Hello. I am using OrientDB 3.1.10 and I am interested in partitioned graphs multi tenancy solution (https://orientdb.org/docs/3.1.x/datamodeling/Multi-Tenant.html#use-partitioned-graphs). However in the security section of documentation, record level security feature is marked as deprecated (https://orientdb.org/docs/3.1.x/security/Database-Security.html#record-level-security-deprecated-in-v-31) and replaced by predicate security, which is more flexible but, as far as I understand, don't have out-of-the-box mechanism that sets appropriate fields on record creation (like ORestricted class did). What is a suggested approach? Should I create a hook that sets e.g. owner from a current user manually ?

5 replies

Jonathan D Strootman

@strootman

After I set lightweight edges to true, how do I verify it is set?
It does not appear in CONFIG nor PROPERTIES in console.

2 replies

Shreyank Sharma

@SHreyank4Real

Hi All,

we have a distributed orientdb deployed in kubernetes in 2 differenct region,
we planed to change the rootpassword in both the orietndb
after changing the password, one of the cluster worked properly, but another is starting giving following logs,

'''''
DB name="OurDB"
at com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.open(OAbstractPaginatedStorage.java:323)
at com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx.open(ODatabaseDocumentTx.java:259)
at com.orientechnologies.orient.server.OServer.openDatabase(OServer.java:988)
at com.orientechnologies.orient.server.OServer.openDatabase(OServer.java:958)
at com.orientechnologies.orient.server.OServer.openDatabase(OServer.java:949)
at com.orientechnologies.orient.server.network.protocol.binary.ONetworkProtocolBinary.openDatabase(ONetworkProtocolBinary.java:915)
at com.orientechnologies.orient.server.network.protocol.binary.ONetworkProtocolBinary.handshakeRequest(ONetworkProtocolBinary.java:249)
at com.orientechnologies.orient.server.network.protocol.binary.ONetworkProtocolBinary.execute(ONetworkProtocolBinary.java:214)
at com.orientechnologies.common.thread.OSoftThread.run(OSoftThread.java:82)
Caused by: com.orientechnologies.orient.core.exception.OStorageException: Cannot open storage it is acquired by other process

and this--

DB name="OSystem"
at com.orientechnologies.orient.core.storage.impl.local.paginated.OPaginatedStorageDirtyFlag.lockFile(OPaginatedStorageDirtyFlag.java:109)
at com.orientechnologies.orient.core.storage.impl.local.paginated.OPaginatedStorageDirtyFlag.open(OPaginatedStorageDirtyFlag.java:142)
at com.orientechnologies.orient.core.storage.impl.local.paginated.OLocalPaginatedStorage.preOpenSteps(OLocalPaginatedStorage.java:438)
at com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.open(OAbstractPaginatedStorage.java:271)
... 18 more

$ANSI{green {db=videoDB}} authenticate()
com.orientechnologies.orient.core.exception.OStorageException: Cannot open local storage '/orientdb/databases/OSystem' with mode=rw
""
and when we try to change the admin password, it is giving

com.orientechnologies.orient.server.distributed.ODistributedException: Quorum (2) cannot be reached on server "server2 name" because it is major than available node(1)

why orientdb wants to open OSystem db in mode=rw ?
and why db from one cluster allowed me to change password, where another is giving me Ouorum issues?

Thanks in advance

2 replies

Jonathan D Strootman

@strootman

https://discourse.orientdb.org/t/object-api-and-spring-data/1473
Anyone have anything?
Come on! Between this room and the discourse server, it's too quiet, lol

Roman

@UtmostCreator

Hello!

4 replies

Can someboby please help me with this error (during startup)
https://privatebin.net/?99a3c6727d0b638a#4LZLjnY7PCSybfHD97waNtuRyhxQDQuMZJhM882BP2Rd

OS windows 10 20H2
JDK 16.0.1
OrientDB 3.2.0

Where communities thrive

People

Repo info

Activity