June 19, 2013

Problem dumping MySQL database - Unknown system variable 'GTID_MODE'

I was trying to dump and restore a MySQL database today, but received the following error when I tried to dump: mysqldump: Couldn't execute 'SELECT @@GTID_MODE': Unknown system variable 'GTID_MODE' (1193) The MySQL version of the database I was trying to dump was 5.5.28 and the server I was trying to restore into was 5.6.10. A quick google told me that the error was likely due to this mismatch in versions. ... Read more

May 22, 2013

MySQL thread_stack overrun error

We added a trigger to MySQL (v5.5.28) recently that was a simple UPDATE on table column, when a target table was UPDATEd. It ran fine (as expected) on our development environment but not when we pushed the changes to staging. The error being thrown by MySQL was: Thread stack overrun: 8304 bytes used of a 131072 byte stack, and 128000 bytes needed. Use 'mysqld --thread_stack=#' to specify a bigger stack. Querying the database told me that the current _threadstack setting is 128K: ... Read more

© Michael Sharman 2017