Re: SQL error and "can't upgrade database" when I try to upgrade CS 4.17.1.0 to 4.18.0.0

[Wei ZHOU]

Hi,
Please keep an eye on
https://github.com/apache/cloudstack/issues/7358

-Wei


On Friday, 24 March 2023, David Larsen  wrote:

> Hi
>
> I’m running CS 4.17.1.0 on ubuntu 18.04 and MySQL 5.7.41, and tried to
> upgrade to 4.18.0.0
>
> Please see log bellow for details regarding sql error.
>
>
> 2023-03-24 15:07:42,669 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
> CALL `cloud`.`IDEMPOTENT_ADD_COLUMN`('cloud.vm_template', 'user_data_id',
> 'bigint unsigned DEFAULT NULL COMMENT "id of the us
>er data"')
> 2023-03-24 15:07:43,075 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
> CALL `cloud`.`IDEMPOTENT_ADD_FOREIGN_KEY`('cloud.vm_template',
> 'user_data', 'id')
> 2023-03-24 15:07:43,213 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:)
> Error executing: CALL 
> `cloud`.`IDEMPOTENT_ADD_FOREIGN_KEY`('cloud.vm_template',
> 'user_data', 'id')
> 2023-03-24 15:07:43,214 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:)
> java.sql.SQLIntegrityConstraintViolationException: Can't write; duplicate
> key in table '#sql-500_158'
> 2023-03-24 15:07:43,216 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null)
> (logid:) Unable to execute upgrade script
> java.sql.SQLIntegrityConstraintViolationException: Can't write; duplicate
> key in table '#sql-500_158'
> at com.cloud.utils.db.ScriptRunner.runScript(
> ScriptRunner.java:185)
> at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:87)
> at com.cloud.upgrade.DatabaseUpgradeChecker.runScript(
> DatabaseUpgradeChecker.java:226)
> at com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(
> DatabaseUpgradeChecker.java:310)
> at com.cloud.upgrade.DatabaseUpgradeChecker.check(
> DatabaseUpgradeChecker.java:401)
> at org.apache.cloudstack.spring.lifecycle.
> CloudStackExtendedLifeCycle.checkIntegrity(CloudStackExtendedLifeCycle.
> java:64)
> at org.apache.cloudstack.spring.lifecycle.
> CloudStackExtendedLifeCycle.start(CloudStackExtendedLifeCycle.java:54)
> at org.springframework.context.support.DefaultLifecycleProcessor.
> doStart(DefaultLifecycleProcessor.java:178)
> at org.springframework.context.support.DefaultLifecycleProcessor.
> access$200(DefaultLifecycleProcessor.java:54)
> at org.springframework.context.support.DefaultLifecycleProcessor$
> LifecycleGroup.start(DefaultLifecycleProcessor.java:356)
> at java.base/java.lang.Iterable.forEach(Iterable.java:75)
> at org.springframework.context.support.DefaultLifecycleProcessor.
> startBeans(DefaultLifecycleProcessor.java:155)
> at org.springframework.context.support.DefaultLifecycleProcessor.
> onRefresh(DefaultLifecycleProcessor.java:123)
> at org.springframework.context.support.AbstractApplicationContext.
> finishRefresh(AbstractApplicationContext.java:935)
> at org.springframework.context.support.AbstractApplicationContext.
> refresh(AbstractApplicationContext.java:586)
> at org.apache.cloudstack.spring.module.model.impl.
> DefaultModuleDefinitionSet.loadContext(DefaultModuleDefinitionSet.
> java:144)
> at org.apache.cloudstack.spring.module.model.impl.
> DefaultModuleDefinitionSet$2.with(DefaultModuleDefinitionSet.java:121)
> at org.apache.cloudstack.spring.module.model.impl.
> DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:244)
> at org.apache.cloudstack.spring.module.model.impl.
> DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:249)
> at org.apache.cloudstack.spring.module.model.impl.
> DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:232)
> at org.apache.cloudstack.spring.module.model.impl.
> DefaultModuleDefinitionSet.loadContexts(DefaultModuleDefinitionSet.
> java:116)
> at org.apache.cloudstack.spring.module.model.impl.
> DefaultModuleDefinitionSet.load(DefaultModuleDefinitionSet.java:78)
> at org.apache.cloudstack.spring.module.factory.
> ModuleBasedContextFactory.loadModules(ModuleBasedContextFactory.java:37)
> at org.apache.cloudstack.spring.module.factory.
> CloudStackSpringContext.init(CloudStackSpringContext.java:70)
> at org.apache.cloudstack.spring.module.factory.
> CloudStackSpringContext.(CloudStackSpringContext.java:57)
> at org.apache.cloudstack.spring.module.factory.
> CloudStackSpringContext.(CloudStackSpringContext.java:61)
> at org.apache.cloudstack.spring.module.web.
> CloudStackContextLoaderListener.contextInitialized(
> CloudStackContextLoaderListener.java:52)
> at org.eclipse.jetty.server.handler.ContextHandler.
> callContextInitialized(ContextHandler.java:1073)
> at org.eclipse.jetty.servlet.ServletContextHandler.
> callContextInitialized(ServletContextHandler.java:572)
> at org.eclipse.jetty.server.handler.ContextHandler.
> contextInitialized(ContextHandler.java:1002)
> at org.eclipse.jetty.servlet.ServletHandler.initialize(
> ServletHandler.java:765)
> at 

