From: | Brian P Millett <bpm(at)ec-group(dot)com> |
---|---|
To: | postgres <hackers(at)postgreSQL(dot)org> |
Cc: | Peter T Mount <peter(at)retep(dot)org(dot)uk> |
Subject: | ERROR: index_rescan: invalid amrescan regproc ??? |
Date: | 1999-04-23 19:35:41 |
Message-ID: | 3720CB8D.D29B6D54@ec-group.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hello,
I am trying to run the ImageViewer.java example that is part of the
src/interfaces/jdbc/ examples. I have a database test which has two
images loaded into it with the ImageVIewer app.
I am running a cvs snapshot as of 4/22, java1.2, Solaris 7, cc: WorkShop
Compilers 5.0 98/12/15 C 5.0.
I envoke the postmaster as:
su bpm -c "${PGSQLHOME}/bin/postmaster -i -d -D ${PGDATA} 2>&1 >
${PGDATA}/trace.log"
to get a trace.log file.
I start the java app as:
vlad: java -classpath $MYCLASSPATH example.ImageViewer
jdbc:postgresql:test bpm foo
Connecting to Database URL = jdbc:postgresql:test
Selecting oid for item_4.gif
Got oid 149387
Import complete
Selecting oid for item_2.gif
Got oid 149441
At this point I get a SQLException: "Fastpath: index_rescan: invalid
amrescan regproc"
In the trace.log, I have:
vlad: tail -f trace.log
read_pg_options: all=1,verbose=2,query
debug info:
User = bpm
RemoteHost = 127.0.0.1
RemotePort = 33694
DatabaseName = test
Verbose = 2
Noversion = f
timings = f
dates = Normal
bufsize = 64
sortmem = 512
query echo = f
InitPostgres
StartTransactionCommand
query: show datestyle
ProcessUtility: show datestyle
CommitTransactionCommand
LockReleaseAll: lockmethod=1, pid=4369
LockReleaseAll: reinitializing lockQueue
LockReleaseAll: done
StartTransactionCommand
query: select proname, oid from pg_proc where proname = 'lo_open' or
proname = 'lo_close' or proname = 'lo_creat' or proname = 'lo_unlink' or
proname = 'lo_lseek' or proname = 'lo_tell' or proname = 'loread' or
proname = 'lowrite'
ProcessQuery
CommitTransactionCommand
LockReleaseAll: lockmethod=1, pid=4369
LockReleaseAll: reinitializing lockQueue
LockReleaseAll: done
StartTransactionCommand
query: select imgname from images order by imgname
ProcessQuery
CommitTransactionCommand
LockReleaseAll: lockmethod=1, pid=4369
LockReleaseAll: reinitializing lockQueue
LockReleaseAll: done
StartTransactionCommand
query: select imgoid from images where imgname='item_4.gif'
ProcessQuery
CommitTransactionCommand
LockReleaseAll: lockmethod=1, pid=4369
LockReleaseAll: reinitializing lockQueue
LockReleaseAll: done
StartTransactionCommand
CommitTransactionCommand
LockReleaseAll: lockmethod=1, pid=4369
LockReleaseAll: reinitializing lockQueue
LockReleaseAll: done
StartTransactionCommand
CommitTransactionCommand
LockReleaseAll: lockmethod=1, pid=4369
LockReleaseAll: reinitializing lockQueue
LockReleaseAll: done
StartTransactionCommand
CommitTransactionCommand
LockReleaseAll: lockmethod=1, pid=4369
LockReleaseAll: reinitializing lockQueue
LockReleaseAll: done
StartTransactionCommand
CommitTransactionCommand
LockReleaseAll: lockmethod=1, pid=4369
LockReleaseAll: reinitializing lockQueue
LockReleaseAll: done
StartTransactionCommand
CommitTransactionCommand
LockReleaseAll: lockmethod=1, pid=4369
LockReleaseAll: reinitializing lockQueue
LockReleaseAll: done
StartTransactionCommand
CommitTransactionCommand
LockReleaseAll: lockmethod=1, pid=4369
LockReleaseAll: reinitializing lockQueue
LockReleaseAll: done
StartTransactionCommand
CommitTransactionCommand
LockReleaseAll: lockmethod=1, pid=4369
LockReleaseAll: reinitializing lockQueue
LockReleaseAll: done
StartTransactionCommand
query: select imgoid from images where imgname='item_2.gif'
ProcessQuery
CommitTransactionCommand
LockReleaseAll: lockmethod=1, pid=4369
LockReleaseAll: reinitializing lockQueue
LockReleaseAll: done
StartTransactionCommand
CommitTransactionCommand
LockReleaseAll: lockmethod=1, pid=4369
LockReleaseAll: reinitializing lockQueue
LockReleaseAll: done
StartTransactionCommand
CommitTransactionCommand
LockReleaseAll: lockmethod=1, pid=4369
LockReleaseAll: reinitializing lockQueue
LockReleaseAll: done
StartTransactionCommand
CommitTransactionCommand
LockReleaseAll: lockmethod=1, pid=4369
LockReleaseAll: reinitializing lockQueue
LockReleaseAll: done
StartTransactionCommand
CommitTransactionCommand
LockReleaseAll: lockmethod=1, pid=4369
LockReleaseAll: reinitializing lockQueue
LockReleaseAll: done
StartTransactionCommand
CommitTransactionCommand
LockReleaseAll: lockmethod=1, pid=4369
LockReleaseAll: reinitializing lockQueue
LockReleaseAll: done
StartTransactionCommand
AbortCurrentTransaction
LockReleaseAll: lockmethod=1, pid=4369
LockReleaseAll: reinitializing lockQueue
LockReleaseAll: done
Which doesn't show an error :-(
>From the commandline where I envoked postmaster, I have:
# /etc/init.d/postgress.init start
FindExec: found "/opt/pgsql/bin/postgres" using argv[0]
FindExec: found "/opt/pgsql/bin/postgres" using argv[0]
/opt/pgsql/bin/postmaster: BackendStartup: pid 4481 user bpm db test
socket 5
NOTICE: DateStyle is Postgres with US (NonEuropean) conventions
ERROR: index_rescan: invalid amrescan regproc
Then the java app is basically dead & I have to exit.
Any ideas?
Thanks.
--
Brian Millett
Enterprise Consulting Group "Heaven can not exist,
(314) 205-9030 If the family is not eternal"
bpm(at)ec-group(dot)com F. Ballard Washburn
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-04-23 19:41:03 | Re: [HACKERS] PostgreSQL Webpage -> PGSQL Advocacy |
Previous Message | Bruce Momjian | 1999-04-23 19:34:07 | Re: [HACKERS] ERROR: mot_idx: cannot extend |