Docker seekdb deployment with init SQL fails to execute initialization scripts
Nobody has claimed this yet.
- Dominant language
- C++
- Stars
- 2.9k
- Forks
- 339
- Avg merge
- 1d 19h
- Merged PRs (30d)
- 52
Description
Environment
- Version: OceanBase seekdb 1.2.0.0
- Source Revision: 100000222026032420-bde98aeaa8740119c4a2aa420138c838312e6708
- Deployment Method: Docker
Description
When deploying the seekdb Docker container with initialization SQL scripts, the scripts are not successfully executed. The container starts, but the specified SQL for initial setup does not run.
Steps to Reproduce
- Deploy the seekdb Docker container with a configuration that includes initialization SQL scripts (e.g., via environment variables or mounted volumes).
- Start the container.
- Observe that the container process (
seekdb) starts, as indicated by the version output. - Check the database state; the expected tables, data, or users defined in the init SQL are not present.
Impact
The database is not in the expected initial state after deployment, requiring manual intervention to run setup scripts. This breaks automated deployment and provisioning workflows that rely on a fully initialized instance.
Proposed Solution
Investigate the Docker entrypoint or startup sequence to ensure initialization SQL hooks are correctly triggered after the seekdb process is ready to accept connections. The fix should ensure compatibility with common methods for providing init SQL (e.g., /docker-entrypoint-initdb.d/ pattern or specific environment variables).
Contributor guide
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
Inspect the Docker entrypoint and startup sequence, using the reported environment-variable and mounted-volume initialization methods, including /docker-entrypoint-initdb.d/. Reproduce the deployment and verify that init SQL runs after seekdb accepts connections; done means the expected tables, data, or users are present without manual intervention.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- docker, sql
- Domain
- databases, devops
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Quiet
- Clarity
- Mostly clear
- Newbie friendliness
- 48/100