# Cronjob Search Index Error after Update Maria DB to V10.3

**URL:** <https://forum.shopware.com/t/cronjob-search-index-error-after-update-maria-db-to-v10-3/85931>\
**Category:** Allgemein\
**Created:** [12. März 2021 um 10:08 UTC](https://forum.shopware.com/t/cronjob-search-index-error-after-update-maria-db-to-v10-3/85931 "2021-03-12T10:08:53Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![goldenerzirkel](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/goldenerzirkel/32/10567_2.png) [@goldenerzirkel](https://forum.shopware.com/u/goldenerzirkel)\
**Post date:** [12. März 2021 um 10:08 UTC](https://forum.shopware.com/t/cronjob-search-index-error-after-update-maria-db-to-v10-3/85931/1 "2021-03-12T10:08:54Z")

</div>

Moin moin,  
nach dem Update von MariaDB V10.1 auf MariaDB 10.3 bekomme ich Fehlermeldungen beim Cronjob für den Search Index:  
In DBALException.php line 179:

```
 An exception occurred while executing 'INSERT IGNORE INTO s_search_index (k  
 eywordID, elementID, fieldID)                                                

 SELECT sk.id as keywordID, 1 as elementID, 5 as fieldID FROM s_search_keywo  
 rds sk WHERE sk.keyword IN ('978-3-12-561432-1')                             

 UNION ALL                                                                    

 SELECT sk.id as keywordID, 1 as elementID, 18 as fieldID FROM s_search_keyw  
 ords sk WHERE sk.keyword IN ('9783125614321')                                

 UNION ALL                                                                    

 SELECT sk.id as keywordID, 2 as elementID, 5 as fieldID FROM s_search_keywo  
 rds sk WHERE sk.keyword IN ('978-3-12-561437-6')                             

 UNION ALL         
…
… usw. und am Ende dann...
…
    SELECT sk.id as keywordID, 3124 as elementID, 18 as fieldID FROM s_search_k  
     eywords sk WHERE sk.keyword IN ('9783125174962')':                           

 SQLSTATE[42000]: Syntax error or access violation: 1064 memory exhausted ne  
 ar 'sk.id as keywordID, 3123 as elementID, 5 as fieldID FROM s_search_keywo  
 rds sk...' at line 15995                                                     

In Connection.php line 1062:

 SQLSTATE[42000]: Syntax error or access violation: 1064 memory exhausted ne  
 ar 'sk.id as keywordID, 3123 as elementID, 5 as fieldID FROM s_search_keywo  
 rds sk...' at line 15995                                                     

sw:cron:run [-f|--force] [--] [<cronjob>]               

```

PHP hat als memory\_limit=2560M, ich glaube das können wir ausschließen. Ich hab gerade gar keine Idee wie ich debuggen soll. Bin für Vorschläge dankbar.  
_Shopware 5.6.7_  
_php7.4.14_  
_MariaDB 10.3.27_

Frohes Schaffen und Gruß, Kai

---

<div class="post-metadata">

**Author:** ![vanwittlaer](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/vanwittlaer/32/8499_2.png) [@vanwittlaer](https://forum.shopware.com/u/vanwittlaer)\
**Post date:** [14. März 2021 um 10:03 UTC](https://forum.shopware.com/t/cronjob-search-index-error-after-update-maria-db-to-v10-3/85931/2 "2021-03-14T10:03:58Z")

</div>

> [@goldenerzirkel](#):
>
> `1064 memory exhausted`

Hallo Kai,  
vermute mal, dass sich das auf die DB-Konfiguration (und nicht PHP-Memory-Limit) bezieht.  
Viele Grüße  
Benny