Support Questions
Find answers, ask questions, and share your expertise

Ambari with Postgres

Solved Go to solution

Ambari with Postgres

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

Accepted Solutions

Re: Ambari with Postgres

@hakansan 

 

The error is stating your hard drive is full:

    

could not write to file "pg_logical/replorigin_checkpoint.tmp": No space left on device

"no space left on device"

 

The solution you need is to investigate cleaning out some files to free up space, expanding disk, etc.

 

If this answer resolves your issue or allows you to move forward, please choose to ACCEPT this solution and close this topic. If you have further dialogue on this topic please comment here or feel free to private message me. If you have new questions related to your Use Case please create separate topic and feel free to tag me in your post.

 

Thanks,

Steven

View solution in original post

2 REPLIES 2

Re: Ambari with Postgres

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.

Re: Ambari with Postgres

@hakansan 

 

The error is stating your hard drive is full:

    

could not write to file "pg_logical/replorigin_checkpoint.tmp": No space left on device

"no space left on device"

 

The solution you need is to investigate cleaning out some files to free up space, expanding disk, etc.

 

If this answer resolves your issue or allows you to move forward, please choose to ACCEPT this solution and close this topic. If you have further dialogue on this topic please comment here or feel free to private message me. If you have new questions related to your Use Case please create separate topic and feel free to tag me in your post.

 

Thanks,

Steven

View solution in original post