I wish I could. This is an enterprise implementation handling the processing of 100,000 lab results per day. For each result there are probably 1000 individual queries which handle all aspects of this processing.
I am using BaseX to drive a rules engine. Much less complex than Drools, but meets our needs. Each of these queries resides in its own class, which has its own “connection”, to the single server (singleton). This singleton was created since the size of the
“database” is prohibitive in loading them per class. This application runs under JBoss, and utilizes Hibernate as the ORM. It interfaces to 4 separate data tiers to collect data, and monitor the operations. I was wondering what in the code can constitute
a failure of this type. I have looked in stackoverflow, which only elicits the usual fact that there is a network issue. Where is this exception triggered in the BaseX paradigm? Is this just the usual stack trace from Java which normally has little value in
determining a causation?
Thanks once again!
Carl R Bondeson
IT Analyst 3
Department of Public Health
Operation & Support Services
Information Technology
Phone: 860-509-7434
From: Christian Grün <christian.gruen@gmail.com>
Sent: Tuesday, April 27, 2021 8:41 AM
To: Bondeson, Carl <Carl.Bondeson@ct.gov>
Cc: basex-talk@mailman.uni-konstanz.de
Subject: Re: [basex-talk] 7.9 to 9.4 upgrade
EXTERNAL EMAIL: This email originated from outside of the organization. Do not click any links or open any attachments unless you trust the sender and know the content is safe.
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