Ok, so we are testing the features of the db that is way we are truncating all the collections to create them again (less data to practice and no to loose anything) And this (screenshot attached) happened when truncating the same huge collection...
So our question is the same, how do we get rid of that? How do we solve it? We cannot edit the data or create smaller csv files because they are not under our control, each one of them is a composition from different sources (oracle, postgres, sql server, mysql)... so we need a solution for this issue, this also happens when trying to create the indexes and when doing large queries or very specific ones over the data... what would happen when querying multiple collections at the same time? I will create a js script to test all as last option... after that we will have to take a serious decision about it On Sunday, March 12, 2017 at 8:06:15 PM UTC-5, Mauricio Chica Patiño wrote: > > So, I have a huge amount of data divided in states and counties, each > county has the same data structure and I am trying to import it into arango > g > Using arangimp works nice, slow because of the amount of information but > it works... but when checking the information, it is incomplete... so I > tested arangoimp with log files and when it faces huge csv files (more > than 1 GB) I found that the file is not processed completelly, the > importation is broken when it has been processed between 45 and 65% of its > content... > > The error is always the same... "[5066] ERROR error message: lock > timeout" > > I have increased the --server.connection-timeout 15000 > --server.request-timeout 15000 options as shown... I know that values ara > exagerated so no problem... but no difference... same error... > > So, what is the solution?? How to avoid this error?? > > > -- You received this message because you are subscribed to the Google Groups "ArangoDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
