Bug #22889 Relay bin log file corruption: not properly escaped Null character
| Submitted: | 2 Oct 2006 12:19 | Modified: | 16 Oct 2006 8:59 |
|---|---|---|---|
| Reporter: | Sveta Smirnova | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server: Replication | Severity: | S3 (Non-critical) |
| Version: | 4.0.25-standard-log | OS: | Linux (Linux) |
| Assigned to: | Mats Kindahl | CPU Architecture: | Any |
[2 Oct 2006 12:19]
Sveta Smirnova
[2 Oct 2006 16:59]
Andrei Elkin
I would not claim the bug is about replication until the customer provides a necessary part for analysis: the original binlog which makes impossible to compare an existed in the report relay-log, containing an offending query, with the correct one.
[13 Oct 2006 12:26]
Lars Thalmann
Active support ended 30 Oct 2006 for MySQL 4.0. This bug should be fixed in 4.1 and upwards.
[16 Oct 2006 8:59]
Mats Kindahl
It's not possible to repeat the failure since we don't know where the query went bad in the following chain: - Query entered through JDBC interface with a string containing '\\0' - Query sent to server by JDBC - Query executed by server - Query written to binary log - Query sent to slave by dump thread - Query written to relay log by I/O thread: the query now contain a NUL character I suspect a combination of the following: - The quoting is not handled properly somewhere in the chain - The query is not checked syntactically somewhere in the chain, hence the query is logged into the relay log in some form - The query is read from the relay log in a form that can be executed - The problem is visible only when inspecting the relay log directly, or when using mysqlbinlog
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.055 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.