On Wed, Aug 05, 2020 at 09:53:44AM +0900, Amit Langote wrote:
> On Wed, Aug 5, 2020 at 9:52 AM Amit Langote <[email protected]> wrote:
> > On Wed, Aug 5, 2020 at 9:32 AM Justin Pryzby <[email protected]> wrote:
> > > On Wed, Aug 05, 2020 at 09:26:20AM +0900, Amit Langote wrote:
> > > > On Wed, Aug 5, 2020 at 12:11 AM Justin Pryzby <[email protected]>
> > > > wrote:
> > > > >
> > > > > On Tue, Aug 04, 2020 at 08:12:10PM +0900, Amit Langote wrote:
> > > > > > It may be this commit that went into PG 12 that is causing the
> > > > > > problem:
> > > > >
> > > > > Thanks for digging into this.
> > > > >
> > > > > > to account for partitions that were pruned by the planner for which
> > > > > > we
> > > > > > decided to put 0 into relid_map, but it only considered the case
> > > > > > where
> > > > > > the number of partitions doesn't change since the plan was created.
> > > > > > The crash reported here is in the other case where the concurrently
> > > > > > added partitions cause the execution-time PartitionDesc to have more
> > > > > > partitions than the one that PartitionedRelPruneInfo is based on.
> > > > >
> > > > > Is there anything else needed to check that my crash matches your
> > > > > analysis ?
> > > >
> > > > If you can spot a 0 in the output of the following, then yes.
> > > >
> > > > (gdb) p *pinfo->relid_map@pinfo->nparts
> > >
> > > I guess you knew that an earlier message has just that. Thanks.
> > > https://www.postgresql.org/message-id/[email protected]
> >
> > Yeah, you showed:
> >
> > (gdb) p *pinfo->relid_map@414
> >
> > And there is indeed a 0 in there, but I wasn't sure if it was actually
> > in the array or a stray zero due to forcing gdb to show beyond the
> > array bound. Does pinfo->nparts match 414?
Yes. I typed 414 manually since the the array lengths were suspect.
(gdb) p pinfo->nparts
$1 = 414
(gdb) set print elements 0
(gdb) p *pinfo->relid_map@pinfo->nparts
$3 = {22652203, 22652104, 22651920, 22651654, 22647359, 22645269, 22644012,
22639600, 22638852, 22621975, 22615355, 22615256, 22615069, 22610573, 22606503,
22606404, 22600237, 22600131, 22596610, 22595013,
22594914, 22594725, 22594464, 22589317, 22589216, 22587504, 22582570,
22580264, 22577047, 22576948, 22576763, 22576656, 22574077, 22570911, 22570812,
22564524, 22564113, 22558519, 22557080, 22556981, 22556793,
22555205, 22550680, 22550579, 22548884, 22543899, 22540822, 22536665,
22536566, 22536377, 22535133, 22528876, 22527780, 22526065, 22521131, 22517878,
22513674, 22513575, 22513405, 22513288, 22507520, 22504728,
22504629, 22493699, 22466016, 22458641, 22457551, 22457421, 22457264,
22452879, 22449864, 22449765, 22443560, 22442952, 22436193, 22434644, 22434469,
22434352, 22430792, 22426903, 22426804, 22420732, 22420025,
22413050, 22411963, 22411864, 22411675, 22407652, 22404156, 22404049,
22397550, 22394622, 22390035, 22389936, 22389752, 22388386, 22383211, 22382115,
22381934, 22375210, 22370297, 22367878, 22367779, 22367586,
22362556, 22359928, 22358236, 22353374, 22348704, 22345692, 22345593,
22345399, 22341347, 22336809, 22336709, 22325812, 22292836, 22287756, 22287657,
22287466, 22283194, 22278659, 22278560, 22272041, 22269121,
22264424, 22264325, 22264135, 22260102, 22255418, 22254818, 22248841,
22245824, 22241490, 22241391, 22241210, 22240354, 22236224, 22235123, 22234060,
22228744, 22228345, 22228033, 22222528, 22222429, 22222330,
22222144, 22222045, 22218408, 22215986, 22215887, 22209311, 22209212,
22207919, 22205203, 22203385, 22203298, 22203211, 22203124, 22202954, 22202859,
22202772, 22201869, 22200438, 22197706, 22195027, 22194932,
22194834, 22191208, 22188412, 22187029, 22182238, 22182134, 22182030,
22181849, 22181737, 22181107, 22175811, 22175710, 22169859, 22169604, 22159266,
22158131, 22158021, 22157824, 22153348, 22153236, 22147308,
22146736, 22143778, 22143599, 22143471, 22138702, 22138590, 22132612,
22132513, 22132271, 22132172, 22131987, 21935599, 21932664, 21927997, 21925823,
21885889, 21862973, 21859854, 21859671, 21858869, 21853440,
21851884, 21845405, 21842901, 21837523, 21837413, 21837209, 21832347,
21829359, 21827652, 21822602, 21816150, 21805995, 21805812, 21805235, 21798914,
21798026, 21791895, 21791124, 21783854, 21783744, 21783540,
21780568, 21774797, 21774687, 21768326, 21764063, 21759627, 21759517,
21759311, 21755697, 21751690, 21751156, 21744906, 21738543, 21736176, 21735992,
21735769, 21727603, 21725956, 21716432, 21678682, 21670968,
21670858, 21670665, 21669342, 21661932, 21661822, 21655311, 21650838,
21646721, 21646611, 21646409, 21640984, 21637816, 21637706, 21631061, 21622723,
21621459, 21621320, 21621148, 21612902, 21612790, 21606170,
21602265, 21597910, 21597800, 21597605, 21592489, 21589415, 21589305,
21582910, 21578017, 21576758, 21576648, 21572692, 21566633, 21566521, 21560127,
21560017, 21553910, 21553800, 21553613, 21553495, 21549102,
21548992, 21542759, 21540922, 21532093, 21531983, 21531786, 21531676,
21531264, 21531154, 21525290, 21524817, 21519470, 21519360, 21519165, 21516571,
21514269, 21514159, 21508389, 21508138, 21508028, 21507830,
21503457, 21502484, 21496897, 21494287, 21493722, 21493527, 21491807,
21488530, 21486122, 21485766, 21485603, 21485383, 21481969, 21481672, 21476245,
21472576, 21468851, 21468741, 21468546, 21467832, 21460086,
21425406, 21420632, 21420506, 21419974, 21417830, 21417365, 21408677,
21401314, 21400808, 21399725, 21399113, 21393312, 21393202, 21387393, 21384625,
21384361, 21384172, 21384054, 21379960, 21374013, 21365760,
21361813, 21361703, 21361504, 21358333, 21358220, 21352848, 21348896,
21348484, 21343591, 21337675, 21337472, 21331017, 21330907, 21325895, 21325785,
21325675, 21325565, 21325370, 21319929, 21316068, 21315958,
21312609, 21284187, 21262186, 21258549, 21258439, 21258279, 21258131,
21254759, 21251782, 21251094, 21250984, 21250874, 21250764, 21244302, 21239067,
21238951, 21238831, 21236783, 21235605, 21230205, 21166173,
21151836, 21151726, 21151608, 21151498, 21151388, 21151278, 21151168,
21151055, 2576248, 2576255, 2576262, 2576269, 2576276, 21456497, 22064128, 0}
--
Justin
