Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse

Cloudron Forum

Apps | Demo | Docs | Install

Postgresql not starting with "Resetting root password" infinite loop

Scheduled Pinned Locked Moved Solved Support
postgresql
9 Posts 4 Posters 330 Views
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • A Offline
    A Offline
    adrw
    wrote on last edited by girish
    #1

    My Postgresql seems to have an infinite loop and won't start, any ideas?

    2022-01-24T20:21:05.000Z Resetting root password
    2022-01-24T20:22:43.000Z Detected existing installation
    2022-01-24T20:22:43.000Z Resetting root password
    2022-01-24T20:24:22.000Z Detected existing installation
    2022-01-24T20:24:22.000Z Resetting root password
    2022-01-24T20:26:03.000Z Detected existing installation
    
    girishG 1 Reply Last reply
    0
  • girishG Do not disturb
    girishG Do not disturb
    girish Staff
    replied to adrw on last edited by
    #2

    @adrw It seems postgres is not starting up. Do you have enough disk space? If you do docker restart postgresql , it should show any startup errors in the logs.

    A 1 Reply Last reply
    0
  • A Offline
    A Offline
    adrw
    replied to girish on last edited by
    #3

    @girish thanks! disk space was fine but it seems like the memory was underprovisioned, I increased from default to 2GB and it started booting again, 1GB seemingly wasn't enough.

    A 1 Reply Last reply
    0
  • A Offline
    A Offline
    adrw
    replied to adrw on last edited by
    #4

    @girish I'm seeing this failure again, the disk usage in System tab shows 250GB free

    A 1 Reply Last reply
    0
  • A Offline
    A Offline
    adrw
    replied to adrw on last edited by
    #5

    @adrw It seem to again have required more memory, wondering if there'd be a way to add that to the logs or detect that reset root password loop to suggest increasing memory. I also encountered it with the SFTP service.

    nebulonN 1 Reply Last reply
    0
  • nebulonN Online
    nebulonN Online
    nebulon Staff
    replied to adrw on last edited by
    #6

    @adrw did you get notifications about postgres running out of memory in your dashboard? Also the starting worked now after increasing the limit?

    A 1 Reply Last reply
    0
  • girishG Do not disturb
    girishG Do not disturb
    girish Staff
    wrote on last edited by
    #7

    Also, if there are no OOM messages in the notifications, can you also please check if dmesg output on the server has some OOM errors? Maybe we are not detecting OOM correctly.

    robiR 1 Reply Last reply
    1
  • robiR Offline
    robiR Offline
    robi
    replied to girish on last edited by
    #8

    @girish There are at least two ways I can think of to get a warning that the container is running out of memory limit and is about to be OOM killed.

    1. use --memory-reservation in containers set at 90% of --memory (limit) setting.

    2. track high watermarks for app usage in kernel or graph data and raise warnings of imminent OOM kill possibility.

    Perhaps add another graph somewhere where these are plotted visually and one can quick click to see which and bump up the memory config by 20%.

    Life of sky tech

    1 Reply Last reply
    0
  • A Offline
    A Offline
    adrw
    replied to nebulon on last edited by
    #9

    @nebulon I didn't get any notifications in the dashboard for OOM which is why debugging was fairly unintuitive.

    @girish If I encounter it again, I'll check dmesg and let you know.

    1 Reply Last reply
    0

  • Login

  • Don't have an account? Register

  • Login or register to search.
  • First post
    Last post
0
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Login

  • Don't have an account? Register

  • Login or register to search.