Postgres Pro
Downloads
Home   >   mailing lists

Thread: BUG #14283: PostgreSQL 9.6 head crashing PostGIS bot

BUG #14283: PostgreSQL 9.6 head crashing PostGIS bot

From
lr@pcorp.us
Date:
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz
aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDI4MwpMb2dnZWQgYnk6ICAg
ICAgICAgIFJlZ2luYSBPYmUKRW1haWwgYWRkcmVzczogICAgICBsckBwY29y
cC51cwpQb3N0Z3JlU1FMIHZlcnNpb246IDkuNmJldGEzCk9wZXJhdGluZyBz
eXN0ZW06ICAgTWluZ3c2NCBXaW5kb3dzIDcgYW5kIERlYmlhbgpEZXNjcmlw
dGlvbjogICAgICAgIAoKTm90ZSB0aGlzIGlzIGFmdGVyIDkuNmJldGEzIHJl
bGVhc2UsIGJ1dCBJIGhhZCB0byBzZWxlY3QgYSB2ZXJzaW9uLg0KDQpTaW5j
ZSBhcm91bmQgOC8zLzIwMTYgb3VyIERlYmlhbiBQb3N0R0lTIGJ1aWxkIGJv
dCBoYXMgYmVlbiBjcmFzaGluZyBkdXJpbmcKdGVzdCB0byBpbnN0YWxsIFBv
c3RHSVMgKHVzaW5nIG5vbi1leHRlbnNpb24pLCB3aGF0J3MgaW50ZXJlc3Rp
bmcgaXMgdGhhdAp3aGVuIGluc3RhbGxlZCB2aWEgDQoNCkNSRUFURSBFWFRF
TlNJT04gcG9zdGdpczsNCg0KaXQgZG9lcyBub3QgY3Jhc2guICBJIHdhcyBh
YmxlIHRvIHJlcGxhY2F0ZSB0aGUgaXNzdWUgdW5kZXIgd2luZG93cyBhcyB3
ZWxsCm1pbmd3NjQsIGFuZCB0cmFjZWQgaXQgdG8gdGhlIHBhcnQgb2YgdGhl
IGluc3RhbGwgc2NyaXB0IHRoYXQgZG9lcyB0aGlzOg0KDQpDUkVBVEUgT1Ig
UkVQTEFDRSBWSUVXIGdlb2dyYXBoeV9jb2x1bW5zIEFTDQoJCVNFTEVDVA0K
CQkJY3VycmVudF9kYXRhYmFzZSgpIEFTIGZfdGFibGVfY2F0YWxvZywgDQoJ
CQluLm5zcG5hbWUgQVMgZl90YWJsZV9zY2hlbWEsIA0KCQkJYy5yZWxuYW1l
IEFTIGZfdGFibGVfbmFtZSwgDQoJCQlhLmF0dG5hbWUgQVMgZl9nZW9ncmFw
aHlfY29sdW1uLA0KCQkJcG9zdGdpc190eXBtb2RfZGltcyhhLmF0dHR5cG1v
ZCkgQVMgY29vcmRfZGltZW5zaW9uLA0KCQkJcG9zdGdpc190eXBtb2Rfc3Jp
ZChhLmF0dHR5cG1vZCkgQVMgc3JpZCwNCgkJCXBvc3RnaXNfdHlwbW9kX3R5
cGUoYS5hdHR0eXBtb2QpIEFTIHR5cGUNCgkJRlJPTSANCgkJCXBnX2NsYXNz
IGMsIA0KCQkJcGdfYXR0cmlidXRlIGEsIA0KCQkJcGdfdHlwZSB0LCANCgkJ
CXBnX25hbWVzcGFjZSBuDQoJCVdIRVJFIHQudHlwbmFtZSA9ICdnZW9ncmFw
aHknDQoJICAgICAgICBBTkQgYS5hdHRpc2Ryb3BwZWQgPSBmYWxzZQ0KCSAg
ICAgICAgQU5EIGEuYXR0dHlwaWQgPSB0Lm9pZA0KCSAgICAgICAgQU5EIGEu
YXR0cmVsaWQgPSBjLm9pZA0KCSAgICAgICAgQU5EIGMucmVsbmFtZXNwYWNl
ID0gbi5vaWQNCgkgICAgICAgIEFORCBOT1QgcGdfaXNfb3RoZXJfdGVtcF9z
Y2hlbWEoYy5yZWxuYW1lc3BhY2UpDQoJICAgICAgICBBTkQgaGFzX3RhYmxl
X3ByaXZpbGVnZSggYy5vaWQsICdTRUxFQ1QnOjp0ZXh0ICk7DQoNCg0KDQpU
aGUgYmFja3RyYWNlIG9mIHRoZSBlcnJvciBpcyBzaG93aW5nOg0KDQpSZWFk
aW5nIHN5bWJvbHMgZnJvbQpDOlxtaW5nNjRnY2M0OFxwcm9qZWN0c1xwb3N0
Z3Jlc3FsXHJlbFxwZzkuNnc2NGdjYzQ4XGJpblxwb3N0Z3Jlcy5leGUuLi5k
b25lLg0KMHgwMDAwMDAwMDc3N2NhZTExIGluIG50ZGxsIURiZ0JyZWFrUG9p
bnQgKCkNCiAgIGZyb20gQzpcV2luZG93c1xTWVNURU0zMlxudGRsbC5kbGwN
CihnZGIpIGNvbnQNCkNvbnRpbnVpbmcuDQpbVGhyZWFkIDI3MTk2LjB4N2Y5
YyBleGl0ZWQgd2l0aCBjb2RlIDBdDQoNClByb2dyYW0gcmVjZWl2ZWQgc2ln
bmFsIFNJR1NFR1YsIFNlZ21lbnRhdGlvbiBmYXVsdC4NCltTd2l0Y2hpbmcg
dG8gVGhyZWFkIDI3MTk2LjB4NzE5OF0NCkdldE9sZGVzdFNuYXBzaG90ICgp
IGF0IHNuYXBtZ3IuYzo0MjINCjQyMiAgICAgICAgICAgICAgICAgICAgIHJl
dHVybiBPbGRlc3RBY3RpdmVTbmFwc2hvdC0+YXNfc25hcDsNCihnZGIpIGJ0
DQojMCAgR2V0T2xkZXN0U25hcHNob3QgKCkgYXQgc25hcG1nci5jOjQyMg0K
IzEgIDB4MDAwMDAwMDAwMDQ0ZWZkZCBpbiBpbml0X3RvYXN0X3NuYXBzaG90
ICh0b2FzdF9zbmFwc2hvdD0weDI5OWU5YjApDQogICAgYXQgdHVwdG9hc3Rl
ci5jOjIzMTQNCiMyICAweDAwMDAwMDAwMDA0NGYxMjMgaW4gdG9hc3RfZmV0
Y2hfZGF0dW0gKGF0dHI9PG9wdGltaXplZCBvdXQ+KQ0KICAgIGF0IHR1cHRv
YXN0ZXIuYzoxODY5DQojMyAgMHgwMDAwMDAwMDAwNDUwOGM2IGluIGhlYXBf
dHVwbGVfdW50b2FzdF9hdHRyIChhdHRyPTB4NTljMDRjYSkNCiAgICBhdCB0
dXB0b2FzdGVyLmM6MTc5DQojNCAgMHgwMDAwMDAwMDAwN2JjOWRhIGluIHBn
X2RldG9hc3RfZGF0dW1fcGFja2VkIChkYXR1bT08b3B0aW1pemVkIG91dD4p
DQogICAgYXQgZm1nci5jOjIyNjYNCiM1ICAweDAwMDAwMDAwMDA3OTA2MjAg
aW4gdGV4dF90b19jc3RyaW5nICh0PTB4NTljMDRjYSkgYXQgdmFybGVuYS5j
OjE4Ng0KIzYgIDB4MDAwMDAwMDAwMDdhM2E5NSBpbiBSZWxhdGlvbkJ1aWxk
UnVsZUxvY2sgKA0KICAgIHJlbGF0aW9uPXJlbGF0aW9uQGVudHJ5PTB4ZTdk
Y2Q0OCkgYXQgcmVsY2FjaGUuYzo3MzINCiM3ICAweDAwMDAwMDAwMDA3YTYy
MWEgaW4gUmVsYXRpb25CdWlsZERlc2MgKA0KICAgIHRhcmdldFJlbElkPXRh
cmdldFJlbElkQGVudHJ5PTU4MTI0LCBpbnNlcnRJdD1pbnNlcnRJdEBlbnRy
eT0wICdcMDAwJykNCiAgICBhdCByZWxjYWNoZS5jOjEwMzUNCiM4ICAweDAw
MDAwMDAwMDA3YTY2MjUgaW4gUmVsYXRpb25DbGVhclJlbGF0aW9uICgNCiAg
ICByZWxhdGlvbj1yZWxhdGlvbkBlbnRyeT0weGU3ZGM0ZDAsIHJlYnVpbGQ9
cmVidWlsZEBlbnRyeT0xICdcMDAxJykNCiAgICBhdCByZWxjYWNoZS5jOjIy
MTgNCiM5ICAweDAwMDAwMDAwMDA3YTcwYjggaW4gUmVsYXRpb25GbHVzaFJl
bGF0aW9uIChyZWxhdGlvbj0weGU3ZGM0ZDApDQogICAgYXQgcmVsY2FjaGUu
YzoyMzMwDQojMTAgUmVsYXRpb25DYWNoZUludmFsaWRhdGVFbnRyeSAocmVs
YXRpb25JZD01ODEyNCkgYXQgcmVsY2FjaGUuYzoyMzkyDQojMTEgMHgwMDAw
MDAwMDAwN2EwNzVlIGluIExvY2FsRXhlY3V0ZUludmFsaWRhdGlvbk1lc3Nh
Z2UgKA0KICAgIG1zZz1tc2dAZW50cnk9MHhlNzA3OTkwKSBhdCBpbnZhbC5j
OjU2OA0KIzEyIDB4MDAwMDAwMDAwMDdhMDg3NiBpbiBQcm9jZXNzSW52YWxp
ZGF0aW9uTWVzc2FnZXMgKGhkcj0weDRlMTMwODgsDQogICAgZnVuYz0weDdh
MDY1MCA8TG9jYWxFeGVjdXRlSW52YWxpZGF0aW9uTWVzc2FnZT4pIGF0IGlu
dmFsLmM6NDQ0DQojMTMgMHgwMDAwMDAwMDAwN2EwOGE5IGluIENvbW1hbmRF
bmRJbnZhbGlkYXRpb25NZXNzYWdlcyAoKSBhdAppbnZhbC5jOjEwNTYNCiMx
NCAweDAwMDAwMDAwMDA0ODk0ODYgaW4gQXRDQ0lfTG9jYWxDYWNoZSAoKSBh
dCB4YWN0LmM6MTM3Nw0KIzE1IENvbW1hbmRDb3VudGVySW5jcmVtZW50ICgp
IGF0IHhhY3QuYzo5NTYNCiMxNiAweDAwMDAwMDAwMDA2YjBkMjIgaW4gZXhl
Y19zaW1wbGVfcXVlcnkgKA0KICAgIHF1ZXJ5X3N0cmluZz0weDEwMDAwMDAw
MDAwMDAwMCA8ZXJyb3I6IENhbm5vdCBhY2Nlc3MgbWVtb3J5IGF0IGFkZHJl
c3MKMHgxMDAwMDAwMDAwMDAwMDA+KSBhdCBwb3N0Z3Jlcy5jOjExMzMNCiMx
NyBQb3N0Z3Jlc01haW4gKGFyZ2M9PG9wdGltaXplZCBvdXQ+LCBhcmd2PWFy
Z3ZAZW50cnk9MHgyNDk1YzgsDQogICAgZGJuYW1lPTB4MTgwMDE3MDAxNjAw
MTUgPGVycm9yOiBDYW5ub3QgYWNjZXNzIG1lbW9yeSBhdCBhZGRyZXNzCjB4
MTgwMDE3MDAxNjAwMTU+LCB1c2VybmFtZT08b3B0aW1pemVkIG91dD4pIGF0
IHBvc3RncmVzLmM6NDA3NA0KIzE4IDB4MDAwMDAwMDAwMDY0Nzk0ZCBpbiBC
YWNrZW5kUnVuIChwb3J0PTB4Mjk5ZjQwMCkgYXQgcG9zdG1hc3Rlci5jOjQy
NjINCiMxOSBTdWJQb3N0bWFzdGVyTWFpbiAoYXJnYz1hcmdjQGVudHJ5PTMs
IGFyZ3Y9YXJndkBlbnRyeT0weDJiN2U4MCkNCiAgICBhdCBwb3N0bWFzdGVy
LmM6NDc1Mg0KIzIwIDB4MDAwMDAwMDAwMDgwM2FjOCBpbiBtYWluIChhcmdj
PTMsIGFyZ3Y9MHgyYjdlODApIGF0IG1haW4uYzoyMDUNCg0KVGhpcyBpcyBh
bHNvIGxvZ2dlZCBpbiBQb3N0R0lTIGJ1ZyB0cmFja2VyOg0KaHR0cHM6Ly90
cmFjLm9zZ2VvLm9yZy9wb3N0Z2lzL3RpY2tldC8zNjA5DQoNCkdpdmVuIHRo
ZSB0aW1pbmcgb2Ygd2hlbiB0aGUgZXJyb3Igc3RhcnRlZCwgSSBhbSBoaWdo
bHkgc3VzcGVjdGluZyB0aGlzCmNvbW1pdDoNCg0KDQpQcmV2ZW50ICJzbmFw
c2hvdCB0b28gb2xkIiBmcm9tIHRyeWluZyB0byByZXR1cm4gcHJ1bmVkIFRP
QVNUIHR1cGxlcy4KKENvbW1pdCAzZTJmM2MyZTQyM2IzYWU5MDY2NjhjMTg2
YmFjNzk1MjJiOGUzZTI5IGJ5IHJoYWFzKQ0KDQpodHRwczovL2dpdC5wb3N0
Z3Jlc3FsLm9yZy9naXR3ZWIvP3A9cG9zdGdyZXNxbC5naXQ7YT1jb21taXQ7
aD0zZTJmM2MyZTQyM2IzYWU5MDY2NjhjMTg2YmFjNzk1MjJiOGUzZTI5DQoN
Cg0KDQoNCg0KCgo=

