When updating the PrivacyIdea server from Ubuntu 20.0.4 LTS (PrivacyIdea 3.11) to Ubuntu 22.0.4 LTS (PrivacyIdea 3.12), an error occurs during the DB schema update phase.
Hello and welcome Michal_Soppe,
The error comes from MySQL/InnoDB during the privacyIDEA database migration:
(1206) The total number of locks exceeds the lock table size
This happens when the migration runs a large transaction that needs many row locks, but the MySQL server has too little InnoDB memory available.
See:
Br
Julio
1 Like
It works. Thanks for the help. I increased the memory to the same size as the VM’s allocated memory in the configuration file “/etc/mysql/my.cnf”
[mysqld]
innodb_buffer_pool_size =4G
1 Like