[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    RE: SELECT => ERROR 1022: Can't write, duplicate key in table
From:       Steven Roussey <sroussey () network54 ! com>
Date:       2000-05-31 21:06:53
[Download RAW message or body]

Hi!

I get the 'ERROR 1022: Can't write, duplicate key in table' on a SELECT --
not an INSERT!

Sincerely,

Steven Roussey
Network54.com
http://network54.com/?pp=e


-----Original Message-----
From: sinisa@mysql.com [mailto:sinisa@mysql.com]
Sent: Wednesday, May 31, 2000 7:04 AM
Subject: Re: SELECT => ERROR 1022: Can't write, duplicate key in table


Steven Roussey writes:
 > Hi,
 >
 > When I do a long select on a table that has insert delayed used to insert
 > data, either I get 'ERROR 1022: Can't write, duplicate key in table', or
 > after I 'set SQL_BIG_TABLES = 1' and do the select the processlist fills
up
 > with 'waiting for handler insert | insert delayed into ....' to the point
 > that after a while there are no more processes.
 >
 > Sincerely,
 >
 > Steven Roussey
 > Network54.com
 > http://network54.com/?pp=e
 >
 >

Hi!

That is expected behaviour.

INSERT , whether non-delayed or delayed, will return an error if
insertion of duplicate value in unique key is attempted.

SQL_BIG_TABLES will use disk for temporary tables, which will slow
down a query, thus piling up others that are trying to access the same
table.

Regards,

Sinisa

+----------------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___     ==  mysql@tcx.se            |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Sinisa Milivojevic          |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|     mailto:sinisa@mysql.com     |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Larnaka, Cyprus             |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                             |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                            |
|             /*/             \*\                Developers Team       |
+----------------------------------------------------------------------+


-- 
---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail mysql-thread38895@lists.mysql.com

To unsubscribe, send a message to:
    <mysql-unsubscribe-mysql=progressive-comp.com@lists.mysql.com>

[prev in list] [next in list] [prev in thread] [next in thread]