Bug #32200 National characters in table/view names and replication
| Submitted: | 8 Nov 2007 21:28 | Modified: | 13 Nov 2007 3:01 |
|---|---|---|---|
| Reporter: | Alexey Stroganov | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: Replication | Severity: | S3 (Non-critical) |
| Version: | 5.0.50,5.1.22 | OS: | Any |
| Assigned to: | Assigned Account | CPU Architecture: | Any |
[8 Nov 2007 21:30]
Alexey Stroganov
Test case for bug
Attachment: rpl_i03.test (application/octet-stream, text), 551 bytes.
[22 Jan 2009 10:35]
Sveta Smirnova
There is related bug #42237. Most likely duplicate.
[23 Jan 2009 12:19]
Valeriy Kravchuk
Bug #42237 was marked as a duplicate of this one.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.057 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.
Description: Replication fail with following errors in slave.err if table/view names contain national characters: 071108 23:47:01 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '/data0/ranger/mysql-enterprise-5.0.50-linux-x86_64-glibc23/mysql-test/var/log/slave-relay-bin.000001' position: 4 071108 23:47:01 [Note] Slave I/O thread: connected to master 'root@127.0.0.1:9306', replication started in log ' FIRST' at position 4 071108 23:47:01 [ERROR] Slave: Error 'Table 'viewdb.initial_v..' doesn't exist' on query. Default database: 'view db'. Query: 'INSERT INTO initial_v. VALUES ('.')', Error_code: 1146 071108 23:47:01 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'master-bin.000001' position 470 071108 23:47:31 [Note] Slave: received end packet from server, apparent master shutdown: 071108 23:47:31 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'master-bin.000001' position 570 071108 23:47:31 [ERROR] Slave I/O thread: error reconnecting to master 'root@127.0.0.1:9306': Error: 'Lost connec tion to MySQL server at 'reading initial communication packet', system error: 111' errno: 2013 retry-time: 1 r etries: 10 071108 23:47:31 [Note] /data0/ranger/mysql-enterprise-5.0.50-linux-x86_64-glibc23/bin/mysqld: Normal shutdown How to repeat: 1. put attached test case to mysql-test/t directory 2. ./mysql-test-run.pl rpl_i03