Cache Hosts - Which are tempting max_connect_errors?
Hi,
Is there a way in 4.X or 5.0 to tell which hosts are running up the
counter towards max_connect_errors? We'd like to be able to monitor this
and act accordingly? I've seen that they suggest to set it to 9 in
13.5.5.2 FLUSH Syntax to avoid it. I'm just wondering why they didn't say
to just use --skip-cache-host .
Thanks, Tuc
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [mysql] Re: SELECT to return 0 instead of NULL?
> > On Fri, May 23, 2008 at 8:23 AM, Tuc at T-B-O-H.NET <[EMAIL PROTECTED]> wrote: > > Hi, > > > >I'm running a query : > > > > SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='hotspot'; > > > >But if there aren't any rows in "radacct" for the UserName of > > "hotspot", it returns a NULL. Is there a way to change it to return 0 > > instead? (I can't change the application, but I can change the SQL) > > > > > SELECT IFNULL( SUM(AcctSessionTime),0) FROM radacct WHERE UserName='hotspot'; > Exactly what I need, thanks... I didn't see anything like that on the headers of : http://dev.mysql.com/doc/refman/5.0/en/select.html otherwise I wouldn't have asked. Thanks! Tuc -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SELECT to return 0 instead of NULL?
Hi, I'm running a query : SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='hotspot'; But if there aren't any rows in "radacct" for the UserName of "hotspot", it returns a NULL. Is there a way to change it to return 0 instead? (I can't change the application, but I can change the SQL) Thanks, Tuc -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Connection time out/slow response from server
Hi,
Running 4.1.22 created from FreeBSD ports on FreeBSD 5.5 .
I run under TCP Wrappers. Even if 1 foreign machine attempts
to contact us on the tcp port, the database becomes incredibly sluggish
or unresponsive at all.
Is there something I can do to prevent this from happening?
I'm using TCPWrappers to help control access to the database instead
of going to firewall rules. I'd rather not do this, defeats what
TCPWrappers was all about.
Thanks, Tuc
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
TCPWrappers and database unavailibility
Hi,
Running 4.1.22 created from FreeBSD ports on FreeBSD 5.5 .
I run under TCP Wrappers. Even if 1 foreign machine attempts
to contact us on the tcp port, the database becomes incredibly sluggish
or unresponsive.
phpmyadmin shows " MySQL said: #2003 - The server is not responding"
Is there something I can do to prevent this from causing all the problems?
Thanks, Tuc
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connections with bad DNS cause lockups
Hi, Ok, I created the file and I looked and see absolutely nothing about the bad connection attempt, only good ones. I've posted it to : http://vjofn.tucs-beachin-obx-house.com/mysqltrace.txt does anyone see anything that would give any clues? Thanks, Tuc > Hello. > > When I suggested to create a trace file, I wanted to find the place > where mysqld hangs. In my opinion, it is possible. You should > research the last entries at the end of the trace file (using tail, > for example) after mysql has hung. I'm not sure if we are able to find > any clues in the trace files when using clients with a good reverse. > > > Tuc at T-B-O-H <[EMAIL PROTECTED]> wrote: > > Hi, > > > >I hacked the Makefile so that it would recompile it with > > -debug on the version. I started it with "--debug" as part of the > > extra args passed to safe_mysqld. It started, and created a > > /tmp/mysqld.trace where its logging to. > > > >So far, no one with a broken reverse DNS has tried to > > contact the server However, me with a good reverse but no > > authority via the /etc/hosts.allow has gone against it 5 or > > 6 times, and the log doesn't even show any evidence. > > > >If it isn't showing any sort of logging of my illegal > > attempt, I'm concerned it will not show any attempts from the > > hosts that are causing the problems. > > > >Thanks, Tuc -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connections with bad DNS cause lockups
> > Hello. > > I don't know. You may want to hack MySQL source (it seems not > too hard to change the dbug/dbug.c file). As an alternative you can > make a feature request at: > http://bugs.mysql.com > Done. Thank you. > > In my opinion, timestamp is a helpful thing (however, it may affect the > performance which is already a very low when MySQL produces trace > files). In you case if MySQL really hangs you should be able to find > the significant difference in the logging behavior after it has hung. > I guess it won't log anything. And the last messages (mostly from > sql/hostname) should be exactly what you need. > The problem is that it will eventually recover itself and continue on its way until the next time. I am waiting for it to happen again stillI've turned monitoring on so that if it does start to become uncontactable I'll get paged. Thanks, Tuc > > > Tuc at T-B-O-H <[EMAIL PROTECTED]> wrote: > > Hi, > > > >Ok. Is there a way to get a timestamp in the file too? If > > this happens while I'm not near a machine I want to make sure I can > > find the right time frame in the file. > > > >Thanks, Tuc -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connections with bad DNS cause lockups
Hi, Ok. Is there a way to get a timestamp in the file too? If this happens while I'm not near a machine I want to make sure I can find the right time frame in the file. Thanks, Tuc > > Hello. > > When I suggested to create a trace file, I wanted to find the place > where mysqld hangs. In my opinion, it is possible. You should > research the last entries at the end of the trace file (using tail, > for example) after mysql has hung. I'm not sure if we are able to find > any clues in the trace files when using clients with a good reverse. > > > Tuc at T-B-O-H <[EMAIL PROTECTED]> wrote: > > Hi, > > > >I hacked the Makefile so that it would recompile it with > > -debug on the version. I started it with "--debug" as part of the > > extra args passed to safe_mysqld. It started, and created a > > /tmp/mysqld.trace where its logging to. > > > >So far, no one with a broken reverse DNS has tried to > > contact the server However, me with a good reverse but no > > authority via the /etc/hosts.allow has gone against it 5 or > > 6 times, and the log doesn't even show any evidence. > > > >If it isn't showing any sort of logging of my illegal > > attempt, I'm concerned it will not show any attempts from the > > hosts that are causing the problems. > > > >Thanks, Tuc > > > >> > >> Hello. > >> > >> > >> To make the suggestions, we should have enough amount of information. > >> If your MySQL server isn't heavy loaded, create a trace file and find > >> out the place where the new connections hang. See: > >> http://dev.mysql.com/doc/mysql/en/making-trace-files.html > >> > >> > >> > >> Tuc at T-B-O-H <[EMAIL PROTECTED]> wrote: > >> >> > >> >> Hello. > >> >> > >> >> In my opinion, we're a little kinked in this issue. Let's start over. > >> >> > >> >:( Sorry. I've been told by the GF that I have a habit of > >> > doing it to her too. > >> >> > >> >> In one of your posts you mentioned that the server runs lots > >> >> of other services besides the database. > >> >> > >> >Yes, according to my runbook, the server : > >> > > >> >1) Is an NFS server to 4 other servers for web traffic > >> > and logging. > >> >2) Is the primary MX server for 7 domains (About 100 > >> > emails a day) > >> >3) Runs a Listproc for 4 mailing lists (About 5 messages > >> > a day to 60 people) > >> >4) Runs MySQL (Approx 98 queries per hour) > >> >5) Runs [EMAIL PROTECTED] (2 processes) > >> >6) Runs an IMAP Server for 1 user who logs on 5-10 > >> > minutes a day > >> > > >> >The server pushes about 120kb/s a second > >> > according to MRTG for all that. > >> >> > >> >> Why do you think that > >> >> the cause of the server's weird behavior is MySQL? > >> >> > >> >Maybe I wasn't clear about it. The server is running > >> > perfectly. I'm running SETI on it since its normally bored out > >> > of its ever loving mind. When someone with a missing or bad > >> > reverse DNS (PTR) record attempts to connect to the MySQL > >> > server, any other connection via either the socket or the > >> > TCP socket ends up blocking and waiting. Every other service > >> > on the machine is fine, but MySQL becomes completely > >> > unresponsive. When I said "DOS", I meant only against MySQL. > >> > The rest of the machine is fine to process anything it wants. > >> >> > >> >> Is server still > >> >> working, but you are unable to reach it through the network, or it > >> >> is completely hung? > >> >> > >> >No other services are affected, only attempts to connect > >> > to MySQL via the socket or TCP. This makes what little access there > >> > is to the database (A searchable orchid database) stop, and monitoring > >> > detects it down and pages out. > >> > > >> > > >> >Thanks, Tuc > >> >> > >> >> >> > >> >> >> > >> >> >So if thats the way (FreeBSD ports), then besides the already > >> >> > suggested > >> >> > changing to pure IP, is there any other ways to stop the DOS? > >> >> > > >> >> >Thanks, Tuc > >> >> > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connections with bad DNS cause lockups
Hi,
I hacked the Makefile so that it would recompile it with
-debug on the version. I started it with "--debug" as part of the
extra args passed to safe_mysqld. It started, and created a
/tmp/mysqld.trace where its logging to.
So far, no one with a broken reverse DNS has tried to
contact the server However, me with a good reverse but no
authority via the /etc/hosts.allow has gone against it 5 or
6 times, and the log doesn't even show any evidence.
If it isn't showing any sort of logging of my illegal
attempt, I'm concerned it will not show any attempts from the
hosts that are causing the problems.
Thanks, Tuc
>
> Hello.
>
>
> To make the suggestions, we should have enough amount of information.
> If your MySQL server isn't heavy loaded, create a trace file and find
> out the place where the new connections hang. See:
> http://dev.mysql.com/doc/mysql/en/making-trace-files.html
>
>
>
> Tuc at T-B-O-H <[EMAIL PROTECTED]> wrote:
> >>
> >> Hello.
> >>
> >> In my opinion, we're a little kinked in this issue. Let's start over.
> >>
> >:( Sorry. I've been told by the GF that I have a habit of
> > doing it to her too.
> >>
> >> In one of your posts you mentioned that the server runs lots
> >> of other services besides the database.
> >>
> >Yes, according to my runbook, the server :
> >
> >1) Is an NFS server to 4 other servers for web traffic
> > and logging.
> >2) Is the primary MX server for 7 domains (About 100
> > emails a day)
> >3) Runs a Listproc for 4 mailing lists (About 5 messages
> > a day to 60 people)
> >4) Runs MySQL (Approx 98 queries per hour)
> >5) Runs [EMAIL PROTECTED] (2 processes)
> >6) Runs an IMAP Server for 1 user who logs on 5-10
> > minutes a day
> >
> >The server pushes about 120kb/s a second
> > according to MRTG for all that.
> >>
> >> Why do you think that
> >> the cause of the server's weird behavior is MySQL?
> >>
> >Maybe I wasn't clear about it. The server is running
> > perfectly. I'm running SETI on it since its normally bored out
> > of its ever loving mind. When someone with a missing or bad
> > reverse DNS (PTR) record attempts to connect to the MySQL
> > server, any other connection via either the socket or the
> > TCP socket ends up blocking and waiting. Every other service
> > on the machine is fine, but MySQL becomes completely
> > unresponsive. When I said "DOS", I meant only against MySQL.
> > The rest of the machine is fine to process anything it wants.
> >>
> >> Is server still
> >> working, but you are unable to reach it through the network, or it
> >> is completely hung?
> >>
> >No other services are affected, only attempts to connect
> > to MySQL via the socket or TCP. This makes what little access there
> > is to the database (A searchable orchid database) stop, and monitoring
> > detects it down and pages out.
> >
> >
> >Thanks, Tuc
> >>
> >> >>
> >> >>
> >> >So if thats the way (FreeBSD ports), then besides the already
> >> > suggested
> >> > changing to pure IP, is there any other ways to stop the DOS?
> >> >
> >> >Thanks, Tuc
> >> >
> >>
> >>
> >>
>
> --
> For technical support contracts, goto https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.NET http://www.ensita.net/
>__ ___ ___ __
> / |/ /_ __/ __/ __ \/ /Gleb Paharenko
> / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
> /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
><___/ www.mysql.com
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connections with bad DNS cause lockups
> > Hello. > > In my opinion, we're a little kinked in this issue. Let's start over. > :( Sorry. I've been told by the GF that I have a habit of doing it to her too. > > In one of your posts you mentioned that the server runs lots > of other services besides the database. > Yes, according to my runbook, the server : 1) Is an NFS server to 4 other servers for web traffic and logging. 2) Is the primary MX server for 7 domains (About 100 emails a day) 3) Runs a Listproc for 4 mailing lists (About 5 messages a day to 60 people) 4) Runs MySQL (Approx 98 queries per hour) 5) Runs [EMAIL PROTECTED] (2 processes) 6) Runs an IMAP Server for 1 user who logs on 5-10 minutes a day The server pushes about 120kb/s a second according to MRTG for all that. > > Why do you think that > the cause of the server's weird behavior is MySQL? > Maybe I wasn't clear about it. The server is running perfectly. I'm running SETI on it since its normally bored out of its ever loving mind. When someone with a missing or bad reverse DNS (PTR) record attempts to connect to the MySQL server, any other connection via either the socket or the TCP socket ends up blocking and waiting. Every other service on the machine is fine, but MySQL becomes completely unresponsive. When I said "DOS", I meant only against MySQL. The rest of the machine is fine to process anything it wants. > > Is server still > working, but you are unable to reach it through the network, or it > is completely hung? > No other services are affected, only attempts to connect to MySQL via the socket or TCP. This makes what little access there is to the database (A searchable orchid database) stop, and monitoring detects it down and pages out. Thanks, Tuc > > >> > >> > >So if thats the way (FreeBSD ports), then besides the already > > suggested > > changing to pure IP, is there any other ways to stop the DOS? > > > >Thanks, Tuc > > > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.NET http://www.ensita.net/ >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Gleb Paharenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ><___/ www.mysql.com > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connections with bad DNS cause lockups
> > Hello. > > > > is that when it gets probed, it COMPLETELY offlines (DOS) the server. > > One upon a time I solved such an issue with MySQL on FreeBSD by switching > to the official binaries from: > http://dev.mysql.com/downloads > > Still, the recommended way to run MySQL on FreeBSD is compiling it from the > ports. > > So if thats the way (FreeBSD ports), then besides the already suggested changing to pure IP, is there any other ways to stop the DOS? Thanks, Tuc -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connections with bad DNS cause lockups
Hi, I'm running FreeBSD 5.4 on the system in question. It was my understanding on newer Unixes that things like a call to gethostbyname(3) would cause it to go against the nsdispatch(3) in libc and determine what method to perform its various lookups. Right now its set to read nsswitch.conf and that has "hosts: files dns". That, to me, means it'll go against /etc/hosts first, then do lookups against bind. The problem I have switching to just "hosts: files" is that this system does alot of other services besides a database, that depend on being able to do reliable forward and reverse DNS queries. I understand you then want me to put all the names into my /etc/hosts, but doing so doesn't buy me what I need for all the rest of the services on the box. I also have TCPWrappers running depending on domain names out of my control, so it would mean that every time they added/deleted a host, I would have to be told of it. I think /etc/hosts would also do forward DNS only, while TCPWrappers also wants reverse DNS (PTR). While in concept the suggestion is a work around, I think it then breaks every thing around it. Thanks, Tuc -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connections with bad DNS cause lockups
Hi, (Lets not get into top/bottom/mixed post discussions. :) ) I'm not sure why putting in hosts would make a difference. Doesn't the --skip-name-resolve bypass any sort of name resolution, be it /etc/hosts or resolver? Or are you telling me to change nsswitch.conf from "hosts: files dns" to just "hosts: files"? Would be a SLIM possibility, if this wasn't a machine that didn't only do MySQL and other things in my TCPWrappers (/etc/hosts.allow) did partial domain matching for clients. Thanks, Tuc > > > (please, either top-post or bottom-post but don't mix it up) > > One way to bypass a broken DNS server is to create complete HOSTS files on > your servers. That way you can keep using your hostnames but avoid the > problems of actual DNS server negotiations going sour as all hostname to > IP address translations are handled locally. This is especially useful for > resolving internal names for resources that rarely change addresses (like > servers and most users). Then, the only names that pose a risk would be > those not on the list. > > It's not a perfect solution but it may keep you going until MySQL can > figure out something better to deal with misbehaving DNS servers. > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine > > Tuc at T-B-O-H <[EMAIL PROTECTED]> wrote on 09/01/2005 10:56:24 AM: > > > > > > > Hello. > > > > > > Have a look here: > > > http://dev.mysql.com/doc/mysql/en/dns.html > > > > > > You may want to start mysqld with the --skip-name-resolve option. > > > > > Hi, > > > > > >Thanks for the reply. I did see that page before, but > > I guess my bigger question is why if the DNS is broken/slow, why > > does the entire server come to a COMPLETE halt, no commands can > > be done via either TCP *OR* the socket. If it just errored, that > > session took forever, whatever... I could understand. The problem > > is that when it gets probed, it COMPLETELY offlines (DOS) the server. > > And just *1* connection! > > > >Just also seems difficult to keep proper documentation if > > we are using IPs and not complete hostnames. > > > > > > Thanks, Tuc > > > > > > Tuc at T-B-O-H <[EMAIL PROTECTED]> wrote: > > > > Hi, > > > > > > > >We seem to be running into a problem with our > > > > installation that we don't understand. > > > > > > > >We are running "mysql-server-4.0.25" from > > > > the ports collection on a FreeBSD 5.3-RELEASE-p10 > > > > machine. Its tcpwrapper'd to only allow from our > > > > /24, and a single machine outside the /24. > > > > > > > >At times, all of a sudden the server seems > > > > to "freeze". It appears that we've narrowed it down > > > > to an issue with people attacking the server that > > > > come from a site that has a bad reverse DNS setup. > > > > > > > >Has anyone else seen this, or knows how > > > > to stop it? > > > > > > > >Thanks, Tuc -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connections with bad DNS cause lockups
>
> Hello.
>
> Have a look here:
> http://dev.mysql.com/doc/mysql/en/dns.html
>
> You may want to start mysqld with the --skip-name-resolve option.
>
Hi,
Thanks for the reply. I did see that page before, but
I guess my bigger question is why if the DNS is broken/slow, why
does the entire server come to a COMPLETE halt, no commands can
be done via either TCP *OR* the socket. If it just errored, that
session took forever, whatever... I could understand. The problem
is that when it gets probed, it COMPLETELY offlines (DOS) the server.
And just *1* connection!
Just also seems difficult to keep proper documentation if
we are using IPs and not complete hostnames.
Thanks, Tuc
>
> Tuc at T-B-O-H <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> >We seem to be running into a problem with our
> > installation that we don't understand.
> >
> >We are running "mysql-server-4.0.25" from
> > the ports collection on a FreeBSD 5.3-RELEASE-p10
> > machine. Its tcpwrapper'd to only allow from our
> > /24, and a single machine outside the /24.
> >
> >At times, all of a sudden the server seems
> > to "freeze". It appears that we've narrowed it down
> > to an issue with people attacking the server that
> > come from a site that has a bad reverse DNS setup.
> >
> >Has anyone else seen this, or knows how
> > to stop it?
> >
> >Thanks, Tuc
> >
>
>
> --
> For technical support contracts, goto https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.NET http://www.ensita.net/
>__ ___ ___ __
> / |/ /_ __/ __/ __ \/ /Gleb Paharenko
> / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
> /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
><___/ www.mysql.com
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Connections with bad DNS cause lockups
Hi, We seem to be running into a problem with our installation that we don't understand. We are running "mysql-server-4.0.25" from the ports collection on a FreeBSD 5.3-RELEASE-p10 machine. Its tcpwrapper'd to only allow from our /24, and a single machine outside the /24. At times, all of a sudden the server seems to "freeze". It appears that we've narrowed it down to an issue with people attacking the server that come from a site that has a bad reverse DNS setup. Has anyone else seen this, or knows how to stop it? Thanks, Tuc -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
flush-hosts/tcpwrapper problems
Hi, I've got an odd setup that I need to diagnose. The customer won't allow us to upgrade very far with the OS or MySQL. Its currently on a BSD/OS 4.0.1 system, and 4.2 is the highest we could possibly be allowed to go. We have upgraded to mysql-3.23.58 (Customer won't let us go to 4 or 5), with the following patches from the RedHat distro: mysql-3.23.58-config.patch mysql-3.23.58-setpermission.patch mysql-3.23.58-dropdb.patch mysql-3.23.58-symlink.patch mysql-3.23.58-hotcopy.patch mysql-3.23.58-typo.patch mysql-3.23.58-security.patch The configure is just "./configure --with-libwrap". (We do have to go in to client/Makefile, mysys/Makefile and sql/Makefile to take the -fno-exceptions out otherwise it won't compile) With the recent reports of an issue with MySQL we've been getting alot of probes against the server. Its currently set to only allow connections from a monitoring machine, and locally. It appears that after a while the server starts to get QUITE slow... Requests take over a minute, even using the local socket. Until we do a "flush-hosts", it runs quite slow. Has anyone heard/seen/experienced this? On some other customer servers, we just had to put "mysqld:ALL" into /etc/hosts.allow to prevent the database from becoming unusable. Thanks, Tuc/TTSG Internet Services, Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Looking to resolve odd response to DOS
Hi, I've got an odd setup that I need to diagnose. The customer won't allow us to upgrade very far with the OS or MySQL. Its currently on a BSD/OS 4.0.1 system, and 4.2 is the highest we could possibly be allowed to go. We have upgraded to mysql-3.23.58 (Customer won't let us go to 4 or 5), with the following patches from the RedHat distro: mysql-3.23.58-config.patch mysql-3.23.58-setpermission.patch mysql-3.23.58-dropdb.patch mysql-3.23.58-symlink.patch mysql-3.23.58-hotcopy.patch mysql-3.23.58-typo.patch mysql-3.23.58-security.patch The configure is just "./configure --with-libwrap". (We do have to go in to client/Makefile, mysys/Makefile and sql/Makefile to take the -fno-exceptions out otherwise it won't compile) With the recent reports of an issue with MySQL we've been getting alot of probes against the server. Its currently set to only allow connections from a monitoring machine, and locally. It appears that after a while the server starts to get QUITE slow... Requests take over a minute, even using the local socket. Until we do a "flush-hosts", it runs quite slow. Has anyone heard/seen/experienced this? On some other customer servers, we just had to put "mysqld:ALL" into /etc/hosts.allow to prevent the database from becoming unusable. Thanks, Tuc/TTSG Internet Services, Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MYSQL dies after FreeBSD 4.6.2-cvsup-4.7
Hi, We just cvsup'd a FreeBSD machine from 4.6.2 to 4.7, made world, and installed a new kernel. Now mysql is complaining : Fatal error 'Can't create gc thread' at line ? in file /usr/src/lib/libc_r/uthre ad/uthread_create.c (errno = ?) 030129 10:36:35 mysqld restarted Fatal error 'Can't create gc thread' at line ? in file /usr/src/lib/libc_r/uthre ad/uthread_create.c (errno = ?) 030129 10:36:35 mysqld restarted Fatal error 'Can't create gc thread' at line ? in file /usr/src/lib/libc_r/uthre ad/uthread_create.c (errno = ?) Any ideas where to start? Tried to recompile mysql to see if it just needed that, and it didn't change anything. (This is 3.23.54a) Thanks, Tuc/TTSG Internet Services, Inc. - 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: Cannot compile on BSDI
> > Since the crash happens in the client directory, I tried even > configuring --without-client in pure desperation. It didn't > help; the compiler went into the client directory even then > and crashed just the same way. > > Does anyone know how to fix this? > After you run the configure, edit the "client/Makefile", and remove the "-fno-exceptions". Tuc/TTSG Internet Services, Inc. database,sql,query,table database,sql,query,table database,sql,query,table database,sql,query,table database,sql,query,table - 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
-fno-exceptions and BSDI 4.0.1/gcc 2.7.2.1
Hi,
Having an issue trying to get the latest MYSQLs to compile on
BSDI 4.0.1, with the default 2.7.2.1 GCC compiler. It appears there is an
"-fno-exceptions" in the Makefile, that the version of GCC that ships with
BSDI 4.0.1 doesn't grok. We are only building clients for 8 4.0.1 systems,
and the server will be on Solaris 2.7 and BSDI 4.2 .
Are we safe just removing it from the Makefile?
Thanks, Tuc/TTSG Internet Services, Inc.
database,sql,query,table
-
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
FINALLY, got a core!
Hi,
Well, 45 days later after doing everything I could to get it to
dump a core (3.22.32), it did!
So, the results are :
Program terminated with signal 11, Segmentation fault.
#0 0x808bfef in get_best_combination (join=0xc244808) at sql_select.cc:1638
1638*j= *join->best_positions[tablenr].table;
(gdb) bt
#0 0x808bfef in get_best_combination (join=0xc244808) at sql_select.cc:1638
#1 0x808aa10 in make_join_statistics (join=0xc244808, tables=0x0, conds=0x0,
keyuse_array=0xc244d50) at sql_select.cc:899
#2 0x8089311 in mysql_select (thd=0x8932000, tables=0x895c0c8,
fields=@0x893237c, conds=0x0, order=0x895c150, group=0x0, having=0x0,
proc_param=0x0, select_options=5120, result=0x895c180) at sql_select.cc:337
#3 0x8075954 in mysql_execute_command () at sql_parse.cc:687
#4 0x807723f in mysql_parse (thd=0x8932000,
inBuf=0x895c010 "SELECT * from Cache_0001 ORDER BY Entry_Number LIMIT 0,1",
length=60) at sql_parse.cc:1377
#5 0x8075064 in do_command (thd=0x8932000) at sql_parse.cc:428
#6 0x8074b0b in handle_one_connection (arg=0x8932000) at sql_parse.cc:292
#7 0xc203868 in _thread_kern_start ()
(gdb)
Ok! So, where do I go from here?!
Thanks, Tuc/TTSG Internet Services, Inc.
-
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: Host "" is not allowed to connect to this MySQL Server
> > I guess if you are updating user columns directly, you need to restart > mysqld in order for changes to take effect... I think, that was a case > with me... > I find a "mysqladmin flush-hosts" fixes it for me. WHY, no one ever has figured out why. When one or more of the systems decides it can't talk to the server, I just run that and its all happy again. Thanks, Tuc/TTSG Internet Services, Inc. - 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
FOLLOWUP - Seg Fault/No core, WHY?
Hi, So far for everyone that asked about the permissions on my directories that I've replied to, no one has said I had a permission issue. We tried to upgrade to 3.23.37, and used : gmake distclean PATH=/usr/local/bin:/sbin:/usr/sbin:/bin:/usr/bin:/usr/contrib/bin:/usr/X11/bin export PATH CXXFLAGS=-g export CXXFLAGS ./configure --with-debug --with-mysqld-user=mysql --with-libwrap=/usr/lib --loca lstatedir=/usr/home/wwwcust1/mysql --enable-static gmake That seemed to be fine. HOWEVER, when it came to Msql-Mysql-modules 1.2213, all heck broke loose. During the configure we saw : kvasir# more doit /usr/local/bin/perl Makefile.PL --static --config kvasir# sh doit /usr/local/bin/perl: can't resolve symbol 'compress' /usr/local/bin/perl: can't resolve symbol 'uncompress' Which drivers do you want to install? 1) MySQL only 2) mSQL only (either of mSQL 1 or mSQL 2) 3) MySQL and mSQL (either of mSQL 1 or mSQL 2) 4) mSQL 1 and mSQL 2 5) MySQL, mSQL 1 and mSQL 2 Enter the appropriate number: [3] A search of the archives said to add "-lz" to the libs. This didn't help, it began to complain about some symbol "newSVpvn". When I went to revert back to the previous mysql (3.22.32) it went fine, but Msql-Mysql-modules 1.2213 still had problems with compress/ uncompress. I had to install it, get a list of all the files involved, remove them, and reconfigure/install and it was ok. We need to fall back and continue trying to debug why the install falls over, and (to a lesser extent) why it doesn't produce a core. (Then again, to debug, it might take producing the core first so there is something to debug). Thanks, Tuc/TTSG Internet Services, Inc - 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
Seg Fault/No core, WHY?
Hi, We've got a situation happening on a server, and have no idea why. The server is a PII/600 with 1G memory, running BSDI 4.0.1 . The Mysql is "mysql-3.22.32", and was compiled with : gmake distclean PATH=/usr/local/bin:/sbin:/usr/sbin:/bin:/usr/bin:/usr/contrib/bin:/usr/X11/bin export PATH CXXFLAGS=-g export CXXFLAGS ./configure --with-debug --with-mysqld-user=mysql --with-libwrap=/usr/lib --loca lstatedir=/usr/home/wwwcust1/mysql --enable-static gmake We currently use perl 5.004_04, Apache 1.3.14, mod_perl 1.21 Msql-Mysql-modules 1.2213 and php 4.0.3pl1 to access the databases. This was a pretty stable install for about a year, until we had 2 crashes about a month apart. After that, we updated from running under root to running under "mysql" user. At that point, it looks like we fail irregularly : mysqld started on Sat Apr 21 08:37:56 EDT 2001 /usr/local/libexec/mysqld: ready for connections 010424 11:25:39 /usr/local/libexec/mysqld: Normal shutdown 010424 11:25:40 /usr/local/libexec/mysqld: Shutdown Complete mysqld ended on Tue Apr 24 11:25:40 EDT 2001 mysqld started on Tue Apr 24 11:25:47 EDT 2001 /usr/local/libexec/mysqld: ready for connections mysqld started on Thu Apr 26 05:21:05 EDT 2001 /usr/local/libexec/mysqld: ready for connections mysqld ended on Fri May 11 13:26:34 EDT 2001 mysqld started on Fri May 11 13:41:06 EDT 2001 /usr/local/libexec/mysqld: ready for connections mysqld ended on Sat May 12 23:46:41 EDT 2001 mysqld started on Sat May 12 23:55:15 EDT 2001 /usr/local/libexec/mysqld: ready for connections mysqld ended on Tue May 15 10:45:49 EDT 2001 mysqld started on Tue May 15 10:50:24 EDT 2001 /usr/local/libexec/mysqld: ready for connections mysqld ended on Wed May 16 12:05:14 EDT 2001 mysqld started on Wed May 16 12:12:56 EDT 2001 /usr/local/libexec/mysqld: ready for connections April 24 is when we changed from running as root to running as the "mysql" user. The ODD thing is that we don't get a core dump of any sort. The only way we get ANY indication something happened is that we see : Starting mysqld daemon with databases from /usr/home/wwwcust1/mysql Segmentation fault mysqld daemon ended as the output of starting it as : echo "/usr/local/bin/safe_mysqld"|at now We also were doing a "mysqladmin status" on it every 10 minutes, and the last one was : Uptime: 90576 Threads: 1 Questions: 59880 Slow queries: 10 Opens: 19 Flush tables: 1 Open tables: 11 We run about 3 other servers configured with the same versions,etc, and they are all stable. I know the first thing people will say is "UPGRADE", but I'd like to see if there is something we can do while we try to schedule this with the user. Or, something we should do when we put the lastest in incase it has the same behaviour. Thanks, Tuc/TTSG Internet Services, Inc. - 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
