Strange insert: ERROR 1172 (42000)

2006-09-26 Thread Wai-Sun Chia
This is so weird! I'm getting a: ERROR 1172 (42000): Result consisted of more than one row I've setup 2 machines. Same table (dbsetup.sql) , same insert statement (foo.sql), same version (5.0.24a). Only difference is: One is my laptop on FC5-i386, the other is a server on RHEL4u4-i386 Any clues

MySQL Insert error..

2005-04-18 Thread preeth k
*/ res=mysql_query(&my_connection,"INSERT INTO ids(sip,sport,dip,dport)VALUES('"+srcip+"',"+srcport+",'"+destip+"',"+destport+")"); if (!res) { printf("Inserted %lu rows\n",(unsigned l

InnoDB, odd "insert error" shared row locking behavior

2004-07-01 Thread Josh Chamas
Hi again, I ran into some dead locking that was unexpected, & I basically think the "insert error -> share lock" behavior is problematic. I would think that either a insert error does not acquire a row lock ( equivalent of a basic select ), or that it would acquire an exclusi

Re: Replication with HEAP tables & slave insert error

2004-02-03 Thread Egor Egorov
"Vinod Panicker" <[EMAIL PROTECTED]> wrote: > > "Vinod Panicker" <[EMAIL PROTECTED]> wrote: > >> Also, the slave stopped due to an error of a duplicate key! Why >> should it have a problem with inserting data that went through fine on the > master? > > Could you describe your problem more deta

RE: Replication with HEAP tables & slave insert error

2004-02-02 Thread Vinod Panicker
Hi Egor, Thanks for the reply. My responses below - "Vinod Panicker" <[EMAIL PROTECTED]> wrote: > Hi, > > Had a query regarding replication with HEAP tables. It seems like I > cannot use LOAD DATA FROM MASTER to update the stopped slave with data > from the master since it apparently work

Re: Replication with HEAP tables & slave insert error

2004-02-02 Thread Egor Egorov
"Vinod Panicker" <[EMAIL PROTECTED]> wrote: > Hi, > > Had a query regarding replication with HEAP tables. It seems like I cannot > use LOAD DATA FROM MASTER to update the stopped slave with data from the > master since it apparently works only for MyISAM tables. Any other way of > updating the s

Replication with HEAP tables & slave insert error

2004-02-01 Thread Vinod Panicker
Hi, Had a query regarding replication with HEAP tables. It seems like I cannot use LOAD DATA FROM MASTER to update the stopped slave with data from the master since it apparently works only for MyISAM tables. Any other way of updating the slave with a snapshot of the data? Since a HEAP table do

RE: Insert error

2002-11-27 Thread MarkH
27;); ERROR 2013: Lost connection to MySQL server during query mysql> --- Thanks Mark -Original Message- From: miguel solórzano [mailto:[EMAIL PROTECTED]] Sent: 27 November 2002 09:17 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Insert er

RE: Insert error

2002-11-27 Thread MarkH
[mailto:[EMAIL PROTECTED]] Sent: 26 November 2002 18:27 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Insert error Mark, Are you working from the command line or using a tool (which)? MySQL version nr? Are you running WinMySQLadmin (the traffic lights in the System Tray)? =dn > I&#x

Re: Insert error

2002-11-27 Thread miguel solórzano
At 16:50 26/11/2002 +, [EMAIL PROTECTED] wrote: Hi, I'm running MySQL as a service on win2k and trying to insert data into a database. Each time I try to do this I receive the following error: "ERROR 2013: Lost connection to MySQL server during query" The following error was shown when I o

Re: Insert error

2002-11-26 Thread DL Neil
Mark, Are you working from the command line or using a tool (which)? MySQL version nr? Are you running WinMySQLadmin (the traffic lights in the System Tray)? =dn > I'm running MySQL as a service on win2k and trying to insert data into a > database. Each time I try to do this I receive the foll

Insert error

2002-11-26 Thread MarkH
I'm running MySQL as a service on win2k and trying to insert data into a database. Each time I try to do this I receive the following error: "ERROR 2013: Lost connection to MySQL server during query" The following error was shown when I opted to debug: "Unhandled exception at 0x004803c9 in mysq

Insert Error

2002-10-24 Thread Insanely Great
Greetings... I have a table in database ch whose create statement is as follows - CREATE TABLE `chn1` ( `id` int(10) NOT NULL auto_increment, `chn` varchar(10) NOT NULL default 'Pagal', `name ` varchar(50) default '', `chn3` text, PRIMARY KEY (`id`) TYPE=ISAM ; Now when I giving a insert stateme

RE: Insert Error

2002-10-24 Thread Norris, Joseph
List Subject: Insert Error Greetings... I have a table in database ch whose create statement is as follows - CREATE TABLE `chn1` ( `id` int(10) NOT NULL auto_increment, `chn` varchar(10) NOT NULL default 'Pagal', `name ` varchar(50) default '', `chn3` text, PRIMARY KEY (`id`

RE: Insert Error

2002-10-24 Thread Jennifer Goodie
The column's name is 'name ' not 'name' run an alter to get rid of the space at the end. > -Original Message- > From: Insanely Great [mailto:insanely420@;PunkAss.com] > Sent: Thursday, October 24, 2002 8:59 AM > To: MySQL List > Subject: Insert Err

Re: execute insert error, ERROR 2006

2001-05-14 Thread Sinisa Milivojevic
SJ writes: > I insert a sql statment, size is 30M, a field type is longtext > using >mysql dbname < filename > > in file, it is a sql as insert into table ... values ... > > where file size is 10 M, it execute well, but report error when file size is to 30M > > > it report: > ERROR

execute insert error, ERROR 2006

2001-05-14 Thread SJ
I insert a sql statment, size is 30M, a field type is longtext using mysql dbname < filename in file, it is a sql as insert into table ... values ... where file size is 10 M, it execute well, but report error when file size is to 30M it report: ERROR 2006 at line 1: MYSQL server has