Thomas Aeby wrote on Tue, 06 Feb 2007 17:05:35 +0100: > 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? Bigsister reports "failed to add table host", before I deleted the .frm files. After deleting and restarting MySQL I got "table host doesn't exist, can't create table host". So, a different message, same meaning. However, the four *.frm files got created again, nothing else, though. Then bigsister stopped trying and I restarted it, am waiting now for the next write. BTW: do you know one cannot stop the three bigsister processes on Windows from the management console? The stop just times out after a long while. The only thing that works for me is to kill the process in the task manager. Hm, I'm still waiting that bigsis makes another attempt to write to the mysql db. It should be the server process doing that, shouldn't it? I restarted it, then restarted bsmon after some minutes, no change yet. But I saw that the RRDTool perl module is missing when starting bsmon. Which might explain some of the anomalies with viewing stats. What's the name of that module? For now it seems that bigsister doesn't even try to use the MySQL db, although it got restarted and MySQL is running just fine. No errors anywhere. > > 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? I did now, see above. I deleted twice. They came back the first time, but not the second time. I think I restarted MySQL after the second time and maybe the missing link prompted bigssis to stop any further attempts. Don't know. I then dropped the database twice, restarted just everything and the *.frm files were created again. But no error anywhere and no logging. The dates of the *.frm files stay with the creation date as it already happened with the first ones (I only noticed that today, that should have made plain clear that no logging occurred ;-) > > Is the error message you get exactly the one that is cited? Yes. I think I got it with each reattempt of bigsis to create the "missing" table. At the moment there are no errors and no logging. > RRD graphs are not touched by the DB data logger - data can be logged to > both RRD and database (and this is the default). I think I confused something. I thought RRDTool would then use the data from the MySQL database. I now figure that db is actually for my own purpose, in case *I* want to grab performance data with my own application from a SQL db? Ok, last attempt. I wanted to kill all bigsister tasks now and when doing so I found that I had six perl process running. Which means that the earlier kills or restarts didn't really succeed although it seemed to be working ok. I killed all now and restarted bigsister and now it has started to add data to the db files. Finally :-) This time I created the database from PHPMyAdmin with a collation of ascii_bin. I had created it earlier at the MySQL prompt with the default collation. Maybe that made the difference. I also noticed now that InnoDB databases only have those *.frm files, so that was okay. All the database tables I looked at for comparison turned out to be MyISAM. Now, how do I make use of the stats in the MySQL db? Do I have to write my own program or is there something out that fits without much configuration? Or is it this data that gets ed by bshistgraph? (can't use it yet, no R installed). Kai -- Kai Schätzl, Berlin, Germany Get your web at Conactive Internet Services: http://www.conactive.com ------------------------------------------------------------------------- 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.