[otrs] DB2 - fetch failed - handles can't be shared between threads

25 Feb 2009

      Hello,

we are running OTRS 2.3.4 on debian with db2 v.9.1 Fixpack 6.

Sometimes we get the following error.

  Software error:

  DBD::DB2::dr FETCH failed: handle 1 is owned by thread db433d0 not
  current thread bb849f8 (handles can't be shared between threads and
  your driver may need a CLONE method added) at
  /usr/share/perl5/Apache/DBI.pm line 97.

  For help, please send mail to the webmaster (webmaster@localhost),
  giving this error message and the time and date of the error.

If we reload the page everything works fine.

It seems to appear only if more than one user is logged on or/and when
the generic agents are executed.

The Perl DB2-DBI is from IBM:
http://www-01.ibm.com/support/docview.wss?rs=71&uid=swg21297335

The Database config is:

  $Self->{DatabaseHost} = 'localhost';
  $Self->{Database}     = 'otrsdb';
  $Self->{DatabaseUser} = 'db2user';
  $Self->{DatabasePw}   = 'our-password';
  $Self->{DatabaseDSN}  = "DBI:DB2:$Self->{Database}";

-- 
regards
Denis Cornehl