Maksim Soldatjonok Maksold

## Database Fix for AUTO_INCREMENT exceeds max value.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                Maksold
                / Database Fix for AUTO_INCREMENT exceeds max value.md
            
            
              Last active
              February 27, 2024 13:25
                — forked from JesKingDev/Database Fix for AUTO_INCREMENT exceeds max value.md
            
              
                Data fix for the scenarios where gaps in a table's auto_increment result in the next value exceeding the max size of an INT. Specifically helps address the Magento Issue - AUTO_INCREMENT grows on every INSERT ... ON DUPLICATE on InnoDB tables #28387 https://github.com/magento/magento2/issues/28387
              
          
    AUTO_INCREMENT grows on every INSERT ... ON DUPLICATE on InnoDB tables #28387

magento/magento2#28387
Symptom:

General system exception happened.
SQLSTATE[22003]: Numeric value out of range: 167
Out of range value for column 'value_id' at row 1,
query was: INSERT INTO catalog_product_entity_varchar
(entity_id,attribute_id,store_id,value)
VALUES (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (


## magento-nginx.conf
# This is an annotated subset of the Nginx configuration from our Magento production platform @ www.hypernode.com
# See https://www.byte.nl/blog/magento-cacheleak-issue

# !!!! If you are a Hypernode customer, do not use this config as it will result in duplicate statements. !!!!!

user app;
worker_processes 4;
pid /var/run/nginx.pid;

events {
	# This is an annotated subset of the Nginx configuration from our Magento production platform @ www.hypernode.com
	# See https://www.byte.nl/blog/magento-cacheleak-issue

	# !!!! If you are a Hypernode customer, do not use this config as it will result in duplicate statements. !!!!!

	user app;
	worker_processes 4;
	pid /var/run/nginx.pid;

	events {