Not the answer you need?
Register and ask your own question!

[ERROR] InnoDB: MySQL is freeing a thd

pablo.barrachinapablo.barrachina EntrantInactive User Role Contributor
Hi All,

From time ago, we are receiving this errors in production environment:

[ERROR] InnoDB: MySQL is freeing a thd though trx->n_mysql_tables_in_use is 1 and trx->mysql_n_tables_locked is 3.

I was searching internet, but only found references from years ago.

Can be a problem? Can anyone help us?

Percona Server 5.7.18
CentOS Linux 7

Thank you!

Comments

  • RoelVandePaarRoelVandePaar Contributor Inactive User Role Beginner
    Hi Pablo

    Could it be that innodb-thread-concurrency > 0 and actual Threads_running > innodb-thread-concurrency?
  • pablo.barrachinapablo.barrachina Entrant Inactive User Role Contributor
    Hi Roel,

    Thanks for your answer. We have innodb-thread-concurrency set to 0 (default), so I think that's not the problem....

    Any ideas?

    Thank you!
  • pablo.barrachinapablo.barrachina Entrant Inactive User Role Contributor
    I've reading some blogs and I see that could be due to cache configuration.

    This is our cache configuration:

    query_cache_size=1024M
    query_cache_type=ON


    It could be possible?
  • pablo.barrachinapablo.barrachina Entrant Inactive User Role Contributor
    Hi, We have disabled the cache configuration, but error continues appearing.... any ideas? What's the meaning of the mysql_n_tables_locked value? Thank you!
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.