Re: Error in mysql replication with LOAD DATA INFILE

2010-12-20 Thread Anand Kumar
The application is designed to work such a way that it will process the csv files daily as part of the aggregate process to calculate some metrics. it runs fine on the master, when it come to slave through replicaiton it fails with the error. i even tried upgrading the slave to latest version mys

Re: Error in mysql replication with LOAD DATA INFILE

2010-12-19 Thread Anand Kumar
On Mon, Dec 20, 2010 at 9:00 AM, Anand wrote: > Hi guys, > > i am facing a serious issue with my replication , i tried so many things > but no luck. > > my replication is running with mysql 5.0.51a in master and 5.0.90 in slave. > > we run LOAD DATA INFILE in master to process some csv files and

Re: Error in mysql replication with LOAD DATA INFILE

2010-12-19 Thread Lee Gary
Hi Anand, Just try 'load data local infile',it maybe work. Eric 2010/12/20 Anand : > Hi guys, > > i am facing a serious issue with my replication , i tried so many things but > no luck. > > my replication is running with mysql 5.0.51a in master and 5.0.90 in slave. > > we run LOAD DATA INFILE in

RE: Error in mysql slave server

2007-09-05 Thread Rick James
Things to check: * Packet bigger than my.cnf settings allow. * Memory available to running process happened to be hit (FreeBSD has "memdsiz"). * Network glitch. > -Original Message- > From: Ashok Chauhan [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 04, 2007 12:37 AM > To: mysql@l

Re: error in mysql

2005-07-19 Thread Gleb Paharenko
Hello. You've provided not enough information to give you a good suggestion. Are you connecting through UNIX socket or TCP? Similar behavior is often caused by DNS problems. 4.0.15 is a very old MySQL. Use 4.1.12 (or 4.0.25). What does it mean 'find out any database'? Did you mean that MyS

RE: error in mysql

2005-07-19 Thread PMilanese
I do hope that you understand that this is not a productive post (question?) "Very slow" is a bit vague. What is it that you are trying to do? -Original Message- From: Manish [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 19, 2005 3:20 AM To: mysql@lists.mysql.com Subject: error in mysql

RE: error in mysql using poolman

2001-11-02 Thread felix
d. Any idea? Thanks in advance - Original Message - From: TAKAHASHI, Tomohiro <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 02, 2001 3:43 PM Subject: Re: error in mysql using poolman > HI, > > I think MySQL does not suppor

Re: error in mysql using poolman

2001-11-02 Thread TAKAHASHI, Tomohiro
HI, I think MySQL does not support TransactionIsolationLevel NONE. And, setTransactionIsolation method of 'org.gjt.mm.mysql.Driver' will throw SQL Exception. Because, in that case, driver sends SQL statement 'SET SESSION TRANSACTION ISOLATION LEVEL ;' to MySQL. This SQL statement is wro