Comments - MariaDB Replication Error Number 1366- Incorrect integer value: '\x00' for column 'DB.tablename'.'column' at row 1
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
This error occurs on slave2 .Master and slave1 is working fine
Please check below details.
**** Master *****
mysql> select version(); +-----------------+
+-----------------+
+-----------------+ 1 row in set (0.01 sec)
mysql> SHOW GLOBAL VARIABLES LIKE 'binlog_format'; +---------------+-------+
+---------------+-------+
+---------------+-------+ 1 row in set (0.00 sec)
mysql> SHOW CREATE TABLE geos.cnc_runningtimes; +------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
`StartTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `EndTime` datetime DEFAULT NULL, `IdWorkStation` smallint(5) unsigned DEFAULT NULL, `UnexpectedWorkStationStatus` tinyint(1) NOT NULL DEFAULT '0', `IdCncRunningTime` int(10) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`IdCncRunningTime`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC | +------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec)
**** Master *****
** Slave1 ***** MariaDB [(none)]> select version(); +---------------------+
+---------------------+
+---------------------+ 1 row in set (0.001 sec)
MariaDB [(none)]> SHOW GLOBAL VARIABLES LIKE 'binlog_format'; +---------------+-------+
+---------------+-------+
+---------------+-------+ 1 row in set (0.001 sec)
MariaDB [(none)]> SHOW CREATE TABLE geos.cnc_runningtimes; +------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
`StartTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `EndTime` datetime DEFAULT NULL, `IdWorkStation` smallint(5) unsigned DEFAULT NULL, `UnexpectedWorkStationStatus` tinyint(1) NOT NULL DEFAULT 0, `IdCncRunningTime` int(10) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`IdCncRunningTime`) ) ENGINE=InnoDB AUTO_INCREMENT=262527 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC | +------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.000 sec)
****slave1*******
***** Slave2 *** MariaDB [(none)]> select version(); +---------------------+
+---------------------+
+---------------------+ 1 row in set (0.000 sec)
MariaDB [(none)]> SHOW GLOBAL VARIABLES LIKE 'binlog_format'; +---------------+-------+
+---------------+-------+
+---------------+-------+ 1 row in set (0.003 sec)
MariaDB [(none)]> SHOW CREATE TABLE geos.cnc_runningtimes; +------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
`StartTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `EndTime` datetime DEFAULT NULL, `IdWorkStation` smallint(5) unsigned DEFAULT NULL, `UnexpectedWorkStationStatus` tinyint(1) NOT NULL DEFAULT 0, `IdCncRunningTime` int(10) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`IdCncRunningTime`) ) ENGINE=InnoDB AUTO_INCREMENT=261988 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC | +------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.000 sec) *****slave2*******
Please create a bug report https://jira.mariadb.org
If you have the original INSERT SQL statement that might help, but otherwise don't worry, there aren't that many options to enumerate.