Recently, the ci build has failed with the following error message:
1 2 3
The reason is, so far as I known, that firstly the database has the log recorded and when the volume of log increasing, it would cause the “out of space” error if it exceeds the threshold of log size limit.
The knowledge that we should know is:
# Scheme of way to record transaction log is store in log_reuse_wait_desc # column of sys.databases, check “this”:http://msdn.microsoft.com/en-us/library/ms178534.aspx, it gives all the choices of how to deal with the transaction log
A little bit log for this document, I will just cut the cliche and show how I solve this issue with the knowledge I found from Internet.
Given our current build is using data warehouse “Warehouse” and such error happens
First thing is to connect to the data warehouse, and check whether the log is full by using DBCC tools.
Check log spaces used:
Then you will see the log size for “Warehouse” is 100% After knowing it is the right reason as the error message shows, we have two steps to go:
set the data warehouse into recovery mode and set the log_reuse_wait_desc using no backup for reserving logs
truncate the currently logs and shrink its size
Way to change the database recovery mode and set backup scheme:
1 2 3 4 5
way to shrink the log file:
Then you will get new log scheme with no backup and a log size less than 1MB. Of course, the most important thing is that the ci build won’t fail….