Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [jgit-dev] More problems

On Mon, Jun 20, 2011 at 07:48, Shawn Pearce <spearce@xxxxxxxxxxx> wrote:
> On Mon, Jun 20, 2011 at 07:40, Matthias Sohn
> <matthias.sohn@xxxxxxxxxxxxxx> wrote:
>> 2011/6/20 Zivkov, Sasa <sasa.zivkov@xxxxxxx>
>>> Looks like mysql sequences (used to generate primary keys) were reset.
>>> Somebody having mysql access would have to check all the sequences and the
>>> existing key values generated out of these sequences and update the
>>> sequences
>>> accordingly (to the greatest key value + 1).
> Correct, and done. MySQL has a feature where the auto_increment
> columns reset to 0 on server restart if the table is empty. Gerrit
> keeps these tables empty, as it only uses them to generate a new
> number. So MySQL restarts are really ugly because we have to manually
> fix these tables to bump their counters.

FWIW, I just fixed this MySQL bug and pushed a new build. We shouldn't
need to worry about resetting the counters on a MySQL restart.


Back to the top