Hi,   We are also getting the same error almost every week for any database. Can we get any permanent solution for this? After waiting for sometime it get resolved itself. But i want to know the root cause for this and if it database or table gets locked, how i can release that lock for those DB and table in MySQL database. ... View more

Thanks for the information Steven. I will be visiting the options you provided and see if I can make a progress hoping not to break the things. Do you know if in a future release of HDP will cover this vulnerability ? And again,  thanks a lot for your inputs.     ... View more

@RajeshLuckky  If you follow the original post,  you need the ssl key and cert in the jdbc string.   "At Nifi level make sure the cert file(s) are owned to nifi user".   For example, if you create the cert and key files in the folder /etc/nifi/ssl/ then you would execute: chown -R nifi:nifi /etc/nifi/ssl/   This will own the files to nifi so the nifi user can read them.  ... View more

@math23    No,  you can also just copy the service directly into your ambari.  I suggest this way if you can't easily get a newer cluster.      I tried to point you at how to install the custom service in the accepted solution.    A management pack just makes that task a lil easier, as well as being applicable to different stack versions.     ... View more

Yah I can understand that. Recently working with 580 columns. Nifi is definitely the solution you want look at. ... View more

Thanks a Lot Steven , will go through the same . Will come back to you by any chance If i have any doubt  . ... View more

Thank you it worked. I also used "1" for the number to make it work but it indeed worked. ... View more

"UpdateRecord" processor with below syntax resolved the issue. ${field.value:toDate("EEE MMM dd HH:mm:ss z yyyy"):format("yyyy-MM-dd HH:mm:ss")} ... View more

<edit> Sorry I thought this was a new post.  @guido please do not respond to old posts with new solutions.   Ambari 2.6.0 Bug is not applicable here.     @apappu The version on the end of the package is how they handled having multiple versions available in the repos as well as facilitating the upgrade process from one version to another.   Using the variable scope in the python allowed ambari code to be dynamic across all the different versions, environments, etc.   If your repos are setup right, this should not be an issue.  I have seen some failure in the public repos lately, slow to respond, or blocked by certain cloud providers causing the "no package found" errors.     If you are running your own private repos and have an issue like this, you can just create the packages you need in the version you want using the rpmrebuild command on an existing rpm.  ... View more

@stevenmatison    I still haven't had any luck with this at all. Do you know if an error on one specific file could cause the entire process to crash and not complete or does it attempt to skip over bad files? ... View more