| From: | Trang Le <trang(dot)le(at)evizi(dot)com> |
|---|---|
| To: | Mladen Gogala <gogala(dot)mladen(at)gmail(dot)com> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | calling store procedure / insert statement never complete |
| Date: | 2021-09-02 06:13:14 |
| Message-ID: | CAFfZjTi_mwpb4=b-sfjzHQ0LJpyLGfvnQ0rpwuY2NO1SWRva1A@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi Mladen,
I missed previous emails, so I am creating a new one.
I think the problem is coming from front-end side. when I run store
procedure, job in pg_locks is done, data is inserted, log table shows that
job completed with number of insert. However, store procedure in front-end
side is still show running until the sever closed connection. The same
problem when I run the query statement only, insert about 190k rows, when
check target table, data is insert, but in the front-end side is still show
wait until server close connection.
I use pgamin4 5.3.
Error: Server closed the connection unexpectedly. This probably means the
server terminated abnormally before or while processing the request.
Could you please double check?
Thanks and regards,
Trang
| From | Date | Subject | |
|---|---|---|---|
| Next Message | o.lepretre | 2021-09-02 06:21:37 | RE: oldest WAL files not removed |
| Previous Message | Alexander Kass | 2021-09-02 05:50:04 | No xmin in pg_database |