Andy Kurth created VCL-679:
------------------------------

             Summary: utils.pm:get_computer_info using image.name to retrieve 
imagerevision info
                 Key: VCL-679
                 URL: https://issues.apache.org/jira/browse/VCL-679
             Project: VCL
          Issue Type: Bug
          Components: vcld (backend)
    Affects Versions: 2.3
            Reporter: Andy Kurth
            Priority: Minor
             Fix For: 2.3.3


get_computer_info is retrieving computer.nextimageid, using this to retrieve 
the image info, and then using the image.name value to retrieve the 
imagerevision info.  It's possible that an image.name value does not have a 
corresponding entry in imagerevision.imagename.  The following will appear in 
vcld.log if this is the case:

|31709|2104580:2193018|inuse| ---- WARNING ----
|31709|2104580:2193018|inuse| 2013-02-27 
04:13:19|31709|2104580:2193018|inuse|utils.pm:get_imagerevision_info(4253)|imagerevision
 'vmwarewinxp-SAS93EGEMinerTextMiner3198-v3' was not found in the database, 0 
rows were returned from database select statement:
|31709|2104580:2193018|inuse| SELECT
|31709|2104580:2193018|inuse| imagerevision.*
|31709|2104580:2193018|inuse| FROM
|31709|2104580:2193018|inuse| imagerevision
|31709|2104580:2193018|inuse| WHERE
|31709|2104580:2193018|inuse| imagerevision.imagename = 
'vmwarewinxp-SAS93EGEMinerTextMiner3198-v3'
|31709|2104580:2193018|inuse| ( 0) utils.pm, get_imagerevision_info (line: 4253)
|31709|2104580:2193018|inuse| (-1) utils.pm, get_computer_info (line: 7740)
|31709|2104580:2193018|inuse| (-2) utils.pm, get_request_info (line: 3829)
|31709|2104580:2193018|inuse| (-3) vcld, main (line: 286)


image.name should not be used anywhere and the column should probably be 
removed from the database altogether.  imagerevision.imagename is 
authoritative.  


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Reply via email to