Title
#fleet
s

Stephan

10/07/2021, 6:49 PM
👋 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

Martavis Parker

10/07/2021, 7:22 PM
Which version of MYSQL are you using? MariaDB?
s

Stephan

10/07/2021, 7:45 PM
@Martavis Parker mysql-community-server 5.7.32-1debian9
7:30 PM
Anyone got any more thoughts on this issue?
Benjamin Edwards

Benjamin Edwards

10/08/2021, 7:38 PM
@zwass is this related to the point release we needed to create today?
Tomas Touceda

Tomas Touceda

10/08/2021, 8:13 PM
it's related to the db running, do you have statement based replication configured? the temporary table creation is not safe for that
s

Stephan

10/08/2021, 8:18 PM
Yup, we do
8:19 PM
@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

Tomas Touceda

10/08/2021, 8:20 PM
you don't have to change it forever, just to run the migrations
8:20 PM
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
8:20 PM
we'll take this into account for future migrations
s

Stephan

10/08/2021, 8:24 PM
👍 thanks