My Server dies if I do silly things

[thomas_duemesnil]

I know why this happens but in my opinion I think even a silly action should not kill the server instance.

BEGIN
    DECLARE NewArray INTEGER ARRAY(5);
    message NewArray type info to client;
END;

I was playing with a JASON array and thought the message command could do something like NewArray.toSting(). A Message "Array" would also be fine. But the server process should not die !

I use 16.0.0.2003 as the server engine.

Only to let you know.

[Former Member · Accepted solution]

We would agree. No client action should not be able to crash the server. That's why we fixed this in later SPs/EBFs than the one you are using.

SQLA Bug Fix ( CR#771618 ) "Server crash when using ARRAY or ROW type values in MESSAGE statement"

Fixed in 16.0.0 builds >= 2020

[VolkerBarth · Accepted solution]

No client action should not be able to crash the server.

Nitpicking: This sounds like "We're not happy until you're not happy.":)

[Former Member · Accepted solution]

Correct! Extra (double negative) 'not's noted to be in error ...

[MarkCulp]

I've tried this will the latest version of 16 and I get the error:

Cannot convert varray to a long varchar

and the server keeps running. I'm not sure which bug fix resolved this issue.. See Nick's answer for the fix. You can find the full list of fixes here .

I'd suggest that you upgrade to a newer version.

HTH

[former_SQLA_member1694878]

Hi Thomas,

Thanks for the report.

This is a bug and should be resolved in a later version of SQL Anywhere.

Versions 16.0.0.2020 and later along with all releases of 17 have this issue fixed.

Thanks, Mikel