search

smartstore / Smartstore

A modular, scalable and ultra-fast open-source all-in-one eCommerce platform built on ASP.NET Core 7
http://www.smartstore.com/
GNU Affero General Public License v3.0
1.11k stars 408 forks source link

An error occured setting up MSSql DB. #702

Open adminy opened 1 year ago

adminy commented 1 year ago

Describing the bug

An error occurred: 'matteblack_gray'
An error occurred: 'matteblack_gray'
An error occurred: 'matteblack_gray'
An error occurred: 'polishedwhite_gray'
An error occurred: 'polishedwhite_gray'
An error occurred: 'polishedwhite_gray'
An error occurred: 'skyblue_gray'
An error occurred: 'skyblue_gray'
An error occurred: 'skyblue_gray'
An error occurred: 'orangeflare_gray'
An error occurred: 'orangeflare_gray'
An error occurred: 'orangeflare_gray'
An error occurred: 'redline_gray'
An error occurred: 'redline_gray'
An error occurred: 'redline_gray'
An error occurred: 'matteblack_sapphireiridium'
An error occurred: 'matteblack_sapphireiridium'
An error occurred: 'matteblack_sapphireiridium'
An error occurred: 'polishedwhite_sapphireiridium'
An error occurred: 'polishedwhite_sapphireiridium'
An error occurred: 'polishedwhite_sapphireiridium'
An error occurred: 'skyblue_sapphireiridium'
An error occurred: 'skyblue_sapphireiridium'
An error occurred: 'skyblue_sapphireiridium'
An error occurred: 'orangeflare_sapphireiridium'
An error occurred: 'orangeflare_sapphireiridium'
An error occurred: 'orangeflare_sapphireiridium'
An error occurred: 'redline_sapphireiridium'
An error occurred: 'redline_sapphireiridium'
An error occurred: 'redline_sapphireiridium'
An error occurred: 'matteblack_violetiridium'
An error occurred: 'matteblack_violetiridium'
An error occurred: 'matteblack_violetiridium'
An error occurred: 'polishedwhite_violetiridium'
An error occurred: 'polishedwhite_violetiridium'
An error occurred: 'polishedwhite_violetiridium'
An error occurred: 'skyblue_violetiridium'
An error occurred: 'skyblue_violetiridium'
An error occurred: 'skyblue_violetiridium'
An error occurred: 'orangeflare_violetiridium'
An error occurred: 'orangeflare_violetiridium'
An error occurred: 'orangeflare_violetiridium'
An error occurred: 'redline_violetiridium'
An error occurred: 'redline_violetiridium'
An error occurred: 'redline_violetiridium'
An error occurred: 'matteblack_jadeiridium'
An error occurred: 'matteblack_jadeiridium'
An error occurred: 'matteblack_jadeiridium'
An error occurred: 'polishedwhite_jadeiridium'
An error occurred: 'polishedwhite_jadeiridium'
An error occurred: 'polishedwhite_jadeiridium'
An error occurred: 'skyblue_jadeiridium'
An error occurred: 'skyblue_jadeiridium'
An error occurred: 'skyblue_jadeiridium'
An error occurred: 'orangeflare_jadeiridium'
An error occurred: 'orangeflare_jadeiridium'
An error occurred: 'orangeflare_jadeiridium'
An error occurred: 'redline_jadeiridium'
An error occurred: 'redline_jadeiridium'
An error occurred: 'redline_jadeiridium'
An error occurred: 'matteblack_rubyiridium'
An error occurred: 'matteblack_rubyiridium'
An error occurred: 'matteblack_rubyiridium'
An error occurred: 'polishedwhite_rubyiridium'
An error occurred: 'polishedwhite_rubyiridium'
An error occurred: 'polishedwhite_rubyiridium'
An error occurred: 'skyblue_rubyiridium'
An error occurred: 'skyblue_rubyiridium'
An error occurred: 'skyblue_rubyiridium'
An error occurred: 'orangeflare_rubyiridium'
An error occurred: 'orangeflare_rubyiridium'
An error occurred: 'orangeflare_rubyiridium'
An error occurred: 'redline_rubyiridium'
An error occurred: 'redline_rubyiridium'
An error occurred: 'redline_rubyiridium'
An error occurred: 'matteblack_24kiridium'
An error occurred: 'matteblack_24kiridium'
An error occurred: 'matteblack_24kiridium'
An error occurred: 'polishedwhite_24kiridium'
An error occurred: 'polishedwhite_24kiridium'
An error occurred: 'polishedwhite_24kiridium'
An error occurred: 'skyblue_24kiridium'
An error occurred: 'skyblue_24kiridium'
An error occurred: 'skyblue_24kiridium'
An error occurred: 'orangeflare_24kiridium'
An error occurred: 'orangeflare_24kiridium'
An error occurred: 'orangeflare_24kiridium'
An error occurred: 'redline_24kiridium'
An error occurred: 'redline_24kiridium'
An error occurred: 'redline_24kiridium'
An error occurred: 'matteblack_positiverediridium'
An error occurred: 'matteblack_positiverediridium'
An error occurred: 'matteblack_positiverediridium'
An error occurred: 'polishedwhite_positiverediridium'
An error occurred: 'polishedwhite_positiverediridium'
An error occurred: 'polishedwhite_positiverediridium'
An error occurred: 'skyblue_positiverediridium'
An error occurred: 'skyblue_positiverediridium'
An error occurred: 'skyblue_positiverediridium'
An error occurred: 'orangeflare_positiverediridium'
An error occurred: 'orangeflare_positiverediridium'
An error occurred: 'orangeflare_positiverediridium'
An error occurred: 'redline_positiverediridium'
An error occurred: 'redline_positiverediridium'
An error occurred: 'redline_positiverediridium'
An error occurred: 'matteblack_clear'
An error occurred: 'matteblack_clear'
An error occurred: 'matteblack_clear'
An error occurred: 'polishedwhite_clear'
An error occurred: 'polishedwhite_clear'
An error occurred: 'polishedwhite_clear'
An error occurred: 'skyblue_clear'
An error occurred: 'skyblue_clear'
An error occurred: 'skyblue_clear'
An error occurred: 'orangeflare_clear'
An error occurred: 'orangeflare_clear'
An error occurred: 'orangeflare_clear'
An error occurred: 'redline_clear'
An error occurred: 'redline_clear'
An error occurred: 'redline_clear'
An error occurred: 'matteblack_fireiridium'
An error occurred: 'matteblack_fireiridium'
An error occurred: 'matteblack_fireiridium'
An error occurred: 'polishedwhite_fireiridium'
An error occurred: 'polishedwhite_fireiridium'
An error occurred: 'polishedwhite_fireiridium'
An error occurred: 'skyblue_fireiridium'
An error occurred: 'skyblue_fireiridium'
An error occurred: 'skyblue_fireiridium'
An error occurred: 'orangeflare_fireiridium'
An error occurred: 'orangeflare_fireiridium'
An error occurred: 'orangeflare_fireiridium'
An error occurred: 'redline_fireiridium'
An error occurred: 'redline_fireiridium'
An error occurred: 'redline_fireiridium'
RecoveryUnit::Shutdown. IsOnline: 02023-05-12 13:19:31.56 spid67s     RBPEX::NotifyFileShutdown: Called for database ID: [5], file Id [0]
Web exited with code 0

To Reproduce Using the following containers mcr.microsoft.com/mssql/server & ghcr.io/smartstore/smartstore-linux:latest out of the box as they are: UI says:

Yippieee! The installation was completed successfully ;-) Your shop is being started now...
If you are not automatically redirected to the home page of the store please click [here](http://192.168.8.78:8765/)

While the database has the above logs. then the web app exits completely.

Expected behavior Setup DB, brings to home screen, no logs like above in the db side.

Desktop (please complete the following information):

muratcakir commented 1 year ago

Could you please try again with the nightly Smartstore build ghcr.io/smartstore/smartstore-linux:nightly? Does it still raise the same exceptions?

adminy commented 1 year ago

Same thing is happening.

zihniartar commented 1 year ago

This is a quirk we have noticed with NET and Docker that Smartstore cannot restart after installation. This behavior is exhibited by many NET based apps in Docker.

The workaround is to manually restart the container or if using a Docker compose file, add a restart: unless-stopped entry in the docker-compose.yaml file like this:

version: "3.4"
services:
  web:
    image: ghcr.io/smartstore/smartstore-linux:nightly
    container_name: web
    ports:
      - "80:80"
    restart: unless-stopped
    depends_on:
....