Cloudstack installation on Ubuntu Xenial

[Daniel Coric]

Hello Everyone,

I'm getting myself familiar with CloudStack so please excuse if I have 
overlooked something obvious.

Using build and install instructions from the official documentation I have 
managed to successfully install CloudStack 4.11 on the neasted CentOS 7.4 KVM 
(from both community provided package repositories and self-built packages).

I have tried some of the basic operations like: uploading iso images, adding 
volumes and users, creating templates, creating and using VMs (both as admin 
and user) etc. 
As far as I can tell, everything worked as expected - except the fact that 
CentOS VM took about half an hour to shut down.

Than I decided to give it a try on Ubuntu too. And indeed, Ubuntu 16.04.4 VM 
shut down normally. 

But, that was also the only thing that worked as expected on that Ubuntu VM.

I have tried to find some solution on internet but the closest I could get was 
this thread:
https://www.mail-archive.com/users@cloudstack.apache.org/msg22578.html
and this documentation:
http://docs.cloudstack.apache.org/projects/cloudstack-administration/en/latest/hosts.html#security

And I'm not even sure if I am on the right path to the solution - any 
assistance would be much appreciated.



Ubuntu 16.04.4 cloudstack-management.err is filled with:

Mon Mar 12 20:30:24 CET 2018 WARN: Establishing SSL connection without server's 
identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ 
and 5.7.6+ requirements SSL connection must be established by default if 
explicit option isn't set. For compliance with existing applications not using 
SSL the verifyServerCertificate property is set to 'false'. You need either to 
explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide 
truststore for server certificate verification.

Ubuntu 16.04.4 agent.log is filled with:

2018-03-12 20:43:58,782 INFO  [utils.exception.CSExceptionErrorCode] 
(main:null) (logid:) Could not find exception: 
com.cloud.utils.exception.NioConnectionException in error code list for 
exceptions
2018-03-12 20:43:58,782 WARN  [cloud.agent.Agent] (main:null) (logid:) NIO 
Connection Exception  com.cloud.utils.exception.NioConnectionException: SSL 
Handshake failed while connecting to host: 10.22.0.5 port: 8250
2018-03-12 20:43:58,782 INFO  [cloud.agent.Agent] (main:null) (logid:) 
Attempted to connect to the server, but received an unexpected exception, 
trying again...
2018-03-12 20:44:03,783 INFO  [cloud.agent.Agent] (main:null) (logid:) 
Connecting to host:10.22.0.5
2018-03-12 20:44:03,783 INFO  [utils.nio.NioClient] (main:null) (logid:) 
Connecting to 10.22.0.5:8250
2018-03-12 20:44:03,786 INFO  [utils.nio.Link] (main:null) (logid:) Conf file 
found: /etc/cloudstack/agent/agent.properties
2018-03-12 20:44:03,787 WARN  [utils.nio.Link] (main:null) (logid:) Failed to 
load keystore, using trust all manager
2018-03-12 20:44:03,858 ERROR [utils.nio.Link] (main:null) (logid:) SSL error 
caught during unwrap data: Received fatal alert: bad_certificate, for local 
address=/10.22.0.5:53356, remote address=/10.22.0.5:8250. The client may have 
invalid ca-certificates.
2018-03-12 20:44:03,858 ERROR [utils.nio.NioClient] (main:null) (logid:) SSL 
Handshake failed while connecting to host: 10.22.0.5 port: 8250
2018-03-12 20:44:03,858 ERROR [utils.nio.NioConnection] (main:null) (logid:) 
Unable to initialize the threads.
java.io.IOException: SSL Handshake failed while connecting to host: 10.22.0.5 
port: 8250
at com.cloud.utils.nio.NioClient.init(NioClient.java:67)
at com.cloud.utils.nio.NioConnection.start(NioConnection.java:95)
at com.cloud.agent.Agent.start(Agent.java:263)
at com.cloud.agent.AgentShell.launchAgent(AgentShell.java:410)
at 
com.cloud.agent.AgentShell.launchAgentFromClassInfo(AgentShell.java:378)
at com.cloud.agent.AgentShell.launchAgent(AgentShell.java:362)
at com.cloud.agent.AgentShell.start(AgentShell.java:467)
at com.cloud.agent.AgentShell.main(AgentShell.java:502)



Regards
D.Coric

Re: Failed to add data store: DB Exception on: com.mysql.jdbc.JDBC42PreparedStatement

[Rafael Weingärtner]

Does ACS have a native support to Ceph?
How is the storage setup in your hosts? How are you presenting this storage
to ACS?

On Mon, Mar 12, 2018 at 4:56 PM, McClune, James <
mcclu...@norwalktruckers.net> wrote:

> I'm using the UI to register storage.
>
> - James
>
> On Mon, Mar 12, 2018 at 3:50 PM, Rafael Weingärtner <
> rafaelweingart...@gmail.com> wrote:
>
> > So, you are getting the error while adding the storage in ACS. Right?
> > I copied and pasted the SQL you have your logs, and I got this:
> > Error: Column 'host_address' cannot be null
> > SQLState:  23000
> >
> >
> > This is the SQL I executed, which is in one of your emails:
> >
> > > INSERT INTO storage_pool
> > > (storage_pool.id,storage_pool.name
> > > ,storage_pool.uuid
> > > ,storage_pool.pool_type,storage_pool.created
> > > ,storage_pool.update_time,storage_pool.data_center_id,
> > storage_pool.pod_id,storage_pool.used_bytes,storage_pool.
> > capacity_bytes,storage_pool.status,storage_pool.storage_
> > provider_name,storage_pool.host_address,storage_pool.path
> > > ,storage_pool.port,storage_pool.user_info,storage_pool.
> > cluster_id,storage_pool.scope,storage_pool.managed,storage_
> > pool.capacity_iops,storage_pool.hypervisor)
> > > VALUES
> > > (0
> > > ,_binary'PrimaryStorage1',_binary'9c279e74-15a5-3c8a-
> > b0d1-14349b59710a','RBD'
> > > ,'2018-03-12 14:55:18',null,1
> > > ,1  ,0  ,0
> > > ,'Initialized'  ,_binary'DefaultPrimary'
> > > ,null ,_binary'6A==@10.10.13.141/rbd',6789
> > > ,null  ,1  ,null
> > > ,0   ,null  ,null
>  )
> > >
> >
> > Are you using the API or UI to register this storage?
> >
> >
> > On Mon, Mar 12, 2018 at 4:47 PM, McClune, James <
> > mcclu...@norwalktruckers.net> wrote:
> >
> > > I started fresh with 4.11.0. The Ceph storage was already setup,
> however,
> > > I'm just now adding it to ACS.
> > >
> > > I get this error anytime I add primary storage. Secondary storage can
> be
> > > added with no problems.
> > >
> > > - James
> > >
> > > On Mon, Mar 12, 2018 at 3:39 PM, Rafael Weingärtner <
> > > rafaelweingart...@gmail.com> wrote:
> > >
> > > > When are you receiving this error? I mean, are you receiving it when
> > you
> > > > add the storage? Or, when you do something else? Was the storage
> > already
> > > > confgured?
> > > >
> > > >
> > > > On Mon, Mar 12, 2018 at 4:35 PM, McClune, James <
> > > > mcclu...@norwalktruckers.net> wrote:
> > > >
> > > > > I'm using Oracle MySQL.
> > > > >
> > > > > - James
> > > > >
> > > > > On Mon, Mar 12, 2018 at 3:33 PM, Rafael Weingärtner <
> > > > > rafaelweingart...@gmail.com> wrote:
> > > > >
> > > > > > Well, you can delete the entry you just inserted. the idea to run
> > the
> > > > SQL
> > > > > > was to find the problem.
> > > > > > It is odd, I was expecting to be a missing column problem. What
> is
> > > the
> > > > DB
> > > > > > that you are using? MariaDB or Oracle MySQL?
> > > > > >
> > > > > > On Mon, Mar 12, 2018 at 4:29 PM, McClune, James <
> > > > > > mcclu...@norwalktruckers.net> wrote:
> > > > > >
> > > > > > > Hi Rafael,
> > > > > > >
> > > > > > > I ran the SQL query and got these errors:
> > > > > > >
> > > > > > >
> > > > > > > When I deleted the *_binary* and *storage_pool.* from the query
> > > > > entries,
> > > > > > > it seemed to work. However, I'm still experiencing oddities:
> > > > > > >
> > > > > > >
> > > > > > > Some of my entries were 'null', when they shouldn't be.
> > > > > > >
> > > > > > > Any help is much appreciated.
> > > > > > >
> > > > > > > Thanks,
> > > > > > > James
> > > > > > >
> > > > > > > On Mon, Mar 12, 2018 at 3:06 PM, Rafael Weingärtner <
> > > > > > > rafaelweingart...@gmail.com> wrote:
> > > > > > >
> > > > > > >> Did you try running the insert that is causing the error
> > manually?
> > > > > > >>
> > > > > > >> On Mon, Mar 12, 2018 at 4:04 PM, McClune, James <
> > > > > > >> mcclu...@norwalktruckers.net> wrote:
> > > > > > >>
> > > > > > >> > Hello CloudStack Community,
> > > > > > >> >
> > > > > > >> > I just upgraded ACS from 4.9.3 to 4.11.0. I'm revamping my
> > > primary
> > > > > > >> storage
> > > > > > >> > (Ceph RBD). The problem I'm experiencing is every time I try
> > to
> > > > > re-add
> > > > > > >> my
> > > > > > >> > Ceph storage pool, I get this error:
> > > > > > >> >
> > > > > > >> >
> > > > > > >> >- Something went wrong; please correct the following:
> > > > > > >> >Failed to add data store: DB Exception on:
> > > > > > >> >com.mysql.jdbc.JDBC42PreparedStatement@71996b4a: INSERT
> > INTO
> > > > > > >> >storage_pool (storage_pool.id, storage_pool.name,
> > > > > > storage_pool.uuid,
> > > > > > >> >storage_pool.pool_type, storage_pool.created,
> > > > > > >> storage_pool.update_time,
> > > > > > >> >storage_pool.data_center_id, storage_pool.pod_id,
> > > > > > >> > storage_pool.used_bytes,
> > > > > > >> >stor

Re: Failed to add data store: DB Exception on: com.mysql.jdbc.JDBC42PreparedStatement

[Rafael Weingärtner]

If you are entering the IP, there is something wrong. Are you using the UI
or APi via CloudMonkey?

On Mon, Mar 12, 2018 at 4:55 PM, McClune, James <
mcclu...@norwalktruckers.net> wrote:

> Yes, I also got Error: Column 'host_address' cannot be null as well. I
> manually added my RADOS monitor IP for the host_address.
>
> Is this right?
>
> - James
>
> On Mon, Mar 12, 2018 at 3:51 PM, McClune, James <
> mcclu...@norwalktruckers.net> wrote:
>
> > Sorry if I confused you on upgrading from 4.9.3 to 4.11.0. I decided to
> > start from scratch and re-installed with 4.11.0.
> >
> > I did not use any old SQL backups from 4.9.3.
> >
> > - James
> >
> > On Mon, Mar 12, 2018 at 3:39 PM, Rafael Weingärtner <
> > rafaelweingart...@gmail.com> wrote:
> >
> >> When are you receiving this error? I mean, are you receiving it when you
> >> add the storage? Or, when you do something else? Was the storage already
> >> confgured?
> >>
> >>
> >> On Mon, Mar 12, 2018 at 4:35 PM, McClune, James <
> >> mcclu...@norwalktruckers.net> wrote:
> >>
> >> > I'm using Oracle MySQL.
> >> >
> >> > - James
> >> >
> >> > On Mon, Mar 12, 2018 at 3:33 PM, Rafael Weingärtner <
> >> > rafaelweingart...@gmail.com> wrote:
> >> >
> >> > > Well, you can delete the entry you just inserted. the idea to run
> the
> >> SQL
> >> > > was to find the problem.
> >> > > It is odd, I was expecting to be a missing column problem. What is
> >> the DB
> >> > > that you are using? MariaDB or Oracle MySQL?
> >> > >
> >> > > On Mon, Mar 12, 2018 at 4:29 PM, McClune, James <
> >> > > mcclu...@norwalktruckers.net> wrote:
> >> > >
> >> > > > Hi Rafael,
> >> > > >
> >> > > > I ran the SQL query and got these errors:
> >> > > >
> >> > > >
> >> > > > When I deleted the *_binary* and *storage_pool.* from the query
> >> > entries,
> >> > > > it seemed to work. However, I'm still experiencing oddities:
> >> > > >
> >> > > >
> >> > > > Some of my entries were 'null', when they shouldn't be.
> >> > > >
> >> > > > Any help is much appreciated.
> >> > > >
> >> > > > Thanks,
> >> > > > James
> >> > > >
> >> > > > On Mon, Mar 12, 2018 at 3:06 PM, Rafael Weingärtner <
> >> > > > rafaelweingart...@gmail.com> wrote:
> >> > > >
> >> > > >> Did you try running the insert that is causing the error
> manually?
> >> > > >>
> >> > > >> On Mon, Mar 12, 2018 at 4:04 PM, McClune, James <
> >> > > >> mcclu...@norwalktruckers.net> wrote:
> >> > > >>
> >> > > >> > Hello CloudStack Community,
> >> > > >> >
> >> > > >> > I just upgraded ACS from 4.9.3 to 4.11.0. I'm revamping my
> >> primary
> >> > > >> storage
> >> > > >> > (Ceph RBD). The problem I'm experiencing is every time I try to
> >> > re-add
> >> > > >> my
> >> > > >> > Ceph storage pool, I get this error:
> >> > > >> >
> >> > > >> >
> >> > > >> >- Something went wrong; please correct the following:
> >> > > >> >Failed to add data store: DB Exception on:
> >> > > >> >com.mysql.jdbc.JDBC42PreparedStatement@71996b4a: INSERT
> INTO
> >> > > >> >storage_pool (storage_pool.id, storage_pool.name,
> >> > > storage_pool.uuid,
> >> > > >> >storage_pool.pool_type, storage_pool.created,
> >> > > >> storage_pool.update_time,
> >> > > >> >storage_pool.data_center_id, storage_pool.pod_id,
> >> > > >> > storage_pool.used_bytes,
> >> > > >> >storage_pool.capacity_bytes, storage_pool.status,
> >> > > >> >storage_pool.storage_provider_name,
> >> storage_pool.host_address,
> >> > > >> >storage_pool.path, storage_pool.port,
> storage_pool.user_info,
> >> > > >> >storage_pool.cluster_id, storage_pool.scope,
> >> > storage_pool.managed,
> >> > > >> >storage_pool.capacity_iops, storage_pool.hypervisor) VALUES
> >> (0,
> >> > > >> >_binary'PrimaryStorage1', _binary'9c279e74-15a5-3c8a-
> >> > > >> > b0d1-14349b59710a',
> >> > > >> >'RBD', '2018-03-12 14:55:18', null, 1, 1, 0, 0,
> 'Initialized',
> >> > > >> >_binary'DefaultPrimary', null, _binary'6A==@
> 10.10.13.141/rbd'
> >> ,
> >> > > 6789,
> >> > > >> >null, 1, null, 0, null, null)
> >> > > >> >
> >> > > >> > Here is the error from the management-server.log file:
> >> > > >> >
> >> > > >> > 2018-03-12 11:01:32,786 DEBUG [c.c.u.d.T.Transaction]
> >> > > >> > (qtp66233253-19:ctx-04c43d3a ctx-329be767) (logid:c19a8879)
> >> Rolling
> >> > > back
> >> > > >> > the transaction: Time = 1 Name =  qtp66233253-19; called by
> >> > > >> > -TransactionLegacy.rollback:889-TransactionLegacy.removeUpTo
> >> :832-
> >> > > >> > TransactionLegacy.close:656-TransactionContextInterceptor.
> >> > invoke:36-
> >> > > >> > ReflectiveMethodInvocation.proceed:174-ExposeInvocationInter
> >> ceptor.
> >> > > >> > invoke:92-ReflectiveMethodInvocation.proceed:185-
> >> > > >> > JdkDynamicAopProxy.invoke:212-$Proxy91.persist:-1-PrimaryDat
> >> > > >> aStoreHelper.
> >> > > >> > createPrimaryDataStore:135-CloudStackPrimaryDataStoreLife
> >> > > >> > CycleImpl.initialize:353-StorageManagerImpl.createPool:710
> >> > > >> > 2018-03-12 11:01:32,788 DEBUG [c.c.s.StorageManagerImpl]

Re: Failed to add data store: DB Exception on: com.mysql.jdbc.JDBC42PreparedStatement

[McClune, James]

I'm using the UI to register storage.

- James

On Mon, Mar 12, 2018 at 3:50 PM, Rafael Weingärtner <
rafaelweingart...@gmail.com> wrote:

> So, you are getting the error while adding the storage in ACS. Right?
> I copied and pasted the SQL you have your logs, and I got this:
> Error: Column 'host_address' cannot be null
> SQLState:  23000
>
>
> This is the SQL I executed, which is in one of your emails:
>
> > INSERT INTO storage_pool
> > (storage_pool.id,storage_pool.name
> > ,storage_pool.uuid
> > ,storage_pool.pool_type,storage_pool.created
> > ,storage_pool.update_time,storage_pool.data_center_id,
> storage_pool.pod_id,storage_pool.used_bytes,storage_pool.
> capacity_bytes,storage_pool.status,storage_pool.storage_
> provider_name,storage_pool.host_address,storage_pool.path
> > ,storage_pool.port,storage_pool.user_info,storage_pool.
> cluster_id,storage_pool.scope,storage_pool.managed,storage_
> pool.capacity_iops,storage_pool.hypervisor)
> > VALUES
> > (0
> > ,_binary'PrimaryStorage1',_binary'9c279e74-15a5-3c8a-
> b0d1-14349b59710a','RBD'
> > ,'2018-03-12 14:55:18',null,1
> > ,1  ,0  ,0
> > ,'Initialized'  ,_binary'DefaultPrimary'
> > ,null ,_binary'6A==@10.10.13.141/rbd',6789
> > ,null  ,1  ,null
> > ,0   ,null  ,null   )
> >
>
> Are you using the API or UI to register this storage?
>
>
> On Mon, Mar 12, 2018 at 4:47 PM, McClune, James <
> mcclu...@norwalktruckers.net> wrote:
>
> > I started fresh with 4.11.0. The Ceph storage was already setup, however,
> > I'm just now adding it to ACS.
> >
> > I get this error anytime I add primary storage. Secondary storage can be
> > added with no problems.
> >
> > - James
> >
> > On Mon, Mar 12, 2018 at 3:39 PM, Rafael Weingärtner <
> > rafaelweingart...@gmail.com> wrote:
> >
> > > When are you receiving this error? I mean, are you receiving it when
> you
> > > add the storage? Or, when you do something else? Was the storage
> already
> > > confgured?
> > >
> > >
> > > On Mon, Mar 12, 2018 at 4:35 PM, McClune, James <
> > > mcclu...@norwalktruckers.net> wrote:
> > >
> > > > I'm using Oracle MySQL.
> > > >
> > > > - James
> > > >
> > > > On Mon, Mar 12, 2018 at 3:33 PM, Rafael Weingärtner <
> > > > rafaelweingart...@gmail.com> wrote:
> > > >
> > > > > Well, you can delete the entry you just inserted. the idea to run
> the
> > > SQL
> > > > > was to find the problem.
> > > > > It is odd, I was expecting to be a missing column problem. What is
> > the
> > > DB
> > > > > that you are using? MariaDB or Oracle MySQL?
> > > > >
> > > > > On Mon, Mar 12, 2018 at 4:29 PM, McClune, James <
> > > > > mcclu...@norwalktruckers.net> wrote:
> > > > >
> > > > > > Hi Rafael,
> > > > > >
> > > > > > I ran the SQL query and got these errors:
> > > > > >
> > > > > >
> > > > > > When I deleted the *_binary* and *storage_pool.* from the query
> > > > entries,
> > > > > > it seemed to work. However, I'm still experiencing oddities:
> > > > > >
> > > > > >
> > > > > > Some of my entries were 'null', when they shouldn't be.
> > > > > >
> > > > > > Any help is much appreciated.
> > > > > >
> > > > > > Thanks,
> > > > > > James
> > > > > >
> > > > > > On Mon, Mar 12, 2018 at 3:06 PM, Rafael Weingärtner <
> > > > > > rafaelweingart...@gmail.com> wrote:
> > > > > >
> > > > > >> Did you try running the insert that is causing the error
> manually?
> > > > > >>
> > > > > >> On Mon, Mar 12, 2018 at 4:04 PM, McClune, James <
> > > > > >> mcclu...@norwalktruckers.net> wrote:
> > > > > >>
> > > > > >> > Hello CloudStack Community,
> > > > > >> >
> > > > > >> > I just upgraded ACS from 4.9.3 to 4.11.0. I'm revamping my
> > primary
> > > > > >> storage
> > > > > >> > (Ceph RBD). The problem I'm experiencing is every time I try
> to
> > > > re-add
> > > > > >> my
> > > > > >> > Ceph storage pool, I get this error:
> > > > > >> >
> > > > > >> >
> > > > > >> >- Something went wrong; please correct the following:
> > > > > >> >Failed to add data store: DB Exception on:
> > > > > >> >com.mysql.jdbc.JDBC42PreparedStatement@71996b4a: INSERT
> INTO
> > > > > >> >storage_pool (storage_pool.id, storage_pool.name,
> > > > > storage_pool.uuid,
> > > > > >> >storage_pool.pool_type, storage_pool.created,
> > > > > >> storage_pool.update_time,
> > > > > >> >storage_pool.data_center_id, storage_pool.pod_id,
> > > > > >> > storage_pool.used_bytes,
> > > > > >> >storage_pool.capacity_bytes, storage_pool.status,
> > > > > >> >storage_pool.storage_provider_name,
> > storage_pool.host_address,
> > > > > >> >storage_pool.path, storage_pool.port,
> storage_pool.user_info,
> > > > > >> >storage_pool.cluster_id, storage_pool.scope,
> > > > storage_pool.managed,
> > > > > >> >storage_pool.capacity_iops, storage_pool.hypervisor) VALUES
> > (0,
> > > > > >> >_binary'PrimaryStorage1', _binary'9c279e74-15a5-3c8a-
> >

Re: Failed to add data store: DB Exception on: com.mysql.jdbc.JDBC42PreparedStatement

[McClune, James]

Yes, I also got Error: Column 'host_address' cannot be null as well. I
manually added my RADOS monitor IP for the host_address.

Is this right?

- James

On Mon, Mar 12, 2018 at 3:51 PM, McClune, James <
mcclu...@norwalktruckers.net> wrote:

> Sorry if I confused you on upgrading from 4.9.3 to 4.11.0. I decided to
> start from scratch and re-installed with 4.11.0.
>
> I did not use any old SQL backups from 4.9.3.
>
> - James
>
> On Mon, Mar 12, 2018 at 3:39 PM, Rafael Weingärtner <
> rafaelweingart...@gmail.com> wrote:
>
>> When are you receiving this error? I mean, are you receiving it when you
>> add the storage? Or, when you do something else? Was the storage already
>> confgured?
>>
>>
>> On Mon, Mar 12, 2018 at 4:35 PM, McClune, James <
>> mcclu...@norwalktruckers.net> wrote:
>>
>> > I'm using Oracle MySQL.
>> >
>> > - James
>> >
>> > On Mon, Mar 12, 2018 at 3:33 PM, Rafael Weingärtner <
>> > rafaelweingart...@gmail.com> wrote:
>> >
>> > > Well, you can delete the entry you just inserted. the idea to run the
>> SQL
>> > > was to find the problem.
>> > > It is odd, I was expecting to be a missing column problem. What is
>> the DB
>> > > that you are using? MariaDB or Oracle MySQL?
>> > >
>> > > On Mon, Mar 12, 2018 at 4:29 PM, McClune, James <
>> > > mcclu...@norwalktruckers.net> wrote:
>> > >
>> > > > Hi Rafael,
>> > > >
>> > > > I ran the SQL query and got these errors:
>> > > >
>> > > >
>> > > > When I deleted the *_binary* and *storage_pool.* from the query
>> > entries,
>> > > > it seemed to work. However, I'm still experiencing oddities:
>> > > >
>> > > >
>> > > > Some of my entries were 'null', when they shouldn't be.
>> > > >
>> > > > Any help is much appreciated.
>> > > >
>> > > > Thanks,
>> > > > James
>> > > >
>> > > > On Mon, Mar 12, 2018 at 3:06 PM, Rafael Weingärtner <
>> > > > rafaelweingart...@gmail.com> wrote:
>> > > >
>> > > >> Did you try running the insert that is causing the error manually?
>> > > >>
>> > > >> On Mon, Mar 12, 2018 at 4:04 PM, McClune, James <
>> > > >> mcclu...@norwalktruckers.net> wrote:
>> > > >>
>> > > >> > Hello CloudStack Community,
>> > > >> >
>> > > >> > I just upgraded ACS from 4.9.3 to 4.11.0. I'm revamping my
>> primary
>> > > >> storage
>> > > >> > (Ceph RBD). The problem I'm experiencing is every time I try to
>> > re-add
>> > > >> my
>> > > >> > Ceph storage pool, I get this error:
>> > > >> >
>> > > >> >
>> > > >> >- Something went wrong; please correct the following:
>> > > >> >Failed to add data store: DB Exception on:
>> > > >> >com.mysql.jdbc.JDBC42PreparedStatement@71996b4a: INSERT INTO
>> > > >> >storage_pool (storage_pool.id, storage_pool.name,
>> > > storage_pool.uuid,
>> > > >> >storage_pool.pool_type, storage_pool.created,
>> > > >> storage_pool.update_time,
>> > > >> >storage_pool.data_center_id, storage_pool.pod_id,
>> > > >> > storage_pool.used_bytes,
>> > > >> >storage_pool.capacity_bytes, storage_pool.status,
>> > > >> >storage_pool.storage_provider_name,
>> storage_pool.host_address,
>> > > >> >storage_pool.path, storage_pool.port, storage_pool.user_info,
>> > > >> >storage_pool.cluster_id, storage_pool.scope,
>> > storage_pool.managed,
>> > > >> >storage_pool.capacity_iops, storage_pool.hypervisor) VALUES
>> (0,
>> > > >> >_binary'PrimaryStorage1', _binary'9c279e74-15a5-3c8a-
>> > > >> > b0d1-14349b59710a',
>> > > >> >'RBD', '2018-03-12 14:55:18', null, 1, 1, 0, 0, 'Initialized',
>> > > >> >_binary'DefaultPrimary', null, _binary'6A==@10.10.13.141/rbd'
>> ,
>> > > 6789,
>> > > >> >null, 1, null, 0, null, null)
>> > > >> >
>> > > >> > Here is the error from the management-server.log file:
>> > > >> >
>> > > >> > 2018-03-12 11:01:32,786 DEBUG [c.c.u.d.T.Transaction]
>> > > >> > (qtp66233253-19:ctx-04c43d3a ctx-329be767) (logid:c19a8879)
>> Rolling
>> > > back
>> > > >> > the transaction: Time = 1 Name =  qtp66233253-19; called by
>> > > >> > -TransactionLegacy.rollback:889-TransactionLegacy.removeUpTo
>> :832-
>> > > >> > TransactionLegacy.close:656-TransactionContextInterceptor.
>> > invoke:36-
>> > > >> > ReflectiveMethodInvocation.proceed:174-ExposeInvocationInter
>> ceptor.
>> > > >> > invoke:92-ReflectiveMethodInvocation.proceed:185-
>> > > >> > JdkDynamicAopProxy.invoke:212-$Proxy91.persist:-1-PrimaryDat
>> > > >> aStoreHelper.
>> > > >> > createPrimaryDataStore:135-CloudStackPrimaryDataStoreLife
>> > > >> > CycleImpl.initialize:353-StorageManagerImpl.createPool:710
>> > > >> > 2018-03-12 11:01:32,788 DEBUG [c.c.s.StorageManagerImpl]
>> > > >> > (qtp66233253-19:ctx-04c43d3a ctx-329be767) (logid:c19a8879)
>> Failed
>> > to
>> > > >> add
>> > > >> > data store: DB Exception on: com.mysql.jdbc.
>> > JDBC42PreparedStatement@
>> > > >> > 4901e335:
>> > > >> > INSERT INTO storage_pool (storage_pool.id, storage_pool.name,
>> > > >> > storage_pool.uuid, storage_pool.pool_type, storage_pool.created,
>> > > >> > storage_pool.update_time, storage_pool.data_center_id,
>> > > >> storag

Re: Failed to add data store: DB Exception on: com.mysql.jdbc.JDBC42PreparedStatement

[McClune, James]

Sorry if I confused you on upgrading from 4.9.3 to 4.11.0. I decided to
start from scratch and re-installed with 4.11.0.

I did not use any old SQL backups from 4.9.3.

- James

On Mon, Mar 12, 2018 at 3:39 PM, Rafael Weingärtner <
rafaelweingart...@gmail.com> wrote:

> When are you receiving this error? I mean, are you receiving it when you
> add the storage? Or, when you do something else? Was the storage already
> confgured?
>
>
> On Mon, Mar 12, 2018 at 4:35 PM, McClune, James <
> mcclu...@norwalktruckers.net> wrote:
>
> > I'm using Oracle MySQL.
> >
> > - James
> >
> > On Mon, Mar 12, 2018 at 3:33 PM, Rafael Weingärtner <
> > rafaelweingart...@gmail.com> wrote:
> >
> > > Well, you can delete the entry you just inserted. the idea to run the
> SQL
> > > was to find the problem.
> > > It is odd, I was expecting to be a missing column problem. What is the
> DB
> > > that you are using? MariaDB or Oracle MySQL?
> > >
> > > On Mon, Mar 12, 2018 at 4:29 PM, McClune, James <
> > > mcclu...@norwalktruckers.net> wrote:
> > >
> > > > Hi Rafael,
> > > >
> > > > I ran the SQL query and got these errors:
> > > >
> > > >
> > > > When I deleted the *_binary* and *storage_pool.* from the query
> > entries,
> > > > it seemed to work. However, I'm still experiencing oddities:
> > > >
> > > >
> > > > Some of my entries were 'null', when they shouldn't be.
> > > >
> > > > Any help is much appreciated.
> > > >
> > > > Thanks,
> > > > James
> > > >
> > > > On Mon, Mar 12, 2018 at 3:06 PM, Rafael Weingärtner <
> > > > rafaelweingart...@gmail.com> wrote:
> > > >
> > > >> Did you try running the insert that is causing the error manually?
> > > >>
> > > >> On Mon, Mar 12, 2018 at 4:04 PM, McClune, James <
> > > >> mcclu...@norwalktruckers.net> wrote:
> > > >>
> > > >> > Hello CloudStack Community,
> > > >> >
> > > >> > I just upgraded ACS from 4.9.3 to 4.11.0. I'm revamping my primary
> > > >> storage
> > > >> > (Ceph RBD). The problem I'm experiencing is every time I try to
> > re-add
> > > >> my
> > > >> > Ceph storage pool, I get this error:
> > > >> >
> > > >> >
> > > >> >- Something went wrong; please correct the following:
> > > >> >Failed to add data store: DB Exception on:
> > > >> >com.mysql.jdbc.JDBC42PreparedStatement@71996b4a: INSERT INTO
> > > >> >storage_pool (storage_pool.id, storage_pool.name,
> > > storage_pool.uuid,
> > > >> >storage_pool.pool_type, storage_pool.created,
> > > >> storage_pool.update_time,
> > > >> >storage_pool.data_center_id, storage_pool.pod_id,
> > > >> > storage_pool.used_bytes,
> > > >> >storage_pool.capacity_bytes, storage_pool.status,
> > > >> >storage_pool.storage_provider_name, storage_pool.host_address,
> > > >> >storage_pool.path, storage_pool.port, storage_pool.user_info,
> > > >> >storage_pool.cluster_id, storage_pool.scope,
> > storage_pool.managed,
> > > >> >storage_pool.capacity_iops, storage_pool.hypervisor) VALUES (0,
> > > >> >_binary'PrimaryStorage1', _binary'9c279e74-15a5-3c8a-
> > > >> > b0d1-14349b59710a',
> > > >> >'RBD', '2018-03-12 14:55:18', null, 1, 1, 0, 0, 'Initialized',
> > > >> >_binary'DefaultPrimary', null, _binary'6A==@10.10.13.141/rbd',
> > > 6789,
> > > >> >null, 1, null, 0, null, null)
> > > >> >
> > > >> > Here is the error from the management-server.log file:
> > > >> >
> > > >> > 2018-03-12 11:01:32,786 DEBUG [c.c.u.d.T.Transaction]
> > > >> > (qtp66233253-19:ctx-04c43d3a ctx-329be767) (logid:c19a8879)
> Rolling
> > > back
> > > >> > the transaction: Time = 1 Name =  qtp66233253-19; called by
> > > >> > -TransactionLegacy.rollback:889-TransactionLegacy.removeUpTo:832-
> > > >> > TransactionLegacy.close:656-TransactionContextInterceptor.
> > invoke:36-
> > > >> > ReflectiveMethodInvocation.proceed:174-
> ExposeInvocationInterceptor.
> > > >> > invoke:92-ReflectiveMethodInvocation.proceed:185-
> > > >> > JdkDynamicAopProxy.invoke:212-$Proxy91.persist:-1-PrimaryDat
> > > >> aStoreHelper.
> > > >> > createPrimaryDataStore:135-CloudStackPrimaryDataStoreLife
> > > >> > CycleImpl.initialize:353-StorageManagerImpl.createPool:710
> > > >> > 2018-03-12 11:01:32,788 DEBUG [c.c.s.StorageManagerImpl]
> > > >> > (qtp66233253-19:ctx-04c43d3a ctx-329be767) (logid:c19a8879) Failed
> > to
> > > >> add
> > > >> > data store: DB Exception on: com.mysql.jdbc.
> > JDBC42PreparedStatement@
> > > >> > 4901e335:
> > > >> > INSERT INTO storage_pool (storage_pool.id, storage_pool.name,
> > > >> > storage_pool.uuid, storage_pool.pool_type, storage_pool.created,
> > > >> > storage_pool.update_time, storage_pool.data_center_id,
> > > >> storage_pool.pod_id,
> > > >> > storage_pool.used_bytes, storage_pool.capacity_bytes,
> > > >> storage_pool.status,
> > > >> > storage_pool.storage_provider_name, storage_pool.host_address,
> > > >> > storage_pool.path, storage_pool.port, storage_pool.user_info,
> > > >> > storage_pool.cluster_id, storage_pool.scope, storage_pool.managed,
> > > >> > storage_pool.capacity_iops, storage_pool.h

Re: Failed to add data store: DB Exception on: com.mysql.jdbc.JDBC42PreparedStatement

[Rafael Weingärtner]

So, you are getting the error while adding the storage in ACS. Right?
I copied and pasted the SQL you have your logs, and I got this:
Error: Column 'host_address' cannot be null
SQLState:  23000


This is the SQL I executed, which is in one of your emails:

> INSERT INTO storage_pool
> (storage_pool.id,storage_pool.name
> ,storage_pool.uuid
> ,storage_pool.pool_type,storage_pool.created
> ,storage_pool.update_time,storage_pool.data_center_id,storage_pool.pod_id,storage_pool.used_bytes,storage_pool.capacity_bytes,storage_pool.status,storage_pool.storage_provider_name,storage_pool.host_address,storage_pool.path
> ,storage_pool.port,storage_pool.user_info,storage_pool.cluster_id,storage_pool.scope,storage_pool.managed,storage_pool.capacity_iops,storage_pool.hypervisor)
> VALUES
> (0
> ,_binary'PrimaryStorage1',_binary'9c279e74-15a5-3c8a-b0d1-14349b59710a','RBD'
> ,'2018-03-12 14:55:18',null,1
> ,1  ,0  ,0
> ,'Initialized'  ,_binary'DefaultPrimary'
> ,null ,_binary'6A==@10.10.13.141/rbd',6789
> ,null  ,1  ,null
> ,0   ,null  ,null   )
>

Are you using the API or UI to register this storage?


On Mon, Mar 12, 2018 at 4:47 PM, McClune, James <
mcclu...@norwalktruckers.net> wrote:

> I started fresh with 4.11.0. The Ceph storage was already setup, however,
> I'm just now adding it to ACS.
>
> I get this error anytime I add primary storage. Secondary storage can be
> added with no problems.
>
> - James
>
> On Mon, Mar 12, 2018 at 3:39 PM, Rafael Weingärtner <
> rafaelweingart...@gmail.com> wrote:
>
> > When are you receiving this error? I mean, are you receiving it when you
> > add the storage? Or, when you do something else? Was the storage already
> > confgured?
> >
> >
> > On Mon, Mar 12, 2018 at 4:35 PM, McClune, James <
> > mcclu...@norwalktruckers.net> wrote:
> >
> > > I'm using Oracle MySQL.
> > >
> > > - James
> > >
> > > On Mon, Mar 12, 2018 at 3:33 PM, Rafael Weingärtner <
> > > rafaelweingart...@gmail.com> wrote:
> > >
> > > > Well, you can delete the entry you just inserted. the idea to run the
> > SQL
> > > > was to find the problem.
> > > > It is odd, I was expecting to be a missing column problem. What is
> the
> > DB
> > > > that you are using? MariaDB or Oracle MySQL?
> > > >
> > > > On Mon, Mar 12, 2018 at 4:29 PM, McClune, James <
> > > > mcclu...@norwalktruckers.net> wrote:
> > > >
> > > > > Hi Rafael,
> > > > >
> > > > > I ran the SQL query and got these errors:
> > > > >
> > > > >
> > > > > When I deleted the *_binary* and *storage_pool.* from the query
> > > entries,
> > > > > it seemed to work. However, I'm still experiencing oddities:
> > > > >
> > > > >
> > > > > Some of my entries were 'null', when they shouldn't be.
> > > > >
> > > > > Any help is much appreciated.
> > > > >
> > > > > Thanks,
> > > > > James
> > > > >
> > > > > On Mon, Mar 12, 2018 at 3:06 PM, Rafael Weingärtner <
> > > > > rafaelweingart...@gmail.com> wrote:
> > > > >
> > > > >> Did you try running the insert that is causing the error manually?
> > > > >>
> > > > >> On Mon, Mar 12, 2018 at 4:04 PM, McClune, James <
> > > > >> mcclu...@norwalktruckers.net> wrote:
> > > > >>
> > > > >> > Hello CloudStack Community,
> > > > >> >
> > > > >> > I just upgraded ACS from 4.9.3 to 4.11.0. I'm revamping my
> primary
> > > > >> storage
> > > > >> > (Ceph RBD). The problem I'm experiencing is every time I try to
> > > re-add
> > > > >> my
> > > > >> > Ceph storage pool, I get this error:
> > > > >> >
> > > > >> >
> > > > >> >- Something went wrong; please correct the following:
> > > > >> >Failed to add data store: DB Exception on:
> > > > >> >com.mysql.jdbc.JDBC42PreparedStatement@71996b4a: INSERT INTO
> > > > >> >storage_pool (storage_pool.id, storage_pool.name,
> > > > storage_pool.uuid,
> > > > >> >storage_pool.pool_type, storage_pool.created,
> > > > >> storage_pool.update_time,
> > > > >> >storage_pool.data_center_id, storage_pool.pod_id,
> > > > >> > storage_pool.used_bytes,
> > > > >> >storage_pool.capacity_bytes, storage_pool.status,
> > > > >> >storage_pool.storage_provider_name,
> storage_pool.host_address,
> > > > >> >storage_pool.path, storage_pool.port, storage_pool.user_info,
> > > > >> >storage_pool.cluster_id, storage_pool.scope,
> > > storage_pool.managed,
> > > > >> >storage_pool.capacity_iops, storage_pool.hypervisor) VALUES
> (0,
> > > > >> >_binary'PrimaryStorage1', _binary'9c279e74-15a5-3c8a-
> > > > >> > b0d1-14349b59710a',
> > > > >> >'RBD', '2018-03-12 14:55:18', null, 1, 1, 0, 0,
> 'Initialized',
> > > > >> >_binary'DefaultPrimary', null, _binary'6A==@10.10.13.141/rbd
> ',
> > > > 6789,
> > > > >> >null, 1, null, 0, null, null)
> > > > >> >
> > > > >> > Here is the error from the management-server.log file:
> > > > >> >
> > > > >> > 2018-03-12 11:01:32,786 DEBUG [c.c.u.d.T.Transac

Re: Failed to add data store: DB Exception on: com.mysql.jdbc.JDBC42PreparedStatement

[McClune, James]

I started fresh with 4.11.0. The Ceph storage was already setup, however,
I'm just now adding it to ACS.

I get this error anytime I add primary storage. Secondary storage can be
added with no problems.

- James

On Mon, Mar 12, 2018 at 3:39 PM, Rafael Weingärtner <
rafaelweingart...@gmail.com> wrote:

> When are you receiving this error? I mean, are you receiving it when you
> add the storage? Or, when you do something else? Was the storage already
> confgured?
>
>
> On Mon, Mar 12, 2018 at 4:35 PM, McClune, James <
> mcclu...@norwalktruckers.net> wrote:
>
> > I'm using Oracle MySQL.
> >
> > - James
> >
> > On Mon, Mar 12, 2018 at 3:33 PM, Rafael Weingärtner <
> > rafaelweingart...@gmail.com> wrote:
> >
> > > Well, you can delete the entry you just inserted. the idea to run the
> SQL
> > > was to find the problem.
> > > It is odd, I was expecting to be a missing column problem. What is the
> DB
> > > that you are using? MariaDB or Oracle MySQL?
> > >
> > > On Mon, Mar 12, 2018 at 4:29 PM, McClune, James <
> > > mcclu...@norwalktruckers.net> wrote:
> > >
> > > > Hi Rafael,
> > > >
> > > > I ran the SQL query and got these errors:
> > > >
> > > >
> > > > When I deleted the *_binary* and *storage_pool.* from the query
> > entries,
> > > > it seemed to work. However, I'm still experiencing oddities:
> > > >
> > > >
> > > > Some of my entries were 'null', when they shouldn't be.
> > > >
> > > > Any help is much appreciated.
> > > >
> > > > Thanks,
> > > > James
> > > >
> > > > On Mon, Mar 12, 2018 at 3:06 PM, Rafael Weingärtner <
> > > > rafaelweingart...@gmail.com> wrote:
> > > >
> > > >> Did you try running the insert that is causing the error manually?
> > > >>
> > > >> On Mon, Mar 12, 2018 at 4:04 PM, McClune, James <
> > > >> mcclu...@norwalktruckers.net> wrote:
> > > >>
> > > >> > Hello CloudStack Community,
> > > >> >
> > > >> > I just upgraded ACS from 4.9.3 to 4.11.0. I'm revamping my primary
> > > >> storage
> > > >> > (Ceph RBD). The problem I'm experiencing is every time I try to
> > re-add
> > > >> my
> > > >> > Ceph storage pool, I get this error:
> > > >> >
> > > >> >
> > > >> >- Something went wrong; please correct the following:
> > > >> >Failed to add data store: DB Exception on:
> > > >> >com.mysql.jdbc.JDBC42PreparedStatement@71996b4a: INSERT INTO
> > > >> >storage_pool (storage_pool.id, storage_pool.name,
> > > storage_pool.uuid,
> > > >> >storage_pool.pool_type, storage_pool.created,
> > > >> storage_pool.update_time,
> > > >> >storage_pool.data_center_id, storage_pool.pod_id,
> > > >> > storage_pool.used_bytes,
> > > >> >storage_pool.capacity_bytes, storage_pool.status,
> > > >> >storage_pool.storage_provider_name, storage_pool.host_address,
> > > >> >storage_pool.path, storage_pool.port, storage_pool.user_info,
> > > >> >storage_pool.cluster_id, storage_pool.scope,
> > storage_pool.managed,
> > > >> >storage_pool.capacity_iops, storage_pool.hypervisor) VALUES (0,
> > > >> >_binary'PrimaryStorage1', _binary'9c279e74-15a5-3c8a-
> > > >> > b0d1-14349b59710a',
> > > >> >'RBD', '2018-03-12 14:55:18', null, 1, 1, 0, 0, 'Initialized',
> > > >> >_binary'DefaultPrimary', null, _binary'6A==@10.10.13.141/rbd',
> > > 6789,
> > > >> >null, 1, null, 0, null, null)
> > > >> >
> > > >> > Here is the error from the management-server.log file:
> > > >> >
> > > >> > 2018-03-12 11:01:32,786 DEBUG [c.c.u.d.T.Transaction]
> > > >> > (qtp66233253-19:ctx-04c43d3a ctx-329be767) (logid:c19a8879)
> Rolling
> > > back
> > > >> > the transaction: Time = 1 Name =  qtp66233253-19; called by
> > > >> > -TransactionLegacy.rollback:889-TransactionLegacy.removeUpTo:832-
> > > >> > TransactionLegacy.close:656-TransactionContextInterceptor.
> > invoke:36-
> > > >> > ReflectiveMethodInvocation.proceed:174-
> ExposeInvocationInterceptor.
> > > >> > invoke:92-ReflectiveMethodInvocation.proceed:185-
> > > >> > JdkDynamicAopProxy.invoke:212-$Proxy91.persist:-1-PrimaryDat
> > > >> aStoreHelper.
> > > >> > createPrimaryDataStore:135-CloudStackPrimaryDataStoreLife
> > > >> > CycleImpl.initialize:353-StorageManagerImpl.createPool:710
> > > >> > 2018-03-12 11:01:32,788 DEBUG [c.c.s.StorageManagerImpl]
> > > >> > (qtp66233253-19:ctx-04c43d3a ctx-329be767) (logid:c19a8879) Failed
> > to
> > > >> add
> > > >> > data store: DB Exception on: com.mysql.jdbc.
> > JDBC42PreparedStatement@
> > > >> > 4901e335:
> > > >> > INSERT INTO storage_pool (storage_pool.id, storage_pool.name,
> > > >> > storage_pool.uuid, storage_pool.pool_type, storage_pool.created,
> > > >> > storage_pool.update_time, storage_pool.data_center_id,
> > > >> storage_pool.pod_id,
> > > >> > storage_pool.used_bytes, storage_pool.capacity_bytes,
> > > >> storage_pool.status,
> > > >> > storage_pool.storage_provider_name, storage_pool.host_address,
> > > >> > storage_pool.path, storage_pool.port, storage_pool.user_info,
> > > >> > storage_pool.cluster_id, storage_pool.scope, storage_pool.managed,
> > > >> > storage

Re: Failed to add data store: DB Exception on: com.mysql.jdbc.JDBC42PreparedStatement

[Rafael Weingärtner]

When are you receiving this error? I mean, are you receiving it when you
add the storage? Or, when you do something else? Was the storage already
confgured?


On Mon, Mar 12, 2018 at 4:35 PM, McClune, James <
mcclu...@norwalktruckers.net> wrote:

> I'm using Oracle MySQL.
>
> - James
>
> On Mon, Mar 12, 2018 at 3:33 PM, Rafael Weingärtner <
> rafaelweingart...@gmail.com> wrote:
>
> > Well, you can delete the entry you just inserted. the idea to run the SQL
> > was to find the problem.
> > It is odd, I was expecting to be a missing column problem. What is the DB
> > that you are using? MariaDB or Oracle MySQL?
> >
> > On Mon, Mar 12, 2018 at 4:29 PM, McClune, James <
> > mcclu...@norwalktruckers.net> wrote:
> >
> > > Hi Rafael,
> > >
> > > I ran the SQL query and got these errors:
> > >
> > >
> > > When I deleted the *_binary* and *storage_pool.* from the query
> entries,
> > > it seemed to work. However, I'm still experiencing oddities:
> > >
> > >
> > > Some of my entries were 'null', when they shouldn't be.
> > >
> > > Any help is much appreciated.
> > >
> > > Thanks,
> > > James
> > >
> > > On Mon, Mar 12, 2018 at 3:06 PM, Rafael Weingärtner <
> > > rafaelweingart...@gmail.com> wrote:
> > >
> > >> Did you try running the insert that is causing the error manually?
> > >>
> > >> On Mon, Mar 12, 2018 at 4:04 PM, McClune, James <
> > >> mcclu...@norwalktruckers.net> wrote:
> > >>
> > >> > Hello CloudStack Community,
> > >> >
> > >> > I just upgraded ACS from 4.9.3 to 4.11.0. I'm revamping my primary
> > >> storage
> > >> > (Ceph RBD). The problem I'm experiencing is every time I try to
> re-add
> > >> my
> > >> > Ceph storage pool, I get this error:
> > >> >
> > >> >
> > >> >- Something went wrong; please correct the following:
> > >> >Failed to add data store: DB Exception on:
> > >> >com.mysql.jdbc.JDBC42PreparedStatement@71996b4a: INSERT INTO
> > >> >storage_pool (storage_pool.id, storage_pool.name,
> > storage_pool.uuid,
> > >> >storage_pool.pool_type, storage_pool.created,
> > >> storage_pool.update_time,
> > >> >storage_pool.data_center_id, storage_pool.pod_id,
> > >> > storage_pool.used_bytes,
> > >> >storage_pool.capacity_bytes, storage_pool.status,
> > >> >storage_pool.storage_provider_name, storage_pool.host_address,
> > >> >storage_pool.path, storage_pool.port, storage_pool.user_info,
> > >> >storage_pool.cluster_id, storage_pool.scope,
> storage_pool.managed,
> > >> >storage_pool.capacity_iops, storage_pool.hypervisor) VALUES (0,
> > >> >_binary'PrimaryStorage1', _binary'9c279e74-15a5-3c8a-
> > >> > b0d1-14349b59710a',
> > >> >'RBD', '2018-03-12 14:55:18', null, 1, 1, 0, 0, 'Initialized',
> > >> >_binary'DefaultPrimary', null, _binary'6A==@10.10.13.141/rbd',
> > 6789,
> > >> >null, 1, null, 0, null, null)
> > >> >
> > >> > Here is the error from the management-server.log file:
> > >> >
> > >> > 2018-03-12 11:01:32,786 DEBUG [c.c.u.d.T.Transaction]
> > >> > (qtp66233253-19:ctx-04c43d3a ctx-329be767) (logid:c19a8879) Rolling
> > back
> > >> > the transaction: Time = 1 Name =  qtp66233253-19; called by
> > >> > -TransactionLegacy.rollback:889-TransactionLegacy.removeUpTo:832-
> > >> > TransactionLegacy.close:656-TransactionContextInterceptor.
> invoke:36-
> > >> > ReflectiveMethodInvocation.proceed:174-ExposeInvocationInterceptor.
> > >> > invoke:92-ReflectiveMethodInvocation.proceed:185-
> > >> > JdkDynamicAopProxy.invoke:212-$Proxy91.persist:-1-PrimaryDat
> > >> aStoreHelper.
> > >> > createPrimaryDataStore:135-CloudStackPrimaryDataStoreLife
> > >> > CycleImpl.initialize:353-StorageManagerImpl.createPool:710
> > >> > 2018-03-12 11:01:32,788 DEBUG [c.c.s.StorageManagerImpl]
> > >> > (qtp66233253-19:ctx-04c43d3a ctx-329be767) (logid:c19a8879) Failed
> to
> > >> add
> > >> > data store: DB Exception on: com.mysql.jdbc.
> JDBC42PreparedStatement@
> > >> > 4901e335:
> > >> > INSERT INTO storage_pool (storage_pool.id, storage_pool.name,
> > >> > storage_pool.uuid, storage_pool.pool_type, storage_pool.created,
> > >> > storage_pool.update_time, storage_pool.data_center_id,
> > >> storage_pool.pod_id,
> > >> > storage_pool.used_bytes, storage_pool.capacity_bytes,
> > >> storage_pool.status,
> > >> > storage_pool.storage_provider_name, storage_pool.host_address,
> > >> > storage_pool.path, storage_pool.port, storage_pool.user_info,
> > >> > storage_pool.cluster_id, storage_pool.scope, storage_pool.managed,
> > >> > storage_pool.capacity_iops, storage_pool.hypervisor) VALUES (0,
> > >> > _binary'PrimaryStorage1', _binary'9c279e74-15a5-3c8a-b0d
> > >> 1-14349b59710a',
> > >> > 'RBD', '2018-03-12 15:01:32', null, 1, 1, 0, 0, 'Initialized',
> > >> > _binary'DefaultPrimary', null, _binary'6A==@10.10.13.141/rbd',
> 6789,
> > >> null,
> > >> > 1, null, 0, null, null)
> > >> > com.cloud.utils.exception.CloudRuntimeException: DB Exception on:
> > >> > com.mysql.jdbc.JDBC42PreparedStatement@4901e335: INSERT INTO
> > >> storage_pool
> > >> > (
> > >> > stor

Re: Failed to add data store: DB Exception on: com.mysql.jdbc.JDBC42PreparedStatement

[McClune, James]

I'm using Oracle MySQL.

- James

On Mon, Mar 12, 2018 at 3:33 PM, Rafael Weingärtner <
rafaelweingart...@gmail.com> wrote:

> Well, you can delete the entry you just inserted. the idea to run the SQL
> was to find the problem.
> It is odd, I was expecting to be a missing column problem. What is the DB
> that you are using? MariaDB or Oracle MySQL?
>
> On Mon, Mar 12, 2018 at 4:29 PM, McClune, James <
> mcclu...@norwalktruckers.net> wrote:
>
> > Hi Rafael,
> >
> > I ran the SQL query and got these errors:
> >
> >
> > When I deleted the *_binary* and *storage_pool.* from the query entries,
> > it seemed to work. However, I'm still experiencing oddities:
> >
> >
> > Some of my entries were 'null', when they shouldn't be.
> >
> > Any help is much appreciated.
> >
> > Thanks,
> > James
> >
> > On Mon, Mar 12, 2018 at 3:06 PM, Rafael Weingärtner <
> > rafaelweingart...@gmail.com> wrote:
> >
> >> Did you try running the insert that is causing the error manually?
> >>
> >> On Mon, Mar 12, 2018 at 4:04 PM, McClune, James <
> >> mcclu...@norwalktruckers.net> wrote:
> >>
> >> > Hello CloudStack Community,
> >> >
> >> > I just upgraded ACS from 4.9.3 to 4.11.0. I'm revamping my primary
> >> storage
> >> > (Ceph RBD). The problem I'm experiencing is every time I try to re-add
> >> my
> >> > Ceph storage pool, I get this error:
> >> >
> >> >
> >> >- Something went wrong; please correct the following:
> >> >Failed to add data store: DB Exception on:
> >> >com.mysql.jdbc.JDBC42PreparedStatement@71996b4a: INSERT INTO
> >> >storage_pool (storage_pool.id, storage_pool.name,
> storage_pool.uuid,
> >> >storage_pool.pool_type, storage_pool.created,
> >> storage_pool.update_time,
> >> >storage_pool.data_center_id, storage_pool.pod_id,
> >> > storage_pool.used_bytes,
> >> >storage_pool.capacity_bytes, storage_pool.status,
> >> >storage_pool.storage_provider_name, storage_pool.host_address,
> >> >storage_pool.path, storage_pool.port, storage_pool.user_info,
> >> >storage_pool.cluster_id, storage_pool.scope, storage_pool.managed,
> >> >storage_pool.capacity_iops, storage_pool.hypervisor) VALUES (0,
> >> >_binary'PrimaryStorage1', _binary'9c279e74-15a5-3c8a-
> >> > b0d1-14349b59710a',
> >> >'RBD', '2018-03-12 14:55:18', null, 1, 1, 0, 0, 'Initialized',
> >> >_binary'DefaultPrimary', null, _binary'6A==@10.10.13.141/rbd',
> 6789,
> >> >null, 1, null, 0, null, null)
> >> >
> >> > Here is the error from the management-server.log file:
> >> >
> >> > 2018-03-12 11:01:32,786 DEBUG [c.c.u.d.T.Transaction]
> >> > (qtp66233253-19:ctx-04c43d3a ctx-329be767) (logid:c19a8879) Rolling
> back
> >> > the transaction: Time = 1 Name =  qtp66233253-19; called by
> >> > -TransactionLegacy.rollback:889-TransactionLegacy.removeUpTo:832-
> >> > TransactionLegacy.close:656-TransactionContextInterceptor.invoke:36-
> >> > ReflectiveMethodInvocation.proceed:174-ExposeInvocationInterceptor.
> >> > invoke:92-ReflectiveMethodInvocation.proceed:185-
> >> > JdkDynamicAopProxy.invoke:212-$Proxy91.persist:-1-PrimaryDat
> >> aStoreHelper.
> >> > createPrimaryDataStore:135-CloudStackPrimaryDataStoreLife
> >> > CycleImpl.initialize:353-StorageManagerImpl.createPool:710
> >> > 2018-03-12 11:01:32,788 DEBUG [c.c.s.StorageManagerImpl]
> >> > (qtp66233253-19:ctx-04c43d3a ctx-329be767) (logid:c19a8879) Failed to
> >> add
> >> > data store: DB Exception on: com.mysql.jdbc.JDBC42PreparedStatement@
> >> > 4901e335:
> >> > INSERT INTO storage_pool (storage_pool.id, storage_pool.name,
> >> > storage_pool.uuid, storage_pool.pool_type, storage_pool.created,
> >> > storage_pool.update_time, storage_pool.data_center_id,
> >> storage_pool.pod_id,
> >> > storage_pool.used_bytes, storage_pool.capacity_bytes,
> >> storage_pool.status,
> >> > storage_pool.storage_provider_name, storage_pool.host_address,
> >> > storage_pool.path, storage_pool.port, storage_pool.user_info,
> >> > storage_pool.cluster_id, storage_pool.scope, storage_pool.managed,
> >> > storage_pool.capacity_iops, storage_pool.hypervisor) VALUES (0,
> >> > _binary'PrimaryStorage1', _binary'9c279e74-15a5-3c8a-b0d
> >> 1-14349b59710a',
> >> > 'RBD', '2018-03-12 15:01:32', null, 1, 1, 0, 0, 'Initialized',
> >> > _binary'DefaultPrimary', null, _binary'6A==@10.10.13.141/rbd', 6789,
> >> null,
> >> > 1, null, 0, null, null)
> >> > com.cloud.utils.exception.CloudRuntimeException: DB Exception on:
> >> > com.mysql.jdbc.JDBC42PreparedStatement@4901e335: INSERT INTO
> >> storage_pool
> >> > (
> >> > storage_pool.id, storage_pool.name, storage_pool.uuid,
> >> > storage_pool.pool_type, storage_pool.created,
> storage_pool.update_time,
> >> > storage_pool.data_center_id, storage_pool.pod_id,
> >> storage_pool.used_bytes,
> >> > storage_pool.capacity_bytes, storage_pool.status,
> >> > storage_pool.storage_provider_name, storage_pool.host_address,
> >> > storage_pool.path, storage_pool.port, storage_pool.user_info,
> >> > storage_pool.cluster_id, storage_pool.scope, storage_poo

Re: Failed to add data store: DB Exception on: com.mysql.jdbc.JDBC42PreparedStatement

[Rafael Weingärtner]

Well, you can delete the entry you just inserted. the idea to run the SQL
was to find the problem.
It is odd, I was expecting to be a missing column problem. What is the DB
that you are using? MariaDB or Oracle MySQL?

On Mon, Mar 12, 2018 at 4:29 PM, McClune, James <
mcclu...@norwalktruckers.net> wrote:

> Hi Rafael,
>
> I ran the SQL query and got these errors:
>
>
> When I deleted the *_binary* and *storage_pool.* from the query entries,
> it seemed to work. However, I'm still experiencing oddities:
>
>
> Some of my entries were 'null', when they shouldn't be.
>
> Any help is much appreciated.
>
> Thanks,
> James
>
> On Mon, Mar 12, 2018 at 3:06 PM, Rafael Weingärtner <
> rafaelweingart...@gmail.com> wrote:
>
>> Did you try running the insert that is causing the error manually?
>>
>> On Mon, Mar 12, 2018 at 4:04 PM, McClune, James <
>> mcclu...@norwalktruckers.net> wrote:
>>
>> > Hello CloudStack Community,
>> >
>> > I just upgraded ACS from 4.9.3 to 4.11.0. I'm revamping my primary
>> storage
>> > (Ceph RBD). The problem I'm experiencing is every time I try to re-add
>> my
>> > Ceph storage pool, I get this error:
>> >
>> >
>> >- Something went wrong; please correct the following:
>> >Failed to add data store: DB Exception on:
>> >com.mysql.jdbc.JDBC42PreparedStatement@71996b4a: INSERT INTO
>> >storage_pool (storage_pool.id, storage_pool.name, storage_pool.uuid,
>> >storage_pool.pool_type, storage_pool.created,
>> storage_pool.update_time,
>> >storage_pool.data_center_id, storage_pool.pod_id,
>> > storage_pool.used_bytes,
>> >storage_pool.capacity_bytes, storage_pool.status,
>> >storage_pool.storage_provider_name, storage_pool.host_address,
>> >storage_pool.path, storage_pool.port, storage_pool.user_info,
>> >storage_pool.cluster_id, storage_pool.scope, storage_pool.managed,
>> >storage_pool.capacity_iops, storage_pool.hypervisor) VALUES (0,
>> >_binary'PrimaryStorage1', _binary'9c279e74-15a5-3c8a-
>> > b0d1-14349b59710a',
>> >'RBD', '2018-03-12 14:55:18', null, 1, 1, 0, 0, 'Initialized',
>> >_binary'DefaultPrimary', null, _binary'6A==@10.10.13.141/rbd', 6789,
>> >null, 1, null, 0, null, null)
>> >
>> > Here is the error from the management-server.log file:
>> >
>> > 2018-03-12 11:01:32,786 DEBUG [c.c.u.d.T.Transaction]
>> > (qtp66233253-19:ctx-04c43d3a ctx-329be767) (logid:c19a8879) Rolling back
>> > the transaction: Time = 1 Name =  qtp66233253-19; called by
>> > -TransactionLegacy.rollback:889-TransactionLegacy.removeUpTo:832-
>> > TransactionLegacy.close:656-TransactionContextInterceptor.invoke:36-
>> > ReflectiveMethodInvocation.proceed:174-ExposeInvocationInterceptor.
>> > invoke:92-ReflectiveMethodInvocation.proceed:185-
>> > JdkDynamicAopProxy.invoke:212-$Proxy91.persist:-1-PrimaryDat
>> aStoreHelper.
>> > createPrimaryDataStore:135-CloudStackPrimaryDataStoreLife
>> > CycleImpl.initialize:353-StorageManagerImpl.createPool:710
>> > 2018-03-12 11:01:32,788 DEBUG [c.c.s.StorageManagerImpl]
>> > (qtp66233253-19:ctx-04c43d3a ctx-329be767) (logid:c19a8879) Failed to
>> add
>> > data store: DB Exception on: com.mysql.jdbc.JDBC42PreparedStatement@
>> > 4901e335:
>> > INSERT INTO storage_pool (storage_pool.id, storage_pool.name,
>> > storage_pool.uuid, storage_pool.pool_type, storage_pool.created,
>> > storage_pool.update_time, storage_pool.data_center_id,
>> storage_pool.pod_id,
>> > storage_pool.used_bytes, storage_pool.capacity_bytes,
>> storage_pool.status,
>> > storage_pool.storage_provider_name, storage_pool.host_address,
>> > storage_pool.path, storage_pool.port, storage_pool.user_info,
>> > storage_pool.cluster_id, storage_pool.scope, storage_pool.managed,
>> > storage_pool.capacity_iops, storage_pool.hypervisor) VALUES (0,
>> > _binary'PrimaryStorage1', _binary'9c279e74-15a5-3c8a-b0d
>> 1-14349b59710a',
>> > 'RBD', '2018-03-12 15:01:32', null, 1, 1, 0, 0, 'Initialized',
>> > _binary'DefaultPrimary', null, _binary'6A==@10.10.13.141/rbd', 6789,
>> null,
>> > 1, null, 0, null, null)
>> > com.cloud.utils.exception.CloudRuntimeException: DB Exception on:
>> > com.mysql.jdbc.JDBC42PreparedStatement@4901e335: INSERT INTO
>> storage_pool
>> > (
>> > storage_pool.id, storage_pool.name, storage_pool.uuid,
>> > storage_pool.pool_type, storage_pool.created, storage_pool.update_time,
>> > storage_pool.data_center_id, storage_pool.pod_id,
>> storage_pool.used_bytes,
>> > storage_pool.capacity_bytes, storage_pool.status,
>> > storage_pool.storage_provider_name, storage_pool.host_address,
>> > storage_pool.path, storage_pool.port, storage_pool.user_info,
>> > storage_pool.cluster_id, storage_pool.scope, storage_pool.managed,
>> > storage_pool.capacity_iops, storage_pool.hypervisor) VALUES (0,
>> > _binary'PrimaryStorage1', _binary'9c279e74-15a5-3c8a-b0d
>> 1-14349b59710a',
>> > 'RBD', '2018-03-12 15:01:32', null, 1, 1, 0, 0, 'Initialized',
>> > _binary'DefaultPrimary', null, _binary'6A==@10.10.13.141/rbd', 6789,
>> null,
>> > 1, null, 0, null, null)
>

Re: Failed to add data store: DB Exception on: com.mysql.jdbc.JDBC42PreparedStatement

[McClune, James]

Hi Rafael,

I ran the SQL query and got these errors:


When I deleted the *_binary* and *storage_pool.* from the query entries, it
seemed to work. However, I'm still experiencing oddities:


Some of my entries were 'null', when they shouldn't be.

Any help is much appreciated.

Thanks,
James

On Mon, Mar 12, 2018 at 3:06 PM, Rafael Weingärtner <
rafaelweingart...@gmail.com> wrote:

> Did you try running the insert that is causing the error manually?
>
> On Mon, Mar 12, 2018 at 4:04 PM, McClune, James <
> mcclu...@norwalktruckers.net> wrote:
>
> > Hello CloudStack Community,
> >
> > I just upgraded ACS from 4.9.3 to 4.11.0. I'm revamping my primary
> storage
> > (Ceph RBD). The problem I'm experiencing is every time I try to re-add my
> > Ceph storage pool, I get this error:
> >
> >
> >- Something went wrong; please correct the following:
> >Failed to add data store: DB Exception on:
> >com.mysql.jdbc.JDBC42PreparedStatement@71996b4a: INSERT INTO
> >storage_pool (storage_pool.id, storage_pool.name, storage_pool.uuid,
> >storage_pool.pool_type, storage_pool.created,
> storage_pool.update_time,
> >storage_pool.data_center_id, storage_pool.pod_id,
> > storage_pool.used_bytes,
> >storage_pool.capacity_bytes, storage_pool.status,
> >storage_pool.storage_provider_name, storage_pool.host_address,
> >storage_pool.path, storage_pool.port, storage_pool.user_info,
> >storage_pool.cluster_id, storage_pool.scope, storage_pool.managed,
> >storage_pool.capacity_iops, storage_pool.hypervisor) VALUES (0,
> >_binary'PrimaryStorage1', _binary'9c279e74-15a5-3c8a-
> > b0d1-14349b59710a',
> >'RBD', '2018-03-12 14:55:18', null, 1, 1, 0, 0, 'Initialized',
> >_binary'DefaultPrimary', null, _binary'6A==@10.10.13.141/rbd', 6789,
> >null, 1, null, 0, null, null)
> >
> > Here is the error from the management-server.log file:
> >
> > 2018-03-12 11:01:32,786 DEBUG [c.c.u.d.T.Transaction]
> > (qtp66233253-19:ctx-04c43d3a ctx-329be767) (logid:c19a8879) Rolling back
> > the transaction: Time = 1 Name =  qtp66233253-19; called by
> > -TransactionLegacy.rollback:889-TransactionLegacy.removeUpTo:832-
> > TransactionLegacy.close:656-TransactionContextInterceptor.invoke:36-
> > ReflectiveMethodInvocation.proceed:174-ExposeInvocationInterceptor.
> > invoke:92-ReflectiveMethodInvocation.proceed:185-
> > JdkDynamicAopProxy.invoke:212-$Proxy91.persist:-1-
> PrimaryDataStoreHelper.
> > createPrimaryDataStore:135-CloudStackPrimaryDataStoreLife
> > CycleImpl.initialize:353-StorageManagerImpl.createPool:710
> > 2018-03-12 11:01:32,788 DEBUG [c.c.s.StorageManagerImpl]
> > (qtp66233253-19:ctx-04c43d3a ctx-329be767) (logid:c19a8879) Failed to add
> > data store: DB Exception on: com.mysql.jdbc.JDBC42PreparedStatement@
> > 4901e335:
> > INSERT INTO storage_pool (storage_pool.id, storage_pool.name,
> > storage_pool.uuid, storage_pool.pool_type, storage_pool.created,
> > storage_pool.update_time, storage_pool.data_center_id,
> storage_pool.pod_id,
> > storage_pool.used_bytes, storage_pool.capacity_bytes,
> storage_pool.status,
> > storage_pool.storage_provider_name, storage_pool.host_address,
> > storage_pool.path, storage_pool.port, storage_pool.user_info,
> > storage_pool.cluster_id, storage_pool.scope, storage_pool.managed,
> > storage_pool.capacity_iops, storage_pool.hypervisor) VALUES (0,
> > _binary'PrimaryStorage1', _binary'9c279e74-15a5-3c8a-b0d1-14349b59710a',
> > 'RBD', '2018-03-12 15:01:32', null, 1, 1, 0, 0, 'Initialized',
> > _binary'DefaultPrimary', null, _binary'6A==@10.10.13.141/rbd', 6789,
> null,
> > 1, null, 0, null, null)
> > com.cloud.utils.exception.CloudRuntimeException: DB Exception on:
> > com.mysql.jdbc.JDBC42PreparedStatement@4901e335: INSERT INTO
> storage_pool
> > (
> > storage_pool.id, storage_pool.name, storage_pool.uuid,
> > storage_pool.pool_type, storage_pool.created, storage_pool.update_time,
> > storage_pool.data_center_id, storage_pool.pod_id,
> storage_pool.used_bytes,
> > storage_pool.capacity_bytes, storage_pool.status,
> > storage_pool.storage_provider_name, storage_pool.host_address,
> > storage_pool.path, storage_pool.port, storage_pool.user_info,
> > storage_pool.cluster_id, storage_pool.scope, storage_pool.managed,
> > storage_pool.capacity_iops, storage_pool.hypervisor) VALUES (0,
> > _binary'PrimaryStorage1', _binary'9c279e74-15a5-3c8a-b0d1-14349b59710a',
> > 'RBD', '2018-03-12 15:01:32', null, 1, 1, 0, 0, 'Initialized',
> > _binary'DefaultPrimary', null, _binary'6A==@10.10.13.141/rbd', 6789,
> null,
> > 1, null, 0, null, null)
> > at com.cloud.utils.db.GenericDaoBase.persist(GenericDaoBase.java:1436)
> > at
> > org.apache.cloudstack.storage.datastore.db.PrimaryDataStoreDaoImpl.
> > persist(PrimaryDataStoreDaoImpl.java:274)
> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > at
> > sun.reflect.NativeMethodAccessorImpl.invoke(
> NativeMethodAccessorImpl.java:
> > 62)
> > at
> > sun.reflect.DelegatingMethodAccessorImpl.invoke(
> > Deleg

Re: Failed to add data store: DB Exception on: com.mysql.jdbc.JDBC42PreparedStatement

[McClune, James]

No, I'll try that right now.

Thanks for the prompt reply Rafael.

- James

On Mon, Mar 12, 2018 at 3:06 PM, Rafael Weingärtner <
rafaelweingart...@gmail.com> wrote:

> Did you try running the insert that is causing the error manually?
>
> On Mon, Mar 12, 2018 at 4:04 PM, McClune, James <
> mcclu...@norwalktruckers.net> wrote:
>
> > Hello CloudStack Community,
> >
> > I just upgraded ACS from 4.9.3 to 4.11.0. I'm revamping my primary
> storage
> > (Ceph RBD). The problem I'm experiencing is every time I try to re-add my
> > Ceph storage pool, I get this error:
> >
> >
> >- Something went wrong; please correct the following:
> >Failed to add data store: DB Exception on:
> >com.mysql.jdbc.JDBC42PreparedStatement@71996b4a: INSERT INTO
> >storage_pool (storage_pool.id, storage_pool.name, storage_pool.uuid,
> >storage_pool.pool_type, storage_pool.created,
> storage_pool.update_time,
> >storage_pool.data_center_id, storage_pool.pod_id,
> > storage_pool.used_bytes,
> >storage_pool.capacity_bytes, storage_pool.status,
> >storage_pool.storage_provider_name, storage_pool.host_address,
> >storage_pool.path, storage_pool.port, storage_pool.user_info,
> >storage_pool.cluster_id, storage_pool.scope, storage_pool.managed,
> >storage_pool.capacity_iops, storage_pool.hypervisor) VALUES (0,
> >_binary'PrimaryStorage1', _binary'9c279e74-15a5-3c8a-
> > b0d1-14349b59710a',
> >'RBD', '2018-03-12 14:55:18', null, 1, 1, 0, 0, 'Initialized',
> >_binary'DefaultPrimary', null, _binary'6A==@10.10.13.141/rbd', 6789,
> >null, 1, null, 0, null, null)
> >
> > Here is the error from the management-server.log file:
> >
> > 2018-03-12 11:01:32,786 DEBUG [c.c.u.d.T.Transaction]
> > (qtp66233253-19:ctx-04c43d3a ctx-329be767) (logid:c19a8879) Rolling back
> > the transaction: Time = 1 Name =  qtp66233253-19; called by
> > -TransactionLegacy.rollback:889-TransactionLegacy.removeUpTo:832-
> > TransactionLegacy.close:656-TransactionContextInterceptor.invoke:36-
> > ReflectiveMethodInvocation.proceed:174-ExposeInvocationInterceptor.
> > invoke:92-ReflectiveMethodInvocation.proceed:185-
> > JdkDynamicAopProxy.invoke:212-$Proxy91.persist:-1-
> PrimaryDataStoreHelper.
> > createPrimaryDataStore:135-CloudStackPrimaryDataStoreLife
> > CycleImpl.initialize:353-StorageManagerImpl.createPool:710
> > 2018-03-12 11:01:32,788 DEBUG [c.c.s.StorageManagerImpl]
> > (qtp66233253-19:ctx-04c43d3a ctx-329be767) (logid:c19a8879) Failed to add
> > data store: DB Exception on: com.mysql.jdbc.JDBC42PreparedStatement@
> > 4901e335:
> > INSERT INTO storage_pool (storage_pool.id, storage_pool.name,
> > storage_pool.uuid, storage_pool.pool_type, storage_pool.created,
> > storage_pool.update_time, storage_pool.data_center_id,
> storage_pool.pod_id,
> > storage_pool.used_bytes, storage_pool.capacity_bytes,
> storage_pool.status,
> > storage_pool.storage_provider_name, storage_pool.host_address,
> > storage_pool.path, storage_pool.port, storage_pool.user_info,
> > storage_pool.cluster_id, storage_pool.scope, storage_pool.managed,
> > storage_pool.capacity_iops, storage_pool.hypervisor) VALUES (0,
> > _binary'PrimaryStorage1', _binary'9c279e74-15a5-3c8a-b0d1-14349b59710a',
> > 'RBD', '2018-03-12 15:01:32', null, 1, 1, 0, 0, 'Initialized',
> > _binary'DefaultPrimary', null, _binary'6A==@10.10.13.141/rbd', 6789,
> null,
> > 1, null, 0, null, null)
> > com.cloud.utils.exception.CloudRuntimeException: DB Exception on:
> > com.mysql.jdbc.JDBC42PreparedStatement@4901e335: INSERT INTO
> storage_pool
> > (
> > storage_pool.id, storage_pool.name, storage_pool.uuid,
> > storage_pool.pool_type, storage_pool.created, storage_pool.update_time,
> > storage_pool.data_center_id, storage_pool.pod_id,
> storage_pool.used_bytes,
> > storage_pool.capacity_bytes, storage_pool.status,
> > storage_pool.storage_provider_name, storage_pool.host_address,
> > storage_pool.path, storage_pool.port, storage_pool.user_info,
> > storage_pool.cluster_id, storage_pool.scope, storage_pool.managed,
> > storage_pool.capacity_iops, storage_pool.hypervisor) VALUES (0,
> > _binary'PrimaryStorage1', _binary'9c279e74-15a5-3c8a-b0d1-14349b59710a',
> > 'RBD', '2018-03-12 15:01:32', null, 1, 1, 0, 0, 'Initialized',
> > _binary'DefaultPrimary', null, _binary'6A==@10.10.13.141/rbd', 6789,
> null,
> > 1, null, 0, null, null)
> > at com.cloud.utils.db.GenericDaoBase.persist(GenericDaoBase.java:1436)
> > at
> > org.apache.cloudstack.storage.datastore.db.PrimaryDataStoreDaoImpl.
> > persist(PrimaryDataStoreDaoImpl.java:274)
> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > at
> > sun.reflect.NativeMethodAccessorImpl.invoke(
> NativeMethodAccessorImpl.java:
> > 62)
> > at
> > sun.reflect.DelegatingMethodAccessorImpl.invoke(
> > DelegatingMethodAccessorImpl.java:43)
> > at java.lang.reflect.Method.invoke(Method.java:498)
> > at
> > org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection
> > (AopUtils.java:338)
> > at
> > org.springfr

Re: Failed to add data store: DB Exception on: com.mysql.jdbc.JDBC42PreparedStatement

[Rafael Weingärtner]

Did you try running the insert that is causing the error manually?

On Mon, Mar 12, 2018 at 4:04 PM, McClune, James <
mcclu...@norwalktruckers.net> wrote:

> Hello CloudStack Community,
>
> I just upgraded ACS from 4.9.3 to 4.11.0. I'm revamping my primary storage
> (Ceph RBD). The problem I'm experiencing is every time I try to re-add my
> Ceph storage pool, I get this error:
>
>
>- Something went wrong; please correct the following:
>Failed to add data store: DB Exception on:
>com.mysql.jdbc.JDBC42PreparedStatement@71996b4a: INSERT INTO
>storage_pool (storage_pool.id, storage_pool.name, storage_pool.uuid,
>storage_pool.pool_type, storage_pool.created, storage_pool.update_time,
>storage_pool.data_center_id, storage_pool.pod_id,
> storage_pool.used_bytes,
>storage_pool.capacity_bytes, storage_pool.status,
>storage_pool.storage_provider_name, storage_pool.host_address,
>storage_pool.path, storage_pool.port, storage_pool.user_info,
>storage_pool.cluster_id, storage_pool.scope, storage_pool.managed,
>storage_pool.capacity_iops, storage_pool.hypervisor) VALUES (0,
>_binary'PrimaryStorage1', _binary'9c279e74-15a5-3c8a-
> b0d1-14349b59710a',
>'RBD', '2018-03-12 14:55:18', null, 1, 1, 0, 0, 'Initialized',
>_binary'DefaultPrimary', null, _binary'6A==@10.10.13.141/rbd', 6789,
>null, 1, null, 0, null, null)
>
> Here is the error from the management-server.log file:
>
> 2018-03-12 11:01:32,786 DEBUG [c.c.u.d.T.Transaction]
> (qtp66233253-19:ctx-04c43d3a ctx-329be767) (logid:c19a8879) Rolling back
> the transaction: Time = 1 Name =  qtp66233253-19; called by
> -TransactionLegacy.rollback:889-TransactionLegacy.removeUpTo:832-
> TransactionLegacy.close:656-TransactionContextInterceptor.invoke:36-
> ReflectiveMethodInvocation.proceed:174-ExposeInvocationInterceptor.
> invoke:92-ReflectiveMethodInvocation.proceed:185-
> JdkDynamicAopProxy.invoke:212-$Proxy91.persist:-1-PrimaryDataStoreHelper.
> createPrimaryDataStore:135-CloudStackPrimaryDataStoreLife
> CycleImpl.initialize:353-StorageManagerImpl.createPool:710
> 2018-03-12 11:01:32,788 DEBUG [c.c.s.StorageManagerImpl]
> (qtp66233253-19:ctx-04c43d3a ctx-329be767) (logid:c19a8879) Failed to add
> data store: DB Exception on: com.mysql.jdbc.JDBC42PreparedStatement@
> 4901e335:
> INSERT INTO storage_pool (storage_pool.id, storage_pool.name,
> storage_pool.uuid, storage_pool.pool_type, storage_pool.created,
> storage_pool.update_time, storage_pool.data_center_id, storage_pool.pod_id,
> storage_pool.used_bytes, storage_pool.capacity_bytes, storage_pool.status,
> storage_pool.storage_provider_name, storage_pool.host_address,
> storage_pool.path, storage_pool.port, storage_pool.user_info,
> storage_pool.cluster_id, storage_pool.scope, storage_pool.managed,
> storage_pool.capacity_iops, storage_pool.hypervisor) VALUES (0,
> _binary'PrimaryStorage1', _binary'9c279e74-15a5-3c8a-b0d1-14349b59710a',
> 'RBD', '2018-03-12 15:01:32', null, 1, 1, 0, 0, 'Initialized',
> _binary'DefaultPrimary', null, _binary'6A==@10.10.13.141/rbd', 6789, null,
> 1, null, 0, null, null)
> com.cloud.utils.exception.CloudRuntimeException: DB Exception on:
> com.mysql.jdbc.JDBC42PreparedStatement@4901e335: INSERT INTO storage_pool
> (
> storage_pool.id, storage_pool.name, storage_pool.uuid,
> storage_pool.pool_type, storage_pool.created, storage_pool.update_time,
> storage_pool.data_center_id, storage_pool.pod_id, storage_pool.used_bytes,
> storage_pool.capacity_bytes, storage_pool.status,
> storage_pool.storage_provider_name, storage_pool.host_address,
> storage_pool.path, storage_pool.port, storage_pool.user_info,
> storage_pool.cluster_id, storage_pool.scope, storage_pool.managed,
> storage_pool.capacity_iops, storage_pool.hypervisor) VALUES (0,
> _binary'PrimaryStorage1', _binary'9c279e74-15a5-3c8a-b0d1-14349b59710a',
> 'RBD', '2018-03-12 15:01:32', null, 1, 1, 0, 0, 'Initialized',
> _binary'DefaultPrimary', null, _binary'6A==@10.10.13.141/rbd', 6789, null,
> 1, null, 0, null, null)
> at com.cloud.utils.db.GenericDaoBase.persist(GenericDaoBase.java:1436)
> at
> org.apache.cloudstack.storage.datastore.db.PrimaryDataStoreDaoImpl.
> persist(PrimaryDataStoreDaoImpl.java:274)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
> 62)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(
> DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at
> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection
> (AopUtils.java:338)
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.
> invokeJoinpoint(ReflectiveMethodInvocation.java:197)
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
> ReflectiveMethodInvocation.java:163)
> at
> com.cloud.utils.db.TransactionContextInterceptor.invoke(
> TransactionContextInterceptor.java:34)
> at
> org.springframework.aop.framework.

Failed to add data store: DB Exception on: com.mysql.jdbc.JDBC42PreparedStatement

[McClune, James]

Hello CloudStack Community,

I just upgraded ACS from 4.9.3 to 4.11.0. I'm revamping my primary storage
(Ceph RBD). The problem I'm experiencing is every time I try to re-add my
Ceph storage pool, I get this error:


   - Something went wrong; please correct the following:
   Failed to add data store: DB Exception on:
   com.mysql.jdbc.JDBC42PreparedStatement@71996b4a: INSERT INTO
   storage_pool (storage_pool.id, storage_pool.name, storage_pool.uuid,
   storage_pool.pool_type, storage_pool.created, storage_pool.update_time,
   storage_pool.data_center_id, storage_pool.pod_id, storage_pool.used_bytes,
   storage_pool.capacity_bytes, storage_pool.status,
   storage_pool.storage_provider_name, storage_pool.host_address,
   storage_pool.path, storage_pool.port, storage_pool.user_info,
   storage_pool.cluster_id, storage_pool.scope, storage_pool.managed,
   storage_pool.capacity_iops, storage_pool.hypervisor) VALUES (0,
   _binary'PrimaryStorage1', _binary'9c279e74-15a5-3c8a-b0d1-14349b59710a',
   'RBD', '2018-03-12 14:55:18', null, 1, 1, 0, 0, 'Initialized',
   _binary'DefaultPrimary', null, _binary'6A==@10.10.13.141/rbd', 6789,
   null, 1, null, 0, null, null)

Here is the error from the management-server.log file:

2018-03-12 11:01:32,786 DEBUG [c.c.u.d.T.Transaction]
(qtp66233253-19:ctx-04c43d3a ctx-329be767) (logid:c19a8879) Rolling back
the transaction: Time = 1 Name =  qtp66233253-19; called by
-TransactionLegacy.rollback:889-TransactionLegacy.removeUpTo:832-TransactionLegacy.close:656-TransactionContextInterceptor.invoke:36-ReflectiveMethodInvocation.proceed:174-ExposeInvocationInterceptor.invoke:92-ReflectiveMethodInvocation.proceed:185-JdkDynamicAopProxy.invoke:212-$Proxy91.persist:-1-PrimaryDataStoreHelper.createPrimaryDataStore:135-CloudStackPrimaryDataStoreLifeCycleImpl.initialize:353-StorageManagerImpl.createPool:710
2018-03-12 11:01:32,788 DEBUG [c.c.s.StorageManagerImpl]
(qtp66233253-19:ctx-04c43d3a ctx-329be767) (logid:c19a8879) Failed to add
data store: DB Exception on: com.mysql.jdbc.JDBC42PreparedStatement@4901e335:
INSERT INTO storage_pool (storage_pool.id, storage_pool.name,
storage_pool.uuid, storage_pool.pool_type, storage_pool.created,
storage_pool.update_time, storage_pool.data_center_id, storage_pool.pod_id,
storage_pool.used_bytes, storage_pool.capacity_bytes, storage_pool.status,
storage_pool.storage_provider_name, storage_pool.host_address,
storage_pool.path, storage_pool.port, storage_pool.user_info,
storage_pool.cluster_id, storage_pool.scope, storage_pool.managed,
storage_pool.capacity_iops, storage_pool.hypervisor) VALUES (0,
_binary'PrimaryStorage1', _binary'9c279e74-15a5-3c8a-b0d1-14349b59710a',
'RBD', '2018-03-12 15:01:32', null, 1, 1, 0, 0, 'Initialized',
_binary'DefaultPrimary', null, _binary'6A==@10.10.13.141/rbd', 6789, null,
1, null, 0, null, null)
com.cloud.utils.exception.CloudRuntimeException: DB Exception on:
com.mysql.jdbc.JDBC42PreparedStatement@4901e335: INSERT INTO storage_pool (
storage_pool.id, storage_pool.name, storage_pool.uuid,
storage_pool.pool_type, storage_pool.created, storage_pool.update_time,
storage_pool.data_center_id, storage_pool.pod_id, storage_pool.used_bytes,
storage_pool.capacity_bytes, storage_pool.status,
storage_pool.storage_provider_name, storage_pool.host_address,
storage_pool.path, storage_pool.port, storage_pool.user_info,
storage_pool.cluster_id, storage_pool.scope, storage_pool.managed,
storage_pool.capacity_iops, storage_pool.hypervisor) VALUES (0,
_binary'PrimaryStorage1', _binary'9c279e74-15a5-3c8a-b0d1-14349b59710a',
'RBD', '2018-03-12 15:01:32', null, 1, 1, 0, 0, 'Initialized',
_binary'DefaultPrimary', null, _binary'6A==@10.10.13.141/rbd', 6789, null,
1, null, 0, null, null)
at com.cloud.utils.db.GenericDaoBase.persist(GenericDaoBase.java:1436)
at
org.apache.cloudstack.storage.datastore.db.PrimaryDataStoreDaoImpl.persist(PrimaryDataStoreDaoImpl.java:274)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:338)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:197)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at
com.cloud.utils.db.TransactionContextInterceptor.invoke(TransactionContextInterceptor.java:34)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:174)
at
org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke

Re: KVM HostHA

[Parth Patel]

>
> Hi Jon,
>
> As I said, in my case, making the host HA didn't work but by just having a
> HA VM running on host and executing - (WARNING) "echo c >
> /proc/sysrq-trigger" to simulate a kernel crash on host, the management
> server registered it as down and started the VM on another host. I know
> I've suggested this before but I insist you give this a try. Also, you
> don't need to completely power off the machine manually but just plugging
> out the network cable works fine. The cloudstack agent after losing
> connection to management server auto reboots because of KVM heartbeat check
> shell script mentioned by Rohit Yadav to one of my earlier queries in other
> thread.
>
> On Mon 12 Mar, 2018, 21:23 Jon Marshall,  wrote:
> Hi Paul
>
>
> Thanks for the response.
>
>
> I think I am not understanding how it was meant to work then. My
> understanding was that the manager used ipmitool to just keep querying the
> compute nodes as to their status so I assumed it didn't matter how you shut
> the node down, once it was down the manager would get no response and mark
> it as down (which it does).
>
>
> I am in testing mode so I think I will just go and pull the power and see
> what happens :)
>
>
> Thanks
>
>
> Jon
>
>
> 
> From: Paul Angus 
> Sent: 12 March 2018 15:31
> To: users@cloudstack.apache.org
> Subject: RE: KVM HostHA
> Hi Jon,
>
> I think that what you guys are finding, is that a controlled host
> shutdown, which will cause the agent to shutdown cleanly; Is not considered
> an HA event. I wouldn't expect CloudStack to take any action if you shut
> down a host, only if the host (agent) stops responding.
>
>
>
>
> Kind regards,
>
> Paul Angus
>
> paul.an...@shapeblue.com
> www.shapeblue.com
> [http://www.shapeblue.com/wp-content/uploads/2017/06/logo.png]<
> http://www.shapeblue.com/>
>
> Shapeblue - The CloudStack Company
> www.shapeblue.com
> Rapid deployment framework for Apache CloudStack IaaS Clouds. CSForge is a
> framework developed by ShapeBlue to deliver the rapid deployment of a
> standardised ...
>
>
>
> 53 Chandos Place, Covent Garden, London WC2N 4HSUK
> @shapeblue
>
>
>
>
> -Original Message-
> From: Jon Marshall 
> Sent: 12 March 2018 15:15
> To: users@cloudstack.apache.org
> Subject: Re: KVM HostHA
>
> I have the same issue here and am not entirely sure what the behaviour
> should be.
>
>
> I have one manager node and 2 compute nodes running 4.11 with ipmi working
> correctly.
>
>
> From the UI under HA -
>
>
> HA Enabled Yes
> HA State Available
> HA Provider kvmhaprovider
>
>
> although interestingly from the "Details" tab it shows -
>
>
> HA enabled No
>
>
> which I assume is a cosmetic issue ?
>
>
> On each compute node I have one HA enabled VM and one non HA enabled VM.
>
>
> I power off a compute node and the UI updates the host status and the VMs
> on that node stop responding but they never fail over to the other node.
>
>
> Couple of things I noticed -
>
>
> 1) as soon as i power off the compute node the HA state on the other node
> shows "Ineligible"
>
>
> 2) In the UI the instances all still show as green even though two of them
> are not available
>
>
> Any help much appreciated
>
>
>
>
> 
> From: victor 
> Sent: 07 March 2018 17:01
> To: users@cloudstack.apache.org
> Subject: KVM HostHA
>
> Hello Guys,
>
> I have installed cloudstack 4.11. I have enabled HA for each hosts I have
> added. I have also added ipmi successfully (using ipmi driver).
> The hosts are showing like the following.
>
> ===
>
> HA Enabled Yes
> HA State Available
> HA Provider kvmhaprovider
>
> ==
>
> Also the host is showing the following correctly
>
> Resource state --> Enabled
> State --> UP
> Power state --> On
>
> So I have shutdown one of the hosts to see how the KVM hosts Ha is
> working. I have waited for half an hour. But nothing has happened. What
> will happen to the VM's in that host, if the host failed to back up.
> There isn't much from logs.
>
> Regards
> Victor
>

RE: KVM HostHA

[Paul Angus]

I tested using:

echo c > /proc/sysrq-trigger

which will crash the host.

Kind regards,

Paul Angus

paul.an...@shapeblue.com 
www.shapeblue.com
53 Chandos Place, Covent Garden, London  WC2N 4HSUK
@shapeblue
  
 


-Original Message-
From: Jon Marshall  
Sent: 12 March 2018 15:53
To: users@cloudstack.apache.org
Subject: Re: KVM HostHA

Hi Paul


Thanks for the response.


I think I am not understanding how it was meant to work then.  My understanding 
was that the manager used ipmitool to just keep querying the compute nodes as 
to their status so I assumed it didn't matter how you shut the node down, once 
it was down the manager would get no response and mark it as down (which it 
does).


I am in testing mode so I think I will just go and pull the power and see what 
happens :)


Thanks


Jon



From: Paul Angus 
Sent: 12 March 2018 15:31
To: users@cloudstack.apache.org
Subject: RE: KVM HostHA
 Hi Jon,

I think that what you guys are finding, is that a controlled host shutdown, 
which will cause the agent to shutdown cleanly;  Is not considered an HA event. 
 I wouldn't expect CloudStack to take any action if you shut down a host, only 
if the host (agent) stops responding.




Kind regards,

Paul Angus

paul.an...@shapeblue.com
www.shapeblue.com
[http://www.shapeblue.com/wp-content/uploads/2017/06/logo.png]

Shapeblue - The CloudStack Company
www.shapeblue.com
Rapid deployment framework for Apache CloudStack IaaS Clouds. CSForge is a 
framework developed by ShapeBlue to deliver the rapid deployment of a 
standardised ...



53 Chandos Place, Covent Garden, London  WC2N 4HSUK @shapeblue




-Original Message-
From: Jon Marshall 
Sent: 12 March 2018 15:15
To: users@cloudstack.apache.org
Subject: Re: KVM HostHA

I have the same issue here and am not entirely sure what the behaviour should 
be.


I have one manager node and 2 compute nodes running 4.11 with ipmi working 
correctly.


From the UI under HA -


HA Enabled   Yes
HA State Available
HA Provider  kvmhaprovider


although interestingly from the "Details" tab it shows -


HA enabled   No


which I assume is a cosmetic issue ?


On each compute node I have one HA enabled VM and one non HA enabled VM.


I power off a compute node and the UI updates the host status and the VMs on 
that node stop responding but they never fail over to the other node.


Couple of things I noticed -


1) as soon as i power off the compute node the HA state on the other node shows 
"Ineligible"


2) In the UI the instances all still show as green even though two of them are 
not available


Any help much appreciated





From: victor 
Sent: 07 March 2018 17:01
To: users@cloudstack.apache.org
Subject: KVM HostHA

Hello Guys,

I have installed cloudstack 4.11. I have enabled HA for each hosts I have 
added. I have also added ipmi successfully (using ipmi driver).
The hosts are showing like the following.

===

HA Enabled   Yes
HA State Available
HA Provider  kvmhaprovider

==

Also the host is showing the following correctly

Resource state --> Enabled
State --> UP
Power state --> On

So I have shutdown one of the hosts to see how the KVM hosts Ha is working.  I 
have waited for half an hour. But nothing has happened. What will happen to the 
VM's in that host, if the host failed to back up.
There isn't much from logs.

Regards
Victor

Re: KVM HostHA

[Jon Marshall]

Hi Paul


Thanks for the response.


I think I am not understanding how it was meant to work then.  My understanding 
was that the manager used ipmitool to just keep querying the compute nodes as 
to their status so I assumed it didn't matter how you shut the node down, once 
it was down the manager would get no response and mark it as down (which it 
does).


I am in testing mode so I think I will just go and pull the power and see what 
happens :)


Thanks


Jon



From: Paul Angus 
Sent: 12 March 2018 15:31
To: users@cloudstack.apache.org
Subject: RE: KVM HostHA
 Hi Jon,

I think that what you guys are finding, is that a controlled host shutdown, 
which will cause the agent to shutdown cleanly;  Is not considered an HA event. 
 I wouldn't expect CloudStack to take any action if you shut down a host, only 
if the host (agent) stops responding.




Kind regards,

Paul Angus

paul.an...@shapeblue.com
www.shapeblue.com
[http://www.shapeblue.com/wp-content/uploads/2017/06/logo.png]

Shapeblue - The CloudStack Company
www.shapeblue.com
Rapid deployment framework for Apache CloudStack IaaS Clouds. CSForge is a 
framework developed by ShapeBlue to deliver the rapid deployment of a 
standardised ...



53 Chandos Place, Covent Garden, London  WC2N 4HSUK
@shapeblue




-Original Message-
From: Jon Marshall 
Sent: 12 March 2018 15:15
To: users@cloudstack.apache.org
Subject: Re: KVM HostHA

I have the same issue here and am not entirely sure what the behaviour should 
be.


I have one manager node and 2 compute nodes running 4.11 with ipmi working 
correctly.


>From the UI under HA -


HA Enabled   Yes
HA State Available
HA Provider  kvmhaprovider


although interestingly from the "Details" tab it shows -


HA enabled   No


which I assume is a cosmetic issue ?


On each compute node I have one HA enabled VM and one non HA enabled VM.


I power off a compute node and the UI updates the host status and the VMs on 
that node stop responding but they never fail over to the other node.


Couple of things I noticed -


1) as soon as i power off the compute node the HA state on the other node shows 
"Ineligible"


