Complex view abends backend (status 11)
От | Joel Burton |
---|---|
Тема | Complex view abends backend (status 11) |
Дата | |
Msg-id | 39BF764E.23211.A41A07D@localhost обсуждение исходный текст |
Список | 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@scw.org Support Center of Washington (www.scw.org)
В списке pgsql-general по дате отправления: