Thank you for your answer in previous my question.
Sorry I have another question about replicator.
MySQL extractor got an error 'Unable to retrieve column metadata'.
Extractor works just after execute 'trepctl online', but this error occurs about half a day later.
2021/10/08 01:49:44.690 | mysvc-tungsten-extraction-dev | [mysvc - Thread-262] INFO commands.FileDeleteTask File deleted: /opt/continuent/relay/mysvc/mysql-bin-changelog.189126
2021/10/08 01:54:44.649 | mysvc-tungsten-extraction-dev | [mysvc - Relay Client - mysvc] INFO extractor.mysql.RelayLogClient Closing relay log: name=/opt/continuent/relay/mysvc/mysql-bin-changelog.189135 bytes=568
2021/10/08 01:54:44.649 | mysvc-tungsten-extraction-dev | [mysvc - Relay Client - mysvc] INFO extractor.mysql.RelayLogClient Rotating to new relay log: name=/opt/continuent/relay/mysvc/mysql-bin-changelog.189136
2021/10/08 01:54:44.649 | mysvc-tungsten-extraction-dev | [mysvc - Relay Client - mysvc] INFO extractor.mysql.RelayLogClient Opening relay log: name=/opt/continuent/relay/mysvc/mysql-bin-changelog.189136
2021/10/08 01:54:44.649 | mysvc-tungsten-extraction-dev | [mysvc - Relay Client - mysvc] INFO extractor.mysql.RelayLogClient Adding relay log to binlog index: /opt/continuent/relay/mysvc/mysql-bin-changelog.index
2021/10/08 01:54:44.749 | mysvc-tungsten-extraction-dev | [mysvc - binlog-to-q-0] INFO extractor.mysql.MySQLExtractor Checking for old relay log files...
2021/10/08 01:54:44.749 | mysvc-tungsten-extraction-dev | [mysvc - Thread-263] INFO commands.FileDeleteTask File deleted: /opt/continuent/relay/mysvc/mysql-bin-changelog.189127
2021/10/08 01:59:45.320 | mysvc-tungsten-extraction-dev | [mysvc - Relay Client - mysvc] INFO extractor.mysql.RelayLogClient Closing relay log: name=/opt/continuent/relay/mysvc/mysql-bin-changelog.189136 bytes=568
2021/10/08 01:59:45.320 | mysvc-tungsten-extraction-dev | [mysvc - Relay Client - mysvc] INFO extractor.mysql.RelayLogClient Rotating to new relay log: name=/opt/continuent/relay/mysvc/mysql-bin-changelog.189137
2021/10/08 01:59:45.320 | mysvc-tungsten-extraction-dev | [mysvc - Relay Client - mysvc] INFO extractor.mysql.RelayLogClient Opening relay log: name=/opt/continuent/relay/mysvc/mysql-bin-changelog.189137
2021/10/08 01:59:45.320 | mysvc-tungsten-extraction-dev | [mysvc - Relay Client - mysvc] INFO extractor.mysql.RelayLogClient Adding relay log to binlog index: /opt/continuent/relay/mysvc/mysql-bin-changelog.index
2021/10/08 01:59:45.320 | mysvc-tungsten-extraction-dev | [mysvc - binlog-to-q-0] INFO extractor.mysql.MySQLExtractor Checking for old relay log files...
2021/10/08 01:59:45.320 | mysvc-tungsten-extraction-dev | [mysvc - Thread-264] INFO commands.FileDeleteTask File deleted: /opt/continuent/relay/mysvc/mysql-bin-changelog.189128
2021/10/08 02:01:46.178 | mysvc-tungsten-extraction-dev | [mysvc - binlog-to-q-0] ERROR pipeline.SingleThreadStageTask Stage task failed: stage=binlog-to-q seqno=310 fragno=0
2021/10/08 02:01:46.178 | com.continuent.tungsten.replicator.ReplicatorException: Unable to retrieve column metadata: schema=mydb table=mytable
2021/10/08 02:01:46.178 | at com.continuent.tungsten.replicator.filter.ColumnNameFilter.getColumnInformation(ColumnNameFilter.java:266)
2021/10/08 02:01:46.178 | at com.continuent.tungsten.replicator.filter.ColumnNameFilter.filter(ColumnNameFilter.java:153)
2021/10/08 02:01:46.178 | at com.continuent.tungsten.replicator.pipeline.SingleThreadStageTask.runTask(SingleThreadStageTask.java:459)
2021/10/08 02:01:46.178 | at com.continuent.tungsten.replicator.pipeline.SingleThreadStageTask.run(SingleThreadStageTask.java:183)
2021/10/08 02:01:46.178 | at java.lang.Thread.run(Thread.java:748)
2021/10/08 02:01:46.178 | mysvc-tungsten-extraction-dev | [mysvc - binlog-to-q-0] INFO pipeline.SingleThreadStageTask Performing emergency rollback of applied changes
2021/10/08 02:01:46.178 | mysvc-tungsten-extraction-dev | [mysvc - binlog-to-q-0] INFO pipeline.SingleThreadStageTask Dispatching error event: Stage task failed: stage=binlog-to-q seqno=310 fragno=0
2021/10/08 02:01:46.178 | mysvc-tungsten-extraction-dev | [mysvc - binlog-to-q-0] INFO pipeline.SingleThreadStageTask Terminating processing for stage task thread
2021/10/08 02:01:46.178 | mysvc-tungsten-extraction-dev | [mysvc - binlog-to-q-0] INFO pipeline.SingleThreadStageTask Last successfully processed event prior to termination: seqno=310 eventid=mysql-bin-changelog.189137:0000000000000728;-1
2021/10/08 02:01:46.178 | mysvc-tungsten-extraction-dev | [mysvc - binlog-to-q-0] INFO pipeline.SingleThreadStageTask Task event count: 311
2021/10/08 02:01:46.178 | mysvc-tungsten-extraction-dev | [mysvc - pool-2-thread-1] ERROR management.OpenReplicatorManager Received error notification, shutting down services :The db and table in the error is not the target of replication.
Results of tpm reverse are the below.
$ tpm reverse
# Installed from tungsten@myservice-tungsten-extraction:/opt/continuent/software/tungsten-replicator-for-mysql-extractor-6.1.13-45
# Configuration built from /etc/tungsten/tungsten.ini
# Defaults for all data services and hosts
tools/tpm configure defaults \
--auto-recovery-max-attempts=10 \
--disable-security-controls=true \
--install-directory=/opt/continuent \
--mysql-allow-intensive-checks=true \
'--profile-script=~/.bash_profile' \
--skip-validation-check=InstallerMasterSlaveCheck \
--skip-validation-check=MySQLBinaryLogsEnabledCheck \
--skip-validation-check=MySQLMyISAMCheck \
--skip-validation-check=MySQLPermissionsCheck \
--skip-validation-check=RowBasedBinaryLoggingCheck \
--user=tungsten
# Options for the myservice data service
tools/tpm configure myservice \
--master=myservice-tungsten-extraction \
--members=myservice-tungsten-extraction
# Options for myservice-tungsten-extraction
tools/tpm configure --hosts=myservice-tungsten-extraction \
--java-mem-size=3072 \
--rmi-port=10001
# Options for myservice-tungsten-extraction
tools/tpm configure myservice \
--hosts=myservice-tungsten-extraction \
--datasource-mysql-conf=/dev/null \
--enable-heterogeneous-service=true \
--privileged-master=false \
--property=replicator.filter.pkey.addColumnsToDeletes=true \
--property=replicator.filter.pkey.addPkeyToInserts=true \
--property=replicator.service.comments=true \
--replication-password=XXXXXXXXX \
--replication-user=myuser \
--svc-extractor-filters=dropcatalogdata,replicate,colnames,pkey \
--thl-log-retention=7d \
--thl-port=2112
Thanks