Hello,
 
After adding a primary key (alter table add primary key(col1, col2) to an innodb table the server hangs and I get this in the console:
 
040509 19:50:24  InnoDB: Started; log sequence number 0 28870268
mysqld-max-nt.exe: ready for connections.
Version: '4.1.1a-alpha-max-nt'  socket: ''  port: 3306
InnoDB: Error: stored ref len is 268, but table ref len is 780
040509 19:52:23InnoDB: Assertion failure in thread 2768 in file C:\411a\build\my
sql-4.1.1a-alpha\innobase\row\row0sel.c line 1972
InnoDB: Failing assertion: field->prefix_len > 0
InnoDB: We intentionally generate a memory trap.
InnoDB: Send a detailed bug report to [EMAIL PROTECTED].
InnoDB: Thread 2952 stopped in file C:\411a\build\mysql-4.1.1a-alpha\innobase\sy
nc\sync0arr.c line 126
InnoDB: Thread 2296 stopped in file C:\411a\build\mysql-4.1.1a-alpha\innobase\bu
f\buf0flu.c line 769
 
I have no idea why it does this. I was trying to make updateable resultsets work through the connector/j, which I have a vague idea requires that the table has a primary key (although I can't see why this is a requirement).
 
Regards,

Michael Berg
Seniorkonsulent/teknisk specialist


Berg Consult
+45 22 68 93 61
www.bergconsult.com

Reply via email to