Hi Carl,

It’s difficult to guess what might to on in your code. Do you think you can manage to provide us with a self-contained and minimalized code snippet that allows us to reproduce the problem, or parts of it?

Best,
Christian


On Tue, Apr 27, 2021 at 1:38 PM Bondeson, Carl <Carl.Bondeson@ct.gov> wrote:

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 "&#xd;"; 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