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.4k 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 Do not disturb
        girishG Do not disturb
        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 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
                  • 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