-
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?
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login