oceanbase / oceanbase/seekdb

Docker seekdb deployment with init SQL fails to execute initialization scripts

Open
#352 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

dima
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

  1. Deploy the seekdb Docker container with a configuration that includes initialization SQL scripts (e.g., via environment variables or mounted volumes).
  2. Start the container.
  3. Observe that the container process (seekdb) starts, as indicated by the version output.
  4. 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

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.