MySQL Bugs: #14541: NDB can not replicate tables that do not have a PK

Bug #14541	NDB can not replicate tables that do not have a PK
Submitted:	1 Nov 2005 12:28	Modified:	2 Mar 2006 10:23
Reporter:	Jonathan Miller	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Replication	Severity:	S2 (Serious)
Version:	5.1	OS:	Linux (Linux)
Assigned to:	Martin Skold	CPU Architecture:	Any

Description:
2:43:14 [Note] NDB Binlog: CREATE TABLE Event: REPL$test/t1
2:43:14 [ERROR] NDB Binlog: logging of table ./test/t1 without a primary key is not supported

When using mysql-test to test Cluster Replication a majority of tests fail due to the table not having a PK. This does not seem to be an issue for MyISAM or InnoDB.

NDB and DBD use a hidden key for tables without PK. We might be able to use this to replicate with.

How to repeat:
Create a table without a PK and try to replicate.

Suggested fix:
NDB and DBD use a hidden key for tables without PK. We might be able to use this to replicate with.

Pushed implementation of cluster replication with 
tables with no primary key to clone mysql-5.1-wl2325-v3, to
be merged with mysql-5.1 clone once RBR is pushed to 5.1.

Thank you for your bug report. This issue has already been fixed
in the latest released version of that product, which you can download at 
http://www.mysql.com/downloads/

Additional info:

Per Martin/IRC: Fix was applied in 5.1.7; documented same in 5.1.7 changelog; closed.

I am also receiving the same in my replication error log:

061017 18:54:39 [ERROR] NDB Binlog: logging of table ./juriscape/lcarticlemas_log with BLOB attribute and no PK is not supported
061017 18:54:58 [ERROR] NDB Binlog: logging of table ./juriscape/lccomments with BLOB attribute and no PK is not supported
061017 18:55:28 [ERROR] NDB Binlog: logging of table ./juriscape/lcerrorlog with BLOB attribute and no PK is not supported

[root@rhel4mysql1 mysql]# rpm -qa | grep MySQL
perl-DBD-MySQL-2.9004-3.1
qt-MySQL-3.3.3-9.3
MySQL-python-1.0.0-1.RHEL4.1
MySQL-server-5.1.11-0.glibc23
MySQL-shared-5.1.11-0.glibc23
MySQL-devel-5.1.11-0.glibc23
MySQL-client-5.1.11-0.glibc23