Kannan, please upgrade to 3.23.49a or 4.0.1.
1000001 used to mean lock wait timeout. It has been replaced by a clear-English error code. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB ----- Original Message ----- From: <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Monday, April 01, 2002 1:30 PM Subject: mysql innodb error > > Placed At : > > > Hi ... > > I 'm getting this very odd error with my update query..I run mysql-4.0.0-alpha > on a redhat linux machine.. > My table type is innodb. > > the error is as follows.. > > ERROR 1030: Got error 1000001 from table handler > > I do not have a very complex table structure and this error comes up only for > one record or so..I restart the mysql on the server then the update starts > working for this record..I 'm not able to create another table selecting from > this table also..I feel that there is somekind of lock that gets set..but i have > fought for long with this problem .. > Should i go for a higher version of mysql can anyone suggest please.. > > regards > kannan > > > > **************************************************************************** ****************** > > Quality Policy > > "To be the best-in-class service provider by practising international > standards > in providing world-class services and end-to-end network solutions." > **************************************************************************** ****************** > > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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
