Description of problem:
Adter deploying a .war file, the installation date seems way off
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1. Inventory an EWS server and assure is has gone green.
2. Navigate to your virtual host within the tree, and deploy something, i.e., counter.war
3. Navigate to your war resource in the tree (i.e., counter/) and click the Content tab
4. View resulting table
I have an installation date of "14732 days, 20 hours ago"
* It probably shouldn't read "Installation Date" if it is a "how long ago" sort of measurement
* The installation time measure is way, way off. Maybe this is package create date?
I've run into this problem and looked into it as well and it turns out that the Content -> Deployed Content list uses InstallledPackage.installationDate, while the actual Package Version(fixed in 589173) uses the PackageVersion.fileCreationTime.
These appear to serve the same purpose but exist on two different objects and tables. Not completely sure why.
Proposed fix, change named query InstalledPackage.QUERY_FIND_PACKAGE_LIST_ITEM_COMPOSITE to use the PackageVersion details.
As a result of BZ 589173, almost all packages(excluding webapps deployed exploded before rhq) now have the fileCreated date set if it's obtainable.
Queries of rhq_package_version show almost full population of timestamp, excluding case above, while queries of rhq_installed_package are almost devoid of timestamp information.
This should fix many places in the code where timestamp simply displays epoch/computer zero time.
This bug also manifests itself when EDS VDBs are deployed to a server. We're seeing 14987 days 22 hours, and the like.
Speaking to Stefan, this is no related to his content fixes, so unassigning from that tracker BZ
Reassigning to jon3.1.0. It would be good to fix, as per its priority
git log master
time: Tue Jun 19 10:50:45 2012 +0200
author: Jirka Kremser - firstname.lastname@example.org
message: [BZ 588507 - WAR file deployed against Tomcat shows an incorrect installation date] Instalation date is now taken from InstalledPackage instance instead of PackageVersion instance
Created attachment 601691 [details]
installation date under TomcatVirtualHost->localhost->deployedWar->Content is set correct.
Bulk close of old bugs in VERIFIED state.