I tried even with
thread_stack=1000000000
(starting from thread_stack=100000 and increasing by 10 times each time)
It still keeps on crashing.
Note that my select is
SELECT * FROM PARTITIONED_A_1_1 AS PARTITIONED, PARTITIONED_B_1 AS
PARTITIONED_B WHERE PARTITIONED_B.ID=PARTITIONED.ID1) UNION
(SELECT * FROM PARTITIONED_A_1_1 AS PARTITIONED, PARTITIONED_B_1 AS
PARTITIONED_B WHERE PARTITIONED_B.ID=PARTITIONED.ID1) UNION
(SELECT * FROM PARTITIONED_A_1_1 AS PARTITIONED, PARTITIONED_B_1 AS
PARTITIONED_B WHERE PARTITIONED_B.ID=PARTITIONED.ID1) UNION
(SELECT * FROM PARTITIONED_A_1_1 AS PARTITIONED, PARTITIONED_B_1 AS
PARTITIONED_B WHERE PARTITIONED_B.ID=PARTITIONED.ID1) UNION
(SELECT * FROM PARTITIONED_A_1_1 AS PARTITIONED, PARTITIONED_B_1 AS
PARTITIONED_B WHERE PARTITIONED_B.ID=PARTITIONED.ID1) UNION
(SELECT * FROM PARTITIONED_A_1_1 AS PARTITIONED, PARTITIONED_B_1 AS
PARTITIONED_B WHERE PARTITIONED_B.ID=PARTITIONED.ID1) UNION
(SELECT * FROM PARTITIONED_A_1_1 AS PARTITIONED, PARTITIONED_B_1 AS
PARTITIONED_B WHERE PARTITIONED_B.ID=PARTITIONED.ID1) UNION
(SELECT * FROM PARTITIONED_A_1_1 AS PARTITIONED, PARTITIONED_B_1 AS
PARTITIONED_B WHERE PARTITIONED_B.ID=PARTITIONED.ID1) UNION
(SELECT * FROM PARTITIONED_A_1_1 AS PARTITIONED, PARTITIONED_B_1 AS
PARTITIONED_B WHERE PARTITIONED_B.ID=PARTITIONED.ID1) UNION
(SELECT * FROM PARTITIONED_A_1_1 AS PARTITIONED, PARTITIONED_B_1 AS
PARTITIONED_B WHERE PARTITIONED_B.ID=PARTITIONED.ID1) UNION
(SELECT * FROM PARTITIONED_A_1_1 AS PARTITIONED, PARTITIONED_B_1 AS
PARTITIONED_B WHERE PARTITIONED_B.ID=PARTITIONED.ID1) UNION
(SELECT * FROM PARTITIONED_A_1_1 AS PARTITIONED, PARTITIONED_B_1 AS
PARTITIONED_B WHERE PARTITIONED_B.ID=PARTITIONED.ID1)
I tried with Chambon's query as well, but it keeps on crashing too:
select JobStatus from Test where
((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((
(((((((((((((
JobStatus = 'xyz'
)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
))))))))))))))))))
;
> -----Messaggio originale-----
> Da: Sasha Pachev [mailto:[EMAIL PROTECTED]
> Inviato: lunedi 14 giugno 2004 21.56
> A: Leonardo Francalanci
> Cc: [EMAIL PROTECTED]
> Oggetto: Re: R: query string make mysqld crash (mysqld 4.0.20)
>
>
> Leonardo Francalanci wrote:
> > I have a similar problem with a list of union(s) (see my email, one
> > hour before yours).
> > It seems there is something in the way mysql parses the string
> > that makes it crash. I tried with version 4.1.2 as well, but
> > it keeps on crashing.
>
> Due to the architecture of the parser, if you have a lot of ( levels, eg
> ((((((...(expr)...))))), it needs a bigger thread stack. If it is
> absolutely
> critical for you to deal with those, increase the value of thread_stack.
> Otherwise (recommended), re-write the expression. Increasing
> thread_stack comes
> at a cost in memory usage.
>
> It is, nevertheless, a bug, for the server to coredump on this.
> The code does
> thread stack checking to make sure it does not exceed the limit,
> but apparently
> it does miss some cases.
>
>
> --
> Sasha Pachev
> Create online surveys at http://www.surveyz.com/
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
