Bug #23416 BLOB attribute and no PK is not supported

• Submitted: 18 Oct 2006 9:44
• Modified: 19 Oct 2006 6:59
• Reporter: Mitul Savani
• Status: Not a Bug
• Category: MySQL Cluster: Cluster (NDB) storage engine
• Severity: S3 (Non-critical)
• Version: 5.1.11-0
• OS: Linux (Linux AS release 4 (Nahant))
• CPU Architecture: Any
• Tags: binlog, cluster, pk, replication

[18 Oct 2006 9:44] Mitul Savani

Description:
Hi,

I have setup cluster which is in below mentioned format:

Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)]     2 node(s)
id=2    @192.168.2.161  (Version: 5.1.11, Nodegroup: 0, Master)
id=3    @192.168.2.162  (Version: 5.1.11, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1    @192.168.2.160  (Version: 5.1.11)

[mysqld(API)]   3 node(s)
id=4    @192.168.2.162  (Version: 5.1.11)
id=5    @192.168.2.161  (Version: 5.1.11)
id=6    @192.168.2.159  (Version: 5.1.11)

Aftere that I have set the replication in 192.168.2.159(Master) - MySQL Server with another server.

But my replication is skipping some records in slave when I go to and check error log i find the below mentioend error:

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

Could any one assist me in this regard?

Thanks,

Mitul Savani

How to repeat:
Update the query in Master Slave will remain as it is.

Suggested fix:
Looking for suggation to fix this !!

[18 Oct 2006 15:42] Valeriy Kravchuk

This is a documented limitation of cluster. Read http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-limitations.html:

"MySQL Cluster cannot produce a binlog for tables having BLOB columns but no primary key."

[19 Oct 2006 6:02] Mitul Savani

Oh... 

Thanks for your reply. 

Is there any solution for that any alternative?

Thanks,

[19 Oct 2006 6:14] Jonas Oreland

Add an auto increment primary key.

[19 Oct 2006 6:59] Mitul Savani

Yeah that is true and will work fine. but I would like is there more option?

Thanks,

[19 Oct 2006 7:09] Jonas Oreland

Not that I can think of, 
  except ofcourse impl. support and sending us the patch :-)