cancel
Showing results for 
Search instead for 
Did you mean: 

unable to save product

unable to save product

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

6 REPLIES 6

Re: unable to save product

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.

 

 

Hope this helps you!
Problem Solved! Click Kudos & Accept as Solution!

Re: unable to save product

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 

Re: unable to save product

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. 

Hope this helps you!
Problem Solved! Click Kudos & Accept as Solution!

Re: unable to save product

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

 

Re: unable to save product

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...!!

Re: unable to save product

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