Fri Apr 15 11:16:16 PDT 2011
- Previous message: No subject
- Next message: No subject
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
my_db=# select * from _sac_uk.sl_log_2 where log_tableid =190;
log_origin | log_txid | log_tableid | log_actionseq | log_cmdtype |
log_cmddata
------------+------------+-------------+---------------+-------------+-----------------------------------------------------------------------------------------------------
1 | 1369072247 | 190 | 239698918 | I |
("id","lock_until_time") values ('anonymous_marking','2011-05-11
11:40:02.456091')
1 | 1369182578 | 190 | 239728797 | I |
("id","lock_until_time") values
('process_past_due_pm_assignments.pl','2011-05-11
11:00:23.944101')
1 | 1369182587 | 190 | 239728806 | D |
"id"='process_past_due_pm_assignments.pl'
1 | 1369182626 | 190 | 239728830 | I |
("id","lock_until_time") values
('process_past_due_pm_assignments.pl','2011-05-11
11:00:24.525818') 1 | 1369182671 | 190 | 239728833 | D
| "id"='process_past_due_pm_assignments.pl'
(5 rows)
my_db=# select * from _sac_uk.sl_log_1 where log_tableid =190;
log_origin | log_txid | log_tableid | log_actionseq | log_cmdtype |
log_cmddata
------------+------------+-------------+---------------+-------------+------------------------------------------------------------------------------------
1 | 1369393174 | 190 | 239789790 | D |
"id"='anonymous_marking'
1 | 1369403276 | 190 | 239793047 | I |
("id","lock_until_time") values ('anonymous_marking','2011-05-11
12:40:02.970433')(2 rows)
On the subscriber logs:May 11 11:54:40 uk-sdb2 postgres[30851]: [926-1]
2011-05-11 11:54:40.755 PDT [user=slony,db=my_db 10.1.0.149(47318) PID:30851
XID:1509911291]ERROR: duplicate key value violates unique constraint
"cron_lock_pkey"
May 11 11:54:40 uk-sdb2 postgres[30851]: [926-2] 2011-05-11 11:54:40.755 PDT
[user=slony,db=my_db 10.1.0.149(47318) PID:30851 XID:1509911291]STATEMENT:
update only "public"."m_user" set "last_login"='2011-05-11 10:40:02.429308'
where "id"='2459339';
Any help would be much appreciated.
--Richard
--000e0cd14f88f871e704a304a2b7
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
<div><div>Hello,</div><div><br></div><div><div>running=C2=A0slon version 2.=
0.6 here...</div></div><div><br></div><div>Would anyone be able to help me =
track down why slony missed a DELETE? =C2=A0It seems that my replication is=
broken as the subscribers are trying to process an INSERT, but a primary k=
ey is being violated. =C2=A0The origin machine does not have the offending =
tuple, which leads me to believe that a DELETE was processed, but wasn'=
t propagated to the subscribers</div>
<div><br></div><div>From my origin machine:</div><div>my_db=3D# select * fr=
om cron_lock;</div><div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 id =C2=A0 =C2=A0 =C2=A0=
=C2=A0 | =C2=A0 =C2=A0 =C2=A0lock_until_time =C2=A0 =C2=A0 =C2=A0=C2=A0</d=
iv><div>-------------------+----------------------------</div><div>=C2=A0an=
onymous_marking | 2011-05-11 11:40:02.456091</div>
<div>(1 row)</div><div><br></div><div>From my subscriber machines:</div><di=
v>my_db=3D# select * from cron_lock ;</div><div>=C2=A0 =C2=A0 =C2=A0 =C2=A0=
id =C2=A0 =C2=A0 =C2=A0 =C2=A0 | =C2=A0 =C2=A0 =C2=A0lock_until_time =C2=
=A0 =C2=A0 =C2=A0=C2=A0</div><div>-------------------+---------------------=
-------</div>
<div>=C2=A0anonymous_marking | 2011-05-11 10:40:02.123721</div><div>(1 row)=
</div><div><br></div><div>From the origin's sl_log_* tables:</div><div>=
my_db=3D# select * from _sac_uk.sl_log_2 where log_tableid =3D190;</div><di=
v>=C2=A0log_origin | =C2=A0log_txid =C2=A0| log_tableid | log_actionseq | l=
og_cmdtype | =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 log_cmddata =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=C2=A0</div>
<div>------------+------------+-------------+---------------+-------------+=
---------------------------------------------------------------------------=
--------------------------</div><div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 1 |=
1369072247 | =C2=A0 =C2=A0 =C2=A0 =C2=A0 190 | =C2=A0 =C2=A0 239698918 | I=
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | ("id","lock_until_time=
") values ('anonymous_marking','2011-05-11 11:40:02.456091=
')</div>
<div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 1 | 1369182578 | =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 190 | =C2=A0 =C2=A0 239728797 | I =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 | ("id","lock_until_time") values ('<a href=
=3D"http://process_past_due_pm_assignments.pl">process_past_due_pm_assignme=
nts.pl</a>','2011-05-11 11:00:23.944101')</div>
<div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 1 | 1369182587 | =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 190 | =C2=A0 =C2=A0 239728806 | D =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 | "id"=3D'<a href=3D"http://process_past_due_pm_assign=
ments.pl">process_past_due_pm_assignments.pl</a>'</div><div>=C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 1 | 1369182626 | =C2=A0 =C2=A0 =C2=A0 =C2=A0 190 |=
=C2=A0 =C2=A0 239728830 | I =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | ("id=
","lock_until_time") values ('<a href=3D"http://process_=
past_due_pm_assignments.pl">process_past_due_pm_assignments.pl</a>',=
9;2011-05-11 11:00:24.525818') =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A01 | 13=
69182671 | =C2=A0 =C2=A0 =C2=A0 =C2=A0 190 | =C2=A0 =C2=A0 239728833 | D =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | "id"=3D'<a href=3D"http:=
//process_past_due_pm_assignments.pl">process_past_due_pm_assignments.pl</a=
>'</div>
<div>(5 rows)</div><div><br></div><div>my_db=3D# select * from _sac_uk.sl_l=
og_1 where log_tableid =3D190;</div><div>=C2=A0log_origin | =C2=A0log_txid =
=C2=A0| log_tableid | log_actionseq | log_cmdtype | =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0log_cmddata =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0=C2=A0</div>
<div>------------+------------+-------------+---------------+-------------+=
---------------------------------------------------------------------------=
--------- =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A01 | 1369393174 | =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 190 | =C2=A0 =C2=A0 239789790 | D =C2=A0 =C2=A0 =C2=A0 =C2=A0=
=C2=A0 | "id"=3D'anonymous_marking'</div>
<div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 1 | 1369403276 | =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 190 | =C2=A0 =C2=A0 239793047 | I =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 | ("id","lock_until_time") values ('anonymou=
s_marking','2011-05-11 12:40:02.970433')(2 rows)</div><div><br>=
</div>
<div>On the subscriber logs:May 11 11:54:40 uk-sdb2 postgres[30851]: [926-1=
] 2011-05-11 11:54:40.755 PDT [user=3Dslony,db=3Dmy_db 10.1.0.149(47318) PI=
D:30851 XID:1509911291]ERROR: =C2=A0duplicate key value violates unique con=
straint "cron_lock_pkey"</div>
<div>May 11 11:54:40 uk-sdb2 postgres[30851]: [926-2] 2011-05-11 11:54:40.7=
55 PDT [user=3Dslony,db=3Dmy_db 10.1.0.149(47318) PID:30851 XID:1509911291]=
STATEMENT: =C2=A0update only "public"."m_user" set &quo=
t;last_login"=3D'2011-05-11 10:40:02.429308' where "id&qu=
ot;=3D'2459339';</div>
<div><br></div><div>Any help would be much appreciated.</div><div>--Richard=
</div></div><div><br></div>
--000e0cd14f88f871e704a304a2b7--
- Previous message: No subject
- Next message: No subject
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list