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:
None 
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:5.0.50,5.1.22 OS:Any
Assigned to: Assigned Account CPU Architecture:Any
Triage: Triaged: D2 (Serious) / R2 (Low) / E3 (Medium)

[8 Nov 2007 21:28] Alexey Stroganov
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
[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.