unable to save product

[5e45d797eab01]

I am trying to update price of a product and then I have an error "Stock Item was unable to be saved. Please try again". someone suggested for reindex but I have this error 

SQLSTATE[HY000]: General error: 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions., query was: CREATE TEMPORARY TABLE IF NOT EXISTS `catalog_product_index_eav_temp` LIKE `catalog_product_index_eav_tmp`

I am using cloud proxy sql from GCP. 

Appreciate any help. 

thx

sri

[Madhu Rajawat]

Hi @5e45d797eab01 

Please contact with server guy and check the server space. It is a server low memory issue.

_temp tables are not generating in the database due to server space issues.

After that do reindex once.

[5e45d797eab01]

Right the issue is with temp tables are not getting created. Because I am using Google cloud SQL. If you enable bin logging, there is an issue with temp tables. I had to turn of bin logging for this to work. But that could be an issue with replication in future though I turned it off for now. I ain't dealing with it right now and will leave it to my coworkers 

[Madhu Rajawat]

Hi @5e45d797eab01 

I was facing the same issue. this issue was occurring due to server lower space. When increasing the server space then this issue fixed. 
Turn off logging is a temporary solution So I would suggest you don't go with turn off bin logging. Contact to the server team for increasing server space. 

[Aveshnaik007]

This is happens mostly because of MSI with sample data exists in it. 
If there is no sample data and you still facing this issue then try this.

If you are using a 2.4 and Elastic search then try this

sudo service elasticsearch status

 sudo service elasticsearch start

 sudo service elasticsearch restart

Still not fix then try this

php bin/magento setup:upgrade
php bin/magento setup:static-content:deploy -f
php bin/magento indexer:reset
php bin/magento indexer:reindex
php bin/magento cache:flush

[Milople]

Hi @5e45d797eab01 ,

It's an issue of Index. Please change all indexers as Update by Schedule mode in system-> index management.
If this will not work then try this other solution.

Flush cache

sudo php bin/magento cache:flush

Chek Indexer Status

php bin/magento indexer:status

Reset Indexer

php bin/magento indexer:reset

Reindex Indexer

php bin/magento indexer:reindex

Chek Indexer Status

php bin/magento indexer:status

Chek indexer Info

php bin/magento indexer:info

Finally Flush Cache

php bin/magento cache:flush

If still get the same error then contact us.
Accept it as a solution and click Kudos.

Thank you...!!

[Vinizz]

Could not validate a connection to Elasticsearch. No alive nodes. All the 1 nodes seem to be down.