MySQL Forums
Forum List  »  NDB clusters

Got error 121 when reading table
Posted by: Ghenadie Zvizdenco
Date: May 02, 2017 02:50AM

Hello,

Random error on a mysql NDB cluster mysqld node. Mysql Version:5.7.16-ndb-7.5.4

perror gives:
OS error code 121: Remote I/O error
MySQL error code 121: Duplicate key on write or update

The table has no foreign key. The table DDL is similar to:
CREATE TABLE "T" (
"C1" varchar(15) NOT NULL DEFAULT '',
"C2" decimal(8,0) NOT NULL DEFAULT '0',
"C3" decimal(8,0) NOT NULL DEFAULT '0',
"C4" varchar(30) NOT NULL DEFAULT '',
"C5" varchar(5) NOT NULL DEFAULT '',
"C6" date NOT NULL DEFAULT '0000-00-00',
"C7" varchar(5) DEFAULT NULL,
"C8" varchar(5) DEFAULT NULL,
"C9" date DEFAULT NULL,
PRIMARY KEY ("C1","C2","C3","C4","C5","C6")
) ENGINE=ndbcluster DEFAULT CHARSET=latin1

Am I missing something?

Options: ReplyQuote


Subject
Views
Written By
Posted
Got error 121 when reading table
282
May 02, 2017 02:50AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.