colinmollenhour / mariadb-galera-swarm

MariaDb Galera Cluster container based on official mariadb image which can auto-bootstrap and recover cluster state.
https://hub.docker.com/r/colinmollenhour/mariadb-galera-swarm
Apache License 2.0
217 stars 102 forks source link

Use of --init-file (in start.sh) may result in ERROR: 1105 Boostrap file error. Query size exceeded 20000 bytes. #44

Closed alphaDev23 closed 2 years ago

alphaDev23 commented 6 years ago

Starting the seed with a sql file (in /docker-entrypoint-initdb.d/) that contains queries greater than 20,000 bytes results in 'ERROR: 1105 Boostrap file error. Query size exceeded 20000 bytes'. The following describes the issue in greater detail: https://bugs.mysql.com/bug.php?id=67345

The current container functions differently than the mariadb:10.2 container which does not exhibit this issue.

While myqldump, for example, can be executed with the options '--extended-insert=FALSE --complete-insert' to break the insert queries, this does not guaranty that the issue will not be exhibited given a query may still exceed 20,000 bytes even with these options set.