Index notification is always running in Shopware 6

Shopware 6 (English) General Questions (EN)
1

Index notification is always running in Shopware 6. Even if I try to cancel it, it starts again.

image_2021_10_14T08_45_03_461Z

2

By default, the DB is used as the backend for the message queue. Check the table enqueue.

Maybe just truncate the table message_queue_stats which rebuild the message stats which are used for that UI. Most of the time that resolves stuck stats that refuse to update.

3

https://timmehosting.de/shopware-6-admin-worker-deaktivieren

1 „Gefällt mir“
4

Hello dear Shopware community,

just like @abinjohnedamana we have the same problem that the message queue notifications in the admin panel don’t go away.

queue
queue379×507 22.8 KB

We have two crons running:

  • bin/console messenger:consume --memory-limit=512M --time-limit=180 -vv
  • bin/console scheduled-task:run --memory-limit=512M --time-limit=180

According to our cron log, the scheduled task and the messenger are working correctly and the queue is being processed … I don’t get any CRITICAL or similar error messages … only of the INFO type.

We also checked the dead_messages, enqueue, and message_queue_stats tables, they are all empty. How come the notifications don’t go away?

For evidence, I would be very grateful!

greetings Marco

5

Thats really odd, since the table message_queue_stats is responsible for the picture you have posted.

6

@Max_Shop … yes . it really sucks. Dont know where SW get these data from.

7

Hi @Max_Shop, @abinjohnedamana

hey guys … we`ve found a little workaround to get these messages away.
There is a table called increment. have a look at the column ‚cluster‘ and set a filter to ‚message_queue_stats‘ .

There is a entry called ‚Shopware\Core\Content\Product\DataAbstractionLayer\ProductStreamMappingIndexingMessage‘ and ‚Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexingMessage‘ … after deleting this entries message queue works corretly now. the deleted entries will be created again if you update a product in your shop.

t_increment
t_increment1607×767 168 KB

1 „Gefällt mir“
8

this works also for thumbnails and category indexing :heart_eyes:

9

Oh, I have confused the table. The first one contains the single entries, increment the summarised value. If you clear the first table, you always have to set the corresponding value in increment to 0.

10

@Max_Shop oh yes, it’s better to set the value to 0 instead of deleting the entries. it`s safer :upside_down_face:

11

@Max_Shop @marco.meister

The increment table is only available from Shopware version 6.4.7.0

1 „Gefällt mir“
12

Oh, I have confused the table. The first one contains the single entries, increment the summarised value.. .