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.

Sign up for GitHub

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

Jump to bottom

Socket timeout exception #8415

Closed
hrstoyanov opened this issue Jul 19, 2018 · 3 comments
Closed

Socket timeout exception #8415

hrstoyanov opened this issue Jul 19, 2018 · 3 comments
Assignees
@luigidellaquila
Labels
bug
Milestone
3.0.5

Comments

@hrstoyanov
Copy link

hrstoyanov commented Jul 19, 2018 •
edited
Loading

OrientDB Version: 3.0.5-SNAPSHOT

Java Version: 8

OS: Windows

I am getting socket timeouts (after waiting for a while) for a very simple query in console:


orientdb {db=my.db}> select from Account

+----+-----+-------+--------+----+-------------+--------+------------------+--------------------+
|#   |@RID |@CLASS |stripeId|name|emailAddress |livemode|subscriptionStatus|subscriptionLivemode|
+----+-----+-------+--------+----+-------------+--------+------------------+--------------------+
|0   |#65:0|Account|test    |Test|[email protected]|false   |active            |false               |
+----+-----+-------+--------+----+-------------+--------+------------------+--------------------+

1 item(s) found. Query executed in 0.002 sec(s).
orientdb {db=my.db}> select from Staffer

orientdb {db=my.db}> select out('WorksFor') from Account

Error: com.orientechnologies.common.io.OIOException: Read timed out

Error: java.net.SocketTimeoutException: Read timed out

orientdb {db=my.db}> select in() from Account

Error: com.orientechnologies.common.io.OIOException: Read timed out

Error: java.net.SocketTimeoutException: Read timed out
@hrstoyanov
Copy link
Author

This could be another console bug!
When I try this in Studio, against the same database, I get (very quickly):

image

and in raw format:

{
    "result": [
        {
            "in()": [
                
            ]
        }
    ],
    "executionPlan": {
        "@type": "d",
        "@version": 0,
        "cost": 0,
        "prettyPrint": "+ FETCH FROM CLASS Account\n  + FETCH FROM CLUSTER 65 ASC\n  + FETCH FROM CLUSTER 66 ASC\n  + FETCH FROM CLUSTER 67 ASC\n  + FETCH FROM CLUSTER 68 ASC\n  + FETCH FROM CLUSTER 69 ASC\n  + FETCH FROM CLUSTER 70 ASC\n  + FETCH FROM CLUSTER 71 ASC\n  + FETCH FROM CLUSTER 72 ASC\n  + FETCH NEW RECORDS FROM CURRENT TRANSACTION SCOPE (if any)\n+ CALCULATE PROJECTIONS\n  in()",
        "type": "QueryExecutionPlan",
        "steps": [
            {
                "@type": "d",
                "@version": 0,
                "cost": -1,
                "subSteps": [
                    {
                        "@type": "d",
                        "@version": 0,
                        "cost": 0,
                        "subSteps": [
                            
                        ],
                        "name": "FetchFromClusterExecutionStep",
                        "description": "+ FETCH FROM CLUSTER 65 ASC",
                        "type": "FetchFromClusterExecutionStep",
                        "targetNode": "FetchFromClusterExecutionStep",
                        "javaType": "com.orientechnologies.orient.core.sql.executor.FetchFromClusterExecutionStep",
                        "@fieldTypes": "cost=l"
                    },
                    {
                        "@type": "d",
                        "@version": 0,
                        "cost": 0,
                        "subSteps": [
                            
                        ],
                        "name": "FetchFromClusterExecutionStep",
                        "description": "+ FETCH FROM CLUSTER 66 ASC",
                        "type": "FetchFromClusterExecutionStep",
                        "targetNode": "FetchFromClusterExecutionStep",
                        "javaType": "com.orientechnologies.orient.core.sql.executor.FetchFromClusterExecutionStep",
                        "@fieldTypes": "cost=l"
                    },
                    {
                        "@type": "d",
                        "@version": 0,
                        "cost": 0,
                        "subSteps": [
                            
                        ],
                        "name": "FetchFromClusterExecutionStep",
                        "description": "+ FETCH FROM CLUSTER 67 ASC",
                        "type": "FetchFromClusterExecutionStep",
                        "targetNode": "FetchFromClusterExecutionStep",
                        "javaType": "com.orientechnologies.orient.core.sql.executor.FetchFromClusterExecutionStep",
                        "@fieldTypes": "cost=l"
                    },
                    {
                        "@type": "d",
                        "@version": 0,
                        "cost": 0,
                        "subSteps": [
                            
                        ],
                        "name": "FetchFromClusterExecutionStep",
                        "description": "+ FETCH FROM CLUSTER 68 ASC",
                        "type": "FetchFromClusterExecutionStep",
                        "targetNode": "FetchFromClusterExecutionStep",
                        "javaType": "com.orientechnologies.orient.core.sql.executor.FetchFromClusterExecutionStep",
                        "@fieldTypes": "cost=l"
                    },
                    {
                        "@type": "d",
                        "@version": 0,
                        "cost": 0,
                        "subSteps": [
                            
                        ],
                        "name": "FetchFromClusterExecutionStep",
                        "description": "+ FETCH FROM CLUSTER 69 ASC",
                        "type": "FetchFromClusterExecutionStep",
                        "targetNode": "FetchFromClusterExecutionStep",
                        "javaType": "com.orientechnologies.orient.core.sql.executor.FetchFromClusterExecutionStep",
                        "@fieldTypes": "cost=l"
                    },
                    {
                        "@type": "d",
                        "@version": 0,
                        "cost": 0,
                        "subSteps": [
                            
                        ],
                        "name": "FetchFromClusterExecutionStep",
                        "description": "+ FETCH FROM CLUSTER 70 ASC",
                        "type": "FetchFromClusterExecutionStep",
                        "targetNode": "FetchFromClusterExecutionStep",
                        "javaType": "com.orientechnologies.orient.core.sql.executor.FetchFromClusterExecutionStep",
                        "@fieldTypes": "cost=l"
                    },
                    {
                        "@type": "d",
                        "@version": 0,
                        "cost": 0,
                        "subSteps": [
                            
                        ],
                        "name": "FetchFromClusterExecutionStep",
                        "description": "+ FETCH FROM CLUSTER 71 ASC",
                        "type": "FetchFromClusterExecutionStep",
                        "targetNode": "FetchFromClusterExecutionStep",
                        "javaType": "com.orientechnologies.orient.core.sql.executor.FetchFromClusterExecutionStep",
                        "@fieldTypes": "cost=l"
                    },
                    {
                        "@type": "d",
                        "@version": 0,
                        "cost": 0,
                        "subSteps": [
                            
                        ],
                        "name": "FetchFromClusterExecutionStep",
                        "description": "+ FETCH FROM CLUSTER 72 ASC",
                        "type": "FetchFromClusterExecutionStep",
                        "targetNode": "FetchFromClusterExecutionStep",
                        "javaType": "com.orientechnologies.orient.core.sql.executor.FetchFromClusterExecutionStep",
                        "@fieldTypes": "cost=l"
                    },
                    {
                        "@type": "d",
                        "@version": 0,
                        "cost": -1,
                        "subSteps": [
                            
                        ],
                        "name": "FetchTemporaryFromTxStep",
                        "description": "+ FETCH NEW RECORDS FROM CURRENT TRANSACTION SCOPE (if any)",
                        "type": "FetchTemporaryFromTxStep",
                        "targetNode": "FetchTemporaryFromTxStep",
                        "javaType": "com.orientechnologies.orient.core.sql.executor.FetchTemporaryFromTxStep",
                        "@fieldTypes": "cost=l"
                    }
                ],
                "name": "FetchFromClassExecutionStep",
                "description": "+ FETCH FROM CLASS Account\n   + FETCH FROM CLUSTER 65 ASC\n   + FETCH FROM CLUSTER 66 ASC\n   + FETCH FROM CLUSTER 67 ASC\n   + FETCH FROM CLUSTER 68 ASC\n   + FETCH FROM CLUSTER 69 ASC\n   + FETCH FROM CLUSTER 70 ASC\n   + FETCH FROM CLUSTER 71 ASC\n   + FETCH FROM CLUSTER 72 ASC\n   + FETCH NEW RECORDS FROM CURRENT TRANSACTION SCOPE (if any)",
                "type": "FetchFromClassExecutionStep",
                "targetNode": "FetchFromClassExecutionStep",
                "javaType": "com.orientechnologies.orient.core.sql.executor.FetchFromClassExecutionStep",
                "@fieldTypes": "cost=l,subSteps=z"
            },
            {
                "@type": "d",
                "@version": 0,
                "cost": 0,
                "subSteps": [
                    
                ],
                "name": "ProjectionCalculationStep",
                "description": "+ CALCULATE PROJECTIONS\n  in()",
                "type": "ProjectionCalculationStep",
                "targetNode": "ProjectionCalculationStep",
                "javaType": "com.orientechnologies.orient.core.sql.executor.ProjectionCalculationStep",
                "@fieldTypes": "cost=l"
            }
        ],
        "javaType": "com.orientechnologies.orient.core.sql.executor.OSelectExecutionPlan",
        "@fieldTypes": "cost=l,steps=z"
    },
    "notification": "Query executed in 0.008 sec. Returned 1 record(s)"
}

@hrstoyanov hrstoyanov mentioned this issue Jul 19, 2018
Closed
@luigidellaquila
Copy link
Member

HI @hrstoyanov

I'm checking it, it seems be a problem in the protocol
I'll let you know asap

Thanks

Luigi

@luigidellaquila luigidellaquila self-assigned this Jul 20, 2018
@luigidellaquila luigidellaquila added this to the 3.0.5 milestone Jul 20, 2018
luigidellaquila added a commit that referenced this issue Jul 20, 2018
@luigidellaquila
Fix graph traversal projections in SQL
b584a06 
Return a collection of RIDs instead of an OEdgeToVertexIterator, that
creates problems in remote

Resolves: #8415
@luigidellaquila
Copy link
Member

Hi @hrstoyanov

It was a problem on the query executor, I just pushed a fix

Thanks

Luigi

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@luigidellaquila luigidellaquila

Labels
bug
Milestone
3.0.5
Development

No branches or pull requests
2 participants
@luigidellaquila @hrstoyanov