[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: DB Communication Link Failure


Hello Dag,

Im not trying to do a multi-master setup, just recover my DB :/
I have installed  a second node and connect it to the DB and it's not possible to connect to the database server automatically (but manually yes..)
On the first node at each sql query sent, the service mysql restart on db server...


@Rafael, the timeout value is 28800


mysql> SHOW VARIABLES LIKE 'wait_timeout';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| wait_timeout  | 28800 |
+---------------+-------+

Best regards,


Nicolas Bouige
DIMSI
cloud.dimsi.fr<http://www.cloud.dimsi.fr>
4, avenue Laurent Cely
Tour d’Asnière – 92600 Asnière sur Seine
T/ +33 (0)6 28 98 53 40


________________________________
De : Dag Sonstebo <Dag.Sonstebo@xxxxxxxxxxxxx>
Envoyé : jeudi 14 juin 2018 10:32:13
À : users@xxxxxxxxxxxxxxxxxxxxx
Objet : Re: DB Communication Link Failure

What Rafael said…

In addition – can you confirm you aren’t trying something like a multi-master MySQL setup? I have seen this cause similar issues.

Regards,
Dag Sonstebo
Cloud Architect
ShapeBlue

On 13/06/2018, 18:44, "Rafael Weingärtner" <rafaelweingartner@xxxxxxxxx> wrote:

    In this case, I would say that you might be either having some problem in
    your network, or maybe some timeout in the mysql server.
    Can you check the following variable?
    >
    > show variables like "%timeout%";
    >
    >

Dag.Sonstebo@xxxxxxxxxxxxx
www.shapeblue.com<http://www.shapeblue.com>
53 Chandos Place, Covent Garden, London  WC2N 4HSUK
@shapeblue



On Wed, Jun 13, 2018 at 6:05 PM, Nicolas Bouige <n.bouige@xxxxxxxx> wrote:

    > Hello Dag, Rafael,
    >
    > Thanks for your answer, i knonw this seems to be a "simple" issue but, as
    > i said in my previous mail, i checked connectivity between both server
    > without any problem (ping, telnet, firewall policies, remote mysql
    > connection...) and yes i restarted mgmt server (and it's not a silly
    > question...;)..)
    >
    > Someone knows something about the rollback transactions ?
    >
    > Best regards,
    >
    > N.B
    >
    > -----Message d'origine-----
    > De : Rafael Weingärtner [mailto:rafaelweingartner@xxxxxxxxx]
    > Envoyé : mercredi 13 juin 2018 16:59
    > À : users <users@xxxxxxxxxxxxxxxxxxxxx>
    > Objet : Re: DB Communication Link Failure
    >
    > This might be a silly question, but... Have you restarted the management
    > server?
    > This problem may be caused by the connection pool. In theory, it should
    > re-create the connection, but you know, sometimes things just break.
    >
    > On Wed, Jun 13, 2018 at 4:56 PM, Dag Sonstebo <Dag.Sonstebo@xxxxxxxxxxxxx>
    > wrote:
    >
    > > Hi Nicolas – not to dig too far into your analysis or log entries –
    > > but in my experience any time we see “Communications link failure” the
    > > problem is exactly that – a communications issue between management
    > > and DB, rather than an internal DB issue.
    > >
    > > Regards,
    > > Dag Sonstebo
    > > Cloud Architect
    > > ShapeBlue
    > >
    > > From: Nicolas Bouige <n.bouige@xxxxxxxx>
    > > Reply-To: "users@xxxxxxxxxxxxxxxxxxxxx" <users@xxxxxxxxxxxxxxxxxxxxx>
    > > Date: Wednesday, 13 June 2018 at 15:04
    > > To: "users@xxxxxxxxxxxxxxxxxxxxx" <users@xxxxxxxxxxxxxxxxxxxxx>
    > > Subject: DB Communication Link Failure
    > >
    > > Hello All,
    > >
    > > Tonight du to a network issue our management cloudstack server and
    > > MariaDb server have been shutdowned and restarted this morning.
    > >
    > > Unfortunately, we  get some issues of « connectivity » between the
    > > mgmt server and db server.
    > > Both service (cloudstack-management/mysqld) are up and running without
    > > any errors.
    > > Db server are available from mgmt server (telnet OK, mysql –h
    > > dbserver…ok, firewall policies are good from both sides)
    > >
    > > However, when we want to login to the GUI cloudstack an execption is
    > > raised in mgmt-server.log :
    > >
    > > 2018-06-13 15:28:41,019 DEBUG [c.c.u.d.T.Transaction]
    > > (qtp1796488937-13:ctx-88e441c4) (logid:f9e9b399) Rolling back the
    > > transaction: Time = 97 Name =  qtp1796488937-13; 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-$Proxy121.persist:-1-ActionEventUtils.
    > > persistActionEvent:186-ActionEventUtils.onActionEvent:98-
    > > AccountManagerImpl.logoutUser:2096
    > > 2018-06-13 15:28:41,020 WARN  [c.c.u.d.T.Transaction]
    > > (qtp1796488937-13:ctx-88e441c4) (logid:f9e9b399) Unable to rollback
    > > com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException:
    > > Communications link failure during rollback(). Transaction resolution
    > > unknown.
    > >         at
    > > sun.reflect.GeneratedConstructorAccessor98.newInstance(Unknown
    > > Source)
    > >         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(
    > > DelegatingConstructorAccessorImpl.java:45)
    > >         at java.lang.reflect.Constructor.newInstance(Constructor.java:
    > 423)
    > >         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:1015)
    > >         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
    > >         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975)
    > >         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920)
    > >         at com.mysql.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:
    > > 5067)
    > >         at org.apache.commons.dbcp.DelegatingConnection.rollback(
    > > DelegatingConnection.java:368)
    > >         at org.apache.commons.dbcp.PoolingDataSource$
    > > PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:323)
    > >         at com.cloud.utils.db.TransactionLegacy.rollbackTransaction(
    > > TransactionLegacy.java:851)
    > >         at com.cloud.utils.db.TransactionLegacy.rollback(
    > > TransactionLegacy.java:889)
    > >         at com.cloud.utils.db.TransactionLegacy.removeUpTo(
    > > TransactionLegacy.java:832)
    > >         at com.cloud.utils.db.TransactionLegacy.close(
    > > TransactionLegacy.java:656)
    > >         at com.cloud.utils.db.TransactionContextInterceptor.invoke(
    > > TransactionContextInterceptor.java:36)
    > >         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.$Proxy121.persist(Unknown Source)
    > >         at com.cloud.event.ActionEventUtils.persistActionEvent(
    > > ActionEventUtils.java:186)
    > >         at com.cloud.event.ActionEventUtils.onActionEvent(
    > > ActionEventUtils.java:98)
    > >         at com.cloud.user.AccountManagerImpl.logoutUser(
    > > AccountManagerImpl.java:2096)
    > >         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 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.$Proxy40.logoutUser(Unknown Source)
    > >         at com.cloud.api.ApiServer.logoutUser(ApiServer.java:1104)
    > >         at com.cloud.api.ApiServlet.processRequestInContext(
    > > ApiServlet.java:234)
    > >         at com.cloud.api.ApiServlet$1.run(ApiServlet.java:130)
    > >         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 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(
    > > ServletHandler.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$
    > > ReservedThread.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)
    > > 2018-06-13 15:28:41,024 ERROR [c.c.a.ApiServlet]
    > > (qtp1796488937-13:ctx-88e441c4)
    > > (logid:f9e9b399) unknown exception writing api response
    > > com.cloud.utils.exception.CloudRuntimeException: DB Exception on:
    > > com.mysql.jdbc.JDBC4PreparedStatement@168d9c37: INSERT INTO event
    > > (event.type, event.state, event.description, event.created,
    > > event.user_id, event.account_id, event.domain_id, event.level,
    > > event.start_id, event.parameters, event.uuid, event.archived,
    > > event.display) VALUES (_binary'USER.LOGOUT', 'Completed', _binary'user
    > > has logged out',
    > > '2018-06-13 13:28:40', 2, 2, 1, _binary'INFO', 0, null,
    > > _binary'd9009f21-6550-4a18-a6e9-9213bbb8eabb', 0, 1)
    > >         at com.cloud.utils.db.GenericDaoBase.persist(
    > > GenericDaoBase.java:1436)
    > >         at sun.reflect.GeneratedMethodAccessor118.invoke(Unknown Source)
    > >         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.$Proxy121.persist(Unknown Source)
    > >         at com.cloud.event.ActionEventUtils.persistActionEvent(
    > > ActionEventUtils.java:186)
    > >         at com.cloud.event.ActionEventUtils.onActionEvent(
    > > ActionEventUtils.java:98)
    > >         at com.cloud.user.AccountManagerImpl.logoutUser(
    > > AccountManagerImpl.java:2096)
    > >         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 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.$Proxy40.logoutUser(Unknown Source)
    > >         at com.cloud.api.ApiServer.logoutUser(ApiServer.java:1104)
    > >         at com.cloud.api.ApiServlet.processRequestInContext(
    > > ApiServlet.java:234)
    > >         at com.cloud.api.ApiServlet$1.run(ApiServlet.java:130)
    > >         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 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(
    > > ServletHandler.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$
    > > ReservedThread.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.CommunicationsException:
    > > Communications link failure
    > >
    > > The last packet successfully received from the server was 94
    > > milliseconds ago.  The last packet sent successfully to the server was
    > > 93 milliseconds ago.
    > >         at
    > > sun.reflect.GeneratedConstructorAccessor96.newInstance(Unknown
    > > Source)
    > >         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(
    > > DelegatingConstructorAccessorImpl.java:45)
    > >         at java.lang.reflect.Constructor.newInstance(Constructor.java:
    > 423)
    > >         ... 82 more
    > > Caused by: java.io.EOFException: Can not read response from server.
    > > Expected to read 4 bytes, read 0 bytes before connection was
    > > unexpectedly lost.
    > >         at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3119)
    > >         at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3570)
    > >         at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3559)
    > >         ... 78 more
    > >
    > >
    > >
    > > We were able to connect to the GUI during 30 min with same kind of
    > > errors each time we tried to start an instance or VR…and it’s now
    > > impossible to connect to the GUI.
    > >
    > > Seems to be a problem with the rollback transaction but i dont know
    > > how to deal with it except  wait they finish their jobs
    > >
    > > Here log from mysqld.log :
    > >
    > > he manual page at http://dev.mysql.com/doc/mysql/en/crashing.html
    > > contains information that should help you find out what is causing the
    > crash.
    > > 180613 14:24:19 mysqld_safe Number of processes running now: 0
    > > 180613 14:24:19 mysqld_safe mysqld restarted
    > > 2018-06-13 14:24:19 0 [Warning] TIMESTAMP with implicit DEFAULT value
    > > is deprecated. Please use --explici
    > > 2018-06-13 14:24:19 0 [Note] /usr/sbin/mysqld (mysqld 5.6.39) starting
    > > as process 15999 ...
    > > 2018-06-13 14:24:19 15999 [Warning] Buffered warning: Changed limits:
    > > max_open_files: 1024 (requested 500
    > >
    > > 2018-06-13 14:24:19 15999 [Warning] Buffered warning: Changed limits:
    > > table_open_cache: 431 (requested 20
    > >
    > > 2018-06-13 14:24:19 15999 [Note] Plugin 'FEDERATED' is disabled.
    > > 2018-06-13 14:24:19 15999 [Note] InnoDB: Using atomics to ref count
    > > buffer pool pages
    > > 2018-06-13 14:24:19 15999 [Note] InnoDB: The InnoDB memory heap is
    > > disabled
    > > 2018-06-13 14:24:19 15999 [Note] InnoDB: Mutexes and rw_locks use GCC
    > > atomic builtins
    > > 2018-06-13 14:24:19 15999 [Note] InnoDB: Memory barrier is not used
    > > 2018-06-13 14:24:19 15999 [Note] InnoDB: Compressed tables use zlib
    > > 1.2.3
    > > 2018-06-13 14:24:19 15999 [Note] InnoDB: Using Linux native AIO
    > > 2018-06-13 14:24:19 15999 [Note] InnoDB: Using CPU crc32 instructions
    > > 2018-06-13 14:24:19 15999 [Note] InnoDB: Initializing buffer pool,
    > > size = 128.0M
    > > 2018-06-13 14:24:19 15999 [Note] InnoDB: Completed initialization of
    > > buffer pool
    > > 2018-06-13 14:24:19 15999 [Note] InnoDB: Highest supported file format
    > > is Barracuda.
    > > 2018-06-13 14:24:19 15999 [Note] InnoDB: Log scan progressed past the
    > > checkpoint lsn 7513843395
    > > 2018-06-13 14:24:19 15999 [Note] InnoDB: Database was not shutdown
    > > normally!
    > > 2018-06-13 14:24:19 15999 [Note] InnoDB: Starting crash recovery.
    > > 2018-06-13 14:24:19 15999 [Note] InnoDB: Reading tablespace
    > > information from the .ibd files...
    > > 2018-06-13 14:24:19 15999 [Note] InnoDB: Restoring possible
    > > half-written data pages
    > > 2018-06-13 14:24:19 15999 [Note] InnoDB: from the doublewrite buffer...
    > > InnoDB: Doing recovery: scanned up to log sequence number 7513851738
    > > 2018-06-13 14:24:19 15999 [Note] InnoDB: Starting an apply batch of
    > > log records to the database...
    > > InnoDB: Progress in percent: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
    > > 19
    > > 20 21 22 23 24 25 26 27 28 29 30 75 76 77 78 79 80 81 82 83 84 85 86
    > > 87 88
    > > 89 90 91 92 93 94 95 96 97 98 99
    > > InnoDB: Apply batch completed
    > > 2018-06-13 14:24:20 15999 [Note] InnoDB: 128 rollback segment(s) are
    > > active.
    > > 2018-06-13 14:24:20 15999 [Note] InnoDB: Waiting for purge to start
    > > 2018-06-13 14:24:20 15999 [Note] InnoDB: 5.6.39 started; log sequence
    > > number 7513851738
    > > 2018-06-13 14:24:20 15999 [Note] Server hostname (bind-address):
    > > '172.8.22.170'; port: 3306
    > > 2018-06-13 14:24:20 15999 [Note]   - '172.8.22.170' resolves to
    > > '172.8.22.170';
    > > 2018-06-13 14:24:20 15999 [Note] Server socket created on IP:
    > > '172.8.22.170'.
    > > 2018-06-13 14:24:20 15999 [Note] Event Scheduler: Loaded 0 events
    > > 2018-06-13 14:24:20 15999 [Note] /usr/sbin/mysqld: ready for connections.
    > > Version: '5.6.39'  socket: '/var/lib/mysql/mysql.sock'  port: 3306
    > > MySQL Community Server (GPL) ^C
    > > [root@FRPRCSSQB1 /]# tail -f /var/log/mysqld.log
    > > InnoDB: Apply batch completed
    > > 2018-06-13 15:28:42 17230 [Note] InnoDB: 128 rollback segment(s) are
    > > active.
    > > 2018-06-13 15:28:42 17230 [Note] InnoDB: Waiting for purge to start
    > > 2018-06-13 15:28:42 17230 [Note] InnoDB: 5.6.39 started; log sequence
    > > number 7517034692
    > > 2018-06-13 15:28:42 17230 [Note] Server hostname (bind-address):
    > > '172.8.22.170'; port: 3306
    > > 2018-06-13 15:28:42 17230 [Note]   - '172.8.22.170' resolves to
    > > '172.8.22.170';
    > > 2018-06-13 15:28:42 17230 [Note] Server socket created on IP:
    > > '172.8.22.170'.
    > > 2018-06-13 15:28:42 17230 [Note] Event Scheduler: Loaded 0 events
    > > 2018-06-13 15:28:42 17230 [Note] /usr/sbin/mysqld: ready for connections.
    > > Version: '5.6.39'  socket: '/var/lib/mysql/mysql.sock'  port: 3306
    > > MySQL Community Server (GPL)
    > >
    > > Thanks upfront for any technical help or better understanding of what
    > > is going on ;)
    > >
    > > Best regards,
    > > [ignatureBouige]
    > >
    > >
    > > Dag.Sonstebo@xxxxxxxxxxxxx
    > > www.shapeblue.com<http://www.shapeblue.com>
    > > 53 Chandos Place, Covent Garden, London  WC2N 4HSUK @shapeblue
    > >
    > >
    > >
    > >
    >
    >
    > --
    > Rafael Weingärtner
    >



    --
    Rafael Weingärtner