1. mampsupportmod
  2. MAMP - Troubleshooting
  3. Thursday, 21 February 2019

I took a peek inside my MySQL today and noticed what appeared to be a hung process running over 292 hours called compress_gtid_table. I read about this thread on MySQL but I'm unclear why it's still running for so long.

 

The compress_gtid_table is defined in sql/rpl_gtid_persist.cc and reads The main function of the compression thread. Compress the gtid_executed table when get a compression signal.

 

mysql 5 7 23 mamp pro compress gtid table

 

mysql 5 7 23 mamp pro compress gtid table details

 

I tried killing the connection but was not successful...

 

my sql kill connection compress gtid table

Error Killing Connection

Error executing KILL QUERY on thread 1: Error executing 'KILL QUERY 1'

Unknown thread id: 1.

SQL Error: 1094

 

 

my sql kill connection compress gtid table unhandled exception

Unhandled exception:

DbMySQLQuery.resultFieldStringValue():

MySQL_ResultSet::getDouble: can't fetch because not on result set.

 

 

I ended up restarting MySQL and the thread has not come back since. Will keep this updated.





There are no replies made for this post yet.
Be one of the first to reply to this post!