Locks durch select

["Dr. Dieter Becker" <db_(at)_med-in.uni-sb.de>]

Hallo,


ich habe das folgende Programm gestartet und blockiere damit Eingaben in die
Tabelle Patient:

###############################################
create temporary table if not exists t  (iz char(9), anz integer);
insert into t
select substring(izahl,1, 9)  iz, count(*) anz from patient group by 1;

delete from t where anz = 1;

select izahl, pname, vorname, ort, strasse
from patient, t
where substring(patient.izahl,1, 9) = t.iz
order by 1;
drop table t;

##########################################

mysql> show processlist;
+-------+------+-----------+--------+---------+-------+---------------------
-+--------------------------------------------------------------------------
----------------------------+
| Id    | User | Host      | db     | Command | Time  | State
| Info
|
+-------+------+-----------+--------+---------+-------+---------------------
-+--------------------------------------------------------------------------
----------------------------+
.....................|
| 28448 | db   | localhost | archiv | Query   | 272   | Copying to tmp table
| select izahl, pname, vorname, ort, strasse
from patient, t
where substring(patient.izahl,1, 9) = t.i |
| 28449 | hkt  | localhost | archiv | Query   | 112   | Locked
| insert into patient values ( 'BAC270539M' , 'XXXXXXXX' , 'XXXXXXXX' ,
'Hermann' , NULL , NULL , '193 |
+-------+------+-----------+--------+---------+-------+---------------------
-+--------------------------------------------------------------------------
----------------------------+

alle anderen Prozesse weren "sleeping". Wie kann das passieren.

Danke

D. Becker

Dr. med. Dipl.-Math. Dieter Becker
Medizinische Universitäts- und Poliklinik
Innere Medizin III
D66421 Homburg
-----------------------------------------
Tel: 06841 16 3046 / -3077
Fax: 06841 16 3043 / -3385
Email: db_(at)_med-in.uni-sb.de

---
*** Weitere Infos zur Mailingliste und MySQL unter http://www.4t2.com/mysql