Enterprise Install Web UI Errors

---

I am seeing these web ui errors on our main enterprise install. The other thread was for the mangoES.

This error pops up immediately after login, after being redirected to the Watch lists page:

This error is from visiting Data sources if I recall correctly.,

Server error: PreparedStatementCallback; uncategorized SQLException for SQL [SELECT dp.id,dp.data,dp.xid,dp.dataSourceId,dp.name,dp.deviceName,dp.enabled,dp.pointFolderId,dp.loggingType,dp.intervalLoggingPeriodType,dp.intervalLoggingPeriod,dp.intervalLoggingType,dp.tolerance,dp.purgeOverride,dp.purgeType,dp.purgePeriod,dp.defaultCacheSize,dp.discardExtremeValues,dp.engineeringUnits,dp.readPermission,dp.setPermission,dp.templateId,dp.rollup,ds.name,ds.xid,ds.dataSourceType,template.name FROM dataPoints AS dp JOIN dataSources ds ON ds.id = dp.dataSourceId LEFT JOIN templates template ON template.id = dp.templateId ORDER BY dp.deviceName, dp.name OFFSET ? ROWS FETCH NEXT ? ROWS ONLY]; SQL state [90031]; error code [90031]; IO Exception: "java.io.IOException: org.h2.jdbc.JdbcSQLException: IO Exception: ""Missing lob entry: 52283798"" [90028-181]"; "lob: null table: -1 id: 52283798" [90031-181]; nested exception is org.h2.jdbc.JdbcSQLException: IO Exception: "java.io.IOException: org.h2.jdbc.JdbcSQLException: IO Exception: ""Missing lob entry: 52283798"" [90028-181]"; "lob: null table: -1 id: 52283798" [90031-181]```[0_1513353655426_ma.log.1](Uploading 100%)

Should include this log file.

@mihairosu [0_1513353674300_ma.log.1](Uploading 100%)

Not sure why upload is not working for me.

[0_1513353707676_ma.log.1](Uploading 100%)

Here are some excerps:

ERROR 2016-11-07 09:28:36,242 (com.serotonin.m2m2.web.mvc.rest.v1.publisher.pointValue.PointValueWebSocketPublisher.pointTerminated:269) - RemoteEndpoint unavailable, current state [CLOSING], expecting [OPEN or CONNECTED] 
org.eclipse.jetty.websocket.api.WebSocketException: RemoteEndpoint unavailable, current state [CLOSING], expecting [OPEN or CONNECTED]
	at org.eclipse.jetty.websocket.common.WebSocketSession.getRemote(WebSocketSession.java:252)
	at com.serotonin.m2m2.web.mvc.websocket.MangoWebSocketPublisher.sendMessage(MangoWebSocketPublisher.java:138)
	at com.serotonin.m2m2.web.mvc.rest.v1.publisher.pointValue.PointValueWebSocketPublisher.pointTerminated(PointValueWebSocketPublisher.java:266)
	at com.serotonin.m2m2.rt.dataImage.DataPointEventMulticaster.pointTerminated(DataPointEventMulticaster.java:108)
	at com.serotonin.m2m2.rt.dataImage.DataPointEventMulticaster.pointTerminated(DataPointEventMulticaster.java:108)
	at com.serotonin.m2m2.rt.RuntimeManager.stopDataPointShutdown(RuntimeManager.java:556)
	at com.serotonin.m2m2.rt.RuntimeManager.stopDataSourceShutdown(RuntimeManager.java:398)
	at com.serotonin.m2m2.rt.DataSourceGroupTerminator$DataSourceSubGroupTerminator.run(DataSourceGroupTerminator.java:141)
	at com.serotonin.timer.TimerTask.runTask(TimerTask.java:148)
	at com.serotonin.timer.TimerTask.run(TimerTask.java:119)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)
ERROR 2016-11-07 09:28:36,242 (com.serotonin.m2m2.web.mvc.rest.v1.publisher.pointValue.PointValueWebSocketPublisher.pointTerminated:269) - RemoteEndpoint unavailable, current state [CLOSING], expecting [OPEN or CONNECTED] 
org.eclipse.jetty.websocket.api.WebSocketException: RemoteEndpoint unavailable, current state [CLOSING], expecting [OPEN or CONNECTED]
	at org.eclipse.jetty.websocket.common.WebSocketSession.getRemote(WebSocketSession.java:252)
	at com.serotonin.m2m2.web.mvc.websocket.MangoWebSocketPublisher.sendMessage(MangoWebSocketPublisher.java:138)
	at com.serotonin.m2m2.web.mvc.rest.v1.publisher.pointValue.PointValueWebSocketPublisher.pointTerminated(PointValueWebSocketPublisher.java:266)
	at com.serotonin.m2m2.rt.dataImage.DataPointEventMulticaster.pointTerminated(DataPointEventMulticaster.java:109)
	at com.serotonin.m2m2.rt.dataImage.DataPointEventMulticaster.pointTerminated(DataPointEventMulticaster.java:108)
	at com.serotonin.m2m2.rt.RuntimeManager.stopDataPointShutdown(RuntimeManager.java:556)
	at com.serotonin.m2m2.rt.RuntimeManager.stopDataSourceShutdown(RuntimeManager.java:398)
	at com.serotonin.m2m2.rt.DataSourceGroupTerminator$DataSourceSubGroupTerminator.run(DataSourceGroupTerminator.java:141)
	at com.serotonin.timer.TimerTask.runTask(TimerTask.java:148)
	at com.serotonin.timer.TimerTask.run(TimerTask.java:119)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)
ERROR 2016-11-07 09:28:36,243 (com.serotonin.m2m2.web.mvc.rest.v1.publisher.pointValue.PointValueWebSocketPublisher.pointTerminated:269) - RemoteEndpoint unavailable, current state [CLOSING], expecting [OPEN or CONNECTED] 
org.eclipse.jetty.websocket.api.WebSocketException: RemoteEndpoint unavailable, current state [CLOSING], expecting [OPEN or CONNECTED]
	at org.eclipse.jetty.websocket.common.WebSocketSession.getRemote(WebSocketSession.java:252)
	at com.serotonin.m2m2.web.mvc.websocket.MangoWebSocketPublisher.sendMessage(MangoWebSocketPublisher.java:138)
	at com.serotonin.m2m2.web.mvc.rest.v1.publisher.pointValue.PointValueWebSocketPublisher.pointTerminated(PointValueWebSocketPublisher.java:266)
	at com.serotonin.m2m2.rt.dataImage.DataPointEventMulticaster.pointTerminated(DataPointEventMulticaster.java:109)
	at com.serotonin.m2m2.rt.RuntimeManager.stopDataPointShutdown(RuntimeManager.java:556)
	at com.serotonin.m2m2.rt.RuntimeManager.stopDataSourceShutdown(RuntimeManager.java:398)
	at com.serotonin.m2m2.rt.DataSourceGroupTerminator$DataSourceSubGroupTerminator.run(DataSourceGroupTerminator.java:141)
	at com.serotonin.timer.TimerTask.runTask(TimerTask.java:148)
	at com.serotonin.timer.TimerTask.run(TimerTask.java:119)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)
ERROR 2016-11-07 09:28:36,243 (com.serotonin.m2m2.web.mvc.rest.v1.publisher.pointValue.PointValueWebSocketPublisher.pointTerminated:269) - RemoteEndpoint unavailable, current state [CLOSING], expecting [OPEN or CONNECTED] 
org.eclipse.jetty.websocket.api.WebSocketException: RemoteEndpoint unavailable, current state [CLOSING], expecting [OPEN or CONNECTED]
	at org.eclipse.jetty.websocket.common.WebSocketSession.getRemote(WebSocketSession.java:252)
	at com.serotonin.m2m2.web.mvc.websocket.MangoWebSocketPublisher.sendMessage(MangoWebSocketPublisher.java:138)
	at com.serotonin.m2m2.web.mvc.rest.v1.publisher.pointValue.PointValueWebSocketPublisher.pointTerminated(PointValueWebSocketPublisher.java:266)
	at com.serotonin.m2m2.rt.dataImage.DataPointEventMulticaster.pointTerminated(DataPointEventMulticaster.java:108)
	at com.serotonin.m2m2.rt.dataImage.DataPointEventMulticaster.pointTerminated(DataPointEventMulticaster.java:108)
	at com.serotonin.m2m2.rt.RuntimeManager.stopDataPointShutdown(RuntimeManager.java:556)
	at com.serotonin.m2m2.rt.RuntimeManager.stopDataSourceShutdown(RuntimeManager.java:398)
	at com.serotonin.m2m2.rt.DataSourceGroupTerminator$DataSourceSubGroupTerminator.run(DataSourceGroupTerminator.java:141)
	at com.serotonin.timer.TimerTask.runTask(TimerTask.java:148)
	at com.serotonin.timer.TimerTask.run(TimerTask.java:119)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)```

@mihairosu Sounds like it could be disk corruption or out of disk space. Check your disk space and dmesg logs.

Hi Mihai,

The missing lob entry is a known issue in the H2 database. We're updating the library in the 3.3 release and supposedly the lob linking was modified so as to eliminate that error. Often if you retry a query, it will succeed.

There are two main solutions to getting a database throwing that error back to goodness:

1. Do a backup of the database, stop Mango, delete / move the existing Mango/databases/mah2.h2.db, start Mango, do a restart. This will shrink your database some and short alleviate those messages for a while.
2. Switch to MySQL

We're aiming to release 3.3 very early next year, so upgrading to that may also be an option to resolution, once it's released.

Well it's not a space issue, and I sure hope there's no disk corruption. We are using CEPH and it's supposed to be somewhat immune to that, unless of course it's software create corruption.

I look forward to the updates then.

@mihairosu said in Enterprise Install Web UI Errors:

Well it's not a space issue, and I sure hope there's no disk corruption. We are using CEPH and it's supposed to be somewhat immune to that, unless of course it's software create corruption.

I look forward to the updates then.

Yeah I was just throwing that out there, Phillip obviously knows more about this particular issue.