https://github.com/osquery/osquery logo
#fleet
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:
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?
m

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
Anyone 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 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
@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 PM
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
s

Stephan

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