1427638 - jb2bz.py sometimes imports messages out of order

Status: UNCONFIRMED

(Bugzilla :: Bugzilla-General, defect)

Description

[Quanah Gibson-Mount]

Attachment: jb2bz-out-of-order.png

User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0
Build ID: 20171226083017

Steps to reproduce:

Imported from a jitterbugs deployment to bugzilla


Actual results:

Some of the imported bugs had the comments imported in the wrong order


Expected results:

The comments should have been imported in the correct order

Comment 1

[Quanah Gibson-Mount]

Note that the original files being imported had correct sequential timestamps:

root@ub16:/home/quanah/doc/openldap/bugzilla-migration-docs/jitterbugs/extract/bug_tracking/Web# stat 6499
  File: '6499'
  Size: 519             Blocks: 8          IO Block: 4096   regular file
Device: fc00h/64512d    Inode: 9746185     Links: 1
Access: (0644/-rw-r--r--)  Uid: ( 1000/  quanah)   Gid: ( 1000/  quanah)
Access: 2018-01-02 12:32:09.587454806 -0800
Modify: 2010-03-25 16:36:04.000000000 -0700
Change: 2017-12-01 13:03:18.743052375 -0800
 Birth: -
root@ub16:/home/quanah/doc/openldap/bugzilla-migration-docs/jitterbugs/extract/bug_tracking/Web# stat 6499.followup.1
  File: '6499.followup.1'
  Size: 1452            Blocks: 8          IO Block: 4096   regular file
Device: fc00h/64512d    Inode: 9746188     Links: 1
Access: (0644/-rw-r--r--)  Uid: ( 1000/  quanah)   Gid: ( 1000/  quanah)
Access: 2018-01-02 12:32:09.587454806 -0800
Modify: 2010-03-25 17:42:56.000000000 -0700
Change: 2017-12-01 13:03:18.743052375 -0800
 Birth: -

And in the message itself:

root@ub16:/home/quanah/doc/openldap/bugzilla-migration-docs/jitterbugs/extract/bug_tracking/Web# more 6499
From [e-mail]  Thu Mar 25 23:36:04 2010
Date: Thu, 25 Mar 2010 23:36:04 +0000
From: [e-mail]
To: [e-mail]
Subject: ftp.openldap.org: no space left on device

root@ub16:/home/quanah/doc/openldap/bugzilla-migration-docs/jitterbugs/extract/bug_tracking/Web# more 6499.followup.1
From [e-mail]  Fri Mar 26 00:42:56 2010
Return-Path: <[e-mail]>
Received: from [192.168.1.102] (kdz.boolean.net [75.141.233.128])
        (authenticated bits=0)
        by boole.openldap.org (8.14.3/8.14.3) with ESMTP id o2Q0grQR072144;
        Fri, 26 Mar 2010 00:42:54 GMT
        (envelope-from [e-mail])
Subject: Re: (ITS#6499) ftp.openldap.org: no space left on device
Mime-Version: 1.0 (Apple Message framework v1077)
Content-Type: text/plain; charset=us-ascii
From: Kurt Zeilenga <[e-mail]>
In-Reply-To: <[e-mail]>
Date: Thu, 25 Mar 2010 17:42:53 -0700

Comment 2

[Quanah Gibson-Mount]

It looks like the code throws away TZ data, which is the source of the problem.

Comment 3

[Quanah Gibson-Mount]

Fixed in https://github.com/bugzilla/bugzilla/pull/58