1

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.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
alexanoid
  • 24,051
  • 54
  • 210
  • 410
  • Your docker builds fine and run has a issue? Can you post `docker inspect ` for the failed container on http://pastebin.com? – Tarun Lalwani Oct 21 '17 at 16:39
  • Yes, the docker builds fine but run has the mentioned issue. This issue appears on the latest rebuild from the official microsoft/mssql-server-linux image – alexanoid Oct 21 '17 at 18:45
  • I think you issue issue would be this https://docs.docker.com/engine/reference/builder/#notes-about-specifying-volumes. `Changing the volume from within the Dockerfile: If any build steps change the data within the volume after it has been declared, those changes will be discarded.` – Tarun Lalwani Oct 21 '17 at 20:17
  • Thanks for your answer. Maybe I didn't get it but the biggest my concern is that everything was working fine before the last update... – alexanoid Oct 21 '17 at 20:20
  • Can you use a older tag to test it ? – Tarun Lalwani Oct 21 '17 at 20:21
  • This is my biggest issue :( Unfortunately, we didn't save the previous tag – alexanoid Oct 21 '17 at 20:23
  • Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/157201/discussion-between-tarun-lalwani-and-alexanoid). – Tarun Lalwani Oct 21 '17 at 20:27

0 Answers0