Re: [HACKERS] Re: ERROR: index_rescan: invalid amrescan regproc ??? - Mailing list pgsql-hackers
From | Brian P Millett |
---|---|
Subject | Re: [HACKERS] Re: ERROR: index_rescan: invalid amrescan regproc ??? |
Date | |
Msg-id | 372475BE.9EBD6CFC@ec-group.com Whole thread Raw |
In response to | Re: [HACKERS] Re: ERROR: index_rescan: invalid amrescan regproc ??? (Tom Lane <tgl@sss.pgh.pa.us>) |
Responses |
Re: [HACKERS] Re: ERROR: index_rescan: invalid amrescan regproc ???
(Tom Lane <tgl@sss.pgh.pa.us>)
|
List | pgsql-hackers |
Tom Lane wrote: > Peter T Mount <peter@retep.org.uk> writes: > > On Fri, 23 Apr 1999, Brian P Millett wrote: > >> At this point I get a SQLException: "Fastpath: index_rescan: invalid > >> amrescan regproc" > > > This looks like something in the backend has died while a fastpath > > function was being used. I'll see if I can recreate it here. > > Just to save you repeating the look-around I just did: that's > coming out of backend/access/index/indexam.c, and it's apparently > complaining that a pg_am table row has a null amrescan field. > That shouldn't be true of any of the pg_am rows in a correct > installation. > > Brian, what does 'select * from pg_am' show? Did you do an initdb > while installing the 6.5 snapshot you're using? No I did not. :-( I had done everything else but that. Sorry. I did remove the old & do an "initdb", "createdb test", then reran the : java -classpath $MYCLASSPATH example.ImageViewer jdbc:postgresql:test bpm foo Then I got the following SQLexception. ERROR: index_beginscan: invalid ambeginscan regproc Then I did the test=> select * from pg_am; amname|amowner|amkind|amstrategies|amsupport|amgettuple |aminsert |amdelete |amgetattr|amsetlock|amsettid|amfreetuple|ambeginscan |amrescan |amendscan |ammarkpos |amrestrpos |amopen|amclose|ambuild |amcreate|amdestroy ------+-------+------+------------+---------+------------+----------+----------+---------+---------+--------+-----------+-------------+----------+-----------+-----------+------------+------+-------+---------+--------+--------- rtree | 159|o | 8| 3|rtgettuple |rtinsert |rtdelete |- |- |- |- |rtbeginscan |rtrescan |rtendscan |rtmarkpos |rtrestrpos |- |- |rtbuild |- |- btree | 159|o | 5| 1|btgettuple |btinsert |btdelete |- |- |- |- |btbeginscan |btrescan |btendscan |btmarkpos |btrestrpos |- |- |btbuild |- |- hash | 159|o | 1| 1|hashgettuple|hashinsert|hashdelete|- |- |- |- |hashbeginscan|hashrescan|hashendscan|hashmarkpos|hashrestrpos|- |- |hashbuild|- |- gist | 159|o | 100| 7|gistgettuple|gistinsert|gistdelete|- |- |- |- |gistbeginscan|gistrescan|gistendscan|gistmarkpos|gistrestrpos|- |- |gistbuild|- |- (4 rows) Thanks. -- Brian Millett Enterprise Consulting Group "Heaven can not exist, (314) 205-9030 If the family is not eternal" bpm@ec-group.com F. Ballard Washburn
pgsql-hackers by date: