[jira] [Closed] (CLOUDSTACK-5207) jdbc.exceptions are observed when both Master 1 and master 2 goes down and comes back.

["Kiran Koneti (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CLOUDSTACK-5207?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kiran Koneti closed CLOUDSTACK-5207.
------------------------------------


Closing the issue as the Design is changed that when both the DB servers are down the CS goes to shutdown.

> jdbc.exceptions are observed when both Master 1 and master 2 goes down and comes back.
> --------------------------------------------------------------------------------------
>
>                 Key: CLOUDSTACK-5207
>                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-5207
>             Project: CloudStack
>          Issue Type: Bug
>      Security Level: Public(Anyone can view this level - this is the default.) 
>          Components: Management Server
>    Affects Versions: 4.3.0
>            Reporter: Kiran Koneti
>            Assignee: Damodar Reddy T
>            Priority: Critical
>             Fix For: 4.3.0
>
>
> 1)I have created a replication db with 2 masters say M1 and M2.
> 2)The CS setup came up and both the db's are in sync.
> 3)now i made the M1 down and the M2 was made the master and the operations of CS were normal.
> 4)Now i made the M2 also down and the db of the CS could not be accessed.
> 5)Later i made the M1 up and then M2.The data sync happened properly but there is an error message which is constantly shown in the MS log and it is as below:
> "2013-11-20 11:34:50,938 ERROR [c.c.u.d.ConnectionConcierge] (ConnectionConcierge-1:ctx-7c449525) Unable to keep the db connection for LockMaster1
> com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.  Connection closed after inability to pick valid new connection during fail-over.
>         at sun.reflect.GeneratedConstructorAccessor25.newInstance(Unknown Source)
>         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
>         at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
>         at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
>         at com.mysql.jdbc.Util.getInstance(Util.java:386)
>         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1014)
>         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988)
>         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974)
>         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
>         at com.mysql.jdbc.LoadBalancingConnectionProxy.invoke(LoadBalancingConnectionProxy.java:532)
>         at com.mysql.jdbc.FailoverConnectionProxy.invoke(FailoverConnectionProxy.java:136)
>         at $Proxy19.prepareStatement(Unknown Source)
>         at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281)
>         at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313)
>         at com.cloud.utils.db.ConnectionConcierge$ConnectionConciergeManager.testValidity(ConnectionConcierge.java:148)
>         at com.cloud.utils.db.ConnectionConcierge$ConnectionConciergeManager$1.runInContext(ConnectionConcierge.java:211)
>         at org.apache.cloudstack.managed.context.ManagedContextRunnable$1.run(ManagedContextRunnable.java:49)
>         at org.apache.cloudstack.managed.context.impl.DefaultManagedContext$1.call(DefaultManagedContext.java:56)
>         at org.apache.cloudstack.managed.context.impl.DefaultManagedContext.callWithContext(DefaultManagedContext.java:103)
>         at org.apache.cloudstack.managed.context.impl.DefaultManagedContext.runWithContext(DefaultManagedContext.java:53)
>         at org.apache.cloudstack.managed.context.ManagedContextRunnable.run(ManagedContextRunnable.java:46)
>         at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
>         at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:351)
>         at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:178)
>         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:165)
>         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:267)
>         at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
>         at java.lang.Thread.run(Thread.java:679)"



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)