[jira] [Created] (CLOUDSTACK-560) Usage server doesn't work in 4.0.0 due to missing db changes

["David Nalley (JIRA)" <ji...@apache.org>]

David Nalley created CLOUDSTACK-560:
---------------------------------------

             Summary: Usage server doesn't work in 4.0.0 due to missing db changes
                 Key: CLOUDSTACK-560
                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-560
             Project: CloudStack
          Issue Type: Bug
      Security Level: Public (Anyone can view this level - this is the default.)
          Components: Usage
    Affects Versions: 4.0.0
            Reporter: David Nalley
            Assignee: Kishan Kavala
            Priority: Blocker
             Fix For: 4.0.1, 4.1.0


[Alerts]
Usage job failed. Job id: 1 25 Nov 2012 03:13:00

[usage.log]
2012-11-25 03:13:00,154 ERROR [cloud.usage.UsageManagerImpl]
(Usage-Job-1:null) Exception in usage manager
com.cloud.utils.exception.CloudRuntimeException: DB Exception on:
org.apache.commons.dbcp.DelegatingPreparedStatement@5b5a5cf
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
Unknown column 'account.default_zone_id' in 'field list'

The usage server tried to get "account.default_zone_id" from "cloud_usage"
database, but the "account" table doesn't have "default_zone_id" column.


Kishan: This is the same bug as http://bugs.cloudstack.org/browse/CS-15170 - which apparently didn't make it into master or 4.0 branch. 

--
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