[MDEV-30684] InnoDB: Semaphore wait has lasted > 600 seconds Created: 2023-02-19 Updated: 2023-02-20 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Storage Engine - InnoDB |
| Affects Version/s: | 10.3.27 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major |
| Reporter: | Ivan | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | innodb | ||
| Environment: |
Debian Linux 10, RAM 11 Gb |
||
| Attachments: |
50-server.cnf
LOG ERROR.txt
my.cnf
|
||||||||
| Issue Links: |
|
||||||||
| Description |
|
Desde que realizamos el cambio de query_cache_size = 0 se nos está reproduciendo constantemente errores de transacciones, anteriormente la CPU se encontraba constantemente muy alta y se opto por activar la cache para optimizar el rendimiento. |
| Comments |
| Comment by Marko Mäkelä [ 2023-02-20 ] |
|
Server hangs can best be diagnosed from stack traces of all threads. MariaDB Server 10.3 is soon reaching its end of life. Several InnoDB hangs, such as |