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
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