Marcus Sorensen created CLOUDSTACK-1505:
-------------------------------------------
Summary: Unknown column 'domain.region_id' in 'field list'
Key: CLOUDSTACK-1505
URL: https://issues.apache.org/jira/browse/CLOUDSTACK-1505
Project: CloudStack
Issue Type: Bug
Security Level: Public (Anyone can view this level - this is the default.)
Components: Management Server
Affects Versions: 4.1.0
Environment: Management server running on CentOS 6.3
Reporter: Marcus Sorensen
Priority: Critical
Fix For: 4.1.0
I deploy a management server and database. Then I stop management server, drop
database, and then attempt to reinstall. I run:
cloudstack-setup-databases cloud:password@localhost --deploy-as root
cloudstack-setup-management
as I also did during initial successful install. Only this time, I cannot log
in as Admin user. The UI does nothing when I attempt to login, and management
server says:
2013-03-04 16:30:18,950 ERROR [cloud.api.ApiServlet] (catalina-exec-14:null)
unknown exception writing api response
com.cloud.utils.exception.CloudRuntimeException: DB Exception on:
com.mysql.jdbc.JDBC4PreparedStatement@18f7d92f: SELECT domain.id,
domain.parent, domain.name, domain.owner, domain.path, domain.level,
domain.removed, domain.child_count, domain.next_child_seq, domain.state,
domain.network_domain, domain.uuid, domain.region_id FROM domain WHERE
domain.path = _binary'/' AND domain.removed IS NULL ORDER BY RAND() LIMIT 1
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown
column 'domain.region_id' in 'field list'
Indeed, there is no mention of region_id in the sql deployment, and perhaps
whatever injects this into the schema doesn't like a reinstall. This could be
hard on devs and people testing out cloudstack.
--
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
