SEVERE: Fetching error ... Record with rid #0:1 was not found in database

[Thom]

After running for a while one query stops working (although it previously worked without any problems for the same data!)

 WARNING: Error deserializing record with id #37:233 send this data for debugging: ABZEYXRhX0dyb3VwcwhwYXRoAAAAaAdVAAAAmwxwYXJlbnQAAADcBwxJTVBPUlQAAAEFBwhuYW1lAAABJQcIdGV4dAAAAS8HCHR5cGUAAAEwBwhpMThuAAABNQcKZ3JvdXAAAAE4BwBkcHJvZHVrdGthdGFsb2cvYnlnZ2VyaS9lcmdvLTQwMDAtc2VyaWVuL2VyZ28tNDA1Mi8EBwp1cmwtbAAAALIHBwZ1cmwAAADHBygvcGljcy8wOTlkMzAxMDU2LmpwZygvcGljcy9iOGYyMjEwMmE3LmpwZ1Bwcm9kdWt0a2F0YWxvZy9ieWdnZXJpL2VyZ28tNDAwMC1zZXJpZW4vPkRBTkFMSU1fSU1QT1JUXzIwMTYtMzItMTIgMTE6MzISRXJnbyA0MDUyAAhsZWFmBGRrDmJ5Z2dlcmk=
 
SEVERE: Fetching error on record #37:233
 com.orientechnologies.orient.core.exception.ORecordNotFoundException: Record with rid #0:1 was not found in database
     at com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx.reload(ODatabaseDocumentTx.java:1649)
     at com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx.reload(ODatabaseDocumentTx.java:121)
     at com.orientechnologies.orient.core.record.ORecordAbstract.reload(ORecordAbstract.java:265)
     at com.orientechnologies.orient.core.record.ORecordAbstract.reload(ORecordAbstract.java:256)
     at com.orientechnologies.orient.core.record.impl.ODocument.reload(ODocument.java:654)
     at com.orientechnologies.orient.core.type.ODocumentWrapper.reload(ODocumentWrapper.java:91)
     at com.orientechnologies.orient.core.type.ODocumentWrapperNoClass.reload(ODocumentWrapperNoClass.java:73)
     at com.orientechnologies.orient.core.metadata.schema.OSchemaShared.reload(OSchemaShared.java:568)
     at com.orientechnologies.orient.core.metadata.schema.OSchemaProxy.reload(OSchemaProxy.java:192)
     at com.orientechnologies.orient.core.metadata.OMetadataDefault.reload(OMetadataDefault.java:225)
     at com.orientechnologies.orient.core.record.impl.ODocument.getGlobalPropertyById(ODocument.java:2167)
     at com.orientechnologies.orient.core.record.impl.ODocumentInternal.getGlobalPropertyById(ODocumentInternal.java:60)
     at com.orientechnologies.orient.core.serialization.serializer.record.binary.ORecordSerializerBinaryV0.getGlobalProperty(ORecordSerializerBinaryV0.java:280)
     at com.orientechnologies.orient.core.serialization.serializer.record.binary.ORecordSerializerBinaryV0.deserialize(ORecordSerializerBinaryV0.java:179)
     at com.orientechnologies.orient.core.serialization.serializer.record.binary.ORecordSerializerBinary.fromStream(ORecordSerializerBinary.java:74)
     at com.orientechnologies.orient.core.record.impl.ODocument.deserializeFields(ODocument.java:1817)
     at com.orientechnologies.orient.core.record.impl.ODocument.checkForFields(ODocument.java:2413)
     at com.orientechnologies.orient.core.record.impl.ODocument.fieldNames(ODocument.java:736)
     at com.orientechnologies.orient.core.fetch.OFetchHelper.processRecord(OFetchHelper.java:291)
     at com.orientechnologies.orient.core.fetch.OFetchHelper.fetch(OFetchHelper.java:82)
     at com.orientechnologies.orient.core.serialization.serializer.record.string.ORecordSerializerJSON.toString(ORecordSerializerJSON.java:336)
     at com.orientechnologies.orient.core.serialization.serializer.record.string.ORecordSerializerStringAbstract.toString(ORecordSerializerStringAbstract.java:666)
     at com.orientechnologies.orient.core.record.ORecordAbstract.toJSON(ORecordAbstract.java:192)

[Thom]

Forgot to say im using orientdb 2.1.9

[Thom]

After running for a while the code highlighted in red fails with the exception shown above.

graph.command(new OSQLAsynchQuery<Vertex>("select * from Data_Groups where i18n=? and path=?",
                            new OCommandResultListener() {
                               
                                int resultCount = 0;
                               
                                @Override
                                public boolean result(Object iRecord) {
                                   
                                    resultCount++;
                                   
                                    String json = graph.getVertex(iRecord).getRecord().toJSON("rid");                                   
                                    resultData.setJSON(json);
                                   
                                    return resultCount < 1;
                                }
           
                                @Override
                                public void end() {
                                                   
                                }
                        })).execute(i18n, url);

Den torsdag den 18. februar 2016 kl. 17.28.59 UTC+1 skrev Thom:

[Andrey Lomakin]

Hi,

1. Is that error only for this single record ?
   
2. Could you send us database to check ?

--

---
You received this message because you are subscribed to the Google Groups "OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email to orient-databa...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Best regards,
Andrey Lomakin, R&D lead. 

OrientDB Ltd

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

[Emil]

Hi,

1. What i was seeing was error for different values of the query parameters (different records), After a restart the query would work but then after a while it would fail for the same parameters used when the query was working.

2. I dont own the data so Im not sure if im allowed to, but I will find out

I was actually using 2.1.9 as the client library and 2.1.6 for the server so maybe this is the cause of all this. Now im on 2.1.10 for both server and client. I haven't seen the error since upgrading, but previously it took a few days for the error to surface.

Thanks

--

---
You received this message because you are subscribed to a topic in the Google Groups "OrientDB" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/orient-database/aC8Cd7wmHCw/unsubscribe.
To unsubscribe from this group and all its topics, send an email to orient-databa...@googlegroups.com.

[Andrey Lomakin]

Hi,

Thank you for update, please keep us posted about any good or bad news which you will get.

[Andrey Lomakin]

I think the best place to discuss such problems is bugtracker.

So if you will encounter issue again could you create new issue in bug tracker ?

[Emil]

Hi Andrey,

I will add a new issue in the bug tracker if I encounter this behavior again.

Thanks for looking into this

Thom.