[
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.
--
Shawn.
