Postgre database maxed out at 100MB
edmundhighcock opened this issue · 3 comments
edmundhighcock commented
Dear docker-taiga,
Thanks as ever for providing this great package. I have been running it for 2 years without problems.
However, unfortunately our server has stopped working, and it appears that the database cannot write any more:
docker-compose logs -t db
taiga-db | 2020-06-17T08:55:22.362237520Z 2020-06-17 08:55:22.362 UTC [8917] LOG: could not close temporary statistics file "pg_stat_tmp/global.tmp": No space left on device
taiga-db | 2020-06-17T08:55:23.012867079Z 2020-06-17 08:55:23.012 UTC [8917] LOG: could not close temporary statistics file "pg_stat_tmp/global.tmp": No space left on device
The db takes up exactly 100MB... is the size limited somewhere?
sudo du -h --max-depth=0 data/db
100M data/db
Thanks in advance!
edmundhighcock commented
When I go into the db container, it all looks fine:
$ docker exec -it taiga-db sh
/ # df -h
Filesystem Size Used Available Use% Mounted on
overlay 64.0G 8.1G 55.9G 13% /
tmpfs 64.0M 0 64.0M 0% /dev
tmpfs 478.6M 0 478.6M 0% /sys/fs/cgroup
/dev/nvme0n1p1 64.0G 8.1G 55.9G 13% /etc/resolv.conf
/dev/nvme0n1p1 64.0G 8.1G 55.9G 13% /etc/hostname
/dev/nvme0n1p1 64.0G 8.1G 55.9G 13% /etc/hosts
shm 64.0M 8.0K 64.0M 0% /dev/shm
/dev/nvme0n1p1 64.0G 8.1G 55.9G 13% /var/lib/postgresql/data
tmpfs 478.6M 0 478.6M 0% /proc/acpi
tmpfs 64.0M 0 64.0M 0% /proc/kcore
tmpfs 64.0M 0 64.0M 0% /proc/keys
tmpfs 64.0M 0 64.0M 0% /proc/latency_stats
tmpfs 64.0M 0 64.0M 0% /proc/timer_list
tmpfs 64.0M 0 64.0M 0% /proc/sched_debug
tmpfs 478.6M 0 478.6M 0% /sys/firmware
w1ck3dg0ph3r commented
Hi!
Sorry, I can't reproduce this:
$ sudo du -hd0 data/db
353M data/db
Maybe there is some disk quota set up externally?
edmundhighcock commented
I never found out the cause of this, but updating to the your latest version fixed it.