• Recent
    • Tags
    • Popular
    • Register
    • Login

    Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.

    Radix IoT Website Mango 3 Documentation Website Mango 4 Documentation Website Mango 5 Documentation Website

    Enterprise Install Web UI Errors

    Scheduled Pinned Locked Moved User help
    7 Posts 3 Posters 1.7k Views 3 Watching
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • M Offline
      mihairosu
      last edited by mihairosu

      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:

      0_1513353516622_mango error1.png

      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%)
      M 1 Reply Last reply Reply Quote 0
      • M Offline
        mihairosu @mihairosu
        last edited by

        Should include this log file.

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

        1 Reply Last reply Reply Quote 0
        • M Offline
          mihairosu
          last edited by

          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)```
          1 Reply Last reply Reply Quote 0
          • Jared WiltshireJ Offline
            Jared Wiltshire
            last edited by

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

            Developer at Radix IoT

            1 Reply Last reply Reply Quote 0
            • phildunlapP Offline
              phildunlap
              last edited by phildunlap

              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.

              1 Reply Last reply Reply Quote 0
              • M Offline
                mihairosu
                last edited by

                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.

                Jared WiltshireJ 1 Reply Last reply Reply Quote 0
                • Jared WiltshireJ Offline
                  Jared Wiltshire @mihairosu
                  last edited by

                  @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.

                  Developer at Radix IoT

                  1 Reply Last reply Reply Quote 0
                  • First post
                    Last post