:wave: during an upgrade from 4.1.0 to 4.4.0 we g...
# fleets
Stephan
10/07/2021, 6:49 PM👋 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.m
Martavis Parker
10/07/2021, 7:22 PMWhich version of MYSQL are you using? MariaDB?
s
Stephan
10/07/2021, 7:45 PM@Martavis Parker mysql-community-server 5.7.32-1debian9
Stephan
10/08/2021, 7:30 PMAnyone got any more thoughts on this issue?
b
Benjamin Edwards
10/08/2021, 7:38 PM@zwass is this related to the point release we needed to create today?
t
Tomas Touceda
10/08/2021, 8:13 PMit'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 PMYup, we do
Stephan
10/08/2021, 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
t
Tomas Touceda
10/08/2021, 8:20 PMyou don't have to change it forever, just to run the migrations
Tomas Touceda
10/08/2021, 8:20 PMafter 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
10/08/2021, 8:20 PMwe'll take this into account for future migrations
s
Stephan
10/08/2021, 8:24 PM👍 thanks
2 Views