Re: Daan Hoogland - New ASF Member

[Ivet Petrova]

Congrats, Daan! This is well deserved! I am very happy for you!

Sent from my iPhone


 

> On 24 Mar 2023, at 11:19, Slavka Peleva  wrote:
> 
> Congratulations Daan!
> 
> Best regards,
> Slavka
> 
>> On Fri, Mar 24, 2023 at 12:01 PM Nicolas Vazquez <
>> nicolas.vazq...@shapeblue.com> wrote:
>> 
>> Congratulations Daan!
>> 
>> Regards,
>> Nicolas Vaquez
>> 
>> From: Paul Angus 
>> Sent: Friday, March 24, 2023 6:28:54 AM
>> To: users@cloudstack.apache.org ;
>> d...@cloudstack.apache.org 
>> Subject: Daan Hoogland - New ASF Member
>> 
>> 
>> 
>> It is my pleasure to announce that Daan Hoogland as been elected to become
>> a
>> member of the ASF.
>> 
>> The ASF would like to recognize both his practical involvement and the way
>> in which he has interacted with others in and around the ASF.
>> 
>> 
>> 
>> Congratulations  Daan.
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> Kind regards
>> 
>> 
>> 
>> Paul Angus
>> 
>> 
>> 
>> 
>> 
>> 
>> 

Re: Daan Hoogland - New ASF Member

[pavan aravapalli]

Congratulations Dan!.

Thanks & Regards,
Pavan.

On Fri, 24 Mar 2023 at 19:33, Daan Hoogland  wrote:

> thanks all,
> will try to be worthy ;)
>
> On Fri, Mar 24, 2023 at 2:17 PM Simon Weller  wrote:
>
> > Wow, that's fantastic. Congratulations Daan!
> >
> > -Si
> >
> > On Fri, Mar 24, 2023 at 4:29 AM Paul Angus  wrote:
> >
> > >
> > >
> > > It is my pleasure to announce that Daan Hoogland as been elected to
> > become
> > > a
> > > member of the ASF.
> > >
> > > The ASF would like to recognize both his practical involvement and the
> > way
> > > in which he has interacted with others in and around the ASF.
> > >
> > >
> > >
> > > Congratulations  Daan.
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > Kind regards
> > >
> > >
> > >
> > > Paul Angus
> > >
> > >
> > >
> > >
> >
>
>
> --
> Daan
>

SV: SQL error and "can't upgrade database" when I try to upgrade CS 4.17.1.0 to 4.18.0.0

[David Larsen]

Hi Gary

Thanks for update. I will try to upgrade mysql to 8.0 then.



-David



Fra: Gary Dixon 
Sendt: fredag 24. mars 2023 17:37
Til: users@cloudstack.apache.org
Emne: RE: SQL error and "can't upgrade database" when I try to upgrade CS 
4.17.1.0 to 4.18.0.0


Somebody else recently posted about this issue and resolved it by updating 
their MySql that was also on v5.7.41 - they didn't specify what version they 
updated MySql to however
Gary Dixon​
Senior Technical Consultant
T:  +44 161 537 4990
E:  vms@quadris‑support.com
W: www.quadris.co.uk
[cid:image552174.png@F2EB7DBA.3861FD3F]
The information contained in this e-mail from Quadris may be confidential and 
privileged for the private use of the named recipient.  The contents of this 
e-mail may not necessarily represent the official views of Quadris.  If you 
have received this information in error you must not copy, distribute or take 
any action or reliance on its contents.  Please destroy any hard copies and 
delete this message.
-Original Message-
From: David Larsen mailto:david.lar...@adcom.no>>
Sent: Friday, March 24, 2023 4:27 PM
To: users@cloudstack.apache.org
Subject: SV: SQL error and "can't upgrade database" when I try to upgrade CS 
4.17.1.0 to 4.18.0.0

Update:
I reverted to 4.17.1.0 snapshot and successfully upgraded to 4.17.2.0 without 
any issues.
I will try upgrade to 4.18.0 from 4.17.2.0 later.

Med vennlig hilsen

David Larsen
Senior systemkonsulent


ADCOM MOLDE, IT Data AS
Fabrikkvegen 13  | 6415 Molde
Mobil: 959 48 308 | Sentralbord: 71 25 06 40
david.lar...@adcom.no | 
https://eur01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.adcom.no%2F=05%7C01%7CGary.Dixon%40quadris.co.uk%7C68fd5fbd03f147134c6008db2c84b008%7Cf1d6abf3d3b44894ae16db0fb93a96a2%7C0%7C0%7C638152720630391311%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C=2srpXA2d5XwQHLEW9bT%2BPwgtz5RCzAqI5et%2BYVX7qKE%3D=0



