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

  • 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.

Search Words

Can't obtain mutex

Error-TEXT: 34:48] [FATAL] [9329] [Error::throw] URI handler (HSPC::Billing::Subscription->teaser_office) error: Can't obtain mutex 'subscr_034670' during timeout 60 seconds

subscr_

Change End date

624ca542e40215e6f1d39170d8e7ec75 caea8340e2d186a540518d08602aa065 400e18f6ede9f8be5575a475d2d6b0a6 70a5401e8b9354cd1d64d0346f2c4a3e

Email subscription for changes to this article
Save as PDF