Java crash

[Maurizio Scarpis]

Hi Thomas.

I had an unexpected Java crash

Versions: SQL-WB/J 129 and Java 14.0.2 (64 bit)

I have a script that (via wbrunresult, wonderful!) runs a "long" script for every row read by the cursor

Thinking about crash due to wbrunresult I tried to create a single script (create by wbexport instead of wbrunresult) but the problema is the same

Other strange issue: if I run the scripts (both) from the front end it is all ok.

IIf i run the scripts in batch mode I have the crash

A portion of the log is reported in the attachment.

I know I was not exausitve in the explanation, please send me some hints for helping in the solution.

Regards

Maurizio 

[Maurizio Scarpis]

Hi Thomas.

I forgot an important issue: if I run the script in batch mode normally it crashes but not always; it is very strange for me. 

No other instances of Java are running when I launch my script.

Ram used: 4 g

[Thomas Kellerer]

Hmm, there is an invalid regex involved, but I am unsure where this comes from.

Could you send me the complete log file to the support email address please?
Maybe that will give me a clue which part is responsible for that.

Thomas

[Maurizio Scarpis]

Hi Thomas.

The log files seems to repeat indefinitely the same lines "n" times (I try to rerun the script but I am quite sure).

I have to correct me for the previous emails.

The crash happens if the "long" script is executed via "wbinclude" o via "wbrun".

If the script is executed as a standa-alone script it runs well.

[Thomas Kellerer]

Hi Maurizio,

the reason I asked for the log file are the things logged _before_ running the script that might be interesting (ideally in DEBUG mode).

The parameters for WbInclude might be interesting as well (e.g. if they are using -searchFor, -replaceWith together with -useRegex)

Regards
Thomas

[Maurizio Scarpis]

I am not able to retry immediately to get the full log.

There were no options for wbinclud, the only option is -file=xxxx

Regards

Maurizio

[Maurizio Scarpis]

Hi Thomas.

You will see the following attachments:

1. f01javalog.txt: Java crash log
2. f02_sqlwbj.txt: SQL-WB/J log
3. f03_mainscript.txt: the scripts that iterates the folowing script
4. f04_includedscripts.txt: the "included" scripts (costicommessa.sql)

I hope they may be useful; if you need something else I'm here to hekp solution.

Please remember thar the actual bypass is done running tow different scripts; the first one creates a unique "big" script that is run in a following separate session (that is : Java is closede after the execution of the first script and then restarted for the second one)

Regards

Maurizio

Il giorno venerdì 3 marzo 2023 alle 10:52:50 UTC+1 Maurizio Scarpis ha scritto:

[Maurizio Scarpis]

Hi Thomas.

As requested thru your email, you will find the script in the attachment.

The script runs well if executed directly by sqlwbj batch.

The script crashes if executed via wbinclude.

The Java versions are the same (14.0.2 64-bit)

Thanks

Maurizio