List:Backup« Previous MessageNext Message »
From:Ingo Strüwing Date:July 28 2009 7:53pm
Subject:Re: Please advise [Re: Restore locking: TRUNCATE resets AUTO_INCREMENT
on InnoDB]
View as plain text  
Hi Chuck,

Charles Bell, 28.07.2009 16:30:

...
> Ok, So I'm reading through this thread and I start to wonder ... since
> we're using InnoDB which uses the row-level insert mechanism of the
> default drivers, what do the rows in the backup image file contain for
> the auto increment column? I think it would be helpful to see a dump of
> a row to see if the auto increment value is in there.

Is this an action item for me? Extracting and translating a row from a
backup image file?

Note that I still don't know, how to proceed with WL#4844/Bug#42895 and
their dependencies Bug#40944 and Bug#41716. The patch that completes all
four is ready, but we don't restore the auto_increment value correctly.
This is not a "real" regression from the current code base, but the fix
might be understood as incomplete. (The current code uses to work if
RESTORE is not attacked by DML. Since this might be the normal case, a
regression can be claimed as the new code never restores auto_increment
for InnoDB.) (OTOH, clean restore of auto_increment was not a goal for
BACKUP/RESTORE so far.)

At first I need a decision, if the auto_increment problem must be fixed
by this patch. If not, there is hope to fix all the above #s before my
vacation. If yes, then I need a decision, how to fix it after my vacation.

Regards
Ingo
-- 
Ingo Strüwing, Database Group
Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten
Geschäftsführer: Thomas Schröder,   Wolfgang Engels,   Wolf Frenkel
Vorsitzender des Aufsichtsrates: Martin Häring   HRB München 161028
Thread
Restore locking: TRUNCATE resets AUTO_INCREMENT on InnoDBIngo Strüwing24 Jul
  • Please advise [Re: Restore locking: TRUNCATE resets AUTO_INCREMENT onInnoDB]Ingo Strüwing24 Jul
    • Re: Please advise [Re: Restore locking: TRUNCATE resets AUTO_INCREMENTon InnoDB]Ingo Strüwing27 Jul
      • Re: Please advise [Re: Restore locking: TRUNCATE resets AUTO_INCREMENTon InnoDB]Konstantin Osipov27 Jul
      • Re: Please advise [Re: Restore locking: TRUNCATE resets AUTO_INCREMENTon InnoDB]Rafal Somla28 Jul
        • Re: Please advise [Re: Restore locking: TRUNCATE resets AUTO_INCREMENTon InnoDB]Ingo Strüwing28 Jul
          • Re: Please advise [Re: Restore locking: TRUNCATE resets AUTO_INCREMENTon InnoDB]Charles Bell28 Jul
            • Re: Please advise [Re: Restore locking: TRUNCATE resets AUTO_INCREMENTon InnoDB]Ingo Strüwing28 Jul
      • Re: Please advise [Re: Restore locking: TRUNCATE resets AUTO_INCREMENTon InnoDB]Jørgen Løland13 Aug
      • Meeting preparation [Re: Restore locking: TRUNCATE resetsAUTO_INCREMENT on InnoDB]Ingo Strüwing31 Aug
  • Re: Restore locking: TRUNCATE resets AUTO_INCREMENT on InnoDBSusanne Ebrecht28 Jul
    • Re: Restore locking: TRUNCATE resets AUTO_INCREMENT on InnoDBIngo Strüwing28 Jul
      • Re: Restore locking: TRUNCATE resets AUTO_INCREMENT on InnoDBSusanne Ebrecht28 Jul
      • Re: Restore locking: TRUNCATE resets AUTO_INCREMENT on InnoDBAnn W. Harrison28 Jul
Re: Meeting preparation [Re: Restore locking: TRUNCATE resetsAUTO_INCREMENT on InnoDB]Ingo Strüwing1 Sep