search

mydumper / mydumper_docs

GNU Affero General Public License v3.0
1 stars 0 forks source link

Does the parameters 'use savepoints' and 'less locking' conflict? #1

Open flyingonthebed opened 1 month ago

flyingonthebed commented 1 month ago

OS Version： Ubuntu 22.04.3 LTS (GNU/Linux 6.5.0-1022-aws x86_64) MySQL Version： Oracle MySQL 8.0.28 Mydumper Version：v0.16.5-1

Cmd:
mydumper -h xxx -P 3306 -u xxx -p 'xxx' -o /xxx/date '+%Y_%m_%d-%H:%M' --regex '^(?!(mysql.|sys.|performance_schema.))' -c -t 3 -v 3 --use-savepoints --less-locking --rows 100000 -F 512 -G -R -E --views-as-tables -e -L /tmp/logic_backup.log

Situation description： When I perform a logical backup, the log will output "[ERROR] - Rollback to savepoint failed: SAVEPOINT mydumper does not exist"。

So， does the parameters 'use savepoints' and 'less locking' conflict?

davidducos commented 1 month ago

Hi @flyingonthebed , we might need to review --use-savepoints one more time to see if it is not broken again.

davidducos commented 1 month ago

OH! @flyingonthebed you are in the wrong repo, this should be reported on https://github.com/mydumper/mydumper/, only documentation issues should be reported in this repo.