Java Errors

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Java Errors

Rob Brooks
Hello, I'm running Lasso 8.6.0.1 on Centos 5.9/Apache 2.2.3/MySQL 5.0.95

 

I have a script that launches a rather hairy SQL call that keeps producing a
Java error in libicuuc.so ( I've attached the java error file from
LassoSites folder).  The query takes a few seconds but will run if I copy
and paste it into a mysql client such as command line client or phpmyadmin.
Watching Lasso in console mode I see the error happen and then one of the
Lasso child processes dies but Lasso recovers and respawns a child process
so things appear normal.  However, I believe over time that this causes the
server to become non-responsive requiring a restart of lasso using lasso8ctl
script.  

 

For instance, after the SQL call causes the Java error I get this:

 

[rbrooks@server9 ~]$ ps auxc | grep Lasso

root      7066  0.0  0.0   4836  1152 pts/1    S+   13:23   0:00
consoleLassoSer

lasso     7078  0.0  0.3 129988 27736 pts/1    Sl+  13:23   0:00
Lasso8Service

 

and after another call is made to the server and Lasso relaunches another
child I get this :

 

[rbrooks@server9 ~]$ ps auxc | grep Lasso

root      7066  0.0  0.0   4836  1152 pts/1    S+   13:23   0:00
consoleLassoSer

lasso     7078  0.0  0.3 129988 27772 pts/1    Sl+  13:23   0:00
Lasso8Service

lasso     7269 23.8  0.7 2496148 58732 pts/1   Sl+  13:44   0:01
Lasso8Service

 

 

