Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND
Hello ,
We have faced two times below error on our galera cluster system . Please help us,
Error Details :
Could not execute Update_rows event on table joygame.kingdom.kingdom_userBase; Can't find record
in 'kingdom_userBase', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log FIRST, end_log_pos 395, Error_code: 1032
kingdom_userBase table script:
CREATE TABLE `kingdom_userBase` (
`UserID` bigint(20) NOT NULL,
`UserName` varchar(45) NOT NULL,
`Password` char(32) NOT NULL,
`Email` varchar(50) NOT NULL,
`Games` bigint(20) DEFAULT NULL,
`Segments` bigint(20) DEFAULT NULL,
`AvatarHash` char(6) DEFAULT NULL,
`LastLogin` bigint(20) NOT NULL,
`IsActive` bit(1) NOT NULL DEFAULT b'1',
`CreateDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`UpdateDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`UserID`),
UNIQUE KEY `IX_UserName` (`UserName`),
KEY `IX_Email` (`Email`),
KEY `IX_LastLogin` (`LastLogin`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
And you can find our system some variables below :
version : 5.6.15-56
version_comment : Percona XtraDB Cluster (GPL), Release 25.5, Revision 759, wsrep_25.5.r4061
version_compile_machine : x86_64
version_compile_os : Linux
wsrep_sst_method : xtrabackup-v2
Best Regards,
-
Hi,
Can you please create a support ticket and attach the output from :
http://support.severalnines.com/entries/21091498-Error-reporting-
What update statement are you executing causing this?
Is happening after node recovery ?
BR
johan
Please sign in to leave a comment.
Comments
1 comment