Følg oss på sosiale medier:
• Tenk på miljøet før du skriver ut denne eposten


-Opprinnelig melding-
Fra: David Larsen mailto:david.lar...@adcom.no>>
Sendt: fredag 24. mars 2023 15:33
Til: users@cloudstack.apache.org
Emne: SQL error and "can't upgrade database" when I try to upgrade CS 4.17.1.0 
to 4.18.0.0

Hi

I’m running CS 4.17.1.0 on ubuntu 18.04 and MySQL 5.7.41, and tried to upgrade 
to 4.18.0.0

Please see log bellow for details regarding sql error.


2023-03-24 15:07:42,669 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CALL 
`cloud`.`IDEMPOTENT_ADD_COLUMN`('cloud.vm_template', 'user_data_id', 'bigint 
unsigned DEFAULT NULL COMMENT "id of the us er data"')
2023-03-24 15:07:43,075 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CALL 
`cloud`.`IDEMPOTENT_ADD_FOREIGN_KEY`('cloud.vm_template', 'user_data', 'id')
2023-03-24 15:07:43,213 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:) Error 
executing: CALL `cloud`.`IDEMPOTENT_ADD_FOREIGN_KEY`('cloud.vm_template', 
'user_data', 'id')
2023-03-24 15:07:43,214 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:) 
java.sql.SQLIntegrityConstraintViolationException: Can't write; duplicate key 
in table '#sql-500_158'
2023-03-24 15:07:43,216 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null) 
(logid:) Unable to execute upgrade script
java.sql.SQLIntegrityConstraintViolationException: Can't write; duplicate key 
in table '#sql-500_158'
at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:185)
at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:87)
at 
com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:226)
at 
com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:310)
at 
com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:401)
at 
org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.checkIntegrity(CloudStackExtendedLifeCycle.java:64)
at 
org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.start(CloudStackExtendedLifeCycle.java:54)
at 
org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:178)
at 
org.springframework.context.support.DefaultLifecycleProcessor.access$200(DefaultLifecycleProcessor.java:54)
at 
org.springframework.context.support.DefaultLifecycleProcessor$LifecycleGroup.start(DefaultLifecycleProcessor.java:356)
at java.base/java.lang.Iterable.forEach(Iterable.java:75)
at 
org.springframework.context.support.DefaultLifecycleProcessor.startBeans(DefaultLifecycleProcessor.java:155)
at 
org.springframework.context.support.DefaultLifecycleProcessor.onRefresh(DefaultLifecycleProcessor.java:123)
at 
org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:935)
at 
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:586)
at 

RE: SQL error and "can't upgrade database" when I try to upgrade CS 4.17.1.0 to 4.18.0.0

[Gary Dixon]

Somebody else recently posted about this issue and resolved it by updating 
their MySql that was also on v5.7.41 - they didn't specify what version they 
updated MySql to however


Gary Dixon
Senior Technical Consultant
T:  +44 161 537 4990
E:  v...@quadris-support.com
W: www.quadris.co.uk
The information contained in this e-mail from Quadris may be confidential and 
privileged for the private use of the named recipient.  The contents of this 
e-mail may not necessarily represent the official views of Quadris.  If you 
have received this information in error you must not copy, distribute or take 
any action or reliance on its contents.  Please destroy any hard copies and 
delete this message.
-Original Message-
From: David Larsen 
Sent: Friday, March 24, 2023 4:27 PM
To: users@cloudstack.apache.org
Subject: SV: SQL error and "can't upgrade database" when I try to upgrade CS 
4.17.1.0 to 4.18.0.0

Update:
I reverted to 4.17.1.0 snapshot and successfully upgraded to 4.17.2.0 without 
any issues.
I will try upgrade to 4.18.0 from 4.17.2.0 later.

Med vennlig hilsen

David Larsen
Senior systemkonsulent


ADCOM MOLDE, IT Data AS
Fabrikkvegen 13  | 6415 Molde
Mobil: 959 48 308 | Sentralbord: 71 25 06 40
david.lar...@adcom.no | 
https://eur01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.adcom.no%2F=05%7C01%7CGary.Dixon%40quadris.co.uk%7C68fd5fbd03f147134c6008db2c84b008%7Cf1d6abf3d3b44894ae16db0fb93a96a2%7C0%7C0%7C638152720630391311%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C=2srpXA2d5XwQHLEW9bT%2BPwgtz5RCzAqI5et%2BYVX7qKE%3D=0

   

Følg oss på sosiale medier:
 Tenk på miljøet før du skriver ut denne eposten


-Opprinnelig melding-
Fra: David Larsen 
Sendt: fredag 24. mars 2023 15:33
Til: users@cloudstack.apache.org
Emne: SQL error and "can't upgrade database" when I try to upgrade CS 4.17.1.0 
to 4.18.0.0

Hi

I’m running CS 4.17.1.0 on ubuntu 18.04 and MySQL 5.7.41, and tried to upgrade 
to 4.18.0.0

Please see log bellow for details regarding sql error.


2023-03-24 15:07:42,669 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CALL 
`cloud`.`IDEMPOTENT_ADD_COLUMN`('cloud.vm_template', 'user_data_id', 'bigint 
unsigned DEFAULT NULL COMMENT "id of the us   er 
data"')
2023-03-24 15:07:43,075 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CALL 
`cloud`.`IDEMPOTENT_ADD_FOREIGN_KEY`('cloud.vm_template', 'user_data', 'id')
2023-03-24 15:07:43,213 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:) Error 
executing: CALL `cloud`.`IDEMPOTENT_ADD_FOREIGN_KEY`('cloud.vm_template', 
'user_data', 'id')
2023-03-24 15:07:43,214 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:) 
java.sql.SQLIntegrityConstraintViolationException: Can't write; duplicate key 
in table '#sql-500_158'
2023-03-24 15:07:43,216 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null) 
(logid:) Unable to execute upgrade script
java.sql.SQLIntegrityConstraintViolationException: Can't write; duplicate key 
in table '#sql-500_158'
at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:185)
at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:87)
at 
com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:226)
at 
com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:310)
at 
com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:401)
at 
org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.checkIntegrity(CloudStackExtendedLifeCycle.java:64)
at 
org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.start(CloudStackExtendedLifeCycle.java:54)
at 
org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:178)
at 
org.springframework.context.support.DefaultLifecycleProcessor.access$200(DefaultLifecycleProcessor.java:54)
at 
org.springframework.context.support.DefaultLifecycleProcessor$LifecycleGroup.start(DefaultLifecycleProcessor.java:356)
at java.base/java.lang.Iterable.forEach(Iterable.java:75)
at 
org.springframework.context.support.DefaultLifecycleProcessor.startBeans(DefaultLifecycleProcessor.java:155)
at 
org.springframework.context.support.DefaultLifecycleProcessor.onRefresh(DefaultLifecycleProcessor.java:123)
at 
org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:935)
at 
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:586)
at 
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContext(DefaultModuleDefinitionSet.java:144)
at 
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet$2.with(DefaultModuleDefinitionSet.java:121)
at 

SV: SQL error and "can't upgrade database" when I try to upgrade CS 4.17.1.0 to 4.18.0.0

[David Larsen]

Update: 
I reverted to 4.17.1.0 snapshot and successfully upgraded to 4.17.2.0 without 
any issues.
I will try upgrade to 4.18.0 from 4.17.2.0 later.

Med vennlig hilsen

David Larsen 
Senior systemkonsulent


ADCOM MOLDE, IT Data AS
Fabrikkvegen 13  | 6415 Molde 
Mobil: 959 48 308 | Sentralbord: 71 25 06 40
david.lar...@adcom.no | www.adcom.no 

    

Følg oss på sosiale medier: 
 Tenk på miljøet før du skriver ut denne eposten


-Opprinnelig melding-
Fra: David Larsen  
Sendt: fredag 24. mars 2023 15:33
Til: users@cloudstack.apache.org
Emne: SQL error and "can't upgrade database" when I try to upgrade CS 4.17.1.0 
to 4.18.0.0

Hi

I’m running CS 4.17.1.0 on ubuntu 18.04 and MySQL 5.7.41, and tried to upgrade 
to 4.18.0.0

Please see log bellow for details regarding sql error.


2023-03-24 15:07:42,669 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CALL 
`cloud`.`IDEMPOTENT_ADD_COLUMN`('cloud.vm_template', 'user_data_id', 'bigint 
unsigned DEFAULT NULL COMMENT "id of the us   er 
data"')
2023-03-24 15:07:43,075 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CALL 
`cloud`.`IDEMPOTENT_ADD_FOREIGN_KEY`('cloud.vm_template', 'user_data', 'id')
2023-03-24 15:07:43,213 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:) Error 
executing: CALL `cloud`.`IDEMPOTENT_ADD_FOREIGN_KEY`('cloud.vm_template', 
'user_data', 'id')
2023-03-24 15:07:43,214 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:) 
java.sql.SQLIntegrityConstraintViolationException: Can't write; duplicate key 
in table '#sql-500_158'
2023-03-24 15:07:43,216 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null) 
(logid:) Unable to execute upgrade script
java.sql.SQLIntegrityConstraintViolationException: Can't write; duplicate key 
in table '#sql-500_158'
at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:185)
at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:87)
at 
com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:226)
at 
com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:310)
at 
com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:401)
at 
org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.checkIntegrity(CloudStackExtendedLifeCycle.java:64)
at 
org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.start(CloudStackExtendedLifeCycle.java:54)
at 
org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:178)
at 
org.springframework.context.support.DefaultLifecycleProcessor.access$200(DefaultLifecycleProcessor.java:54)
at 
org.springframework.context.support.DefaultLifecycleProcessor$LifecycleGroup.start(DefaultLifecycleProcessor.java:356)
at java.base/java.lang.Iterable.forEach(Iterable.java:75)
at 
org.springframework.context.support.DefaultLifecycleProcessor.startBeans(DefaultLifecycleProcessor.java:155)
at 
org.springframework.context.support.DefaultLifecycleProcessor.onRefresh(DefaultLifecycleProcessor.java:123)
at 
org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:935)
at 
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:586)
at 
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContext(DefaultModuleDefinitionSet.java:144)
at 
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet$2.with(DefaultModuleDefinitionSet.java:121)
at 
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:244)
at 
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:249)
at 
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:232)
at 
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContexts(DefaultModuleDefinitionSet.java:116)
at 
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.load(DefaultModuleDefinitionSet.java:78)
at 
org.apache.cloudstack.spring.module.factory.ModuleBasedContextFactory.loadModules(ModuleBasedContextFactory.java:37)
at 
org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.init(CloudStackSpringContext.java:70)
at 
org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.(CloudStackSpringContext.java:57)
at 
org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.(CloudStackSpringContext.java:61)
at 
org.apache.cloudstack.spring.module.web.CloudStackContextLoaderListener.contextInitialized(CloudStackContextLoaderListener.java:52)
at 

API question.

[JeanPaul van der Mijle]

Hi All,

Been playing with the API for a bit for an easy access/streamlined front end. I 
have found out several things that seems not right in the documents.

Following the documents at https://cloudstack.apache.org/api/apidocs-4.17/, 
since we have 4.17.2.0 installed at the moment, I found that the documents 
isn't always right. For instance:

Authentication, Login.
It mentions passwords needs to be hashed in md5. I was debugging over an hour 
why it didn't work, to find out this was not true and it just accepts plain 
text passwords. Even if MD5 is weak, it is not the biggest issue right now. 
Documents refer for other options of hashing should be made myself. Which is on 
the task list anyway as MD5 is only good for testing. But it is not even there.

Now for the thing that bugs me the most right now, which doesn't stop the rest 
of the development but is quite annoying:

Users, listUsers. *
Users, getUser.
Accounts, listAccounts. *

All have the same issue, in the response I should get icon response too. At 
least 1 out of the 3. It's not there.
For the other 2 (marked with *) they both have in their request a non required 
flag: showicon.
I tried:
showicon
showicon=true
showicon=1
showicon=yes

So far, all errors out and I get the message that either credentials are at 
fault or that the signature is incorrect.
However, removing this flag, the command works. So I doubt it is faulty creds.

I did the flag as well within the signature, as outside the signature, so far 
no juice.

I am aware about the pickyness of the API, so within PHP I just build up an 
array and run http_build_query to keep the alphabetic order on the request.

Hope someone can give me insight!

Thanks, have a nice weekend.

With regards,

JeanPaul

SQL error and "can't upgrade database" when I try to upgrade CS 4.17.1.0 to 4.18.0.0

[David Larsen]

Hi

I’m running CS 4.17.1.0 on ubuntu 18.04 and MySQL 5.7.41, and tried to upgrade 
to 4.18.0.0

Please see log bellow for details regarding sql error.


2023-03-24 15:07:42,669 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CALL 
`cloud`.`IDEMPOTENT_ADD_COLUMN`('cloud.vm_template', 'user_data_id', 'bigint 
unsigned DEFAULT NULL COMMENT "id of the us   er 
data"')
2023-03-24 15:07:43,075 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CALL 
`cloud`.`IDEMPOTENT_ADD_FOREIGN_KEY`('cloud.vm_template', 'user_data', 'id')
2023-03-24 15:07:43,213 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:) Error 
executing: CALL `cloud`.`IDEMPOTENT_ADD_FOREIGN_KEY`('cloud.vm_template', 
'user_data', 'id')
2023-03-24 15:07:43,214 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:) 
java.sql.SQLIntegrityConstraintViolationException: Can't write; duplicate key 
in table '#sql-500_158'
2023-03-24 15:07:43,216 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null) 
(logid:) Unable to execute upgrade script
java.sql.SQLIntegrityConstraintViolationException: Can't write; duplicate key 
in table '#sql-500_158'
at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:185)
at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:87)
at 
com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:226)
at 
com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:310)
at 
com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:401)
at 
org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.checkIntegrity(CloudStackExtendedLifeCycle.java:64)
at 
org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.start(CloudStackExtendedLifeCycle.java:54)
at 
org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:178)
at 
org.springframework.context.support.DefaultLifecycleProcessor.access$200(DefaultLifecycleProcessor.java:54)
at 
org.springframework.context.support.DefaultLifecycleProcessor$LifecycleGroup.start(DefaultLifecycleProcessor.java:356)
at java.base/java.lang.Iterable.forEach(Iterable.java:75)
at 
org.springframework.context.support.DefaultLifecycleProcessor.startBeans(DefaultLifecycleProcessor.java:155)
at 
org.springframework.context.support.DefaultLifecycleProcessor.onRefresh(DefaultLifecycleProcessor.java:123)
at 
org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:935)
at 
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:586)
at 
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContext(DefaultModuleDefinitionSet.java:144)
at 
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet$2.with(DefaultModuleDefinitionSet.java:121)
at 
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:244)
at 
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:249)
at 
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:232)
at 
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContexts(DefaultModuleDefinitionSet.java:116)
at 
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.load(DefaultModuleDefinitionSet.java:78)
at 
org.apache.cloudstack.spring.module.factory.ModuleBasedContextFactory.loadModules(ModuleBasedContextFactory.java:37)
at 
org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.init(CloudStackSpringContext.java:70)
at 
org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.(CloudStackSpringContext.java:57)
at 
org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.(CloudStackSpringContext.java:61)
at 
org.apache.cloudstack.spring.module.web.CloudStackContextLoaderListener.contextInitialized(CloudStackContextLoaderListener.java:52)
at 
org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:1073)
at 
org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:572)
at 
org.eclipse.jetty.server.handler.ContextHandler.contextInitialized(ContextHandler.java:1002)
at 
org.eclipse.jetty.servlet.ServletHandler.initialize(ServletHandler.java:765)
at 
org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:379)
at 
org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1449)
at 
org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1414)
at 

