:wave: hi, we are struggling with `hydra migrate ...
# talk-hydra
s
đź‘‹ hi, we are struggling with
hydra migrate sql
since there is a
max_statement_time
in place at global level for our MariaDB instance, (MySQL equivalent is
max_execution_time
) Due to pretty huge table, one of the migrations fails and breaks our schema so we have to do a manual roll-back. I am wondering if there is a way to tell
hydra migrate
to use a bigger timeout while it's running... (there are workarounds for us, but I would like to see something convenient like
hydra migrate sql --timeout=10m
so I don't have to update our DB parameters temporarily just for migration)
s
you can probably set that as a query param in the DSN
s
thank you @steep-lamp-91158 , I was searching for dedicated param, but totally missed that “everything else” is passed “as is” 🤦 sorry for bothering with you with this stupid question