Fehler bei "Datenbank Migration" von Update EA2 auf RC2

Shopware 6 (German) Allgemein
1

Hallo,

ich erhalte folgende Fehlermeldung im Schritt “Datenbank Migration”
 

Error

Received the following error message:
An exception occurred while executing ' CREATE TABLE `product_export` ( `id` BINARY(16) NOT NULL, `product_stream_id` BINARY(16) NOT NULL, `storefront_sales_channel_id` BINARY(16) NULL, `sales_channel_id` BINARY(16) NOT NULL, `sales_channel_domain_id` BINARY(16) NULL, `file_name` VARCHAR(255) NOT NULL, `access_key` VARCHAR(255) NOT NULL, `encoding` VARCHAR(255) NOT NULL, `file_format` VARCHAR(255) NOT NULL, `include_variants` TINYINT(1) NULL DEFAULT '0', `generate_by_cronjob` TINYINT(1) NOT NULL DEFAULT '0', `generated_at` DATETIME(3) NULL, `interval` INT(11) NOT NULL, `header_template` LONGTEXT NULL, `body_template` LONGTEXT NULL, `footer_template` LONGTEXT NULL, `created_at` DATETIME(3) NOT NULL, `updated_at` DATETIME(3) NULL, PRIMARY KEY (`id`), UNIQUE KEY `file_name` (`file_name`), KEY `fk.product_export.product_stream_id` (`product_stream_id`), KEY `fk.product_export.storefront_sales_channel_id` (`storefront_sales_channel_id`), KEY `fk.product_export.sales_channel_id` (`sales_channel_id`), KEY `fk.product_export.sales_channel_domain_id` (`sales_channel_domain_id`), CONSTRAINT `fk.product_export.product_stream_id` FOREIGN KEY (`product_stream_id`) REFERENCES `product_stream` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk.product_export.storefront_sales_channel_id` FOREIGN KEY (`storefront_sales_channel_id`) REFERENCES `sales_channel` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk.product_export.sales_channel_id` FOREIGN KEY (`sales_channel_id`) REFERENCES `sales_channel` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk.product_export.sales_channel_domain_id` FOREIGN KEY (`sales_channel_domain_id`) REFERENCES `sales_channel_domain` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; ': SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'product_export' already exists

Please try to fix this error and restart the update.

Response

{"valid":false,"errorMsg":"An exception occurred while executing '\n CREATE TABLE `product_export` (\n `id` BINARY(16) NOT NULL,\n `product_stream_id` BINARY(16) NOT NULL,\n `storefront_sales_channel_id` BINARY(16) NULL,\n `sales_channel_id` BINARY(16) NOT NULL,\n `sales_channel_domain_id` BINARY(16) NULL,\n `file_name` VARCHAR(255) NOT NULL,\n `access_key` VARCHAR(255) NOT NULL,\n `encoding` VARCHAR(255) NOT NULL,\n `file_format` VARCHAR(255) NOT NULL,\n `include_variants` TINYINT(1) NULL DEFAULT '0',\n `generate_by_cronjob` TINYINT(1) NOT NULL DEFAULT '0',\n `generated_at` DATETIME(3) NULL,\n `interval` INT(11) NOT NULL,\n `header_template` LONGTEXT NULL,\n `body_template` LONGTEXT NULL,\n `footer_template` LONGTEXT NULL,\n `created_at` DATETIME(3) NOT NULL,\n `updated_at` DATETIME(3) NULL,\n PRIMARY KEY (`id`),\n UNIQUE KEY `file_name` (`file_name`),\n KEY `fk.product_export.product_stream_id` (`product_stream_id`),\n KEY `fk.product_export.storefront_sales_channel_id` (`storefront_sales_channel_id`),\n KEY `fk.product_export.sales_channel_id` (`sales_channel_id`),\n KEY `fk.product_export.sales_channel_domain_id` (`sales_channel_domain_id`),\n CONSTRAINT `fk.product_export.product_stream_id` FOREIGN KEY (`product_stream_id`) REFERENCES `product_stream` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,\n CONSTRAINT `fk.product_export.storefront_sales_channel_id` FOREIGN KEY (`storefront_sales_channel_id`) REFERENCES `sales_channel` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,\n CONSTRAINT `fk.product_export.sales_channel_id` FOREIGN KEY (`sales_channel_id`) REFERENCES `sales_channel` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,\n CONSTRAINT `fk.product_export.sales_channel_domain_id` FOREIGN KEY (`sales_channel_domain_id`) REFERENCES `sales_channel_domain` (`id`) ON DELETE CASCADE ON UPDATE CASCADE\n ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;\n ':\n\nSQLSTATE[42S01]: Base table or view already exists: 1050 Table 'product_export' already exists"}

 

