I upgraded to 8.0.4 from 8.0.3. We had two sub projects under root, each of which had additional subprojects under that. One of those subprojects is completely gone after the upgrade.
There were no errors or messages in the logs during the upgrade that indicated a problem, or that these projects would be deleted.
The UI has virtually no indication that the projects ever existed. No audit of them being removed. They aren't in the 'archived' project list. VCS roots that were associated with those projects are now associated with the root project. audit logs of past builds in those projects just list the internal ID of the old build configurations, and clicking on those IDs indicates those build configurations no longer exist.
I looked in the database, in the project table. The top-level subproject *is* listed there, but not the subprojects under that. Not sure where else to look.
I tried downgrading back to 8.0.3, but that didn't bring back the missing projects.
I unfortunately don't have a recent backup to restore from (I know...). I was hoping you could point me at database tables or conf files where some of this configuration might still be so I could perhaps manually try and undo this.
I'm running the war distribution in tomcat7 on ubuntu 12.