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