2

Ich habe anschließend die Tabelle ‘product_export’ gelöscht und nun folgende Fehlermeldung erhalten:

Error
Received the following error message:
An exception occurred while executing 'INSERT INTO sales_channel_type (id, icon_name, created_at) VALUES (?, ?, ?)' with params ["\xed\x53\x5e\x57\x22\x13\x4a\xc1\xaa\x65\x24\xf7\x3e\x26\x88\x1b", "default-object-rocket", "2019-12-13 14:50:05.000"]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '\xEDS^W"\x13J\xC1\xAAe$\xF7>&\x88\x1B' for key 'PRIMARY'

Please try to fix this error and restart the update.
Response
{"valid":false,"errorMsg":"An exception occurred while executing 'INSERT INTO sales_channel_type (id, icon_name, created_at) VALUES (?, ?, ?)' with params [\"\\xed\\x53\\x5e\\x57\\x22\\x13\\x4a\\xc1\\xaa\\x65\\x24\\xf7\\x3e\\x26\\x88\\x1b\", \"default-object-rocket\", \"2019-12-13 14:50:05.000\"]:\n\nSQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '\\xEDS^W\"\\x13J\\xC1\\xAAe$\\xF7>&\\x88\\x1B' for key 'PRIMARY'"}

 

3 
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry

Eintrag existiert schon in sales_channel_type wo icon_name ist “default-object-rocket”

4

Habe ich auch gelöscht und erhalte anschließend:

 

Error
Received the following error message:
An exception occurred while executing 'INSERT INTO sales_channel_type_translation (sales_channel_type_id, language_id, name, manufacturer, description, created_at) VALUES (?, ?, ?, ?, ?, ?)' with params ["\xed\x53\x5e\x57\x22\x13\x4a\xc1\xaa\x65\x24\xf7\x3e\x26\x88\x1b", "", "Produktvergleich", "shopware AG", "Verkaufskanal f\u00fcr Produktvergleichsportale", "2019-12-13 14:56:19.000"]: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`shopware`.`sales_channel_type_translation`, CONSTRAINT `fk.sales_channel_type_translation.language_id` FOREIGN KEY (`language_id`) REFERENCES `language` (`id`) ON DELETE CASCADE ON UPDATE CAS)

Please try to fix this error and restart the update.
Response
{"valid":false,"errorMsg":"An exception occurred while executing 'INSERT INTO sales_channel_type_translation (sales_channel_type_id, language_id, name, manufacturer, description, created_at) VALUES (?, ?, ?, ?, ?, ?)' with params [\"\\xed\\x53\\x5e\\x57\\x22\\x13\\x4a\\xc1\\xaa\\x65\\x24\\xf7\\x3e\\x26\\x88\\x1b\", \"\", \"Produktvergleich\", \"shopware AG\", \"Verkaufskanal f\\u00fcr Produktvergleichsportale\", \"2019-12-13 14:56:19.000\"]:\n\nSQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`shopware`.`sales_channel_type_translation`, CONSTRAINT `fk.sales_channel_type_translation.language_id` FOREIGN KEY (`language_id`) REFERENCES `language` (`id`) ON DELETE CASCADE ON UPDATE CAS)"}

 

5 
 SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails

Ich denke mal mit deinen löschaktionen geht mehr kaputt als repariert wird. Hier fehlen jetzt die Verknüpfungen.