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

Vinay Jain <vinayjain@gmail.com> writes:[color=blue]
> select *, lower(name) from student;
> gives error: could not find block containing chunk 0x8483530[/color]

That's some sort of memory manipulation bug --- pfree'ing a wrong
pointer, likely.
[color=blue]
> template1=# \d student
> Table "public.student"
> Column | Type | Modifiers
> --------+---------+-----------
> name | devchar |
> age | integer |[/color]

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 YourEmailAddressHere" to majordomo@postgresql.org)

On Tue, 17 Aug 2004 09:59:40 +0530, Vinay Jain <vinayjain@gmail.com> wrote:[color=blue]
> On Mon, 16 Aug 2004 10:39:18 -0400, Tom Lane <tgl@sss.pgh.pa.us> wrote:[color=green]
> > Vinay Jain <vinayjain@gmail.com> writes:[color=darkred]
> > > select *, lower(name) from student;
> > > gives error: could not find block containing chunk 0x8483530[/color]
> >
> > That's some sort of memory manipulation bug --- pfree'ing a wrong
> > pointer, likely.[/color]
>
> 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.
>
>[color=green]
> >[color=darkred]
> > > template1=# \d student
> > > Table "public.student"
> > > Column | Type | Modifiers
> > > --------+---------+-----------
> > > name | devchar |
> > > age | integer |[/color]
> >
> > Given that a custom datatype is involved, I'd suspect the C code
> > for the custom type.
> >
> > regards, tom lane
> >[/color]
>
>
> --
> Vinay Jain
> Dissertation Project Trainee
> DAKE Division
> C-DAC Mumbai
>[/color]


--
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

On Tue, Aug 17, 2004 at 10:00:16AM +0530, Vinay Jain wrote:[color=blue]
> On Tue, 17 Aug 2004 09:59:40 +0530, Vinay Jain <vinayjain@gmail.com> wrote:[color=green]
> > On Mon, 16 Aug 2004 10:39:18 -0400, Tom Lane <tgl@sss.pgh.pa.us> wrote:[color=darkred]
> > > Vinay Jain <vinayjain@gmail.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.[/color]
> >[/color]
> 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.[/color]

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