移动帖子因约束导致 500 错误

贡献 错误
1

你好，

一个话题开始偏离主题，所以我将其拆分到了新话题中。不幸的是，它现在又回到了主题上，于是我尝试将相关帖子移回原话题。但我遇到了 500 错误。

似乎有一个约束条件失败了：

2019-09-21 14:39:48.805 UTC [26689] discourse@discourse ERROR:  duplicate key value violates unique constraint "post_timings_unique"`
`2019-09-21 14:39:48.805 UTC [26689] discourse@discourse DETAIL:  Key (topic_id, post_number, user_id)=(9957, 79, 1) already exists.`
`2019-09-21 14:39:48.805 UTC [26689] discourse@discourse STATEMENT:  UPDATE post_timings pt
        SET topic_id    = mp.new_topic_id,
            post_number = mp.new_post_number
        FROM moved_posts mp
        WHERE pt.topic_id = mp.old_topic_id
          AND pt.post_number = mp.old_post_number
          AND mp.old_post_id = mp.new_post_id`
        
`2019-09-21 14:39:48.806 UTC [26689] discourse@discourse ERROR:  current transaction is aborted, commands ignored until end of transaction block`
`2019-09-21 14:39:48.806 UTC [26689] discourse@discourse STATEMENT:  DROP TABLE IF EXISTS moved_posts
2

这里有明确的复现步骤吗？你能在新主题上重现这个问题吗？

2 个赞
3

我相当确定这个问题已在 FIX: Existing post timings could prevent moving posts · discourse/discourse@bee000b · GitHub 中修复。
@nmcgovern 如果您仍能复现该问题，请标记以重新打开。

6 个赞