Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Type mismatch in VALUES section #180

Open
Amixp opened this issue May 22, 2020 · 1 comment
Open

Type mismatch in VALUES section #180

Amixp opened this issue May 22, 2020 · 1 comment

Comments

@Amixp
Copy link

Amixp commented May 22, 2020 •
edited

From log

Expected=8.  Actual=2.  Position: 187.  Data Length: 189
2020-05-22 05:36:29,351/1590125789.351507:CRITICAL:QUERY FAILED
2020-05-22 05:36:29,351/1590125789.351809:CRITICAL:ex=Code: 53. Type mismatch in VALUES section. Repeat query with types_check=True for detailed info. Column itemid: required argument is not an integer
2020-05-22 05:36:29,351/1590125789.351931:CRITICAL:sql=INSERT INTO `zabbix_i88`.`history_uint` (`itemid`, `clock`, `value`, `ns`) VALUES
2020-05-22 05:37:30,412/1590125850.412596:WARNING:Got an exception, skip it in blocking mode
2020-05-22 05:37:30,413/1590125850.413086:WARNING:Result length not requested length:
Expected=8.  Actual=2.  Position: 187.  Data Length: 189
2020-05-22 05:37:31,451/1590125851.451168:WARNING:Got an exception, skip it in blocking mode
2020-05-22 05:37:31,451/1590125851.451454:WARNING:Result length not requested length:
Expected=4.  Actual=2.  Position: 8212.  Data Length: 8214
2020-05-22 05:37:32,814/1590125852.814633:CRITICAL:QUERY FAILED
2020-05-22 05:37:32,815/1590125852.815046:CRITICAL:ex=Code: 53. Type mismatch in VALUES section. Repeat query with types_check=True for detailed info. Column itemid: required argument is not an integer
2020-05-22 05:37:32,815/1590125852.815285:CRITICAL:sql=INSERT INTO `zabbix_i88`.`history_uint` (`itemid`, `clock`, `value`, `ns`) VALUES
2020-05-22 05:38:33,900/1590125913.900565:WARNING:Got an exception, skip it in blocking mode
2020-05-22 05:38:33,900/1590125913.900909:WARNING:Result length not requested length:
Expected=4.  Actual=2.  Position: 8212.  Data Length: 8214
2020-05-22 05:38:34,910/1590125914.910961:WARNING:Got an exception, skip it in blocking mode
2020-05-22 05:38:34,911/1590125914.911283:WARNING:Result length not requested length:
Expected=8.  Actual=1.  Position: 813.  Data Length: 814
2020-05-22 05:38:35,985/1590125915.985317:WARNING:Got an exception, skip it in blocking mode
2020-05-22 05:38:35,985/1590125915.985610:WARNING:Result length not requested length:
Expected=8.  Actual=2.  Position: 8212.  Data Length: 8214
2020-05-22 05:38:37,382/1590125917.382241:CRITICAL:QUERY FAILED
2020-05-22 05:38:37,382/1590125917.382560:CRITICAL:ex=Code: 53. Type mismatch in VALUES section. Repeat query with types_check=True for detailed info. Column itemid: required argument is not an integer
2020-05-22 05:38:37,382/1590125917.382715:CRITICAL:sql=INSERT INTO `zabbix_i88`.`history_uint` (`itemid`, `clock`, `value`, `ns`) VALUES
2020-05-22 05:39:38,443/1590125978.443542:WARNING:Got an exception, skip it in blocking mode
2020-05-22 05:39:38,443/1590125978.443890:WARNING:Result length not requested length:
Expected=8.  Actual=2.  Position: 8212.  Data Length: 8214
2020-05-22 05:39:39,462/1590125979.462185:WARNING:Got an exception, skip it in blocking mode
2020-05-22 05:39:39,462/1590125979.462625:WARNING:Result length not requested length:
Expected=4.  Actual=2.  Position: 812.  Data Length: 814
2020-05-22 05:39:40,536/1590125980.536540:WARNING:Got an exception, skip it in blocking mode
2020-05-22 05:39:40,536/1590125980.536929:WARNING:Result length not requested length:
Expected=4.  Actual=2.  Position: 8212.  Data Length: 8214
2020-05-22 05:39:41,932/1590125981.932213:CRITICAL:QUERY FAILED
2020-05-22 05:39:41,932/1590125981.932589:CRITICAL:ex=Code: 53. Type mismatch in VALUES section. Repeat query with types_check=True for detailed info. Column itemid: required argument is not an integer
2020-05-22 05:39:41,932/1590125981.932733:CRITICAL:sql=INSERT INTO `zabbix_i88`.`history_uint` (`itemid`, `clock`, `value`, `ns`) VALUES
2020-05-22 05:40:43,056/1590126043.056870:WARNING:Got an exception, skip it in blocking mode
2020-05-22 05:40:43,057/1590126043.057307:WARNING:Result length not requested length:
Expected=4.  Actual=2.  Position: 8212.  Data Length: 8214
2020-05-22 05:40:44,073/1590126044.073156:WARNING:Got an exception, skip it in blocking mode
2020-05-22 05:40:44,073/1590126044.073462:WARNING:Result length not requested length:
Expected=4.  Actual=2.  Position: 812.  Data Length: 814
2020-05-22 05:40:45,141/1590126045.141290:WARNING:Got an exception, skip it in blocking mode
2020-05-22 05:40:45,141/1590126045.141573:WARNING:Result length not requested length:
Expected=4.  Actual=2.  Position: 8212.  Data Length: 8214
2020-05-22 05:40:46,519/1590126046.519466:CRITICAL:QUERY FAILED
2020-05-22 05:40:46,519/1590126046.519791:CRITICAL:ex=Code: 53. Type mismatch in VALUES section. Repeat query with types_check=True for detailed info. Column itemid: required argument is not an integer
2020-05-22 05:40:46,519/1590126046.519940:CRITICAL:sql=INSERT INTO `zabbix_i88`.`history_uint` (`itemid`, `clock`, `value`, `ns`) VALUES

