{"action":"closed","issue":{"url":"https://api.github.com/repos/bucardo/bucardo/issues/171","repository_url":"https://api.github.com/repos/bucardo/bucardo","labels_url":"https://api.github.com/repos/bucardo/bucardo/issues/171/labels{/name}","comments_url":"https://api.github.com/repos/bucardo/bucardo/issues/171/comments","events_url":"https://api.github.com/repos/bucardo/bucardo/issues/171/events","html_url":"https://github.com/bucardo/bucardo/issues/171","id":330037559,"node_id":"MDU6SXNzdWUzMzAwMzc1NTk=","number":171,"title":"Can not sync new table added into the exist sync ","user":{"login":"bingzhao-tc","id":32460906,"node_id":"MDQ6VXNlcjMyNDYwOTA2","avatar_url":"https://avatars2.githubusercontent.com/u/32460906?v=4","gravatar_id":"","url":"https://api.github.com/users/bingzhao-tc","html_url":"https://github.com/bingzhao-tc","followers_url":"https://api.github.com/users/bingzhao-tc/followers","following_url":"https://api.github.com/users/bingzhao-tc/following{/other_user}","gists_url":"https://api.github.com/users/bingzhao-tc/gists{/gist_id}","starred_url":"https://api.github.com/users/bingzhao-tc/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bingzhao-tc/subscriptions","organizations_url":"https://api.github.com/users/bingzhao-tc/orgs","repos_url":"https://api.github.com/users/bingzhao-tc/repos","events_url":"https://api.github.com/users/bingzhao-tc/events{/privacy}","received_events_url":"https://api.github.com/users/bingzhao-tc/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-06-06T21:21:58Z","updated_at":"2018-06-07T20:09:23Z","closed_at":"2018-06-07T20:09:23Z","author_association":"NONE","body":"bucardo version 5.4.1\r\n\r\nadd new table to an exist sync, commands as follow.\r\n\r\n> bucardo add table client001.t0170xxxxxxxxxxxxxxxxx relgroup=table_group\r\n> bucardo update sync the_sync relgroup=table_group dbs=sync_db onetimecopy=2\r\n> bucardo validate all\r\n> bucardo stop\r\n> bucardo start\r\n\r\nFrom log\r\n\r\n> (8535) [Wed Jun  6 17:04:10 2018] KID (the_sync) Set database \"dest_db\" to repeatable read read write\r\n> (8535) [Wed Jun  6 17:04:10 2018] KID (the_sync) Set database \"source_db\" to repeatable read read write\r\n> (8535) [Wed Jun  6 17:04:10 2018] KID (the_sync) For fullcopy, we are using source database \"source_db\"\r\n> (8535) [Wed Jun  6 17:04:10 2018] KID (the_sync) Target table \"dest_db.client001.t0460xxxxxxxxxxxxxxxxx has rows and we are in onetimecopy if empty mode, so we will not COPY\r\n> (8535) [Wed Jun  6 17:04:10 2018] KID (the_sync) Target table \"dest_db.client001.t1600xxxxxxxxxxxxxxxxx\" has rows and we are in onetimecopy if empty mode, so we will not COPY\r\n> (8535) [Wed Jun  6 17:04:10 2018] KID (the_sync) Target table \"dest_db.client001.t0170xxxxxxxxxxxxxxxxx\" has rows and we are in onetimecopy if empty mode, so we will not COPY\r\n> (8535) [Wed Jun  6 17:04:10 2018] KID (the_sync) Target table \"dest_db.client001.t0680xxxxxxxxxxxxxxxxx\" has rows and we are in onetimecopy if empty mode, so we will not COPY\r\n**> (8535) [Wed Jun  6 17:04:10 2018] KID (the_sync) Setting push_rows to fullcopy mode\r\n> Use of uninitialized value in concatenation (.) or string at /usr/share/perl5/vendor_perl/Bucardo.pm line 4657.\r\n> (8535) [Wed Jun  6 17:04:10 2018] KID (the_sync) Total target rows deleted: \r\n> (8535) [Wed Jun  6 17:04:10 2018] KID (the_sync) Total target rows copied: 0**\r\n> (8535) [Wed Jun  6 17:04:10 2018] KID (the_sync) Issuing final commit for all databases\r\n> (8535) [Wed Jun  6 17:04:10 2018] KID (the_sync) All databases committed\r\n> (8535) [Wed Jun  6 17:04:10 2018] KID (the_sync) Total time for sync \"the_sync\" (0 rows, 0 tables): 0.72 seconds\r\n> (8535) [Wed Jun  6 17:04:11 2018] KID (the_sync) Analyze complete for dest_db.client001.t0460xxxxxxxxxxxxxxxxx. Time: 1.82\r\n> (8535) [Wed Jun  6 17:04:12 2018] KID (the_sync) Analyze complete for dest_db.client001.t1600xxxxxxxxxxxxxxxxx Time: 2.37\r\n> (8535) [Wed Jun  6 17:04:12 2018] KID (the_sync) Analyze complete for dest_db.client001.t0170xxxxxxxxxxxxxxxxx. Time: 2.62\r\n> (8535) [Wed Jun  6 17:04:12 2018] KID (the_sync) Analyze complete for dest_db.client001.t0680xxxxxxxxxxxxxxxxx. Time: 2.93\r\n> (8535) [Wed Jun  6 17:04:12 2018] KID (the_sync) Analyze complete for dest_db.client001.t0720xxxxxxxxxxxxxxxxx. Time: 3.04\r\n> (8535) [Wed Jun  6 17:04:13 2018] KID (the_sync) Sending NOTIFY \"ctl_syncdone_the_sync\" (line 4941) skip_commit=0\r\n> (8535) [Wed Jun  6 17:04:13 2018] KID (the_sync) Turning onetimecopy back to 0\r\n> (8535) [Wed Jun  6 17:04:13 2018] KID (the_sync) Kid 8535 exiting at cleanup_kid.  Reason: Normal exit\r\n> (8535) [Wed Jun  6 17:04:13 2018] KID (the_sync) Removed pid file /var/run/bucardo/bucardo.kid.sync.the_sync.pid\r\n> (8532) [Wed Jun  6 17:04:13 2018] CTL Got NOTICE syncdone_the_sync from 8536 (line 2196)\r\n> (8532) [Wed Jun  6 17:04:13 2018] CTL Kid 8536 has reported that sync the_sync is done\r\n> "}}
{"actor":{"display_login":"bingzhao-tc"}}