-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Michael Berg wrote:
> 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] > <mailto:[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). Michael, I can't tell you about the crash of InnoDB (you might consider filing a bug at http://bugs.mysql.com/ with a full testcase so someone can try repeating it), but the primary key requirement is so the driver can uniquely identify the row (MySQL doesn't have ROWIDs) that is being updated. This limitation is allowed by the JDBC specification, see section 5.6 of the JDBC-2.0 specification for more details. Regards, -Mark - -- Mr. Mark Matthews MySQL AB, Software Development Manager, J2EE and Windows Platforms Office: +1 708 332 0507 www.mysql.com MySQL Guide to Lower TCO http://www.mysql.com/it-resources/white-papers/tco.php -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFAnuU5tvXNTca6JD8RAjj0AJ9uRYafOQIMpbKy0lvMEYg9xq33yACgmfbd 9clLjpYsLvOP1gUS+8Pl3fo= =REzq -----END PGP SIGNATURE----- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
