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
