0

PostgreSQL 11.2 has been running properly inside a Docker container until I did a docker-compose up to start a new container for another app, then accidentally press Ctrl+C, which killed all the running containers including the one containing PostgreSQL named timescaledb.

When I tried to start PostgreSQL again using the command docker-compose up -d, the docker log files show the following messages, including the errors

unexpected file found in temporary-files directory

and

database system was interrupted; last known up at 2020-02-13 03:13:42 UTC

Do we need to do anything to the unexpected temporary files?

timescaledb | PostgreSQL Database directory appears to contain a database; Skipping initialization
timescaledb | 
timescaledb | 2020-02-13 06:18:26.031 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
timescaledb | 2020-02-13 06:18:26.031 UTC [1] LOG:  listening on IPv6 address "::", port 5432
timescaledb | 2020-02-13 06:18:26.121 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
timescaledb | 2020-02-13 06:18:26.271 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden0002545c0000006c"
timescaledb | 2020-02-13 06:18:26.271 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden00a5e39600002f2e"
timescaledb | 2020-02-13 06:18:26.271 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden003e9e9e00001e8f"
timescaledb | 2020-02-13 06:18:26.271 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden0055488100002335"
timescaledb | 2020-02-13 06:18:26.271 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden000ccab3000003ff"
timescaledb | 2020-02-13 06:18:26.271 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden0026501600001d7b"
timescaledb | 2020-02-13 06:18:26.271 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden0024760b00001564"
timescaledb | 2020-02-13 06:18:26.271 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden000f30a300000a22"
timescaledb | 2020-02-13 06:18:26.271 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden012cff9800007536"
timescaledb | 2020-02-13 06:18:26.271 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden000cc3d7000003fc"
timescaledb | 2020-02-13 06:18:26.271 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden0077b46d00002a6f"
timescaledb | 2020-02-13 06:18:26.271 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden012cf80d0000751b"
timescaledb | 2020-02-13 06:18:26.271 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden003e811d00001e2e"
timescaledb | 2020-02-13 06:18:26.271 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden00247e1300001572"
timescaledb | 2020-02-13 06:18:26.271 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden000e6df70000079c"
timescaledb | 2020-02-13 06:18:26.271 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden0054f16200002232"
timescaledb | 2020-02-13 06:18:26.271 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden0024e33300001688"
timescaledb | 2020-02-13 06:18:26.271 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden007732a4000029cd"
timescaledb | 2020-02-13 06:18:26.271 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden0024bdd6000015f5"
timescaledb | 2020-02-13 06:18:26.271 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden002495d2000015c4"
timescaledb | 2020-02-13 06:18:26.271 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden015d68f900009445"
timescaledb | 2020-02-13 06:18:26.271 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden0021626800000de1"
timescaledb | 2020-02-13 06:18:26.271 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden00772fc3000029c0"
timescaledb | 2020-02-13 06:18:26.271 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden0003be5e0000011f"
timescaledb | 2020-02-13 06:18:26.271 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden0003ad4e0000010e"
timescaledb | 2020-02-13 06:18:26.271 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden003e93f200001e80"
timescaledb | 2020-02-13 06:18:26.271 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden00232856000010b0"
timescaledb | 2020-02-13 06:18:26.271 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden00553d8600002316"
timescaledb | 2020-02-13 06:18:26.271 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden000e1f1a000006b2"
timescaledb | 2020-02-13 06:18:26.271 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden0024687600001539"
timescaledb | 2020-02-13 06:18:26.271 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden00047afb00000145"
timescaledb | 2020-02-13 06:18:26.271 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden00a5b20900002ecc"
timescaledb | 2020-02-13 06:18:26.271 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden00772faf000029bf"
timescaledb | 2020-02-13 06:18:26.271 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden0126e6c60000737f"
timescaledb | 2020-02-13 06:18:26.271 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden012cea2b00007503"
timescaledb | 2020-02-13 06:18:26.271 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden0024a136000015d5"
timescaledb | 2020-02-13 06:18:26.271 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden007729f8000029ac"
timescaledb | 2020-02-13 06:18:26.271 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden012cf4e600007509"
timescaledb | 2020-02-13 06:18:26.271 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden0024acab000015ea"
timescaledb | 2020-02-13 06:18:26.271 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden00262e8e00001ccc"
timescaledb | 2020-02-13 06:18:26.272 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden003e819c00001e33"
timescaledb | 2020-02-13 06:18:26.272 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden00223d2d00000f98"
timescaledb | 2020-02-13 06:18:26.273 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden0055488300002331"
timescaledb | 2020-02-13 06:18:26.273 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden0126af680000734f"
timescaledb | 2020-02-13 06:18:26.273 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden0054428f00002107"
timescaledb | 2020-02-13 06:18:26.273 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden00225fe400000fa3"
timescaledb | 2020-02-13 06:18:26.273 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden0025c6e300001aaa"
timescaledb | 2020-02-13 06:18:26.273 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden012cc38e000074df"
timescaledb | 2020-02-13 06:18:26.273 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden00773a02000029d6"
timescaledb | 2020-02-13 06:18:26.273 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden003e838700001e35"
timescaledb | 2020-02-13 06:18:26.273 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden0024a52f000015e5"
timescaledb | 2020-02-13 06:18:26.273 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden000e053c0000069d"
timescaledb | 2020-02-13 06:18:26.273 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden000cdf3f0000040d"
timescaledb | 2020-02-13 06:18:26.273 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden002647ee00001d5f"
timescaledb | 2020-02-13 06:18:26.273 UTC [1] LOG:  unexpected file found in temporary-files directory: "base/pgsql_tmp/.fuse_hidden003e9f1b00001e90"
timescaledb | 2020-02-13 06:18:28.699 UTC [20] LOG:  database system was interrupted; last known up at 2020-02-13 03:13:42 UTC
timescaledb | 2020-02-13 06:23:32.981 UTC [20] LOG:  database system was not properly shut down; automatic recovery in progress
timescaledb | 2020-02-13 06:23:34.497 UTC [20] LOG:  redo starts at A7/76B84360
timescaledb | 2020-02-13 06:23:34.497 UTC [20] LOG:  invalid record length at A7/76B84440: wanted 24, got 0
timescaledb | 2020-02-13 06:23:34.497 UTC [20] LOG:  redo done at A7/76B84408
timescaledb | 2020-02-13 06:23:37.617 UTC [1] LOG:  database system is ready to accept connections
timescaledb | 2020-02-13 06:23:37.622 UTC [26] LOG:  TimescaleDB background worker launcher connected to shared catalogs

1 Answer 1

1

If you make sure that there is no query running on the database currently that may be using a temporary file, it is safe to remove these leftovers.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.