dummy data fails to import
- Dominant language
- Python
- Stars
- 1.3k
- Forks
- 245
- PR merge metrics
- No merged PRs in 30d
Description
on a fresh install and attempting to bring up with docker (no changes to any files:
```
oncall-web-1 | DB successfully loaded /home/oncall/db/schema.v0.sql
oncall-web-1 | Importing /home/oncall/db/dummy_data.sql...
oncall-web-1 | mysql: [Warning] Using a password on the command line interface can be insecure.
oncall-web-1 | ERROR 1136 (21S01) at line 16: Column count doesn't match value count at row 1
oncall-web-1 | Ran into problems during DB bootstrap. oncall will likely not function correctly. mysql exit code: 1 for /home/oncall/db/dummy_data.sql
oncall-web-1 | Wrote /home/oncall/db_initialized so we don't bootstrap db again
```
Contributor guide
Research direction
Start with db/dummy_data.sql at line 16 and compare its INSERT values with the table definitions in db/schema.v0.sql. Reproduce the fresh-install Docker bootstrap and verify that dummy_data.sql imports without MySQL error 1136 and the database initialization completes successfully.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- docker, mysql
- Domain
- databases, devops
- Issue type
- Bug
- Difficulty
- 2/5
- Estimated time
- 1-3 hours
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 45/100