0 Replies Latest reply on May 19, 2005 3:35 AM by Stephan Fudeus

    OutOfMemory and heavy load on jboss-start when using mysql-s

    Stephan Fudeus Newbie

      Hi,

      I searched a while until I discovered the following problem:

      scenario:
      JDBCStateManager on MySQL with existing tables (so CREATE_TABLES_ON_STARTUP = FALSE).

      Starting JBoss lead to OutOfMemory-Exceptions after a while and no error-message about the cause.

      solution:
      After enabling full logging on the database, I found out that I had an error in the database-schema (column-name PASSWD / PASSWORD in JMS_USERS) and jboss tried those selects (GET_USER_BY_CLIENTID) over and over.
      It seems that when looking up users, upcoming sql-exceptions are ignored and the select is tried all over with increasing clientids.

      Excerpt from mysql-log:

      5 Prepare [9] SELECT USERID, PASSWD, CLIENTID FROM JMS_USERS WHERE CLIENTID=?
      5 Query SELECT USERID, PASSWD, CLIENTID FROM JMS_USERS WHERE CLIENTID='ID:1'
      5 Query rollback
      5 Prepare [10] SELECT USERID, PASSWD, CLIENTID FROM JMS_USERS WHERE CLIENTID=?
      5 Query SELECT USERID, PASSWD, CLIENTID FROM JMS_USERS WHERE CLIENTID='ID:2'
      5 Query rollback
      


      Even if it would make sense to try again in case of some SQLExceptions (in this case obviously not) some kind of error-logging would be helful to find the error early.

      Bye,
      Stephan