We have been using BaseX for about 10 years. We were stuck at 7.9 because the performance of 8 was too restrictive. We tried 9.4 as a last ditch effort to correct some issues and the performance was just as good as 7.9. You made mention that many tcp/ip issues were resolved. We are using BaseX in a multithreaded client server configuration. I have architected a singleton as the server, allowing synchronized clients access to it. Everything is fine until we are under heavy load. We get the following error.

 

IO exception Software caused connection abort: socket write error in mapperProcess query: declare option output:item-separator "
"; distinct-values(for $h in //Concept[@NameSpace='Pilotfish.MergeLevel'] for $d in //Concept[@NameSpace=$h/AssociatedConcept/@NameSpace and .=$h/AssociatedConcept/@Concept] where $h/@Value='ByProductCodeDaily' return  $d/@Value)  retries: 9

 

We try 8 times, with a 100 msec wait between each attempt, and then generate an exception on the 9th. We have added tcp/ip registry fixes (MaxUserPort, TcpTimedWaitDelay)  to the Windows server as a recommended fix for these types of errors. Do you have any other suggestions?

 

Thanks for a great product!

 

Carl R Bondeson

IT Analyst 3

Department of Public Health

Operation & Support Services

Information Technology

Phone: 860-509-7434

Carl.Bondeson@ct.gov