No closed Tickets in List after 12.01.2022

Infos:

  • Used Zammad version: latest
  • Used Zammad installation type: package
  • Operating system: Ubuntu 18.04.6
  • Browser + version: Chrome latest

Expected behavior:

  • Showing all closed Tickets until today

Actual behavior:

There should be much more Tickets in that list.

I cant reindex because elastic search 6.8 is not supported. Upgrade to 7 says i need to reindex with 6.8
What can i do?

Is there any way to drop that index and create it new? I can rebuild index because

sudo zammad run rake searchindex:rebuild --trace
[sudo] password for user:
** Invoke searchindex:rebuild (first_time)
** Invoke environment (first_time)
** Execute environment
** Invoke searchindex:configured (first_time)
** Invoke environment
** Execute searchindex:configured
** Invoke searchindex:version_supported (first_time)
** Invoke environment
** Execute searchindex:version_supported
rake aborted!
Version 6.8.23 of configured elasticsearch is not supported.

And when i update to ES 7.dunno it cant be rebuilded because that index seems to be builded with v5.x and 7.x cant rebuild that old index.

So, my solution to elasticsearch issue was to delete the index while on 6.8

curl -XDELETE 'http://localhost:9200/*'

update to 7.x and recreate index again.

zammad run rake searchindex:rebuild --trace
** Invoke searchindex:rebuild (first_time)
** Invoke environment (first_time)
** Execute environment
** Invoke searchindex:configured (first_time)
** Invoke environment
** Execute searchindex:configured
** Invoke searchindex:version_supported (first_time)
** Invoke environment
** Execute searchindex:version_supported
** Execute searchindex:rebuild
** Execute searchindex:drop
drop indexes...done
** Execute searchindex:drop_pipeline
delete pipeline (pipeline)... done
** Execute searchindex:create
create indexes...done
** Execute searchindex:create_pipeline
create pipeline (pipeline)... done
** Execute searchindex:reload
reload data...
 reload Group
  - started at 2022-02-17 12:16:35 UTC
        1/1
  - took 0 seconds
 reload KnowledgeBase::Answer::Translation
  - started at 2022-02-17 12:16:35 UTC
        7/7
  - took 0 seconds
 reload KnowledgeBase::Translation
  - started at 2022-02-17 12:16:35 UTC
        1/1
  - took 0 seconds
 reload KnowledgeBase::Category::Translation
  - started at 2022-02-17 12:16:36 UTC
        5/5
  - took 0 seconds
 reload Cti::Log
  - started at 2022-02-17 12:16:36 UTC
  - took 0 seconds
 reload StatsStore
  - started at 2022-02-17 12:16:36 UTC
        15/15
  - took 0 seconds
 reload Ticket
  - started at 2022-02-17 12:16:36 UTC
        100/2335
        200/2335
        300/2335
        400/2335
        500/2335
        600/2335
        700/2335
        800/2335
        900/2335
        1000/2335
        1100/2335
        1200/2335
        1300/2335
        1400/2335
        1500/2335
        1600/2335
        1700/2335
        1800/2335
        1900/2335
        2000/2335
        2100/2335
        2200/2335
        2300/2335
        2335/2335
  - took 283 seconds
 reload Ticket::State
  - started at 2022-02-17 12:21:20 UTC
        7/7
  - took 0 seconds
 reload Ticket::Priority
  - started at 2022-02-17 12:21:20 UTC
        3/3
  - took 0 seconds
 reload User
  - started at 2022-02-17 12:21:20 UTC
        100/386
        200/386
        300/386
        386/386
  - took 7 seconds
 reload Chat::Session
  - started at 2022-02-17 12:21:27 UTC
  - took 0 seconds
 reload Organization
  - started at 2022-02-17 12:21:27 UTC
        2/2
  - took 0 seconds

But still no tickets in list after 12.01.2022

Does anyone have an idea, why i cant see no more closed tickets after 12. January 2022?

@MrGeneration do you know why i cant see all closed tickets in Ticket Overview? From today, i can see that there should be more closed tickets in this list (+15 Tickets) but there is one day off now (11.01. instead of 12.01.)

I need help please!

Can any one help please?

I logged in as Admin, changed the View to be ordered from down to up, and now everything works fine again.