From: root
To:
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 malz.erlm.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'
mit freundlichem Gru� / kind regards
Daniel Beuter
SIEMENS
I&S IT PS 221 OP4
Network Solutions
Werner von Siemens Str. 60
91052 Erlangen
Fon: +49 (9131) -6303-211
Fax: +49 (9131) 7-42234
mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
