<div dir="ltr"><div>We compiled the current stable pgPool 3.3.3 from source, as We're seeing it the OTRS is almost everywhere working fine. <br><br>Unfortunately we found the following errors in the OTRS log. When we aren't using pgPool, everything is working well.<br>
<br>Mar 26 16:47:43 hera OTRS-CGI-10[11438]: [Error][Kernel::System::Ticket::HistoryAdd][Line:5066]: Need TicketID!<br>Mar 26 16:47:43 hera OTRS-CGI-10[11438]: [Error][Kernel::System::Ticket::HistoryAdd][Line:5066]: Need TicketID!<br>
Mar 26 16:47:43 hera OTRS-CGI-10[11438]: [Error][Kernel::System::Ticket::HistoryAdd][Line:5066]: Need TicketID!<br>Mar 26 16:47:43 hera OTRS-CGI-10[11438]: [Error][Kernel::System::Ticket::IndexAccelerator::StaticDB::TicketAcceleratorAdd][Line:147]: Need TicketID!<br>
Mar 26 16:47:43 hera OTRS-CGI-10[11438]: [Error][Kernel::System::Ticket::Event::TicketEscalationIndex::Run][Line:42]: Need TicketID in Data!<br>Mar 26 16:47:43 hera OTRS-CGI-10[11438]: [Error][Kernel::System::Ticket::TicketNumberLookup][Line:747]: Need TicketID!<br>
Mar 26 16:47:43 hera OTRS-CGI-10[11438]: [Error][Kernel::System::Ticket::Article::ArticleSend][Line:2023]: Need TicketID!<br>Mar 26 16:47:43 hera OTRS-CGI-10[11438]: [Error][Kernel::System::Ticket::Event::NotificationEvent::Run][Line:68]: Need TicketID in Data!<br>
Mar 26 16:47:43 hera OTRS-CGI-10[11438]: [Error][Kernel::System::Ticket::Event::GenericAgent::Run][Line:49]: Need TicketID! in Data<br>Mar 26 16:47:43 hera OTRS-CGI-10[11438]: [Error][Kernel::System::Ticket::Event::TicketProcessTransitions::Run][Line:55]: Need TicketID in Data!<br>
<br><br></div>We're sending our pgPool config and detailed pgPool log files as attachment.<br><div><br><br>Have you got some ideas, how can we solve this problem?<br><br>Thx,<br>Csaba<br></div></div><div class="gmail_extra">
<br><br><div class="gmail_quote">2014-03-20 0:41 GMT+01:00 Tatsuo Ishii <span dir="ltr"><<a href="mailto:ishii@postgresql.org" target="_blank">ishii@postgresql.org</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="">> We compiled the current code from git repo (version 3.4-alpha1<br>
> (tataraboshi), and tested OTRS.<br>
><br>
> As I seen the OTRS and working fine.<br>
<br>
</div>Great!<br>
<div class=""><br>
> Can we use the 3.4-alpha1 version in production area?<br>
> Whats the planned release date of the stable 3.4 version?<br>
> (We would like to use the official <a href="http://apt.postgres.org" target="_blank">apt.postgres.org</a> packages, if it<br>
> possible)<br>
<br>
</div>The release date of 3.4 is not determined yet. I do not recommend to<br>
use 3.4-alpha1 for production use.<br>
<br>
However 3.3.3 will be released soon (24th of this month), which is a<br>
bug fix version of 3.3.2. The same fix I reffered to is included in<br>
3.3.3 as well.<br>
<br>
You might want to try supposed-to-be-3.3.3 source at:<br>
<br>
<a href="http://git.postgresql.org/gitweb/?p=pgpool2.git;a=shortlog;h=refs/heads/V3_3_STABLE" target="_blank">http://git.postgresql.org/gitweb/?p=pgpool2.git;a=shortlog;h=refs/heads/V3_3_STABLE</a><br>
<div class="HOEnZb"><div class="h5"><br>
Best regards,<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese: <a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><br>
<br>
> Thx,<br>
> Csaba<br>
><br>
><br>
><br>
> 2014-03-12 6:25 GMT+01:00 Tatsuo Ishii <<a href="mailto:ishii@postgresql.org">ishii@postgresql.org</a>>:<br>
><br>
>> Seems the bug fixed in<br>
>><br>
>><br>
>> <a href="http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=35437fa5eada74e181a7940b4917ea6560a75ade" target="_blank">http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=35437fa5eada74e181a7940b4917ea6560a75ade</a><br>
>><br>
>> Can you please try it out?<br>
>><br>
>> Best regards,<br>
>> --<br>
>> Tatsuo Ishii<br>
>> SRA OSS, Inc. Japan<br>
>> English: <a href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
>> Japanese: <a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><br>
>><br>
>> > Hello,<br>
>> ><br>
>> > Thanks for your answer.<br>
>> > A tried it with log_per_node_statement. I'm sending more detailed log.<br>
>><br>
</div></div></blockquote></div><br></div>