Re: Re[4]: mysql 4.0.8- crash on TCP connection
Hi! - Original Message - From: ""Gelu Gogancea"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Friday, January 10, 2003 1:25 PM Subject: Re: Re[4]: mysql 4.0.8- crash on TCP connection > Hi, > It seems is happens to all which use InnoDB.Is announced that will be solved > in 4.0.9. The bug has nothing to do with InnoDB. I think the bug is the following: http://www.mysql.com/doc/en/News-4.0.9.html " Bugs fixed: ... A security patch in 4.0.8 causes the mysqld server to die if the remote hostname can't be resolved. This is now fixed. " A general note: the bug list of MySQL is the changelog in the manual, because it lists also upcoming releases. By looking there you often find the explanation why some version does not work. For InnoDB the bug list is http://www.innodb.com/ibman.html#InnoDB_history. > Regards, > > Gelu Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB sql query > _ > G.NET SOFTWARE COMPANY > > Permanent e-mail address : [EMAIL PROTECTED] > [EMAIL PROTECTED] > - Original Message - > From: "Johannes Ullrich" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, January 10, 2003 4:28 AM > Subject: Re: Re[4]: mysql 4.0.8- crash on TCP connection > > > > On Thu, 9 Jan 2003 22:56:04 +0200 > > "Gelu Gogancea" <[EMAIL PROTECTED]> wrote: > > > > > > All this is very interesting, BUT i have two binary builds (4.0.7 & > > > 4.0.8), > > > Ha,Hayou are gentle. > > > > > > > (load avg 10-60 Query/sec), and 4.0.8 crash (in some > > > > hardware/software) after 2 seconds work :( > > > > > > > Did you see any relationship with 'replication'? I just downloaded > > 4.0.8. All it did was act as a slave. It crashed after a large > > 'load table' from the master and now refuses to start. Looks like > > it crashes as it read the relay-log-info file or just after it does > > so. > > > > at least thats my latest theory after doing more backtrace resolving, > > stracing and experimenting. > > > > did submit one or two bug reports about this. > > > > > > -- > > > > [EMAIL PROTECTED] Collaborative Intrusion Detection > > join http://www.dshield.org > > > > - > > 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 > > > > > > > - > 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 > - 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
Re: Re[4]: mysql 4.0.8- crash on TCP connection
Hi, It seems is happens to all which use InnoDB.Is announced that will be solved in 4.0.9. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: "Johannes Ullrich" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, January 10, 2003 4:28 AM Subject: Re: Re[4]: mysql 4.0.8- crash on TCP connection > On Thu, 9 Jan 2003 22:56:04 +0200 > "Gelu Gogancea" <[EMAIL PROTECTED]> wrote: > > > > All this is very interesting, BUT i have two binary builds (4.0.7 & > > 4.0.8), > > Ha,Hayou are gentle. > > > > > (load avg 10-60 Query/sec), and 4.0.8 crash (in some > > > hardware/software) after 2 seconds work :( > > > > Did you see any relationship with 'replication'? I just downloaded > 4.0.8. All it did was act as a slave. It crashed after a large > 'load table' from the master and now refuses to start. Looks like > it crashes as it read the relay-log-info file or just after it does > so. > > at least thats my latest theory after doing more backtrace resolving, > stracing and experimenting. > > did submit one or two bug reports about this. > > > -- > > [EMAIL PROTECTED] Collaborative Intrusion Detection > join http://www.dshield.org > > - > 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 > > - 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
Re: Re[4]: mysql 4.0.8- crash on TCP connection
On Thu, 9 Jan 2003 22:56:04 +0200 "Gelu Gogancea" <[EMAIL PROTECTED]> wrote: > > All this is very interesting, BUT i have two binary builds (4.0.7 & > 4.0.8), > Ha,Hayou are gentle. > > > (load avg 10-60 Query/sec), and 4.0.8 crash (in some > > hardware/software) after 2 seconds work :( > Did you see any relationship with 'replication'? I just downloaded 4.0.8. All it did was act as a slave. It crashed after a large 'load table' from the master and now refuses to start. Looks like it crashes as it read the relay-log-info file or just after it does so. at least thats my latest theory after doing more backtrace resolving, stracing and experimenting. did submit one or two bug reports about this. -- [EMAIL PROTECTED] Collaborative Intrusion Detection join http://www.dshield.org - 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
Re[4]: mysql 4.0.8- crash on TCP connection
Hello , GG> Functions gethostby* ,from glibc, work directly with the /etc/hosts file.If GG> this functions didn't find an entry for the client, will be crashed. GG> I try to find in the Andrew e-mail if he has installed the glibc 2.2.x but i GG> don't see nothing about it. #> uname -a Linux gap 2.4.20-grsec #1 SMP Fri Dec 6 23:17:05 EET 2002 i686 unknown #>cat /etc/SuSE-release SuSE Linux 7.3 (i386) VERSION = 7.3 #> rpm -qa | grep glibc glibc-i18ndata-2.2.4-77 glibc-profile-2.2.4-77 glibc-html-2.2.4-77 glibc-info-2.2.4-77 glibc-devel-2.2.4-77 glibc-2.2.4-77 GG> What i see is, he use 2.95.x which is declared by GG> MySQL like unstable.In this context can be a coincidence what is happened. I used binary distribution. GG> Also i don't find difference in MYSQL daemon source code(hostname.cc) GG> between 4.0.7 and 4.0.8. I thing that this is "build" problem in binary distribution. P.S sql,query,queries,smallint :) Best regards, Andrew Sitnikov e-mail : [EMAIL PROTECTED] GSM: (+372) 56491109 - 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
Re: Re[4]: mysql 4.0.8- crash on TCP connection
> All this is very interesting, BUT i have two binary builds (4.0.7 & 4.0.8), Ha,Hayou are gentle. > (load avg 10-60 Query/sec), and 4.0.8 crash (in some > hardware/software) after 2 seconds work :( If i understand well it crashed even if no one is connected ? Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: "Andrew Sitnikov" <[EMAIL PROTECTED]> To: "Gelu Gogancea" <[EMAIL PROTECTED]> Cc: "Christopher E. Brown" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, January 09, 2003 10:28 PM Subject: Re[4]: mysql 4.0.8- crash on TCP connection > Hello Gelu, > > >> No, the glibc gethostby* will walk the tree defined in hosts.conf, > >> normally files,dns. A non-find in /etc/hosts followed by a >NXDOMAIN > GG> If you said soanyhow gethostby* is used by DNS and no reverse. > GG> The Name Server(named) use this both functions depending by the order line > GG> in /etc/host.conf.And after this read the /etc/hosts.Depend on the action > GG> this file is call "host database file" or "static table for host names". > All this is very interesting, BUT i have two binary builds (4.0.7 & 4.0.8), > downloaded from mysql mirror, and 4.0.7 work for me about 1 month with out problems > (load avg 10-60 Query/sec), and 4.0.8 crash (in some > hardware/software) after 2 seconds work :( > > > Best regards, > Andrew Sitnikov > e-mail : [EMAIL PROTECTED] > GSM: (+372) 56491109 > > - 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
Re[4]: mysql 4.0.8- crash on TCP connection
Hello Gelu, >> No, the glibc gethostby* will walk the tree defined in hosts.conf, >> normally files,dns. A non-find in /etc/hosts followed by a >NXDOMAIN GG> If you said soanyhow gethostby* is used by DNS and no reverse. GG> The Name Server(named) use this both functions depending by the order line GG> in /etc/host.conf.And after this read the /etc/hosts.Depend on the action GG> this file is call "host database file" or "static table for host names". All this is very interesting, BUT i have two binary builds (4.0.7 & 4.0.8), downloaded from mysql mirror, and 4.0.7 work for me about 1 month with out problems (load avg 10-60 Query/sec), and 4.0.8 crash (in some hardware/software) after 2 seconds work :( Best regards, Andrew Sitnikov e-mail : [EMAIL PROTECTED] GSM: (+372) 56491109 - 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
Re: Re[2]: mysql 4.0.8- crash on TCP connection
sql,query,queries,smallint > No, the glibc gethostby* will walk the tree defined in hosts.conf, > normally files,dns. A non-find in /etc/hosts followed by a >NXDOMAIN If you said soanyhow gethostby* is used by DNS and no reverse. The Name Server(named) use this both functions depending by the order line in /etc/host.conf.And after this read the /etc/hosts.Depend on the action this file is call "host database file" or "static table for host names". > from DNS results in a negative return from the gethostby* call. If it find something return a hostent data struct else is a NULL POINTER. Conclusioni think we talk about two different thing Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: "Christopher E. Brown" <[EMAIL PROTECTED]> To: "Gelu Gogancea" <[EMAIL PROTECTED]> Cc: "Andrew Sitnikov" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, January 09, 2003 9:38 PM Subject: Re: Re[2]: mysql 4.0.8- crash on TCP connection - 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
Re: Re[2]: mysql 4.0.8- crash on TCP connection
On Thu, 9 Jan 2003, Gelu Gogancea wrote: > > Functions gethostby* ,from glibc, work directly with the /etc/hosts file.If > this functions didn't find an entry for the client, will be crashed. > I try to find in the Andrew e-mail if he has installed the glibc 2.2.x but i > don't see nothing about it.What i see is, he use 2.95.x which is declared by > MySQL like unstable.In this context can be a coincidence what is happened. > Also i don't find difference in MYSQL daemon source code(hostname.cc) > between 4.0.7 and 4.0.8. > Regards, > > Gelu No, the glibc gethostby* will walk the tree defined in hosts.conf, normally files,dns. A non-find in /etc/hosts followed by a NXDOMAIN from DNS results in a negative return from the gethostby* call. *This should never cause a crash*, it is not a failure in the resolver code, it is a negative result. As to gcc, 2.95.3 is fine and stable, the notes you mention refer to gcc 2.96, an *unofficial* gcc release, a heavily patched monster released by RedHat and (for a while) used in alot of places. -- I route, therefore you are. - 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
Re: Re[2]: mysql 4.0.8- crash on TCP connection
Functions gethostby* ,from glibc, work directly with the /etc/hosts file.If this functions didn't find an entry for the client, will be crashed. I try to find in the Andrew e-mail if he has installed the glibc 2.2.x but i don't see nothing about it.What i see is, he use 2.95.x which is declared by MySQL like unstable.In this context can be a coincidence what is happened. Also i don't find difference in MYSQL daemon source code(hostname.cc) between 4.0.7 and 4.0.8. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: "Christopher E. Brown" <[EMAIL PROTECTED]> To: "Gelu Gogancea" <[EMAIL PROTECTED]> Cc: "Andrew Sitnikov" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, January 09, 2003 7:48 PM Subject: Re: Re[2]: mysql 4.0.8- crash on TCP connection > On Thu, 9 Jan 2003, Gelu Gogancea wrote: > > > Hi, > > This is a glibc problem.In this case you can start mysql daemon with option > > "--skip-name-resolve" and in this situation is no need to add the IP address > > of every client in hosts file.The disadvantage is that the client can not > > connect to the server using host alias. > > Regards, > > > > Gelu > > > Could you clarify "This is a glibc problem"? A known standard glibc > 2.2.5 against which every other piece of software functions correctly, > even when receiving null returns on reverse lookups, but 4.0.8 (both > precompiled binary and locally build) crashes on a null return. > Specially when (according to other reports) 4.0.7 functions correctly. > > > -- > I route, therefore you are. > > - 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
Re: Re[2]: mysql 4.0.8- crash on TCP connection
On Thu, 9 Jan 2003, Gelu Gogancea wrote: > Hi, > This is a glibc problem.In this case you can start mysql daemon with option > "--skip-name-resolve" and in this situation is no need to add the IP address > of every client in hosts file.The disadvantage is that the client can not > connect to the server using host alias. > Regards, > > Gelu Could you clarify "This is a glibc problem"? A known standard glibc 2.2.5 against which every other piece of software functions correctly, even when receiving null returns on reverse lookups, but 4.0.8 (both precompiled binary and locally build) crashes on a null return. Specially when (according to other reports) 4.0.7 functions correctly. -- I route, therefore you are. - 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
Re: Re[2]: mysql 4.0.8- crash on TCP connection
Hi, This is a glibc problem.In this case you can start mysql daemon with option "--skip-name-resolve" and in this situation is no need to add the IP address of every client in hosts file.The disadvantage is that the client can not connect to the server using host alias. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: "Andrew Sitnikov" <[EMAIL PROTECTED]> To: "Christopher E. Brown" <[EMAIL PROTECTED]> Cc: "Gelu Gogancea" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, January 09, 2003 7:19 PM Subject: Re[2]: mysql 4.0.8- crash on TCP connection > Hello Christopher, > > CEB> This sounds like what I just submitted a bug report for. Connections > CEB> to 4.0.8 (compiled locally or binary distro) cause a server crash if > CEB> the IP of the client is not resolvable in DNS. > Yes ! I really have crash only when client(user) not has DNS records ! > But with 4.0.7 this client(user) working properly. > > CEB> One can add an entry to the hosts file for certain IPs to stop this, > CEB> however this still leaves the fact that ANY IP that can connect to the > CEB> server can crash it if there is no reverse entry. > > > CEB> -- > CEB> I route, therefore you are. > > > > > Best regards, > Andrew Sitnikov > e-mail : [EMAIL PROTECTED] > GSM: (+372) 56491109 > > - 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
Re: mysql 4.0.8- crash on TCP connection
On Thu, 9 Jan 2003, Gelu Gogancea wrote: > Hi, > What OS you use ? > > Regards, > > Gelu > _ > G.NET SOFTWARE COMPANY > > Permanent e-mail address : [EMAIL PROTECTED] > [EMAIL PROTECTED] > - Original Message - > From: "Andrew Sitnikov" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, January 08, 2003 8:14 PM > Subject: mysql 4.0.8- crash on TCP connection > > > > Hello mysql, > > > > I try use 4.0.8 (max & standard)in our production box, > > and it was crash every TCP connection, For 4.0.7 (standard) i has over > 20 days uptime. This sounds like what I just submitted a bug report for. Connections to 4.0.8 (compiled locally or binary distro) cause a server crash if the IP of the client is not resolvable in DNS. One can add an entry to the hosts file for certain IPs to stop this, however this still leaves the fact that ANY IP that can connect to the server can crash it if there is no reverse entry. -- I route, therefore you are. - 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
Re: Re[4]: mysql 4.0.8- crash on TCP connection
Hi, Try to start mysql daemon with "--skip-innodb" and see if the problem persist.I suppose is something wrong with your my.cnf configuration. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: "Andrew Sitnikov" <[EMAIL PROTECTED]> To: "Gelu Gogancea" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, January 09, 2003 6:05 PM Subject: Re[4]: mysql 4.0.8- crash on TCP connection > Hello Gelu, > > GG> Hi Andrew, > GG> I can not reproduce your case.For me work good.The only difference is that i > GG> use source distribution and you use a binary distribution. > GG> Please take a look in mysql log and tell me what you see there. > GG> Regards, > > 030108 20:12:09 mysqld started > 030108 20:12:10 InnoDB: Started > /usr/local/mysql/bin/mysqld: ready for connections > mysqld got signal 11; > This could be because you hit a bug. It is also possible that this binary > or one of the libraries it was linked against is corrupt, improperly built, > or misconfigured. This error can also be caused by malfunctioning hardware. > We will try our best to scrape up some info that will hopefully help diagnose > the problem, but since we have already crashed, something is definitely wrong > and this may fail. > > key_buffer_size=402653184 > read_buffer_size=2093056 > sort_buffer_size=2097144 > max_used_connections=1 > max_connections=200 > threads_connected=1 > It is possible that mysqld could use up to > key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 1211614 K > bytes of memory > Hope that's ok; if not, decrease some variables in the equation. > > thd=0x8704638 > Attempting backtrace. You can use the following information to find out > where mysqld died. If you see no messages after this, something went > terribly wrong... > Cannot determine thread, fp=0xb397f608, backtrace may not be correct. > Stack range sanity check OK, backtrace follows: > 0x806f3bb > 0x8269928 > 0x807724c > 0x8077665 > 0x82670dc > 0x829c67a > New value of fp=(nil) failed sanity check, terminating stack trace! > Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved > stack trace is much more helpful in diagnosing the problem, so please do > resolve it > Trying to get some variables. > Some pointers may be invalid and cause the dump to abort... > thd->query at (nil) is invalid pointer > thd->thread_id=10 > > Successfully dumped variables, if you ran with --log, take a look at the > details of what thread 10 did to cause the crash. In some cases of really > bad corruption, the values shown above may be invalid. > > The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains > information that should help you find out what is causing the crash. > > Number of processes running now: 0 > 030108 20:12:25 mysqld restarted > 030108 20:12:26 InnoDB: Started > > >> Hello Gelu, > >> > >> GG> Hi, > >> GG> What OS you use ? > >> System: Linux gap 2.4.20-grsec #1 SMP Fri Dec 6 23:17:05 EET 2002 i686 > GG> unknown > >> Architecture: i686 > >> > >> Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake > GG> /home/local/sitnikov/bin/gcc /home/local/sitnikov/bin/cc > >> GCC: Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.3/specs > >> gcc version 2.95.3 20010315 (SuSE) > >> Compilation info: CC='gcc' CFLAGS='-O2 -mcpu=pentiumpro' CXX='gcc' > GG> CXXFLAGS='-O2 -mcpu=pentiumpro -felide-constructors' LD > >> FLAGS='' ASFLAGS='' > >> LIBC: > >> -rwxr-xr-x1 root root 1384072 Oct 1 19:10 /lib/libc.so.6 > >> -rw-r--r--1 root root 25215016 Oct 1 18:56 /usr/lib/libc.a > >> -rw-r--r--1 root root 178 Oct 1 18:56 /usr/lib/libc.so > >> > Best regards, > Andrew Sitnikov > e-mail : [EMAIL PROTECTED] > > - 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
Re[4]: mysql 4.0.8- crash on TCP connection
Hello Gelu, GG> Hi Andrew, GG> I can not reproduce your case.For me work good.The only difference is that i GG> use source distribution and you use a binary distribution. GG> Please take a look in mysql log and tell me what you see there. GG> Regards, 030108 20:12:09 mysqld started 030108 20:12:10 InnoDB: Started /usr/local/mysql/bin/mysqld: ready for connections mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=402653184 read_buffer_size=2093056 sort_buffer_size=2097144 max_used_connections=1 max_connections=200 threads_connected=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 1211614 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x8704638 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xb397f608, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x806f3bb 0x8269928 0x807724c 0x8077665 0x82670dc 0x829c67a New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at (nil) is invalid pointer thd->thread_id=10 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 10 did to cause the crash. In some cases of really bad corruption, the values shown above may be invalid. The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains information that should help you find out what is causing the crash. Number of processes running now: 0 030108 20:12:25 mysqld restarted 030108 20:12:26 InnoDB: Started >> Hello Gelu, >> >> GG> Hi, >> GG> What OS you use ? >> System: Linux gap 2.4.20-grsec #1 SMP Fri Dec 6 23:17:05 EET 2002 i686 GG> unknown >> Architecture: i686 >> >> Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake GG> /home/local/sitnikov/bin/gcc /home/local/sitnikov/bin/cc >> GCC: Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.3/specs >> gcc version 2.95.3 20010315 (SuSE) >> Compilation info: CC='gcc' CFLAGS='-O2 -mcpu=pentiumpro' CXX='gcc' GG> CXXFLAGS='-O2 -mcpu=pentiumpro -felide-constructors' LD >> FLAGS='' ASFLAGS='' >> LIBC: >> -rwxr-xr-x1 root root 1384072 Oct 1 19:10 /lib/libc.so.6 >> -rw-r--r--1 root root 25215016 Oct 1 18:56 /usr/lib/libc.a >> -rw-r--r--1 root root 178 Oct 1 18:56 /usr/lib/libc.so >> Best regards, Andrew Sitnikov e-mail : [EMAIL PROTECTED] - 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
Re: mysql 4.0.8- crash on TCP connection
Hi, What OS you use ? Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: "Andrew Sitnikov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, January 08, 2003 8:14 PM Subject: mysql 4.0.8- crash on TCP connection > Hello mysql, > > I try use 4.0.8 (max & standard)in our production box, > and it was crash every TCP connection, For 4.0.7 (standard) i has over 20 days uptime. > > Best regards, > Andrew Sitnikov > e-mail : [EMAIL PROTECTED] > GSM: (+372) 56491109 > > > - > 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 > > - 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
mysql 4.0.8- crash on TCP connection
Hello mysql, I try use 4.0.8 (max & standard)in our production box, and it was crash every TCP connection, For 4.0.7 (standard) i has over 20 days uptime. Best regards, Andrew Sitnikov e-mail : [EMAIL PROTECTED] GSM: (+372) 56491109 - 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