db container exited with code 0 about mssql-node-docker-demo-app

[tobske]

I don't use the npm part of the setup and only execute sqlserver and import-data.sh in the entrypoint.sh. If I kept the order of those two the same in the entrypoint.sh my container is stopping at the end, too. If I switch those two the container stays up. The reason is that because of the & the first command is executed in the in a subshell which means that the outer shell does not wait for this command to finish so it only waits for the second command. If this second command is the import-data.sh which ends after sometime the whole shell and so the whole container will finish. It the order is switched the outer shell is waiting for the sqlserver to end and as this command does not end normally the container stays open.

There is some explanation for this here: https://www.gnu.org/software/bash/manual/bash.html#Lists

Maybe this helps someone with a similar issue.

[aplanting]

the problem is with the bulk load of the file. Inspect the logs with docker logs <container_id>

Starting copy... SQLState = S1000, NativeError = 0 Error = [Microsoft][ODBC Driver 13 for SQL Server]Unexpected EOF encountered in BCP data-file
then the container stops. the scripts starts after 90 seconds.

I have converted the file endings to because i run on Linux to LF and the error goes away but still the container exits.

the BCP is causing the problem I guess

** update **
When removing the import-data.sh script completely the container stays up. BCP is not the problem because setup.sql also causes the container to stop.

[twright-msft]

Yes, exactly @tobske . We've recently updated the documentation to provide this tip as well. https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-configure-docker?view=sql-server-linux-2017#customcontainer
@rdalfonso abd @aplanting - can you confirm that changing the order of the commands resolves the issue for you?

[MarlomSouza]

@twright-msft , I can confirm that if you change the order the container will continue running. There is an exemple in my github.
https://github.com/MarlomSouza/database_docker

[twright-msft]

Thanks for sharing @MarlomSouza . I'm going to go ahead and close out this issue. @rdalfonso or @aplanting - if this is still an issue after trying the above recommendations, please reactivate.