Problems deleting emails using GenericAgent from large queue

[MomentoJams]

Hi,

I'm having trouble deleting emails from a large queue (~125 000 emails) using GenericAgent. It deleted about 30 000 emails without a problem, but now it keeps displaying the same number of affected tickets every time I run the agent e.g. I see this same message every time:

Code: Select all

Warning: There are 122350 tickets affected but only 4000 may be modified during one job execution! 

How can I debug the issue further?

Thanks.

[skullz]

by default, only 4000 ticket will be effected per generic agent execution.

you may check System Configuration > Ticket::GenericAgentRunLimit

[root]

Hi,

Add a schedule and be patient.

- Roy

[MomentoJams]

Thanks for your replies. Actually, the problem is that it's just not deleting anything, no matter how many times I run it. It was deleting the default amount before (4000) -- which I haven't changed yet -- but now it doesn't remove anything from the queue at all.

Is there something I can do to figure out what's going on?

Thanks.

[root]

Hi,

Does the GenericAgent show how many tickets should be deleted when you click on execute? This check's the conditions for the search. If not you probably should post a screenshot.

- Roy

[MomentoJams]

Does the GenericAgent show how many tickets should be deleted when you click on execute? This check's the conditions for the search.

Hi, yes it does: 122350. This number stays the same for each run. It's a bit baffling as it had been running before this (about 10 runs, reducing the ticket count from ~160000 to this number), but repeated running after that now does a lot of work but no reduction in the number of tickets in the queue.

I've been running mytop and it's showing lots of activity (high qps and lots of "DELETE ..." types of queries, too fast to capture).

[root]

Hi,

When you run the command
bin/otrs.Console.pl Maint::Daemon::Summary
is there sth int the output like this:

Code: Select all

  Recurrent generic agent tasks:
  +-------------------------------------------------------------+---------------------+-------------+---------------+---------------------+
  | Name                                                        | Last Execution      | Last Status | Last Duration | Next Execution      |
  +-------------------------------------------------------------+---------------------+-------------+---------------+---------------------+
  | 1010 Daily delete tickets in Junk after 4 weeks not changed | 2023-08-16 06:05:00 | Success     | 1.0 Second(s) | 2023-08-17 06:05:00 |
  +-------------------------------------------------------------+---------------------+-------------+---------------+---------------------+

There must be your GenericAgent listed that deletes the tickets.

- Roy