wave during an upgrade from 4 1 0 to 4 4 0 we got the follow

Question

wave during an upgrade from 4 1 0 to 4 4 0 we got the following error ```FAIL 20210819131107 AddCascadeToHostSoftware go save current host software to a temp table Error 1787 Statement violates GTID consistency CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi statement transactions quitting migration ``` Anyone else run into this

Martavis Parker · Answer

Which version of MYSQL are you using MariaDB

Stephan · Answer

< Martavis Parker> mysql community server 5 7 32 1debian9

Stephan · Answer

Anyone got any more thoughts on this issue

Benjamin Edwards · Answer

< zwass> is this related to the point release we needed to create today

Tomas Touceda · Answer

it s related to the db running do you have statement based replication configured the temporary table creation is not safe for that

Stephan · Answer

Yup we do

Stephan · Answer

< Tomas Touceda> Beyond turning that off anything we can do It s a cluster managed by our DB team so changing that seems unlikely

Tomas Touceda · Answer

you don t have to change it forever just to run the migrations

Tomas Touceda · Answer

after they are run you can turn it on again and it ll be rare for you to need to turn it off again after that

Tomas Touceda · Answer

we ll take this into account for future migrations

Stephan · Answer

+1 thanks