Hi, I'm running a 2-node cluster with MySQL 5.0.18 on two Solaris 10 boxes - call them sun3 and sun5.
Each server is running as a storage node (i.e. ndbd) and a MySQL server node (mysqld). I created the cluster by converting an existing database from MyISAM engine type to "ndbcluster". sun3 hosted the original DB, i.e. I set up clustering, created an empty DB on sun5, then changed the table type of the tables in the DB on sun3 so they replicated across. Did some testing - update on sun3-> change visible on sun5, and vice versa. Then we found that some queries failed on sun3 in some circumstances. This is the query that failed and the error message: update suyx_user set lastname = 'testname' where firstname= 'test'; Error code: 1296 Got error 744 'Character string is invalid for given character set' from ndbcluster Here's a summary of what worked and what didn't: MySQL client on sun3 -> sun3 - Yes MySQL client on remote machine -> sun3 - No GUI client on remote machine -> sun3 - No MySQL client on sun5 -> sun5 - Yes MySQL client on remote machine -> sun5 - Yes GUI client on remote machine -> sun5 - Yes As far as I can make out, both sun boxes are installed identically (I installed + configured mySQL but not the OS) Anyone got any ideas what might be causing these queries to fail? Thanks, R. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
