Skip to main content
Solved

Deadlock found when trying to get lock; try restarting transaction

  • June 20, 2024
  • 2 replies
  • 111 views

wackou
Forum|alt.badge.img+8

Hello everyone,
We are migrating our Centreon 21.04.20 version to the latest version 24.04.
We built a new Debian server and a fresh install of Centreon, it is running correctly.

Now that we are ready to migrate to this platform, we have the following error when importing the centreon_storage SQL export.

Deadlock found when trying to get lock; try restarting transaction

 

The export file is around 16G and the import to the mariadb is very slow.
 


Did you have any ideas to solve this issue ?​​​

Best answer by wackou

Replying to myself.

You have to enable the buffer for 8Go of RAM

vi /etc/mysql/mariadb.conf.d/80-centreon.cnf

 

 

2 replies

wackou
Forum|alt.badge.img+8
  • Author
  • Steward **
  • June 21, 2024

Here is the message that we got ...

 


wackou
Forum|alt.badge.img+8
  • Author
  • Steward **
  • Answer
  • February 23, 2026

Replying to myself.

You have to enable the buffer for 8Go of RAM

vi /etc/mysql/mariadb.conf.d/80-centreon.cnf