Wireless Access

dear sir

       My company's VirsualRF usually can not starting and showing communicat​ion error timeout，I check the visualRF logs  from the location /var/log/visualrf/visualrf.log，really cannot understand the below error in the log，who can help me, very thanks.

at org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:455)
 at com.sun.proxy.$Proxy25.executeUpdate(Unknown Source)
 at com.airwave.core.data.PersistableClassProxyImpl.store(PersistableClassProxyImpl.java:487)
 at com.airwave.core.data.DatabaseServiceImpl.storeAll(DatabaseServiceImpl.java:863)
 at com.airwave.core.data.DatabaseServiceImpl.store(DatabaseServiceImpl.java:851)
 at com.airwave.core.data.DatabaseServiceImpl.event(DatabaseServiceImpl.java:465)
 at sun.reflect.GeneratedMethodAccessor53.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at com.airwave.core.AbstractService._work(AbstractService.java:195)
 at com.airwave.core.AbstractTransactionAwareService$TransactionTask.run(AbstractTransactionAwareService.java:40)
 at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
 at java.util.concurrent.FutureTask.run(Unknown Source)
 at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
 at java.lang.Thread.run(Unknown Source)
2016-05-12 05:59:14,756 ERROR Database[1]  com.airwave.core.data.PersistableClassProxyImpl Problem storing persistable instance Type[com.airwave.model.Radio] Key[5E:AA:FD:9F:F3:CE.n]
2016-05-12 05:59:14,756 ERROR Database[1]  com.airwave.core.data.DatabaseServiceImpl store [Type[com.airwave.model.Radio] Key[5E:AA:FD:9F:F3:CE.n]]
org.postgresql.util.PSQLException: ERROR: insert or update on table "device_radio" violates foreign key constraint "device_radio_device"
  Detail: Key (radio_mac)=(5E:AA:FD:9F:F3:CE) is not present in table "device".
 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
 at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
 at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
 at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
 at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
 at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334)
 at sun.reflect.GeneratedMethodAccessor42.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:455)
 at com.sun.proxy.$Proxy25.executeUpdate(Unknown Source)
 at com.airwave.core.data.PersistableClassProxyImpl.store(PersistableClassProxyImpl.java:487)
 at com.airwave.core.data.DatabaseServiceImpl.storeAll(DatabaseServiceImpl.java:863)
 at com.airwave.core.data.DatabaseServiceImpl.store(DatabaseServiceImpl.java:851)
 at com.airwave.core.data.DatabaseServiceImpl.event(DatabaseServiceImpl.java:465)
 at sun.reflect.GeneratedMethodAccessor53.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at com.airwave.core.AbstractService._work(AbstractService.java:195)
 at com.airwave.core.AbstractTransactionAwareService$TransactionTask.run(AbstractTransactionAwareService.java:40)
 at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
 at java.util.concurrent.FutureTask.run(Unknown Source)
 at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
 at java.lang.Thread.run(Unknown Source)
2016-05-12 05:59:16,198 ERROR Database[1]  com.airwave.core.data.PersistableClassProxyImpl Problem storing persistable instance Type[com.airwave.model.Radio] Key[5E:AA:FD:9F:F3:52.n]
2016-05-12 05:59:16,198 ERROR Database[1]  com.airwave.core.data.DatabaseServiceImpl store [Type[com.airwave.model.Radio] Key[5E:AA:FD:9F:F3:52.n]]
org.postgresql.util.PSQLException: ERROR: insert or update on table "device_radio" violates foreign key constraint "device_radio_device"
  Detail: Key (radio_mac)=(5E:AA:FD:9F:F3:52) is not present in table "device".
 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
 at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)

Not sure what the actual issue is but your log keeps referecing the device 5E:AA:FD:9F:F3:52. Is there any issues within this in AirWave? May try deleting/re-adding it?

Open a TAC case - we had a similar sounding issue and had to have TAC provide a test verio nof the visualRF package to alleviate.

It's much better now.

edit: I'm running 8.2.0.2 - your mileage may vary

dear Sir

        My boss made two adjustments, disable HTML5-based UI and memory allocation transferred to 2GB (previously 512Mb), The VisualRF is functioning properly, so set correctly?

The memory allocation is likely what gave you a better performance, but I can't tell you if that's the "right" setting without knowing a great deal more about your environment - VisualRF basically has to keep track of every client and AP and their signal levels on every square-foot of each floorplan and tuning will need to take all of that into account.

If you aren't sure it's running correctly (or even if you are) it might be good to have TAC take a look.