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