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

Error in mysql replication with LOAD DATA INFILE

2010-12-19 Thread 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 master to process some csv files and load it into a table, it runs perfectly well in master but wh

RE: Error in mysql slave server

2007-09-05 Thread Rick James
2:37 AM > To: mysql@lists.mysql.com; [EMAIL PROTECTED] > Subject: Error in mysql slave server > > Hi All, > > I'm using Mysql 5 (with replication) on CentOS 4.4 OS with 2 > CPU and 8GB > of RAM. > Master & Slave servers have same hardware configration. >

Error in mysql slave server

2007-09-04 Thread Ashok Chauhan
Hi All, I'm using Mysql 5 (with replication) on CentOS 4.4 OS with 2 CPU and 8GB of RAM. Master & Slave servers have same hardware configration. Yesterday my master server, suddenly not established new connections. i checked the log of master server there is no error, then i checked the log of sl

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

error in mysql

2005-07-19 Thread Manish
Hi, I have installed linux 9 with mysql-standard-4.0.15-pc-linux-i686.. mysql responding very slow when i request to find out any database its took long time to respons... plz help me Manish Popli - Fiorano Ma

RE: Strange Error in MySQL

2005-05-10 Thread Jay Blanchard
[snip] Hello. Yes, there are. In fact, other records have more data for this field in them and inserts for those records never threw an error. [/snip] Is the data for the other fields larger than usual? This field may be smaller, but the cumulative row length (the combined size of every field) is

RE: Strange Error in MySQL

2005-05-10 Thread Asad Habib
Hello. Yes, there are. In fact, other records have more data for this field in them and inserts for those records never threw an error. - Asad On Tue, 10 May 2005, Jay Blanchard wrote: > [snip] > Hello. I am receiving the following error when trying to insert into a > field of type text: > > #1

Re: Strange Error in MySQL

2005-05-10 Thread Jigal van Hemert
> #1030 - Got error 139 from storage engine > > The data to be inserted should fit easily into a text field. In fact, this > error only occurs for a particular record and other records with much > larger data sets are not throwing the same error. Has anyone experienced > something similar? I checke

RE: Strange Error in MySQL

2005-05-10 Thread Jay Blanchard
[snip] Hello. I am receiving the following error when trying to insert into a field of type text: #1030 - Got error 139 from storage engine The data to be inserted should fit easily into a text field. In fact, this error only occurs for a particular record and other records with much larger data

Strange Error in MySQL

2005-05-10 Thread Asad Habib
Hello. I am receiving the following error when trying to insert into a field of type text: #1030 - Got error 139 from storage engine The data to be inserted should fit easily into a text field. In fact, this error only occurs for a particular record and other records with much larger data sets ar

Correlated Subquery Error in MySQL 4.1.1-alpha

2004-03-24 Thread Ed Smith
Consider the following schema and data: CREATE TABLE person (pid INTEGER, name CHAR(5)); CREATE TABLE phone (pid INTEGER, num CHAR(10)); INSERT INTO PERSON VALUES (1, 'Bob'); INSERT INTO PERSON VALUES (2, 'Jane'); INSERT INTO PHONE VALUES (1, '12345'); INSERT INTO PHONE VALUES (1, '23456'); INSER

Re: Client doesn't support authentication protocol error in MySQL

2004-03-21 Thread Paul DuBois
At 18:40 -0500 3/21/04, Marvin Cummings wrote: Wondering if anyone running MySQL 5 has come across the following error: Error (1250) : Client does not support authentication protocol requested by server; consider upgrading MySQL client I get this error after attempting to install PN on a Wind

Client doesn't support authentication protocol error in MySQL

2004-03-21 Thread Marvin Cummings
Wondering if anyone running MySQL 5 has come across the following error: Error (1250) : Client does not support authentication protocol requested by server; consider upgrading MySQL client I get this error after attempting to install PN on a Windows 2003 web server. I've already created t

Spelling error in "MySQL Reference Manual"

2003-06-15 Thread Arthur Albano
I didn't know where to send this, so I'm sending it anyway. --- Spelling error in "MySQL Reference Manual" Where it reads: "Portugise error messages." Should read: "Portuguese error messages." Where it reads: "A Portugese mailing list" Shoul

Memory allocation error in MySQL

2002-12-21 Thread Bruno Batarelo
Greetings Recently I have a great problem. My whole project depends on it and some people are not satisfied with my aplication because of it. I use database for storing into InnoDB tables word documents into BLOBs, and some other information about docs into standard column types. However, after a

