View Issue Details [ Jump to Notes ] [ Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0013428CDash(No Category)public2012-07-20 04:262013-10-30 04:26
ReporterNils Gladitz 
Assigned ToJulien Jomier 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOSOS Version
Product Version2.0 
Target VersionFixed in Version2.2 
Summary0013428: Unknown column 'buildid' when running "Cleanup database"
DescriptionI run HEAD SVN (r3273).
When running "Cleanup CDash (can take a long time): [Cleanup database]" from "CDash maintenance" I get:

Unknown column 'buildid' in 'IN/ALL/ANY subquery'Unknown column 'buildid' in 'IN/ALL/ANY subquery'

It still says "Database cleanup complete." though.

I'm not even sure what the option does exactly but my CDash DB has grown beyond 50G and I thought it may be worth a shot.
TagsNo tags attached.
Attached Files

 Relationships

  Notes
(0030092)
Julien Jomier (manager)
2012-07-20 04:30

 Thanks for the report. Are you running MySQL with MyISAM tables? If that's the case you should run a MySQL optimization on your CDash database. Hope that helps.
(0030093)
Nils Gladitz (reporter)
2012-07-20 05:44

 Thank you for the quick reply!

Yes I run MySQL with MyISAM.
I ran "mysqlcheck -o" on the cdash database which did seem to be doing
something (took quite some time) but the database size as displayed by
CDash and in the filesystem itself did not change significantly.

The size isn't yet an issue here and I probably provoked it by having
Coverage, Dynamic Analysis and attaching installers to the test results.

I tried to configure AutoRemove (100 days, 100 builds) but I'm not sure
if any removal is actually happening or if
the parameters as I chose them make sense.

My oldest builds seem to be from December 13 2011 (I think that may actually be the time I set up CDash on that specific server).
(0030094)
Julien Jomier (manager)
2012-07-20 05:49

 If you have phpMyAdmin, I would recommend to check the size of the overhead tables. This size increases if you delete builds only.

You should look at this page for the autoremove:

http://public.kitware.com/Wiki/CDash:Administration#Automatic_removal_of_builds [^]
(0030095)
Nils Gladitz (reporter)
2012-07-20 08:31

 I now enabled automatic removal in my configuration,
ran the autoRemoveBuilds.php script manually a couple of times and
reran table optimization.

I didn't have phpMyAdmin but I used "mysqlshow --status cdash"; the Data_free column apparently correlates to the "overhead" value.
Got all zeros for cdash now.

The 2011 builds are gone as expected as well.

I am now at about 49G (about 4.3G freed up) ... I was hoping for more but if it stays around that (and as I understand it it should as long as new builds use as much table space as the old deleted builds did) I'm happy.

Thanks again!

 Issue History
Date Modified Username Field Change
2012-07-20 04:26 Nils Gladitz New Issue
2012-07-20 04:30 Julien Jomier Note Added: 0030092
2012-07-20 05:44 Nils Gladitz Note Added: 0030093
2012-07-20 05:49 Julien Jomier Note Added: 0030094
2012-07-20 08:31 Nils Gladitz Note Added: 0030095
2012-12-18 07:52 Julien Jomier Assigned To => Julien Jomier
2012-12-18 07:52 Julien Jomier Status new => assigned
2012-12-18 07:56 Julien Jomier Status assigned => resolved
2012-12-18 07:56 Julien Jomier Fixed in Version => 2.2
2012-12-18 07:56 Julien Jomier Resolution open => fixed
2013-10-30 04:26 Nils Gladitz Status resolved => closed

Copyright © 2000 - 2018 MantisBT Team