Huge data to encode in JSON cuase Apache 500

Hi all, I've setup an OTRS (version 3.1.21) on a 3GB / 2 CPU virtual machine. I have made a CGI to return a ticket list into JSON. For this, I use the method TicketSearch. There, I have a hge hash to output as JSON. ************************ use JSON; print "application/json"; print JSON->new->encode($Result); ************************ This encoding cause a 500. I have <:Apache2 IO write: (103) Software caused connection abort> in apache logs. Is this a memory problem ? How could I solve it ? Regards,

ddt... or more explanation of why you need to get all your tickets via JSON
might be helpful.
On Wed, Jul 16, 2014 at 6:38 AM, Marwan Rabbâa
Hi all,
I've setup an OTRS (version 3.1.21) on a 3GB / 2 CPU virtual machine.
I have made a CGI to return a ticket list into JSON.
For this, I use the method TicketSearch. There, I have a hge hash to output as JSON.
************************ use JSON; print "application/json"; print JSON->new->encode($Result); ************************
This encoding cause a 500. I have <:Apache2 IO write: (103) Software caused connection abort> in apache logs.
Is this a memory problem ? How could I solve it ?
Regards,
--------------------------------------------------------------------- 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

Hi,
In fact, I have made this CGI cause I need to parse / search (via a cron)
on tickets made since ....
Regards,
2014-07-16 13:48 GMT+02:00 Gerald Young
ddt... or more explanation of why you need to get all your tickets via JSON might be helpful.
On Wed, Jul 16, 2014 at 6:38 AM, Marwan Rabbâa
wrote: Hi all,
I've setup an OTRS (version 3.1.21) on a 3GB / 2 CPU virtual machine.
I have made a CGI to return a ticket list into JSON.
For this, I use the method TicketSearch. There, I have a hge hash to output as JSON.
************************ use JSON; print "application/json"; print JSON->new->encode($Result); ************************
This encoding cause a 500. I have <:Apache2 IO write: (103) Software caused connection abort> in apache logs.
Is this a memory problem ? How could I solve it ?
Regards,
--------------------------------------------------------------------- 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
--------------------------------------------------------------------- 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

How can one reproduce your experience?
On Wed, Jul 16, 2014 at 8:03 AM, Marwan Rabbâa
Hi,
In fact, I have made this CGI cause I need to parse / search (via a cron) on tickets made since ....
Regards,
2014-07-16 13:48 GMT+02:00 Gerald Young
: ddt... or more explanation of why you need to get all your tickets via
JSON might be helpful.
On Wed, Jul 16, 2014 at 6:38 AM, Marwan Rabbâa
wrote: Hi all,
I've setup an OTRS (version 3.1.21) on a 3GB / 2 CPU virtual machine.
I have made a CGI to return a ticket list into JSON.
For this, I use the method TicketSearch. There, I have a hge hash to output as JSON.
************************ use JSON; print "application/json"; print JSON->new->encode($Result); ************************
This encoding cause a 500. I have <:Apache2 IO write: (103) Software caused connection abort> in apache logs.
Is this a memory problem ? How could I solve it ?
Regards,
--------------------------------------------------------------------- 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
--------------------------------------------------------------------- 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
--------------------------------------------------------------------- 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

@crythias: Thanks to help me solving this pb ^^
What I want to do is encode a large number of tickets obtained throught the
search lib.
I made the search with personalized params :
$TicketObject->TicketSearch(
'StateType' => ['open', 'new', 'closed'],
'Result' => 'ARRAY',
'TicketChangeTimeNewerDate' => '2014-02-01 00:00:00',
'SortBy' => 'Age'
'UserID' => '1',
'OrderBy' => 'Up'
);
but json failed ...
2014-07-16 14:07 GMT+02:00 Gerald Young
How can one reproduce your experience?
On Wed, Jul 16, 2014 at 8:03 AM, Marwan Rabbâa
wrote: Hi,
In fact, I have made this CGI cause I need to parse / search (via a cron) on tickets made since ....
Regards,
2014-07-16 13:48 GMT+02:00 Gerald Young
: ddt... or more explanation of why you need to get all your tickets via
JSON might be helpful.
On Wed, Jul 16, 2014 at 6:38 AM, Marwan Rabbâa
wrote: Hi all,
I've setup an OTRS (version 3.1.21) on a 3GB / 2 CPU virtual machine.
I have made a CGI to return a ticket list into JSON.
For this, I use the method TicketSearch. There, I have a hge hash to output as JSON.
************************ use JSON; print "application/json"; print JSON->new->encode($Result); ************************
This encoding cause a 500. I have <:Apache2 IO write: (103) Software caused connection abort> in apache logs.
Is this a memory problem ? How could I solve it ?
Regards,
--------------------------------------------------------------------- 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
--------------------------------------------------------------------- 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
--------------------------------------------------------------------- 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
--------------------------------------------------------------------- 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

+ a TicketGet for each ticket, of course
I can do a SOAP call for ticket search, but my original problem was to
avoid HTTP request (TicketGet SOAP) foreach tickets found
2014-07-16 14:21 GMT+02:00 Marwan Rabbâa
@crythias: Thanks to help me solving this pb ^^
What I want to do is encode a large number of tickets obtained throught the search lib.
I made the search with personalized params :
$TicketObject->TicketSearch( 'StateType' => ['open', 'new', 'closed'], 'Result' => 'ARRAY', 'TicketChangeTimeNewerDate' => '2014-02-01 00:00:00', 'SortBy' => 'Age' 'UserID' => '1', 'OrderBy' => 'Up' );
but json failed ...
2014-07-16 14:07 GMT+02:00 Gerald Young
: How can one reproduce your experience?
On Wed, Jul 16, 2014 at 8:03 AM, Marwan Rabbâa
wrote: Hi,
In fact, I have made this CGI cause I need to parse / search (via a cron) on tickets made since ....
Regards,
2014-07-16 13:48 GMT+02:00 Gerald Young
: ddt... or more explanation of why you need to get all your tickets via
JSON might be helpful.
On Wed, Jul 16, 2014 at 6:38 AM, Marwan Rabbâa
wrote: Hi all,
I've setup an OTRS (version 3.1.21) on a 3GB / 2 CPU virtual machine.
I have made a CGI to return a ticket list into JSON.
For this, I use the method TicketSearch. There, I have a hge hash to output as JSON.
************************ use JSON; print "application/json"; print JSON->new->encode($Result); ************************
This encoding cause a 500. I have <:Apache2 IO write: (103) Software caused connection abort> in apache logs.
Is this a memory problem ? How could I solve it ?
Regards,
--------------------------------------------------------------------- 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
--------------------------------------------------------------------- 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
--------------------------------------------------------------------- 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
--------------------------------------------------------------------- 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
participants (2)
-
Gerald Young
-
Marwan Rabbâa