At 19:10 02/11/2001 -0500, Ken wrote: Hi Ken, Unlucky with your report I can't able to begin any test for fix this behavior. Try to make notes about every step until reach the crash, then send me the notes and the structure of the tables.
Regards, Miguel >I'm running MySQL 3.23.41 on Win95 (just upgraded from an earlier 3.23 >beta, in case that would solve the problem). I have a moderately complex >query that causes the MySQL server to crash when I execute it. (invalid >page fault in module MYSQLD-OPT.EXE) > >The same query works fine on a Redhat version of MySQL I have access >to. It's definitely not a syntax error (not that a syntax error should >crash the database server). It even gives me the correct results. > >If I systematically remove a piece at a time from the SELECT portion, I >can eventually come up with a working query. But I can't narrow it down >to one part in particular. Certain combinations work, and certain ones >lead to this consistent crash. I just haven't identified a pattern. > >I tried dropping the database, then rebuilding it from a txt dump I made >from my production version of the database (the Redhat one). Didn't >help. The same query causes the same crash in Win95. > >I'm stumped. Does anyone know of a known issue with Win32 MySQL that >would cause this? Is there some way I can re-order my query to avoid this >problem? I'm paralyzed, now not being able to run my application in my >development environment. > >Thanks immensely to anyone who can help! > >- Ken > >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Miguel A. Solórzano <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - Săo Paulo, Brazil <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
