Archiving no longer works

Hi!
I received an email error from WordPress on the Matomo plugin. Archiving doesn’t seem to work anymore because the plugin tells me “WP DB Error: [1637] Too many active concurrent transactions”.
I tried to find the solution through different forums but without success.
I will be grateful if you can help me! Thanks in advance.

Hi @marinelvsq, sorry for the delay.

Can you please provide us a copy of your system check: How do I find and copy the system report in Matomo for WordPress?

Hi! Here is the report:
https://justpaste.it/bfs58

Hi @marinelvsq thanks for that. Can you confirm roughly how many hits you have per month?
You can try to Archive less often and at low traffic times.

Also as per your system check - could you try address and resolve this error;

  • Error Database Capabilities: error (UTF8mb4 charset CREATE TEMPORARY TABLES MySQL CREATE TEMPORARY TABLES permission is required for Matomo to work properly.