ERROR: Code [1206]; The total number of locks exceeds the lock table size;

  • 7013293
  • 13-Sep-2013
  • 25-Sep-2013

Environment

Novell Vibe 3.2

Situation

Unable to add an entry, get a general error "Please contact your System Administrator for assistance."

Resolution

  1. Backup Vibe database
    • https://www.novell.com/documentation/vibe32/vibe32_admin/data/ble2mdl.html
  2. Backup mysql global variables
    • Login to mysql on a terminal with a user that has admin rights to the database,for example 'root'
      mysql -u root -p
    • then enter the following mysql command:
      mysql> show global variables;
    • make sure you copy the values to the global variables on a text file as backup and reference.
    • look for the field innodb_buffer_pool_size and take note of the value.
      Is usually 8388608 bytes or 8M
    • mysql> quit;
  3. Stop mysql and vibe
    • rcmysql stop
    • /etc/init.d/teaming stop
  4. Go to the /etc/my.cnf file
    • uncomment the innodb_buffer_pool_size field and increase the value of what you currently have to about 25% more
    • innodb_buffer_pool_size = 10M
    • save file
  5. Start mysql and Vibe
    • rcmysql start
    • /etc/init.d/teaming start

Cause

It could be that the innodb_buffer_pool_size has exceeded its limit.

Additional Information

Catalina.out log file shows the following SQL error:

class org.springframework.jdbc.UncategorizedSQLException
Hibernate flushing: could not insert: [org.kablink.teaming.domain.AuditTrail]; uncategorized SQLException for SQL [insert into SS_AuditTrail (zoneId, startDate, startBy, endBy, endDate, entityType, entityId, owningBinderId, owningBinderKey, description, transactionType, fileId, applicationId, deletedFolderEntryFamily, type, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'A', ?)]; SQL state [HY000]; error code [1206]; The total number of locks exceeds the lock table size; nested exception is java.sql.SQLException: The total number of locks exceeds the lock table size

Feedback service temporarily unavailable. For content questions or problems, please contact Support.