[EMAIL PROTECTED] wrote:
>
> >Description:
> Sometimes the query below appears to hang on the table below.
> The problem seems worse on queries which come from a
> webserver, where persistent DB connections are used. :
>
> The online manual page hints at the same problem elsewhere:
> see Tomi Panula-Ontto's comment at
> http://www.mysql.com/doc/U/P/UPDATE.html
>
> UPDATE domain_sm
> SET age = age + 1, exit_time = NOW(),
> exit_env =
>'983895322:mxm5480.tc:mxm5480.tc:mxm5480.tc:mxm5480.tc:9'
> WHERE identity = 'mjo13684test11.tc'
>
> CREATE TABLE domain_sm (
> identity varchar(63) DEFAULT '' NOT NULL,
> age int(11) DEFAULT '0' NOT NULL,
> state int(11) DEFAULT '0' NOT NULL,
> entry_time datetime,
> entry_env blob,
> exit_time datetime,
> exit_env blob,
> UNIQUE identity (identity,age),
> KEY state (state)
> );
>
> >Submitter-Id: <submitter ID>
> >Originator: Martin Oldfield
> >Organization:
> Martin Oldfield,
> AdamsNames Ltd.
>
> >
> >MySQL support: none
> >Synopsis: UPDATE command can sometimes hang
> >Severity: non-critical
> >Priority: low
> >Category: mysql
> >Class: sw-bug
> >Release: mysql-3.22.32 (Source distribution)
> >Server: /usr/bin/mysqladmin Ver 8.0 Distrib 3.22.32, for pc-linux-gnu on i686
> TCX Datakonsult AB, by Monty
>
> Server version 3.22.32-log
> Protocol version 10
> Connection ptolemy via TCP/IP
> TCP port 3306
> Uptime: 20 days 1 hour 24 min 22 sec
>
> Threads: 47 Questions: 5773313 Slow queries: 5671 Opens: 68799 Flush tables: 1
>Open tables: 63
> >Environment:
>
> System: Linux joanna 2.2.17 #1 Thu Oct 19 16:36:18 BST 2000 i686 unknown
> Architecture: i686
>
> Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
> GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.2/specs
> gcc version 2.95.2 20000220 (Debian GNU/Linux)
> Compilation info: CC='gcc' CFLAGS='-O2 -fomit-frame-pointer' CXX='g++'
>CXXFLAGS='-O2 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti'
>LDFLAGS=''
> Configure command: ./configure --enable-shared --without-readline
>--enable-assembler --with-mysqld-user=mysql
>--with-unix-socket-path=/var/run/mysqld/mysqld.sock --prefix=/usr --exec-prefix=/usr
>--libexecdir=/usr/sbin --sysconfdir=/etc/mysql --datadir=/usr/share
>--localstatedir=/var/lib/mysql --infodir=/usr/share/info --includedir=/usr/include
>--mandir=/usr/share/man
> Perl: This is perl, version 5.005_03 built for i386-linux
>
You are incrementing part of the key being used in the select.
This can cause an endless loop in 3.22 versions.
This is addressed in 3.23 versions, mut may still be an issue with
yours.
You can check the changelog to find where it was fixed.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