2) In the UI the instances all still show as green even though two of them are 
not available


Any help much appreciated





From: victor 
Sent: 07 March 2018 17:01
To: users@cloudstack.apache.org
Subject: KVM HostHA

Hello Guys,

I have installed cloudstack 4.11. I have enabled HA for each hosts I have 
added. I have also added ipmi successfully (using ipmi driver).
The hosts are showing like the following.

===

HA Enabled   Yes
HA State Available
HA Provider  kvmhaprovider

==

Also the host is showing the following correctly

Resource state --> Enabled
State --> UP
Power state --> On

So I have shutdown one of the hosts to see how the KVM hosts Ha is working.  I 
have waited for half an hour. But nothing has happened. What will happen to the 
VM's in that host, if the host failed to back up.
There isn't much from logs.

Regards
Victor

RE: KVM HostHA

[Paul Angus]

Hi Jon,

I think that what you guys are finding, is that a controlled host shutdown, 
which will cause the agent to shutdown cleanly;  Is not considered an HA event. 
 I wouldn't expect CloudStack to take any action if you shut down a host, only 
if the host (agent) stops responding.




Kind regards,

Paul Angus

paul.an...@shapeblue.com 
www.shapeblue.com
53 Chandos Place, Covent Garden, London  WC2N 4HSUK
@shapeblue
  
 


-Original Message-
From: Jon Marshall  
Sent: 12 March 2018 15:15
To: users@cloudstack.apache.org
Subject: Re: KVM HostHA

I have the same issue here and am not entirely sure what the behaviour should 
be.


I have one manager node and 2 compute nodes running 4.11 with ipmi working 
correctly.


From the UI under HA -


HA Enabled   Yes
HA State Available
HA Provider  kvmhaprovider


although interestingly from the "Details" tab it shows -


HA enabled   No


which I assume is a cosmetic issue ?


On each compute node I have one HA enabled VM and one non HA enabled VM.


I power off a compute node and the UI updates the host status and the VMs on 
that node stop responding but they never fail over to the other node.


Couple of things I noticed -


1) as soon as i power off the compute node the HA state on the other node shows 
"Ineligible"


2) In the UI the instances all still show as green even though two of them are 
not available


Any help much appreciated





From: victor 
Sent: 07 March 2018 17:01
To: users@cloudstack.apache.org
Subject: KVM HostHA

Hello Guys,

I have installed cloudstack 4.11. I have enabled HA for each hosts I have 
added. I have also added ipmi successfully (using ipmi driver).
The hosts are showing like the following.

===

HA Enabled   Yes
HA State Available
HA Provider  kvmhaprovider

==

Also the host is showing the following correctly

Resource state --> Enabled
State --> UP
Power state --> On

So I have shutdown one of the hosts to see how the KVM hosts Ha is working.  I 
have waited for half an hour. But nothing has happened. What will happen to the 
VM's in that host, if the host failed to back up.
There isn't much from logs.

Regards
Victor

Re: KVM HostHA

[Jon Marshall]

I have the same issue here and am not entirely sure what the behaviour should 
be.


I have one manager node and 2 compute nodes running 4.11 with ipmi working 
correctly.


>From the UI under HA -


HA Enabled   Yes
HA State Available
HA Provider  kvmhaprovider


although interestingly from the "Details" tab it shows -


HA enabled   No


which I assume is a cosmetic issue ?


On each compute node I have one HA enabled VM and one non HA enabled VM.


I power off a compute node and the UI updates the host status and the VMs on 
that node stop responding but they never fail over to the other node.


Couple of things I noticed -


1) as soon as i power off the compute node the HA state on the other node shows 
"Ineligible"


2) In the UI the instances all still show as green even though two of them are 
not available


Any help much appreciated





From: victor 
Sent: 07 March 2018 17:01
To: users@cloudstack.apache.org
Subject: KVM HostHA

Hello Guys,

I have installed cloudstack 4.11. I have enabled HA for each hosts I
have added. I have also added ipmi successfully (using ipmi driver).
The hosts are showing like the following.

===

HA Enabled   Yes
HA State Available
HA Provider  kvmhaprovider

==

Also the host is showing the following correctly

Resource state --> Enabled
State --> UP
Power state --> On

So I have shutdown one of the hosts to see how the KVM hosts Ha is
working.  I have waited for half an hour. But nothing has happened. What
will happen to the VM's in that host, if the host failed to back up.
There isn't much from logs.

Regards
Victor

Re: Storage Migration VPC ACS 4.5.2

[Felipe Rossi]

Tks All,

Now its ok, we can migrate and now update for ACS 4.9.2


Att / Regards



Felipe Rossi
Diretor de Negócios e Inovação
Cloud Architect
+55(45) 9911.60094  +55(45) 3326-4568
fel...@brascloud.com.br www.brascloud.com.br
    
   
   
















> On 9 Mar 2018, at 06:55, Andrija Panic  wrote:
> 
> Felipe,
> 
> first make sure that you have proper TAG setup on System Offering for VR,
> to match your NEW storage TAGs (if any TAGs used), and then as Dag said,
> disable the old storage - or if possible you can also edit/create INVALID
> tags on the old storage (go to Infrastructure --> Primary Storage and click
> on EDIT button on old sotrage to define new or edit TAGS) - this way also
> old storage will NOT match the tag of the Service Offering for VR, so VR
> should NOT be recreated on old storage at all.
> 
> As for " Other thing, in ACS 4.5 do not exist cleanup VPC option" - this is
> OK, restarting VPC in ACS 4.5 implicitly does the same thing - new VR
> created with new name on possibly new storage (same as with ACS 4.8 with
> CleanUP option)
> 
> 
> Let me know if this works,
> 
> Cheers
> 
> On 8 March 2018 at 18:00, Felipe Rossi  > wrote:
> 
>> Hello Dag / Rafael,
>> 
>> @Dag
>> I setup TAG on new storage and when i make in VR work fine selecting
>> CLEANUP option and migrate work to new storage, but when i have VR+VPC its
>> not work.
>> 
>> @Rafael, dont show error on screen, on ACS i not verify the logs, im try
>> again and report if generate some logs.
>> 
>> 
>> Att / Regards
>> 
>> 
>> 
>> Felipe Rossi
>> Diretor de Negócios e Inovação
>> Cloud Architect
>> +55(45) 9911.60094  +55(45) 3326-4568
>> fel...@brascloud.com.br www.brascloud.com.br
>> > >   > 
>> felipesecure/>   > >
>> > >
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>>> On 8 Mar 2018, at 13:49, Rafael Weingärtner 
>> wrote:
>>> 
>>> What acommand are you using to migrate this VR of a VPC?
>>> What is the error are you seeing in the log files?
>>> 
>>> On Thu, Mar 8, 2018 at 1:40 PM, Felipe Rossi 
>>> wrote:
>>> 
 Hi Andrija,
 
 I need migrate VR of VPC for another Primary Storage but not work, if we
 migrate other any just VR without VPC
 select option CLEANUP work, but VR of VPC not migrate to another
>> storage.
 
 Att / Regards
 
 
 
 Felipe Rossi
 Diretor de Negócios e Inovação
 Cloud Architect
 +55(45) 9911.60094  +55(45) 3326-4568
 fel...@brascloud.com.br www.brascloud.com.br
       > felipe-rossi-208a1830/?ppe=1>
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
> On 8 Mar 2018, at 12:53, Andrija Panic 
>> wrote:
> 
> Hi Felipe,
> 
> I did not understand the question - what are you trying to achieve
 exactly ?
> 
> Cheers
> 
> On 8 March 2018 at 16:21, Felipe Rossi 
>> wrote:
> 
>> Hello Guys,
>> 
>> I need Verify what process for storage migration of VPC on ACS 4.5.2
>> 
>> I try migrate VR but not work.
>> 
>> 
>> 
>> Att / Regards
>> 
>> 
>> 
>> Felipe Rossi
>> Diretor de Negócios e Inovação
>> Cloud Architect
>> +55(45) 9911.60094  +55(45) 3326-4568
>> fel...@brascloud.com.br www.brascloud.com.br
>>    > felipesecure/>   
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
> 
> 
> --
> 
> Andrija Panić
 
 
>>> 
>>> 
>>> --
>>> Rafael Weingärtner
>> 
>> 
> 
> 
> -- 
> 
> Andrija Panić