List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:December 27 1999 10:35pm
Subject:URGENT! Mysql suddenly stops answering (freezes).
View as plain text  
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.
Thread
URGENT! Mysql suddenly stops answering (freezes).Boian Ikonomov3 Dec
  • Re: URGENT! Mysql suddenly stops answering (freezes).sinisa3 Dec
  • URGENT! Mysql suddenly stops answering (freezes).Michael Widenius28 Dec
Re:URGENT! Mysql suddenly stops answering (freezes).Bobi3 Dec