search

mikeizbicki / cmc-csci143

big data course materials
40 stars 76 forks source link

PSQL Error #535

Open tylerting opened 6 months ago

tylerting commented 6 months ago

As I run the following commands:

nohup sh load_tweets_parallel.sh
cat nohup.out

I get the following output:

psql: FATAL:  could not open file "base/13468/pg_filenode.map": No such file or directory

I have double checked the port numbers on docker-compose.yml, load_denormalized.sh, and load_tweets_parallel.sh files but not sure why I am running into such errors. Tried reseting containers within docker, bring them down and building them up but it's not fixing things. Does anyone know how I could fix this?

mikeizbicki commented 6 months ago

The file base/13468/pg_filenode.map is contained inside the postgtres database in the $PGDATA folder. This file being missing means that your database has been corrupted. Probably you tried to delete the database and the rm command was interrupted and so deleted only some of the files. Rerunning this command allow you to re-build the database and fix the problem.