MysqlDataTruncation For Audit Log On Start/Stop

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

MysqlDataTruncation For Audit Log On Start/Stop

wbautista
When using the REST api, running start or stop plans responds with a nasty looking MysqlDataTrunctation error, yet the plan is actually exectued. The source appears to be from AuditLog, and it refers to the 'details' column. See full response below:

2015-08-05 06:41:38,633 [INFO] - gluconsole.rest.Client - executing plan: plan/c9581ec6-bd14-49fd-a686-c09c41186bba/execution
Traceback (most recent call last):
  File "./bin/../.git/glu-tools/console_cli/bin/console-cli.py", line 252, in <module>
    sys.exit(main())
  File "./bin/../.git/glu-tools/console_cli/bin/console-cli.py", line 229, in main
    result = client.executePlan(action, filter, options.parallel, options.dryrun)
  File "/home/bzapal/orbitz-fabrics/hcon_pfqa/.git/glu-tools/console_cli/lib/python/gluconsole/rest.py", line 235, in executePlan
    return self._executePlan(plan, dryrun)
  File "/home/bzapal/orbitz-fabrics/hcon_pfqa/.git/glu-tools/console_cli/lib/python/gluconsole/rest.py", line 173, in _executePlan
    planStatus = self._doRequest(planUrl, "POST")
  File "/home/bzapal/orbitz-fabrics/hcon_pfqa/.git/glu-tools/console_cli/lib/python/gluconsole/rest.py", line 87, in _doRequest
    raise restkit.errors.RequestFailed(response.body_string(), response.status_int, response)
restkit.errors.RequestFailed: <!DOCTYPE html>


<html>
<head>
  <script src="/console/plugins/jquery-1.11.1/js/jquery/jquery-1.11.1.min.js" type="text/javascript" library="jquery"></script>

  <title>[HCON_PFQA] Unexpected Error - GLU Console</title>
  <link rel="stylesheet" href="/console/css/bootstrap.min.css"/>
  <link rel="stylesheet" href="/console/css/main-glu.css"/>
  <link rel="shortcut icon" href="/console/assets/favicon-9ef27019cc7a636e29ecc851528f716e.ico" type="image/x-icon"/>
  <style type="text/css">
  
  .navbar-inner {
    background: #005a87;
    background: -webkit-gradient(linear, left top, right top, color-stop(.2, #005a87),color-stop(1, #ffffff)) fixed no-repeat 0 100%;
    background: -moz-linear-gradient(left,#005a87 20%,#ffffff) fixed no-repeat 0 100%;
  }

  .navbar .nav > li > a {
    text-shadow: 1px 1px 1px #005a87;
  }

  
  div#footer {
    margin-top: 2em;
    border-top: solid 1px #dddddd;
    text-align: right;
    font-style: italic;
    font-size: 0.8em;
    color: #aaaaaa;
  }
  #footer-text {
    position: relative;
    top: -8px;
    left: -30px;
  }
  #footer-image {
    margin-top: 2px;
  }
    ul.tags.with-links a:link, ul.tags.with-links a:visited {background: #005a87;color: #ffffff;} ul.tags.with-links a:hover {color: #005a87;background: #ffffff;} ul.tags.with-links li.tag-0 a:link, ul.tags.with-links li.tag-0 a:visited {background: #ec7000; color: #fff0e1;} ul.tags.with-links li.tag-0 a:hover { color: #ec7000; background: #fff0e1;} ul.tags.with-links li.tag-1 a:link, ul.tags.with-links li.tag-1 a:visited {background: #006633; color: #f1f5ec;} ul.tags.with-links li.tag-1 a:hover { color: #006633; background: #f1f5ec;} ul.tags.with-links li.tag-2 a:link, ul.tags.with-links li.tag-2 a:visited {background: #5229a3; color: #e0d5f9;} ul.tags.with-links li.tag-2 a:hover { color: #5229a3; background: #e0d5f9;}
  </style>
  
  
  <meta name="layout" content="main">
  <link rel="stylesheet" href="/console/assets/errors-81f3e38a6e878acd57e3d51912c37b04.css" type="text/css">

  <style type="text/css">
      #__delta_content td {
        white-space: normal !important;
        padding-top: 1px;
        padding-bottom: 2px;
      }
     
      #__delta_content td ul li {
        display: inline-block;
      }
     
      #__delta_content tr:hover td {
        background-color:rgba(0,0,0,0.2);
      }
     
      .container tr:hover td {
        background-color:rgba(0,0,0,0.2);
      }
      </style>
  <r:layoutResources/>
  <script type="text/javascript" src="/console/js/bootstrap.min.js"></script>
  <script type="text/javascript" src="/console/js/console_jquery.js"></script>
