Hello. Please, could you explain what does it mean 'Signal 11 without fail'. Usually after receiving such a signal MySQL crashes. Of course, it should do this in normal circumstances. What is in the error log? Check if the problem still exists on official binaries of 5.0.18.
Ian Sales (DBA) wrote: > Hi, > > I'm running a 5.0.16 instance on a Debian box (2.6.13 kernel). The > following statement causes a signal 11 without fail, and each time when > mysqld_safe restarts the daemon, no socket file is created: > > UPDATE X_Products.product_details AS pd , > X_Products.tblMaxProductStockDisplay AS sd SET pd.allocated = IF( > pd.stock_level>sd.intMaxStockDisplay , > (pd.stock_level-sd.intMaxStockDisplay) , 0 ) WHERE pd.product_uid = > sd.intProductID; > > I can find no reference to unsupported syntax or a bug. Has anyone else > had the same happen to them? > > - ian > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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]
