Skip to Content
avatar image
Former Member

JDBC SENDER CHANNELS FREQUENTLY GETTING LOCKED

Hi Experts

We have multiple interfaces between 3rd party system which are running on oracle,SQL and my SQL database.

In our production system we are facing jdbc sender channel locking frequently at least a single channel gets locked in a day.we are manually removing the locks from visual admin.

May I know the reason why these channels are getting locked?

What is the best approach to be followed in order to get rid of these lock?

This is happening from past one week.

Regards

Nagur

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Mar 01, 2016 at 01:17 PM

    Hello Nagur,

    Refer the note-821267,should be helpful.

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Nagur,

      Refer the below discussion and note-1083488

      @Engg Thanks for pointing. Always helpful .  😊

      While copying this note-1083488,copied by that one by mistake in dashboard. that's for File locking and other issues.

  • Mar 02, 2016 at 06:23 AM

    Nagur,

    Please collect data, which channels are getting locked, when they are getting locked, are they getting locked in lower environments. Collect this information over a period of time (3-4 days). Once there is pattern, it would be easy to find root cause.

    Usually JDBC channel get locked when multiple PI node or channel try to access same table OR due to network issues.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks Raghu

      We have two nodes in our production server it may be one of the cause.

      Regards

      Nagur

  • Mar 02, 2016 at 07:28 AM

    Hi Nagur,

    I use the option of Disconnect from Database After Processing Each Message to avoid the session can be keep hang, however if you have a little poll time, this could affect to the performance. Have you talked with the DB team in order to know if they have an huge number of connections opened?

    If you talk with the SAP guys the probably will recommend to you to recollect traces with the XPI inspector.

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 02, 2016 at 07:47 AM

    Hi Nagur,

    Set the additional parameter clusterSyncMode to lock as per this sap note 801367 - XI 3.0 JDBC Adapter: Additional Parameters


    "lock": This option will ensure that there is only one instance of the channel running across server node. When this option is set, JDBC adapter acquires an enqueue service lock on the server node. Lock is taken on channel object and it is exclusive and non-cumulative such that no second instance (even it is from the same channel) can fetch the data from configured Database tables unless and until first instance has completed (success/fail) it’s processing. Another key aspect of this setting is that, the polling is submitted to all the server nodes. Therefore, the processing happens at all server nodes depending on the lock acquired by the instance.

    Regards,

    Praveen.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks Inaki and praveen

      I have checked disconnect the database after each transaction.

      It was not happening previously we are facing the issue from past one week.

      The only problem is we have around 250 sender JDBC channels setting the parameter in all the channels is complex.

      For now i have created a copy of the channel and replace in the sender agreement.

      Regards

      Nagur

  • Mar 02, 2016 at 10:21 AM

    Hello Nagur,

    You may wish to check the note #1510659 Improvement in Locking Logging and Monitoring in JDBC.

    Regards

    Eoin

    Add comment
    10|10000 characters needed characters exceeded