Article ID: 129209, created on Aug 3, 2016, last review on Apr 11, 2017

  • Applies to:
  • Odin Business Automation Standard 4.5

Symptoms

Upon clicking Change End date on a subscription screen the following error emerges:

    [2016/07/25 11:47:20] [FATAL] [9714] [Error::throw] URI handler (HSPC::Billing::Subscription->teaser_office) error: Can't obtain mutex 'subscr_034670' during timeout 60 seconds (See /var/log/hspc/rep2016-07-25_11-47-20 for details)

Cause

The most probable issue cause is low MySQL performance caused by long running SQL queries.

Resolution

To resolve the issue, please enable slow query logging in /etc/my.cnf

    #vi /etc/my.cnf

    [mysqld]
    long_query_time = 60
    log-slow-queries = /tmp/mysql-slow.log   

and restart MySQL for the changes to come into force:

    #service mysql restart

Reproduce the issue and check /tmp/mysql-slow.log for the queries that cause the delay. If MySQL proves to be the issue cause, check OBAS is slow because of MySQL performance for solution.

624ca542e40215e6f1d39170d8e7ec75 caea8340e2d186a540518d08602aa065 400e18f6ede9f8be5575a475d2d6b0a6 70a5401e8b9354cd1d64d0346f2c4a3e

Email subscription for changes to this article
Save as PDF