Skip to content
This repository has been archived by the owner on May 10, 2023. It is now read-only.

Blob data failed to replicate #120

Open
udyr-f opened this issue Sep 7, 2019 · 1 comment
Open

Blob data failed to replicate #120

udyr-f opened this issue Sep 7, 2019 · 1 comment

Comments

@udyr-f
Copy link

udyr-f commented Sep 7, 2019

If my mysql field type is blob and I copy the data at the end copy_from will report an error "missing data for column 'xxx'",

@udyr-f
Copy link
Author

udyr-f commented Sep 7, 2019

DROP TABLE IF EXISTS `QRTZ_JOB_DETAILS`;
CREATE TABLE `QRTZ_JOB_DETAILS`  (
  `SCHED_NAME` varchar(120)  NOT NULL,
  `JOB_NAME` varchar(200)  NOT NULL,
  `JOB_GROUP` varchar(200)  NOT NULL,
  `DESCRIPTION` varchar(250)  NULL DEFAULT NULL,
  `JOB_CLASS_NAME` varchar(250)  NOT NULL,
  `IS_DURABLE` varchar(1)  NOT NULL,
  `IS_NONCONCURRENT` varchar(1)  NOT NULL,
  `IS_UPDATE_DATA` varchar(1)  NOT NULL,
  `REQUESTS_RECOVERY` varchar(1)  NOT NULL,
  `JOB_DATA` blob NULL,
  PRIMARY KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) USING BTREE,
  INDEX `IDX_QRTZ_J_REQ_RECOVERY`(`SCHED_NAME`, `REQUESTS_RECOVERY`) USING BTREE,
  INDEX `IDX_QRTZ_J_GRP`(`SCHED_NAME`, `JOB_GROUP`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('1', '1', '1', '1', '1', '1', '1', '1', '1', NULL);

This table will report 'missing data for column "JOB_NAME"'

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant