Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit9072835

Browse files
committed
Remove WARNING message from brin_desummarize_range
This message was being emitted on the grounds that only crashedsummarization could cause it, but in reality even an aborted vacuumcould do it ... which makes it way too noisy, particularly since itshows up in regression tests and makes them die.Reported by Tom Lane.Discussion:https://postgr.es/m/489091.1593534251@sss.pgh.pa.us
1 parent89162b7 commit9072835

File tree

1 file changed

+8
-15
lines changed

1 file changed

+8
-15
lines changed

‎src/backend/access/brin/brin_revmap.c

Lines changed: 8 additions & 15 deletions
Original file line numberDiff line numberDiff line change
@@ -333,7 +333,6 @@ brinRevmapDesummarizeRange(Relation idxrel, BlockNumber heapBlk)
333333
OffsetNumberrevmapOffset;
334334
OffsetNumberregOffset;
335335
ItemIdlp;
336-
BrinTuple*tup;
337336

338337
revmap=brinRevmapInitialize(idxrel,&pagesPerRange,NULL);
339338

@@ -365,6 +364,10 @@ brinRevmapDesummarizeRange(Relation idxrel, BlockNumber heapBlk)
365364
regBuf=ReadBuffer(idxrel,ItemPointerGetBlockNumber(iptr));
366365
LockBuffer(regBuf,BUFFER_LOCK_EXCLUSIVE);
367366
regPg=BufferGetPage(regBuf);
367+
/*
368+
* We're only removing data, not reading it, so there's no need to
369+
* TestForOldSnapshot here.
370+
*/
368371

369372
/* if this is no longer a regular page, tell caller to start over */
370373
if (!BRIN_IS_REGULAR_PAGE(regPg))
@@ -386,23 +389,13 @@ brinRevmapDesummarizeRange(Relation idxrel, BlockNumber heapBlk)
386389
ereport(ERROR,
387390
(errcode(ERRCODE_INDEX_CORRUPTED),
388391
errmsg("corrupted BRIN index: inconsistent range map")));
389-
tup= (BrinTuple*)PageGetItem(regPg,lp);
390-
/* XXX apply sanity checks? Might as well delete a bogus tuple ... */
391-
392-
/*
393-
* We're only removing data, not reading it, so there's no need to
394-
* TestForOldSnapshot here.
395-
*/
396392

397393
/*
398-
* Because of SUE lock, this function shouldn't run concurrently with
399-
* summarization. Placeholder tuples can only exist as leftovers from
400-
* crashed summarization, so if we detect any, we complain but proceed.
394+
* Placeholder tuples only appear during unfinished summarization, and we
395+
* hold ShareUpdateExclusiveLock, so this function cannot run concurrently
396+
* with that. So any placeholder tuples that exist are leftovers from a
397+
* crashed or aborted summarization; remove them silently.
401398
*/
402-
if (BrinTupleIsPlaceholder(tup))
403-
ereport(WARNING,
404-
(errmsg("leftover placeholder tuple detected in BRIN index \"%s\", deleting",
405-
RelationGetRelationName(idxrel))));
406399

407400
START_CRIT_SECTION();
408401

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp