[
https://issues.apache.org/jira/browse/CLOUDSTACK-1505?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13592806#comment-13592806
]
Marcus Sorensen commented on CLOUDSTACK-1505:
---------------------------------------------
So, it looks like cloudstack-setup-databases is deploying version 4.0.0
database?
013-03-04 16:38:55,386 INFO [cloud.upgrade.DatabaseUpgradeChecker]
(Timer-1:null) DB version = 4.0.0 Code Version = 4.1.0-SNAPSHOT
2013-03-04 16:38:55,386 INFO [cloud.upgrade.DatabaseUpgradeChecker]
(Timer-1:null) Database upgrade must be performed from 4.0.0 to 4.1.0-SNAPSHOT
2013-03-04 16:38:55,387 DEBUG [cloud.upgrade.DatabaseUpgradeChecker]
(Timer-1:null) Running upgrade Upgrade40to41 to upgrade from 4.0.0-4.1.0 to
4.1.0
Note this is with a fresh install from 4.1 branch. If I drop database cloud,
run cloudstack-setup-databases, and then start the management server, it runs
the upgrade. Here are the sql files it's deploying:
Applying /usr/share/cloudstack-management/setup/create-database.sql
[ OK ]
Applying /usr/share/cloudstack-management/setup/create-schema.sql
[ OK ]
Applying /usr/share/cloudstack-management/setup/create-database-premium.sql
[ OK ]
Applying /usr/share/cloudstack-management/setup/create-schema-premium.sql
[ OK ]
Applying /usr/share/cloudstack-management/setup/server-setup.sql
[ OK ]
Applying /usr/share/cloudstack-management/setup/templates.sql
[ OK ]
> 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
