"Leonardo Francalanci" <[EMAIL PROTECTED]> wrote: > I'm using MySql version 4.1.1. > When I issue a query like > > (SELECT * FROM PARTITIONED_1_1 AS PARTITIONED, PARTITIONED2_1 AS > PARTITIONED2 WHERE > PARTITIONED2.ID=PARTITIONED.ID1) UNION (SELECT * FROM PARTITIONED_2_1 AS > PARTITIONED, PARTITIONED2_1 AS PARTITIONED2 WHE > RE PARTITIONED2.ID=PARTITIONED.ID1) UNION (SELECT * FROM PARTITIONED_3_1 AS > PARTITIONED, PARTITIONED2_1 AS PARTITIONED2 > WHERE PARTITIONED2.ID=PARTITIONED.ID1) UNION (SELECT * FROM PARTITIONED_4_1 > AS PARTITIONED, PARTITIONED2_1 AS PARTITIONE > D2 WHERE PARTITIONED2.ID=PARTITIONED.ID1) UNION (SELECT * FROM > PARTITIONED_1_2 AS PARTITIONED, PARTITIONED2_1 AS PARTITI > ONED2 WHERE PARTITIONED2.ID=PARTITIONED.ID1) UNION (SELECT * FROM > PARTITIONED_2_2 AS PARTITIONED, PARTITIONED2_1 AS PART > ITIONED2 WHERE PARTITIONED2.ID=PARTITIONED.ID1) UNION (SELECT * FROM > PARTITIONED_3_2 AS PARTITIONED, PARTITIONED2_1 AS P > ARTITIONED2 WHERE PARTITIONED2.ID=PARTITIONED.ID1) UNION (SELECT * FROM > PARTITIONED_4_2 AS PARTITIONED, PARTITIONED2_1 A > S PARTITIONED2 WHERE PARTITIONED2.ID=PARTITIONED.ID1) UNION (SELECT * FROM > PARTITIONED_1_1 AS PARTITIONED, PARTITIONED2_ > 2 AS PARTITIONED2 WHERE PARTITIONED2.ID=PARTITIONED.ID1) UNION (SELECT * > FROM PARTITIONED_2_1 AS PARTITIONED, PARTITIONE > D2_2 AS PARTITIONED2 WHERE PARTITIONED2.ID=PARTITIONED.ID1) UNION (SELECT * > FROM PARTITIONED_3_1 AS PARTITIONED, PARTITI > ONED2_2 AS PARTITIONED2 WHERE PARTITIONED2.ID=PARTITIONED.ID1) UNION (SELECT > * FROM PARTITIONED_4_1 AS PARTITIONED, PART > ITIONED2_2 AS PARTITIONED2 WHERE PARTITIONED2.ID=PARTITIONED.ID1) UNION > (SELECT * FROM PARTITIONED_1_2 AS PARTITIONED, P > ARTITIONED2_2 AS PARTITIONED2 WHERE PARTITIONED2.ID=PARTITIONED.ID1) UNION > (SELECT * FROM PARTITIONED_2_2 AS PARTITIONED > , PARTITIONED2_2 AS PARTITIONED2 WHERE PARTITIONED2.ID=PARTITIONED.ID1) > UNION (SELECT * FROM PARTITIONED_3_2 AS PARTITIO > NED, PARTITIONED2_2 AS PARTITIONED2 WHERE PARTITIONED2.ID=PARTITIONED.ID1) > UNION (SELECT * FROM PARTITIONED_4_2 AS PARTI > TIONED, PARTITIONED2_2 AS PARTITIONED2 WHERE > PARTITIONED2.ID=PARTITIONED.ID1) ORDER BY 1,2,3,4,5 > > (sorry for the format, but it is what I get from telnet) > > mysql crashes. > > I started mysql with --max_allowed_packet=100M, but nothing changes: it > keeps crashing. > > Should I change a variable? Which? >
Could you provide structure of tables and some data for testing? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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]
