Opened 9 years ago

#4665 new defect

every 51'st changeset is not imported from the repository

Reported by: Dimitri Tarassenko Owned by: Lewis Baker
Priority: high Component: PerforcePlugin
Severity: critical Keywords: missing changesets
Cc: Trac Release: 0.11


I am using a large and old repository with ~9000 (nine thousand) changesets. I have noticed a few errors here and there when I started using RepoSearch plugin, in particular, that a lot of changesets are missing. While tracking this down I found the pattern that all missing changesets would differ in number by 51.

While in Perforce numbered changesets can be canceled, leaving a gap in their sequence, you can find if you are missing changesets by executing this:

select cast(rev as integer)-1 from revision where cast(rev as integer)-1 not in (select rev from revision) order by cast(rev as integer);

NOTE: this is Postgres version, I am sure SQLIte will be similar.

I was able to get this fixed by changing "batchsize = 50" to "batchsize = 1000000" in and, but this obviously is a workaround rather than a solution.

I am positive the bug is there because when I tried it with batchsize = 1000 I was missing changesets 1001, 2002, 3003 and so on.

Thank you!

Attachments (0)

Change History (0)

Modify Ticket

Change Properties
Set your email in Preferences
as new The owner will remain Lewis Baker.

Add Comment

E-mail address and name can be saved in the Preferences.

Note: See TracTickets for help on using tickets.