Mango System starts up and operates, but now when I log into the editor the mango system comes to a screeching halt? Any thoughts?

[srennhack]

That was probably 3-4 weeks ago.

[phildunlap]

I was trying to suss out and ensure you've used the memory-large.bat, not the .sh

You can purge the events by shutting Mango down, using Mango/bin/h2-web-console.bat (edit to have the -webAllowOthers if you're not working on the machine running this and you need to connect to the web console from another IP) and then running

delete from userEvents;
delete from events;

You can find your login information for the web console in your env.properties file. You may also be able to access the interface if you start Mango in safe mode (by creating the file Mango/SAFE and then starting Mango), as some of your stack traces indicate your scripts may be one of the offenders as well. Then you could purge your events from the Purge Settings section of the system settings page.

[srennhack]

OK, shutting down mango, I am not working on the machine running mango right now, but it is right here next to me.
so do i need to go through changing the h2-web-console.bat on the mango computer?

[phildunlap]

Yes.

[srennhack]

OK I have done that, now how do I connect to the web console from this computer? Remember I'm not a programmer, and am trying to learn as I go here.

[phildunlap]

No worries.

@echo off
rem
rem | Copyright (C) 2006-2015 //infintie Automation. All rights reserved.
rem | @author Phillip Dunlap
rem
rem | Runs H2 Web Console. (Script Version 1.0.0 - To be run from MA_HOME\bin)

rem | Define the port to start H2 on...
set H2_PORT=8085

rem | Check if MA_HOME is properly defined
if "%MA_HOME%" == "" goto useCD
if exist "%MA_HOME%\bin\ma-start.bat" goto okHome
echo The MA_HOME environment variable is not defined correctly: %MA_HOME%. Trying the current directory instead...

rem | Check if the current directory is ok to use
:useCD
set BIN_DIR=%CD%
pushd ..
set MA_HOME=%CD%
popd
if exist "%MA_HOME%\bin\ma-start.bat" goto okHome

rem | Don't know where home is.
echo Cannot determine the MA home directory
goto end

rem | Found a good home. Carry on...
:okHome
echo Using %MA_HOME% as MA_HOME

set EXECJAVA=java
if "%JAVA_HOME%" == "" goto gotJava
set EXECJAVA=%JAVA_HOME%\bin\java

:gotJava
echo Using Java at %EXECJAVA%

rem | Put the whole lib folder on CP because we cannot do h2*.jar...
rem | Add -webAllowOthers if you will be using the web console from an origin other than localhost
"%EXECJAVA%" -cp "%MA_HOME%\lib\*" org.h2.tools.Server -web -webPort "%H2_PORT%" -baseDir "%MA_HOME%\"

:end

So -webAllowOthers has been added somewhere on the "%EXECJAVA% line, probably best as ... -web -webAllowOthers -webPort ...

Now run the h2-web-console.bat script, and navigate to http://[the computer ip]:8085

You can see the port is defined in the script as H2_PORT

[srennhack]

ok in the H2 port.

[srennhack]

I have been out of the office for several weeks, and am just getting back to this. I am still unable to get into the developer without the mango system freezing up. Here is a screen shot of when I tried to go into the reports at 12:08 today. The hard drive seems to be searching constantly never stops.

[phildunlap]

Hi srennhack,

Of the steps I have offered, which have you done? Did you purge your events tables?

Do you still have out of memory errors in your Mango/logs/ma.log file?

[srennhack]

The only step not tried is starting Mango in the safe mode. I did not see out of memory errors today.

[phildunlap]

Ah. I asked because there events didn't load in your header in the screenshot, which would lead me to believe you still have a very large events table (or you recently purged and have no events in the events table). The exception from the Meta point is unrelated to the performance issue beyond its being an event. How large is your events table currently?

You can try purging your audit table too, running DELETE FROM audit; either in the H2 web console or in the SQL console page.

There can be a caching issue on the excel reports page sometimes where the first time you load the page it doesn't pull up the list of templates. If you refresh this almost always brings up the list.

If the hard drive is going crazy, is it with reads or writes? If you have tons of meta points running often doing .past(MINUTE, 5) type operations, that would be a heavy read load. There are solutions to convert that over to using the cache. If you have lots of point values waiting to be written (check this on your /internal/status.shtm page), you can adjust the NoSQL settings to delay more for small batches and increase the small batch size.

[phildunlap]

Also, you can get the actual text of the stack traces you wish to post from the Mango/logs/ma.log or Mango/bin/logs/ma.log file. it's a lot better than screenshots of command prompts.

[srennhack]

@phildunlap
I guess I am just confused that the Mango data collection and screens that were created prior to Nov. of last year all work perfectly fine upon a restart of the system. And it is only when I try to go into the developer that everything stops working? I did create some reports back in Oct of last year that read string files from the AB PLC, and they are checking those points every 30 seconds. and the report is setup for a past 24hr period. and that all worked fine also up until the point that the Java system was upgraded, which appears to be the point where the problems accessing the Mango development screens started to occur. What can I give/send you that might help in resolving this? I don't feel that I am explaining things correctly, and not being a computer programmer, I am mostly lost with what you are telling me. as I don't know how to or where to access some of the files and setups you have described. I apologize for my lack of knowledge in this area.

[phildunlap]

No worries. It is a lot easier to provide support if you are able to get text from your ma.log file. What are you unaware of how to access? You are navigating around the Mango/ directory in a Windows explorer, correct? Your ma.log file is the place to start. Any path I provide that begins with Mango/ is in your Mango's root directory, which it'll say it's using as MA_HOME during startup.

I don't know what you mean "the developer" as a location. It's best to take your nouns from the program, as then we're on the same page.

I would guess the upgrade to Java was incidental. If you were using a JDK, and are still, that's probably not the problem.

[srennhack]

@phildunlap
Log file attached
[0_1516188987376_ma.log.5.5](Uploading 100%)
At about 8:04 yesterday i tried to log into the mango system to try and edit, but at that point everything stopped, and I had to restart the system.

[phildunlap]

The log didn't upload. You need to wait for it to turn into a link in the preview section. I have the greatest luck with the "upload file" button above the composition window.

[srennhack]

[0_1516276596205_ma.log.5](Uploading 100%)
When I try uploading, I get the following error:

[srennhack]

@srennhack said in Mango System starts up and operates, but now when I log into the editor the mango system comes to a screeching halt? Any thoughts?:

[0_1516276596205_ma.log.5](Uploading 100%)
When I try uploading, I get the following error:

Is there anything else I can do? Is there an e-mail that I can send the file to?
I really need to get this issue resolved,

[phildunlap]

Hi srennhack,

We discourage posting personal information. support@infiniteautomation.com is our support email address. I retained your contact information.

[phildunlap]

Resolution was found in purging the events and userEvents tables through the Mango/bin/h2-web-console.sh script (but may have been possible through the Mango interface on the SQL console page, or just purging events in the purge settings). Then, the database was backed up and restored, which reduced its on disk size from 3.8GB to about 26MB