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


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



  • 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"
    

  • App Dev

    @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?


  • Staff

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


  • Staff

    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?



  • @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.


Log in to reply