Problems with Debian-package libdbd-mysql perl 3.0004-1

Hi all, I only want to announce, that there will occur problems when upgrading from libdbd-mysql-perl_3.0002-2 to libdbd-mysql-perl_3.0004-1. The Cron-Jobs will result in a error: DBI::db=HASH(0x1552de0)->disconnect invalidates 1 active statement handle (either destroy statement handles or call finish on them before disconnecting) at /usr/share/otrs/Kernel/System/DB.pm line 273. I am using the testing otrs-package 1:1.3.3p01-1 with Debian testing and MySQL4. But I want to complain about the official support of the otrs-Group. I phoned the OTRS.de-firm and asked about support (I didn't know at this moment, that my admin updated the perl-lib). They told me to sign a 1500 EUR contract for one year. But I didnt want to have support for one year. I only want to support for this problem. I know many other OS-projects where you get support for only one problem and only one day. Perhaps the support team would make more money with this kind of giving support. I searched all the web to get a solutions for this problem but I didn't found one. Even the mailing list doesn't have one. So support crew get more flexibel (other are more flexibel at the moment). Regards Alexander Maringer

Hello Alexander, On Mi, Jun 07, 2006 at 02:13:25 +0200, Alexander Maringer wrote:
I only want to announce, that there will occur problems when upgrading from libdbd-mysql-perl_3.0002-2 to libdbd-mysql-perl_3.0004-1.
The Cron-Jobs will result in a error: DBI::db=HASH(0x1552de0)->disconnect invalidates 1 active statement handle (either destroy statement handles or call finish on them before disconnecting) at /usr/share/otrs/Kernel/System/DB.pm line 273.
I am using the testing otrs-package 1:1.3.3p01-1 with Debian testing and MySQL4.
I can reproduce this problems. With OTRS 2.0.4 and mysql 5.0 it looks like this: DBI::db=HASH(0x8c4272c)->disconnect invalidates 1 active statement handle (either destroy statement handles or call finish on them before disconnecting) at /home/cs/src/otrs/Kernel/System/DB.pm line 219, <PRODUCT> line 2. It helped to comment out line 219 in Kernel/System/DB.pm but we have to research the issue further more. I opened a bug report on this issue: http://bugs.otrs.org/show_bug.cgi?id=1231
But I want to complain about the official support of the otrs-Group. I phoned the OTRS.de-firm and asked about support (I didn't know at this moment, that my admin updated the perl-lib). They told me to sign a 1500 EUR contract for one year. But I didnt want to have support for one year. I only want to support for this problem.
At the moment we offer support this way only, sorry.
I know many other OS-projects where you get support for only one problem and only one day. Perhaps the support team would make more money with this kind of giving support.
We will restruture our support packages in the near future and I'm sure that getting support for one issue or for one day only will be possible then.
Alexander Maringer
Regards, Christian -- ((otrs)) :: OTRS GmbH :: Europaring 4 :: D - 94315 Straubing Fon: +49 (0) 9421 1862 760 :: Fax: +49 (0) 9421 1862 769 http://www.otrs.com/ :: Communication with success!

On 7-06-2006 at 14:13, Alexander Maringer wrote:
I searched all the web to get a solutions for this problem but I didn't found one. Even the mailing list doesn't have one. So support crew get more flexibel (other are more flexibel at the moment).
Greetings, although I'm not a member of the OTRS team I'd like to point out a few things: 1) OTRS.de is not supposed to give any support, as this is free software. The large majority of open source software available on the Internet is totally unsupported: use it as it is and be kind with the authors if you want to use things free. 2) Any skilled programmer is able to help you, and I'm sure that posting on the right mailing list you'll find someone to hire for your purposes. 3) If this software doesn't work for you, learn how to fix it yourself or choose another product. 4) If your problem is upgrading libdbd_mysql-perl, just downgrade it. 5) Installing Perl modules with perl -MCPAN -e shell is often a more reliable solution than using apt-get. 6) The problem is probably unrelated to OTRS itself but I think it depends on your system/Perl/libdbd package/whatever. 7) Asking things in the appropriate mailing list (otrs@otrs.org) is a better idea in order to get support from the community. Kind regards, - alessandro ranellucci.

Hi Alessandro, On 7-06-2006 at 16:07, Alessandro Ranellucci wrote: On 7-06-2006 at 14:13, Alexander Maringer wrote:
1) OTRS.de is not supposed to give any support, as this is free software. The large majority of open source software available on the Internet is totally unsupported: use it as it is and be kind with the authors if you want to use things free.
I think this is not right any more. Many projects create support lines to get their money for further development. And if anybody made such a line, than it should be opened for anybody.
2) Any skilled programmer is able to help you, and I'm sure that posting on the right mailing list you'll find someone to hire for your purposes.
I searched on any mailing list which is related with otrs and did not found any solution. Perhaps I'm not able to search or read ;-)
3) If this software doesn't work for you, learn how to fix it yourself or choose another product.
If you are a genius, than you have my full respect. I program in 5 languages and this is enough for me at the moment, so I don't want to learn perl at the moment as well as I need to correct this problem for myself ;-)
4) If your problem is upgrading libdbd_mysql-perl, just downgrade it.
Because of knowing the source of the problem, I also knew the solution and I downgraded it already.
6) The problem is probably unrelated to OTRS itself but I think it depends on your system/Perl/libdbd package/whatever.
I only made a statement, so that other people with the same problem know what to do.
7) Asking things in the appropriate mailing list (otrs@otrs.org) is a better idea in order to get support from the community.
I don't think, this was a userlist problem .... .... And searching the user list show me some equal problems not solved .... Regards ... Alexander
participants (3)
-
Alessandro Ranellucci
-
Alexander Maringer
-
Christian Schoepplein