Re: BUG #14283: PostgreSQL 9.6 head crashing PostGIS bot

From
Michael Paquier
Date:
On Sun, Aug 7, 2016 at 2:18 PM,  <lr@pcorp.us> wrote:
> Given the timing of when the error started, I am highly suspecting this
> commit:
> Prevent "snapshot too old" from trying to return pruned TOAST tuples.
> (Commit 3e2f3c2e423b3ae906668c186bac79522b8e3e29 by rhaas)
> https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=3e2f3c2e423b3ae906668c186bac79522b8e3e29

Right. This bug is discussed here as well:
https://www.postgresql.org/message-id/87vazemeda.fsf@credativ.de
And it is tracked in the list of open items for 9.6.
--
Michael

Re: BUG #14283: PostgreSQL 9.6 head crashing PostGIS bot

From
Tom Lane
Date:
Michael Paquier <michael.paquier@gmail.com> writes:
> On Sun, Aug 7, 2016 at 2:18 PM,  <lr@pcorp.us> wrote:
>> Given the timing of when the error started, I am highly suspecting this
>> commit:
>> Prevent "snapshot too old" from trying to return pruned TOAST tuples.
>> (Commit 3e2f3c2e423b3ae906668c186bac79522b8e3e29 by rhaas)

> Right. This bug is discussed here as well:
> https://www.postgresql.org/message-id/87vazemeda.fsf@credativ.de
> And it is tracked in the list of open items for 9.6.

Should be fixed now.

            regards, tom lane