| From: | Amit Kapila <amit(dot)kapila(at)huawei(dot)com> |
|---|---|
| To: | "'Harry'" <shirlekar(dot)harshal(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Cursor fetch Problem. |
| Date: | 2012-12-28 11:38:35 |
| Message-ID: | 00a401cde4ef$df96efa0$9ec4cee0$@kapila@huawei.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thursday, December 27, 2012 2:44 PM Harry wrote:
> Below is the Linux ps -ef | grep postgres output :-
>
> 501 12163 5473 0 Dec19 ? 00:00:00 postgres: enterprisedb
> sampledb 192.168.0.231[53991] ?EDB-SPL Procedure successfully completed
> 501 12167 5473 0 Dec19 ? 00:00:00 postgres: enterprisedb
> sampledb 192.168.0.231[53995] ?EDB-SPL Procedure successfully
> completed.
>
> Also, if i try to kill from OS the whole database gets shut down.
Have you checked server logs for any specific messages like below or any
other message after you call cancel/terminate
Backend API?
FATAL: terminating connection due to administrator command
ERROR: canceling statement due to user request
With Regards,
Amit Kapila.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Harry | 2012-12-28 11:45:20 | Re: Cursor fetch Problem. |
| Previous Message | wd | 2012-12-28 07:53:45 | Re: Group by bug? |