On Sun, 2007-02-04 at 01:31 +0100, Kai Schaetzl wrote: > So, a Myriad of > error messages gets logged. The error is the second one as described on this > page and there doesn't seem to be a fix other than deleting the tables: > http://dev.mysql.com/doc/refman/5.0/en/innodb-troubleshooting-datadict.html > > The creation process may be fine for MyISAM tables, but there still would be > the MYI and MYD files missing and I think MyISAM needs these as well. > > So, is there a way to repair these tables somehow? I assume, as the above article tells us, this is related to some corruption within MySQL. BigSister is not MySQL-aware, it uses standard SQL in order to manipulate tables and their contents (e.g. "CREATE TABLE" for creating tables). Therefore, operations should either fail (it's not impossible that BigSister uses something MySQL 5 is unhappy with - haven't yet tested against MySQL 5, though wouldn't actually expect a problem) or succeed, but never leave behind half-existing tables. What does syslog say? Have you tried the suggestion in the above article: Remove the "abandoned" .frm files? Do they just reappear as soon as Big Sister tries to create the tables, next? Is the error message you get exactly the one that is cited? > Furthermore, when investigating this I became suspicious that BigSister > doesn't use MySQL logging, anyway. The tables are at 9KB and do not grow at > all. Well, as long as they do not exist, BigSister won't be able to write data into them. Sounds straightforward to me :-)) > Looking at them shows that there is no data in them. On the other hand, > the files in var/graph still exist and get updated with data it seems. RRD graphs are not touched by the DB data logger - data can be logged to both RRD and database (and this is the default). Best regards, Tom ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier. Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Bigsister-general mailing list suppressed https://lists.sourceforge.net/lists/listinfo/bigsister-general
Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.