Hi! From time to time I observe $subj on clusters using logical replication. I most of cases there are a lot of other errors. Probably $subj condition should be kind of impossible without other problems. I propose to enhance error logging of XLogReadRecord() in ReadPageInternal(). Thank you! Best regards, Andrey Borodin.
Hello. I saw this error multiple times trying to replicate the 2-3 TB server (version 11 to version 12). I was unable to find any explanation for this error. Thanks, Michail.
On 2021-Jul-23, Andrey Borodin wrote: > Hi! > > From time to time I observe $subj on clusters using logical replication. > I most of cases there are a lot of other errors. Probably $subj condition should be kind of impossible without other problems. > I propose to enhance error logging of XLogReadRecord() in ReadPageInternal(). Hmm. A small problem in this patch is that XLogReaderValidatePageHeader already sets errormsg_buf; you're overwriting that. I suggest to leave that untouched. There are other two cases where the problem occurs in page_read() callback; ReadPageInternal explicitly documents that it doesn't set the error in that case. We have two options to deal with that: 1. change all existing callbacks to set the errormsg_buf depending on what actually fails, and then if they return failure without an error message, add something like your proposed message. 2. throw error directly in the callback rather than returning. I don't think this strategy actually works I attach a cut-down patch that doesn't deal with the page_read callbacks issue, just added stub comments in xlog.c where something should be done. -- Álvaro Herrera 39°49'30"S 73°17'W — https://www.EnterpriseDB.com/ "I am amazed at [the pgsql-sql] mailing list for the wonderful support, and lack of hesitasion in answering a lost soul's question, I just wished the rest of the mailing list could be like this." (Fotis) (http://archives.postgresql.org/pgsql-sql/2006-06/msg00265.php)
Сайт использует файлы cookie для корректной работы и повышения удобства. Нажимая кнопку «Принять» или продолжая пользоваться сайтом, вы соглашаетесь на их использование в соответствии с Политикой в отношении обработки cookie ООО «ППГ», в том числе на передачу данных из файлов cookie сторонним статистическим и рекламным службам. Вы можете управлять настройками cookie через параметры вашего браузера