I've tried upping the heap size on the JVM.  The library in question
(libicuuc.so ) belongs to ICU suite (http://site.icu-project.org/) which are
Java/C++ libs for Unicode support.

 

This SQL call is for a report on large amounts of data and could return
upwards of 50K rows to be written to a file.  

 

Has anyone seen this before?  I can't think of where else to look.

 

 

Thanks

Rob

 

 

 


#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Java Errors

Tim Taplin
hmm, the attachment doesnt come thru to the list, so I cant see the specific java error.

However, based on your description, I would think that the error is happening during some post query processing on the Lasso side. It is possible that there is some unicode encoding happening in the connector, but I would want to rule out other possibilities before going there.

Can you run just the sql query and return the raw results (records_array) in a lasso variable?

What manipulation are you doing with the data as it comes back to lasso?

If these possibilities are excluded, then the next step would be to look at your character sets for each piece of the puzzle, lasso setup, db connection, db definition, table definitions, etc. Possibly post some of this information to get more clear feedback from the community.

I'd not be much good at sorting this out at that level but there are others here who I'm sure can.

Tim Taplin

On Mar 19, 2013, at 12:52 PM, Rob Brooks <[hidden email]> wrote:

> Hello, I'm running Lasso 8.6.0.1 on Centos 5.9/Apache 2.2.3/MySQL 5.0.95
>
>
>
> I have a script that launches a rather hairy SQL call that keeps producing a
> Java error in libicuuc.so ( I've attached the java error file from
> LassoSites folder).  The query takes a few seconds but will run if I copy
> and paste it into a mysql client such as command line client or phpmyadmin.
> Watching Lasso in console mode I see the error happen and then one of the
> Lasso child processes dies but Lasso recovers and respawns a child process
> so things appear normal.  However, I believe over time that this causes the
> server to become non-responsive requiring a restart of lasso using lasso8ctl
> script.  
>
>
>
> For instance, after the SQL call causes the Java error I get this:
>
>
>
> [rbrooks@server9 ~]$ ps auxc | grep Lasso
>
> root      7066  0.0  0.0   4836  1152 pts/1    S+   13:23   0:00
> consoleLassoSer
>
> lasso     7078  0.0  0.3 129988 27736 pts/1    Sl+  13:23   0:00
> Lasso8Service
>
>
>
> and after another call is made to the server and Lasso relaunches another
> child I get this :
>
>
>
> [rbrooks@server9 ~]$ ps auxc | grep Lasso
>
> root      7066  0.0  0.0   4836  1152 pts/1    S+   13:23   0:00
> consoleLassoSer
>
> lasso     7078  0.0  0.3 129988 27772 pts/1    Sl+  13:23   0:00
> Lasso8Service
>
> lasso     7269 23.8  0.7 2496148 58732 pts/1   Sl+  13:44   0:01
> Lasso8Service
>
>
>
>
>
> I've tried upping the heap size on the JVM.  The library in question
> (libicuuc.so ) belongs to ICU suite (http://site.icu-project.org/) which are
> Java/C++ libs for Unicode support.
>
>
>
> This SQL call is for a report on large amounts of data and could return
> upwards of 50K rows to be written to a file.  
>
>
>
> Has anyone seen this before?  I can't think of where else to look.
>
>
>
>
>
> Thanks
>
> Rob
>
>
>
>
>
>
>
> #############################################################
> This message is sent to you because you are subscribed to
>  the mailing list Lasso
> [hidden email]
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>

#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Java Errors

Kyle Jessup-2
In reply to this post by Rob Brooks
The "Java" here is just a crash log, but Java isn't the cause or involved in any way (we do not use the java icu).

The first thing I'd look for is that your BLOB fields are BLOBS and that your text field have valid text in them. Since it appears to be crashing in icu which does the unicode handling, that's my first hunch.

-Kyle


On Mar 19, 2013, at 2:52 PM, Rob Brooks <[hidden email]> wrote:

> Hello, I'm running Lasso 8.6.0.1 on Centos 5.9/Apache 2.2.3/MySQL 5.0.95
>
>
>
> I have a script that launches a rather hairy SQL call that keeps producing a
> Java error in libicuuc.so ( I've attached the java error file from
> LassoSites folder).  The query takes a few seconds but will run if I copy
> and paste it into a mysql client such as command line client or phpmyadmin.
> Watching Lasso in console mode I see the error happen and then one of the
> Lasso child processes dies but Lasso recovers and respawns a child process
> so things appear normal.  However, I believe over time that this causes the
> server to become non-responsive requiring a restart of lasso using lasso8ctl
> script.  
>
>
>
> For instance, after the SQL call causes the Java error I get this:
>
>
>
> [rbrooks@server9 ~]$ ps auxc | grep Lasso
>
> root      7066  0.0  0.0   4836  1152 pts/1    S+   13:23   0:00
> consoleLassoSer
>
> lasso     7078  0.0  0.3 129988 27736 pts/1    Sl+  13:23   0:00
> Lasso8Service
>
>
>
> and after another call is made to the server and Lasso relaunches another
> child I get this :
>
>
>
> [rbrooks@server9 ~]$ ps auxc | grep Lasso
>
> root      7066  0.0  0.0   4836  1152 pts/1    S+   13:23   0:00
> consoleLassoSer
>
> lasso     7078  0.0  0.3 129988 27772 pts/1    Sl+  13:23   0:00
> Lasso8Service
>
> lasso     7269 23.8  0.7 2496148 58732 pts/1   Sl+  13:44   0:01
> Lasso8Service
>
>
>
>
>
> I've tried upping the heap size on the JVM.  The library in question
> (libicuuc.so ) belongs to ICU suite (http://site.icu-project.org/) which are
> Java/C++ libs for Unicode support.
>
>
>
> This SQL call is for a report on large amounts of data and could return
> upwards of 50K rows to be written to a file.  
>
>
>
> Has anyone seen this before?  I can't think of where else to look.
>
>
>
>
>
> Thanks
>
> Rob
>
>
>
>
>
>
>
> #############################################################
> This message is sent to you because you are subscribed to
>  the mailing list Lasso
> [hidden email]
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>

#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Java Errors

Kyle Jessup-2

On Mar 20, 2013, at 8:08 AM, Kyle Jessup <[hidden email]> wrote:

> The "Java" here is just a crash log, but Java isn't the cause or involved in any way (we do not use the java icu).
>
> The first thing I'd look for is that your BLOB fields are BLOBS and that your text field have valid text in them. Since it appears to be crashing in icu which does the unicode handling, that's my first hunch.
>
> -Kyle
>

Another idea:

Do you have SQL statement logging turned on or any other type of excessive logging which might involve the SQL? log_warning(action_statement), for example.

-Kyle

> On Mar 19, 2013, at 2:52 PM, Rob Brooks <[hidden email]> wrote:
>
>> Hello, I'm running Lasso 8.6.0.1 on Centos 5.9/Apache 2.2.3/MySQL 5.0.95
>>
>>
>>
>> I have a script that launches a rather hairy SQL call that keeps producing a
>> Java error in libicuuc.so ( I've attached the java error file from
>> LassoSites folder).  The query takes a few seconds but will run if I copy
>> and paste it into a mysql client such as command line client or phpmyadmin.
>> Watching Lasso in console mode I see the error happen and then one of the
>> Lasso child processes dies but Lasso recovers and respawns a child process
>> so things appear normal.  However, I believe over time that this causes the
>> server to become non-responsive requiring a restart of lasso using lasso8ctl
>> script.  
>>
>>
>>
>> For instance, after the SQL call causes the Java error I get this:
>>
>>
>>
>> [rbrooks@server9 ~]$ ps auxc | grep Lasso
>>
>> root      7066  0.0  0.0   4836  1152 pts/1    S+   13:23   0:00
>> consoleLassoSer
>>
>> lasso     7078  0.0  0.3 129988 27736 pts/1    Sl+  13:23   0:00
>> Lasso8Service
>>
>>
>>
>> and after another call is made to the server and Lasso relaunches another
>> child I get this :
>>
>>
>>
>> [rbrooks@server9 ~]$ ps auxc | grep Lasso
>>
>> root      7066  0.0  0.0   4836  1152 pts/1    S+   13:23   0:00
>> consoleLassoSer
>>
>> lasso     7078  0.0  0.3 129988 27772 pts/1    Sl+  13:23   0:00
>> Lasso8Service
>>
>> lasso     7269 23.8  0.7 2496148 58732 pts/1   Sl+  13:44   0:01
>> Lasso8Service
>>
>>
>>
>>
>>
>> I've tried upping the heap size on the JVM.  The library in question
>> (libicuuc.so ) belongs to ICU suite (http://site.icu-project.org/) which are
>> Java/C++ libs for Unicode support.
>>
>>
>>
>> This SQL call is for a report on large amounts of data and could return
>> upwards of 50K rows to be written to a file.  
>>
>>
>>
>> Has anyone seen this before?  I can't think of where else to look.
>>
>>
>>
>>
>>
>> Thanks
>>
>> Rob
>>
>>
>>
>>
>>
>>
>>
>> #############################################################
>> This message is sent to you because you are subscribed to
>> the mailing list Lasso
>> [hidden email]
>> To unsubscribe, E-mail to: <[hidden email]>
>> Send administrative queries to  <[hidden email]>
>
> #############################################################
> This message is sent to you because you are subscribed to
>  the mailing list Lasso
> [hidden email]
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>

#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>