Tool for porting data from MongoDB to OrientDB

[Ameer Tamboli]

Hi all,

Is there any tool which can port the data from MongoDB to OrientDB? Preferably it should be non-gremlin way of porting the data.

Regards,
Ameer

[Luca Garulli]

Hi Ameer, 

how can you export data from MongoDB?

Lvc@

--
 
---
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/groups/opt_out.

[Shishya]

I am also looking to import from MongoDB and no probs with Gremlin either.

I have 5 mills/15 GB records in Mongo which I want to import.

Any suggests to to make it fatser.

Python connector to read records and push in orientdb is painfully slow.

Regards

[Luca Garulli]

So in what format do you export the database from MongoDB?

Lvc@

[prabhat]

Data is in json format per line for each row.

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/ZjilrGdQd5k/unsubscribe.
To unsubscribe from this group and all its topics, send an email to orient-databa...@googlegroups.com.

[Luca Garulli]

Do you have any link to the used format? Maybe we could create a standard importer from MongoDB?

Lvc@

[prabhat]

Best would be create an uploader feature from JSON. This was this can be used in any other place as well.

Format is attached below. This has 3 rows.

{ "_id" : { "$oid" : "52f22845cb210633f07388de" }, "abstract" : "A vehicle controller self-diagnosis apparatus having areas such as memory information, tables, and the like relating to abnormality-detection processing that can be easily modified when abnormal-detection targets are increased or decreased, thereby reducing the amount of time required to implement such changes. An abnormality-diagnosis program of the present invention includes an abnormality-detection object, an abnormality-verification object, and an abnormality-processing object. The abnormality-detection object is provided with a program of object-oriented design to determine normality or abnormality based on information from several sensors. The abnormality-verification object is provided with a program of object-oriented design to process a flag set by the abnormality-detection object. The abnormality-processing object is provided with a program of object-oriented design to comprehensively determine an abnormality-detection result for a plurality of abnormality-detection targets, and to ultimately decide whether an abnormality-indicating lamp should be illuminated.", "applicants" : [], "assignees" : [ { "city" : "Aichi-Pref.", "name" : "Denso Corporation", "country" : "JP" } ], "citations" : [ { "kind" : "A", "country" : "not found", "inventor_name" : "Kato et al.", "patent_id" : "4497057", "date" : "19850100", "class" : "371 29" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Smith et al.", "patent_id" : "5671141", "date" : "19970900", "class" : "701 29" }, { "kind" : "not found", "country" : "WO", "inventor_name" : "not found", "patent_id" : "WO 97/13064", "date" : "19970400", "class" : "not found" } ], "country" : "US", "date" : "20030902", "day" : "02", "further_international_class" : [], "further_national_class" : [ "731172", "714 46", "340439" ], "international_class" : "G06F 1100", "inventors" : [ { "city" : "Kariya", "first_name" : "Kokichi", "last_name" : "Shimizu", "name" : "Kokichi Shimizu", "country" : "JP", "pincode" : "not found", "state" : "not found" } ], "ipc_version" : "7", "iso_date" : { "$date" : 1062460800000 }, "kind" : "B1", "month" : "09", "national_class" : "701 29", "patent_id" : "06615119", "status" : "not found", "time_stamp" : 1062460800, "title" : "Object-oriented diagnostic apparatus for vehicle controller", "year" : "2003" }

{ "_id" : { "$oid" : "52f22845cb210633f07388e0" }, "abstract" : " A 5-chloro-6-phenyl-2-(4-trifluoromethylphenyl)-4-pyrimidinyl-aminoacetamide derivative of the formula (I): wherein R is a methyl group or a cyclopropyl group, and a pharmaceutical composition containing the same. Said compounds exhibit a potent anti-rheumatoid activity and show low toxicity, and hence, they are useful as an agent for prophylaxis or treatment of immuno inflammatory diseases such as rheumatoid diseases (e.g., rheumatoid arthritis, Behcet disease, ankylosing spondylitis, etc.) and autoimmune diseases (e.g., multiple sclerosis, systemic lupus erythematosus, Sjgren syndrome, etc.).", "applicants" : [], "assignees" : [ { "city" : "Osaka-Fu", "name" : "Dainippon Pharmaceutical Co., Ltd.", "country" : "JP" } ], "citations" : [ { "kind" : "A", "country" : "not found", "inventor_name" : "Murata et al.", "patent_id" : "5972946", "date" : "19991000", "class" : "514256" }, { "kind" : "not found", "country" : "EP", "inventor_name" : "not found", "patent_id" : "826673", "date" : "19980300", "class" : "not found" }, { "kind" : "not found", "country" : "JP", "inventor_name" : "not found", "patent_id" : "10-130150", "date" : "19980500", "class" : "not found" }, { "kind" : "not found", "country" : "WO", "inventor_name" : "not found", "patent_id" : "98/09960", "date" : "19980300", "class" : "not found" } ], "country" : "US", "date" : "20030916", "day" : "16", "further_international_class" : [ "A61K 31505" ], "further_national_class" : [ "544329" ], "international_class" : "C07D23942", "inventors" : [ { "city" : "Izumiotsu", "first_name" : "Teruya", "last_name" : "Murata", "name" : "Teruya Murata", "country" : "JP", "pincode" : "not found", "state" : "not found" }, { "city" : "Ikoma", "first_name" : "Kazunori", "last_name" : "Ohno", "name" : "Kazunori Ohno", "country" : "JP", "pincode" : "not found", "state" : "not found" }, { "city" : "Sakai", "first_name" : "Masayasu", "last_name" : "Tanaka", "name" : "Masayasu Tanaka", "country" : "JP", "pincode" : "not found", "state" : "not found" }, { "city" : "Suita", "first_name" : "Mari", "last_name" : "Itoh", "name" : "Mari Itoh", "country" : "JP", "pincode" : "not found", "state" : "not found" } ], "ipc_version" : "7", "iso_date" : { "$date" : 1063670400000 }, "kind" : "B1", "month" : "09", "national_class" : "514256", "patent_id" : "06620817", "status" : "not found", "time_stamp" : 1063670400, "title" : { "lsqb" : "", "rsqb" : "" }, "year" : "2003" }

{ "_id" : { "$oid" : "52f22845cb210633f07388e2" }, "abstract" : "not found", "applicants" : [], "assignees" : [ { "city" : "Rockford", "name" : "Wolverine World Wide, Inc.", "country" : "not found" } ], "citations" : [ { "kind" : "S", "country" : "not found", "inventor_name" : "Mewdows", "patent_id" : "D227519", "date" : "19730700", "class" : "D 2907" }, { "kind" : "S", "country" : "not found", "inventor_name" : "Askew", "patent_id" : "D229251", "date" : "19731100", "class" : "D 2907" }, { "kind" : "S", "country" : "not found", "inventor_name" : "Adams", "patent_id" : "D456597", "date" : "20020500", "class" : "D 2969" }, { "kind" : "S", "country" : "not found", "inventor_name" : "Adams et al.", "patent_id" : "D457297", "date" : "20020500", "class" : "D 2969" }, { "kind" : "S", "country" : "not found", "inventor_name" : "Adams", "patent_id" : "D461950", "date" : "20020800", "class" : "D 2969" }, { "kind" : "S", "country" : "not found", "inventor_name" : "Adams", "patent_id" : "D477455", "date" : "20030700", "class" : "D 2969" }, { "kind" : "S", "country" : "not found", "inventor_name" : "Robbins", "patent_id" : "D480543", "date" : "20031000", "class" : "D 2969" } ], "country" : "US", "date" : "20040309", "day" : "09", "further_international_class" : [], "further_national_class" : [], "international_class" : "0299", "inventors" : [ { "city" : "Glastonburg", "first_name" : "Kenneth J.", "last_name" : "Robbins", "name" : "Kenneth J. Robbins", "country" : "GB", "pincode" : "not found", "state" : "not found" } ], "ipc_version" : "7", "iso_date" : { "$date" : 1078790400000 }, "kind" : "S1", "month" : "03", "national_class" : "D 2969", "patent_id" : "D0487335", "status" : "not found", "time_stamp" : 1078790400, "title" : "Footwear upper", "year" : "2004" }

{ "_id" : { "$oid" : "52f22845cb210633f07388e4" }, "abstract" : "A method of using a finishing element and using organic lubricating films for finishing semiconductor wafers is described. The lubricants in the finishing element can be transferred to operative finishing interface forming lubricating film. The organic lubricating film thickness can be controlled to improve finishing and reduce unwanted surface defects. Differential organic lubricating film methods are described to differentially finish semiconductor wafers. Planarization and localized finishing can be improved using differential lubricating boundary layer and organic lubricating film methods of finishing.", "applicants" : [], "assignees" : [ { "city" : "Wilmington", "name" : "Beaver Creek Concepts Inc.", "country" : "not found" } ], "citations" : [ { "kind" : "A", "country" : "not found", "inventor_name" : "Sandhu", "patent_id" : "5069002", "date" : "19911200", "class" : "51165 R" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Jensen", "patent_id" : "5107445", "date" : "19920400", "class" : "36525" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Medillin", "patent_id" : "5137544", "date" : "19920800", "class" : "51308" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Schietinger", "patent_id" : "5154512", "date" : "19921000", "class" : "374  9" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Schietinger", "patent_id" : "5166080", "date" : "19921100", "class" : "437  7" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Sandhu", "patent_id" : "5196353", "date" : "19930300", "class" : "437  7" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Tuttle et al.", "patent_id" : "5232875", "date" : "19930800", "class" : "451 63 X" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Cote", "patent_id" : "5308438", "date" : "19940500", "class" : "156636" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Yu", "patent_id" : "5314843", "date" : "19940500", "class" : "437225" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Cadien", "patent_id" : "5340370", "date" : "19940800", "class" : "51 38" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Sasaki", "patent_id" : "5352277", "date" : "19941000", "class" : "106  6" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Koos", "patent_id" : "5413941", "date" : "19950500", "class" : "437  8" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Jackson et al.", "patent_id" : "5456627", "date" : "19951000", "class" : "451 63 X" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Yau", "patent_id" : "5595526", "date" : "19970100", "class" : "451  8" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Chen", "patent_id" : "5597442", "date" : "19970100", "class" : "1566261" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Moriyama", "patent_id" : "5609511", "date" : "19970300", "class" : "451  5" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Lofaro", "patent_id" : "5609517", "date" : "19970300", "class" : "451529" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Farkas", "patent_id" : "5614444", "date" : "19970300", "class" : "437225" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Kishi et al.", "patent_id" : "5624300", "date" : "19970400", "class" : "451 63 X" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Kimura", "patent_id" : "5639388", "date" : "19970600", "class" : "216 84" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Sandhu", "patent_id" : "5643060", "date" : "19970700", "class" : "451285" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Chen", "patent_id" : "5647952", "date" : "19970700", "class" : "1566361" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Pan", "patent_id" : "5667629", "date" : "19970900", "class" : "438 13" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Kimura et al.", "patent_id" : "5679063", "date" : "19971000", "class" : "451 60 X" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Mattingly", "patent_id" : "5685766", "date" : "19971100", "class" : "451 36" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Beratan", "patent_id" : "5695384", "date" : "19971200", "class" : "451 28" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Litvak", "patent_id" : "5695660", "date" : "19971200", "class" : "216 85" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Cronin", "patent_id" : "5722879", "date" : "19980300", "class" : "451281" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Muroyama", "patent_id" : "5728308", "date" : "19980300", "class" : "216 88" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Robinson", "patent_id" : "5733176", "date" : "19980300", "class" : "451 41" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Kodama", "patent_id" : "5733819", "date" : "19980300", "class" : "438692" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Barr", "patent_id" : "5735036", "date" : "19980400", "class" : "2960312" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Doan", "patent_id" : "5738562", "date" : "19980400", "class" : "451  5" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Birang", "patent_id" : "5743784", "date" : "19980400", "class" : "451 21" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Church", "patent_id" : "5749769", "date" : "19980500", "class" : "451  5" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Grover et al.", "patent_id" : "5759917", "date" : "19980600", "class" : "438690" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Sandhu", "patent_id" : "5762537", "date" : "19980600", "class" : "451  7" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Kaufman", "patent_id" : "5783489", "date" : "19980700", "class" : "438692" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Sato", "patent_id" : "5830280", "date" : "19981100", "class" : "134  2" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Moore", "patent_id" : "5833519", "date" : "19981100", "class" : "451 56" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Sandhu", "patent_id" : "5842909", "date" : "19981200", "class" : "451  7" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Scherber", "patent_id" : "5858813", "date" : "19990100", "class" : "438693" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Sakurai et al.", "patent_id" : "5860847", "date" : "19990100", "class" : "451 10" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Miller", "patent_id" : "5876266", "date" : "19990300", "class" : "451 56" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Ronay", "patent_id" : "5876490", "date" : "19990300", "class" : "106  3" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Ploessl", "patent_id" : "5885137", "date" : "19990300", "class" : "106  3" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Suzuki", "patent_id" : "5885334", "date" : "19990300", "class" : "438639" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Appel", "patent_id" : "5906754", "date" : "19990500", "class" : "216 88" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Duescher", "patent_id" : "5910041", "date" : "19990600", "class" : "451 28" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Avanzino", "patent_id" : "5916855", "date" : "19990600", "class" : "51307" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Walker", "patent_id" : "5919082", "date" : "19990700", "class" : "451 41" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Burke", "patent_id" : "5934978", "date" : "19990800", "class" : "451 36" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Wright", "patent_id" : "5945347", "date" : "19990800", "class" : "438692" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Cadien", "patent_id" : "5954975", "date" : "19990900", "class" : "216 38" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Kaufman", "patent_id" : "5954997", "date" : "19990900", "class" : "252 791" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Bruxuoort", "patent_id" : "5958794", "date" : "19990900", "class" : "438692" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Ronay", "patent_id" : "5968280", "date" : "19991000", "class" : "134  2" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Tseng", "patent_id" : "5972793", "date" : "19991000", "class" : "438692" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Kobayashi", "patent_id" : "5985045", "date" : "19991100", "class" : "148240" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Duescher", "patent_id" : "5993298", "date" : "19991100", "class" : "451 56" }, { "kind" : "B1", "country" : "not found", "inventor_name" : "Molnar", "patent_id" : "6238829", "date" : "19991100", "class" : "451  8" }, { "kind" : "B1", "country" : "not found", "inventor_name" : "Molnar", "patent_id" : "6267644", "date" : "19991100", "class" : "451 41" }, { "kind" : "B1", "country" : "not found", "inventor_name" : "Molnar", "patent_id" : "6293851", "date" : "19991100", "class" : "451 41" }, { "kind" : "B1", "country" : "not found", "inventor_name" : "Molnar", "patent_id" : "6291349", "date" : "20000300", "class" : "438690" }, { "kind" : "A", "country" : "not found", "inventor_name" : "Messner et al.", "patent_id" : "6121143", "date" : "20000900", "class" : "438692" }, { "kind" : "not found", "country" : "WO", "inventor_name" : "not found", "patent_id" : "WO 98/08919", "date" : "19980300", "class" : "not found" }, { "kind" : "not found", "country" : "WO", "inventor_name" : "not found", "patent_id" : "WO 99/64527", "date" : "19991200", "class" : "not found" }, { "kind" : "not found", "country" : "WO", "inventor_name" : "not found", "patent_id" : "WO 00/00561", "date" : "20000100", "class" : "not found" }, { "kind" : "not found", "country" : "WO", "inventor_name" : "not found", "patent_id" : "WO 00/00567", "date" : "20000100", "class" : "not found" } ], "country" : "US", "date" : "20020806", "day" : "06", "further_international_class" : [], "further_national_class" : [ "451 41", "451 60" ], "international_class" : "B24B 2902", "inventors" : [ { "city" : "Wilmington", "first_name" : "Charles J", "last_name" : "Molnar", "name" : "Charles J Molnar", "country" : "not found", "pincode" : "not found", "state" : "DE" } ], "ipc_version" : "7", "iso_date" : { "$date" : 1028592000000 }, "kind" : "B1", "month" : "08", "national_class" : "451  8", "patent_id" : "06428388", "status" : "not found", "time_stamp" : 1028592000, "title" : "Finishing element with finishing aids", "year" : "2002" }

Prabhat Kumar Singh

[Luca Garulli]

Hi, this is very close to OrientDB import/export format that is JSON. You could adapt it to be in OrientDB format. Try to export a database and open the file (it's GZIPPED): you'll find a JSON.

Lvc@

[Ameer Tamboli]

Hi Luca,

Do we need to handle the fields "_id", "$oid" and "$date" differently?

Regards,
Ameer

[Luca Garulli]

OrientDB has @rid but it's in own format: <cluster>:<position>. And it's assigned by the database, so that property could be called just _id.

Lvc@

[prabhat]

Will the Orientdb import utility handle 15GB file?

Prabhat Kumar Singh

[prabhat]

Luca,

A Orientdb exported json is of this format. How do we customise mongodb format to this. any pointers please.

{"info":{"name":"testdb","default-cluster-id":3,"exporter-version":7,"engine-version":"1.6.4","engine-build":"0","storage-config-version":6,"schema-version":4,"mvrbtree-version":3,"schemaRecordId":"#0:1","indexMgrRecordId":"#0:2"},"clusters":[{"name":"internal","id":0,"type":"PHYSICAL"},{"name":"index","id":1,"type":"PHYSICAL"},{"name":"manindex","id":2,"type":"PHYSICAL"},{"name":"default","id":3,"type":"PHYSICAL"},{"name":"orole","id":4,"type":"PHYSICAL"},{"name":"ouser","id":5,"type":"PHYSICAL"},{"name":"orids","id":6,"type":"PHYSICAL"},{"name":"ofunction","id":7,"type":"PHYSICAL"},{"name":"oschedule","id":8,"type":"PHYSICAL"},{"name":"v","id":9,"type":"PHYSICAL"},{"name":"e","id":10,"type":"PHYSICAL"},{"name":"datab","id":11,"type":"PHYSICAL"}],"schema":{"version":54,"classes":[{"name":"E","default-cluster-id":10,"cluster-ids":[10],"short-name":"E"},{"name":"OFunction","default-cluster-id":7,"cluster-ids":[7],"properties":[{"name":"code","type":"STRING"},{"name":"idempotent","type":"BOOLEAN"},{"name":"language","type":"STRING"},{"name":"name","type":"STRING"},{"name":"parameters","type":"EMBEDDEDLIST","linked-type":"STRING"}]},{"name":"OIdentity","default-cluster-id":-1,"cluster-ids":[-1],"abstract":true},{"name":"ORIDs","default-cluster-id":6,"cluster-ids":[6]},{"name":"ORestricted","default-cluster-id":-1,"cluster-ids":[-1],"abstract":true,"properties":[{"name":"_allow","type":"LINKSET","linked-class":"OIdentity"},{"name":"_allowDelete","type":"LINKSET","linked-class":"OIdentity"},{"name":"_allowRead","type":"LINKSET","linked-class":"OIdentity"},{"name":"_allowUpdate","type":"LINKSET","linked-class":"OIdentity"}]},{"name":"ORole","default-cluster-id":4,"cluster-ids":[4],"super-class":"OIdentity","properties":[{"name":"inheritedRole","type":"LINK","linked-class":"ORole"},{"name":"mode","type":"BYTE"},{"name":"name","type":"STRING","mandatory":true,"not-null":true},{"name":"rules","type":"EMBEDDEDMAP","linked-type":"BYTE"}]},{"name":"OSchedule","default-cluster-id":8,"cluster-ids":[8],"properties":[{"name":"arguments","type":"EMBEDDEDMAP"},{"name":"function","type":"LINK","mandatory":true,"not-null":true,"linked-class":"OFunction"},{"name":"name","type":"STRING","mandatory":true,"not-null":true},{"name":"rule","type":"STRING","mandatory":true,"not-null":true},{"name":"start","type":"BOOLEAN"},{"name":"starttime","type":"DATETIME"},{"name":"status","type":"STRING"}]},{"name":"OTriggered","default-cluster-id":-1,"cluster-ids":[-1],"abstract":true},{"name":"OUser","default-cluster-id":5,"cluster-ids":[5],"super-class":"OIdentity","properties":[{"name":"name","type":"STRING","mandatory":true,"not-null":true},{"name":"password","type":"STRING","mandatory":true,"not-null":true},{"name":"roles","type":"LINKSET","linked-class":"ORole"},{"name":"status","type":"STRING","mandatory":true,"not-null":true}]},{"name":"V","default-cluster-id":9,"cluster-ids":[9],"oversize":2.0},{"name":"datab","default-cluster-id":11,"cluster-ids":[11],"super-class":"V"}]},"records":[{"@type":"b","@rid":"#0:0","@version":0,"value":"NnwgfCMwOjF8IHwjMDoyfGVufElOfHl5eXktTU0tZGR8eXl5eS1NTS1kZCBISDptbTpzc3xBc2lhL0tvbGthdGF8VVRGLTh8IHwwfG1tYXB8NTAwS2J8NTAwTWJ8NTAlfGF1dG98MHwxMnwwfGludGVybmFsfC0xfGR8dHJ1ZXwxLjJ8MS4yfHNuYXBweXwxfGluZGV4fC0xfGR8dHJ1ZXwxLjJ8MS4yfHNuYXBweXwyfG1hbmluZGV4fC0xfGR8dHJ1ZXwxLjJ8MS4yfHNuYXBweXwzfGRlZmF1bHR8LTF8ZHx0cnVlfDEuMnwxLjJ8c25hcHB5fDR8b3JvbGV8LTF8ZHx0cnVlfDEuMnwxLjJ8c25hcHB5fDV8b3VzZXJ8LTF8ZHx0cnVlfDEuMnwxLjJ8c25hcHB5fDZ8b3JpZHN8LTF8ZHxmYWxzZXwyLjB8NS4wfHNuYXBweXw3fG9mdW5jdGlvbnwtMXxkfHRydWV8MS4yfDEuMnxzbmFwcHl8OHxvc2NoZWR1bGV8LTF8ZHx0cnVlfDEuMnwxLjJ8c25hcHB5fDl8dnwtMXxkfHRydWV8MS4yfDEuMnxzbmFwcHl8MTB8ZXwtMXxkfHRydWV8MS4yfDEuMnxzbmFwcHl8MTF8ZGF0YWJ8LTF8ZHx0cnVlfDEuMnwxLjJ8c25hcHB5fDB8IHxtbWFwfDUxMm1ifGZhbHNlfHRydWV8MHw="},{"@type":"d","@rid":"#0:1","@version":54,"schemaVersion":4,"classes":[{"@type":"d","@version":0,"name":"OUser","shortName":null,"defaultClusterId":5,"strictMode":false,"abstract":false,"overSize":0.0,"clusterIds":[5],"properties":[{"@type":"d","@version":0,"name":"status","type":7,"mandatory":true,"readonly":false,"notNull":true,"collate":"default","min":null,"max":null,"regexp":null,"customFields":null},{"@type":"d","@version":0,"name":"password","type":7,"mandatory":true,"readonly":false,"notNull":true,"collate":"default","min":null,"max":null,"regexp":null,"customFields":null},{"@type":"d","@version":0,"name":"name","type":7,"mandatory":true,"readonly":false,"notNull":true,"collate":"ci","min":null,"max":null,"regexp":null,"customFields":null},{"@type":"d","@version":0,"name":"roles","type":15,"mandatory":false,"readonly":false,"notNull":false,"collate":"default","min":null,"max":null,"regexp":null,"linkedClass":"ORole","customFields":null}],"customFields":null,"superClass":"OIdentity","@fieldTypes":"overSize=f,properties=e"},{"@type":"d","@version":0,"name":"OIdentity","shortName":null,"defaultClusterId":-1,"strictMode":false,"abstract":true,"overSize":0.0,"clusterIds":[-1],"properties":[],"customFields":null,"superClass":null,"@fieldTypes":"overSize=f,properties=e"},{"@type":"d","@version":0,"name":"ORIDs","shortName":null,"defaultClusterId":6,"strictMode":false,"abstract":false,"overSize":0.0,"clusterIds":[6],"properties":[],"customFields":null,"superClass":null,"@fieldTypes":"overSize=f,properties=e"},{"@type":"d","@version":0,"name":"ORestricted","shortName":null,"defaultClusterId":-1,"strictMode":false,"abstract":true,"overSize":0.0,"clusterIds":[-1],"properties":[{"@type":"d","@version":0,"name":"_allow","type":15,"mandatory":false,"readonly":false,"notNull":false,"collate":"default","min":null,"max":null,"regexp":null,"linkedClass":"OIdentity","customFields":null},{"@type":"d","@version":0,"name":"_allowUpdate","type":15,"mandatory":false,"readonly":false,"notNull":false,"collate":"default","min":null,"max":null,"regexp":null,"linkedClass":"OIdentity","customFields":null},{"@type":"d","@version":0,"name":"_allowRead","type":15,"mandatory":false,"readonly":false,"notNull":false,"collate":"default","min":null,"max":null,"regexp":null,"linkedClass":"OIdentity","customFields":null},{"@type":"d","@version":0,"name":"_allowDelete","type":15,"mandatory":false,"readonly":false,"notNull":false,"collate":"default","min":null,"max":null,"regexp":null,"linkedClass":"OIdentity","customFields":null}],"customFields":null,"superClass":null,"@fieldTypes":"overSize=f,properties=e"},{"@type":"d","@version":0,"name":"OTriggered","shortName":null,"defaultClusterId":-1,"strictMode":false,"abstract":true,"overSize":0.0,"clusterIds":[-1],"properties":[],"customFields":null,"superClass":null,"@fieldTypes":"overSize=f,properties=e"},{"@type":"d","@version":0,"name":"V","shortName":null,"defaultClusterId":9,"clusterIds":[9],"overSize":2.0,"strictMode":false,"abstract":false,"properties":[],"superClass":null,"customFields":null,"@fieldTypes":"overSize=f,properties=e"},{"@type":"d","@version":0,"name":"datab","shortName":null,"defaultClusterId":11,"clusterIds":[11],"overSize":0.0,"strictMode":false,"abstract":false,"properties":[],"superClass":"V","customFields":null,"@fieldTypes":"overSize=f,properties=e"},{"@type":"d","@version":0,"name":"OSchedule","shortName":null,"defaultClusterId":8,"strictMode":false,"abstract":false,"overSize":0.0,"clusterIds":[8],"properties":[{"@type":"d","@version":0,"name":"start","type":0,"mandatory":false,"readonly":false,"notNull":false,"min":null,"max":null,"regexp":null,"customFields":null,"collate":"default"},{"@type":"d","@version":0,"name":"starttime","type":6,"mandatory":false,"readonly":false,"notNull":false,"min":null,"max":null,"regexp":null,"customFields":null,"collate":"default"},{"@type":"d","@version":0,"name":"status","type":7,"mandatory":false,"readonly":false,"notNull":false,"collate":"default","min":null,"max":null,"regexp":null,"customFields":null},{"@type":"d","@version":0,"name":"rule","type":7,"mandatory":true,"readonly":false,"notNull":true,"collate":"default","min":null,"max":null,"regexp":null,"customFields":null},{"@type":"d","@version":0,"name":"function","type":13,"mandatory":true,"readonly":false,"notNull":true,"collate":"default","min":null,"max":null,"regexp":null,"linkedClass":"OFunction","customFields":null},{"@type":"d","@version":0,"name":"name","type":7,"mandatory":true,"readonly":false,"notNull":true,"collate":"default","min":null,"max":null,"regexp":null,"customFields":null},{"@type":"d","@version":0,"name":"arguments","type":12,"mandatory":false,"readonly":false,"notNull":false,"collate":"default","min":null,"max":null,"regexp":null,"customFields":null}],"customFields":null,"superClass":null,"@fieldTypes":"overSize=f,properties=e"},{"@type":"d","@version":0,"name":"ORole","shortName":null,"defaultClusterId":4,"strictMode":false,"abstract":false,"overSize":0.0,"clusterIds":[4],"properties":[{"@type":"d","@version":0,"name":"name","type":7,"mandatory":true,"readonly":false,"notNull":true,"collate":"ci","min":null,"max":null,"regexp":null,"customFields":null},{"@type":"d","@version":0,"name":"mode","type":17,"mandatory":false,"readonly":false,"notNull":false,"collate":"default","min":null,"max":null,"regexp":null,"customFields":null},{"@type":"d","@version":0,"name":"rules","type":12,"mandatory":false,"readonly":false,"notNull":false,"collate":"default","min":null,"max":null,"regexp":null,"linkedType":17,"customFields":null},{"@type":"d","@version":0,"name":"inheritedRole","type":13,"mandatory":false,"readonly":false,"notNull":false,"collate":"default","min":null,"max":null,"regexp":null,"linkedClass":"ORole","customFields":null}],"customFields":null,"superClass":"OIdentity","@fieldTypes":"overSize=f,properties=e"},{"@type":"d","@version":0,"name":"OFunction","shortName":null,"defaultClusterId":7,"strictMode":false,"abstract":false,"overSize":0.0,"clusterIds":[7],"properties":[{"@type":"d","@version":0,"name":"parameters","type":10,"mandatory":false,"readonly":false,"notNull":false,"collate":"default","min":null,"max":null,"regexp":null,"linkedType":7,"customFields":null},{"@type":"d","@version":0,"name":"idempotent","type":0,"mandatory":false,"readonly":false,"notNull":false,"collate":"default","min":null,"max":null,"regexp":null,"customFields":null},{"@type":"d","@version":0,"name":"code","type":7,"mandatory":false,"readonly":false,"notNull":false,"collate":"default","min":null,"max":null,"regexp":null,"customFields":null},{"@type":"d","@version":0,"name":"language","type":7,"mandatory":false,"readonly":false,"notNull":false,"collate":"default","min":null,"max":null,"regexp":null,"customFields":null},{"@type":"d","@version":0,"name":"name","type":7,"mandatory":false,"readonly":false,"notNull":false,"collate":"default","min":null,"max":null,"regexp":null,"customFields":null}],"customFields":null,"superClass":null,"@fieldTypes":"overSize=f,properties=e"},{"@type":"d","@version":0,"name":"E","shortName":"E","defaultClusterId":10,"clusterIds":[10],"overSize":0.0,"strictMode":false,"abstract":false,"properties":[],"superClass":null,"customFields":null,"@fieldTypes":"overSize=f,properties=e"}],"@fieldTypes":"classes=e"},{"@type":"d","@rid":"#0:2","@version":4,"indexes":[{"@type":"d","@version":0,"type":"UNIQUE","name":"ORole.name","indexDefinition":{"@type":"d","@version":0,"className":"ORole","field":"name","keyType":"STRING","collate":"ci"},"indexDefinitionClass":"com.orientechnologies.orient.core.index.OPropertyIndexDefinition","clusters":["orole"],"mapRid":"#1:0","algorithm":"SBTREE","valueContainerAlgorithm":"NONE","@fieldTypes":"clusters=e"},{"@type":"d","@version":0,"type":"UNIQUE","name":"OUser.name","indexDefinition":{"@type":"d","@version":0,"className":"OUser","field":"name","keyType":"STRING","collate":"ci"},"indexDefinitionClass":"com.orientechnologies.orient.core.index.OPropertyIndexDefinition","clusters":["ouser"],"mapRid":"#1:1","algorithm":"SBTREE","valueContainerAlgorithm":"NONE","@fieldTypes":"clusters=e"},{"@type":"d","@version":0,"type":"DICTIONARY","name":"dictionary","indexDefinition":{"@type":"d","@version":0,"keyTypes":["STRING"],"collate":"default"},"indexDefinitionClass":"com.orientechnologies.orient.core.index.OSimpleKeyIndexDefinition","clusters":[],"mapRid":"#2:0","algorithm":"SBTREE","valueContainerAlgorithm":"NONE","@fieldTypes":"clusters=e"}],"@fieldTypes":"indexes=e"},{"@type":"b","@rid":"#1:0","@version":1,"value":""},{"@type":"b","@rid":"#1:1","@version":1,"value":""},{"@type":"b","@rid":"#2:0","@version":1,"value":""},{"@type":"d","@rid":"#4:0","@version":2,"@class":"ORole","name":"admin","inheritedRole":null,"mode":1,"rules":{"database.bypassrestricted":15},"@fieldTypes":"mode=b"},{"@type":"d","@rid":"#4:1","@version":2,"@class":"ORole","name":"reader","inheritedRole":null,"mode":0,"rules":{"database":2,"database.schema":2,"database.cluster.internal":2,"database.cluster.orole":2,"database.cluster.ouser":2,"database.class.*":2,"database.cluster.*":2,"database.command":2,"database.hook.record":2},"@fieldTypes":"mode=b"},{"@type":"d","@rid":"#4:2","@version":2,"@class":"ORole","name":"writer","inheritedRole":null,"mode":0,"rules":{"database":2,"database.schema":7,"database.cluster.internal":2,"database.cluster.orole":2,"database.cluster.ouser":2,"database.class.*":15,"database.cluster.*":15,"database.command":15,"database.hook.record":15},"@fieldTypes":"mode=b"},{"@type":"d","@rid":"#5:0","@version":1,"@class":"OUser","name":"admin","password":"{SHA-256}8C6976E5B5410415BDE908BD4DEE15DFB167A9C873FC4BB8A81F6F2AB448A918","status":"ACTIVE","roles":["#4:0"],"@fieldTypes":"roles=e"},{"@type":"d","@rid":"#5:1","@version":1,"@class":"OUser","name":"reader","password":"{SHA-256}3D0941964AA3EBDCB00CCEF58B1BB399F9F898465E9886D5AEC7F31090A0FB30","status":"ACTIVE","roles":["#4:1"],"@fieldTypes":"roles=e"},{"@type":"d","@rid":"#5:2","@version":1,"@class":"OUser","name":"writer","password":"{SHA-256}B93006774CBDD4B299389A03AC3D88C3A76B460D538795BC12718011A909FBA5","status":"ACTIVE","roles":["#4:2"],"@fieldTypes":"roles=e"},{"@type":"d","@rid":"#11:0","@version":1,"@class":"datab","id":1},{"@type":"d","@rid":"#11:1","@version":1,"@class":"datab","id":2},{"@type":"d","@rid":"#11:2","@version":1,"@class":"datab","id":"e2"}],"indexes":[{"name":"dictionary","type":"DICTIONARY","definition":{"defClass":"com.orientechnologies.orient.core.index.OSimpleKeyIndexDefinition","stream":{"@type":"d","@version":0,"keyTypes":["STRING"],"collate":"default"}}},{"name":"OUser.name","type":"UNIQUE","clustersToIndex":["ouser"],"definition":{"defClass":"com.orientechnologies.orient.core.index.OPropertyIndexDefinition","stream":{"@type":"d","@version":0,"className":"OUser","field":"name","keyType":"STRING","collate":"ci"}}},{"name":"ORole.name","type":"UNIQUE","clustersToIndex":["orole"],"definition":{"defClass":"com.orientechnologies.orient.core.index.OPropertyIndexDefinition","stream":{"@type":"d","@version":0,"className":"ORole","field":"name","keyType":"STRING","collate":"ci"}}}],"manualIndexes":[{"name":"dictionary","content":[]}]}

Prabhat Kumar Singh

[Luca Garulli]

Yes,

even if it's gzipped: the parsing happens in streaming.

Lvc@

[prabhat]

I get this error. File is attached.

Importing records...

- Importing records into cluster 'internal' (id=0):  = 2 records

- Importing records into cluster 'orole' (id=4):  = 3 records

- Importing records into cluster 'ouser' (id=5): Error importing record. Source line 0, column 16349

Error on database import happened just before line 0, column 16350

java.lang.NullPointerException

at com.orientechnologies.orient.core.db.tool.ODatabaseImport.importRecord(ODatabaseImport.java:854)

at com.orientechnologies.orient.core.db.tool.ODatabaseImport.importRecords(ODatabaseImport.java:804)

at com.orientechnologies.orient.core.db.tool.ODatabaseImport.importDatabase(ODatabaseImport.java:191)

at com.orientechnologies.orient.console.OConsoleDatabaseApp.importDatabase(OConsoleDatabaseApp.java:1429)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:601)

at com.orientechnologies.common.console.OConsoleApplication.execute(OConsoleApplication.java:279)

at com.orientechnologies.common.console.OConsoleApplication.executeCommands(OConsoleApplication.java:156)

at com.orientechnologies.common.console.OConsoleApplication.run(OConsoleApplication.java:94)

at com.orientechnologies.orient.graph.console.OGremlinConsole.main(OGremlinConsole.java:53)

Error: com.orientechnologies.orient.core.db.tool.ODatabaseExportException: Error on importing database 'testdb' from file: testdb.json

Error: java.lang.NullPointerException

Prabhat Kumar Singh

[Luca Garulli]

Hi,

that import expects a "@type" : "d" as field for documents. Now I fixed it in current "develop" branch to use documents if not specified other:

https://github.com/orientechnologies/orientdb/issues/2052

Lvc@

[Luca Garulli]

With last fix the import worked correctly:

Importing database /temp/testdb.json...

Started import of database 'plocal:/temp/mydb' from /temp/testdb.json...

Non merge mode (-merge=false): removing all default non security classes

- Class OTriggered was removed.

- Class datab was removed.

- Class E was removed.

- Class ORestricted was removed.

- Class OSchedule was removed.

- Class OFunction was removed.

- Class ORIDs was removed.

- Class V was removed.

Removed 8 classes.

Importing database info...OK

Importing clusters...

- Creating cluster 'internal'...OK, assigned id=0

- Creating cluster 'default'...OK, assigned id=3

- Creating cluster 'orole'...OK, assigned id=4

- Creating cluster 'ouser'...OK, assigned id=5

- Creating cluster 'orids'...OK, assigned id=6

- Creating cluster 'ofunction'...OK, assigned id=7

- Creating cluster 'oschedule'...OK, assigned id=8

- Creating cluster 'v'...OK, assigned id=9

- Creating cluster 'e'...OK, assigned id=10

- Creating cluster 'datab'...OK, assigned id=11

Rebuilding indexes of truncated clusters ...

Cluster content was truncated and index OUser.name will be rebuilt

Index OUser.name was successfully rebuilt.

Cluster content was truncated and index ORole.name will be rebuilt

Index ORole.name was successfully rebuilt.

Done 2 indexes were rebuilt.

Done. Imported 10 clusters

Importing database schema...OK (11 classes)

Importing records...

- Importing records into cluster 'internal' (id=0):  = 2 records

- Importing records into cluster 'orole' (id=4):  = 3 records

- Importing records into cluster 'ouser' (id=5):  = 3 records

- Importing records into cluster 'default' (id=3):  = 2 records

- Importing records into cluster 'default' (id=3): 

Started migration of links (-migrateLinks=true). Links are going to be updated according to new RIDs:

- Cluster default... Processed: 3

- Cluster orole... Processed: 3

- Cluster ouser... Processed: 3

- Cluster orids... Processed: 0

- Cluster ofunction... Processed: 0

- Cluster oschedule... Processed: 0

- Cluster v... Processed: 0

- Cluster e... Processed: 0

- Cluster datab... Processed: 0

Total links updated: 9

Done. Imported 10 records

Importing indexes ...

- Index 'dictionary'...OK

- Index 'OUser.name'...OK

- Index 'ORole.name'...OK

Done. Created 3 indexes.

Importing manual index entries...

- Index 'dictionary'...OK (0 entries)

Done. Imported 1 indexes.

Rebuild of stale indexes...

Stale indexes were rebuilt...

Deleting RID Mapping table...OK

Database import completed in 3353 ms

Lvc@

[prabhat]

Is it in 1.7-rc2.

When I try to do git pull, I get 1.7-rc1 only, where it gives same error.

Regards

[Luca Garulli]

1.7-rc1 has been closed. We're working against 1.7-rc2-SNAPSHOT in "develop" branch.

Lvc@

[prabhat]

Can I please get a working copy of SNAPSHOT .

I need it solve my mongo headache

Regards

[Luca Garulli]

Hi,

it's online on: https://oss.sonatype.org/content/repositories/snapshots/com/orientechnologies/orientdb-community/1.7-rc2-SNAPSHOT/

Lvc@

[prabhat]

Hi Luca,

The way you created a default for @type, can you please fix @rid the same way or drop it as a mandatory field, coz anyway holes are fixed and this value is mostly ignored during import.

Thanks

[Shishya]

Thanks a lot Luca. Impressive and marvelous.

 

[Luca Garulli]

Works?

Lvc@

On 19 February 2014 09:55, Shishya <prab...@gmail.com> wrote:

Thanks a lot Luca. Impressive and marvelous.

 

--

[Shishya]

Luca,

I was waiting to confirm if yes or no. It works, except a few errors.Like;

1. Indexes get dropped after restart

2. Export/Imports drops all clusters , all classes, except 4 of basic ones.

3. plocal connection gives this error

2014-02-24 20:05:04:327 WARN segment file 'database.ocf' was not closed correctly last time [OSingleFileSegment]
2014-02-24 20:05:04:525 WARN Storage uspto3 was not closed properly. Will try to restore from write ahead log. [OLocalPaginatedStorage]
2014-02-24 20:05:04:526 SEVE Restore is not possible because write ahead log is empty. [OLocalPaginatedStorage]
2014-02-24 20:05:11:648 WARN segment file '___exportImportRIDMap.him' was not closed correctly last time [OHashIndexBufferStore]
2014-02-24 20:05:11:649 WARN segment file '___exportImportRIDMap.hit' was not closed correctly last time [OHashIndexTreeStateStore]OK


Exception in thread "main" java.lang.NullPointerException
 at com.orientechnologies.orient.core.index.hashindex.local.OLocalHashTable.saveState(OLocalHashTable.java:369)
 at com.orientechnologies.orient.core.index.hashindex.local.OLocalHashTable.flush(OLocalHashTable.java:1141)
 at com.orientechnologies.orient.core.index.engine.OLocalHashTableIndexEngine.flush(OLocalHashTableIndexEngine.java:94)
 at com.orientechnologies.orient.core.index.OIndexAbstract.flush(OIndexAbstract.java:116)
 at com.orientechnologies.orient.core.index.OIndexManagerAbstract.flush(OIndexManagerAbstract.java:170)
 at com.orientechnologies.orient.core.index.OIndexManagerAbstract.close(OIndexManagerAbstract.java:279)
 at com.orientechnologies.orient.core.storage.OStorageAbstract.close(OStorageAbstract.java:117)
 at com.orientechnologies.orient.core.storage.OStorageEmbedded.close(OStorageEmbedded.java:70)
 at com.orientechnologies.orient.core.storage.impl.local.paginated.OLocalPaginatedStorage.doClose(OLocalPaginatedStorage.java:712)
 at com.orientechnologies.orient.core.storage.impl.local.paginated.OLocalPaginatedStorage.close(OLocalPaginatedStorage.java:671)
 at com.orientechnologies.orient.core.storage.OStorageAbstract.close(OStorageAbstract.java:103)
 at com.orientechnologies.orient.core.db.raw.ODatabaseRaw.close(ODatabaseRaw.java:501)
 at com.orientechnologies.orient.core.db.ODatabaseWrapperAbstract.close(ODatabaseWrapperAbstract.java:85)
 at com.orientechnologies.orient.core.db.record.ODatabaseRecordAbstract.close(ODatabaseRecordAbstract.java:322)
 at com.orientechnologies.orient.core.db.ODatabaseWrapperAbstract.close(ODatabaseWrapperAbstract.java:85)
 at com.orientechnologies.orient.core.db.ODatabaseFactory.shutdown(ODatabaseFactory.java:93)
 at com.orientechnologies.orient.core.Orient.shutdown(Orient.java:148)
 at com.orientechnologies.orient.console.OConsoleDatabaseApp.onAfter(OConsoleDatabaseApp.java:172)
 at com.orientechnologies.common.console.OConsoleApplication.run(OConsoleApplication.java:102)
 at com.orientechnologies.orient.graph.console.OGremlinConsole.main(OGremlinConsole.java:54)
 

[Shishya]

Another error now on restart of server

orientdb java.lang.IllegalArgumentException: Cluster 1 is null

[Shishya]

Hi Luca/Someone

Please help here. I am trying to run it normally. But I get this error more so often. I cant connect by remote, but by plocal only. Indexes shows indexes in console but cluster has no index. 

Please help

2014-02-27 19:31:51:669 INFO Wait till indexes restore after crash was finished. [OIndexManagerShared]Error when attempt to restore indexes after crash was performed.
Error in creation of new cluster 'index' of type: PHYSICAL
-> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
-> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
-> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
-> java.lang.reflect.Constructor.newInstance(Constructor.java:526)
-> com.orientechnologies.common.log.OLogManager.exception(OLogManager.java:162)
-> com.orientechnologies.orient.core.storage.impl.local.paginated.OLocalPaginatedStorage.addCluster(OLocalPaginatedStorage.java:905)
-> com.orientechnologies.orient.core.index.OIndexManagerShared$1.run(OIndexManagerShared.java:345)
-> java.lang.Thread.run(Thread.java:744)
Cannot add segment 'index' because it is already registered in database 'uspto8'
-> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
-> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
-> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
-> java.lang.reflect.Constructor.newInstance(Constructor.java:526)
-> com.orientechnologies.common.log.OLogManager.exception(OLogManager.java:162)
-> com.orientechnologies.orient.core.storage.impl.local.paginated.OLocalPaginatedStorage.addCluster(OLocalPaginatedStorage.java:905)
-> com.orientechnologies.orient.core.index.OIndexManagerShared$1.run(OIndexManagerShared.java:345)
-> java.lang.Thread.run(Thread.java:744)
2014-02-27 19:31:51:670 INFO Indexes restore after crash was finished. [OIndexManagerShared]
2014-02-27 19:31:51:704 SEVE Internal server error:
java.lang.IllegalArgumentException: Cluster 1 is null [ONetworkProtocolHttpDb]

[Luca Garulli]

Hi,

I think creating a simple Java class that import the database would be easier. Something like:

ODocument doc = new ODocument();

f = open mongo file

for( String line : f.readFileLineByLine() ){

  doc.reset();

  doc.setClassname("xxxx");  // SET HERE YOUR CLASS NAME

  doc.fromJSON(line);

  doc.save();

}

Lvc@

[Gunjan Patel]

On Monday, February 17, 2014 at 7:22:55 PM UTC+5:30, Lvc@ wrote:

Hi Ameer, 

how can you export data from MongoDB?

Lvc@

Use try mongodump You can easily get data in BSON file. mongorestore easily store data in Mongo