docker-library / docker-library/mysql
Issue with entrypoint with DELIMITER?
Open
Nobody has claimed this yet.
question
- Dominant language
- Shell
- Stars
- 2.6k
- Forks
- 2.2k
- PR merge metrics
- No merged PRs in 30d
Description
I have an issue with SQL entrypoint, which runs without any issues when imported manually.
Error:
database | 2021-03-08 16:07:08+00:00 [Note] [Entrypoint]: /usr/local/bin/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/0.sql
database | ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER $$
database | /*!50003 DROP TRIGGER*//*!50032 IF EXISTS */ /*!50003 `test` */$$' at line 3
Example SQL file:
/* Trigger structure for table `test` */
DELIMITER $$
/*!50003 DROP TRIGGER*//*!50032 IF EXISTS */ /*!50003 `test` */$$
Image:
REPOSITORY TAG IMAGE ID CREATED SIZE
mysql 5.7 d54bd1054823 9 days ago 449MB
Docker version:
19.03.8
Can someone help me with this, please?
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Reproduce the report with the mysql:5.7 image, the shown SQL, and /docker-entrypoint-initdb.d/0.sql, then inspect /usr/local/bin/docker-entrypoint.sh. Compare initialization with the reported manual import and identify the expected DELIMITER behavior. Done requires an agreed fix or documented limitation plus a regression check.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- docker, mysql
- Domain
- database, devops
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 28/100