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 "
"; 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
