Re: [I] [Bug] Assert failure in GIN index due to MaxHeapTuplesPerPageBits modification [cloudberry]

["avamingli (via GitHub)" <gi...@apache.org>]

avamingli commented on issue #1222:
URL: https://github.com/apache/cloudberry/issues/1222#issuecomment-3149847855

   > Hi, [@assam258-5892](https://github.com/assam258-5892)
   > 
   > Thank you for your report! Your analysis is excellent!
   > 
   > > It's difficult to make a case because the data is inside the corporate security net.
   > 
   > According to the source codes, I was able to construct a successful reproduction of the issue:
   > 
   > create table t_issue_1222(i int4[]) with (appendonly=true);
   > create index t_issue_1222_idx on t_issue_1222 using gin (i)
   >   with (fastupdate = on, gin_pending_list_limit = 4096);
   > insert into t_issue_1222 select array[1, 2, g] from generate_series(1, 400000) g;
   > 
   > CREATE TABLE
   > CREATE INDEX
   > ERROR:  Unexpected internal error (assert.c:48)  (seg1 127.0.1.1:9903 pid=3489454) (assert.c:48)
   > DETAIL:  FailedAssertion("OffsetNumberIsValid(ItemPointerGetOffsetNumber(&segment->first))", File: "ginpostinglist.c", Line: 338)
   > I have a quick fix and a little more at [#1223](https://github.com/apache/cloudberry/pull/1223)
   > 
   > If you'd like to improve it later, feel free to do so!
   
   Done. I added a FIXME comment in that PR.
   
   @assam258-5892 If you suspect similar issues in other index types, feel free to:
   Submit a fix following the same approach, or open a new issue with reproduction steps(we need that case in regression test).
   Your contributions are greatly appreciated! I’ll now close this issue as resolved.
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@cloudberry.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cloudberry.apache.org
For additional commands, e-mail: commits-help@cloudberry.apache.org