could not find block containing chunk 0x8483530

[Vinay Jain]

select *, lower(name) from student;
gives error: could not find block containing chunk 0x8483530

what does this error mean & what may be the cause?
template1=# \d student
Table "public.student "
Column | Type | Modifiers
--------+---------+-----------
name | devchar |
age | integer |

Regards
Vinay

--
Vinay Jain
Dissertation Project Trainee
DAKE Division
C-DAC Mumbai

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Tom Lane]

Vinay Jain <vi*******@gmai l.com> writes:

select *, lower(name) from student;
gives error: could not find block containing chunk 0x8483530
That's some sort of memory manipulation bug --- pfree'ing a wrong
pointer, likely.
template1=# \d student
Table "public.student "
Column | Type | Modifiers
--------+---------+-----------
name | devchar |
age | integer |

Given that a custom datatype is involved, I'd suspect the C code
for the custom type.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)

[Vinay Jain]

On Tue, 17 Aug 2004 09:59:40 +0530, Vinay Jain <vi*******@gmai l.com> wrote:

On Mon, 16 Aug 2004 10:39:18 -0400, Tom Lane <tg*@sss.pgh.pa .us> wrote:

Vinay Jain <vi*******@gmai l.com> writes:

select *, lower(name) from student;
gives error: could not find block containing chunk 0x8483530

That's some sort of memory manipulation bug --- pfree'ing a wrong
pointer, likely.

I am not using pfree in C code. but I am using palloc for memory allocation.

All other queries like: select * from student order by lower(name);
gives appropriate result.

template1=# \d student
Table "public.student "
Column | Type | Modifiers
--------+---------+-----------
name | devchar |
age | integer |

Given that a custom datatype is involved, I'd suspect the C code
for the custom type.

regards, tom lane

--
Vinay Jain
Dissertation Project Trainee
DAKE Division
C-DAC Mumbai

--
Vinay Jain
Dissertation Project Trainee
DAKE Division
C-DAC Mumbai

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Alvaro Herrera]

On Tue, Aug 17, 2004 at 10:00:16AM +0530, Vinay Jain wrote:

On Tue, 17 Aug 2004 09:59:40 +0530, Vinay Jain <vi*******@gmai l.com> wrote:

On Mon, 16 Aug 2004 10:39:18 -0400, Tom Lane <tg*@sss.pgh.pa .us> wrote:

Vinay Jain <vi*******@gmai l.com> writes:
> select *, lower(name) from student;
> gives error: could not find block containing chunk 0x8483530

That's some sort of memory manipulation bug --- pfree'ing a wrong
pointer, likely.

I am not using pfree in C code. but I am using palloc for memory allocation.

All other queries like: select * from student order by lower(name);
gives appropriate result.

Maybe you are palloc'ing in the wrong memory context. Make sure you
understand how memory contexts are used and thier longevity.

If you want anything more specific, you should post your code.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Vivir y dejar de vivir son soluciones imaginarias.
La existencia está en otra parte" (Andre Breton)
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster