> 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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