From binlog (this sample position)

/*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/;
BEGIN
/*!*/;
# at 90742723
#200522  4:05:37 server id 1  end_log_pos 90742790 CRC32 0xaea15f3c     Table_map: `zabbix_i88`.`history_uint` mapped to number 3568
# at 90742790
#200522  4:05:37 server id 1  end_log_pos 90742978 CRC32 0xebdfe8cd     Write_rows: table id 3568
# at 90742978
#200522  4:05:37 server id 1  end_log_pos 90743116 CRC32 0x563c8236     Write_rows: table id 3568 flags: STMT_END_F
### Extra row info for partitioning: partition: 31
### INSERT INTO `zabbix_i88`.`history_uint`
### SET
###   @1=31109 /* LONGINT meta=0 nullable=0 is_null=0 */
###   @2=1590075509 /* INT meta=0 nullable=0 is_null=0 */
###   @3=2693000000 /* LONGINT meta=0 nullable=0 is_null=0 */
###   @4=603240000 /* INT meta=0 nullable=0 is_null=0 */
### INSERT INTO `zabbix_i88`.`history_uint`
### SET
###   @1=31109 /* LONGINT meta=0 nullable=0 is_null=0 */
###   @2=1590079109 /* INT meta=0 nullable=0 is_null=0 */
###   @3=2693000000 /* LONGINT meta=0 nullable=0 is_null=0 */
###   @4=314724351 /* INT meta=0 nullable=0 is_null=0 */
### INSERT INTO `zabbix_i88`.`history_uint`
### SET
###   @1=31109 /* LONGINT meta=0 nullable=0 is_null=0 */
###   @2=1590082709 /* INT meta=0 nullable=0 is_null=0 */
###   @3=2693000000 /* LONGINT meta=0 nullable=0 is_null=0 */
###   @4=818740007 /* INT meta=0 nullable=0 is_null=0 */
### INSERT INTO `zabbix_i88`.`history_uint`
### SET
###   @1=31109 /* LONGINT meta=0 nullable=0 is_null=0 */
###   @2=1590086309 /* INT meta=0 nullable=0 is_null=0 */
###   @3=2693000000 /* LONGINT meta=0 nullable=0 is_null=0 */
###   @4=254728503 /* INT meta=0 nullable=0 is_null=0 */
### INSERT INTO `zabbix_i88`.`history_uint`
### SET
###   @1=31109 /* LONGINT meta=0 nullable=0 is_null=0 */
###   @2=1590089909 /* INT meta=0 nullable=0 is_null=0 */
###   @3=2693000000 /* LONGINT meta=0 nullable=0 is_null=0 */
###   @4=219237073 /* INT meta=0 nullable=0 is_null=0 */

Config file

log_file=/var/log/clickhouse-mysql/main.log
log_level=WARNING
nice_pause=1  #пауза в сек. между попытками чтения binlog
#dry=yes
daemon=False
pid_file=/var/run/clickhouse-client.pid
binlog_position_file=/var/log/clickhouse-mysql/clickhouse-mysql-binlog.pos

mempool=yes
mempool_max_events_num=10000
mempool_max_rows_num=1000
mempool_max_flush_interval=5
csvpool=no
csvpool_file_path_prefix=/tmp/clickhouse-mysql/zbx__
csvpool_keep_files=no

#migrate_table=yes
#Copy existing data from MySQL table(s) with SELECT statement
#Binlog is not read during this procedure - just copy data from the src table(s). 

pump_data=yes
#Use in combination with --src-wait in case would like to continue and wait for new rows 
src_wait=yes
src_resume=yes # продолжить репликацию если задан binlog_position_file

#
# src section
#
src_server_id=1
src_host=172.31.135.38
src_port=3306
src_user="reader"
src_password="**************8"
src_schemas="zabbix_i88"
src_tables=history_log,history,history_str,history_text,history_uint,trends,trends_uint

#src_file=
#src_binlog_file=mysql-bin.000001 #стартовая позиция binlog, если не задан - берется из binlog_position_file
#src_binlog_position=28579794

#
# dst section
#
dst_host=172.*******
dst_port=9000
dst_user="zabbix"
dst_password="***********#"
dst_schema="zabbix_i88"
dst_create_table=no
dst_table_prefix=""

create table history_uint
(
	itemid bigint unsigned not null,
	clock int default 0 not null,
	value bigint unsigned default 0 not null,
	ns int default 0 not null
);
create index history_uint_1
	on history_uint (itemid, clock);
@Amixp
Copy link
Author

Amixp commented Oct 5, 2020

I need help for hard fix types in queries

@Amixp Amixp changed the title Type mismatch in VALUES section Type mismatch in VALUES section #help Oct 5, 2020
@Amixp Amixp changed the title Type mismatch in VALUES section #help Type mismatch in VALUES section Oct 5, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@Amixp