On Sun, 2004-11-07 at 21:31, Tom Lane wrote: > "Katsaros Kwn/nos" <[EMAIL PROTECTED]> writes: > > More precisely,when I call (my_)SPI_prepare the following message comes > > exactly at the point where (my_)SPI_end_call(true) is called: > > > WARNING: problem in alloc set my_SPI Exec: detected write past chunk > > end in block 0x830b7e8, chunk 0x830c058 > > WARNING: problem in alloc set my_SPI Exec: detected write past chunk > > end in block 0x8307720, chunk 0x830b6cc > > > Any ideas? I think it is something with the memory contexts but > > obviously this is not enough to solve the problem. > > I'd bet on buffer-overrun problems. Check your allocation request sizes > against what's actually being used.
I tried to increase the allocated memory using ALLOCSET_DEFAULT_*SIZE just to see what would happen, but nothing.What is returned is a Plan node and some (3 in my example) Query nodes. All inside a List. Are these too big to fit? When my user defined procedure (that calls my_SPI functions) returns, the following message also appears: WARNING: problem in alloc set my_SPI Results: detected write past chunk end in block 0x8313550, chunk 0x8315140 which is obviously about the same kind of problem. The thing is that I noticed that this latter message appears as many times as I palloc inside my_SPI_copy_results() function which is an extension of _SPI_copy_plan(). I cannot understand what the problem is since I do similar things with _SPI_copy_plan. I palloc() exactly at the same places with the original func. Is it that I use Lists as a mean of returning multiple objects to the user defined function or even that I call another function that pallocs before calling my_SPI_copy_results() (this other function produces the Query nodes)? Are there any other places in the source other than (my_)spi.c, (my_)spi.h and xact.c (AtEOXact_(my_)SPI() call) that I should make an entry regarding my code? Thanks for your interest! Ntinos ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
