cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daan Hoogland <daan.hoogl...@gmail.com>
Subject Re: upgrade question
Date Mon, 11 Nov 2013 20:09:53 GMT
Alena,

Sorry for not reporting earlier. The error was due to an incomplete import
by a mysql version different from the one doing the export. No cloudstack
issue there

Thanks,

mobile biligual spell checker used
Op 11 nov. 2013 18:24 schreef "Alena Prokharchyk" <
Alena.Prokharchyk@citrix.com>:

>  Daan,
>
>  If you execute the line "DROP VIEW IF EXISTS `cloud`.`event_view`;"
> manually, does it drop the view? Also can you check if your management
> server was started twice (unlikely)? I can't think of anything else.
>
>  In the future we should use "CREATE OR REPLACE VIEW" syntax instead of
> dropping/recreating the view
>
>  -Alena.
>
>   From: Daan Hoogland <daan.hoogland@gmail.com>
> Reply-To: "dev@cloudstack.apache.org" <dev@cloudstack.apache.org>
> Date: Monday, November 11, 2013 5:09 AM
> To: dev <dev@cloudstack.apache.org>
> Subject: upgrade question
>
>   H,
>
>  I started doing some upgrade testing and got an exception during startup:
>
>  INFO  [cloud.upgrade.DatabaseUpgradeChecker] (Timer-2:) Database
> upgrade must be performed from 4.1.1 to 4.2.1-SNAPSHOT
> ERROR [utils.db.ScriptRunner] (Timer-2:) Error executing: CREATE VIEW
> `cloud`.`event_view` AS     select         event.id,
> event.uuid,         event.type,         event.state,
> event.description,         event.created,         event.level,
> event.parameters,         event.start_id,         eve.uuid start_uuid,
>         event.user_id,         event.archived,         user.username
> user_name,         account.id account_id,         account.uuid
> account_uuid,         account.account_name account_name,
> account.type account_type,         domain.id domain_id,
> domain.uuid domain_uuid,         domain.name domain_name,
> domain.path domain_path,         projects.id project_id,
> projects.uuid project_uuid,         projects.name project_name
> from         `cloud`.`event`             inner join
> `cloud`.`account` ON event.account_id = account.id             inner
> join         `cloud`.`domain` ON event.domain_id = domain.id
>   inner join         `cloud`.`user` ON event.user_id = user.id
>     left join         `cloud`.`projects` ON
> projects.project_account_id = event.account_id             left join
>       `cloud`.`event` eve ON event.start_id = eve.id
> ERROR [utils.db.ScriptRunner] (Timer-2:)
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
> 'event_view' already exists
> ERROR [cloud.upgrade.DatabaseUpgradeChecker] (Timer-2:) Unable to
> execute upgrade script:
>
> C:\Users\dhoogland\cloudstack\cloudstack\client\target\utilities\scripts\db\db\schema-410to420.sql
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
> 'event_view' already exists
>     at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:193)
>     at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:87)
>
>  etcetera.
>
>  I checked the upgrade script which says,
>
>
>  DROP VIEW IF EXISTS `cloud`.`event_view`;
> CREATE VIEW `cloud`.`event_view` AS
>     select
>         event.id,
> ...
>
>  So in theory it should delete the table and not complain about it
> already existing. Am I missing something or did I hit a bug? (auto
> commit issue maybe?)
>
>  regards,
> Daan
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message