Hi!
I was scanning old mails to check if we have any unsolved problems and
come across the belove mail message. Do you still have this problem
or have you managed to solve this?
Anyway, the problem is very probably that you are using gcc 2.8.1;
Just upgrade to 2.95.2 and use the following configure line and
this problem will disappear:
CFLAGS="-O6 -mpentiumpro -fomit-frame-pointer" CXX=gcc CXXFLAGS="-O6 -mpentiumpro
-fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti" ./configure
--prefix=/usr/local/mysql --enable-assembler --with-mysqld-ldflags=-all-static
--disable-shared
Regards,
Monty
>>>>> "Boian" == Boian Ikonomov <bobi@stripped> writes:
Boian> Description:
Boian> After random periods of time (may be upto 7 days but more often after about
Boian> 8 hours normal work) mysqld freezes.
Boian> It stops responding to requests (both via TCP and UNIX sockets) and
Boian> requesting perl scripts, using DBI are freezed too.
Boian> Here is debug information:
Boian> [CUT]
Boian> T@4367365: | <mysql_parse
Boian> T@4367365: | info: query ready
Boian> T@4367365: | >close_thread_tables
Boian> T@4367365: | | >unlock_databases
Boian> T@4367365: | | | >ha_lock
Boian> T@4367365: | | | | >ni_lock_database
Boian> T@4367365: | | | | <ni_lock_database
Boian> T@4367365: | | | <ha_lock
Boian> T@4367365: | | <unlock_databases
Boian> T@4367365: | | >thr_multi_unlock
Boian> T@4367365: | | | lock: data: 8181b20 count: 1
Boian> T@4367365: | | | lock: Free lock: data: 8186f30 thread: 4367365 lock: 81827a0
Boian> T@4367365: | | <thr_multi_unlock
Boian> T@4367365: | | >my_free
Boian> T@4367365: | | | my: ptr: 8181b10
Boian> T@4367365: | | <my_free
Boian> T@4367365: | <close_thread_tables
Boian> T@4367365: | >my_realloc
Boian> T@4367365: | | my: ptr: 81a59c0 Size: 16384 MyFlags: 0
Boian> T@4367365: | | exit: ptr: 81a59c0
Boian> T@4367365: | <my_realloc
Boian> T@4367365: | >free_root
Boian> T@4367365: | | >my_free
Boian> T@4367365: | | | my: ptr: 81847c8
Boian> T@4367365: | | <my_free
Boian> T@4367365: | <free_root
Boian> T@4367365: <do_command
Boian> T@4367365: >do_command
Boian> T@4367365: | general: Command on socket 29 = 1 (Quit)
Boian> T@4367365: | >free_root
Boian> T@4367365: | <free_root
Boian> T@4367365: <do_command
Boian> T@4367365: >close_connection
Boian> T@4367365: | enter: fd: 29 error: ''
Boian> T@4367365: | >my_free
Boian> T@4367365: | | my: ptr: 81a19b8
Boian> T@4367365: | <my_free
Boian> T@4367365: <close_connection
Boian> T@4367365: >end_thread
Boian> T@4367365: | >free_root
Boian> T@4367365: | <free_root
Boian> T@4367365: | >my_free
Boian> T@4367365: | | my: ptr: 8187900
Boian> T@4367365: | <my_free
Boian> T@4367365: | >my_free
Boian> T@4367365: | | my: ptr: 818cb50
Boian> T@4367365: | <my_free
Boian> T@4367365: | >my_free
Boian> T@4367365: | | my: ptr: 818d1a0
Boian> T@4367365: | <my_free
Boian> T@4367365: | >my_free
Boian> T@4367365: | | my: ptr: 81a59c0
Boian> T@4367365: | <my_free
Boian> T@1025 : | >process_alarm
Boian> T@1025 : | | info: sig: 14 active alarms: 3
Boian> T@1025 : | <process_alarm
Boian> T@1025 : | >process_alarm
Boian> T@1025 : | | info: sig: 14 active alarms: 3
Boian> T@1025 : | | info: sending signal to waiting thread
Boian> T@1025 : | <process_alarm
Boian> T@4139010: | info: raw_net_read returned -1, errno: 4
Boian> T@4185092: | info: raw_net_read returned -1, errno: 4
Boian> T@1025 : | >process_alarm
Boian> T@1025 : | | info: sig: 14 active alarms: 3
Boian> T@1025 : | <process_alarm
Boian> T@1025 : | >process_alarm
Boian> T@1025 : | | info: sig: 14 active alarms: 3
Boian> T@1025 : | | info: sending signal to waiting thread
Boian> T@1025 : | <process_alarm
Boian> T@1025 : | >process_alarm
Boian> T@1025 : | | info: sig: 14 active alarms: 3
Boian> T@1025 : | | info: sending signal to waiting thread
Boian> T@1025 : | | info: sending signal to waiting thread
Boian> T@1025 : | <process_alarm
Boian> T@1024 : | >my_malloc
Boian> T@1024 : | | my: Size: 16384 MyFlags: 16
Boian> T@1024 : | | exit: ptr: 81a19b8
Boian> T@1024 : | <my_malloc
Boian> T@1024 : | >my_malloc
Boian> T@1024 : | | my: Size: 10 MyFlags: 0
Boian> T@1024 : | | exit: ptr: 8187900
Boian> T@1024 : | <my_malloc
Boian> T@1024 : | >create_new_thread
Boian> T@1025 : | >process_alarm
Boian> T@1025 : | | info: sig: 14 active alarms: 1
Boian> T@1025 : | | info: sending signal to waiting thread
Boian> T@1025 : | <process_alarm
Boian> T@1025 : | >process_alarm
Boian> T@1025 : | | info: sig: 14 active alarms: 1
Boian> T@1025 : | | info: sending signal to waiting thread
Boian> T@1025 : | <process_alarm
Boian> [ ------------- END OF DEBUG ------------ ]
Boian> Here is requesting Perl script (about 60 requests pres minute):
Boian> #!/usr/bin/perl
Boian> $host="localhost";
Boian> $db_table="table_name";
Boian> $db_user="user_name";
Boian> $db_pass="";
Boian> $username=$ARGV[0];
Boian> use DBI;
Boian> $|= 1; # Autoflush
DBI-> trace(2,"/tmp/dbi.out"); #Da tracvame DBI
Boian> $dbh =
> DBI->connect("DBI:mysql:database=$db_table:host=$host",$db_user,$db_pass) or exit 1;
Boian> my $sth=$dbh->prepare("select * from subscriptions where username='$username'
> order by restriction_id ") or exit 1;
Boian> $sth->execute();
Boian> while (my $ref = $sth->fetchrow_hashref()) {
Boian> print "$ref->{'restriction_id'} ";
Boian> }
Boian> print "\n";
Boian> $sth->finish;
Boian> $dbh->disconnect;
Boian> [ ---------------------- END OF PERL SCRIPT ---------------------- ]
Boian> How-To-Repeat:
Boian> Submitter-Id: <submitter ID>
Boian> Originator: Boian Ikonomov
Boian> Organization: ProLink Ltd
Boian> MySQL support: none
Boian> Synopsis: myslqd suddenly stops respondig
Boian> Severity: critical
Boian> Priority: high
Boian> Category: mysql
Boian> Class: sw-bug
Boian> Release: mysql-3.22.27 (Source distribution)
Boian> Server: lt-mysqladmin Ver 7.11 Distrib 3.22.27, for pc-linux-gnu on i686
Boian> TCX Datakonsult AB, by Monty
Boian> Server version 3.22.27
Boian> Protocol version 10
Boian> Connection Localhost via UNIX socket
Boian> UNIX socket /tmp/mysql.sock
Boian> Uptime: 3 hours 57 min 24 sec
Boian> Threads: 6 Questions: 6735 Slow queries: 0 Opens: 16 Flush tables: 1 Open
> tables: 12
Boian> Environment:
Boian> System: DUAL P III CPU Linux server 2.2.13 #2 SMP Fri Nov 5 17:43:45 EET 1999
> i686 unknown
Boian> Architecture: i686
Boian> Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
Boian> GCC: Reading specs from /usr/lib/gcc-lib/i586-pc-linux-gnulibc1/2.8.1/specs
Boian> gcc version 2.8.1
Boian> Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS=''
Boian> Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock
> --with-low-memory --with-mit-threads=yes
Boian> Perl: This is perl, version 5.004_04 built for i586-linux
Boian> ---------------------------------------------------------------------
Boian> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
Boian> posting. To request this thread, e-mail mysql-thread20204@stripped
Boian> To unsubscribe, send a message to the address shown in the
Boian> List-Unsubscribe header of this message. If you cannot see it,
Boian> e-mail mysql-unsubscribe@stripped instead.
