Very log startup

[przemom]

Hi,
I have problem with mango scada...it starts very long. The start time can take up to 30 min...
There is no errors in ma.log. Where can be problem. I have tested the same version of mango scada on other machine (the same type) and it started in about 1 minute.

[phildunlap]

Hi przemom,

A few questions,

1. What is your database backend? Are you using the NoSQL module?
2. How many data points does the Mango have?
3. What percentage through the startup does the delay happen at?

[przemom]

Hi,
ad. 1. in classes/env.properties I have selected h2 but in overrides/classes/env.properties I have selected mysql. I guess that mysql backend is used
ad. 2. 50
ad.3. 88%

[phildunlap]

Hmm. I would expect you're still on H2 then. Your env.properties file gets overridden in Mango/overrides/properties/env.properties . You could confirm that it's H2 by checking at the top of your system settings page, or seeing if there is a decent size file at Mango/databases/mah2.h2.db

Pausing at 88% suggests to me that in your env.properties file "swagger.enabled=true" . Swagger can definitely add a minute or two to startup, as it constructs the page at host:ip/swagger . If you are not using swagger, you could disable that property.

Can you post a picture of it paused at 50% and what it says? The steps at 50% should be quite fast.

[przemom]

Mariadb is a backend. It slack on 88%.

[phildunlap]

Okay, i agree it is on a MySQL or Maria from the log image. For 75%, I would ask the size of the PointValues table... But, from the image you shared, 75% should only be taking 1608 + 1861 + 2811 +8339 = 14.6s so I wouldn't think that's really a major slowdown. Was saying it was paused at 50% incorrect? I still believe 88% relates to having swagger enabled in your env.properties.

[przemom]

Thanks,
after disabling swagger

#For rest API Documentation at /swagger/index.html
swagger.enabled=false

startup took ~4minutes, thanks. Problem solved.

[phildunlap]

Glad to hear it!