search

PacktPublishing / -MySQL-8-for-Administrators

MySQL 8 for Administrators, by Packt Publishing
MIT License
11 stars 17 forks source link

Issue in lab4c #2

Closed swaminathanks closed 3 years ago

swaminathanks commented 3 years ago

Hi,

I am facing the following issue while installing lab4c

TASK [Stream backup to target] ***** fatal: [lab4c-db1]: FAILED! => {"changed": true, "cmd": "mysqldump --all-databases --triggers --routines --events --master-data=1 --single-transaction | socat -u - tcp:lab4c-db2:4444", "delta": "0:00:00.245405", "end": "2021-08-19 17:21:29.571576", "msg": "non-zero return code", "rc": 1, "start": "2021-08-19 17:21:29.326171", "stderr": "2021/08/19 17:21:29 socat[8271] E write(5, 0x555aaf71f2a0, 2613): Broken pipe\nmysqldump: Got errno 11 on write", "stderr_lines": ["2021/08/19 17:21:29 socat[8271] E write(5, 0x555aaf71f2a0, 2613): Broken pipe", "mysqldump: Got errno 11 on write"], "stdout": "", "stdout_lines": []}

Regards Swami

swaminathanks commented 3 years ago

On the target side I see the error message below when the mysqldump is executed on the primary. Why is the warning line still there even though we use all the required switches with the command.

Please suggest a solution, Thanks Swami

[vagrant@lab5a-db2 ~]$ socat -u tcp4-listen:4445,reuseaddr stdio | mysql ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WARNING: --master-data is deprecated and will be removed in a future version. Us' at line 1 2021/08/20 12:50:27 socat[7667] E write(1, 0x55c4565b5410, 668): Broken pipe

swaminathanks commented 3 years ago

okay, I changed the value master-data to source-data and it worked fine. I was able to install lab5a successfully. I hope it this will make lab4c also work fine.