Channels
android_tests
apple-silicon
arm-architecture
auditing-warroom
aws
carving
code-review
community-feeds
core
darkbytes
doorman
ebpf
eclecticiq-polylogyx-extension
extensions
file-carving
fim
fleet
fleet-dev
fleetosquery
foundation
fuzzing
general
golang
goquery
infrastructure
jobs
kolide
linen-dev
linux
macos
officehours
osctrl
plugins
process-auditing
querycon
queryhub
random
selfgroup
sql
tls
uptycs
vendor-feeds
website
windows
zeek
zentral
zercurity
Title
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.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
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 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
@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
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