Kannan, error 1000001 used to mean a lock wait timeout. In 4.0.1 and later 3.23 versions that has been replaced by a new 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] <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Date: Sunday, March 17, 2002 3:48 PM Subject: mysql error > > Placed At : > > >Hi ... > >I have a database having 30 tables..i run mysql-4.0.0 with innodb..updates and >delete on one paritcular table fail ..when i run the query the prompt jus t >hangs and i get the following error.. > >ERROR 1030: Got error 1000001 from table handler > >I'm also not able to create a new table by selecting from this table.. > >would be great if someone cld help me with this.. > >thanx >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