</head>
<body onload="">


<div class="container">
<div class="navbar navbar-fixed-top">
  <div class="navbar-inner">
      <ul class="nav">
        <li  id="tab-dashboard"><a href="/console/dashboard?fabric=HCON_PFQA">Dashboard</a></li>
        <li  id="tab-agents"><a href="/console/agents?fabric=HCON_PFQA">Agents</a></li>
        
          <li  id="tab-plans"><a href="/console/plan/deployments?fabric=HCON_PFQA">Deployments</a></li>
          <li  id="tab-model"><a href="/console/model/list?fabric=HCON_PFQA">Model</a></li>
        
        <li  id="tab-admin"><a href="/console/admin?fabric=HCON_PFQA">Admin</a></li>
        <li  id="tab-home"><a href="/console/home?fabric=HCON_PFQA"><span id="tab-home-username">bzapal</span></a></li>
        <li  id="tab-help"><a href="/console/help?fabric=HCON_PFQA">Help</a></li>
      </ul>
      <ul class="nav pull-right">
        
        <li class="dropdown"><a href="#" class="dropdown-toggle" data-toggle="dropdown">HCON_PFQA<b class="caret"></b></a><ul class="dropdown-menu"><li><a href="/console/dashboard?fabric=ANS_PFQA">ANS_PFQA</a></li><li><a href="/console/dashboard?fabric=APT_PFQA">APT_PFQA</a></li><li><a href="/console/dashboard?fabric=ARCHITECT_PFQA">ARCHITECT_PFQA</a></li><li><a href="/console/dashboard?fabric=ASUP_PFQA">ASUP_PFQA</a></li><li><a href="/console/dashboard?fabric=ATC_PFQA">ATC_PFQA</a></li><li><a href="/console/dashboard?fabric=AWAY_PFQA">AWAY_PFQA</a></li><li><a href="/console/dashboard?fabric=BI-MODA_PFQA">BI-MODA_PFQA</a></li><li><a href="/console/dashboard?fabric=CAR_PFQA">CAR_PFQA</a></li><li><a href="/console/dashboard?fabric=CD_PFQA">CD_PFQA</a></li><li><a href="/console/dashboard?fabric=CORE_DEV">CORE_DEV</a></li><li><a href="/console/dashboard?fabric=CS_PFQA">CS_PFQA</a></li><li><a href="/console/dashboard?fabric=EBSUP_PFQA">EBSUP_PFQA</a></li><li><a href="/console/dashboard?fabric=EMKTC_PFQA">EMKTC_PFQA</a></li><li><a href="/console/dashboard?fabric=FALCONS_PFQA">FALCONS_PFQA</a></li><li><a href="/console/dashboard?fabric=FCP_PFQA">FCP_PFQA</a></li><li><a href="/console/dashboard?fabric=FCT_PFQA">FCT_PFQA</a></li><li><a href="/console/dashboard?fabric=FDP_PFQA">FDP_PFQA</a></li><li><a href="/console/dashboard?fabric=FINANCE_PFQA">FINANCE_PFQA</a></li><li><a href="/console/dashboard?fabric=FUEL_PFQA">FUEL_PFQA</a></li><li><a href="/console/dashboard?fabric=FUNNEL_PFQA">FUNNEL_PFQA</a></li><li><a href="/console/dashboard?fabric=GLAD_PFQA">GLAD_PFQA</a></li><li><a href="/console/dashboard?fabric=GO_PFQA">GO_PFQA</a></li><li><a href="/console/dashboard?fabric=HCLUB_PFQA">HCLUB_PFQA</a></li><li><a href="/console/dashboard?fabric=HCON_PFQAB">HCON_PFQAB</a></li><li><a href="/console/dashboard?fabric=HCON_PFQAC">HCON_PFQAC</a></li><li><a href="/console/dashboard?fabric=HCORE_PFQA">HCORE_PFQA</a></li><li><a href="/console/dashboard?fabric=HCORE_PFQA-CI">HCORE_PFQA-CI</a></li><li><a href="/console/dashboard?fabric=HCSL_PFQA">HCSL_PFQA</a></li><li><a href="/console/dashboard?fabric=HDP_POC">HDP_POC</a></li><li><a href="/console/dashboard?fabric=HEAT_PFQA">HEAT_PFQA</a></li><li><a href="/console/dashboard?fabric=HERD_PFQA">HERD_PFQA</a></li><li><a href="/console/dashboard?fabric=HEXT_PFQA">HEXT_PFQA</a></li><li><a href="/console/dashboard?fabric=HEXT_PFQA-CI">HEXT_PFQA-CI</a></li><li><a href="/console/dashboard?fabric=HKB_PFQA">HKB_PFQA</a></li><li><a href="/console/dashboard?fabric=HLOC_PFQA">HLOC_PFQA</a></li><li><a href="/console/dashboard?fabric=HLP_PFQA">HLP_PFQA</a></li><li><a href="/console/dashboard?fabric=HMS_PFQA">HMS_PFQA</a></li><li><a href="/console/dashboard?fabric=HOTEL-FE_PFQA">HOTEL-FE_PFQA</a></li><li><a href="/console/dashboard?fabric=HRM_PFQA">HRM_PFQA</a></li><li><a href="/console/dashboard?fabric=ICEMAN_PFQA">ICEMAN_PFQA</a></li><li><a href="/console/dashboard?fabric=ICON_PFQA">ICON_PFQA</a></li><li><a href="/console/dashboard?fabric=INS_PFQA">INS_PFQA</a></li><li><a href="/console/dashboard?fabric=ISM_PFQA">ISM_PFQA</a></li><li><a href="/console/dashboard?fabric=JTG_PFQA">JTG_PFQA</a></li><li><a href="/console/dashboard?fabric=LION_PFQA">LION_PFQA</a></li><li><a href="/console/dashboard?fabric=LION_PFQA_TWO">LION_PFQA_TWO</a></li><li><a href="/console/dashboard?fabric=LOYL_PFQA">LOYL_PFQA</a></li><li><a href="/console/dashboard?fabric=LOYL_PFQA_TWO">LOYL_PFQA_TWO</a></li><li><a href="/console/dashboard?fabric=MAD_PFQA">MAD_PFQA</a></li><li><a href="/console/dashboard?fabric=MAVERICK_PFQA">MAVERICK_PFQA</a></li><li><a href="/console/dashboard?fabric=ML_PFQA">ML_PFQA</a></li><li><a href="/console/dashboard?fabric=MSG_PFQA">MSG_PFQA</a></li><li><a href="/console/dashboard?fabric=NEAT_PFQA">NEAT_PFQA</a></li><li><a href="/console/dashboard?fabric=NUCU_PFQA">NUCU_PFQA</a></li><li><a href="/console/dashboard?fabric=OFB_PFQA">OFB_PFQA</a></li><li><a href="/console/dashboard?fabric=OGRE_PFQA">OGRE_PFQA</a></li><li><a href="/console/dashboard?fabric=OGRE_PFQA-THREE">OGRE_PFQA-THREE</a></li><li><a href="/console/dashboard?fabric=OGRE_PFQA-TWO">OGRE_PFQA-TWO</a></li><li><a href="/console/dashboard?fabric=OLB_PFQA">OLB_PFQA</a></li><li><a href="/console/dashboard?fabric=ORION_PFQA">ORION_PFQA</a></li><li><a href="/console/dashboard?fabric=PARTNER_PORTAL_PFQA">PARTNER_PORTAL_PFQA</a></li><li><a href="/console/dashboard?fabric=PERCS_PFQA">PERCS_PFQA</a></li><li><a href="/console/dashboard?fabric=PI_PFQA">PI_PFQA</a></li><li><a href="/console/dashboard?fabric=QCORE_PFQA">QCORE_PFQA</a></li><li><a href="/console/dashboard?fabric=RAIL_PFQA">RAIL_PFQA</a></li><li><a href="/console/dashboard?fabric=REDARROWS_PFQA">REDARROWS_PFQA</a></li><li><a href="/console/dashboard?fabric=SAO_PFQA">SAO_PFQA</a></li><li><a href="/console/dashboard?fabric=SATELLITE_PFQA">SATELLITE_PFQA</a></li><li><a href="/console/dashboard?fabric=SAT_PFQA">SAT_PFQA</a></li><li><a href="/console/dashboard?fabric=SEAL_PFQA">SEAL_PFQA</a></li><li><a href="/console/dashboard?fabric=SERVICING_PFQA">SERVICING_PFQA</a></li><li><a href="/console/dashboard?fabric=SLIANG_PFQA">SLIANG_PFQA</a></li><li><a href="/console/dashboard?fabric=SLR_PFQA">SLR_PFQA</a></li><li><a href="/console/dashboard?fabric=SORT_PFQA">SORT_PFQA</a></li><li><a href="/console/dashboard?fabric=SPAR_PFQA">SPAR_PFQA</a></li><li><a href="/console/dashboard?fabric=SRE_PFQA">SRE_PFQA</a></li><li><a href="/console/dashboard?fabric=TIC_PFQA">TIC_PFQA</a></li><li><a href="/console/dashboard?fabric=TNM_PFQA">TNM_PFQA</a></li><li><a href="/console/dashboard?fabric=TNT_PFQA">TNT_PFQA</a></li><li><a href="/console/dashboard?fabric=TOTORO_PFQA">TOTORO_PFQA</a></li><li><a href="/console/dashboard?fabric=TPC_PFQA">TPC_PFQA</a></li><li><a href="/console/dashboard?fabric=UGC_PFQA">UGC_PFQA</a></li><li><a href="/console/dashboard?fabric=UI_PFQA">UI_PFQA</a></li><li><a href="/console/dashboard?fabric=WEB-SERVICES_PFQA">WEB-SERVICES_PFQA</a></li><li><a href="/console/dashboard?fabric=WRSVR_PFQA">WRSVR_PFQA</a></li><li><a href="/console/dashboard?fabric=XPL_PFQA">XPL_PFQA</a></li><li><a href="/console/dashboard?fabric=ZETA_PFQA">ZETA_PFQA</a></li></ul></li>
        
        
          
            
              
            
          
        
      </ul>
    </div>
  </div>
