[MDEV-29989] binlog_do_db option breaks importing sql dumps - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.4, 10.5, 10.6, 10.9, 10.10, 10.11
Fix Version/s: 10.4.32, 10.5.23, 10.6.16, 10.10.7, 10.11.6, 11.0.4, 11.1.3
Component/s: Server
Labels:
- regression
Environment:
Debian GNU/Linux 10 (buster)

Description

If you have binlog enabled and binlog_do_db set to some table and then make a mariadb-dump and import the dump to some database different of the one set in binlog_do_db, then all the Innodb tables in that database have no records.

I'm attaching a bash script to demonstrate the problem.
The result from all counts should e 1, but when binlog_do_db is set the result for the innodb table changes.

That behaviour wasn't observed in 10.5 versions. It appeared after upgrade to 10.8.
Cannot report for the versions in between, unfortunately.

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

binlog-do-db-bug.sh
2 kB
2022-11-18 18:51

Issue Links

is duplicated by

MDEV-30834 restoring a dump created by mysqldump doesn't restore table rows if the database is excluded from binary log using binlog_ignore_db option

Closed

MDEV-32442 Tables empty after mysqldump restore when binlog_do_db is set for a different db

Closed

relates to

MDEV-24621 In bulk insert, pre-sort and build indexes one page at a time

Closed

Activity

People

Assignee:: Thirunarayanan Balathandayuthapani

Reporter:: Anton Avramov

Votes:: 1 Vote for this issue

Watchers:: 6 Start watching this issue

Dates

Created:: 2022-11-09 15:04

Updated:: 2023-12-11 12:36

Resolved:: 2023-09-26 05:46

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.