Error in mysql-4.0.4-BETA/sql/handler.h

2002-10-15 Thread Gelu Gogancea
Hi, In ./sql/handler.h in line of code no. 297 the right declaration for optimize() function is : virtual int optimize(THD* thd,HA_CHECK_OPT* check_opt); This was find it in MYSQL 4.0.4 Linux Source Distribution(tarball) Regards, Gelu _ G.NET

error in mysql - help!!!

2002-07-25 Thread jan henrik mo
I have tried to install mysql, but there is something wrong... When I start up my computer I get this error-message in a pop-up with a 'winmysqladmin.exe'-header: Error reading Memo2 -> Lines.Strings: The parameter is incorrect. Does anybody know what this means, and what I can do to make mysql

Re: Intermittent 1049 error in MySQL 3.23.49

2002-04-23 Thread Clay Loveless
Hello again, I've now been on the list long enough to determine it's not an inactive list ... So, I'm hoping that means that someone (perhaps one of the MySQL team I've seen active on the list today) may be able to address this problem, as it is quite a serious one. Is there a reason that it's n

Build error in mysql

2002-04-01 Thread Victoria Reznichenko
Laxmikant, Monday, April 01, 2002, 12:33:12 PM, you wrote: LA> Can anybody help me out in solving the build error LA> problem for mysql LA> I am trying to build MySQL-3.23.49-1.src.rpm with the LA> linux command "rpm --rebuild MySQL-3.23.49-1.src.rpm". LA> Using redhat linux 6.2 with glibc2.1.3

Re: Build error in mysql

2002-04-01 Thread Laxmikant Agarwal
i am using egcs 2.91.66 --- Jeremy Zawodny <[EMAIL PROTECTED]> wrote: > On Mon, Apr 01, 2002 at 01:33:12AM -0800, Laxmikant > Agarwal wrote: > > Hello, > > Can anybody help me out in solving the build error > > problem for mysql > > > > I am trying to build MySQL-3.23.49-1.src.rpm with > the >

Re: Build error in mysql

2002-04-01 Thread Jeremy Zawodny
On Mon, Apr 01, 2002 at 01:33:12AM -0800, Laxmikant Agarwal wrote: > Hello, > Can anybody help me out in solving the build error > problem for mysql > > I am trying to build MySQL-3.23.49-1.src.rpm with the > linux command "rpm --rebuild MySQL-3.23.49-1.src.rpm". > Using redhat linux 6.2 with gl

Build error in mysql

2002-04-01 Thread Laxmikant Agarwal
Hello, Can anybody help me out in solving the build error problem for mysql I am trying to build MySQL-3.23.49-1.src.rpm with the linux command "rpm --rebuild MySQL-3.23.49-1.src.rpm". Using redhat linux 6.2 with glibc2.1.3. Following is the error while compiling- make[2]: Entering

Re: MySql "fatal error" in mysql-opt.exe

2002-03-19 Thread Michael Widenius
Hi! >> I'm trying to run MySQL ver 3.23.49 on Win98 with Apache, PHP & Perl. Apache >> reports that PHP & Perl are running OK. When I try to start MySQL, or let it >> start on boot, or try to use the "WinMySqladmin" program, I get a Windows >> error from MYSQLD-OPT.exe, with the usual Win98 "c

Re: MySql "fatal error" in mysql-opt.exe

2002-03-12 Thread Miguel Angel Solorzano
At 22:30 12/03/02 +, Mick wrote: Hi! Microsoft(R) Windows 95 (C)Copyright Microsoft Corp 1981-1996. C:\>c:\mysql\bin\mysqld-opt --standalone --console C:\MYSQL\BIN\MYSQLD~1.EXE: ready for connections Microsoft(R) Windows 95 (C)Copyright Microsoft Corp 1981-1996. C:\>c:\mysql\bin\mysql Welc

MySql "fatal error" in mysql-opt.exe

2002-03-12 Thread Mick
Hi, I'm trying to run MySQL ver 3.23.49 on Win98 with Apache, PHP & Perl. Apache reports that PHP & Perl are running OK. When I try to start MySQL, or let it start on boot, or try to use the "WinMySqladmin" program, I get a Windows error from MYSQLD-OPT.exe, with the usual Win98 "close" and "deta

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

error in mysql using poolman

2001-11-02 Thread felix
First of all, sorry for this email if you are not the proper person, but I'm desperate with this problem I am testing PoolMan to provide database connection pooling on W98 running mysql with the mm.mysql JDBC drivers and JDK 1.3.1. When I execute my sample code the next error appears: "java.s