Article ID: 123501, created on Nov 12, 2014, last review on Nov 12, 2014

  • Applies to:
  • Virtual Automation 6.0

Symptoms

"Logs" tab in the PVA MN cannot be opened, the following error message is displayed:

Application Error
The server has encountered an internal error or misconfiguration.
Contact your support representative.

In the "/var/log/pva/cc/yyyy.mm.dd-cpcon.log" on PVA MN node similar error messages can be found:

...
11/11/2014 12:28:59.8605750 [14370] : void xslElemDie(xsltTransformContext*, xmlNode*, xmlNode*, xsltElemPreComp*) at xslext/xslutils.cpp:231 : sw:die : message:

                        Error occured in VZAgent pager2 operator:
                        <error>
  <code>1</code>
  <message>Internal error: DB Error 1205 (Lock wait timeout exceeded; try restarting transaction) in query
^H
INSERT AceToken (operation, resultingRule, objId) SELECT DISTINCT operation, resultingRule, objId FROM Ace WHERE (sid in ('AQUAAAAAIAEfKh7WKMRHkLsP6ttrsSJQAQAAAA==','AQUAAAAAIAHS4Eybb+BPvron8SzG2i0BAQAAAA==')) AND (operation in (54))

</message>
</error>
11/11/2014 12:28:59.8615980 [14370] : VZAXML* TransformationManager::apply_stylesheet(boost::intrusive_ptr<VZCPDocumentPrototypeT<xslDocumentTraits> >, VZL::VZLMessage*) at TransformationManager.cpp:877 : XSLT processor error state 2.
11/11/2014 12:28:59.8616450 [14370] : int WebCP::httpScreen(std::string, VZL::VZLMessage*) at WebCP.cpp:1019 : Can't process output XSL transformation for screens/core/folders/tasks.xsl

Note: "Internal error: DB Error 1205 (Lock wait timeout exceeded;try restarting transaction) in query" is the most important part of the log snippet above.

Cause

There is a hanged MySQL transaction that results in a deadlock in the PVA MN database.

Resolution

  1. Login to the PVA MN node/container
  2. Open the PVA MN database:

    # mysql -uroot VZAgentDB
    
  3. Check the running transactions:

    mysql> show processlist;
    +----+------+-----------------+-----------+---------+--------+--------------+------------------------------------------------------------------------------------------------------+
    | Id | User | Host            | db        | Command | Time   | State        | Info                                                                                                 |
    +----+------+-----------------+-----------+---------+--------+--------------+------------------------------------------------------------------------------------------------------+
    |  3 | root | localhost:56465 | VZAgentDB | Sleep   |     20 |              | NULL                                                                                                 |
    |  4 | root | localhost:56466 | VZAgentDB | Sleep   |      6 |              | NULL                                                                                                 |
    |  5 | root | localhost:56467 | VZAgentDB | Sleep   |   2563 |              | NULL                                                                                                 |
    |  7 | root | localhost:56498 | VZAgentDB | Sleep   |     48 |              | NULL                                                                                                 |
    | 10 | root | localhost:56700 | VZAgentDB | Sleep   |    101 |              | NULL                                                                                                 |
    | 11 | root | localhost:56836 | VZAgentDB | Sleep   |      6 |              | NULL                                                                                                 |
    | 13 | root | localhost:57029 | VZAgentDB | Sleep   |      6 |              | NULL                                                                                                 |
    | 19 | root | localhost:57618 | VZAgentDB | Query   | 121507 | Sending data | SELECT T11550880.id, T11550880.op, T11550880.origin_eid, T11550880.origin_title, T11550880.principal |
    | 20 | root | localhost:58009 | VZAgentDB | Sleep   |    106 |              | NULL                                                                                                 |
    | 21 | root | localhost:58011 | VZAgentDB | Sleep   |    105 |              | NULL                                                                                                 |
    | 27 | root | localhost:44840 | VZAgentDB | Sleep   |   1606 |              | NULL                                                                                                 |
    | 61 | root | localhost:52942 | VZAgentDB | Sleep   |   1021 |              | NULL                                                                                                 |
    | 62 | root | localhost:52946 | VZAgentDB | Sleep   |    685 |              | NULL                                                                                                 |
    | 74 | root | localhost:55824 | VZAgentDB | Sleep   |   1021 |              | NULL                                                                                                 |
    | 75 | root | localhost:55833 | VZAgentDB | Sleep   |    275 |              | NULL                                                                                                 |
    | 76 | root | localhost:55834 | VZAgentDB | Sleep   |    224 |              | NULL                                                                                                 |
    | 77 | root | localhost:55840 | VZAgentDB | Sleep   |    278 |              | NULL                                                                                                 |
    | 78 | root | localhost:55848 | VZAgentDB | Sleep   |    969 |              | NULL                                                                                                 |
    | 79 | root | localhost:44691 | VZAgentDB | Sleep   |    572 |              | NULL                                                                                                 |
    | 80 | root | localhost       | VZAgentDB | Query   |      0 | NULL         | show processlist                                                                                     |
    +----+------+-----------------+-----------+---------+--------+--------------+------------------------------------------------------------------------------------------------------+
    20 rows in set (0.00 sec)
    
  4. Check if the connection for the querying transactions is actually opened - e.g. in the example above it is necessary to check the transaction id 19 - on port 57618:

    # netstat -antpl  | grep 57618
    
  5. If you do not see an open connection - kill the transaction:

    mysql> kill 19;
    Query OK, 0 rows affected (0.00 sec)
    

Search Words

Application Error The server has encountered an internal error or misconfiguration. Contact your support representative.

Lock wait timeout exceeded; try restarting transaction) in query

Internal error: DB Error 1205

DB Error 1205

application error

319940068c5fa20655215d590b7be29b 2897d76d56d2010f4e3a28f864d69223 0889ab60fa6494de107aa7338c3c38b6

Email subscription for changes to this article
Save as PDF