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


    Cloudron Forum

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular

    Solved Mastodon 3.0.1 works, but moment it updates to 3.1.2 I just see 500 HTTP status codes when loading feed.

    Mastodon
    mastodon
    3
    5
    164
    Loading More Posts
    • 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.
    • d19dotca
      d19dotca last edited by girish

      Hello,

      Is anyone else having issues with Mastodon after the latest update? I just updated and see 500 HTTP status errors in the application, but I don't see much in the way of these 500 HTTP status code errors in the logs for some reason. I do see a few though, I just can't figure out what it's really implying yet. The pages still load but not the feed, seems all the user-generated content is not being served. Any ideas? For now I've restored to 3.0.1 where it works successfully.

      Mar 08 07:25:35 172.18.0.1 - - [08/Mar/2020:07:25:35 +0000] "GET /api/v1/notifications?exclude_types[]=follow_request HTTP/1.1" 500 846 "https://<subdomain>.<domain.tld>/web/timelines/home" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_4) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.1 Safari/605.1.15"
      Mar 08 07:25:35 verb 6a3b702b-1b98-440c-8a3d-4a1f52a64669 Starting stream from timeline:1 for 1
      Mar 08 07:25:35 verb Subscribe timeline:1
      Mar 08 07:25:35 [b6deaa45-cc63-498d-8073-96bf0d1b9a62] method=GET path=/api/v1/timelines/home format=html controller=Api::V1::Timelines::HomeController action=show status=500 error='ActiveRecord::StatementInvalid: PG::UndefinedTable: ERROR: relation "bookmarks" does not exist
      Mar 08 07:25:35 LINE 8: WHERE a.attrelid = '"bookmarks"'::regclass
      Mar 08 07:25:35 ^
      Mar 08 07:25:35 : SELECT a.attname, format_type(a.atttypid, a.atttypmod),
      Mar 08 07:25:35 pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod,
      Mar 08 07:25:35 c.collname, col_description(a.attrelid, a.attnum) AS comment
      Mar 08 07:25:35 FROM pg_attribute a
      Mar 08 07:25:35 LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum
      Mar 08 07:25:35 LEFT JOIN pg_type t ON a.atttypid = t.oid
      Mar 08 07:25:35 LEFT JOIN pg_collation c ON a.attcollation = c.oid AND a.attcollation <> t.typcollation
      Mar 08 07:25:35 WHERE a.attrelid = '"bookmarks"'::regclass
      Mar 08 07:25:35 AND a.attnum > 0 AND NOT a.attisdropped
      Mar 08 07:25:35 ORDER BY a.attnum
      Mar 08 07:25:35 ' duration=338.17 view=0.00 db=79.19
      Mar 08 07:25:35 [b6deaa45-cc63-498d-8073-96bf0d1b9a62]
      Mar 08 07:25:35 [b6deaa45-cc63-498d-8073-96bf0d1b9a62] ActiveRecord::StatementInvalid (PG::UndefinedTable: ERROR: relation "bookmarks" does not exist
      Mar 08 07:25:35 LINE 8: WHERE a.attrelid = '"bookmarks"'::regclass
      Mar 08 07:25:35 ^
      Mar 08 07:25:35 : SELECT a.attname, format_type(a.atttypid, a.atttypmod),
      Mar 08 07:25:35 pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod,
      Mar 08 07:25:35 c.collname, col_description(a.attrelid, a.attnum) AS comment
      Mar 08 07:25:35 FROM pg_attribute a
      Mar 08 07:25:35 LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum
      Mar 08 07:25:35 LEFT JOIN pg_type t ON a.atttypid = t.oid
      Mar 08 07:25:35 LEFT JOIN pg_collation c ON a.attcollation = c.oid AND a.attcollation <> t.typcollation
      Mar 08 07:25:35 WHERE a.attrelid = '"bookmarks"'::regclass
      Mar 08 07:25:35 AND a.attnum > 0 AND NOT a.attisdropped
      Mar 08 07:25:35 ORDER BY a.attnum
      Mar 08 07:25:35 ):
      Mar 08 07:25:35 [b6deaa45-cc63-498d-8073-96bf0d1b9a62]
      Mar 08 07:25:35 [b6deaa45-cc63-498d-8073-96bf0d1b9a62] app/models/status.rb:312:in `bookmarks_map'
      Mar 08 07:25:35 [b6deaa45-cc63-498d-8073-96bf0d1b9a62] app/presenters/status_relationships_presenter.rb:22:in `initialize'
      Mar 08 07:25:35 [b6deaa45-cc63-498d-8073-96bf0d1b9a62] app/controllers/api/v1/timelines/home_controller.rb:15:in `new'
      Mar 08 07:25:35 [b6deaa45-cc63-498d-8073-96bf0d1b9a62] app/controllers/api/v1/timelines/home_controller.rb:15:in `show'
      Mar 08 07:25:35 172.18.0.1 - - [08/Mar/2020:07:25:35 +0000] "GET /api/v1/timelines/home HTTP/1.1" 500 846 "https://<subdomain>.<domain.tld>/web/timelines/home" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_4) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.1 Safari/605.1.15"
      Mar 08 07:25:35 [ce9271cc-f0a4-4af8-8354-fed3bbfcdd04] method=GET path=/api/v1/filters format=html controller=Api::V1::FiltersController action=index status=200 duration=11.59 view=2.06 db=3.30
      Mar 08 07:25:35 172.18.0.1 - - [08/Mar/2020:07:25:35 +0000] "GET /api/v1/filters HTTP/1.1" 200 39 "https://<subdomain>.<domain.tld>/web/timelines/home" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_4) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.1 Safari/605.1.15"
      Mar 08 07:25:35 172.18.0.1 - - [08/Mar/2020:07:25:35 +0000] "GET /sw.js HTTP/1.1" 200 29244 "https://<subdomain>.<domain.tld>/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_4) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.1 Safari/605.1.15"
      

      --
      Dustin Dauncey
      www.d19.ca

      murgero 1 Reply Last reply Reply Quote 0
      • murgero
        murgero App Dev @d19dotca last edited by

        @d19dotca said in Mastodon 3.0.1 works, but moment it updates to 3.1.2 I just see 500 HTTP status codes when loading feed.:

        ActiveRecord::StatementInvalid (PG::UndefinedTable: ERROR: relation "bookmarks" does not exist
        Mar 08 07:25:35 LINE 8: WHERE a.attrelid = '"bookmarks"'::regclass

        This actually looks like an issue on Mastodon's end, is there anything in their github to suggest other users are having issues as well?

        --
        https://urgero.org
        ~ Professional Nerd. Freelance Programmer. ~
        Matrix: @murgero:urgero.org

        1 Reply Last reply Reply Quote 0
        • girish
          girish Staff last edited by

          Looks like https://github.com/tootsuite/mastodon/issues/13219 . I have revoked the release for now.

          1 Reply Last reply Reply Quote 0
          • girish
            girish Staff last edited by

            It turns out the Cloudron package didn't run the migration script. I have fixed that up and pushed an update. @d19dotca Can you update and tell me if it works now?

            d19dotca 1 Reply Last reply Reply Quote 3
            • d19dotca
              d19dotca @girish last edited by

              @girish Yes, that did the trick - thank you so much! The package version 1.1.1 works for upgrading to Mastodon 3.1.2. Thank you for resolving that so quickly.

              --
              Dustin Dauncey
              www.d19.ca

              1 Reply Last reply Reply Quote 1
              • First post
                Last post
              Powered by NodeBB