Re: Daan Hoogland - New ASF Member

[Daan Hoogland]

thanks all,
will try to be worthy ;)

On Fri, Mar 24, 2023 at 2:17 PM Simon Weller  wrote:

> Wow, that's fantastic. Congratulations Daan!
>
> -Si
>
> On Fri, Mar 24, 2023 at 4:29 AM Paul Angus  wrote:
>
> >
> >
> > It is my pleasure to announce that Daan Hoogland as been elected to
> become
> > a
> > member of the ASF.
> >
> > The ASF would like to recognize both his practical involvement and the
> way
> > in which he has interacted with others in and around the ASF.
> >
> >
> >
> > Congratulations  Daan.
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > Kind regards
> >
> >
> >
> > Paul Angus
> >
> >
> >
> >
>


-- 
Daan

Re: Daan Hoogland - New ASF Member

[Simon Weller]

Wow, that's fantastic. Congratulations Daan!

-Si

On Fri, Mar 24, 2023 at 4:29 AM Paul Angus  wrote:

>
>
> It is my pleasure to announce that Daan Hoogland as been elected to become
> a
> member of the ASF.
>
> The ASF would like to recognize both his practical involvement and the way
> in which he has interacted with others in and around the ASF.
>
>
>
> Congratulations  Daan.
>
>
>
>
>
>
>
>
>
> Kind regards
>
>
>
> Paul Angus
>
>
>
>

Re: Daan Hoogland - New ASF Member

[Ruben Bosch]

Congrats Daan!

Met vriendelijke groet / Kind regards,

Ruben Bosch
CLDIN

> On 24 Mar 2023, at 14:07, Suresh Kumar Anaparti 
>  wrote:
> 
> Congratulations Daan!
> 
> Regards,
> Suresh
> 
> On Fri, Mar 24, 2023 at 2:59 PM Paul Angus  wrote:
>> 
>> 
>> 
>> It is my pleasure to announce that Daan Hoogland as been elected to become a
>> member of the ASF.
>> 
>> The ASF would like to recognize both his practical involvement and the way
>> in which he has interacted with others in and around the ASF.
>> 
>> 
>> 
>> Congratulations  Daan.
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> Kind regards
>> 
>> 
>> 
>> Paul Angus
>> 
>> 
>> 

Re: Daan Hoogland - New ASF Member

[Suresh Kumar Anaparti]

Congratulations Daan!

Regards,
Suresh

On Fri, Mar 24, 2023 at 2:59 PM Paul Angus  wrote:
>
>
>
> It is my pleasure to announce that Daan Hoogland as been elected to become a
> member of the ASF.
>
> The ASF would like to recognize both his practical involvement and the way
> in which he has interacted with others in and around the ASF.
>
>
>
> Congratulations  Daan.
>
>
>
>
>
>
>
>
>
> Kind regards
>
>
>
> Paul Angus
>
>
>

Re: Daan Hoogland - New ASF Member

[Wido den Hollander]

Congrats Daan!



Op 24-03-2023 om 10:28 schreef Paul Angus:
  


It is my pleasure to announce that Daan Hoogland as been elected to become a
member of the ASF.

The ASF would like to recognize both his practical involvement and the way
in which he has interacted with others in and around the ASF.

  


Congratulations  Daan.

  

  

  

  


Kind regards

  


Paul Angus

  

Re: Daan Hoogland - New ASF Member

[Vishesh Jindal]

Congrats Daan!

From: Nux 
Sent: Friday, March 24, 2023 5:31 PM
To: d...@cloudstack.apache.org 
Cc: users@cloudstack.apache.org 
Subject: Re: Daan Hoogland - New ASF Member

Wow, congrats Daan!

On 2023-03-24 09:28, Paul Angus wrote:
> It is my pleasure to announce that Daan Hoogland as been elected to
> become a
> member of the ASF.
>
> The ASF would like to recognize both his practical involvement and the
> way
> in which he has interacted with others in and around the ASF.
>
>
>
> Congratulations  Daan.
>
>
>
>
>
>
>
>
>
> Kind regards
>
>
>
> Paul Angus

 

Re: question regarding use of usage records

[Daan Hoogland]

Swen,
I think you are right, except maybe textual; in your case the id of the VM
is 62 and the id of the vm the volume belongs to is 26. I am assuming here
that there is no bug that transposes the digits of the id.
regards,

On Thu, Mar 23, 2023 at 5:42 PM  wrote:

> Hey all,
>
>
>
> I am playing around with usage records and I am a little bit stuck in
> understanding some mappings. As far as I see it is not possible to map a
> volume to a virtual machine by using the usage records only. Is this
> correct, or do I miss something? Any idea?
>
>
>
> Here is the usage records output for 1 vm:
>
>
>
> "account": "admin",
>
> "accountid": "8ef6bd85-86a3-11ed-b0af-5a15ae8c1838",
>
> "domainid": "ee2aff59-86a2-11ed-b0af-5a15ae8c1838",
>
> "domain": "ROOT",
>
> "zoneid": "73d1a241-5719-4771-b3fd-a9943de2bb87",
>
> "description": "Running VM usage for mysql3 (i-2-62-VM)
> (2000b926-003c-467e-9493-63f5faa59a69) using service offering Instance
> LocalSSD - Default 10GB SSD (8201645c-3428-4aef-a0c4-8bd066d30d8f) and
> template Ubuntu 22.04 LTS 64bit (ed8a6760-b23e-494c-84a1-7f55e5035a7c)",
>
> "usage": "1 Hrs",
>
> "usagetype": 1,
>
> "rawusage": 1,
>
> "virtualmachineid":
> "2000b926-003c-467e-9493-63f5faa59a69",
>
> "name": "mysql3",
>
> "offeringid": "8201645c-3428-4aef-a0c4-8bd066d30d8f",
>
> "templateid": "ed8a6760-b23e-494c-84a1-7f55e5035a7c",
>
> "ostypeid": "ef326446-86a2-11ed-b0af-5a15ae8c1838",
>
> "osdisplayname": "Other Ubuntu (64-bit)",
>
> "oscategoryid": "ee62e83d-86a2-11ed-b0af-5a15ae8c1838",
>
> "oscategoryname": "Ubuntu",
>
> "usageid": "2000b926-003c-467e-9493-63f5faa59a69",
>
> "type": "XenServer",
>
> "cpunumber": 1,
>
> "cpuspeed": 2000,
>
> "memory": 1024,
>
> "startdate": "2023-03-22'T'11:00:00+01:00",
>
> "enddate": "2023-03-22'T'11:59:59+01:00",
>
> "tags": [
>
>
>
> ]
>
>
>
> And here is the usage records output of 1 volume:
>
>
>
> "account": "admin",
>
> "accountid": "8ef6bd85-86a3-11ed-b0af-5a15ae8c1838",
>
> "domainid": "ee2aff59-86a2-11ed-b0af-5a15ae8c1838",
>
> "domain": "ROOT",
>
> "zoneid": "73d1a241-5719-4771-b3fd-a9943de2bb87",
>
> "description": "Volume usage for ROOT-26 (null) with
> disk offering Custom LocalSSD (5684e5ac-bf27-4a94-93e9-12d07f0c60f4) and
> size (10.00 GB) 10737418240",
>
> "usage": "1 Hrs",
>
> "usagetype": 6,
>
> "rawusage": 1,
>
> "offeringid": "5684e5ac-bf27-4a94-93e9-12d07f0c60f4",
>
> "size": 10737418240,
>
> "startdate": "2023-03-22'T'11:00:00+01:00",
>
> "enddate": "2023-03-22'T'11:59:59+01:00",
>
> "tags": [
>
>
>
> ]
>
>

-- 
Daan

Re: Usage Types docu

[Daan Hoogland]

Swen,
I guess the docs were not updated for that. You can add a PR to
https://github.com/apache/cloudstack-documentation if you wish.
So far, and initially for any new feature; the code is the documentation. ;)

On Thu, Mar 23, 2023 at 4:31 PM  wrote:

> Hi all,
>
>
>
> I found this in the docu regarding usage types:
>
> http://docs.cloudstack.apache.org/en/latest/adminguide/usage.html?highlight=
> usage#usage-types
> 
>
> But it looks like 4.18.0.0 has more types (id 15 - 21) as the ones
> mentioned
> in the docu. Did I missed something? Is there any kind of docu regarding
> the
> new usage types?
>
>
>
> Regards,
>
> Swen
>
>

