Re: an error message that I don't understand

On Fri, May 2, 2025 at 1:25 PM Martin Mueller < martinmuel...@northwestern.edu> wrote: > > table tid from new index tuple (32586,21) overlaps with invalid duplicate > tuple at offset 120 of block 4398 in index "aacorrections_tcpreading_idx" > Read that as "your index is corrupted". > I have no

an error message that I don't understand

I get this error message: table tid from new index tuple (32586,21) overlaps with invalid duplicate tuple at offset 120 of block 4398 in index "aacorrections_tcpreading_idx" from an update query of the update table 1 set columnx = ‘yes’ where table1.xmlid in (select xmlid from table2) I have no

RE: Unlogged partitionned tables and hot standbys

Hi, Old mail but I see the issue is corrected in PostgreSQL 18 devel, many thanks. Best regards, Phil De : Phil Florent Envoyé : jeudi 21 décembre 2023 17:00 À : pgsql-gene...@postgresql.org Objet : Unlogged partitionned tables and hot standbys Hi, Today I co

checkpoint_timeout parameter & WAL archive delay, pgbackrest fails

Hi folks, My pgbackrest backup on one of my RepoServer fails. The backup fails some times with the error WAL file cannot be archived before 6 ms timeout. The pgbackrest stanza check command is sometimes successful, but sometimes fails. I don't know whyPG is unable to copy WAL fi