Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Table lock for logging tables times out...

  1. #1
    Join Date
    Sep 2011
    Posts
    190

    Question Table lock for logging tables times out...

    I keep getting these random errors from Kettle (kitchen) where Kettle (pdi-ce-4.1.0-stable; MySQL 5.1.52) seems to want to lock an entire logging table before writing the log records.

    Can I change this behaviour somehow? Apparently it's not working as planned.

    Code:
    ERROR 07-11 08:02:12,672 - dwh_dim_contractStatus - org.pentaho.di.core.exception.KettleException: 
    Unable to perform logging at the end of the transformation
    
    Error writing log record to table [aud_translog]
    
    Unable to write log record to log table aud_translog
    
    Couldn't execute SQL: UPDATE aud_translog SET CHANNEL_ID=? , TRANSNAME=? , STATUS=? , LINES_READ=? , LINES_WRITTEN=? , LINES_UPDATED=? , LINES_INPUT=? , LINES_OUTPUT=? , LINES_REJECTED=? , ERRORS=? , STARTDATE=? , ENDDATE=? , LOGDATE=? , DEPDATE=? , REPLAYDATE=? , LOG_FIELD=? WHERE ID_BATCH=? 
    
    Lock wait timeout exceeded; try restarting transaction
    Last edited by mbvt; 11-07-2011 at 05:57 AM.

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

  3. #3
    Join Date
    Sep 2011
    Posts
    190

    Default

    thx!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.