I have several tables (tblClass, tblInst, etc.) and a complex view
vlkpClass that pulls together both tables, along with ~10 subselects
of information from other tables, some including aggregate function
information. The view compiles correctly, and has worked correctly,
but as it grew, it now gives this:
--
000913.12:39:00.946 [4254] query: select * from vlkpclass;
/usr/bin/postmaster: reaping dead processes...
/usr/bin/postmaster: CleanupProc: pid 4254 exited with status 11
Server process (pid 4254) exited with status 11 at Wed Sep 13
12:39:00 2000
Terminating any active server processes...
Server processes were terminated at Wed Sep 13 12:39:00 2000
Reinitializing shared memory and semaphores
000913.12:39:00.966 [4218] shmem_exit(0)
000913.12:39:00.966 [4218] NOTICE: IPCPrivateMemoryKill:
shmctl(240642, 0, 0)
failed: Invalid argument
000913.12:39:00.966 [4218] NOTICE: IPCPrivateMemoryKill:
shmctl(240641, 0, 0)
failed: Invalid argument
000913.12:39:00.966 [4218] NOTICE: IPCPrivateMemoryKill:
shmctl(240640, 0, 0)
failed: Invalid argument
binding ShmemCreate(key=52e3ed, size=1104896)
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset:
/usr/bin/postmaster: ServerLoop: handling reading 5
/usr/bin/postmaster: ServerLoop: handling reading 5
/usr/bin/postmaster: ServerLoop: handling writing 5
The Data Base System is starting up
/usr/bin/postmaster: ServerLoop: handling writing 5
Failed.
!# 000913.12:39:00.975 [4264] DEBUG: Data Base System is
starting up at Wed Sep 13 12:39:00 2000
000913.12:39:00.975 [4264] DEBUG: Data Base System was
interrupted being in production at Wed Sep 13 12:38:32 2000
000913.12:39:00.977 [4264] DEBUG: Data Base System is in
production state at Wed Sep 13 12:39:00 2000
000913.12:39:00.977 [4264] proc_exit(0)
000913.12:39:00.978 [4264] shmem_exit(0)
000913.12:39:00.978 [4264] exit(0)
/usr/bin/postmaster: reaping dead processes...
--
If I select certain fields from the view, it works fine, but if I select
many or select *, it crashes as above.
Any ideas? What can I do to provide more information?
Thanks!
--
Joel Burton, Director of Information Systems -*- jburton@scw.org
Support Center of Washington (www.scw.org)
