:wave: during an upgrade from 4.1.0 to 4.4.0 we g...
# fleet
👋 during an upgrade from 4.1.0 to 4.4.0 we got the following error:
Copy code
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?
Which version of MYSQL are you using? MariaDB?
@Martavis Parker mysql-community-server 5.7.32-1debian9
Anyone got any more thoughts on this issue?
@zwass is this related to the point release we needed to create today?
it's related to the db running, do you have statement based replication configured? the temporary table creation is not safe for that
Yup, we do
@Tomas Touceda Beyond turning that off, anything we can do? It's a cluster managed by our DB team so changing that seems unlikely
you don't have to change it forever, just to run the migrations
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
we'll take this into account for future migrations
👍 thanks