Обсуждение: problem with custom Gist for custom type
Hi there folks I created custom type, and attempt to create gist indexing for it, to make search wind quick. on select from * where something << 'something'; I get: WARNING: problem in alloc set GiST temporary context: detected write past chunk end in block 0x843e6e0, chunk 0x843e994 Can someone tell me please, what might be the cause? Thanks
Grzegorz Jaskiewicz <gj@pointblue.com.pl> writes:
> I created custom type, and attempt to create gist indexing for it, to
> make search wind quick.
> on select from * where something << 'something'; I get:
> WARNING: problem in alloc set GiST temporary context: detected write
> past chunk end in block 0x843e6e0, chunk 0x843e994
> Can someone tell me please, what might be the cause?
Looks like you're scribbling on memory that doesn't belong to you.
Check for miscomputed palloc request sizes, etc.
regards, tom lane
On Wednesday 26 October 2005 17:48, Tom Lane wrote: > Looks like you're scribbling on memory that doesn't belong to you. > Check for miscomputed palloc request sizes, etc. Thanks very much for the tip. I thogut perhaps I am not filling out some parts of structures, or something. Can I use valgrind to find out the root of problem. If so, how should I invoke it with postgres. Postgres it self was configured with: ./configure --prefix=/usr/local/postgres --with-python --enable-cassert --with-openssl --with-gnu-ld --enable-integer-datetimes --enable-debug Thanks. -- GJ Binary system, you're either 1 or 0... dead or alive ;)
btw, if you could read russian, we have GiST programming tutorial http://www.sai.msu.su/~megera/postgres/talks/gist_tutorial.html Oleg On Wed, 26 Oct 2005, Tom Lane wrote: > Grzegorz Jaskiewicz <gj@pointblue.com.pl> writes: >> I created custom type, and attempt to create gist indexing for it, to >> make search wind quick. >> on select from * where something << 'something'; I get: > >> WARNING: problem in alloc set GiST temporary context: detected write >> past chunk end in block 0x843e6e0, chunk 0x843e994 > >> Can someone tell me please, what might be the cause? > > Looks like you're scribbling on memory that doesn't belong to you. > Check for miscomputed palloc request sizes, etc. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83
On Wednesday 26 October 2005 18:34, Oleg Bartunov wrote: > btw, if you could read russian, we have GiST programming tutorial > http://www.sai.msu.su/~megera/postgres/talks/gist_tutorial.html I did try, but last time I did Russian lessons was around 10 years ago, so ... babel fish could help btw, but I would kindly ask for translating this tut. Especially if you can elaborate on picksplit method more, it would be great. -- GJ Binary system, you're either 1 or 0... dead or alive ;)
Ok, I got it, google is my friend ;) ... > Can I use valgrind to find out the root of problem. If so, how should I > invoke it with postgres. Postgres it self was configured with: ... -- GJ Binary system, you're either 1 or 0... dead or alive ;)