Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Class not found after query parsing error #5075

Closed
serenic opened this issue Oct 8, 2015 · 6 comments
Closed

Class not found after query parsing error #5075

serenic opened this issue Oct 8, 2015 · 6 comments
Assignees
Milestone

Comments

@serenic
Copy link

serenic commented Oct 8, 2015

Orientdb 2.0.13

Log:

2015-10-08 10:10:31:331 INFO  [OVariableParser.resolveVariables] Error on resolving property: distributed [orientechnologies]
2015-10-08 10:10:31:332 INFO  Installing Script interpreter. WARN: authenticated clients can execute any kind of code into the server by using the following allowed languages: [sql] [OServerSideScriptInterpreter]
2015-10-08 10:10:31:332 INFO  OrientDB Server v2.0.13 is active. [OServer]Sent run-time exception to the client /127.0.0.1:34499: com.orientechnologies.orient.core.sql.OCommandSQLParsingException: Error on parsing command at position #32: Invalid keyword ''2015-10-07 16:36:55''
Command: select from user where createdAt>'2015-10-07 16:36:55'
----------------------------------------^
com.orientechnologies.orient.core.sql.OCommandSQLParsingException: Error on parsing command at position #32: Invalid keyword ''2015-10-07 16:36:55''
Command: select from user where createdAt>'2015-10-07 16:36:55'
----------------------------------------^
    at com.orientechnologies.orient.core.sql.OCommandExecutorSQLAbstract.throwParsingException(OCommandExecutorSQLAbstract.java:93)
    at com.orientechnologies.orient.core.sql.OCommandExecutorSQLSelect.parse(OCommandExecutorSQLSelect.java:251)
    at com.orientechnologies.orient.core.sql.OCommandExecutorSQLSelect.parse(OCommandExecutorSQLSelect.java:78)
    at com.orientechnologies.orient.core.sql.OCommandExecutorSQLDelegate.parse(OCommandExecutorSQLDelegate.java:56)
    at com.orientechnologies.orient.core.sql.OCommandExecutorSQLDelegate.parse(OCommandExecutorSQLDelegate.java:37)
    at com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.command(OAbstractPaginatedStorage.java:1178)
    at com.orientechnologies.orient.core.sql.query.OSQLQuery.run(OSQLQuery.java:71)
    at com.orientechnologies.orient.core.sql.query.OSQLSynchQuery.run(OSQLSynchQuery.java:85)
    at com.orientechnologies.orient.core.query.OQueryAbstract.execute(OQueryAbstract.java:33)
    at com.orientechnologies.orient.server.network.protocol.binary.ONetworkProtocolBinary.command(ONetworkProtocolBinary.java:1183)
    at com.orientechnologies.orient.server.network.protocol.binary.ONetworkProtocolBinary.executeRequest(ONetworkProtocolBinary.java:390)
    at com.orientechnologies.orient.server.network.protocol.binary.OBinaryNetworkProtocolAbstract.execute(OBinaryNetworkProtocolAbstract.java:217)
    at com.orientechnologies.common.thread.OSoftThread.run(OSoftThread.java:69)
Sent run-time exception to the client /127.0.0.1:35067: com.orientechnologies.orient.core.exception.OQueryParsingException: Error on parsing query at position #5: Error on parsing query
Query:  user  WHERE @rid = "11:2"  LIMIT 1
----------^
com.orientechnologies.orient.core.exception.OQueryParsingException: Error on parsing query at position #5: Error on parsing query
Query:  user  WHERE @rid = "11:2"  LIMIT 1
----------^
    at com.orientechnologies.orient.core.sql.filter.OSQLTarget.(OSQLTarget.java:76)
    at com.orientechnologies.orient.core.sql.OSQLEngine.parseTarget(OSQLEngine.java:440)
    at com.orientechnologies.orient.core.sql.OCommandExecutorSQLSelect.parse(OCommandExecutorSQLSelect.java:200)
    at com.orientechnologies.orient.core.sql.OCommandExecutorSQLSelect.parse(OCommandExecutorSQLSelect.java:78)
    at com.orientechnologies.orient.core.sql.OCommandExecutorSQLDelegate.parse(OCommandExecutorSQLDelegate.java:56)
    at com.orientechnologies.orient.core.sql.OCommandExecutorSQLDelegate.parse(OCommandExecutorSQLDelegate.java:37)
    at com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.command(OAbstractPaginatedStorage.java:1178)
    at com.orientechnologies.orient.core.command.OCommandRequestTextAbstract.execute(OCommandRequestTextAbstract.java:63)
    at com.orientechnologies.orient.server.network.protocol.binary.ONetworkProtocolBinary.command(ONetworkProtocolBinary.java:1183)
    at com.orientechnologies.orient.server.network.protocol.binary.ONetworkProtocolBinary.executeRequest(ONetworkProtocolBinary.java:390)
    at com.orientechnologies.orient.server.network.protocol.binary.OBinaryNetworkProtocolAbstract.execute(OBinaryNetworkProtocolAbstract.java:217)
    at com.orientechnologies.common.thread.OSoftThread.run(OSoftThread.java:69)
