robert-s-lee/arcion-integration

arcion integration with other products

arcion-integration's Issues

generated_sent_date mapped to generated column generated_sent_date

looks like we are erroring out on this line of schema. The setup is at https://github.com/robert-s-lee/arcion-integration/tree/mautic/mautic

generated_sent_date` date GENERATED ALWAYS AS (concat(year(`date_sent`),_utf8mb4'-',lpad(month(`date_sent`),2,_utf8mb4'0'),_utf8mb4'-',lpad(dayofmonth(`date_sent`),2,_utf8mb4'0'))) VIRTUAL COMMENT '(DC2Type:generated)',

message in the error log

2023-02-04 20:57:44.176 DEBUG [main] t.r.d.j.m.MySQLDatabase: io_replicate: fetching table names...
2023-02-04 20:57:44.281 ERROR [main] t.r.Main: Replication error
tech.replicant.ReplicationException: java.lang.IllegalArgumentException: generated_sent_date mapped to generated column generated_sent_date
        at tech.replicant.db.DBReplicationManager.a(SourceFile:3054)
        at tech.replicant.Main.main(SourceFile:50419)
Caused by: java.lang.IllegalArgumentException: generated_sent_date mapped to generated column generated_sent_date
        at tech.replicant.mapper.ColumnMapper.a(SourceFile:118)
        at tech.replicant.mapper.TableMapper.a(SourceFile:546)
        at tech.replicant.mapper.DBMapper.a(SourceFile:739)
        at tech.replicant.mapper.DBMapper.a(SourceFile:597)
        at tech.replicant.mapper.DBMapper.a(SourceFile:548)
        at tech.replicant.db.DBApplier.a(SourceFile:470)
        at tech.replicant.db.DBApplier.a(SourceFile:420)
        at tech.replicant.db.DBSnapshotApplier.a(SourceFile:1360)
        at tech.replicant.db.DBReplicationManager.a(SourceFile:1305)
        at tech.replicant.db.DBReplicationManager.a(SourceFile:1799)
        at tech.replicant.db.DBReplicationManager.a(SourceFile:2984)
        ... 1 common frames omitted

schema

CREATE TABLE `email_stats` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `email_id` int unsigned DEFAULT NULL,
  `lead_id` bigint unsigned DEFAULT NULL,
  `list_id` int unsigned DEFAULT NULL,
  `ip_id` int unsigned DEFAULT NULL,
  `copy_id` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_sent` datetime NOT NULL,
  `is_read` tinyint(1) NOT NULL,
  `is_failed` tinyint(1) NOT NULL,
  `viewed_in_browser` tinyint(1) NOT NULL,
  `date_read` datetime DEFAULT NULL,
  `tracking_hash` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `retry_count` int DEFAULT NULL,
  `source` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `source_id` int DEFAULT NULL,
  `tokens` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  `open_count` int DEFAULT NULL,
  `last_opened` datetime DEFAULT NULL,
  `open_details` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:array)',
  `generated_sent_date` date GENERATED ALWAYS AS (concat(year(`date_sent`),_utf8mb4'-',lpad(month(`date_sent`),2,_utf8mb4'0'),_utf8mb4'-',lpad(dayofmonth(`date_sent`),2,_utf8mb4'0'))) VIRTUAL COMMENT '(DC2Type:generated)',
  PRIMARY KEY (`id`),
  KEY `IDX_CA0A2625A832C1C9` (`email_id`),
  KEY `IDX_CA0A262555458D` (`lead_id`),
  KEY `IDX_CA0A26253DAE168B` (`list_id`),
  KEY `IDX_CA0A2625A03F5E9F` (`ip_id`),
  KEY `IDX_CA0A2625A8752772` (`copy_id`),
  KEY `stat_email_search` (`email_id`,`lead_id`),
  KEY `stat_email_search2` (`lead_id`,`email_id`),
  KEY `stat_email_failed_search` (`is_failed`),
  KEY `is_read_date_sent` (`is_read`,`date_sent`),
  KEY `stat_email_hash_search` (`tracking_hash`),
  KEY `stat_email_source_search` (`source`,`source_id`),
  KEY `email_date_sent` (`date_sent`),
  KEY `email_date_read_lead` (`date_read`,`lead_id`),
  KEY `generated_sent_date_email_id` (`generated_sent_date`,`email_id`),
  CONSTRAINT `FK_CA0A26253DAE168B` FOREIGN KEY (`list_id`) REFERENCES `lead_lists` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_CA0A262555458D` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_CA0A2625A03F5E9F` FOREIGN KEY (`ip_id`) REFERENCES `ip_addresses` (`id`),
  CONSTRAINT `FK_CA0A2625A832C1C9` FOREIGN KEY (`email_id`) REFERENCES `emails` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_CA0A2625A8752772` FOREIGN KEY (`copy_id`) REFERENCES `email_copies` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
/*!