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


Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Search
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
Brand Logo

Cloudron Forum

Apps | Demo | Docs | Install
  1. Cloudron Forum
  2. Support
  3. Postgresql not starting with "Resetting root password" infinite loop

Postgresql not starting with "Resetting root password" infinite loop

Scheduled Pinned Locked Moved Solved Support
postgresql
9 Posts 4 Posters 1.5k Views 4 Watching
  • 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
    • A adrw

      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 Offline
      girishG Offline
      girish
      Staff
      wrote 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
      • girishG girish

        @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 Offline
        A Offline
        adrw
        wrote 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 adrw

          @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 Offline
          A Offline
          adrw
          wrote 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 adrw

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

            A Offline
            A Offline
            adrw
            wrote 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
            • A adrw

              @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 Offline
              nebulonN Offline
              nebulon
              Staff
              wrote 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 Offline
                girishG Offline
                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
                • girishG girish

                  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 Offline
                  robiR Offline
                  robi
                  wrote 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%.

                  Conscious tech

                  1 Reply Last reply
                  0
                  • nebulonN nebulon

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

                    A Offline
                    A Offline
                    adrw
                    wrote 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
                    Reply
                    • Reply as topic
                    Log in to reply
                    • Oldest to Newest
                    • Newest to Oldest
                    • Most Votes


                    • Login

                    • Don't have an account? Register

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