Error 1064 and full transaction log?
Comments
-
Im running into an issue where my production services have stopped and Im having a hard time getting my stuff up again. I looked in the logs I found an error message that says: "Error message: The transaction log for Database Decisions is full due to name of some data I cannot share". Im also finding an "Error 1064: An exception has occurred in the service when handling the control request." Any ideas? I need my machines back up.
-
Hey,
This is actually a (SQL) database issue. First you need to drop/delete the transact log, update your DB schedule, and then everything should be fine. If you need more information, please use this link! (https://docs.microsoft.com/en-us/sql/relational-databases/logs/troubleshoot-a-full-transaction-log-sql-server-error-9002?view=sql-server-ver15).
-
Thank you, after deleting the logs and updating my DB schedule so it doesnt happen again, I did a restart of SHM and everything was back to normal.