Complex view abends backend (status 11)

From: "Joel Burton" <jburton(at)scw(dot)org>
To: pgsql-general(at)postgreSQL(dot)org, pgsql-bugs(at)postgreSQL(dot)org
Subject: Complex view abends backend (status 11)
Date: 2000-09-13 16:42:54
Message-ID: 39BF764E.23211.A41A07D@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)scw(dot)org
Support Center of Washington (www.scw.org)

Browse pgsql-general by date

  From Date Subject
Next Message chris markiewicz 2000-09-13 16:54:11 Database cmdatabase does not exist in pg_database
Previous Message The Hermit Hacker 2000-09-13 15:31:25 Is this broken?