4 Replies Latest reply on May 21, 2002 10:46 AM by Guy Bullen-Smith

    OutOfMemory error JBoss 3.0RC2 CMP

    Guy Bullen-Smith Newbie

      In attempting to load up a table JBoss threw OutOfMemory
      after about 2300 insertions.

      Each create is made in a separate call to a transactional method of a session bean. It involves a couple of lookups and an update of a "next id table". The prior entries are in the DB.

      Is something broken or is it a configure/installation problem?

      Thanks, Guy

      Here's the tail of the log:

      2002-05-20 15:22:34,134 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.KeyCounter.findByPrimaryKey] Executing SQL: SELECT beanName FROM KeyCounter WHERE beanName=?
      2002-05-20 15:22:34,134 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.KeyCounter] Executing SQL: SELECT version, nextFreeId FROM KeyCounter WHERE (beanName=?)
      2002-05-20 15:22:34,134 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.Agreement] Create: pk=[.2349.]
      2002-05-20 15:22:34,134 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.Agreement] Executing SQL: SELECT COUNT(*) FROM Agreement WHERE id=?
      2002-05-20 15:22:34,134 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.Agreement] Executing SQL: INSERT INTO Agreement (id, version, agreementCode, clientId, dueDate, nextDueDate, commenceDate, firstInsDate, finalPayDate, archiveDate, newFlag, settledFlag, expiredFlag, pdiFlag, reloadFlag, statementFlag, repeatFlag, assetFlag, eftFlag, eri, primeRate, frequency, orgPeriod, spread, residualAmt, eftDay, bankBranchKey, bankAccount, bankAccTypeKey, bankAccName, adhocAmt, agreementTypeKey, fixLink, invoiceNetTot, invoiceVatTot, invoiceExtTot, orgContractBal, orgAccountBal, orgPrinciple, dealerDeposit, ourDeposit, depositDueDate, interimInt, financeCharges, contractBal, dueBal, ufcBal, bookValueBal) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
      2002-05-20 15:22:35,035 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.Agreement] Create: Rows affected = 1
      2002-05-20 15:22:35,035 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreEntityCommand.KeyCounter] Executing SQL: UPDATE KeyCounter SET version=?, nextFreeId=? WHERE beanName=?
      2002-05-20 15:22:35,035 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreEntityCommand.KeyCounter] Create: Rows affected = 1
      2002-05-20 15:22:35,035 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreEntityCommand.Agreement] Executing SQL: UPDATE Agreement SET version=? WHERE id=?
      2002-05-20 15:22:35,035 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreEntityCommand.Agreement] Create: Rows affected = 1
      2002-05-20 15:22:36,097 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.Client.findByCode] Executing SQL: SELECT t0_c.id FROM Client t0_c WHERE t0_c.clientCode = ?
      2002-05-20 15:22:36,107 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.Client] Executing SQL: SELECT version, clientCode, name, firstName, initials, title, tradeName, contactName, contactTitle, physAddress1, physAddress2, physAddress3, physCity, physCode, postAddress1, postAddress2, postAddress3, postCity, postCode, workAddress1, workAddress2, workAddress3, workCity, workCode, telHome, telWork, telFax, telCell, email, idPassNo, dob, coRegNo, taxNo, globDebDay, bankBranchKey, bankAccount, bankAccTypeKey, bankAccName, finYrEnd, clientType FROM Client WHERE (id=?)
      2002-05-20 15:22:36,107 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreEntityCommand.Client] Executing SQL: UPDATE Client SET version=? WHERE id=?
      2002-05-20 15:22:36,117 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreEntityCommand.Client] Create: Rows affected = 1
      2002-05-20 15:22:36,117 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.KeyCounter.findByPrimaryKey] Executing SQL: SELECT beanName FROM KeyCounter WHERE beanName=?
      2002-05-20 15:22:36,117 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.KeyCounter] Executing SQL: SELECT version, nextFreeId FROM KeyCounter WHERE (beanName=?)
      2002-05-20 15:22:37,869 ERROR [org.jboss.ejb.plugins.LogInterceptor] TransactionRolledbackException, causedBy:
      java.lang.OutOfMemoryError
      2002-05-20 15:22:40,734 ERROR [STDERR] java.lang.OutOfMemoryError
      2002-05-20 15:23:32,738 ERROR [STDERR] java.lang.OutOfMemoryError
      2002-05-20 15:24:34,597 DEBUG [org.jboss.ejb.plugins.LRUEnterpriseContextCachePolicy] Resized cache for bean PayPlan: old capacity = 1000000, new capacity = 50
      2002-05-20 15:27:00,968 DEBUG [org.jboss.resource.connectionmanager.IdleRemover] run: IdleRemover notifying pools, interval: 450000
      2002-05-20 15:34:30,965 DEBUG [org.jboss.resource.connectionmanager.IdleRemover] run: IdleRemover notifying pools, interval: 450000
      2002-05-20 15:42:00,972 DEBUG [org.jboss.resource.connectionmanager.IdleRemover] run: IdleRemover notifying pools, interval: 450000
      2002-05-20 15:49:31,049 DEBUG [org.jboss.resource.connectionmanager.IdleRemover] run: IdleRemover notifying pools, interval: 450000
      2002-05-20 15:57:01,056 DEBUG [org.jboss.resource.connectionmanager.IdleRemover] run: IdleRemover notifying pools, interval: 450000