>Description:
A cron job runs a shell script (update_adrs) that gets lynx to download and
save a web page (adr.htm). It then runs a perl script (adr.pl) to parse the web page
into an import file (adr.txt). Finally it executes a mysql command to import that file
into a table called Library.ADR. mysqld appears to reliably crash and restart,
although sometimes it will fail to restart (according to the error log), complaining
that the TCP/IP port is in use. It will start manually just fine.
>How-To-Repeat:
I will attach the scripts in a seperate email, as I can't work this interface
(I wanna GUI wah!). The script expects to be run from a directory /data/scripts. If
you create said directory and put everything there, you should only need to run the
shell script update_adrs
>Fix:
(don't know)
>Submitter-Id: <submitter ID>
>Originator:
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis: a LOAD DATA INFILE query crashes mysqld
>Severity: serious
>Priority: low
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.49a (Official MySQL Binary)
>Server: /usr/local/mysql/bin/mysqladmin Ver 8.23 Distrib 3.23.49a, for pc-linux-gnu
>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 3.23.49a-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 25 min 5 sec
Threads: 18 Questions: 9215 Slow queries: 0 Opens: 111 Flush tables: 1 Open
tables: 64 Queries per second avg: 6.123
>Environment:
System: Linux linux1289.dn.net 2.4.17 #1 SMP Fri Dec 28 09:35:36 EST 2001 i686 unknown
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/i686-pc-linux-gnu/2.95.3/specs
gcc version 2.95.3 20010315 (release)
Compilation info: CC='gcc' CFLAGS='-Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch
-Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec
-Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro
-O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-Wimplicit -Wreturn-type
-Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat
-Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings
-Woverloaded-virtual -Wextern-inline -Wsign-promo -Wreorder -Wctor-dtor-privacy
-Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -mcpu=pentiumpro -O3
-fno-omit-frame-pointer' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Mar 15 00:34 /lib/libc.so.6 -> libc-2.2.4.so
-rwxr-xr-x 1 root root 5724399 Oct 3 2001 /lib/libc-2.2.4.so
-rw-r--r-- 1 root root 27314604 Oct 3 2001 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Oct 3 2001 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr/local/mysql --enable-assembler
--with-extra-charsets=complex --enable-thread-safe-client
--with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static
--with-other-libc=/usr/local/mysql-glibc '--with-comment=Official MySQL Binary'
--prefix=/usr/local/mysql --with-extra-charset=complex --enable-thread-safe-client
--enable-local-infile 'CFLAGS=-Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch
-Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec
-Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro
-O3 -fno-omit-frame-pointer' 'CXXFLAGS=-Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch
-Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec
-Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual
-Wextern-inline -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor
-felide-constructors -fno-exceptions -fno-rtti -mcpu=pentiumpr!
o -O3 -fno-omit-frame-pointer' CXX=gcc
---------------------------------------------------------------------
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
