Ticket #200 (closed defect: fixed)

Opened 1 year ago

Last modified 2 months ago

Replicator import fails for deleted objects

Reported by: rambo Assigned to: rambo
Priority: major Milestone: 1.8 Thor
Component: MidCOM component Version:
Keywords: Cc:

Description

Jan 03 2008 20:17:54    [error] midcom_helper_replicator_importer::import_xml: Failed to import midgard_article 82f4eec2456d11dc8f1a67f6361c3c433c43 (action: deleted), errstr: Object already imported

The timestamps on the XML are weird

diff article_updated.xml article_deleted.xml 
3c3
<   <midgard_article purge="no" action="updated" guid="82f4eec2456d11dc8f1a67f6361c3c433c43">
---
>   <midgard_article purge="no" action="deleted" guid="82f4eec2456d11dc8f1a67f6361c3c433c43">
6c6
<       <created>2007-08-08 05:09:16</created>
---
>       <created>1186549756</created>
8c8
<       <revised>2008-01-03 18:14:50</revised>
---
>       <revised>1199384090</revised>
11c11
<       <locked></locked>
---
>       <locked>0</locked>
13c13
<       <approved></approved>
---
>       <approved>0</approved>
16,17c16,17
<       <schedulestart></schedulestart>
<       <scheduleend></scheduleend>
---
>       <schedulestart>0</schedulestart>
>       <scheduleend>0</scheduleend>
21c21
<       <published>2007-08-08 05:09:16</published>
---
>       <published>1186549756</published>
23,25c23,25
<       <imported></imported>
<       <exported></exported>
<       <deleted>0</deleted>
---
>       <imported>0</imported>
>       <exported>1199384091</exported>
>       <deleted>1</deleted>
29c29
<     <created></created>
---
>     <created>0</created>
36c36
<     <approved></approved>
---
>     <approved>0</approved>
56c56
<     <revised>2008-01-03 18:14:50</revised>
---
>     <revised>0</revised>
71c71
<     <locked></locked>
---
>     <locked>0</locked>

Database looks better

mysql> select guid,metadata_deleted,metadata_revised,revised from article where guid="82f4eec2456d11dc8f1a67f6361c3c433c43";
+--------------------------------------+------------------+---------------------+---------------------+
| guid                                 | metadata_deleted | metadata_revised    | revised             |
+--------------------------------------+------------------+---------------------+---------------------+
| 82f4eec2456d11dc8f1a67f6361c3c433c43 |                1 | 2008-01-03 18:17:34 | 2008-01-03 18:14:50 | 
+--------------------------------------+------------------+---------------------+---------------------+
1 row in set (0.00 sec)

Change History

01/03/08 20:03:12 changed by rambo

(In [14215]) workaround for MGD_ERR_OBJECT_IMPORTED issue, refs #200

01/03/08 20:05:24 changed by rambo

(In [14216]) forward port r14215, refs #200

01/03/08 20:41:55 changed by rambo

  • owner changed from pp to rambo.
  • component changed from Midgard Core to MidCOM component.

In fact this is caused by the way MidCOM core handles DBA watches and the way MidCOM core mucks most timestamp fields (including the $obj->metadata ones) to unixtime.

01/03/08 20:44:26 changed by rambo

  • status changed from new to closed.
  • resolution set to fixed.

(In [14218]) Juggling for deleted objects to fix #200

01/03/08 20:45:52 changed by rambo

(In [14219]) forward port r14218, refs #200

09/30/08 14:59:42 changed by bergie

  • milestone set to 1.8 Thor.