I am trying to rebuild one (forum.techandtiny.com) of three Discourse instances that I run on my server. The crazy part is the plugins used are identical to the two other instances (forum.tabletpc.review and forum.farfarawaynews.com) that I run on my server. However, in updating all three instances today, only this one fails to spin up after rebuilding. Attached is the terminal output.
It looks like it could be some kind of conflict in your
vote_history that’s throwing it off
discourse@discourse STATEMENT: INSERT INTO question_answer_votes (post_id, user_id, created_at) SELECT X.post_id AS post_id, (X.value->>'user_id')::int AS user_id, (X.value->>'created_at')::timestamp AS created_at FROM ( SELECT post_id, jsonb_array_elements(value::jsonb) AS value FROM post_custom_fields WHERE name = 'vote_history' ) AS X WHERE (X.value->>'action') != 'destroy' ORDER BY (X.value->>'created_at')::timestamp DESC ON CONFLICT DO NOTHING rake aborted! StandardError: An error has occurred, this and all later migrations canceled: