cloudstack-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rafael Weingärtner <rafaelweingart...@gmail.com>
Subject Re: Failed to add data store: DB Exception on: com.mysql.jdbc.JDBC42PreparedStatement
Date Mon, 12 Mar 2018 19:56:44 GMT
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 <
mcclunej@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 <
> mcclunej@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 <
> > rafaelweingartner@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 <
> >> mcclunej@norwalktruckers.net> wrote:
> >>
> >> > I'm using Oracle MySQL.
> >> >
> >> > - James
> >> >
> >> > On Mon, Mar 12, 2018 at 3:33 PM, Rafael Weingärtner <
> >> > rafaelweingartner@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 <
> >> > > mcclunej@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 <
> >> > > > rafaelweingartner@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 <
> >> > > >> mcclunej@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,
> >> > > >> 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)
> >> > > >> > at com.cloud.utils.db.GenericDaoBase.persist(
> >> > > GenericDaoBase.java:1436)
> >> > > >> > at
> >> > > >> > org.apache.cloudstack.storage.datastore.db.PrimaryDataStoreD
> >> aoImpl.
> >> > > >> > persist(PrimaryDataStoreDaoImpl.java:274)
> >> > > >> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
> >> > > >> > at
> >> > > >> > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce
> >> > > >> ssorImpl.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(JdkDynamicAopProxy.java:212)
> >> > > >> > at com.sun.proxy.$Proxy91.persist(Unknown Source)
> >> > > >> > at
> >> > > >> > org.apache.cloudstack.storage.volume.datastore.
> >> > > PrimaryDataStoreHelper.
> >> > > >> > createPrimaryDataStore(PrimaryDataStoreHelper.java:135)
> >> > > >> > at
> >> > > >> > org.apache.cloudstack.storage.datastore.lifecycle.
> >> > > >> > CloudStackPrimaryDataStoreLifeCycleImpl.initialize(
> >> > > >> > CloudStackPrimaryDataStoreLifeCycleImpl.java:353)
> >> > > >> > at
> >> > > >> > com.cloud.storage.StorageManagerImpl.createPool(
> >> > > >> > StorageManagerImpl.java:710)
> >> > > >> > at
> >> > > >> > com.cloud.storage.StorageManagerImpl.createPool(
> >> > > >> > StorageManagerImpl.java:203)
> >> > > >> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
> >> > > >> > at
> >> > > >> > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce
> >> > > >> ssorImpl.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
> >> > > >> > 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(JdkDynamicAopProxy.java:212)
> >> > > >> > at com.sun.proxy.$Proxy94.createPool(Unknown Source)
> >> > > >> > at
> >> > > >> > org.apache.cloudstack.api.command.admin.storage.
> >> > > >> > CreateStoragePoolCmd.execute(CreateStoragePoolCmd.java:163)
> >> > > >> > at com.cloud.api.ApiDispatcher.dispatch(ApiDispatcher.java:
> 150)
> >> > > >> > at com.cloud.api.ApiServer.queueCommand(ApiServer.java:731)
> >> > > >> > at com.cloud.api.ApiServer.handleRequest(ApiServer.java:555)
> >> > > >> > at com.cloud.api.ApiServlet.processRequestInContext(
> ApiServlet.
> >> > > >> java:310)
> >> > > >> > at com.cloud.api.ApiServlet$1.run(ApiServlet.java:130)
> >> > > >> > at
> >> > > >> > org.apache.cloudstack.managed.context.impl.DefaultManagedCon
> >> > > >> text$1.call(
> >> > > >> > DefaultManagedContext.java:56)
> >> > > >> > at
> >> > > >> > org.apache.cloudstack.managed.context.impl.DefaultManagedCon
> >> text.
> >> > > >> > callWithContext(DefaultManagedContext.java:103)
> >> > > >> > at
> >> > > >> > org.apache.cloudstack.managed.context.impl.DefaultManagedCon
> >> text.
> >> > > >> > runWithContext(DefaultManagedContext.java:53)
> >> > > >> > at com.cloud.api.ApiServlet.processRequest(ApiServlet.
> java:127)
> >> > > >> > at com.cloud.api.ApiServlet.doGet(ApiServlet.java:89)
> >> > > >> > at javax.servlet.http.HttpServlet.service(
> HttpServlet.java:686)
> >> > > >> > at javax.servlet.http.HttpServlet.service(
> HttpServlet.java:791)
> >> > > >> > at org.eclipse.jetty.servlet.ServletHolder.handle(
> ServletHolder
> >> > > >> .java:852)
> >> > > >> > at
> >> > > >> > org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHan
> >> > > >> dler.java:535)
> >> > > >> > at
> >> > > >> > org.eclipse.jetty.server.handler.ScopedHandler.handle(
> >> > > >> > ScopedHandler.java:143)
> >> > > >> > at
> >> > > >> > org.eclipse.jetty.security.SecurityHandler.handle(
> >> > > >> > SecurityHandler.java:548)
> >> > > >> > at
> >> > > >> > org.eclipse.jetty.server.handler.HandlerWrapper.handle(
> >> > > >> > HandlerWrapper.java:132)
> >> > > >> > at
> >> > > >> > org.eclipse.jetty.server.handler.ScopedHandler.
> >> > > >> > nextHandle(ScopedHandler.java:190)
> >> > > >> > at
> >> > > >> > org.eclipse.jetty.server.session.SessionHandler.
> >> > > >> > doHandle(SessionHandler.java:1595)
> >> > > >> > at
> >> > > >> > org.eclipse.jetty.server.handler.ScopedHandler.
> >> > > >> > nextHandle(ScopedHandler.java:188)
> >> > > >> > at
> >> > > >> > org.eclipse.jetty.server.handler.ContextHandler.
> >> > > >> > doHandle(ContextHandler.java:1253)
> >> > > >> > at
> >> > > >> > org.eclipse.jetty.server.handler.ScopedHandler.
> >> > > >> > nextScope(ScopedHandler.java:168)
> >> > > >> > at org.eclipse.jetty.servlet.ServletHandler.doScope(
> >> > > >> > ServletHandler.java:473)
> >> > > >> > at
> >> > > >> > org.eclipse.jetty.server.session.SessionHandler.
> >> > > >> > doScope(SessionHandler.java:1564)
> >> > > >> > at
> >> > > >> > org.eclipse.jetty.server.handler.ScopedHandler.
> >> > > >> > nextScope(ScopedHandler.java:166)
> >> > > >> > at
> >> > > >> > org.eclipse.jetty.server.handler.ContextHandler.
> >> > > >> > doScope(ContextHandler.java:1155)
> >> > > >> > at
> >> > > >> > org.eclipse.jetty.server.handler.ScopedHandler.handle(
> >> > > >> > ScopedHandler.java:141)
> >> > > >> > at
> >> > > >> > org.eclipse.jetty.server.handler.gzip.GzipHandler.
> >> > > >> > handle(GzipHandler.java:527)
> >> > > >> > at
> >> > > >> > org.eclipse.jetty.server.handler.HandlerCollection.
> >> > > >> > handle(HandlerCollection.java:126)
> >> > > >> > at
> >> > > >> > org.eclipse.jetty.server.handler.HandlerWrapper.handle(
> >> > > >> > HandlerWrapper.java:132)
> >> > > >> > at org.eclipse.jetty.server.Server.handle(Server.java:530)
> >> > > >> > at org.eclipse.jetty.server.HttpChannel.handle(
> >> > HttpChannel.java:347)
> >> > > >> > at
> >> > > >> > org.eclipse.jetty.server.HttpConnection.onFillable(
> >> > > >> > HttpConnection.java:256)
> >> > > >> > at
> >> > > >> > org.eclipse.jetty.io.AbstractConnection$
> ReadCallback.succeeded(
> >> > > >> > AbstractConnection.java:279)
> >> > > >> > at org.eclipse.jetty.io.FillInterest.fillable(
> >> > FillInterest.java:102)
> >> > > >> > at org.eclipse.jetty.io.ChannelEndPoint$2.run(
> >> > > ChannelEndPoint.java:124)
> >> > > >> > at
> >> > > >> > org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.
> >> > > >> > doProduce(EatWhatYouKill.java:247)
> >> > > >> > at
> >> > > >> > org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.
> >> > > >> > produce(EatWhatYouKill.java:140)
> >> > > >> > at
> >> > > >> > org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(
> >> > > >> > EatWhatYouKill.java:131)
> >> > > >> > at
> >> > > >> > org.eclipse.jetty.util.thread.ReservedThreadExecutor$Reserve
> >> > > >> dThread.run(
> >> > > >> > ReservedThreadExecutor.java:382)
> >> > > >> > at
> >> > > >> > org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(
> >> > > >> > QueuedThreadPool.java:708)
> >> > > >> > at
> >> > > >> > org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(
> >> > > >> > QueuedThreadPool.java:626)
> >> > > >> > at java.lang.Thread.run(Thread.java:748)
> >> > > >> > Caused by:
> >> > > >> > com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolat
> >> > > >> > ionException:
> >> > > >> > Column 'host_address' cannot be null
> >> > > >> > at sun.reflect.NativeConstructorAccessorImpl.
> newInstance0(Native
> >> > > >> Method)
> >> > > >> > at
> >> > > >> > sun.reflect.NativeConstructorAccessorImpl.newInstance(
> >> > > >> > NativeConstructorAccessorImpl.java:62)
> >> > > >> > at
> >> > > >> > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(
> >> > > >> > DelegatingConstructorAccessorImpl.java:45)
> >> > > >> > ... 90 more
> >> > > >> >
> >> > > >> > Is there something I'm missing or did not do correctly?
I've
> been
> >> > > >> getting
> >> > > >> > this error many times today. If anyone knows anything
about
> this,
> >> > > please
> >> > > >> > let me know. I can also produce server logs, if that
will be
> any
> >> > help.
> >> > > >> >
> >> > > >> > Thanks,
> >> > > >> > James
> >> > > >> >
> >> > > >>
> >> > > >>
> >> > > >>
> >> > > >> --
> >> > > >> Rafael Weingärtner
> >> > > >>
> >> > > >
> >> > > >
> >> > > >
> >> > > > --
> >> > > >
> >> > > >
> >> > > >
> >> > > > James McClune
> >> > > >
> >> > > > Technical Support Specialist
> >> > > >
> >> > > > Norwalk City Schools
> >> > > >
> >> > > > Phone: 419-660-6590 <(419)%20660-6590>
> >> > > >
> >> > > > mcclunej@norwalktruckers.net
> >> > > >
> >> > >
> >> > >
> >> > >
> >> > > --
> >> > > Rafael Weingärtner
> >> > >
> >> >
> >> >
> >> >
> >> > --
> >> >
> >> >
> >> >
> >> > James McClune
> >> >
> >> > Technical Support Specialist
> >> >
> >> > Norwalk City Schools
> >> >
> >> > Phone: 419-660-6590
> >> >
> >> > mcclunej@norwalktruckers.net
> >> >
> >>
> >>
> >>
> >> --
> >> Rafael Weingärtner
> >>
> >
> >
> >
> > --
> >
> >
> >
> > James McClune
> >
> > Technical Support Specialist
> >
> > Norwalk City Schools
> >
> > Phone: 419-660-6590 <(419)%20660-6590>
> >
> > mcclunej@norwalktruckers.net
> >
>
>
>
> --
>
>
>
> James McClune
>
> Technical Support Specialist
>
> Norwalk City Schools
>
> Phone: 419-660-6590
>
> mcclunej@norwalktruckers.net
>



-- 
Rafael Weingärtner

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