search

mikeizbicki / cmc-csci143

big data course materials
40 stars 76 forks source link

pagilahw3 update data issue #466

Closed giffiecode closed 7 months ago

giffiecode commented 7 months ago

after following the README.md file to obtain the latest data, I still get 

postgres=# select count(*) from store;
 count 
-------
     2
(1 row)

when I run docker ps -a, i get 

Yuechen.Pei.23@lambda-server:~/pagila-hw3$ docker ps -a 
CONTAINER ID   IMAGE                   COMMAND                  CREATED          STATUS                    PORTS      NAMES
35dc1d73c72e   pagila-hw3_pg           "docker-entrypoint.s…"   12 minutes ago   Up 2 minutes              5432/tcp   pagila-hw3_pg_1
5b4d62e38245   dpage/pgadmin4          "/entrypoint.sh"         27 minutes ago   Created                              pgadmin4_container
df2ce693a332   postgres:13.2           "docker-entrypoint.s…"   27 minutes ago   Created                              pagila
c1c3a5781722   lab-consistency_mysql   "docker-entrypoint.s…"   26 hours ago     Exited (0) 20 hours ago              lab-consistency_mysql_1
5d36aad9f2a0   lab-consistency_pg      "docker-entrypoint.s…"   26 hours ago     Exited (0) 20 hours ago              lab-consistency_pg_1
33e399d78e71   pagila-hw2_pg           "docker-entrypoint.s…"   3 days ago       Exited (0) 3 days ago                pagila-hw2_pg_1
f6bf0f862e1c   pagila-hw_pg            "docker-entrypoint.s…"   12 days ago      Exited (0) 12 days ago               pagila-hw_pg_1

anyone knows how to solve this issue?

tylerheadley commented 7 months ago

You may need to bring the container down and then bring it back up again.

giffiecode commented 7 months ago

i've done that multiple times :(

mikeizbicki commented 7 months ago

I'm closing since we resolved this in office hours.