question Re: SmartSense HST Agents dying in Archives of Support Questions (Read Only)

SmartSense HST Agents dying

mkataria — Thu, 19 Nov 2015 12:44:03 GMT

Hi,

In one of our clients cluster the HST agents are dying repeatedly and throwing below error in the logs.

Internal Exception: java.sql.BatchUpdateException: A truncation error was encountered trying to shrink VARCHAR '====================[ WARNING! WARNING! WARNING! WARNING! ]=&' to length 255. Error Code: 20000

Any help is appreciated.

Thanks

Re: SmartSense HST Agents dying

jstraub — Thu, 19 Nov 2015 14:04:26 GMT

I suspect this is a bug, I have seen a similar issue like yours in our internal Jira =>

javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.4.2.v): org.eclipse.persistence.exceptions.DatabaseException 
Internal Exception: java.sql.BatchUpdateException: A truncation error was encountered trying to shrink VARCHAR '/bin/sh -c python /usr/hdp/share/hst/parallel-sh.py -n 'hst &' to length 255. 
Error Code: 20000

I'd suggest you open a ticket with our support and you might want to mention the Jira ST-602, which is somewhat similar.

@Paul Codding

Re: SmartSense HST Agents dying

nsabharwal — Thu, 19 Nov 2015 19:00:42 GMT

@Paul Codding

Re: SmartSense HST Agents dying

mkataria — Fri, 20 Nov 2015 00:15:57 GMT

Thanks Jonas

Re: SmartSense HST Agents dying

czounaidou — Fri, 20 Nov 2015 00:41:10 GMT

Can you please add the HST version?

Re: SmartSense HST Agents dying

pcodding — Fri, 20 Nov 2015 01:37:12 GMT

Which version of HST are they using?

Re: SmartSense HST Agents dying

nsabharwal — Fri, 20 Nov 2015 01:49:17 GMT

@mkataria

Re: SmartSense HST Agents dying

mkataria — Fri, 20 Nov 2015 02:00:32 GMT

Smartsense 1.1.0

Re: SmartSense HST Agents dying

mkataria — Fri, 20 Nov 2015 02:07:52 GMT

@Paul Codding

Re: SmartSense HST Agents dying

czounaidou — Fri, 20 Nov 2015 02:20:10 GMT

It is already fixed in 1.1.0, not sure why it is still showing up? Will take a look.

Re: SmartSense HST Agents dying

pcodding — Fri, 20 Nov 2015 02:26:34 GMT

@mkataria We'll need a support case created and logs for the HST Server and Agent uploaded to get to the bottom of it.

Re: SmartSense HST Agents dying

mkataria — Fri, 20 Nov 2015 02:28:05 GMT

my bad, we have two clusters the one with problem is 1.1.0-119

Re: SmartSense HST Agents dying

pcodding — Fri, 20 Nov 2015 02:36:30 GMT

And which version is on the other?

Re: SmartSense HST Agents dying

mkataria — Fri, 20 Nov 2015 02:37:51 GMT

the one which is working is 1.1.0 and installed a month ago (dev), the test is only a week old and has 1.1.0-119

Re: SmartSense HST Agents dying

mkataria — Fri, 20 Nov 2015 02:42:10 GMT

does HST uses some database to write, my assumption was there is none for HST tool but the error hints its writing on derby/sql.. true?

Re: SmartSense HST Agents dying

mkataria — Fri, 20 Nov 2015 03:42:43 GMT

for now a case has been opened to support.

Re: SmartSense HST Agents dying

czounaidou — Wed, 25 Nov 2015 03:14:09 GMT

This is a similar issue but not related to ST-602. The exception in ST-602 happens during capture, but this happens during registration.