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

[d19dotca]

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"

[murgero]

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

[girish]

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

[girish]

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]

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