error 127

2001-07-05 Thread jrevel
MySQL version .38 With a query that is supposed to retrieve something like 8 records from a MyISAM table, I often get the following error: 010705 16:16:26 read_next: Got error 127 when reading table ./sunbow_domains/junit_userprof and the query aborts. Also, I have very often the followin

innodb crash

2001-07-04 Thread jrevel
Hello, I have mysdl 3.23.38 with innodb (dont know which version) support on Linux RedHat 6.2 Mysqld crashed, and when I try to restart it, I have the following error: 010704 16:50:34 mysqld started InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB:

Multiple transactions with innodb

2001-06-23 Thread jrevel
Hello, does InnoDB fully supports multiple transactions ? ie transactions over several tables with multiple connexions. My problem is that I do not get a consistent view of the tables after the inserts or delete : records are missing, or seem to be still present.