Re: BUG #17362: Error "could not find block containing chunk" when using index with icu collation on CentOS 7

Поиск
Список
Период
Сортировка
От Pasi Eronen
Тема Re: BUG #17362: Error "could not find block containing chunk" when using index with icu collation on CentOS 7
Дата
Msg-id CAGtiUvnysMFJqv0NLtJKu-ww1QBid76nV7TBqKn=rGDQQ1VFow@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #17362: Error "could not find block containing chunk" when using index with icu collation on CentOS 7  (Peter Eisentraut <peter.eisentraut@enterprisedb.com>)
Ответы Re: BUG #17362: Error "could not find block containing chunk" when using index with icu collation on CentOS 7  (Pasi Eronen <pe@iki.fi>)
Re: BUG #17362: Error "could not find block containing chunk" when using index with icu collation on CentOS 7  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Hi Peter E & Peter G,

Although I have not touched PostgreSQL internals before, I took a stab
at debugging this, and found something that looks strange (and might
be related):

In varlena.c, ssup_extra->buf1 and buf2 are initialized to 1024-byte
buffers, allocated from the ssup->ssup_cxt memory context.  That
strange-looking test string in my bug report just happens to be 1044
bytes, so a larger buffer is needed at some point.

If growing the buffer happens in "varstrfastcmp_locale", it uses
MemoryContextAlloc(ssup->ssup_cxt, ...). But if growing the buffer
happens in "varstr_abbrev_convert", it just calls "palloc" - and
apparently the current memory context is not ssup_cxt at this point
(at least according to debugging printf's I added).

Might this be causing the problem? (changing the palloc to
MemoryContextAlloc certainly makes the problem go away, but on the
other hand, it looks like neither memory context has been deleted yet
when the error occurs, so it shouldn't really matter...?)

In other news, I tried tweaking the test data strings (mainly
replacing "x"s with other ascii characters), and accidentally found a
version that causes a reproducible segfault (instead of "could not
find block containing chunk" error). I've included the base64-encoded
dump below.

Best regards,
Pasi

base64 -d <<EOF | gunzip > /tmp/bad_strings_data.sql
H4sIAAAAAAAAA+ydS85lyXWd2/eOoqCWLDioeD9gWQBJ60WKIkFSBAQ1jHhShEmKECkBGoF6bhvq
WLYnYMAdtzUUT8Aegr91s7IqX/d/ZRZtQEyQRVZmnjhxIvZee60dO/b/ze9+7y8++8Xfjp/+ZH5t
9PXvf/mrv/nJz3/8y89++yfrX3/2d/2nf7v/1Wd/+P3vfuezX/5q/eTn/+a60ikp7my27dlEG5up
Kw9jd+yptrn3qpc/61/+um6XXO+pmV6qM7G6aVpfPNbjSbbMNmO4fPvNJ1KLY6UeTTphmrjTMH0H
Z3pfZ62cmzvrrSc+fy4M73Oe3rQ8l4n+VDNOscae7fKeca0+Ll9fL/p17bHuOlwxLiZrYjrL9NqC
aSfX7LuzyYbLj96b0/IjjzWC2ScW1qszJ8enrXbaPvZkd+Llh28/MwsLMMI22+/Gq4IWKxweTD7u
bjMr9+4zscbR/bCmp8D0imVmY/Jam31yM+116uWPXvbt7y6FnbHvU7Jx6XQTz2mm1ch00+gu9s4/
9+U7Lx9/tXFCn93sXbCY061p8QyT0ojO+Z5P8pfvvrfUPYbgJlsS3Wb77WRapXYzu2WdZzvHjctf
vHxas4x2xogm25WYVqmmLevNYmDXarUju8u3Xjp6bTEMO5zJfUc28GDGe3te5svYPeS08uV7Lxg4
LltC3NuE3FiWFpepDa+YPh/rz7ax+suPXjhtjCHPmuSs27nB8FuOviqOPtzuKZfu1uX7Lx6+l5x3
9t5MF4+Jc3TTHJt6so85Fb/86pc/eenwb71qjdT37IwdPLAT8PC6RzHFnZMaFp5jeil8vH7HwHWq
BwJL1GboH22taNqsju3Zye34Qje9uuOsWxnvt8MDm7ayExsHBU6Stf2UmS9fektwsl5n0nKATCnA
cqvNzFkxxZb8Pun1376GxsMjJTPTZBcidtmHFwKmNUNpO3R24V2HnG4MN/Be7I0J8S/g2Eim8A7n
SkvtzMvPPv/LVTDqdjE1p81fZh+anRtk8RUs6LnldvmDj1r8BW7UCQJX63DgtgIL1I+czdU4HcuU
Lj948fChr35WacYVwfYYmYjFsq6TF44QswLdiz1Bb+hY4E7s6wLrTez+mE7sMeBDJRjt7k64/Lt3
t8F5lrQ5Z5xL+OUksIwcunHDOk+kKJl5/eyNbWPwXDzO7C3W4+RysVnjawlrZNsAqMufvw+/Kaxa
TjEjgV3Rj0Ns3IShBS6POVeM8fKL96I2T7bYJ0xgmNCE952g32ouJoPaacWBzcXLn7141Ry2cxjL
hF4JDoRPVq1j+HUevtPPNMblL182drJxBI8nzFCxWuf4aCerzdH7OgrI5T73oqvd+ElY3QDoGF23
BSdK09i63MJ4Fgv8blgfy7oa2OKlvxn72dAtT+CZs4B+3tWa3qMCo+4mJ2oly8zPEfU6JrD/iwDG
c/vyq/e3weewIEp8Sxd++5ZlXQmHXBPv7A2/ff3cFU611inH1FkIVyGI17QKOwputQDbGvXlvvRq
cYs+YA++duvjD7bVEt81WrONbSNw1ZeExA+96mRWLbJcvYLLNTl8hM2MyecWfcq95RfG9quD9J0U
PIEkauyQcBHoXLHb+zGgzcV9gbR7g0K7YhWn4XywSjYcMqcgBEOwe+LiP3zRPOqARPtcTdhRzt28
GQHqnno6dTY72h6Xb77oG798CVgCd8OXcxDbP5Eg5NYwa/Zde3ZgFhD1ES8IgNgsy8uH8bi5lhk+
ZINiCB3rOBFC8Nsf9xV6T+m79Ya3gpVBxscrLPzaA6UVy2x59Iv76PcI1YW3trERIfOmWUR3iU3L
+dCHMLf2y+98ADdHcqUI2PZqWG7K4OYt6uCrYY5Y9nAv949rKCvOjclC4bAX4guBE8K/6sJapi9p
lMu3P/br5wCLIT+YodAKi+EtmM7wBZ0RIAKpfySQYPqpbJuAtoMcI96jqEYA37BHAmrc5bCZH0Ht
rpBF1CfYFBwRP+KtwCYhN6Qyz7Czz2ov39tfya9rqOHkjNm4gtlED58cZ1fjxUFKGcXZc2lfzcvf
mkhJLsErkwlVNBTlRoQ7wdjuwnYTIodv5q/q7ckBYApdGcJL3LNEigLxXC2feHK3Ff77V1/R2zUB
SHTghQUhHGFABQrT+8KyK7jtkIfDxcsPPvlrCRT4j3i5m3w3gQLdIrpn02Tr96n1nRTD1Q+YKlhh
+tFzeeAPOUUDt5u5R1sPof6P38UbfNM77WdLvQBUPNpPnHxkJbakaQWJ76oA4ZTrw4JmxuFsigmH
AMjuwF8OU0xh5i+lBiKlwlQ6UYpAGdcN1AjHu09UWIVNpnb57fncX1eexdfRqSEhQeJMXkwNsbfQ
qdDAoKTKN96fuy2xwg1MDVVBMww0DARvrACVOlro8sXcmaBX7opBtxQY3jhWtObMFhYsthIBLz/6
1AbwnkHsCt3tlfdmJSoi4ZdZNZP8aUSsaGNo7+fPUPIp2hWdWQuyEs8t46Rnc0NXlkC0OZc//tST
bfBYNjmKDrHAeWJekDAm4Uuv+YSB9f70E790gtYTomVyDljygknUEwlteAVeBJ7W/VXA9bXYHEv3
1vR1lNpD5dYAVO9dW0WATrj+5duf9JUZRsG2o/daX/K+bFpAiitRaGuZIZZx+fqnfCM+kc7mPYR2
3rjHLaQnI42HL0+flC34VG9rXi6KeXc8EgOyvA1GYU4pMU58vBR7+daXZh5QFAHjknJh7x1+Ur3S
2CeANiMt5nr5o080O+Y3LEYWJu5XlNjwXeoWHAwhppTDjBFQ+KRb/v4c/JrWxUZMaGBXbEOJgwLF
7Kt09mPh+5fvvYUGPWORfU7jqqLpgQLWWLDUc9JaJdu+xuUbn2qCPRDEQkeRAKGYTENHb9fMTCFK
8+R0/OWbn+ht77581DMOn6XkqPgT6mUMtOwuAeoGBvLfr+zl8LO2VicAb7Hs3XFPbc1B5xMdbQh7
fTIoulaf4tiwE1AHIpzTMn1jlilDy0awkb/0FXKkKyHfY1dWeQIYYlMupik0xTN7dwffXJc//GSv
szbMNDzYACJhxITwAQkxJSZXRwgeQfMWz7kiEHYUaYNRYwsd5tGys/p/tWIH2/cvxPqrJwB0do2I
VfYt7e0Jm9irSdPFnVJqAcLy5gMaxru2+OgaX8Fjq+j8ftDgM6bqAYR3yNd1bX676PRoZRwkdCVn
wFRro491DwzWvZMIusV09jkWwB+g511jOlPXBiHLmisuX0Oo77Ce6/anEqYgzjXK85FNHRcxOtjp
dnm3p/2S8uwF0YXop3LQ+1ErPFk0Bh+j1F1FGl7/5XQGvwGZQloqmb+IQsohnWU9+wItqfnt2VyB
70WYQkMA5nzAZp1yQGcRqfsK9qTs30D31xg/12br4d8OyIqJt7UCFwp2rF7cSMnty//5z//wP95d
sNv+sBvoNW9Q4nxSSMl0XBFCuosQO4x3wfL2bTpUQcFjz1Up8slWTVFGlBiIOVwL+72n9LYTwoqY
qAvC2Q0CtaxMeba5pBltG/ny/fce65Ool/k4sJuXQCeIejD4YEveLtSE8rx874NMOOgIIgI2Dohn
SZUpDMRDlxpKqfqs49UfvjHD2toJVmL26HABbMZni1JlRYeso8xx+dan8tnXrrtRDH3AlMo4RW7F
Llhk9XQb78EIodqX77y3LixZHlEL4ZrOQfcE6ppiHnIFeJlw8a8m2l7PcM6x7GajNBUxGwrD8f+i
dXhIa7Hayw8+YHA7LHa7YjpbBzdNp7j5Zrz4U9pscPAfMB0ZHeNj0YTNssUtMjy2H51grR5QOz2t
d43u2pPH8eECyx4mZ8NCz9VlFgT/+JYWsHL5wX0hFfpex28emMLUYQldPS4sT0eJDnWR30JIMAgF
3ncxs/FWJAayc2LmJzQ2U0+0ennnuyClgVHNsbfzmZlMW8qpVB5nWZKb7sP+e/WbtR46++06BT7S
jxMXdtvaXayfdfv3pK2WhRdCOXAoHcKCzAJ+AHYMX5K1uQNmb3oF2q/lqRxnrh0JYUWpkBAW56tb
2XmwrL33mrVSRz6z+l2mAaSY0XBj9jtGUDyvHD5/7IpmrMtJhgWrA+0CSfUoY3w0gX6BJcmXr38x
IT+BJixvAjl8+IBIVFwnFEtIi62FWN+OQyU5lvmouEJWig201rE9SEeZbtWz6uVv3njguMkLymSJ
gOG4mnTlue0ra4Sb2WAvf/fuF1shWYNtLJ7mi71yDcRW1z0BoFn2JFz+8r2FCqwI+4gQrIPHYJym
4mBKq0VvnU4GyjunGFe2Puel45eiyDoyEzxusbgb3YEcZ4lfLdj15Dh6W9vkqIObqoKUoCdhIwxi
HUh/+fv3t8/2YSFLgiElTm6wq0Ofk6DSdlac9fJnT8lHlNlOT7ab+eoAxcoN2bjlPBa3YsZHLt9+
ykjHNmK5kjErBVkilttB6mx3R3MsYo9/wKE/H4WIFwtuRTD2hMzF58EplLgvs+R2orPt8sMnzOf1
gLGdqnQ/ZIvFjZ0I2iZhJnroimJ9wxG//rSxVoSF5x3MDj7q/Jng2pUxH44/COw5lOkPnjgxOFbW
EYJS+XDgpYKkorIO1N8orP4p886XXlkRHHhm+Gu5nQ6JUBKaiie851pziP7y3Ucm0I8jAueGI+PS
ceoEt+qMb9fa67EpxXT52selvNetICDmA1gAzeKMB5/oG/IH21pws5RhKZe/+7h3VHSTnVbeZtnb
xmf01YcpjSjoiNFHcPtRrygF7noAASJC/pzDnhVNSlDnmTbGPi4//woCekV8AeQKyUHOvvm2kES8
3d58X4JYfPhE2/tCGMZKQfAkzZ+lQF5lGw6BBFoXLx960FlVmqxiDgRdGXR8uRFVQisNBpFzPF+e
9+qAtGfVYEGsmWW1FkOC5+8acrD2IKjdB056QT9GP315g+bT1hH2qgMoY1cdU9jBEVner7AC+MQZ
iSlT5CpLFLSjA+OIyvKr7tUv400Q12mnbTpMTUMnVEXJ3ICr1ZghqZ5g+VZMQi3Vcjv+WTr+nDC3
vh3Ubx9fpRTxjy/PSoPqKjyQVbIOqJBpbeOWLGHfeQViWLn88vO/PCXp6zh88rwlr4ep/AUDWSws
+GxA+xdrdUUyLCxXRQ8K8ahW06tjMn0iAqJ3wvn9xsQRFicfWM1A0CuN6QFhiNkMyPixfDizvFUX
+TqejK7cH8xGKXUXkapWiRllv92KsbNA78obrdM6NS9VghSvkonD/Lw+vbeSkUr4i7381Qc2HiSo
FTmFz2zVyPHcgS0DiKBPx9xx17945yFXJswms9lDdZVQIR5alvWrfDQqGl79BQ956+sqaiuqpscp
8b8KZEd1fQ5ja2MQuEp6V9tcXbLOT5WUWsHzEEOaXYUGxH3k5HQQ//eKXNirgdpMBhYkbsKqNPzO
OA+yxnV63/O1r16x4TUtaj0pnx+TvZWqRATRsWGM7okw74tpcUt4QYYs2SZz3rDMrpOW4H0rO+fh
0xvc8tp6xNc7TBnJgjOjprtOxVPvwbvUba3lXXbOm/NK1vMdVhIZm64ES+ObR4kCOWWey/pysXaZ
Cxw3WKX8RdURYJNpflm8QPreX8DOfwm/rpgvCwY5O+NkqX7sFD1sPKQ1OAygunPZ96Jyqlbn0JGV
v2UadHjjF+AyT0OkAEVjf1hRf2g0ZJmfSHskYNJhZFRNUKvGnzTGtgVsjk8fzaU6ZoBnTK+K2z46
SmCpyKJJDIcE4X3yaJ8PWVAVEw417eBzqzJxCU6yiScFfr5s6M8Y8mr3wW4rPpV1xD4kK1dQQRDQ
ltaoVUeKdx4uLrmaMXOehRGFqiJSOEvIDgl9Uph2Xr7/pHmAzdF2FY8vxagBz6sdymC731DYCCWK
lx89+CW5hxVCM2UoR9oCi71h5mhR3HdOBFW+9yVvDLOA5opGJCTrm0RbwLFkiAV9OdBWFVLtzsO7
rjQbMhGFEbXhKJmpmjW7mkcYlTTmk9TBl+sCgru1VFRtlRKLFZA4DFuLT0D/9LFf/vDOwx7uHSZh
I0ElWRLgjP0keE4oGVE8d5jkEw9liXk74KDwXTlnVJnEeFUt2LfvgOYo7fKzx8ep1hcf0M626UQX
yoLRxGNsrO2EWGAx+fLtXy8EVU9cq7C2PVXy6uJNUXpzCLAI10b4O7/mOf1/8OvKDu3JXmFtS2XP
XnaHFoSfQoU3BL+4X9+yXHubMImOWL5dSZkA67Aq0EMdoYNBewjNn/66pnNvlglS0S3M0xWnqQL6
Y2FLMMY0B3GFpbv88P/V7KxbA8qFmtyEtQgF+jzU+TbzGgnn3pdf75RygoqiHlT46pRKJ4rMg5Ya
IYXjpVTXvzzn+7S/rs0TkmEHKD8dlurKQF8oYwSeHdG2UE69/K//9E//+3/+x3v//Od/evjPP/vN
H//mj3/zx4/88e/95Gc//uyXfzP/7W/97vnrv/7aL37+49/6/d/7XX7z9z/6tf9N//KPt9/6x/9y
+4P/+vFfo3PV41SkjF5tSqeh6QMi3JaUrQpv4un3SP617B7rKsjb251QJaorysIMVFW3a05f5r3E
6xX4XyXB46GdSlIi+rtV8kRpWKJsXnndy/jm0w9SfRhbb0dsA0aXxFaV+apWxZLxrjS5br4JvTeU
XNbZl65TeJQ6L8wJepjKsPez6tc64hit6+gzOJ2DSZPqUqArYffuQ7Turki7QqpLrB1GPJYOsmM0
AwliavJrHYh2T+O+xLsOEL4cVOZMqo3pLSntEyHZrYbZdS0lPE90vhq2ur2QDIaITADhO9gWV0zQ
NeHsXVAJ3POHzdEm5/o0fJwq6zLWtZj8CZ5NI0St+HTB/ca4XfUNKEKzjsq3qg+mDx2Grxa8dbCg
+oJxr9vmYCPD5qrkubKdw2Nlo9QYet0lzPyCYXUNSWrOeK8TsKVbC8PetnyjulYqwb5gWF23YeSJ
4FN2bTfd/2PPSh95sULuRbPFMUc7M9xyycrg4hGq2Dgo7+URvjXmcaeK4c54G7OMcOQelbYvBYlh
87oRwhx0eXqsZyU1Dg5TC0K3Wp2VI35rxh29czrrdkulEs8Yb9cdQ8q676lDZqcC+bCDsWzPOCt0
PPwuHFz566PHqLPweasBYl7lRLNzX6Cg7jeXy68engFvOXtNa9JUSnYnpE8PzdhzZu3gwg77kTFu
HxJTg+AvXTJnYbIugq2Kt9VZdJkI4Fn3UXFMlwoCwWRkF8uAY9VRt/Gg+WkrsRx3zj6vvThXsWKk
kC5qOd3hTF5ebxP46HOO/inHlFfvdC/REVBCVEpDFQPTAq11aDFHsn49eGoKkPHFDt1Tsg7c21JJ
6VZp3XGtV4JG2k9MWtm5amq6spFUzVPWNrrLaWpfcxBAovcPhIm3x1ppZlRPN3aq4wAxh8VlbpPv
nFb+VtJzbLZ1b/2cBTNzujszD2I5seJ9rpkPqDWf5aOjzRPsymZX7SD/arrK53RDAhgpadmn51m1
kb32qTSfO7e7PUBejdsZH3pqdSpz9Zzx+OB4cgbaTVZWChDByjcuMk/2JUUdIj2QbL3OW0Vvb0Y5
Tx3hWQNNmMb1cawbfPmo9/byCqDwuE2fLw6K2lQXGIavKDNNXXF5gC+U1E4s4IIXVYp2Kf2kQ6m0
YSre899w+dpDH39SsghnVStb3dnGxccO3sw1pu1n4rHzgRGuZ5zkVXmjagvCpehGzSownWe77vvY
/pEZoCCP1ttVJaZDUIkqHr4dc0gWAKjnsh4aofUcMsFV2X+rOxu6yLAtU8KxVvF5g5PjoRECX8o+
AmpWx7A26Y41DExXo+dydlnXL3//wAgapPrZj4M6zaymFFG1trMmo9vIblSWo+ZLeHgQjTOSG7ej
xVW0ILt6M6JuS0PhEqPmvdrlp4+Oo6GcPbOMIPZddWDsiJQtQcXKrkHVX8Wly+/ceZbFxK8sbNJv
HX7pNAtYWCztSCw4AejOs7fVIHLVfivuvpWDdEdQBeLyBqGmraeGcP9xjbAGe690+LK3Gzwqm1Dv
BD6juTB8c+0RbnNVhU5wgA3sSyfGVeXHbMnS5fW1aq7LP8Cns84HiT11qK3CRFD0PdQGhTg0qyLo
uf/0ir3sEBVqo9XJHmxK5yU66Dvs5Rn2gafDmm2J3q6gioJbZRqaCSERiVS7Nub2wNO9FKtLBxBA
FffII3RwvEILuxzbnbsfE+Cq4HyrcF51EYj4En6RDiyo69JKwa/vU+BrGpAFZYimqvKiKg9rBlhH
Hba5CQN84OzqGuCXNt76Wdz62hSdqPUOc6jT5eN1g/n+0zUAO6IXu6jUVXVDLd0ut8MXwDYX4gP6
qa7uvCorusJfLC7q6jnekhKBdLadWrv/dNtY1RjiaIrDXXajEv8ydy651NUeWnM18yBYd1OqqjTr
VoWGSi1ZtrFZ9JMeWPOuT1OQbkuFuiFFXeWvulnAFkap3gesJaVm40naonqrgVcvoaiOMSuknb3K
S+4/DQFbY2TdwqnSCroBjkwwGdtfS8d8OV9+fufpD4y3TrU+gHxENnCHoKyCxWZK9LUW6CJ6/gGf
dXoMqEhDDL7oDN6CeKgW54HPjRq///TcRZGAcJy2iGofOihoRjWwhajERvbLn3/42Rpqt/s0ifWu
GiCo5mD/JxEeXrfwvScx1dfjDYmsAWyGIcLaMaqq1ku7xjXLQvZaf59yr436USUlJEDgSXDuqv1B
hE7oHJKuz3sVdNfuS+gS6l3FxVF1FTVaLBKyjHOmE4H+O7Mm+h4fpoqZs2rQeKoCAblM3hk3Orhe
vvP418dQHZECGrtVX0MIhtQU3W7stU3ocYE1Plbk+OaAGd/srKeunuxXXUGag6uVA/0Juzrdb3pU
CL3xocHCN9HEjFkUHqHwFf4FeVJB1eF/0v3t6fGob8g2asqjEnDVceC1U22I+iG8nnD/6Zxy8oCS
2UOREa2uljsTyo+x7tKYVn3CiTWs63j2GYDzAtxXPtyMr71YFX6NcR6y2GtFVFZoL6ClzjFqDtdT
h+kX2yEcGG6MDw5AJAXWcXO0rNinrp74tmToNlW+IqR1+dZjH6L1rG0zhK516hZxSLoTzaJCYG95
mznZjXt1mtdqW6p4m5xdTdssUBhbxe19Bf7QBi09xWhXDs6pVAgQYZyjkpLB/qaRvRKPEWh4ikK8
rhK8C0K+IQdUo5Vbt5KW91FjBqUFniY1X4/o8vSlZmxkq4BsiS0PIkQO9mTrwl77PFgm8XqgMdVS
TAdAMt9IuGXNQWvUGJteVl72kfzYtaxQ4JTZEI0lddDQgJ27ZcUC8NKts08qqhZdSAP50I3TNYOo
y4TVAvwjLEiaxIM7j8HEVffEjnfiCmLJh5ihvI2BisBxF7LejgeSGwBe0MWAc+N5Ax03MsAFAV4F
/l+QNM/B/UTQzIrByuCJR2DUSGh4BP7lmk87pecUZr8aNbhFjCYmwWe7OJ1VVgmSBruCxkLtbHtG
gck1HxEWlKdqO7TwBdaEctZ9573d6u08JfF4i1NNVI9lDNKPja/F0qu2Lic417oPhG8PhZJtHlli
1hSYFJVkepx6Q4066usWtR6eki7vDj/cMVthH0hUP6u2pSc95LMh1h8gcTlDpNTJag6dOwRseiBv
TS19gKdDzUcuf/LYd8A1MmTdmdIUqXKuxAYA2qulRsDEoYRPQKP3Z5f8Vg8lk5ik7nWx1FE57pn7
PmlGHO/yz//93uOulgU43wp0de0AbgHqq+jFulGw+DztfS+BzODnuk+82u0ivH1VU9pD2exZ3rjt
sz7qOgtKZh7pU7Uv0A3vUUJQC47C7lXI7H22/sEBUXkjqp+Ov3WmcdKbVaEgKSezbMt3Ejls/MLA
QLRWdOXpEAJGQzbZ6iZS0YVcHwyEHxhyHZ2Pbac8nqqmLF8WsWtrCXMl2QrJfgpgvz0qoe0MtChh
QC2EgurMbFbJ5IDo9zVXeegy2JcD4f4hxqMkhe4qLTW58ntCpxKespso6oP7eQ2bL9NFyHDrLnJu
fQOVIGCEDf6pC+PjJOaL4cqQStji6qqMvTUI8GBxxTTH2SsQqZ5qDtfshivYpFrIjdc1ybAbLKB3
+HNrPl7+9tFhEKuEOvjM7uIVOaqXmTLgCJmRGhO29b7LqO+lmxWOOHTxLg5YHrak5nwt7e5nLPef
vjslXWcCs2FGS3dzdG11DYJXG6fxWwtgf3Z0EYXKFb0P4ypT7SX9VhNBHXdUMLHr5NOH+0zuegoC
u6di3FpqJqhuqGvBVrB1xyRXSw+EkyvSexGxi7GqnIyeeKKOfEoVVVVW7rUeyglf1Y0zuVfNv5Ss
IpAPVQXvDaCrj/A+j9KIN8frUI8ErTJgguyHTexKDJ+8ffXF4s5PVy/X6FELTeW/amATi1eMHNHo
ukpcx9pS1+PW+MW3DhdLEf/Luj7WAfOqHJM/axSXbdUZ84N3q6468IEVEe1vn3eWmkCuxOZB3ifi
pe8nnjpe1ezsdB3oNHu7YgzTxf8xyp7VlbLFmp7d/ueqBroIO2esP+oDcOugiFZrFs6LIqgllEfB
U5kN1FxRmyT1oi2I+eFBu5qgq6N1VX4+7fJf95EYx1RCF1oOYAq0tIK+Fl0O0uMP6pyrLmjCuLNJ
Xlk1q/PjGOVuWTYexyr+8pdPWx2CPUpkon1911VLJ4JhJQOByhFzYhueiQFq6+NaAJ3w9a1T/qIm
lCr7HPm0fgJveIRfXuuKWUBtcr21sVXbCt1XbdGiMMKwda07x4QNIaDupmbcOqVi4hg1SjSkvAjB
I81ZHmVerwcLgM5W5+6lpEcUE+zzDLMgZtnmAzMNz+Aq10jEzVt9YHSwgN7Bjo5HoapVANtJ8HwA
XVCnK1v13ULyx1etvnvRnZyKy04fiW7xiVsv7QU1X0rNFAWVPc6rvB2Rs7D6rHJ4Vl5FvBufcCk1
w6TUHlztf6Y6X9qgqzjqA3xPEV7j1GVC6FLS1Yu4p86VlXcdlbkhFFUj9MB0JABTUQu6HsbSGblX
qU80YaHbXFvO+8cp9+vBCPo+xhYMIed2jQ/EOE0t4O22yDI7XLq4Jw7mQB3A65YSESFRV3PdsiVW
4cotENrvlj+plgeH2sSNpu5juCvivwH8PBi662pp4R/HnmvXpcACzz63G0wNOVQ9M8HTcaoWQwrP
I6bX2bparR+1m1P/iqwjR6DbztTiylsG9jgrucZYA3sE8dhKIwyvm4K6WFtPB+fO3ODZs3D/iryA
c6t9bNPVy6LbkbNF0/lNvARqUJ9ctHJF0W8U7u206db1QL3vKtB04IBntC1AeRL2pwSxPv7WbUh3
mZPXUUhhRyqhPOog6Jl3eW7DRo95d7/NvJUQbN0Cn8gfn13BGUfE/h9I+es6ZmkDjpxUaIbNo+2a
UfPA0HvOcNUnwcA1ZWe9J5jYolObqJuJC/Rf7RBiElIl5AeA/zpAtt118WarsuR25tHXMqdj55BG
F55wm/02EstJ1Ecs5aUg65XyVvVMxS6hSYRPP+9dwHlzHMKN9PvS6e9W1+2s3hJVHT4Cy9NqBm+/
8YQZ3UZD+oWlNjYY0+cXputWTrC32npC4pXzWGAsrK1+1oLR2Zs6PFsd5y2QpZSuS/8O5f7ECPDm
uCn1HSG6ZursKNaiozpYMI5ZoF+nEiserolRf4S6slJetw6gRRfVzi3/Vlpd46w9npLA1UKpRb46
P57iVSAmKR+VVVfev+pnebQHqhdfjYEvHXfWMbncfE2hqKghKXRnTw8t3enyp09dHp+wJ4zThK3i
DFaZkA0JBJZXi17Xq55TDfb5qGr4oENQk6x6rpcMYGEkxEwffUGWww+ehnzXlmeA/TXjppZM4aL3
YZEtGAtRefntLr/84KPuZBdUlOZryoqbkwlkHc/XTBw/I+/9YSO/tgZ0h6zzYKVL/a0OqrPI04bO
/HUd68NvvfshaPboelrsm06coUtGrT9FIexUDaZOXu8wrutE+vUesnKPqqGBQzRW2ChDwsAFcvIo
wF5TQFbrxqVTXiw21VAqveGq6hXhNLoE+IRLah0N7fVjXMAvLDAz2FA6Uo1dnLDQ66rxA8/f6l1u
fcLUg8BaFfNA9rdXFxkPm+rxiV00vhgTHRNy0LmsFTD2rB+tA61B3NpmXTns4VO+DRldl04lnNUN
R1YXDaKcT16TncJ84r1M97WfWdVLzJRXvRXyjSQOg8DrCRMc7jy54q0MnUv2ZGzSKf9kHi2MZGZN
Pi0/kcPx7tkmKHP8mvpZRop82xKvbhmjUXJbh//A8Z6TV1NrLt/UwyDG3tTy4dbRjxfggjaMAwdZ
j/QIuarXqq1sTLD6aTAJmG+WUNEOYnWF4UZ+VjcW2NCcOJR+HE5TSdMNo3XLfo2GhcWW/Xy4/ubO
uEigMKaHaBQJPV21xXmLAVzTmnYPtPez+saE6JWGuvVF0rW3fCvRJF72GkMZi6WZHz5sfj1CA+e8
fjyJv/XK2/xjKKo5HbunUl3P/fIf7j5urVP1QzVlCc9uzWYQ2KwUa2WF1uXhlNhVp+k63zd26Lqs
/LXdWjQEuEeO2P6+U7JwhfDwS9utDhVRxdBVfTaWMjyEUOuSe87F32tOE2ooIMw3zqJyS3DD5B5O
mbqcOu0jGubqejsnhIQQj/opF0s/UaKLb+RwUjr6sVSX+lFNXhJ+wegTOXSr1DnCyXwLsBVWNJhC
+oifKfX6NZDIYpOqJpZkxrldzx6b1bAAj21pIr3jx76l7eN9A++nemxH629iIRNMUxpFyb5xPuYn
UaXh9ZNYYOtBDZ6n04/JKZavyKWUjM5e9aO/Qi+q+ehCLOxbP7YNwx3QOZzCTvXEhrXUsC9/+sLB
nTsbwwK2VTIQ1dyvdl1uad6rHQqhIF38i+euRi02SrLHG/1X+cqEd+cJBCRJkfkYf7wZ/9qswP8d
eHG3Mej4QyNgoyjRApiBLC1MDS0MzM2NjUySEUfypBgYgXb5ACPcAHTAMzBV61qaGoPOaQGWXcAu
JGj1P/qFLTF6XABiKPgvh28AAA==
EOF

On Thu, Jan 13, 2022 at 5:22 PM Peter Eisentraut
<peter.eisentraut@enterprisedb.com> wrote:
>
>
> On 13.01.22 16:12, Peter Eisentraut wrote:
> > On 11.01.22 23:19, Peter Geoghegan wrote:
> >> On Tue, Jan 11, 2022 at 3:16 AM PG Bug reporting form
> >> <noreply@postgresql.org> wrote:
> >>> When I query a table containing certain Unicode data, using an index
> >>> that
> >>> has certain collation, I get error message "could not find block
> >>> containing
> >>> chunk". This is fully reproducible on CentOS 7 using the official
> >>> RPM. (I
> >>> could not reproduce this on Oracle Linux 8, though):
> >>
> >> It looks like you're probably not using utf8 as your database
> >> encoding, based on the stacktrace -- even though I would expect that
> >> on your ICU version. What does "show server_encoding;" show you when
> >> run from psql?
> >>
> >> My guess is that you can temporarily work around the bug (which looks
> >> like a bug in our !HAVE_UCOL_STRCOLLUTF8 ICU support) by making sure
> >> to use UTF-8 as the server encoding.
> >
> > It looks like the reporter's system is rhel7, which does not have
> > HAVE_UCOL_STRCOLLUTF8, so it will use the other code independent of the
> > encoding.
> >
> > There could very well be some subtle memory counting bug or similar in
> > icu_to_uchar() perhaps.  Needs more analysis.
>
> Ok, I can reproduce this with the given test data and steps if I undef
> HAVE_UCOL_STRCOLLUTF8 in my build.
>
> Interestingly, I couldn't just rebuild and rerun the query.  In order
> for the error to occur, I had to rebuild the index.



В списке pgsql-bugs по дате отправления:

Предыдущее
От: Amit Langote
Дата:
Сообщение: Re: BUG #17355: Server crashes on ExecReScanForeignScan in postgres_fdw when accessing foreign partition
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: BUG #17355: Server crashes on ExecReScanForeignScan in postgres_fdw when accessing foreign partition