RE: [otrs] Disconnect invalidates 1 active statement handle

Never mind, I think I got it. I came across bug 1231 from http://bugs.otrs.org/show_bug.cgi?id=1231. I changed the code as indicated and the problem seems to be resolved. -Dave --- Kernel/System/DB.pm.old Wed Jun 14 15:45:49 2006 +++ Kernel/System/DB.pm Wed Jun 14 15:43:12 2006 @@ -217,6 +217,7 @@ ); } # do disconnect + $Self->{Curser}->finish() if (defined($Self->{Curser})); $Self->{dbh}->disconnect() if ($Self->{dbh}); return 1; } -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of David Hatcher Sent: Monday, January 29, 2007 2:50 PM To: User questions and discussions about OTRS.org Subject: [otrs] Disconnect invalidates 1 active statement handle Hello, Every 10 minutes I receive the message "You have new mail in /var/spool/mail/root." The mail indicates the following line. DBI::db=HASH(0xa185448)->disconnect invalidates 1 active statement handle (either destroy statement handles or call finish on them before disconnecting) at /opt/otrs/Kernel/System/DB.pm line 222, <PRODUCT> line 4. I can see line 222 as... $Self->{dbh}->disconnect() if ($Self->{dbh}); ...but how does this relate to line 4 and how do I fix this problem? Thanks, David [root@raidsrv04 mail]# You have new mail in /var/spool/mail/root

From otrs@raidsrv04.tanner.com Mon Jan 29 14:40:04 2007 Return-Path: Received: from raidsrv04.tanner.com (localhost.localdomain [127.0.0.1]) by raidsrv04.tanner.com (8.13.8/8.13.8) with ESMTP id l0TMe3uf025169 for ; Mon, 29 Jan 2007 14:40:03 -0800 Received: (from otrs@localhost) by raidsrv04.tanner.com (8.13.8/8.13.8/Submit) id l0TMe3tJ025166; Mon, 29 Jan 2007 14:40:03 -0800 Date: Mon, 29 Jan 2007 14:40:03 -0800 Message-Id: <200701292240.l0TMe3tJ025166@raidsrv04.tanner.com> From: root@raidsrv04.tanner.com (Cron Daemon) To: root@raidsrv04.tanner.com Subject: Cron $HOME/bin/GenericAgent.pl -c db >> /dev/null Content-Type: text/plain; charset=UTF-8 Auto-Submitted: auto-generated X-Cron-Env: X-Cron-Env: X-Cron-Env: X-Cron-Env: X-Cron-Env: X-Cron-Env:

DBI::db=HASH(0xa185448)->disconnect invalidates 1 active statement handle (either destroy statement handles or call finish on them before disconnecting) at /opt/otrs/Kernel/System/DB.pm line 222, <PRODUCT> line 4. _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support orr consulting for your OTRS system? =http://www.otrs.com/