Issues with Elastic Search

Shopware 6 (English)
1

I have a prod. store running 6.5.7.3
I have configured ES for admin like so:
OPENSEARCH_URL=127.0.0.1:32778
SHOPWARE_ES_HOSTS=127.0.0.1:32778
ADMIN_OPENSEARCH_URL=127.0.0.1:32778
SHOPWARE_ADMIN_ES_ENABLED=1
SHOPWARE_ADMIN_ES_REFRESH_INDICES=1
SHOPWARE_ADMIN_ES_INDEX_PREFIX=sw6_admin

Admin shows ES is connected,
When I run index i get the following error:
Base table or view not found: 1146 Table ‚sw_dmcas.elasticsearch_index_task‘ doesn’t exist"

The rest of the site is running as expected. What am i missing?

2

We are having the same issue. Did you find a solution?

3

Hi Basti
Had to find the table in an old shopware 6.4.14.X and create the table manually in the 6.5.7.3 database - then everything worked again.
Really strange that its not part of the installation script.

4

CREATE TABLE elasticsearch_index_task (
id binary(16) NOT NULL,
index varchar(500) NOT NULL,
alias varchar(500) NOT NULL,
entity varchar(500) NOT NULL,
doc_count int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
COMMIT;

1 „Gefällt mir“
5

That did it. Thank you!

6

Corrected the SQL:
CREATE TABLE elasticsearch_index_task (
id binary(16) NOT NULL,
index varchar(500) NOT NULL,
alias varchar(500) NOT NULL,
entity varchar(500) NOT NULL,
doc_count int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

7

well its removing formatting of the SQL which makes it fail…

CREATE TABLE `elasticsearch_index_task` (
  `id` binary(16) NOT NULL,
  `index` varchar(500) NOT NULL,
  `alias` varchar(500) NOT NULL,
  `entity` varchar(500) NOT NULL,
  `doc_count` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;