Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

TRUNCATE TABLE causes "Stopping / Starting purge" log entries

Description

After upgrading to 5.7.40, every time TRUNCATE TABLE is executed, this gets logged in the error log:

 

2023-01-09T12:42:08.822717Z 2 [Note] InnoDB: Stopping purge 2023-01-09T12:42:08.824934Z 2 [Note] InnoDB: Resuming purge

How to repeat:

With log_error_verbosity=3, execute TRUNCATE TABLE and check error log:

 

mysql> create table t(id int primary key); Query OK, 0 rows affected (0.00 sec) mysql> truncate table t; Query OK, 0 rows affected (0.01 sec) mysql> truncate table t; Query OK, 0 rows affected (0.00 sec) mysql> truncate table t; Query OK, 0 rows affected (0.00 sec)

Followed by:

# tail /var/log/mysqld.log 2023-01-09T12:41:17.788062Z 0 [Note] Failed to start slave threads for channel '' 2023-01-09T12:41:17.792762Z 0 [Note] Event Scheduler: Loaded 0 events 2023-01-09T12:41:17.792998Z 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.7.40-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL) 2023-01-09T12:42:08.822717Z 2 [Note] InnoDB: Stopping purge 2023-01-09T12:42:08.824934Z 2 [Note] InnoDB: Resuming purge 2023-01-09T12:42:09.564364Z 2 [Note] InnoDB: Stopping purge 2023-01-09T12:42:09.566206Z 2 [Note] InnoDB: Resuming purge 2023-01-09T12:42:09.944561Z 2 [Note] InnoDB: Stopping purge 2023-01-09T12:42:09.946289Z 2 [Note] InnoDB: Resuming purge

On a system doing lots of truncating the error log is flooded with the above. This did not happen on 5.7.39.

I suspect this change is what causes this:

https://github.com/mysql/mysql-server/commit/c7d0df6b872b60b7f0a67f69ecdc85c188792f7a#diff...

It adds a call to trx_purge_stop() in row0trunc.cc which seems to be the cause of these notes in the log.

Environment

None

AFFECTED CS IDs

CS0032746, CS0033049

Activity

Yunus Shaikh January 16, 2023 at 12:43 PM

I confirm same behaviour with 

version 5.7.40-43-57-log version_comment Percona XtraDB Cluster (GPL), Release rel43, Revision ab4d0bd, WSREP version 31.63, wsrep_31.63 version_compile_machine x86_64

Sami Ahlroos January 10, 2023 at 8:07 AM

The log entry says "MySQL community server", but same happens with PS and PXC 5.7.40.

Details

Assignee

Reporter

Upstream Bug URL

https://bugs.mysql.com/bug.php?id=109552
https://bugs.mysql.com/bug.php?id=109552

Needs QA

Yes

Affects versions

Priority

Smart Checklist

Created January 9, 2023 at 1:07 PM
Updated March 6, 2024 at 9:51 AM

Flag notifications