-- 
Daan

Re: Daan Hoogland - New ASF Member

[Nux]

Wow, congrats Daan!

On 2023-03-24 09:28, Paul Angus wrote:
It is my pleasure to announce that Daan Hoogland as been elected to 
become a

member of the ASF.

The ASF would like to recognize both his practical involvement and the 
way

in which he has interacted with others in and around the ASF.



Congratulations  Daan.









Kind regards



Paul Angus

Fwd: TAC supporting Berlin Buzzwords

[Daan Hoogland]

-- Forwarded message -
From: Gavin McDonald 
Date: Fri, Mar 24, 2023 at 10:57 AM
Subject: TAC supporting Berlin Buzzwords
To: 


PMCs,

Please forward to your dev and user lists.

Hi All,

The ASF Travel Assistance Committee is supporting taking up to six (6)
people
to attend Berlin Buzzwords In June this year.

This includes Conference passes, and travel & accommodation as needed.

Please see our website at https://tac.apache.org for more information and
how to apply.

Applications close on 15th April.

Good luck to those that apply.

Gavin McDonald (VP TAC)




-- 
Daan

Re: Daan Hoogland - New ASF Member

[Rohit Yadav]

Congrats Daan!



Regards.


From: Slavka Peleva 
Sent: Friday, March 24, 2023 15:48
To: d...@cloudstack.apache.org 
Cc: users@cloudstack.apache.org 
Subject: Re: Daan Hoogland - New ASF Member

Congratulations Daan!

Best regards,
Slavka

On Fri, Mar 24, 2023 at 12:01 PM Nicolas Vazquez <
nicolas.vazq...@shapeblue.com> wrote:

> Congratulations Daan!
>
> Regards,
> Nicolas Vaquez
> 
> From: Paul Angus 
> Sent: Friday, March 24, 2023 6:28:54 AM
> To: users@cloudstack.apache.org ;
> d...@cloudstack.apache.org 
> Subject: Daan Hoogland - New ASF Member
>
>
>
> It is my pleasure to announce that Daan Hoogland as been elected to become
> a
> member of the ASF.
>
> The ASF would like to recognize both his practical involvement and the way
> in which he has interacted with others in and around the ASF.
>
>
>
> Congratulations  Daan.
>
>
>
>
>
>
>
>
>
> Kind regards
>
>
>
> Paul Angus
>
>
>
>
>
>
>

 

Re: Daan Hoogland - New ASF Member

[Slavka Peleva]

Congratulations Daan!

Best regards,
Slavka

On Fri, Mar 24, 2023 at 12:01 PM Nicolas Vazquez <
nicolas.vazq...@shapeblue.com> wrote:

> Congratulations Daan!
>
> Regards,
> Nicolas Vaquez
> 
> From: Paul Angus 
> Sent: Friday, March 24, 2023 6:28:54 AM
> To: users@cloudstack.apache.org ;
> d...@cloudstack.apache.org 
> Subject: Daan Hoogland - New ASF Member
>
>
>
> It is my pleasure to announce that Daan Hoogland as been elected to become
> a
> member of the ASF.
>
> The ASF would like to recognize both his practical involvement and the way
> in which he has interacted with others in and around the ASF.
>
>
>
> Congratulations  Daan.
>
>
>
>
>
>
>
>
>
> Kind regards
>
>
>
> Paul Angus
>
>
>
>
>
>
>

Re: Daan Hoogland - New ASF Member

[Nicolas Vazquez]

Congratulations Daan!

Regards,
Nicolas Vaquez

From: Paul Angus 
Sent: Friday, March 24, 2023 6:28:54 AM
To: users@cloudstack.apache.org ; 
d...@cloudstack.apache.org 
Subject: Daan Hoogland - New ASF Member



It is my pleasure to announce that Daan Hoogland as been elected to become a
member of the ASF.

The ASF would like to recognize both his practical involvement and the way
in which he has interacted with others in and around the ASF.



Congratulations  Daan.









Kind regards



Paul Angus




 

Re: Daan Hoogland - New ASF Member

[Kiran Chavala]

Congratulations Daan

Regards
Kiran

From: Paul Angus 
Sent: 24 March 2023 14:58
To: users@cloudstack.apache.org ; 
d...@cloudstack.apache.org 
Subject: Daan Hoogland - New ASF Member



It is my pleasure to announce that Daan Hoogland as been elected to become a
member of the ASF.

The ASF would like to recognize both his practical involvement and the way
in which he has interacted with others in and around the ASF.



Congratulations  Daan.









Kind regards



Paul Angus




 

Daan Hoogland - New ASF Member

[Paul Angus]

 

It is my pleasure to announce that Daan Hoogland as been elected to become a
member of the ASF.

The ASF would like to recognize both his practical involvement and the way
in which he has interacted with others in and around the ASF.

 

Congratulations  Daan.

 

 

 

 

Kind regards

 

Paul Angus