CODEWITHSUNDEEP
sql-serverdockervirtualboxdockerfilesql-server-linux
alexanoid
alexanoid

Reputation: 25862

Docker and SQL Server Linux - Error 9002. The transaction log for database master is full due to NOTHING

I use Docker without Hyper-V with VirtualBox and Docker VM on Windows 10 Home edition.

I have the following Docker build file:

FROM repositoryname/mssql-server-linux:test-db

RUN mkdir -p /usr/src/app
WORKDIR /usr/src/app

COPY .  /usr/src/app

# start sql, setup db
RUN /opt/mssql/bin/sqlservr & sleep 15s && \
    /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P pass -d master -i /usr/src/app/setup_db_1.sql && \
    /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P pass -d master -i /usr/src/app/setup__db_2.sql

Right now MS SQL Server fails during startup with the following error:

Error 9002. The transaction log for database master is full due to NOTHING

Is there anything I can do (for example add some instructions to my Docker build file) in order to prevent this error?

Also, I found the similar topic here https://social.msdn.microsoft.com/Forums/en-US/ca65a3e2-2f30-4641-a7ea-d3998c8dd8a7/the-transaction-log-for-database-master-is-full-due-to-nothing-during-updade?forum=sqlsetupandupgrade but unfortunately without the proper answer right now.

Upvotes: 1

Views: 371

Answers (0)

Related Questions