docker-postgresql icon indicating copy to clipboard operation
docker-postgresql copied to clipboard

"Corrupted statistics file" errors

Open rspeer opened this issue 7 years ago • 2 comments

I'm running version 9.5-2 of this container on Docker 1.12.1 on Linux, and eventually it starts outputting lots of errors about files in its data volume.

Here are the kind of errors I get:

db_1             | WARNING:  corrupted statistics file "pg_stat_tmp/global.stat"
db_1             | WARNING:  corrupted statistics file "pg_stat_tmp/global.stat"
db_1             | WARNING:  corrupted statistics file "pg_stat_tmp/global.stat"
db_1             | LOG:  could not rename temporary statistics file "pg_stat_tmp/db_0.tmp" to "pg_stat_tmp/db_0.stat": No such file or directory
db_1             | LOG:  could not rename temporary statistics file "pg_stat_tmp/global.tmp" to "pg_stat_tmp/global.stat": No such file or directory

Here's the docker-compose configuration that launches it:

db:
    restart: always
    image: sameersbn/postgresql:9.5-2
    expose:
      - "5432"
    environment:
      - DEBUG=false
      - PG_TRUST_LOCALNET=true
      - DB_NAME=conceptnet5
    volumes:
      - /bigdrive/conceptnet5.5/postgresql:/var/lib/postgresql

rspeer avatar Sep 29 '16 20:09 rspeer