linkedin / linkedin/oncall

dummy data fails to import

Open
#417 1 comment 0 reactions 0 assignees View on GitHub
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.