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. Chatwoot
  3. Chatwoot 1.36.1 Upgrade Issue

Chatwoot 1.36.1 Upgrade Issue

Scheduled Pinned Locked Moved Solved Chatwoot
15 Posts 7 Posters 636 Views 7 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.
  • BrutalBirdieB Offline
    BrutalBirdieB Offline
    BrutalBirdie
    Partner
    wrote on last edited by
    #4

    Feb 28 16:21:37 DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.

    Did the app or the Postgres service maybe run out of memory? 🤔 resulting to this issue?

    Like my work? Consider donating a drink. Cheers!

    1 Reply Last reply
    0
    • nebulonN Offline
      nebulonN Offline
      nebulon
      Staff
      wrote on last edited by
      #5

      @cleveradmin can you try to clone the app instance and then perform the update on the cloned one? This way we can see if it is reproducible.

      1 Reply Last reply
      0
      • M Offline
        M Offline
        mazarian
        wrote on last edited by
        #6

        I am having a similar error in my logs, but it's happening well after the upgrade.

        Mar 18 10:06:07 => Healtheck error: Error: Timeout of 7000ms exceeded
Mar 18 10:06:17 => Healtheck error: Error: Timeout of 7000ms exceeded
Mar 18 10:06:23 => Healtheck error: Error: connect EHOSTUNREACH 172.18.19.185:3000
Mar 18 10:06:33 => Healtheck error: Error: connect EHOSTUNREACH 172.18.19.185:3000
Mar 18 10:06:43 => Healtheck error: Error: connect EHOSTUNREACH 172.18.19.185:3000
Mar 18 10:06:53 => Healtheck error: Error: connect EHOSTUNREACH 172.18.19.185:3000
Mar 18 10:06:54 => Sourcing /app/data/env.sh
Mar 18 10:06:54 => Starting chatwoot
Mar 18 10:06:54 => Upgrading existing db
Mar 18 10:06:56 I, [2025-03-18T17:06:56.956461 #10] INFO -- : [rake ip_lookup:setup] IP_LOOKUP_API_KEY empty. Skipping geoip database setup
Mar 18 10:06:57 2025-03-18T17:06:57Z
Mar 18 10:06:57 (See full trace by running task with --trace)
Mar 18 10:06:57 /app/code/db/schema.rb:134:in `block in <main>'
Mar 18 10:06:57 /app/code/db/schema.rb:134:in `block in <main>'
Mar 18 10:06:57 /app/code/db/schema.rb:13:in `<main>'
Mar 18 10:06:57 /app/code/db/schema.rb:13:in `<main>'
Mar 18 10:06:57 /app/code/lib/tasks/db_enhancements.rake:18:in `block (2 levels) in <main>'
Mar 18 10:06:57 /app/code/lib/tasks/db_enhancements.rake:18:in `block (2 levels) in <main>'
Mar 18 10:06:57 /app/code/lib/tasks/db_enhancements.rake:18:in `each'
Mar 18 10:06:57 /app/code/lib/tasks/db_enhancements.rake:18:in `each'
Mar 18 10:06:57 /app/code/lib/tasks/db_enhancements.rake:22:in `block (3 levels) in <main>'
Mar 18 10:06:57 /app/code/lib/tasks/db_enhancements.rake:22:in `block (3 levels) in <main>'
Mar 18 10:06:57 ActiveRecord::StatementInvalid: PG::ConnectionBad: PQconsumeInput() server closed the connection unexpectedly (ActiveRecord::StatementInvalid)
Mar 18 10:06:57 Caused by:
Mar 18 10:06:57 PG::ConnectionBad: PQconsumeInput() server closed the connection unexpectedly (PG::ConnectionBad)
Mar 18 10:06:57 Tasks: TOP => db:chatwoot_prepare
Mar 18 10:06:57 This probably means the server terminated abnormally
Mar 18 10:06:57 This probably means the server terminated abnormally
Mar 18 10:06:57 before or while processing the request.
Mar 18 10:06:57 before or while processing the request.
Mar 18 10:06:57 rails aborted!
Mar 18 10:07:07 => Healtheck error: Error: Timeout of 7000ms exceeded
Mar 18 10:07:17 => Healtheck error: Error: Timeout of 7000ms exceeded
Mar 18 10:07:26 => Healtheck error: Error: connect EHOSTUNREACH 172.18.19.185:3000
Mar 18 10:07:33 => Healtheck error: Error: connect EHOSTUNREACH 172.18.19.185:3000
Mar 18 10:07:43 => Healtheck error: Error: connect EHOSTUNREACH 172.18.19.185:3000
Mar 18 10:07:43 BoxError: Unknown install command in apptask:error
Mar 18 10:07:43 BoxError: Unknown install command in apptask:error
Mar 18 10:07:53 => Healtheck error: Error: connect EHOSTUNREACH 172.18.19.185:3000
Mar 18 10:07:57 => Starting chatwoot
Mar 18 10:07:57 => Sourcing /app/data/env.sh
Mar 18 10:07:57 => Upgrading existing db
Mar 18 10:08:00 => Healtheck error: Error: connect ECONNREFUSED 172.18.19.185:3000
Mar 18 10:08:00 I, [2025-03-18T17:08:00.416259 #10] INFO -- : [rake ip_lookup:setup] IP_LOOKUP_API_KEY empty. Skipping geoip database setup
Mar 18 10:08:00 rails aborted!
Mar 18 10:08:00 ActiveRecord::StatementInvalid: PG::ConnectionBad: PQconsumeInput() server closed the connection unexpectedly (ActiveRecord::StatementInvalid)
Mar 18 10:08:00 This probably means the server terminated abnormally
Mar 18 10:08:00 before or while processing the request.
Mar 18 10:08:00 /app/code/db/schema.rb:134:in `block in <main>'
Mar 18 10:08:00 /app/code/db/schema.rb:13:in `<main>'
Mar 18 10:08:00 /app/code/lib/tasks/db_enhancements.rake:22:in `block (3 levels) in <main>'
Mar 18 10:08:00 /app/code/lib/tasks/db_enhancements.rake:18:in `each'
Mar 18 10:08:00 /app/code/lib/tasks/db_enhancements.rake:18:in `block (2 levels) in <main>'
Mar 18 10:08:00 2025-03-18T17:08:00Z
Mar 18 10:08:00 Caused by:
Mar 18 10:08:00 PG::ConnectionBad: PQconsumeInput() server closed the connection unexpectedly (PG::ConnectionBad)
Mar 18 10:08:00 This probably means the server terminated abnormally
Mar 18 10:08:00 before or while processing the request.
Mar 18 10:08:00 /app/code/db/schema.rb:134:in `block in <main>'
Mar 18 10:08:00 /app/code/db/schema.rb:13:in `<main>'
Mar 18 10:08:00 /app/code/lib/tasks/db_enhancements.rake:22:in `block (3 levels) in <main>'
Mar 18 10:08:00 /app/code/lib/tasks/db_enhancements.rake:18:in `each'
Mar 18 10:08:00 /app/code/lib/tasks/db_enhancements.rake:18:in `block (2 levels) in <main>'
Mar 18 10:08:00 Tasks: TOP => db:chatwoot_prepare
Mar 18 10:08:00 (See full trace by running task with --trace)
Mar 18 10:08:17 => Healtheck error: Error: Timeout of 7000ms exceeded
Mar 18 10:08:27 => Healtheck error: Error: Timeout of 7000ms exceeded
Mar 18 10:08:33 => Healtheck error: Error: connect EHOSTUNREACH 172.18.19.185:3000
Mar 18 10:08:43 => Healtheck error: Error: connect EHOSTUNREACH 172.18.19.185:3000
Mar 18 10:08:53 => Healtheck error: Error: connect EHOSTUNREACH 172.18.19.185:3000
Mar 18 10:09:01 => Starting chatwoot
Mar 18 10:09:01 => Sourcing /app/data/env.sh
Mar 18 10:09:01 => Upgrading existing db
Mar 18 10:09:03 => Healtheck error: Error: connect ECONNREFUSED 172.18.19.185:3000
Mar 18 10:09:03 I, [2025-03-18T17:09:03.629615 #10] INFO -- : [rake ip_lookup:setup] IP_LOOKUP_API_KEY empty. Skipping geoip database setup
Mar 18 10:09:04 rails aborted!
Mar 18 10:09:04 ActiveRecord::StatementInvalid: PG::ConnectionBad: PQconsumeInput() server closed the connection unexpectedly (ActiveRecord::StatementInvalid)
Mar 18 10:09:04 This probably means the server terminated abnormally
Mar 18 10:09:04 before or while processing the request.
Mar 18 10:09:04 /app/code/db/schema.rb:134:in `block in <main>'
Mar 18 10:09:04 /app/code/db/schema.rb:13:in `<main>'
Mar 18 10:09:04 /app/code/lib/tasks/db_enhancements.rake:22:in `block (3 levels) in <main>'
Mar 18 10:09:04 /app/code/lib/tasks/db_enhancements.rake:18:in `each'
Mar 18 10:09:04 /app/code/lib/tasks/db_enhancements.rake:18:in `block (2 levels) in <main>'
Mar 18 10:09:04 2025-03-18T17:09:04Z
Mar 18 10:09:04 Caused by:
Mar 18 10:09:04 PG::ConnectionBad: PQconsumeInput() server closed the connection unexpectedly (PG::ConnectionBad)
Mar 18 10:09:04 This probably means the server terminated abnormally
Mar 18 10:09:04 before or while processing the request.
Mar 18 10:09:04 /app/code/db/schema.rb:134:in `block in <main>'
Mar 18 10:09:04 /app/code/db/schema.rb:13:in `<main>'
Mar 18 10:09:04 /app/code/lib/tasks/db_enhancements.rake:22:in `block (3 levels) in <main>'
Mar 18 10:09:04 /app/code/lib/tasks/db_enhancements.rake:18:in `each'
Mar 18 10:09:04 /app/code/lib/tasks/db_enhancements.rake:18:in `block (2 levels) in <main>'
Mar 18 10:09:04 Tasks: TOP => db:chatwoot_prepare
Mar 18 10:09:04 (See full trace by running task with --trace)
Mar 18 10:09:17 => Healtheck error: Error: Timeout of 7000ms exceeded
Mar 18 10:09:27 => Healtheck error: Error: Timeout of 7000ms exceeded
Mar 18 10:09:33 => Healtheck error: Error: connect EHOSTUNREACH 172.18.19.185:3000
Mar 18 10:09:43 => Healtheck error: Error: connect EHOSTUNREACH 172.18.19.185:3000
Mar 18 10:09:53 => Healtheck error: Error: connect EHOSTUNREACH 172.18.19.185:3000
Mar 18 10:10:03 => Healtheck error: Error: connect EHOSTUNREACH 172.18.19.185:3000

        I tried recovering from backup and cloning and am getting the following error:

        An error occurred during the clone operation: Addons Error: Unexpected response code or HTTP error when piping /home/yellowtent/appsdata/e2f314e0-389e-4c1b-8e80-9852e13db8e3/postgresqldump to http://172.18.30.2:3000/databases/dbe2f314e0389e4c1b8e809852e13db8e3/restore?access_token=b637659aed0a708f188d2902fc267163718b8c6777cd722433926b0654ff03c7c2fc782f7c39a559f0d1954f031c7215eb96ebf6bc759500e2419d84607396d249c157dc7a7db537926351f20ae6a23261db0a55c93e07a278161db6c2e7f4fdd04756ff7cc1cd30bd67096101d9b83b643ebf91abf5f2e3a2026dbd93d1ae6b&username=usere2f314e0389e4c1b8e809852e13db8e3: status 500 complete false

        Any help would greatly be appreciated!

        1 Reply Last reply
        0
        • nebulonN Offline
          nebulonN Offline
          nebulon
          Staff
          wrote on last edited by
          #7

          Is your postgres service up and running? Since it returned a 500 status code during database import, it should have error messages in its logs.

          1 Reply Last reply
          0
          • M Offline
            M Offline
            mazarian
            wrote on last edited by
            #8

            I'm not quite sure how to check - I am only able to get into recovery mode and when going into the terminal and pressing the Postgres button, I see this:

            root@fa89594f-7176-4a81-9c25-1686af1e50da:/app/code# PGPASSWORD=${CLOUDRON_POSTGRESQL_PASSWORD} psql -h ${CLOUDRON_POSTGRESQL_HOST} -p ${CLOUDRON_POSTGRESQL_PORT} -U ${CLOUDRON_POSTGRESQL_USERNAME} -d ${CLOUDRON_POSTGRESQL_DATABASE} 
psql (14.9 (Ubuntu 14.9-0ubuntu0.22.04.1), server 16.6 (Ubuntu 16.6-0ubuntu0.24.04.1))
WARNING: psql major version 14, server major version 16.
         Some psql features might not work.
Type "help" for help.

dbfa89594f71764a819c251686af1e50da=>
            andreasduerenA 1 Reply Last reply
            0
            • M mazarian

              I'm not quite sure how to check - I am only able to get into recovery mode and when going into the terminal and pressing the Postgres button, I see this:

              root@fa89594f-7176-4a81-9c25-1686af1e50da:/app/code# PGPASSWORD=${CLOUDRON_POSTGRESQL_PASSWORD} psql -h ${CLOUDRON_POSTGRESQL_HOST} -p ${CLOUDRON_POSTGRESQL_PORT} -U ${CLOUDRON_POSTGRESQL_USERNAME} -d ${CLOUDRON_POSTGRESQL_DATABASE} 
psql (14.9 (Ubuntu 14.9-0ubuntu0.22.04.1), server 16.6 (Ubuntu 16.6-0ubuntu0.24.04.1))
WARNING: psql major version 14, server major version 16.
         Some psql features might not work.
Type "help" for help.

dbfa89594f71764a819c251686af1e50da=>
              andreasduerenA Offline
              andreasduerenA Offline
              andreasdueren
              wrote on last edited by
              #9

              @mazarian Go to https://my.tld.com/#/services and increase memory if necessary and/or reboot that service

              M 1 Reply Last reply
              0
              • andreasduerenA andreasdueren

                @mazarian Go to https://my.tld.com/#/services and increase memory if necessary and/or reboot that service

                M Offline
                M Offline
                mazarian
                wrote on last edited by
                #10

                @andreasdueren and @nebulon thank you both for your replies!

                I just looked at my services, and things looked ok. Graphite was at 84% and I doubled the memory. I also doubled my Postgres memory and Redis memory (for the affected Chatwoot app) but none of those things seemed to help.

                cefff62e-2183-4385-97eb-fa7a62bb8e65-image.png

                1 Reply Last reply
                0
                • M Offline
                  M Offline
                  mazarian
                  wrote on last edited by
                  #11

                  It's also odd- when I try switching between recovery mode off and on, Redis throws errors and I have to restart the service. But doing so doesn't allow me to start the application outside of recovery mode and still in the error logs, I see the same PG errors.

                  1 Reply Last reply
                  0
                  • M Offline
                    M Offline
                    mazarian
                    wrote on last edited by
                    #12

                    Just wanted to add - it seems like I am having to restore from backup for many of my apps. All of the restores are working except for Chatwoot. It seems like something went wrong after the upgrade to Cloudron 8.3.

                    S 1 Reply Last reply
                    1
                    • J Offline
                      J Offline
                      joseph
                      Staff
                      wrote on last edited by
                      #13

                      @mazarian if you can write to support@cloudron.io, we can take a look . it seems a few hit this issue with restoring chatwoot on the recent postgres. however, we haven't been to reproduce it.

                      1 Reply Last reply
                      0
                      • M mazarian

                        Just wanted to add - it seems like I am having to restore from backup for many of my apps. All of the restores are working except for Chatwoot. It seems like something went wrong after the upgrade to Cloudron 8.3.

                        S Offline
                        S Offline
                        stevespaw
                        wrote on last edited by
                        #14

                        @mazarian said in Chatwoot 1.36.1 Upgrade Issue:

                        Just wanted to add - it seems like I am having to restore from backup for many of my apps. All of the restores are working except for Chatwoot. It seems like something went wrong after the upgrade to Cloudron 8.3.

                        Same issue here!

                        1 Reply Last reply
                        0
                        • S Offline
                          S Offline
                          stevespaw
                          wrote on last edited by
                          #15

                          8.3.1 seems to have fixed this issue! Thanks team Cloudron!

                          1 Reply Last reply
                          0
                          • nebulonN nebulon marked this topic as a question on
                          • nebulonN nebulon has marked this topic as solved on
                          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