Hi,
Using Mysql 4.0.20-standard-log since a few days
I encontred an error that I had never seen before.
Here is what I have done :
1_ create an innodb table :
create table Test (JobStatus varchar(32) ) type = innodb;
2_ Run the following request :
select JobStatus from Test where
(((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((
JobStatus = 'xyz'
)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
;
This imply a mysqld crash (and restart) each time I run the request !
I encontred this problem with 4.0.20-standard-log running on Solaris 8
and on Solaris 9.
If I made a try on the previous version I used (4.0.13, on Solaris 8)
everything work fine.
If I decrease the number of parenthesis to 2 * 88, It run
If I increase the number of parenthesis to higher than 2 * 88 mysqld crash
Is there a bug on 4.0.20 ? or do I miss-configure a variable ?
In a hostname.err we find :
> mysqld got signal 11;
> This could be because you hit a bug. It is also possible that this binary
> or one of the libraries it was linked against is corrupt, improperly built,
> or misconfigured. This error can also be caused by malfunctioning hardware.
> We will try our best to scrape up some info that will hopefully help diagnose
> the problem, but since we have already crashed, something is definitely wrong
> and this may fail.
>
> key_buffer_size=67108864
> read_buffer_size=1044480
> max_used_connections=0
> max_connections=128
> threads_connected=1
> It is possible that mysqld could use up to
> key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections =
1506815 K
> bytes of memory
> Hope that's ok; if not, decrease some variables in the equation.
>
> -e
> Number of processes running now: 0
> 040614 13:33:33 mysqld restarted
>
Thans for any help
Regards
--
Bernard CHAMBON
IN2P3 / CNRS (Centre de Calcul de LYON)
email: mailto:[EMAIL PROTECTED]
Tel : 04 72 69 42 18
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
