For example, This is Redmine r1 git revision.
https://www.chiliproject.org/projects/chiliproject/repository/revisions/d19142e20

Previous revision should be nil, and next revision should be r3.
But, previous revision is r3.
https://www.chiliproject.org/projects/chiliproject/repository/revisions/73e0b8f8b3

!redmine-r1.png!

The reason is described at "note-6":http://www.redmine.org/issues/5357#note-6 of #5357.

$ git log master --reverse
commit d19142e20949d442c20275e467f3d39c33a21f03
Author: Jean-Philippe Lang
Date:   Wed Jun 28 17:26:26 2006 +0000

    Initial setup
    
    git-svn-id: http://redmine.rubyforge.org/svn/trunk@1 e93f8b46-1217-0410-a6f0-8f06a7374b81

commit 73e0b8f8b3c9350018a7d8fda143dd9b8aa6f091
Author: Jean-Philippe Lang
Date:   Wed Jun 28 18:09:47 2006 +0000

    Initial import.
    
    git-svn-id: http://redmine.rubyforge.org/svn/trunk@3 e93f8b46-1217-0410-a6f0-8f06a7374b81

commit 6b7650e2f03156ea1e3985b30c1995e44c317e3d
Author: Jean-Philippe Lang
Date:   Wed Jun 28 18:11:03 2006 +0000

    Initial commit
    
    git-svn-id: http://redmine.rubyforge.org/svn/trunk@4 e93f8b46-1217-0410-a6f0-8f06a7374b81

.
.
.

$ ( echo 'SELECT id, committed_on, revision FROM changesets ' \
    echo 'where repository_id = 59 order by id;' ) \
    | sqlite3 test.db 
274932|2006-12-07 05:16:43|41c2af55cf508ad3c4bb566f0696a4130697763a
274933|2006-07-10 01:30:01|f37089f54784da4b457ed19d588e137078977089
274934|2006-07-04 04:38:10|366ca57c36df8e85f903304e0ab0364d4a5ea006
274935|2006-06-29 04:54:35|b1ede59d02891c0e284e15680abd73301374d3bc
274936|2006-06-29 03:11:03|6b7650e2f03156ea1e3985b30c1995e44c317e3d
274937|2006-06-29 03:09:47|73e0b8f8b3c9350018a7d8fda143dd9b8aa6f091
274938|2006-06-29 02:26:26|d19142e20949d442c20275e467f3d39c33a21f03