</div>

<div class="container">
  

  

  

  

  



  

  <h2>An unexpected error has occurred <a href="#" onclick="toggleShowHide('#exceptionDetails');return false;"><i class="icon-info-sign"> </i></a></h2>
  <div id="exceptionDetails" class="hidden">
    <h1>Error 500: Internal Server Error</h1>
<dl class="error-details">
<dt>URI</dt><dd>/console/rest/v1/HCON_PFQA/plan/c9581ec6-bd14-49fd-a686-c09c41186bba/execution</dd>
<dt>Class</dt><dd>com.mysql.jdbc.MysqlDataTruncation</dd><dt>Message</dt><dd>Data truncation: Data too long for column &#39;details&#39; at row 1</dd></dl><h2>Trace</h2><pre class="stack">    Line | Method
-&gt;&gt; 4206 | checkErrorPacket           in com.mysql.jdbc.MysqlIO
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
|   4140 | checkErrorPacket           in     &#39;&#39;
|   2597 | sendCommand . . . . . . .  in     &#39;&#39;
|   2758 | sqlQueryDirect             in     &#39;&#39;
|   2826 | execSQL . . . . . . . . .  in com.mysql.jdbc.ConnectionImpl
|   2082 | executeInternal            in com.mysql.jdbc.PreparedStatement
|   2334 | executeUpdate . . . . . .  in     &#39;&#39;
|   2262 | executeUpdate              in     &#39;&#39;
|   2246 | executeUpdate . . . . . .  in     &#39;&#39;
|     66 | doCall                     in org.linkedin.glu.console.domain.AuditLog$_audit_closure1
|    815 | withTransaction . . . . .  in org.grails.datastore.gorm.GormStaticApi
|    715 | withTransaction            in     &#39;&#39;
|     65 | audit . . . . . . . . . .  in org.linkedin.glu.console.domain.AuditLog
|     85 | audit                      in     &#39;&#39;
|    113 | audit . . . . . . . . . .  in     &#39;&#39;
|     35 | audit                      in org.linkedin.glu.console.provisioner.services.audit.AuditLogServiceImpl
|     58 | auditExecuteDeploymentPlan in org.linkedin.glu.orchestration.engine.deployment.AuditedDeploymentService
|     52 | executeDeploymentPlan      in     &#39;&#39;
|    522 | doCall . . . . . . . . . . in org.linkedin.glu.console.controllers.PlanController$_closure20
|    669 | handle                     in org.eclipse.jetty.servlet.ServletHolder
|   1448 | doFilter . . . . . . . . . in org.eclipse.jetty.servlet.ServletHandler$CachedChain
|    198 | doFilter                   in grails.plugin.cache.web.filter.PageFragmentCachingFilter
|     63 | doFilter . . . . . . . . . in grails.plugin.cache.web.filter.AbstractFilter
|   1419 | doFilter                   in org.eclipse.jetty.servlet.ServletHandler$CachedChain
|    455 | doHandle . . . . . . . . . in org.eclipse.jetty.servlet.ServletHandler
|    137 | handle                     in org.eclipse.jetty.server.handler.ScopedHandler
|    575 | handle . . . . . . . . . . in org.eclipse.jetty.security.SecurityHandler
|    231 | doHandle                   in org.eclipse.jetty.server.session.SessionHandler
|   1075 | doHandle . . . . . . . . . in org.eclipse.jetty.server.handler.ContextHandler
|    384 | doScope                    in org.eclipse.jetty.servlet.ServletHandler
|    193 | doScope . . . . . . . . .  in org.eclipse.jetty.server.session.SessionHandler
|   1009 | doScope                    in org.eclipse.jetty.server.handler.ContextHandler
|    135 | handle . . . . . . . . . . in org.eclipse.jetty.server.handler.ScopedHandler
|    276 | forward                    in org.eclipse.jetty.server.Dispatcher
|    103 | forward . . . . . . . . .  in     &#39;&#39;
|   1419 | doFilter                   in org.eclipse.jetty.servlet.ServletHandler$CachedChain
|    449 | executeChain . . . . . . . in org.apache.shiro.web.servlet.AbstractShiroFilter
|    365 | call                       in org.apache.shiro.web.servlet.AbstractShiroFilter$1
|     90 | doCall . . . . . . . . . . in org.apache.shiro.subject.support.SubjectCallable
|     83 | call                       in     &#39;&#39;
|    383 | execute . . . . . . . . .  in org.apache.shiro.subject.support.DelegatingSubject
|    362 | doFilterInternal           in org.apache.shiro.web.servlet.AbstractShiroFilter
|    125 | doFilter . . . . . . . . . in org.apache.shiro.web.servlet.OncePerRequestFilter
|   1419 | doFilter                   in org.eclipse.jetty.servlet.ServletHandler$CachedChain
|    455 | doHandle . . . . . . . . . in org.eclipse.jetty.servlet.ServletHandler
|    137 | handle                     in org.eclipse.jetty.server.handler.ScopedHandler
|    533 | handle . . . . . . . . . . in org.eclipse.jetty.security.SecurityHandler
|    231 | doHandle                   in org.eclipse.jetty.server.session.SessionHandler
|   1075 | doHandle . . . . . . . . . in org.eclipse.jetty.server.handler.ContextHandler
|    384 | doScope                    in org.eclipse.jetty.servlet.ServletHandler
|    193 | doScope . . . . . . . . .  in org.eclipse.jetty.server.session.SessionHandler
|   1009 | doScope                    in org.eclipse.jetty.server.handler.ContextHandler
|    135 | handle . . . . . . . . . . in org.eclipse.jetty.server.handler.ScopedHandler
|    255 | handle                     in org.eclipse.jetty.server.handler.ContextHandlerCollection
|    154 | handle . . . . . . . . . . in org.eclipse.jetty.server.handler.HandlerCollection
|    116 | handle                     in org.eclipse.jetty.server.handler.HandlerWrapper
|    368 | handle . . . . . . . . . . in org.eclipse.jetty.server.Server
|    489 | handleRequest              in org.eclipse.jetty.server.AbstractHttpConnection
|    942 | headerComplete . . . . . . in     &#39;&#39;
|   1004 | headerComplete             in org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler
|    640 | parseNext . . . . . . . .  in org.eclipse.jetty.http.HttpParser
|    235 | parseAvailable             in     &#39;&#39;
|     82 | handle . . . . . . . . . . in org.eclipse.jetty.server.AsyncHttpConnection
|    196 | handle                     in org.eclipse.jetty.io.nio.SslConnection
|    628 | handle . . . . . . . . . . in org.eclipse.jetty.io.nio.SelectChannelEndPoint
|     52 | run                        in org.eclipse.jetty.io.nio.SelectChannelEndPoint$1
|    608 | runJob . . . . . . . . . . in org.eclipse.jetty.util.thread.QueuedThreadPool
|    543 | run                        in org.eclipse.jetty.util.thread.QueuedThreadPool$3
^    722 | run . . . . . . . . . . .  in java.lang.Thread
</pre>
  </div>


  <r:layoutResources/>
</div>
<div id="footer">
  <div id="footer-image"><img src="/console/images/glu_100_white.png" alt="glu deployment automation platform"/></div>
  <div id="footer-text">GLU Console - 5.6.1</div>
</div>
</body>
</html>
Reply | Threaded
Open this post in threaded view
|

Re: MysqlDataTruncation For Audit Log On Start/Stop

frenchyan
Administrator

​This is the same issue as was reported a few days ago and is being tracked there: https://github.com/pongasoft/glu/issues/305

See the forum thread: http://glu.977617.n3.nabble.com/Data-truncation-Data-too-long-for-column-details-td4026939.html for a workaround in the meantime (increase the details column size).

Yan
Reply | Threaded
Open this post in threaded view
|

Re: MysqlDataTruncation For Audit Log On Start/Stop

wbautista
Thanks, Yan!