现在又做了一次task,同步dm-test库到tidb
因为看dm-master中有描述
“metadata will not be used. for Full mode, incremental sync will never occur; for All mode, the meta dumped by MyDumper will be used”
所以用了增量的方式,貌似还是不行
- 这个是上游库
- 下面是下游库
test5-task.yaml
name: test5
task-mode: incremental
is-sharding: false
target-database:
host: tidb.xxx
port: 3306
user: root
password: h46xBDWEdjCj+uy5kJxeMUAB4z4KJDaJG2U=
mysql-instances:
- source-id: mysql-replica-01
meta:
binlog-name: mysql-bin.000005
binlog-pos: 72150
filter-rules: []
route-rules:
- mysql-replica-1.route_rules.1
- mysql-replica-1.route_rules.2
black-white-list: mysql-replica-1.bw_list.1
mydumper-config-name: mysql-replica-1.dump
routes:
mysql-replica-1.route_rules.1:
schema-pattern: dm_test
table-pattern: ""
target-schema: dm_test
target-table: ""
mysql-replica-1.route_rules.2:
schema-pattern: dm_test
table-pattern: t1
target-schema: dm_test
target-table: t1
filters: {}
black-white-list:
mysql-replica-1.bw_list.1:
do-tables:
- db-name: dm_test
tbl-name: t1
do-dbs: []
ignore-tables:
- db-name: drone
tbl-name: builds
- db-name: drone
tbl-name: cron
- db-name: drone
tbl-name: logs
- db-name: drone
tbl-name: migrations
- db-name: drone
tbl-name: nodes
- db-name: drone
tbl-name: perms
- db-name: drone
tbl-name: repos
- db-name: drone
tbl-name: secrets
- db-name: drone
tbl-name: stages
- db-name: drone
tbl-name: stages_unfinished
- db-name: drone
tbl-name: steps
- db-name: drone
tbl-name: users
- db-name: grafana
tbl-name: alert
- db-name: grafana
tbl-name: alert_notification
- db-name: grafana
tbl-name: alert_notification_state
- db-name: grafana
tbl-name: annotation
- db-name: grafana
tbl-name: annotation_tag
- db-name: grafana
tbl-name: api_key
- db-name: grafana
tbl-name: cache_data
- db-name: grafana
tbl-name: dashboard
- db-name: grafana
tbl-name: dashboard_acl
- db-name: grafana
tbl-name: dashboard_provisioning
- db-name: grafana
tbl-name: dashboard_snapshot
- db-name: grafana
tbl-name: dashboard_tag
- db-name: grafana
tbl-name: dashboard_version
- db-name: grafana
tbl-name: data_source
- db-name: grafana
tbl-name: login_attempt
- db-name: grafana
tbl-name: migration_log
- db-name: grafana
tbl-name: org
- db-name: grafana
tbl-name: org_user
- db-name: grafana
tbl-name: playlist
- db-name: grafana
tbl-name: playlist_item
- db-name: grafana
tbl-name: plugin_setting
- db-name: grafana
tbl-name: preferences
- db-name: grafana
tbl-name: quota
- db-name: grafana
tbl-name: server_lock
- db-name: grafana
tbl-name: session
- db-name: grafana
tbl-name: star
- db-name: grafana
tbl-name: tag
- db-name: grafana
tbl-name: team
- db-name: grafana
tbl-name: team_member
- db-name: grafana
tbl-name: temp_user
- db-name: grafana
tbl-name: test_data
- db-name: grafana
tbl-name: user
- db-name: grafana
tbl-name: user_auth
- db-name: grafana
tbl-name: user_auth_token
ignore-dbs: []
mydumpers:
mysql-replica-1.dump:
mydumper-path: bin/mydumper
threads: 4
chunk-filesize: 64
skip-tz-utc: true
extra-args: -T dm_test.t1
通过dmctl执行任务后,查询报错
» start-task /tmp/test5-task.yaml
{
"result": true,
"msg": "",
"workers": [
{
"result": true,
"worker": "10.125.0.34:8262",
"msg": ""
}
]
}
» query-status test5
{
"result": true,
"msg": "",
"workers": [
{
"result": true,
"worker": "10.125.0.34:8262",
"msg": "",
"subTaskStatus": [
{
"name": "test5",
"stage": "Paused",
"unit": "Sync",
"result": {
"isCanceled": false,
"errors": [
{
"Type": "UnknownError",
"msg": "[code=11025:class=functional:scope=internal:level=high] parse relay dir /home/tidb/deploy/relay_log/561d10a3-7614-11e9-8f94-246e96757168.000001 with pos (mysql-bin.000005, 72150): base file mysql-bin.000005 in directory /home/tidb/deploy/relay_log/561d10a3-7614-11e9-8f94-246e96757168.000001 not found
github.com/pingcap/dm/pkg/terror.(*Error).Generate
/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/pkg/terror/terror.go:232
github.com/pingcap/dm/pkg/streamer.CollectBinlogFilesCmp
/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/pkg/streamer/file.go:78
github.com/pingcap/dm/pkg/streamer.(*BinlogReader).parseDirAsPossible
/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/pkg/streamer/reader.go:181
github.com/pingcap/dm/pkg/streamer.(*BinlogReader).parseRelay
/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/pkg/streamer/reader.go:138
github.com/pingcap/dm/pkg/streamer.(*BinlogReader).StartSync.func1
/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/pkg/streamer/reader.go:111
runtime.goexit
/usr/local/go/src/runtime/asm_amd64.s:1337",
"error": null
}
],
"detail": null
},
"unresolvedDDLLockID": "",
"sync": {
"totalEvents": "0",
"totalTps": "0",
"recentTps": "0",
"masterBinlog": "(mysql-bin.000005, 72523)",
"masterBinlogGtid": "561d10a3-7614-11e9-8f94-246e96757168:1-1223157",
"syncerBinlog": "(mysql-bin.000005, 72150)",
"syncerBinlogGtid": "",
"blockingDDLs": [
],
"unresolvedGroups": [
],
"synced": false
}
}
],
"relayStatus": {
"masterBinlog": "(mysql-bin.000005, 72523)",
"masterBinlogGtid": "561d10a3-7614-11e9-8f94-246e96757168:1-1223157",
"relaySubDir": "561d10a3-7614-11e9-8f94-246e96757168.000001",
"relayBinlog": "(, 4)",
"relayBinlogGtid": "",
"relayCatchUpMaster": false,
"stage": "Paused",
"result": {
"isCanceled": false,
"errors": [
{
"Type": "UnknownError",
"msg": "[code=30015:class=relay-unit:scope=upstream:level=high] TCPReader get event: ERROR 1236 (HY000): The slave is connecting using CHANGE MASTER TO MASTER_AUTO_POSITION = 1, but the master has purged binary logs containing GTIDs that the slave requires.
github.com/pingcap/dm/pkg/terror.(*Error).Delegate
/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/pkg/terror/terror.go:267
github.com/pingcap/dm/pkg/binlog/reader.(*TCPReader).GetEvent
/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/pkg/binlog/reader/tcp.go:151
github.com/pingcap/dm/relay/reader.(*reader).GetEvent
/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/relay/reader/reader.go:144
github.com/pingcap/dm/relay.(*Relay).handleEvents
/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/relay/relay.go:378
github.com/pingcap/dm/relay.(*Relay).process
/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/relay/relay.go:292
github.com/pingcap/dm/relay.(*Relay).Process
/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/relay/relay.go:191
github.com/pingcap/dm/dm/worker.(*realRelayHolder).run
/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/dm/worker/relay.go:164
github.com/pingcap/dm/dm/worker.(*realRelayHolder).Start.func1
/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/dm/worker/relay.go:140
runtime.goexit
/usr/local/go/src/runtime/asm_amd64.s:1337",
"error": null
}
],
"detail": null
}
},
"sourceID": "mysql-replica-01"
}
]
}
dm-master日志
[2019/11/13 14:56:38.017 +08:00] [INFO] [server.go:228] [payload="task:"name: test5\
task-mode: incremental\
is-sharding: false\
target-database:\
host: tidb.xxx\
port: 3306\
user: root\
password: h46xBDWEdjCj+uy5kJxeMUAB4z4KJDaJG2U=\
mysql-instances:\
- source-id: mysql-replica-1\
meta:\
binlog-name: mysql-bin.000005\
binlog-pos: 72150\
filter-rules: []\
route-rules:\
- mysql-replica-1.route_rules.1\
- mysql-replica-1.route_rules.2\
black-white-list: mysql-replica-1.bw_list.1\
mydumper-config-name: mysql-replica-1.dump\
routes:\
mysql-replica-1.route_rules.1:\
schema-pattern: dm_test\
table-pattern: \"\"\
target-schema: dm_test\
target-table: \"\"\
mysql-replica-1.route_rules.2:\
schema-pattern: dm_test\
table-pattern: t1\
target-schema: dm_test\
target-table: t1\
filters: {}\
black-white-list:\
mysql-replica-1.bw_list.1:\
do-tables:\
- db-name: dm_test\
tbl-name: t1\
do-dbs: []\
ignore-tables:\
- db-name: drone\
tbl-name: builds\
- db-name: drone\
tbl-name: cron\
- db-name: drone\
tbl-name: logs\
- db-name: drone\
tbl-name: migrations\
- db-name: drone\
tbl-name: nodes\
- db-name: drone\
tbl-name: perms\
- db-name: drone\
tbl-name: repos\
- db-name: drone\
tbl-name: secrets\
- db-name: drone\
tbl-name: stages\
- db-name: drone\
tbl-name: stages_unfinished\
- db-name: drone\
tbl-name: steps\
- db-name: drone\
tbl-name: users\
- db-name: grafana\
tbl-name: alert\
- db-name: grafana\
tbl-name: alert_notification\
- db-name: grafana\
tbl-name: alert_notification_state\
- db-name: grafana\
tbl-name: annotation\
- db-name: grafana\
tbl-name: annotation_tag\
- db-name: grafana\
tbl-name: api_key\
- db-name: grafana\
tbl-name: cache_data\
- db-name: grafana\
tbl-name: dashboard\
- db-name: grafana\
tbl-name: dashboard_acl\
- db-name: grafana\
tbl-name: dashboard_provisioning\
- db-name: grafana\
tbl-name: dashboard_snapshot\
- db-name: grafana\
tbl-name: dashboard_tag\
- db-name: grafana\
tbl-name: dashboard_version\
- db-name: grafana\
tbl-name: data_source\
- db-name: grafana\
tbl-name: login_attempt\
- db-name: grafana\
tbl-name: migration_log\
- db-name: grafana\
tbl-name: org\
- db-name: grafana\
tbl-name: org_user\
- db-name: grafana\
tbl-name: playlist\
- db-name: grafana\
tbl-name: playlist_item\
- db-name: grafana\
tbl-name: plugin_setting\
- db-name: grafana\
tbl-name: preferences\
- db-name: grafana\
tbl-name: quota\
- db-name: grafana\
tbl-name: server_lock\
- db-name: grafana\
tbl-name: session\
- db-name: grafana\
tbl-name: star\
- db-name: grafana\
tbl-name: tag\
- db-name: grafana\
tbl-name: team\
- db-name: grafana\
tbl-name: team_member\
- db-name: grafana\
tbl-name: temp_user\
- db-name: grafana\
tbl-name: test_data\
- db-name: grafana\
tbl-name: user\
- db-name: grafana\
tbl-name: user_auth\
- db-name: grafana\
tbl-name: user_auth_token\
ignore-dbs: []\
mydumpers:\
mysql-replica-1.dump:\
mydumper-path: bin/mydumper\
threads: 4\
chunk-filesize: 64\
skip-tz-utc: true\
extra-args: -T dm_test.t1\
" "] [request=StartTask]
[2019/11/13 14:57:27.718 +08:00] [INFO] [server.go:228] [payload="task:"name: test5\
task-mode: incremental\
is-sharding: false\
target-database:\
host: tidb.xxx\
port: 3306\
user: root\
password: h46xBDWEdjCj+uy5kJxeMUAB4z4KJDaJG2U=\
mysql-instances:\
- source-id: mysql-replica-01\
meta:\
binlog-name: mysql-bin.000005\
binlog-pos: 72150\
filter-rules: []\
route-rules:\
- mysql-replica-1.route_rules.1\
- mysql-replica-1.route_rules.2\
black-white-list: mysql-replica-1.bw_list.1\
mydumper-config-name: mysql-replica-1.dump\
routes:\
mysql-replica-1.route_rules.1:\
schema-pattern: dm_test\
table-pattern: \"\"\
target-schema: dm_test\
target-table: \"\"\
mysql-replica-1.route_rules.2:\
schema-pattern: dm_test\
table-pattern: t1\
target-schema: dm_test\
target-table: t1\
filters: {}\
black-white-list:\
mysql-replica-1.bw_list.1:\
do-tables:\
- db-name: dm_test\
tbl-name: t1\
do-dbs: []\
ignore-tables:\
- db-name: drone\
tbl-name: builds\
- db-name: drone\
tbl-name: cron\
- db-name: drone\
tbl-name: logs\
- db-name: drone\
tbl-name: migrations\
- db-name: drone\
tbl-name: nodes\
- db-name: drone\
tbl-name: perms\
- db-name: drone\
tbl-name: repos\
- db-name: drone\
tbl-name: secrets\
- db-name: drone\
tbl-name: stages\
- db-name: drone\
tbl-name: stages_unfinished\
- db-name: drone\
tbl-name: steps\
- db-name: drone\
tbl-name: users\
- db-name: grafana\
tbl-name: alert\
- db-name: grafana\
tbl-name: alert_notification\
- db-name: grafana\
tbl-name: alert_notification_state\
- db-name: grafana\
tbl-name: annotation\
- db-name: grafana\
tbl-name: annotation_tag\
- db-name: grafana\
tbl-name: api_key\
- db-name: grafana\
tbl-name: cache_data\
- db-name: grafana\
tbl-name: dashboard\
- db-name: grafana\
tbl-name: dashboard_acl\
- db-name: grafana\
tbl-name: dashboard_provisioning\
- db-name: grafana\
tbl-name: dashboard_snapshot\
- db-name: grafana\
tbl-name: dashboard_tag\
- db-name: grafana\
tbl-name: dashboard_version\
- db-name: grafana\
tbl-name: data_source\
- db-name: grafana\
tbl-name: login_attempt\
- db-name: grafana\
tbl-name: migration_log\
- db-name: grafana\
tbl-name: org\
- db-name: grafana\
tbl-name: org_user\
- db-name: grafana\
tbl-name: playlist\
- db-name: grafana\
tbl-name: playlist_item\
- db-name: grafana\
tbl-name: plugin_setting\
- db-name: grafana\
tbl-name: preferences\
- db-name: grafana\
tbl-name: quota\
- db-name: grafana\
tbl-name: server_lock\
- db-name: grafana\
tbl-name: session\
- db-name: grafana\
tbl-name: star\
- db-name: grafana\
tbl-name: tag\
- db-name: grafana\
tbl-name: team\
- db-name: grafana\
tbl-name: team_member\
- db-name: grafana\
tbl-name: temp_user\
- db-name: grafana\
tbl-name: test_data\
- db-name: grafana\
tbl-name: user\
- db-name: grafana\
tbl-name: user_auth\
- db-name: grafana\
tbl-name: user_auth_token\
ignore-dbs: []\
mydumpers:\
mysql-replica-1.dump:\
mydumper-path: bin/mydumper\
threads: 4\
chunk-filesize: 64\
skip-tz-utc: true\
extra-args: -T dm_test.t1\
" "] [request=StartTask]
[2019/11/13 14:57:27.727 +08:00] [INFO] [common.go:109] ["no tables need to sync"] [schema=drone]
[2019/11/13 14:57:27.728 +08:00] [INFO] [common.go:109] ["no tables need to sync"] [schema=grafana]
[2019/11/13 14:57:27.728 +08:00] [INFO] [checker.go:225] ["
************ task test5 checking items ************
mysql_version
mysql_binlog_enable
mysql_binlog_format
mysql_binlog_row_image
source db dump privilege chcker
source db replication privilege chcker
table structure compatibility check
************ task test5 checking items ************"] [unit="task check"]
[2019/11/13 14:57:27.735 +08:00] [INFO] [server.go:237] ["task name"=test5] [task="name: test5
task-mode: incremental
is-sharding: false
ignore-checking-items: []
meta-schema: dm_meta
remove-meta: false
disable-heartbeat: true
enable-heartbeat: false
heartbeat-update-interval: 1
heartbeat-report-interval: 10
timezone: ""
case-sensitive: false
target-database:
host: tidb.xxx
port: 3306
user: root
password: h46xBDWEdjCj+uy5kJxeMUAB4z4KJDaJG2U=
max-allowed-packet: null
mysql-instances:
- source-id: mysql-replica-01
meta:
binlog-name: mysql-bin.000005
binlog-pos: 72150
filter-rules: []
column-mapping-rules: []
route-rules:
- mysql-replica-1.route_rules.1
- mysql-replica-1.route_rules.2
black-white-list: mysql-replica-1.bw_list.1
mydumper-config-name: mysql-replica-1.dump
mydumper:
mydumper-path: bin/mydumper
threads: 4
chunk-filesize: 64
skip-tz-utc: true
extra-args: -T dm_test.t1
mydumper-thread: 0
loader-config-name: ""
loader:
pool-size: 16
dir: ./dumped_data
loader-thread: 0
syncer-config-name: ""
syncer:
meta-file: ""
worker-count: 16
batch: 100
max-retry: 0
auto-fix-gtid: false
enable-gtid: false
disable-detect: false
safe-mode: false
enable-ansi-quotes: false
syncer-thread: 0
online-ddl-scheme: ""
routes:
mysql-replica-1.route_rules.1:
schema-pattern: dm_test
table-pattern: ""
target-schema: dm_test
target-table: ""
mysql-replica-1.route_rules.2:
schema-pattern: dm_test
table-pattern: t1
target-schema: dm_test
target-table: t1
filters: {}
column-mappings: {}
black-white-list:
mysql-replica-1.bw_list.1:
do-tables:
- db-name: dm_test
tbl-name: t1
do-dbs: []
ignore-tables:
- db-name: drone
tbl-name: builds
- db-name: drone
tbl-name: cron
- db-name: drone
tbl-name: logs
- db-name: drone
tbl-name: migrations
- db-name: drone
tbl-name: nodes
- db-name: drone
tbl-name: perms
- db-name: drone
tbl-name: repos
- db-name: drone
tbl-name: secrets
- db-name: drone
tbl-name: stages
- db-name: drone
tbl-name: stages_unfinished
- db-name: drone
tbl-name: steps
- db-name: drone
tbl-name: users
- db-name: grafana
tbl-name: alert
- db-name: grafana
tbl-name: alert_notification
- db-name: grafana
tbl-name: alert_notification_state
- db-name: grafana
tbl-name: annotation
- db-name: grafana
tbl-name: annotation_tag
- db-name: grafana
tbl-name: api_key
- db-name: grafana
tbl-name: cache_data
- db-name: grafana
tbl-name: dashboard
- db-name: grafana
tbl-name: dashboard_acl
- db-name: grafana
tbl-name: dashboard_provisioning
- db-name: grafana
tbl-name: dashboard_snapshot
- db-name: grafana
tbl-name: dashboard_tag
- db-name: grafana
tbl-name: dashboard_version
- db-name: grafana
tbl-name: data_source
- db-name: grafana
tbl-name: login_attempt
- db-name: grafana
tbl-name: migration_log
- db-name: grafana
tbl-name: org
- db-name: grafana
tbl-name: org_user
- db-name: grafana
tbl-name: playlist
- db-name: grafana
tbl-name: playlist_item
- db-name: grafana
tbl-name: plugin_setting
- db-name: grafana
tbl-name: preferences
- db-name: grafana
tbl-name: quota
- db-name: grafana
tbl-name: server_lock
- db-name: grafana
tbl-name: session
- db-name: grafana
tbl-name: star
- db-name: grafana
tbl-name: tag
- db-name: grafana
tbl-name: team
- db-name: grafana
tbl-name: team_member
- db-name: grafana
tbl-name: temp_user
- db-name: grafana
tbl-name: test_data
- db-name: grafana
tbl-name: user
- db-name: grafana
tbl-name: user_auth
- db-name: grafana
tbl-name: user_auth_token
ignore-dbs: []
mydumpers:
mysql-replica-1.dump:
mydumper-path: bin/mydumper
threads: 4
chunk-filesize: 64
skip-tz-utc: true
extra-args: -T dm_test.t1
loaders: {}
syncers: {}
"] [request=StartTask]
[2019/11/13 14:57:27.742 +08:00] [INFO] [server.go:1913] ["wait op log result"] [task=test5] ["operation log ID"=166] [result="meta:<result:true > log:<id:166 task:<op:Start name:"test5" task:"is-sharding = false\
online-ddl-scheme = \"\"\
case-sensitive = false\
name = \"test5\"\
mode = \"incremental\"\
source-id = \"mysql-replica-01\"\
server-id = 101\
flavor = \"mysql\"\
meta-schema = \"dm_meta\"\
remove-meta = false\
disable-heartbeat = true\
heartbeat-update-interval = 1\
heartbeat-report-interval = 10\
enable-heartbeat = false\
timezone = \"\"\
binlog-type = \"local\"\
relay-dir = \"/home/tidb/deploy/relay_log\"\
filter-rules = []\
mapping-rule = []\
mydumper-path = \"bin/mydumper\"\
threads = 4\
chunk-filesize = 64\
skip-tz-utc = true\
extra-args = \"-T dm_test.t1\"\
pool-size = 16\
dir = \"./dumped_data.test5\"\
meta-file = \"\"\
worker-count = 16\
batch = 100\
max-retry = 0\
auto-fix-gtid = false\
enable-gtid = true\
disable-detect = false\
safe-mode = false\
enable-ansi-quotes = false\
log-level = \"info\"\
log-file = \"/home/tidb/deploy/log/dm-worker.log\"\
log-rotate = \"\"\
pprof-addr = \"\"\
status-addr = \"\"\
\
[meta]\
BinLogName = \"mysql-bin.000005\"\
BinLogPos = 72150\
\
[from]\
host = \"10.125.0.49\"\
port = 3306\
user = \"test\"\
password = \"ndzYxh+L/P6hXPTV5ZT+u0B9xziKiNAmTw==\"\
max-allowed-packet = 67108864\
\
[to]\
host = \"tidb.xxx\"\
port = 3306\
user = \"root\"\
password = \"h46xBDWEdjCj+uy5kJxeMUAB4z4KJDaJG2U=\"\
max-allowed-packet = 67108864\
\
[[route-rules]]\
schema-pattern = \"dm_test\"\
table-pattern = \"\"\
target-schema = \"dm_test\"\
target-table = \"\"\
\
[[route-rules]]\
schema-pattern = \"dm_test\"\
table-pattern = \"t1\"\
target-schema = \"dm_test\"\
target-table = \"t1\"\
\
[black-white-list]\
do-dbs = []\
ignore-dbs = []\
\
[[black-white-list.do-tables]]\
db-name = \"dm_test\"\
tbl-name = \"t1\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"drone\"\
tbl-name = \"builds\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"drone\"\
tbl-name = \"cron\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"drone\"\
tbl-name = \"logs\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"drone\"\
tbl-name = \"migrations\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"drone\"\
tbl-name = \"nodes\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"drone\"\
tbl-name = \"perms\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"drone\"\
tbl-name = \"repos\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"drone\"\
tbl-name = \"secrets\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"drone\"\
tbl-name = \"stages\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"drone\"\
tbl-name = \"stages_unfinished\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"drone\"\
tbl-name = \"steps\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"drone\"\
tbl-name = \"users\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"grafana\"\
tbl-name = \"alert\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"grafana\"\
tbl-name = \"alert_notification\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"grafana\"\
tbl-name = \"alert_notification_state\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"grafana\"\
tbl-name = \"annotation\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"grafana\"\
tbl-name = \"annotation_tag\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"grafana\"\
tbl-name = \"api_key\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"grafana\"\
tbl-name = \"cache_data\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"grafana\"\
tbl-name = \"dashboard\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"grafana\"\
tbl-name = \"dashboard_acl\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"grafana\"\
tbl-name = \"dashboard_provisioning\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"grafana\"\
tbl-name = \"dashboard_snapshot\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"grafana\"\
tbl-name = \"dashboard_tag\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"grafana\"\
tbl-name = \"dashboard_version\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"grafana\"\
tbl-name = \"data_source\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"grafana\"\
tbl-name = \"login_attempt\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"grafana\"\
tbl-name = \"migration_log\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"grafana\"\
tbl-name = \"org\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"grafana\"\
tbl-name = \"org_user\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"grafana\"\
tbl-name = \"playlist\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"grafana\"\
tbl-name = \"playlist_item\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"grafana\"\
tbl-name = \"plugin_setting\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"grafana\"\
tbl-name = \"preferences\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"grafana\"\
tbl-name = \"quota\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"grafana\"\
tbl-name = \"server_lock\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"grafana\"\
tbl-name = \"session\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"grafana\"\
tbl-name = \"star\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"grafana\"\
tbl-name = \"tag\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"grafana\"\
tbl-name = \"team\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"grafana\"\
tbl-name = \"team_member\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"grafana\"\
tbl-name = \"temp_user\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"grafana\"\
tbl-name = \"test_data\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"grafana\"\
tbl-name = \"user\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"grafana\"\
tbl-name = \"user_auth\"\
\
[[black-white-list.ignore-tables]]\
db-name = \"grafana\"\
tbl-name = \"user_auth_token\"\
" > ts:1573628247743165775 > "]
[2019/11/13 14:57:28.743 +08:00] [INFO] [server.go:1041] ["update workers of task"] [task=test5] [workers="[10.125.0.34:8262]"]
[2019/11/13 14:57:37.993 +08:00] [INFO] [server.go:497] [payload="name:"test5" "] [request=QueryStatus]
dm-work.log
dm-work (58.6 KB)