skip to main | skip to sidebar

my mysql related ramblings

A blog about MySQL and other bits and pieces

Thursday, August 27, 2009

partitioning + auto_increment is buggy!

Folks, I just want to warn you how buggy partitioned tables with negative values are. Never use negative values for InnoDB auto_increment columns!!!!

  • Assertion failed: next_insert_id >= auto_inc_interval_for_cur_row.minimum()
  • partitioned innodb tables end up with duplicate primary key values!
  • AUTO_INCREMENT errors with partitioned InnoDB tables in 5.1.31
  • Assertion failure in file row/row0mysql.c line 1386
There are more bugs than I listed here..

Posted by sbester at 07:53 0 comments

Labels: auto_increment, partitioning

Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Blog Archive

  • ►  2014 (1)
    • ►  August (1)
  • ►  2013 (1)
    • ►  January (1)
  • ►  2012 (1)
    • ►  September (1)
  • ►  2010 (5)
    • ►  September (1)
    • ►  June (1)
    • ►  May (2)
    • ►  February (1)
  • ▼  2009 (8)
    • ►  December (1)
    • ▼  August (1)
      • partitioning + auto_increment is buggy!
    • ►  June (3)
    • ►  May (1)
    • ►  January (2)
  • ►  2008 (4)
    • ►  September (1)
    • ►  August (1)
    • ►  July (1)
    • ►  April (1)
  • ►  2007 (15)
    • ►  October (1)
    • ►  September (4)
    • ►  August (5)
    • ►  July (1)
    • ►  May (4)

My own bugs

Loading...
 

A BOOK called ONE STEP AT A TIME on FIBROMYALGIA

  • A BOOK called ONE STEP AT A TIME on FIBROMYALGIA