[
https://issues.apache.org/jira/browse/CLOUDSTACK-1505?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13593218#comment-13593218
]
Kishan Kavala commented on CLOUDSTACK-1505:
-------------------------------------------
schema-40to410.sql should run as part of 40 to 41 upgrade. This file contains
sql to add region_id column.
ALTER TABLE `cloud`.`domain` ADD COLUMN `region_id` int unsigned NOT NULL
DEFAULT '1';
can you verify that schema-40to410.sql was executed?
> 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
> Assignee: Kishan Kavala
> 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
