| From: | Wasim Devale <wasimd60(at)gmail(dot)com> |
|---|---|
| To: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Queries are failing on standby server |
| Date: | 2024-07-25 13:30:31 |
| Message-ID: | CAB5fag6D3HR7b1KdKBJ9033TNwbYgwwXO5NtUgFRJmf8aFPRzw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi All
The queries are failing on the standby server. Please note that Primary
server loading of data is going on and under load.
What setting do we need to configure to not conflict with queries. Below is
the error.
Failure happened on 'Source' side.
ErrorCode=UserErrorUnclassifiedError,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Odbc
Operation
Failed.,Source=Microsoft.DataTransfer.ClientLibrary.Odbc.OdbcConnector,''Type=System.Data.Odbc.OdbcException,Message=ERROR
[40001] [Microsoft][ODBC PostgreSQL Wire Protocol driver][PostgreSQL]ERROR:
VERROR; canceling statement due to conflict with recovery(Detail User query
might have needed to see row versions that must be removed.; File
postgres.c; Line 3133; Routine ProcessInterrupts; ),Source=mspsql27.,'
Thanks,
Wasim
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Keith Fiske | 2024-07-25 13:54:13 | Re: Queries are failing on standby server |
| Previous Message | khan Affan | 2024-07-25 12:58:52 | Re: How to detect if a postgresql gin index is bloated |