Fehler in der Replikation von PostgreSQL

minimike

New Member
Hi

Ich habe die Tage zum ersten Mal einen Replication-Cluster aufgesetzt. Zwei mal RHEL 6.4 mit PostgreSQL 9.1- Der Master ist Echtblech und der Slave ist eine VM. Ich bekomme jetzt aber auf dem Slave folgende Meldungen in den Logs

Code:
Oct 31 19:19:49 pg-replication postgres[30439]: [2-3] 2013-10-31 19:19:49 CET [30439]: [3-1] STATEMENT:  COPY public.jiraaction (id, issueid, author, actiontype, actionlevel, rolelevel, actionbody, created, updateauthor, updated, actionnum) TO stdout;
Oct 31 19:21:42 pg-replication postgres[30636]: [2-1] 2013-10-31 19:21:42 CET [30636]: [1-1] ERROR:  canceling statement due to conflict with recovery
Oct 31 19:21:42 pg-replication postgres[30636]: [2-2] 2013-10-31 19:21:42 CET [30636]: [2-1] DETAIL:  User query might have needed to see row versions that must be removed.
Oct 31 19:21:42 pg-replication postgres[30636]: [2-3] 2013-10-31 19:21:42 CET [30636]: [3-1] STATEMENT:  COPY public.changeitem (id, groupid, fieldtype, field, oldvalue, oldstring, newvalue, newstring) TO stdout;
Oct 31 19:27:45 pg-replication postgres[31226]: [2-1] 2013-10-31 19:27:45 CET [31226]: [1-1] ERROR:  canceling statement due to conflict with recovery
Oct 31 19:27:45 pg-replication postgres[31226]: [2-2] 2013-10-31 19:27:45 CET [31226]: [2-1] DETAIL:  User query might have needed to see row versions that must be removed.
Oct 31 19:27:45 pg-replication postgres[31226]: [2-3] 2013-10-31 19:27:45 CET [31226]: [3-1] STATEMENT:  COPY public.jiraaction (id, issueid, author, actiontype, actionlevel, rolelevel, actionbody, created, updateauthor, updated, actionnum) TO stdout;
Oct 31 19:27:46 pg-replication postgres[31232]: [2-1] 2013-10-31 19:27:46 CET [31232]: [1-1] ERROR:  canceling statement due to conflict with recovery
Oct 31 19:27:46 pg-replication postgres[31232]: [2-2] 2013-10-31 19:27:46 CET [31232]: [2-1] DETAIL:  User query might have needed to see row versions that must be removed.
Oct 31 19:27:46 pg-replication postgres[31232]: [2-3] 2013-10-31 19:27:46 CET [31232]: [3-1] STATEMENT:  COPY public.bodycontent (bodycontentid, body, contentid, bodytypeid) TO stdout;
Oct 31 19:27:46 pg-replication postgres[31248]: [2-1] 2013-10-31 19:27:46 CET [31248]: [1-1] FATAL:  terminating connection due to conflict with recovery
Oct 31 19:27:46 pg-replication postgres[31248]: [2-2] 2013-10-31 19:27:46 CET [31248]: [2-1] DETAIL:  User query might have needed to see row versions that must be removed.
Oct 31 19:27:46 pg-replication postgres[31248]: [2-3] 2013-10-31 19:27:46 CET [31248]: [3-1] HINT:  In a moment you should be able to reconnect to the database and repeat your command.

Frage kann ich jetzt davon ausgehen das die Daten auf dem Slave nun Müll sind? Und wie könnte ich das optimieren? So das es nicht mehr auftritt
 
Back
Top