[MDEV-6753] MariaDB 10.0.13 reports malformed/wrong table name at the replication error message Created: 2014-09-18 Updated: 2022-09-12 Resolved: 2022-09-12 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | OTHER |
| Affects Version/s: | 10.0.13 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Minor |
| Reporter: | Stoykov (Inactive) | Assignee: | Unassigned |
| Resolution: | Won't Fix | Votes: | 0 |
| Labels: | upstream | ||
| Environment: |
CentOS 6 |
||
| Description |
|
On replication failure, the error message contains malformed/wrong table name as seen bellow: [ERROR] Slave SQL: Query caused different errors on master and slave. Error on master: message (format)='Tablespace for table '%-.192s' exists. |
| Comments |
| Comment by Elena Stepanova [ 2014-09-18 ] |
|
It was an intentional change in MySQL, the key word here is "(format)".
|
| Comment by Elena Stepanova [ 2014-09-22 ] |
|
Please comment to re-open if you disagree. |
| Comment by Simon J Mudd [ 2014-09-22 ] |
|
Hi. I agree this is not a bug per se but the message is confusing as presented, but again triggered by an upstream problem. That said I´d like to see this shown differently to make it much clearer what the problem is and where it comes from. So I´d suggest the following: (1) make this report the different error messages on different lines, this makes the huge “blob of an error message” easier to read. An example below (reformatted) but with the SQL munged somewhat to protect the innocent looks much easier to understand: 140917 21:30:04 [ERROR] Slave SQL: Query caused different errors on master and slave. Replace any format values with something like VALUE_FROM_MASTER_UNKNOWN. |
| Comment by Sergei Golubchik [ 2022-09-12 ] |
|
10.0 was EOLed in March 2019 |