Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Ambari with Postgres

avatar
New Contributor

Hi,

Generate the following error in the postgres database installed with the ambari. Can you please help? Postgres cannot be started. Ambari-server cannot be started.

 

/var/log/postgresql/postgresql-10-main.log

 

2020-12-16 16:39:01.601 +03 [1688] LOG:  worker process: logical replication launcher (PID 1821) exited with exit code 1
2020-12-16 16:39:01.602 +03 [1814] LOG:  shutting down
2020-12-16 16:39:05.512 +03 [1688] LOG:  database system is shut down
2020-12-16 16:43:03.421 +03 [1772] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2020-12-16 16:43:03.454 +03 [1772] LOG:  listening on IPv6 address "::", port 5432
2020-12-16 16:43:03.764 +03 [1772] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2020-12-16 16:43:05.405 +03 [1809] LOG:  database system was shut down at 2020-12-16 16:39:05 +03
2020-12-16 16:43:06.942 +03 [1772] LOG:  database system is ready to accept connections
2020-12-16 16:43:07.547 +03 [1845] [unknown]@[unknown] LOG:  incomplete startup packet
2020-12-16 16:43:12.135 +03 [1904] [unknown]@[unknown] LOG:  incomplete startup packet
2020-12-17 17:13:42.251 +03 [1834] PANIC:  could not write to file "pg_logical/replorigin_checkpoint.tmp": No space left on device
2020-12-17 17:13:45.481 +03 [1772] LOG:  checkpointer process (PID 1834) was terminated by signal 6: Aborted
2020-12-17 17:13:45.481 +03 [1772] LOG:  terminating any other active server processes
2020-12-17 17:13:45.515 +03 [1840] LOG:  could not write temporary statistics file "pg_stat/db_16384.tmp": No space left on device
2020-12-17 17:13:45.523 +03 [1840] LOG:  could not write temporary statistics file "pg_stat/db_13018.tmp": No space left on device
2020-12-17 17:13:45.523 +03 [1840] LOG:  could not close temporary statistics file "p

 

 

 

 

 

 

 

1 ACCEPTED SOLUTION

avatar
Super Guru
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login
2 REPLIES 2

avatar
New Contributor

 

df -h
root@hadoop0:~# df -h
Filesystem                         Size  Used Avail Use% Mounted on
udev                               2.9G     0  2.9G   0% /dev
tmpfs                              592M  684K  591M   1% /run
/dev/mapper/ubuntu--vg-ubuntu--lv   29G   26G  2.1G 100% /
tmpfs                              2.9G  8.0K  2.9G   1% /dev/shm
tmpfs                              5.0M     0  5.0M   0% /run/lock
tmpfs                              2.9G     0  2.9G   0% /sys/fs/cgroup
/dev/sda2                          976M  146M  764M  17% /boot
/dev/sda1                          511M  6.1M  505M   2% /boot/efi
overlay                             29G   26G  2.1G  93% /var/lib/docker/overlay2/910138ebc22df100bbc47502f5a49853169038cfe06500f1205c10e3c8c3c590/merged
tmpfs                              592M     0  592M   0% /run/user/0
lvm
lvextend -l +100%FREE /dev/mapper/ubuntu--vg-ubuntu--lv

 

This road worked for me.

Thank you.

avatar
Super Guru
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login