-
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 -
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"@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"'::regclassThis actually looks like an issue on Mastodon's end, is there anything in their github to suggest other users are having issues as well?
-
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?