Caused by: com.orientechnologies.orient.core.exception.OCommandExecutionException: Class 'USER' was not found in current database
    at com.orientechnologies.orient.core.sql.filter.OSQLTarget.extractTargets(OSQLTarget.java:262)
    at com.orientechnologies.orient.core.sql.filter.OSQLTarget.(OSQLTarget.java:67)
    ... 11 more

List of classes before error:

CLASSES
----------------------------------------------+------------------------------------+------------+----------------+
 NAME                                         | SUPERCLASS                         | CLUSTERS   | RECORDS        |
----------------------------------------------+------------------------------------+------------+----------------+
 E                                            |                                    | 10         |              0 |
 OFunction                                    |                                    | 6          |              0 |
 OIdentity                                    |                                    | -          |              0 |
 ORestricted                                  |                                    | -          |              0 |
 ORIDs                                        |                                    | 8          |              0 |
 ORole                                        | OIdentity                          | 4          |              3 |
 OSchedule                                    |                                    | 7          |              0 |
 OTriggered                                   |                                    | -          |              0 |
 OUser                                        | OIdentity                          | 5          |              3 |
 stat                                         | V                                  | 12         |              1 |
 user                                         | V                                  | 11         |              0 |
 V                                            |                                    | 9          |              0 |
----------------------------------------------+------------------------------------+------------+----------------+
 TOTAL = 12                                                                                                    7 |
----------------------------------------------+------------------------------------+------------+----------------+

after:

CLASSES
----------------------------------------------+------------------------------------+------------+----------------+
 NAME                                         | SUPERCLASS                         | CLUSTERS   | RECORDS        |
----------------------------------------------+------------------------------------+------------+----------------+
 E                                            |                                    | 10         |              0 |
 OFunction                                    |                                    | 6          |              0 |
 OIdentity                                    |                                    | -          |              0 |
 ORestricted                                  |                                    | -          |              0 |
 ORIDs                                        |                                    | 8          |              0 |
 ORole                                        | OIdentity                          | 4          |              3 |
 OSchedule                                    |                                    | 7          |              0 |
 OTriggered                                   |                                    | -          |              0 |
 OUser                                        | OIdentity                          | 5          |              3 |
 stat                                         | V                                  | 12         |              1 |
 V                                            |                                    | 9          |              0 |
----------------------------------------------+------------------------------------+------------+----------------+
 TOTAL = 11                                                                                                    7 |
----------------------------------------------+------------------------------------+------------+----------------+
@luigidellaquila
Copy link
Member

Hi @serenic

This should be fixed in 2.1 release, any chance to try it?

Thanks

@serenic
Copy link
Author

serenic commented Oct 8, 2015

Ok, try it. But I can't reproduce this bug again with ver 2.0.13.

@serenic
Copy link
Author

serenic commented Oct 9, 2015

Again...

Sails.js:
User.update command

OrientDB ver. 2.1

@serenic
Copy link
Author

serenic commented Oct 9, 2015

OK, this is a sails.js bug: if I change the source code, while running.

@lvca lvca added the bug label Oct 15, 2015
@lvca lvca added this to the 2.2 milestone Nov 24, 2015
@lvca lvca modified the milestones: 2.2.0-beta, 2.2.0-rc1 Dec 13, 2015
@wolf4ood
Copy link
Member

wolf4ood commented Feb 2, 2016

hi @serenic

can i close this?

@lvca lvca modified the milestones: 2.2.0-rc1, 2.2.0 GA May 7, 2016
@wolf4ood
Copy link
Member

wolf4ood commented May 9, 2016

hi @serenic
Seems resolved i'm closing this. If it is not. Please reopen it

Thanks

@wolf4ood wolf4ood closed this as completed May 9, 2016
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Development

No branches or pull requests

5 participants