I’m having a technical issue – whenever I run the
php bin/magento indexer:reindex
command on the live website, the website goes down –
This is happening only on the live website –
If this same website is run on staging and local then nothing like this happens-
And such errors are also being reported in the logs-
I tried to attaching production DB with staging and in Local and run reindexing, but no such errors were reproduced.
Here is my app/etc/env.php file on production server
<?php
return [
'backend' => [
'frontName' => 'someurl'
],
'remote_storage' => [
'driver' => 'file'
],
'queue' => [
'consumers_wait_for_messages' => 0
],
'crypt' => [
'key' => 'somekey'
],
'db' => [
'table_prefix' => '',
'connection' => [
'default' => [
'host' => 'somehost',
'dbname' => 'somename',
'username' => 'someusername',
'password' => 'somepassword',
'model' => 'mysql4',
'engine' => 'innodb',
'initStatements' => 'SET NAMES utf8;',
'active' => '1',
'driver_options' => [
1014 => false
]
]
]
],
'resource' => [
'default_setup' => [
'connection' => 'default'
]
],
'x-frame-options' => 'SAMEORIGIN',
'MAGE_MODE' => 'production',
'session' => [
'save' => 'redis',
'redis' => [
'host' => 'redis1.i',
'port' => '6379',
'password' => '',
'timeout' => '2.5',
'persistent_identifier' => '',
'database' => '0',
'compression_threshold' => '8192',
'compression_library' => 'gzip',
'log_level' => '1',
'max_concurrency' => '6',
'break_after_frontend' => '5',
'break_after_adminhtml' => '30',
'first_lifetime' => '600',
'bot_first_lifetime' => '30',
'bot_lifetime' => '7200',
'disable_locking' => '1',
'min_lifetime' => '60',
'max_lifetime' => '6048000',
'max_size' => '512000'
]
],
'cache' => [
'frontend' => [
'default' => [
'id_prefix' => 'a91_',
'backend' => 'Magento\Framework\Cache\Backend\Redis',
'backend_options' => [
'server' => 'redis11.i',
'database' => '0',
'port' => '6379',
'password' => '',
'compress_data' => '1',
'compression_lib' => 'gzip'
]
],
'page_cache' => [
'id_prefix' => 'a91_',
'backend' => 'Magento\Framework\Cache\Backend\Redis',
'backend_options' => [
'server' => 'redis31.i',
'database' => '0',
'port' => '6379',
'password' => '',
'compress_data' => '1',
'compression_lib' => 'gzip'
]
]
],
'allow_parallel_generation' => false
],
'lock' => [
'provider' => 'db',
'config' => [
'prefix' => ''
]
],
'directories' => [
'document_root_is_pub' => true
],
'cache_types' => [
'config' => 1,
'layout' => 1,
'block_html' => 1,
'collections' => 1,
'reflection' => 1,
'db_ddl' => 1,
'compiled_config' => 1,
'eav' => 1,
'customer_notification' => 1,
'config_integration' => 1,
'config_integration_api' => 1,
'full_page' => 1,
'config_webservice' => 1,
'translate' => 1,
'vertex' => 1
],
'downloadable_domains' => [
'www.somedomain.com.au'
],
'install' => [
'date' => 'Thu, 08 Jun 2023 06:59:26 +0000'
]
];
Here is my elastic search settings