How It Affects Your App
This error occurs when an invalid foreign key option is used for a generated column. This can cause the application to fail to create the table, or to fail to insert data into the table. It can also cause the application to crash or become unresponsive. This can lead to data loss and disruption of service for the application.
How To Fix
1. Check the error log for the MySQL 3104 error. This can be done by running the following command:
mysql> SHOW GLOBAL VARIABLES LIKE 'log_error';
2. If the error log is not enabled, enable it by running the following command:
mysql> SET GLOBAL log_error = 'ON';
3. Check the error log again to see if the MySQL 3104 error is present.4. If the error is present, check the configuration of the MySQL server to see if the server is configured to use the correct storage engine. This can be done by running the following command:
mysql> SHOW GLOBAL VARIABLES LIKE 'storage_engine';
5. If the storage engine is not configured correctly, configure it by running the following command:
mysql> SET GLOBAL storage_engine = 'InnoDB';
6. Restart the MySQL server to apply the changes.7. Check the error log again to see if the MySQL 3104 error is still present.8. If the error is still present, it is recommended to use an automated database observability tool to monitor and fix the MySQL 3104 in question. An automated database observability tool can provide real-time insights into the performance and health of the database, allowing for quick and easy troubleshooting of any issues that may arise. It can also provide alerts when certain thresholds are exceeded, allowing for proactive monitoring and maintenance of the database.
.png)
