当从Spring-Boot应用程序向我的一个表（具有多个索引）插入新行时，我有时会得到：
ERROR: table tid from new index tuple (952367,9) overlaps with invalid duplicate tuple at offset 12 of block 49008 in index "foo_index"
ERROR: table tid from new index tuple (952110,19) overlaps with invalid duplicate tuple at offset 22 of block 31693 in index "bar_index"
ERROR: table tid from new index tuple (953430,24) overlaps with invalid duplicate tuple at offset 22 of block 31693 in index "bar_index"
ERROR: table tid from new index tuple (953440,39) overlaps with invalid duplicate tuple at offset 23 of block 31693 in index "bar_index"
ERROR: table tid from new index tuple (952368,27) overlaps with invalid duplicate tuple at offset 76 of block 55849 in index "foo_index"
ERROR: table tid from new index tuple (952368,32) overlaps with invalid duplicate tuple at offset 76 of block 55849 in index "foo_index"
ERROR: table tid from new index tuple (953046,13) overlaps with invalid duplicate tuple at offset 12 of block 49008 in index "foo_index"所有这些都遵循警告SQL Error: 0, SQLState: XX002，根据PostgreSQL docs，这意味着index_corrupted。
服务器版本为Ubuntu 13.9-1.pgdg22.04+1。
我能做些什么来修复它？
1条答案
按热度按时间mklgxw1f1#
运行
REINDEX (VERBOSE) TABLE CONCURRENTLY my_table;。花了~30分钟。（该表有大约3000万行。）到目前为止，错误没有再次出现。