title: Ejabberd (v2.1.13) ODBC timeout
body: <p>eJabberd Version 2.1.13</p>
  
  <p>We set up an ejabberd server as part of our app about a year ago (Oct 2013).  Shortly after going live we found issues with ejabberd messages locking up when we reached about 1,200 people online (not all of them were necessarily sending messages).</p>
  
  <p>Following much head scratching the issue was traced to a known (unresolved) bug here: <a href="https://support.process-one.net/browse/EJAB-1583" rel="nofollow">https://support.process-one.net/browse/EJAB-1583</a></p>
  
  <p>In short, an ODBC timeout of 5secs causes a total messaging downtime of 150 seconds ... this rules out the easy fix of extending the timeout because a 7 sec timeout turns into 210 second downtime etc.</p>
  
  <p>I've tried a lot of "experts" to try to find a solution, but it became apparent quite quickly that there are not many experts around.  I'm wondering if anyone has encountered this problem and found a fix, or found ways of reducing the occurances.</p>
  
  <p>The obvious answer is "upgrade", but this is a non-trivial exercise, and our key developer was poached about a year ago (we no longer have the internal expertise necessary).</p>
  
  <p>In summary the questions are:</p>
  
  <ol>
  <li>Are there any recommended configuration settings we can use to reduce this issue?</li>
  <li>Does anyone know a genuine ejabbered expert they could refer us to?</li>
  </ol>
  
  <p>Many thanks,
  David</p>