Re: Subquery Crashes Server
Sinisa Milivojevic <[email protected]>
| Newsgroups | gmane.comp.db.mysql.bugs |
|---|---|
| Message-ID | <[email protected]> |
Jeffus Chris - cjeffu writes: > Hello All, > Sorry this is so long, but I have attempted to answer all that I could > before sending this. > > First of all, the specs: > MySQL MAX 4.1.1 Installed using > "mysql-max-4.1.1-alpha-pc-linux-i686.tar.gz" > Red Hat Linux AS 2.1 > > Now the specifics: > I have 2 queries. Both are more complex than what I have posted, as I have > isolated the incident to the particular section of each query that is > causing the crash. The CUSTOMER table is 150K rows, the PART table is 200K, > and PARTSUPP is 800K. It appears that the server is crashing somewhere > around the Copy_field portion??? > > In trying to diagnose this, I download the debug version. Strange thing > there as well, the server crashes, but does not restart like in the alpha > version. > > 040510 16:39:29 mysqld restarted > 040510 16:39:29 Can't start server: Bind on TCP/IP port: Address already in > use > 040510 16:39:29 Do you already have another mysqld server running on port: > 3306 ? > 040510 16:39:29 Aborting > [skip] > > > Thanks for you consideration. > > Chris Jeffus > Acxiom Corporation > Conway, AR > 501.342.0447 > [email protected] > Hi! Thank you very much for writing to us. In order to be able to repeat the error we need your entire tables. I have tried with empty tables and it works. It also looks like one of the bugs fixed in 4.1.2. 4.1.2 should be out quite soon, one week or similar. -- Sincerely, -- For technical support contracts, go to https://order.mysql.com/?ref=msmi __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[email protected]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB /_/ /_/\_, /___/\___\_\___/ Full time Developer and Support Coordinator <___/ www.mysql.com Larnaca, Cyprus -- MySQL Bugs Mailing List For list archives: http://lists.mysql.com/bugs To unsubscribe: http://lists.mysql.com/[email protected]