Anna, please check with
SHOW VARIABLES if InnoDB is enabled in mysqld. Also check with SHOW CREATE TABLE tablename that your tables really are of the InnoDB type. Error 127 means the 'table is crashed', and I think only MyISAM type tables can return that error number. An upgrade to 4.0.2 is recommended because 4.0.1 is an alpha version, and already 8 months old. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com ----- Original Message ----- From: ""Anna Carlsson"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Thursday, August 15, 2002 11:33 PM Subject: Losing data > Hej > > I have several databases with several tables in them and all works fine > except for one database that loses data. > I'm running mySQL 4.0.1-alpha-nt and the tables are all INNODB. > The problem is as follows: > > Table B references table A by a foreign key. I've filled table A with all the > data I want and are adding data to table B. After a couple of items, only a > few of the items are still in the table. Sometimes the other items reappear > after a couple of minutes, in other cases all items dissapear. Sometimes when > I run a select statement I get an error message from the table handler error > code 127. But I have no idea what that means. > > Has anyone experienced anything like this!? It's just to weird! I have no > idea what to do and are ready to give up and export it all to linux and > postgreSQL instead. > > Anna > > ________________________________________________________________ > > This message was sent using SkyBURST Mail Center. > http://www.skyburst.net > > > > --------------------------------------------------------------------- > 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
