Heikki Tuuri wrote: >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 > Hi there im fairly new myself from a PostgreSql background anyway is there a location to view and make copy of the error messages new and old types for reference and obviously one can quickly rectify.
Cheers Chuck Amadi Systems Programmer > --------------------------------------------------------------------- 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
