| From: | Dan Scott <danieljamesscott(at)gmail(dot)com> |
|---|---|
| To: | Daniel Verite <daniel(at)manitou-mail(dot)org> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: SELECT Query on DB table preventing inserts |
| Date: | 2011-08-30 23:07:28 |
| Message-ID: | CANQKhhnkcBFx_QJrKaBuuPoLfvQwSVM-VrpU4C2JUWMh-KRvAw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Aug 30, 2011 at 13:52, Daniel Verite <daniel(at)manitou-mail(dot)org> wrote:
> Dan Scott wrote:
>
>> the insert process is unable to insert new rows into the database
>
> You should probably provide the error message on insert or otherwise describe
> how it's not working. Normally reading does not unintentionally prevent
> writing in a concurrent session.
I've investigated a little further and it seems that they don't really
'fail'. Just start taking significantly longer to insert, and the
messages start backing up and eventually stop being sent because
they're not being acknowledged. I can see a few "WARNING: pgstat wait
timeout" messages around the time that this is happening in the
syslog.
Thanks,
Dan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fujii Masao | 2011-08-31 00:03:50 | Re: FATAL: terminating connection due to conflict with recovery |
| Previous Message | Dan Scott | 2011-08-30 22:45:44 | Re: SELECT Query on DB table preventing inserts |