Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#1835 Small Device C Compiler suite database s599_regtests removed

fixed
Chris Tsai
sdcc
2012-12-05
2012-12-03
Borut Ražem
No

We, sdcc developers, received a mail with the following content:

"Your project, Small Device C Compiler suite, was found to have one or more databases taking up an inordinate amount of disk space. We've checked the contents of a number of such databases, and we found them to filled with spam comments. As such, we've taken a backup of this data, and then took the database offline."

We realized that the problematic database is s599_regtests, which is (was, since now is removed) used to store the regression test results. The sdcc regression tests are executed every day, and since they run on 13 architectures, 12 targets on each architecture, 968 regression tests on each target, 5 results (integers) for each regression test, the daily size increase is quite big: 769080 integers per day.

I don't know how you came to conclusion that the db is filled with spam, but I assume that such a big increase gives that impression.

I'm not aware of any database policy document about how the sf database can be used, what is the maximal allowed size, ... Does such document exist?

Now, how to proceed?
Can we get the backup of the removed database? Can you put it to the project home directory?

Probably we have to redesign the regression test results storage by somehow storing only the results when they change. The regression test database will be disabled until we found a reasonable decision.

Borut

Discussion

  • Chris Tsai
    Chris Tsai
    2012-12-03

    • labels: --> siteops, p2
    • status: unread --> assigned
    • assigned_to: Chris Tsai
     
  • Chris Tsai
    Chris Tsai
    2012-12-03

    Greetings,

    I've put in a request to have this database restored.

    We do not have any set limits, and if it's legitimate use, that's fine. We've observed a number of projects that were using proportionally considerably higher amount of diskspace for their databases than the majority (ie., < 1% of dbs using 75% of the space). And from the feedback thus far, it appears that yours was one of the very few whose large db size wasn't due to spam.

    Anyway, I'll keep you posted on the database restoration.

    Regards,
    Chris Tsai, SourceForge.net Support

     
  • Chris Tsai
    Chris Tsai
    2012-12-05

    • status: assigned --> fixed
     
  • Chris Tsai
    Chris Tsai
    2012-12-05

    This database has been restored.

    We would appreciate whatever efforts you can make to reduce the size of the db, but since it sounds like it's completely legitimate use, if you can't, that should be fine.

    Regards,
    Chris Tsai, SourceForge.net Support