search

droher / boxball

Prebuilt Docker images with Retrosheet's complete baseball history data for many analytical frameworks. Includes Postgres, cstore_fdw, MySQL, SQLite, Clickhouse, Drill, Parquet, and CSV.
Apache License 2.0
120 stars 16 forks source link

retrosheet_event table empty for postgres-cstore-fdw #59

Closed BBergquist closed 3 years ago

BBergquist commented 3 years ago

Executing SELECT COUNT(*) FROM retrosheet_event; returns 0. I've tried the latest image and 2020.2.

To Reproduce Steps to reproduce the behavior:

  1. docker run --name postgres-cstore-fdw -d -p 5433:5432 -e POSTGRES_PASSWORD="postgres" -v ~/boxball/postgres-cstore-fdw:/var/lib/postgresql/data doublewick/boxball:postgres-cstore-fdw-latest
  2. psql -U postgres -p 5433
  3. SELECT COUNT(*) FROM retrosheet_event
  4. Output should be zero.

Expected behavior Is the event data still being included in the images?

Desktop (please complete the following information):

droher commented 3 years ago

I'm unable to reproduce this error. Could you try removing the volume/container and trying again? The event table loads last and takes the longest, so it's possible that it got interrupted.

docker rm -f postgres-cstore-fdw
rm -rf ~/boxball/postgres-cstore-fdw

If you're still getting it after that, could you post the container logs?

BBergquist commented 3 years ago

Thank you, I will try that. It might be a week or so until I am able to follow up.

BBergquist commented 3 years ago

You are correct. I must have messed it up the first time. Thank you for the quick help!