Bug 130647

From Bugzilla Helper:
User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) Opera 
7.51  [en]

Description of problem:

Subject: [second write process hangs if another one is writing 
already,!!but in another database!!]

>Description:
        <We have this mysql-server with two databases "internet" and 
"intranet".There are two data-collectors "server1" and "server2".Each 
writes in one database. Server1 in internet, server 2 in intranet.The 
problem is, if writing process(f.e.:Server1) is active and second 
one(server2) starts then the process of (server2) hangs.The only way 
to get this hanging process out of the system is to kill the 
process(id) in servername.pid.Afterwards killall -15 mysqld, then 
stop server and start it again.If I don´t do this way I have to 
reboot because the pidd of other msql processes block the restart of 
the server.(strange,isn`t it). Write -and- Read is possible without 
problems. But writing two processes in different databases is not 
possible at same time>
>How-To-Repeat:
        <code/input/activities to reproduce the problem (multiple 
lines)>
>Fix:
        <how to correct or work around the problem, if known 
(multiple lines)>

>Submitter-Id:  <submitter ID>
>Originator:    root
>Organization:
 <organization of PR author (multiple lines)>
>MySQL support: [none | licence | email support | extended email 
support ]
>Synopsis:      <more than one writeprocess impossible>
>Severity:      <[ critical ]>
>Priority:      <[ low | medium | high ] (one line)>
>Category:      mysql
>Class:         <[ sw-bug | doc-bug | change-request | support ] (one 
line)>
>Release:       mysql-4.0.20-standard (Official MySQL RPM)
>Server: /usr/bin/mysqladmin  Ver 8.40 Distrib 4.0.20, for pc-linux 
on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free 
software,
and you are welcome to modify and redistribute it under the GPL 
license

Server version          4.0.20-standard
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/lib/mysql/mysql.sock
Uptime:                 7 days 1 hour 31 min 24 sec

Threads: 2  Questions: 104795562  Slow queries: 7  Opens: 12664  
Flush tables: 1  Open tables: 62  Queries per second avg: 171.716
>C compiler:    2.95.3
>C++ compiler:  2.95.3
>Environment:
        <machine, os, target, libraries (multiple lines)>
System: Linux xxx.xxx.siemens.de 2.4.22-1.2197.nptlsmp #1 SMP Thu Jul 
1 15:05:23 EDT 2004 i686 i686 i386 GNU/Linux
Architecture: i686

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc 
/usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.3.
2/specs
Konfiguriert mit: ../configure --prefix=/usr --mandir=/usr/share/man 
--infodir=/usr/share/info --enable-shared --enable-threads=posix 
--disable-checking --with-system-zlib --enable-__cxa_atexit 
--host=i386-redhat-linux
Thread model: posix
gcc-Version 3.3.2 20031022 (Red Hat Linux 3.3.2-1)
Compilation info: CC='gcc'  CFLAGS='-O2 -mcpu=i486 
-fno-strength-reduce'  CXX='gcc'  CXXFLAGS='-O2 -mcpu=i486 
-fno-strength-reduce                -felide-constructors 
-fno-exceptions -fno-rtti                  '  LDFLAGS=''  ASFLAGS=''
LIBC:
lrwxrwxrwx  1 root root 13 22. Jul 16:34 /lib/libc.so.6 -> libc-2.3.
2.so
-rwxr-xr-x  1 root root 1570384  7. Jan 2004  /lib/libc-2.3.2.so
-rw-r--r--  1 root root 2445156 27. Okt 2003  /usr/lib/libc.a
-rw-r--r--  1 root root 204 27. Okt 2003  /usr/lib/libc.so
Configure command: ./configure '--disable-shared' 
'--with-mysqld-ldflags=-all-static' 
'--with-client-ldflags=-all-static' '--with-server-suffix=-standard' 
'--without-embedded-server' '--without-berkeley-db' '--with-innodb' 
'--without-vio' '--without-openssl' '--enable-assembler' 
'--enable-local-infile' '--with-mysqld-user=mysql' 
'--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--prefix=/' 
'--with-extra-charsets=complex' '--exec-prefix=/usr' 
'--libexecdir=/usr/sbin' '--libdir=/usr/lib' '--sysconfdir=/etc' 
'--datadir=/usr/share' '--localstatedir=/var/lib/mysql' 
'--infodir=/usr/share/info' '--includedir=/usr/include' 
'--mandir=/usr/share/man' '--enable-thread-safe-client' 
'--with-comment=Official MySQL RPM' 'CC=gcc' 'CFLAGS=-O2 -mcpu=i486 
-fno-strength-reduce' 'CXXFLAGS=-O2 -mcpu=i486 -fno-strength-reduce   
              -felide-constructors -fno-exceptions -fno-rtti          
        ' 'CXX=gcc'


Version-Release number of selected component (if applicable):
Linux version 2.4.22-1.2197.nptlsmp (bhcompile.redhat.
com) (gcc version 3.2.3 20030422 (Red Hat Linux 3.2.3-6)) #1 ,Your 
MySQL connection id is 14037 to server version: 4.0.20-standard  

How reproducible:
Always

Steps to Reproduce:
1.  2 databases on one server
2.  2 different write processes from 2 different data-collectors in 
different databases at same time
3.  SELECT	sum(d_pkts), sum(d_octets) , timestamp  , src_addr  , 
dst_addr , protocol , src_as , dst_as  FROM  `flows-20040816-14:59:
00` WHERE  (out_if_id = 19 OR in_if_id = 19) AND  timestamp >= 
'20040816-12:00:00'     
	        AND  timestamp <= '20040816-15:00:00'  GROUP BY protocol  , 
timestamp  , src_addr  , dst_addr  , src_as  , dst_as  ORDER BY 2  
DESC LIMIT 100   <--- thats the write process  for each process 
syntaxly the same
    

Actual Results:  the first starting process is working fine. the 
second one will hang and the connection stays (netstat) open. Also if 
I kill the process the connection is still open and the process also 
stays in ps -auxww


Expected Results:  Both loader processes should write their data in 
the database and close after their work

Additional info: