Hello.
> `key` varchar(255) character set utf8 collate utf8_bin NOT NULL All your character_set_xxx variables have a 'latin1' value, while the `key` column has utf8. In my opinion, this is the root of the problem. Marco P$hler <[EMAIL PROTECTED]> wrote: >> Please, send the output of the following statement executed both on >> master and slave: >> >> show variables like '%char%'; > > mysql> show global variables like 'c%'; > +--------------------------+----------------------------+ > | Variable_name | Value | > +--------------------------+----------------------------+ > | character_set_client | latin1 | > | character_set_connection | latin1 | > | character_set_database | latin1 | > | character_set_results | latin1 | > | character_set_server | latin1 | > | character_set_system | utf8 | > | character_sets_dir | /usr/share/mysql/charsets/ | > | collation_connection | latin1_swedish_ci | > | collation_database | latin1_swedish_ci | > | collation_server | latin1_swedish_ci | > | concurrent_insert | ON | > | connect_timeout | 5 | > +--------------------------+----------------------------+ > 12 rows in set (0.00 sec) > > The output is identical on both servers. > >> Send the definition of your table as well: >> >> SHOW CREATE TABLE sum_day_key_requests; > > mysql> SHOW CREATE TABLE sum_day_key_requests \G > *************************** 1. row *************************** > Table: sum_day_key_requests > Create Table: CREATE TABLE `sum_day_key_requests` ( > `day` date NOT NULL default '0000-00-00', > `type` varchar(50) character set latin1 collate latin1_bin NOT NULL > default '', > `client` varchar(16) character set latin1 collate latin1_bin NOT NULL > default '', > `channel` varchar(16) character set latin1 collate latin1_bin NOT NULL > default '', > `campaign` varchar(100) character set latin1 collate latin1_bin NOT > NULL default '', > `grouping` varchar(64) character set latin1 collate latin1_bin NOT > NULL default '', > `key` varchar(255) character set utf8 collate utf8_bin NOT NULL > default '', > `afftraf` varchar(5) character set latin1 collate latin1_bin NOT NULL > default '', > `sum` int(10) unsigned NOT NULL default '1', > PRIMARY KEY > (`day`,`type`,`client`,`channel`,`campaign`,`grouping`,`key`,`afftraf`) > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 > 1 row in set (1.05 sec) > > The create statements are identical on both servers. > > I have no more ideas. Should I try to reproduce the error with a smaller > example ? > > Marco > --- > http://www.tuxoo.org > http://www.kontaktlinsen-preisvergleich.de > > > > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
