RE: Subquery Crashes Server

Thank you for your response.  I can tar them up and send them, or I can wait
until 4.1.2 comes out.  If you think that it is already fixed, then maybe I
should just wait for its release.

Chris

-----Original Message-----
From: Sinisa Milivojevic [mailto:[email protected]]
Sent: Monday, May 10, 2004 12:04 PM
To: [email protected]
Cc: [email protected]
Subject: Re: Subquery Crashes Server


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



**********************************************************************
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged.
If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination, 
distribution, or copying of this communication is strictly
prohibited.
If you have received this communication in error,
please re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.


-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]