2013/2/14 Robert Citek
>
>
> According to the client, nothing is writing to the slave and
> everything is being logged at the master. I have not had the
> opportunity to independently verified any of this, yet. I do know
> that the slave is not in read-only mode, but rather "we promise not to
>
Agreed. Will do that along with several other possible changes. But
for the moment, I'm still gathering information and coming up with
plausible models.
Will also be turning on general mysql logging on both Master and
Slave, at least briefly, to see what statements are being run on both.
Regard
2013/2/13 Robert Citek
> On Wed, Feb 13, 2013 at 8:59 AM, Robert Citek
> wrote:
> > Any other possibilities? Do other scenarios become likely if there
> > are two or more tables?
> >
> > Of those, which are the most likely?
>
> [from off-list responder]:
> > Other possibility: The replication i
Yes. Except for a handful of static MyISAM tables. But the tables
that are experiencing the issues are all InnoDB and large (a dozen or
so fields, but lots of records.)
Regards,
- Robert
On Thu, Feb 14, 2013 at 5:59 PM, Singer Wang wrote:
> Are you using all InnoDB?
>
> S
--
MySQL General Ma
On Thu, Feb 14, 2013 at 4:54 PM, Manuel Arostegui wrote:
> 2013/2/13 Robert Citek
>>
>> On Wed, Feb 13, 2013 at 8:59 AM, Robert Citek
>> wrote:
>> > Any other possibilities? Do other scenarios become likely if there
>> > are two or more tables?
>> >
>> > Of those, which are the most likely?
>>
On Thu, Feb 14, 2013 at 5:46 PM, Rick James wrote:
>> Is it in read only mode?
> Furthermore, are all users logging in as non-SUPER users? Note: root
> bypasses the readonly flag!
No. The user that is commonly used does have Super privileges. I am
not sure why, but it does.
Regards,
- Rober
Are you using all InnoDB?
S
On Thu, Feb 14, 2013 at 5:55 PM, Robert Citek wrote:
> On Thu, Feb 14, 2013 at 4:54 PM, Manuel Arostegui
> wrote:
> > 2013/2/13 Robert Citek
> >>
> >> On Wed, Feb 13, 2013 at 8:59 AM, Robert Citek
> >> wrote:
> >> > Any other possibilities? Do other scenarios bec
ysql
> Subject: Re: slave replication with lots of 'duplicate entry' errors
>
> 2013/2/13 Robert Citek
>
> > On Wed, Feb 13, 2013 at 8:59 AM, Robert Citek
>
> > wrote:
> > > Any other possibilities? Do other scenarios become likely if there
> &
ursday, February 14, 2013 2:59 PM
> To: Rick James
> Cc: mysql
> Subject: Re: slave replication with lots of 'duplicate entry' errors
>
> On Thu, Feb 14, 2013 at 5:46 PM, Rick James
> wrote:
> >> Is it in read only mode?
> > Furthermore, are all users logg
On Wed, Feb 13, 2013 at 8:59 AM, Robert Citek wrote:
> Any other possibilities? Do other scenarios become likely if there
> are two or more tables?
>
> Of those, which are the most likely?
[from off-list responder]:
> Other possibility: The replication is reading from master not from the point
Corrupted table and / or index.
A number of reasons could cause this issue:
http://dev.mysql.com/doc/refman/5.1/en/corrupted-myisam-tables.html
Regards,
m
"Adarsh Sharma" pisze:
> Thanks , but there is no trigger on tables.
>
> Even I solved the problem after googling a link but cannot unders
INE=MyISAM AUTO_INCREMENT=31592 DEFAULT CHARSET=latin1
Today don't know why below error occurs when i am going insert some
data in it :
mysql> insert into login(user_id,log_status) values(2,1);
ERROR 1062 (23000): Duplicate entry '31592' for key 'PRIMARY'
I check the lat
`user_id` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=31592 DEFAULT CHARSET=latin1
Today don't know why below error occurs when i am going insert some
data in it :
mysql> insert into login(user_id,log_status) values(2,1);
ERROR 1062 (23000): Duplicate entry '31592' for key
.
- michael dykman
On Tue, Nov 9, 2010 at 3:36 PM, Ilham Firdaus wrote:
> Dear friends.
>
> Anybody would be so nice to explain about meaning of this error message:
> "
> Duplicate entry '2' for key 1
> :.
> It comes if we visit this:
> http://www.otekno.biz/kn/cod
Dear friends.
Anybody would be so nice to explain about meaning of this error message:
"
Duplicate entry '2' for key 1
:.
It comes if we visit this:
http://www.otekno.biz/kn/code/functions.php?task=sync
Thank you very much in advance.
--
Enjoy our free facilities: http:/
2009/12/13 Victor Subervi :
[...]
> Please advise.
review your sql: you are inserting into
tem126072414516
and selecting from
tem126072385457
( Asterisk in Pinter Tibor's mail means "bold" )
Greetings,
Mattia Merzi.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
Gods. What is this, a creche ?
*plonk*
On Sun, Dec 13, 2009 at 6:44 PM, Victor Subervi wrote:
> On Sun, Dec 13, 2009 at 12:21 PM, Pinter Tibor wrote:
>
> > Victor Subervi wrote:
> >
> >> Hi;
> >>
> >> mysql> insert into *tem126072414516* (ProdID, Quantity) values ("2",
> "2");
> >> mysql> sele
On Sun, Dec 13, 2009 at 12:21 PM, Pinter Tibor wrote:
> Victor Subervi wrote:
>
>> Hi;
>>
>> mysql> insert into *tem126072414516* (ProdID, Quantity) values ("2", "2");
>> mysql> select * from *tem126072385457*;
>>
>
>
mysql> insert into *tem126072414516* (ProdID, Quantity) values ("2", "2");
ERRO
Victor Subervi wrote:
Hi;
mysql> insert into *tem126072414516* (ProdID, Quantity) values ("2", "2");
mysql> select * from *tem126072385457*;
t
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Hi;
mysql> insert into tem126072414516 (ProdID, Quantity) values ("2", "2");
ERROR 1062 (23000): Duplicate entry '2' for key 2
mysql> select * from tem126072385457;
Empty set (0.00 s
Thank you all I solved the problem
--- On Mon, 3/2/09, Darryle Steplight wrote:
From: Darryle Steplight
Subject: Re: Error: Duplicate entry '0' for key 'PRIMARY'
To: samc...@yahoo.com
Cc: mysql@lists.mysql.com, g...@primeexalia.com
Date: Monday, March 2, 2009, 2:32 PM
>
> From: Gary Smith
> Subject: Re: Error: Duplicate entry '0' for key 'PRIMARY'
> To: samc...@yahoo.com, mysql@lists.mysql.com
> Date: Monday, March 2, 2009, 1:58 PM
>
> Easy. Ensure that all in the primary key have unique values.
>
> With that said,
Are you talking about Length/Values1
--- On Mon, 3/2/09, Gary Smith wrote:
From: Gary Smith
Subject: Re: Error: Duplicate entry '0' for key 'PRIMARY'
To: samc...@yahoo.com, mysql@lists.mysql.com
Date: Monday, March 2, 2009, 1:58 PM
Easy. Ensure that all in the primary ke
How do I modify the column to add value? Can I do it with phpmyadmin?
--- On Mon, 3/2/09, Gary Smith wrote:
From: Gary Smith
Subject: Re: Error: Duplicate entry '0' for key 'PRIMARY'
To: samc...@yahoo.com, mysql@lists.mysql.com
Date: Monday, March 2, 2009, 1:58 PM
Easy
Error: Duplicate entry '0' for key 'PRIMARY'
how can i fix it ?
>Description:
When running the statements below, MySQL errors out with:
ERROR 1062 (23000) at line 5: Duplicate entry '1' for key 1 during SELECT
>How-To-Repeat:
drop table if exists t;
create table t (f int not null);
insert into t values (1),(1);
select 1 from
t straight
5 PM, Steve Edberg wrote:
At 4:36 PM -0700 3/13/07, jerad sloan wrote:
thanks.
i had an extra index setup for one of my fields...i deleted it
and it started working as expected...but now the same thing is
happening again.
i'm getting the error
"Duplicate entry 'http://vid
eve Edberg wrote:
At 4:36 PM -0700 3/13/07, jerad sloan wrote:
thanks.
i had an extra index setup for one of my fields...i deleted it and
it started working as expected...but now the same thing is
happening again.
i'm getting the error
"Duplicate entry
'http://vids.myspace.c
Steve Edberg wrote:
At 4:36 PM -0700 3/13/07, jerad sloan wrote:
thanks.
i had an extra index setup for one of my fields...i deleted it and
it started working as expected...but now the same thing is
happening again.
i'm getting the error
"Duplicate entry 'http:/
At 4:36 PM -0700 3/13/07, jerad sloan wrote:
thanks.
i had an extra index setup for one of my fields...i deleted it and
it started working as expected...but now the same thing is happening
again.
i'm getting the error
"Duplicate entry
'http://vids.myspace.com/index
thanks.
i had an extra index setup for one of my fields...i deleted it and it
started working as expected...but now the same thing is happening again.
i'm getting the error
"Duplicate entry 'http://vids.myspace.com/index.cfm?
fuseaction=vids.individual&vid' for
he string "
http://vids.myspace.com/index.cfm?fuseaction=vids.individual&videoid=2012774576";,
it returns
"error : Duplicate entry '
http://vids.myspace.com/index.cfm?fuseaction=vids.individual&videoid=' for
key 3"
when i check the table and do a search for the strin
when i try to insert the string "
http://vids.myspace.com/index.cfm?fuseaction=vids.individual&videoid=2012774576";,
it returns
"error : Duplicate entry '
http://vids.myspace.com/index.cfm?fuseaction=vids.individual&videoid=' for
key 3"
when i check th
This is structure of the table before I "fixed".
CREATE TABLE `products` (
`prod_id` int(8) unsigned NOT NULL auto_increment,
`prod_no` varchar(50) NOT NULL default '',
`prod_name` varchar(255) NOT NULL default '',
`prod_description` text,
`prod_colors` text,
`prod_includes` text,
`p
Key 6 relates to the 6th key, or index, in the CREATE TABLE statement
for this table:
>> PRIMARY KEY (`prod_id`),
>> UNIQUE KEY `prod_no` (`prod_no`),
>> KEY `products_index1` (`prod_status`),
>> KEY `products_index2` (`prod_start_date`,`prod_end_date`),
>> KEY `on_sale` (`on_sale`),
Sent: Wednesday, January 03, 2007 4:10 PM
>> To: Jerry Schwartz
>> Cc: mysql@lists.mysql.com
>> Subject: RE: Error: Duplicate entry '-L' for key 6
>>
>> Yes, it's custom made app, written in php.
>> The code/query is really very simple:
Wednesday, January 03, 2007 4:10 PM
>> To: Jerry Schwartz
>> Cc: mysql@lists.mysql.com
>> Subject: RE: Error: Duplicate entry '-L' for key 6
>>
>> Yes, it's custom made app, written in php.
>> The code/query is really very simple:
>&g
.8341
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, January 03, 2007 4:10 PM
> To: Jerry Schwartz
> Cc: mysql@lists.mysql.com
> Subject: RE: Error: Duplicate entry '-L' for key 6
>
> Yes, it's custom made app, wri
one location debossed imprint. Die/setup $130.00(a)
Second location $6.00(a)', '2007 Canyon Outback', 'Canyon Outback',
'-00-00', '-00-00', 'new' )
Duplicate entry 'Lavender Peak Purse-L' for key 6
Nothing special.
:(
>
.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, January 03, 2007 3:45 PM
> To: mysql@lists.mysql.com
> Subject: Error: Duplicate entry '-L' for key 6
>
>
it mean? What's key 6?
I tried to find answer on mysql.com but only think I found is
Error: 1062 SQLSTATE: 23000 (ER_DUP_ENTRY)
Message: Duplicate entry '%s' for key %d
CREATE TABLE `web_products` (
`prod_id` int(8) unsigned NOT NULL auto_increment,
`prod_no` v
[EMAIL PROTECTED] wrote:
Ronan McGlue <[EMAIL PROTECTED]> wrote on 03/09/2006 05:05:15 AM:
> i have a little quirck with my current Mysql setup. I log all messages
> from my mtas into Mysql and then use a simple query to generate stats
> from them... as below:
>
> mysql> select exim.hour,
Ronan McGlue <[EMAIL PROTECTED]> wrote on 03/09/2006 05:05:15 AM:
> i have a little quirck with my current Mysql setup. I log all messages
> from my mtas into Mysql and then use a simple query to generate stats
> from them... as below:
>
> mysql> select exim.hour,sum(exim.count),stats.spam,stat
i have a little quirck with my current Mysql setup. I log all messages
from my mtas into Mysql and then use a simple query to generate stats
from them... as below:
mysql> select exim.hour,sum(exim.count),stats.spam,stats.ham from
servers,exim,stats where exim.date=stats.day and exim.date =curd
Hello.
> | 4.0.17-standard |
It is an old version of MySQL which could contain lots of bugs. It is
strongly recommended to upgrade to the latest release 4.1.12, or if it
is impossible in your production environment to 4.0.24. Usually upgrade
solves such kind of errors. Please, next
ag
>
>
> -Original Message-
> From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 30, 2005 3:20 PM
> To: mysql@lists.mysql.com
> Subject: Re: Duplicate entry error
>
>
> Hello.
>
> Please examine your master's
in for your help and cooperation.
Anurag
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 30, 2005 3:20 PM
To: mysql@lists.mysql.com
Subject: Re: Duplicate entry error
Hello.
Please examine your master's binary and slave's relay logs with
er old, check if the
problem remains after upgrade.
[EMAIL PROTECTED] wrote:
>
> Hi all,
> I am getting duplicate entry error while inserting data in the table.
> My table name is TEMP and it contains only one field which is primary key=
> ,nt null as well as auto increm
Hi all,
I am getting duplicate entry error while inserting data in the table.
My table name is TEMP and it contains only one field which is primary key ,nt
null as well as auto increment .
050628 16:05:00 Slave: Error 'Duplicate entry '77' for key 1' on query
Hello.
You may execute select statement similar to this one to determine that you
already have rows with keys you want to insert:
select * from subscriber where phplib_id='val1',$USERCOL='val2',domain='val3';
Where val1,val2,val3 - values from corresponding insert query.
szj <[EMAI
Hi:
I am using MySQL under FC2 on Intel P4. I created one table using
the following command
CREATE TABLE subscriber (
phplib_id varchar(32) NOT NULL default '',
$USERCOL varchar(64) NOT NULL default '',
domain varchar(128) NOT NULL default '',
password varchar(25) NOT NULL default '',
fir
Hi Gerald,
> try ALTER IGNORE TABLE.
Thank you very much. I should have checked the manual first.
http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html
IGNORE is a MySQL extension to standard SQL. It controls how ALTER TABLE
works if there are duplicates on unique keys in the new table. If IGNORE
i
7;n','replied') NOT NULL default 'y',
`datetime` datetime default NULL,
KEY `idx_1` (`member_id`,`new`),
KEY `idx_2` (`member_id`,`datetime`)
) TYPE=InnoDB
Now, I want to add a primary key to it.
ALTER TABLE message_inbox ADD PRIMARY KEY (member_id, message_id)
But there are a
Eldo Skaria wrote:
Hi,
I think the query has to be considering the count rather than the sum.
the query can be like this:
select pkfield1[,pkfield2[,pkfield3[,]]], count(1) from
group by pkfield1[,pkfield2[,pkfield3[,]]]
having count(1) > 1
Here u can add n-number of feilds which u want ma
>> KEY `idx_1` (`member_id`,`new`),
> >> KEY `idx_2` (`member_id`,`datetime`)
> >> ) TYPE=InnoDB
> >>
> >>
> >> Now, I want to add a primary key to it.
> >> ALTER TABLE message_inbox ADD PRIMARY KEY (member_id, message_id)
> >>
') NOT NULL default 'y',
`datetime` datetime default NULL,
KEY `idx_1` (`member_id`,`new`),
KEY `idx_2` (`member_id`,`datetime`)
) TYPE=InnoDB
Now, I want to add a primary key to it.
ALTER TABLE message_inbox ADD PRIMARY KEY (member_id, message_id)
But there are already some duplicated e
#x27;y',
`datetime` datetime default NULL,
KEY `idx_1` (`member_id`,`new`),
KEY `idx_2` (`member_id`,`datetime`)
) TYPE=InnoDB
Now, I want to add a primary key to it.
ALTER TABLE message_inbox ADD PRIMARY KEY (member_id, message_id)
But there are already some duplicated entries.
ERROR 1
`datetime` datetime default NULL,
KEY `idx_1` (`member_id`,`new`),
KEY `idx_2` (`member_id`,`datetime`)
) TYPE=InnoDB
Now, I want to add a primary key to it.
ALTER TABLE message_inbox ADD PRIMARY KEY (member_id, message_id)
But there are already some duplicated entries.
ERROR 1062: Duplicate e
/04 10:56 AM
Subject: "Duplicate entry" breaks replication
Hi,
We recently moved to new servers, and also upgraded from MySQL 3.23 to
4.0.20. We have one master database server and a second identical
machine configured to replicate all databases from the master.
Previously this
started it up
This works, but we keep getting errors like "Error 'Duplicate entry
'53751556' for key 1' on query. Default database: 'archive'." I know
what this means, but how come we are getting them if the two servers
started off with an identical snap
details.
mysql> create index url_site_idx on URL(Site(255));
ERROR 1062: Duplicate entry 'Transmeta unveils futuristic Crusoe chip '
for key 1
mysql>
mysql> select version();
+-+
| version() |
+-+
| 4.0.17-standard |
+-+
1 r
Hi!
On Feb 05, Daniel R. Anderson wrote:
> I got the following error on a perl script:
>
> "Duplicate entry '273' for key 1"
>
> I googled for it and found a thread telling me to DROP the table and re
> CREATE it. So I did, and my script is working fine
Paul DuBois wrote:
At 15:50 + 2/5/04, Daniel R. Anderson wrote:
I got the following error on a perl script:
"Duplicate entry '273' for key 1"
It means you tried to set the value of the column corresponding to key
one to 273, and there was already a record that had t
At 15:50 + 2/5/04, Daniel R. Anderson wrote:
I got the following error on a perl script:
"Duplicate entry '273' for key 1"
It means you tried to set the value of the column corresponding to key
one to 273, and there was already a record that had that value.
I googled for i
On Thursday 05 February 2004 15:50, Daniel R. Anderson wrote:
> I got the following error on a perl script:
>
> "Duplicate entry '273' for key 1"
>
> I googled for it and found a thread telling me to DROP the table and re
> CREATE it. So I did, and my scr
I got the following error on a perl script:
"Duplicate entry '273' for key 1"
I googled for it and found a thread telling me to DROP the table and re
CREATE it. So I did, and my script is working fine. My question: why
did this happen, why did dropping and recreating wor
|
Thanks
From: "Jigal van Hemert" <[EMAIL PROTECTED]>
To: "Mike Mapsnac" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
Subject: Re: Error: 1062 Duplicate Entry '252' for key 1
Date: Thu, 29 Jan 2004 14:32:51 +0100
From: "Mike Mapsnac" <[EMAIL P
From: Mike Mapsnac [mailto:[EMAIL PROTECTED]
> Thanks for explanation.
>
> But I don't insert anything at all to the SLAVE. It is 100%.
>
> Can the problem be problem be relative to Mysql 4.0.13 ?
>
> Thanks
Out of curiosity, what's the data type of this column?
--
Mike Johnson
Web Develop
Thanks for explanation.
But I don't insert anything at all to the SLAVE. It is 100%.
Can the problem be problem be relative to Mysql 4.0.13 ?
Thanks
From: "Jigal van Hemert" <[EMAIL PROTECTED]>
To: "Mike Mapsnac" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]&g
From: "Mike Mapsnac" <[EMAIL PROTECTED]>
> The slave server stop working today and I looked to the error
> log and the the error message is
> Error: 1062 Duplicate Entry '252' for key 1
>
> And than it shows the query and time when it happens. My
>
Hello
The slave server stop working today and I looked to the error log and the the error
message is
Error: 1062 Duplicate Entry '252' for key 1
And than it shows the query and time when it happens. My question is why no error
messages on master server just on slave server?
As I
value,
message from server: "Duplicate entry 'Extended Trip' for key 2"
> 2004-01-28 14:02:51,057 [main] ERROR
net.sf.hibernate.util.JDBCExceptionReporter - Could not insert
>
> Best Regards,
> Samyukta
>
>
>
Hi,
It appears that you have either a primary key
Hi,
I am getting following error while using Hibernate with mySql.Any help appreciated.
Thank you!
2004-01-28 14:02:51,037 [main] ERROR net.sf.hibernate.util.JDBCExceptionReporter -
Invalid argument value, message from server: "Duplicate entry 'Extended Trip' for key
2&qu
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Wileynet wrote:
Here is another beginner question of sorts I imagine.
I receive this error.
java.sql.SQLException: Update failed, possible duplicate entry
I've got this code in a .jsp page.
<% String ref=request.getHeader(
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Wileynet wrote:
Here is another beginner question of sorts I imagine.
I receive this error.
java.sql.SQLException: Update failed, possible duplicate entry
I've got this code in a .jsp page.
<% String ref=request.getHeader(
Here is another beginner question of sorts I imagine.
I receive this error.
java.sql.SQLException: Update failed, possible duplicate entry
I've got this code in a .jsp page.
<% String ref=request.getHeader("Referer");%>
<%
count.addInfo( ref );
%>
count is
is example field acB is unique in table AC, but not in the
return set generated by the join.
The following select statement works fine:
(select seA, acB, count(*) from SE left join AC on (seID=acID) group by
seA,acB);
However, doing a UNION of this statement with itself generates a
"Dupli
Help!
I have a problem with a database which gives a "duplicate entry on key
1" error message when I try to re-add a record that I have just
deleted. I have a feeling it has to do with my index..
my key column is shown like this in the create statement:
Create table 'mydb&#x
Help!
I have a newbie question.
I have a problem with a database which gives a "duplicate entry on key
1" error message when I do a select on a record that I have just
deleted.
my key column is shown like this in the create statement:
Create table 'mydb' (
&#x
In the last episode (Jul 29), Prince Chidi Ajuzie said:
> MySQL Question
> I run sql version 3.23.42.
>
> LOAD DATA INFILE "/usr/lists" INTO TABLE lists;
> ERROR 1062: Duplicate entry '1' for key 1
>
> Please how do i run this successfully. Ive tried th
Prince,
Monday, July 29, 2002, 12:58:22 PM, you wrote:
PCA> MySQL Question
PCA> I run sql version 3.23.42.
PCA> LOAD DATA INFILE "/usr/lists" INTO TABLE lists;
PCA> ERROR 1062: Duplicate entry '1' for key 1
PCA> Please how do i run this successfully. Ive t
MySQL Question
I run sql version 3.23.42.
LOAD DATA INFILE "/usr/lists" INTO TABLE lists;
ERROR 1062: Duplicate entry '1' for key 1
Please how do i run this successfully. Ive tried the REPLACE opt
On Sun, 07 Apr 2002 00:55:59 -0500
Balteo <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I am trying to restore some data from the binary log but I get the
> following error:
> "Duplicate entry '1' for key 1"
>
> I understand restoring data is a two-sta
Hello,
I am trying to restore some data from the binary log but I get the
following error:
"Duplicate entry '1' for key 1"
I understand restoring data is a two-stage process:
1. You do a "source myfile.sql" to restore the data saved with mysqldump
2. You restore
ror that you
VR> received?
Probably no relation, that was just the only Google hit I had. Maybe few words
in the offcial documentation about this kind of errors? Possible causes, solutions?
VR> MM> ERROR 1036 at line 46: Table 'intergenome' is read only
VR> MM> Failed to
M tables to this
MM> servers during easters and this is what I've found(but might be totally unrelated):
MM> ERROR 1062 at line 46: Duplicate entry '0' for key 1
MM> Failed to dump Mthermoautotrophicum.intergenome
MM> ERROR 1062 at line 46: Duplicate e
tion, but the cause for my error is "Invalid
argument"!
And what about the error 98?
I can't say much what happened, I's dumping large MyISAM tables to this
servers during easters and this is what I've found(but might be totally unrelated):
ERROR 1062 at line
riginal Message -
From: "Bogdan Stancescu" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: 25 January 2002 00:22
Subject: Re: LOAD DATA INFILE - "Duplicate entry '' for key..."
> Just for the record, found the glitch: somehow, somebody on the way
;content" field. Then performed a
> "LOAD DATA INFILE" on the resulting file in a different database with
> identical structure. Everything worked just fine.
>
> Later on, after some editing on the table via PHP, everything looked ok in
> PHP and I dumped the table once a
dentical structure. Everything worked just fine.
Later on, after some editing on the table via PHP, everything looked ok in
PHP and I dumped the table once again. Guess what? "LOAD DATA INFILE" now
says "Duplicate entry '' for key 1". The table structures continue to be
It's probably a tinyint field which won't go higher than 127.
Fred.
On Thu, Jan 17, 2002 at 02:40:54PM +0100, Thibaut Allender wrote:
>
> an index cannot be null
>
> you should do this :
>
> insert into equipment (id,description) values ('','test data');
>
> regards
>
> At 14:27 17/01/2002
an index cannot be null
you should do this :
insert into equipment (id,description) values ('','test data');
regards
At 14:27 17/01/2002, you wrote:
>database,sql,query,table
>
>If you just reply to this message, and include the entire text of it in the
>reply, your reply will go through. How
database,sql,query,table
If you just reply to this message, and include the entire text of it in the
reply, your reply will go through. However, you should
first review the text of the message to make sure it has something to do
with MySQL. Just typing the word MySQL once will be sufficient, for
I have just upgraded my test server to MySQL 4.0.0 from MySQL 3.23.44
There is a 2Gb table with 2286869 records which I can query fine on MySQL
3.23.44, but when I change over to MySQL 4 if I try and INSERT or REPLACE
any records it keeps saying 'Duplicate entry' and when I do an
Hi!
Just an update to this thread: the replication
failure of auto-inc columns has probably been
traced. Replication assumes that auto-inc
values for a multiline insert or
INSERT INTO ... SELECT ... are assigned strictly
consecutively, while InnoDB assigns them in parallel.
A symptom of the bug
this setup in a "lab" environment, and as expected, everything
>worked fine. After about a day of running, sv2, the slave, died with this
>error:
>
>-
>
>ERROR: 1062 Duplicate entry '1063030' for
>key 1
>010917 13:30:13 Slave: error runnin
ad
tested this setup in a "lab" environment, and as expected, everything
worked fine. After about a day of running, sv2, the slave, died with this
error:
-
ERROR: 1062 Duplicate entry '1063030' for
key 1
010917 13:30:13 Slave: error
ssID
> where ((word like 'acc')) group by f.ID having qu>0 order by r desc
>
> answer me with
>
> ERROR 1062 at line 1: Duplicate entry '4783' for key 1
>
> How can it be?
>
> Regards,
>
> Ivan Lulukyan
> ACC
> Armenia
>
Hi!
- FAX -388
---
- Original Message -
From: Ivan Lulukyan <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, August 05, 2001 6:28 PM
Subject: Duplicate entry for SELECT query
> Hi All.
> Strange thing.The query below:
>
> select concat(domain,path,file) as
file_names as fn on fn.ID=f.file_nameID left join path_names as pn on
pn.ID=p.path_nameID left join charsets as c on c.ID=f.charsetID left join
classes as l on l.fileID=f.ID left join class_names as ln on ln.ID=l.classID
where ((word like 'acc')) group by f.ID having qu>0 order by r desc
a
1 - 100 of 125 matches
Mail list logo
