text:
stats command does not work with postgresql

What happened?
Running the stats command in the live console terminates the CLI when postgresql is used.
Note: I'm aware that postgresql is still beta! Just wanted to document this.
Reposilite version
3.x
Relevant log output
17:48:33.430 INFO | CLI | florianfriedrich@/xxx.xxx.xxx.xxx:45828> stats

17:48:33.441 WARN | Transaction attempt #0 failed: org.postgresql.util.PSQLException: ERROR: column "statistics_resolved_identifier.id" must appear in the GROUP BY clause or be used in an aggregate function   Position: 30. Statement(s): SELECT statistics_resolved_identifier_id, statistics_resolved_identifier_identifier_id, statistics_resolved_identifier_date, statistics_resolved_identifier_count FROM (SELECT statistics_resolved_identifier.id, statistics_resolved_identifier.identifier_id, statistics_resolved_identifier."date", statistics_resolved_identifier."count" FROM statistics_resolved_identifier GROUP BY statistics_resolved_identifier.identifier_id) subquery: org.jetbrains.exposed.exceptions.ExposedSQLException: org.postgresql.util.PSQLException: ERROR: column "statistics_resolved_identifier.id" must appear in the GROUP BY clause or be used in an aggregate function   Position: 30 at org.jetbrains.exposed.sql.statements.Statement.executeIn$exposed_core(Statement.kt:64) at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:144) at org.jetbrains.exposed.sql.Query.count(Query.kt:199) at org.jetbrains.exposed.sql.Query.count(Query.kt:192) at com.reposilite.statistics.infrastructure.SqlStatisticsRepository$countUniqueResolvedRequests$1.invoke(SqlStatisticsRepository.kt:133) at com.reposilite.statistics.infrastructure.SqlStatisticsRepository$countUniqueResolvedRequests$1.invoke(SqlStatisticsRepository.kt:130) at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.inTopLevelTransaction$run(ThreadLocalTransactionManager.kt:189) at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.access$inTopLevelTransaction$run(ThreadLocalTransactionManager.kt:1) at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$inTopLevelTransaction$1.invoke(ThreadLocalTransactionManager.kt:215) at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.keepAndRestoreTransactionRefAfterRun(ThreadLocalTransactionManager.kt:223) at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.inTopLevelTransaction(ThreadLocalTransactionManager.kt:214) at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$transaction$1.invoke(ThreadLocalTransactionManager.kt:165) at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.keepAndRestoreTransactionRefAfterRun(ThreadLocalTransactionManager.kt:223) at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction(ThreadLocalTransactionManager.kt:135) at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction(ThreadLocalTransactionManager.kt:132) at com.reposilite.statistics.infrastructure.SqlStatisticsRepository.countUniqueResolvedRequests(SqlStatisticsRepository.kt:130) at com.reposilite.statistics.StatisticsFacade.countUniqueRecords(StatisticsFacade.kt:65) at com.reposilite.statistics.StatsCommand.execute(StatsCommand.kt:41) at com.reposilite.console.CommandExecutor.executeCommand(CommandExecutor.kt:70) at com.reposilite.console.CommandExecutor.execute(CommandExecutor.kt:46) at com.reposilite.console.CommandExecutor.execute(CommandExecutor.kt:43) at com.reposilite.console.ConsoleFacade.executeCommand(ConsoleFacade.kt:48) at com.reposilite.console.infrastructure.CliEndpoint.initializeAuthenticatedContext$lambda-10(ConsoleWebSocketHandler.kt:96) at io.javalin.websocket.WsConnection$onMessage$1.invoke(WsConnection.kt:38) at io.javalin.websocket.WsConnection$onMessage$1.invoke(WsConnection.kt:38) at io.javalin.websocket.WsConnection.tryBeforeAndEndpointHandlers(WsConnection.kt:71) at io.javalin.websocket.WsConnection.onMessage(WsConnection.kt:38) at jdk.internal.reflect.GeneratedMethodAccessor14.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:567) at org.eclipse.jetty.websocket.common.events.annotated.CallableMethod.call(CallableMethod.java:70) at org.eclipse.jetty.websocket.common.events.annotated.OptionalSessionCallableMethod.call(OptionalSessionCallableMethod.java:68) at org.eclipse.jetty.websocket.common.events.JettyAnnotatedEventDriver.onTextMessage(JettyAnnotatedEventDriver.java:301) at org.eclipse.jetty.websocket.common.message.SimpleTextMessage.messageComplete(SimpleTextMessage.java:69) at org.eclipse.jetty.websocket.common.events.AbstractEventDriver.appendMessage(AbstractEventDriver.java:67) at org.eclipse.jetty.websocket.common.events.JettyAnnotatedEventDriver.onTextFrame(JettyAnnotatedEventDriver.java:287) at org.eclipse.jetty.websocket.common.events.AbstractEventDriver.incomingFrame(AbstractEventDriver.java:152) at org.eclipse.jetty.websocket.common.WebSocketSession.incomingFrame(WebSocketSession.java:326) at org.eclipse.jetty.websocket.common.extensions.AbstractExtension.nextIncomingFrame(AbstractExtension.java:148) at org.eclipse.jetty.websocket.common.extensions.compress.PerMessageDeflateExtension.nextIncomingFrame(PerMessageDeflateExtension.java:111) at org.eclipse.jetty.websocket.common.extensions.compress.CompressExtension.forwardIncoming(CompressExtension.java:169) at org.eclipse.jetty.websocket.common.extensions.compress.PerMessageDeflateExtension.incomingFrame(PerMessageDeflateExtension.java:90) at org.eclipse.jetty.websocket.common.extensions.ExtensionStack.incomingFrame(ExtensionStack.java:202) at org.eclipse.jetty.websocket.common.Parser.notifyFrame(Parser.java:225) at org.eclipse.jetty.websocket.common.Parser.parseSingleFrame(Parser.java:259) at org.eclipse.jetty.websocket.common.io.AbstractWebSocketConnection.onFillable(AbstractWebSocketConnection.java:459) at org.eclipse.jetty.websocket.common.io.AbstractWebSocketConnection.onFillable(AbstractWebSocketConnection.java:440) at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131) at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:409) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883) at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034) at java.base/java.lang.Thread.run(Thread.java:831) Caused by: org.postgresql.util.PSQLException: ERROR: column "statistics_resolved_identifier.id" must appear in the GROUP BY clause or be used in an aggregate function   Position: 30 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2675) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2365) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:355) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:490) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:408) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:166) at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:118) at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java) at org.jetbrains.exposed.sql.statements.jdbc.JdbcPreparedStatementImpl.executeQuery(JdbcPreparedStatementImpl.kt:24) at org.jetbrains.exposed.sql.Query.executeInternal(Query.kt:102) at org.jetbrains.exposed.sql.Query.executeInternal(Query.kt:18) at org.jetbrains.exposed.sql.statements.Statement.executeIn$exposed_core(Statement.kt:62) ... 57 more

17:48:33.444 DEBUG | HikariPool-1 - Reset (autoCommit) on connection org.postgresql.jdbc.PgConnection@56fc9205

17:48:33.444 WARN | Transaction attempt #1 failed: org.postgresql.util.PSQLException: ERROR: column "statistics_resolved_identifier.id" must appear in the GROUP BY clause or be used in an aggregate function   Position: 30. Statement(s): SELECT statistics_resolved_identifier_id, statistics_resolved_identifier_identifier_id, statistics_resolved_identifier_date, statistics_resolved_identifier_count FROM (SELECT statistics_resolved_identifier.id, statistics_resolved_identifier.identifier_id, statistics_resolved_identifier."date", statistics_resolved_identifier."count" FROM statistics_resolved_identifier GROUP BY statistics_resolved_identifier.identifier_id) subquery: org.jetbrains.exposed.exceptions.ExposedSQLException: org.postgresql.util.PSQLException: ERROR: column "statistics_resolved_identifier.id" must appear in the GROUP BY clause or be used in an aggregate function   Position: 30 at org.jetbrains.exposed.sql.statements.Statement.executeIn$exposed_core(Statement.kt:64) at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:144) at org.jetbrains.exposed.sql.Query.count(Query.kt:199) at org.jetbrains.exposed.sql.Query.count(Query.kt:192) at com.reposilite.statistics.infrastructure.SqlStatisticsRepository$countUniqueResolvedRequests$1.invoke(SqlStatisticsRepository.kt:133) at com.reposilite.statistics.infrastructure.SqlStatisticsRepository$countUniqueResolvedRequests$1.invoke(SqlStatisticsRepository.kt:130) at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.inTopLevelTransaction$run(ThreadLocalTransactionManager.kt:189) at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.access$inTopLevelTransaction$run(ThreadLocalTransactionManager.kt:1) at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$inTopLevelTransaction$1.invoke(ThreadLocalTransactionManager.kt:215) at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.keepAndRestoreTransactionRefAfterRun(ThreadLocalTransactionManager.kt:223) at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.inTopLevelTransaction(ThreadLocalTransactionManager.kt:214) at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$transaction$1.invoke(ThreadLocalTransactionManager.kt:165) at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.keepAndRestoreTransactionRefAfterRun(ThreadLocalTransactionManager.kt:223) at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction(ThreadLocalTransactionManager.kt:135) at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction(ThreadLocalTransactionManager.kt:132) at com.reposilite.statistics.infrastructure.SqlStatisticsRepository.countUniqueResolvedRequests(SqlStatisticsRepository.kt:130) at com.reposilite.statistics.StatisticsFacade.countUniqueRecords(StatisticsFacade.kt:65) at com.reposilite.statistics.StatsCommand.execute(StatsCommand.kt:41) at com.reposilite.console.CommandExecutor.executeCommand(CommandExecutor.kt:70) at com.reposilite.console.CommandExecutor.execute(CommandExecutor.kt:46) at com.reposilite.console.CommandExecutor.execute(CommandExecutor.kt:43) at com.reposilite.console.ConsoleFacade.executeCommand(ConsoleFacade.kt:48) at com.reposilite.console.infrastructure.CliEndpoint.initializeAuthenticatedContext$lambda-10(ConsoleWebSocketHandler.kt:96) at io.javalin.websocket.WsConnection$onMessage$1.invoke(WsConnection.kt:38) at io.javalin.websocket.WsConnection$onMessage$1.invoke(WsConnection.kt:38) at io.javalin.websocket.WsConnection.tryBeforeAndEndpointHandlers(WsConnection.kt:71) at io.javalin.websocket.WsConnection.onMessage(WsConnection.kt:38) at jdk.internal.reflect.GeneratedMethodAccessor14.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:567) at org.eclipse.jetty.websocket.common.events.annotated.CallableMethod.call(CallableMethod.java:70) at org.eclipse.jetty.websocket.common.events.annotated.OptionalSessionCallableMethod.call(OptionalSessionCallableMethod.java:68) at org.eclipse.jetty.websocket.common.events.JettyAnnotatedEventDriver.onTextMessage(JettyAnnotatedEventDriver.java:301) at org.eclipse.jetty.websocket.common.message.SimpleTextMessage.messageComplete(SimpleTextMessage.java:69) at org.eclipse.jetty.websocket.common.events.AbstractEventDriver.appendMessage(AbstractEventDriver.java:67) at org.eclipse.jetty.websocket.common.events.JettyAnnotatedEventDriver.onTextFrame(JettyAnnotatedEventDriver.java:287) at org.eclipse.jetty.websocket.common.events.AbstractEventDriver.incomingFrame(AbstractEventDriver.java:152) at org.eclipse.jetty.websocket.common.WebSocketSession.incomingFrame(WebSocketSession.java:326) at org.eclipse.jetty.websocket.common.extensions.AbstractExtension.nextIncomingFrame(AbstractExtension.java:148) at org.eclipse.jetty.websocket.common.extensions.compress.PerMessageDeflateExtension.nextIncomingFrame(PerMessageDeflateExtension.java:111) at org.eclipse.jetty.websocket.common.extensions.compress.CompressExtension.forwardIncoming(CompressExtension.java:169) at org.eclipse.jetty.websocket.common.extensions.compress.PerMessageDeflateExtension.incomingFrame(PerMessageDeflateExtension.java:90) at org.eclipse.jetty.websocket.common.extensions.ExtensionStack.incomingFrame(ExtensionStack.java:202) at org.eclipse.jetty.websocket.common.Parser.notifyFrame(Parser.java:225) at org.eclipse.jetty.websocket.common.Parser.parseSingleFrame(Parser.java:259) at org.eclipse.jetty.websocket.common.io.AbstractWebSocketConnection.onFillable(AbstractWebSocketConnection.java:459) at org.eclipse.jetty.websocket.common.io.AbstractWebSocketConnection.onFillable(AbstractWebSocketConnection.java:440) at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131) at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:409) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883) at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034) at java.base/java.lang.Thread.run(Thread.java:831) Caused by: org.postgresql.util.PSQLException: ERROR: column "statistics_resolved_identifier.id" must appear in the GROUP BY clause or be used in an aggregate function   Position: 30 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2675) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2365) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:355) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:490) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:408) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:166) at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:118) at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java) at org.jetbrains.exposed.sql.statements.jdbc.JdbcPreparedStatementImpl.executeQuery(JdbcPreparedStatementImpl.kt:24) at org.jetbrains.exposed.sql.Query.executeInternal(Query.kt:102) at org.jetbrains.exposed.sql.Query.executeInternal(Query.kt:18) at org.jetbrains.exposed.sql.statements.Statement.executeIn$exposed_core(Statement.kt:62) ... 57 more

17:48:33.446 DEBUG | HikariPool-1 - Reset (autoCommit) on connection org.postgresql.jdbc.PgConnection@56fc9205

17:48:33.446 WARN | Transaction attempt #2 failed: org.postgresql.util.PSQLException: ERROR: column "statistics_resolved_identifier.id" must appear in the GROUP BY clause or be used in an aggregate function   Position: 30. Statement(s): SELECT statistics_resolved_identifier_id, statistics_resolved_identifier_identifier_id, statistics_resolved_identifier_date, statistics_resolved_identifier_count FROM (SELECT statistics_resolved_identifier.id, statistics_resolved_identifier.identifier_id, statistics_resolved_identifier."date", statistics_resolved_identifier."count" FROM statistics_resolved_identifier GROUP BY statistics_resolved_identifier.identifier_id) subquery: org.jetbrains.exposed.exceptions.ExposedSQLException: org.postgresql.util.PSQLException: ERROR: column "statistics_resolved_identifier.id" must appear in the GROUP BY clause or be used in an aggregate function   Position: 30 at org.jetbrains.exposed.sql.statements.Statement.executeIn$exposed_core(Statement.kt:64) at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:144) at org.jetbrains.exposed.sql.Query.count(Query.kt:199) at org.jetbrains.exposed.sql.Query.count(Query.kt:192) at com.reposilite.statistics.infrastructure.SqlStatisticsRepository$countUniqueResolvedRequests$1.invoke(SqlStatisticsRepository.kt:133) at com.reposilite.statistics.infrastructure.SqlStatisticsRepository$countUniqueResolvedRequests$1.invoke(SqlStatisticsRepository.kt:130) at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.inTopLevelTransaction$run(ThreadLocalTransactionManager.kt:189) at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.access$inTopLevelTransaction$run(ThreadLocalTransactionManager.kt:1) at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$inTopLevelTransaction$1.invoke(ThreadLocalTransactionManager.kt:215) at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.keepAndRestoreTransactionRefAfterRun(ThreadLocalTransactionManager.kt:223) at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.inTopLevelTransaction(ThreadLocalTransactionManager.kt:214) at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$transaction$1.invoke(ThreadLocalTransactionManager.kt:165) at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.keepAndRestoreTransactionRefAfterRun(ThreadLocalTransactionManager.kt:223) at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction(ThreadLocalTransactionManager.kt:135) at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction(ThreadLocalTransactionManager.kt:132) at com.reposilite.statistics.infrastructure.SqlStatisticsRepository.countUniqueResolvedRequests(SqlStatisticsRepository.kt:130) at com.reposilite.statistics.StatisticsFacade.countUniqueRecords(StatisticsFacade.kt:65) at com.reposilite.statistics.StatsCommand.execute(StatsCommand.kt:41) at com.reposilite.console.CommandExecutor.executeCommand(CommandExecutor.kt:70) at com.reposilite.console.CommandExecutor.execute(CommandExecutor.kt:46) at com.reposilite.console.CommandExecutor.execute(CommandExecutor.kt:43) at com.reposilite.console.ConsoleFacade.executeCommand(ConsoleFacade.kt:48) at com.reposilite.console.infrastructure.CliEndpoint.initializeAuthenticatedContext$lambda-10(ConsoleWebSocketHandler.kt:96) at io.javalin.websocket.WsConnection$onMessage$1.invoke(WsConnection.kt:38) at io.javalin.websocket.WsConnection$onMessage$1.invoke(WsConnection.kt:38) at io.javalin.websocket.WsConnection.tryBeforeAndEndpointHandlers(WsConnection.kt:71) at io.javalin.websocket.WsConnection.onMessage(WsConnection.kt:38) at jdk.internal.reflect.GeneratedMethodAccessor14.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:567) at org.eclipse.jetty.websocket.common.events.annotated.CallableMethod.call(CallableMethod.java:70) at org.eclipse.jetty.websocket.common.events.annotated.OptionalSessionCallableMethod.call(OptionalSessionCallableMethod.java:68) at org.eclipse.jetty.websocket.common.events.JettyAnnotatedEventDriver.onTextMessage(JettyAnnotatedEventDriver.java:301) at org.eclipse.jetty.websocket.common.message.SimpleTextMessage.messageComplete(SimpleTextMessage.java:69) at org.eclipse.jetty.websocket.common.events.AbstractEventDriver.appendMessage(AbstractEventDriver.java:67) at org.eclipse.jetty.websocket.common.events.JettyAnnotatedEventDriver.onTextFrame(JettyAnnotatedEventDriver.java:287) at org.eclipse.jetty.websocket.common.events.AbstractEventDriver.incomingFrame(AbstractEventDriver.java:152) at org.eclipse.jetty.websocket.common.WebSocketSession.incomingFrame(WebSocketSession.java:326) at org.eclipse.jetty.websocket.common.extensions.AbstractExtension.nextIncomingFrame(AbstractExtension.java:148) at org.eclipse.jetty.websocket.common.extensions.compress.PerMessageDeflateExtension.nextIncomingFrame(PerMessageDeflateExtension.java:111) at org.eclipse.jetty.websocket.common.extensions.compress.CompressExtension.forwardIncoming(CompressExtension.java:169) at org.eclipse.jetty.websocket.common.extensions.compress.PerMessageDeflateExtension.incomingFrame(PerMessageDeflateExtension.java:90) at org.eclipse.jetty.websocket.common.extensions.ExtensionStack.incomingFrame(ExtensionStack.java:202) at org.eclipse.jetty.websocket.common.Parser.notifyFrame(Parser.java:225) at org.eclipse.jetty.websocket.common.Parser.parseSingleFrame(Parser.java:259) at org.eclipse.jetty.websocket.common.io.AbstractWebSocketConnection.onFillable(AbstractWebSocketConnection.java:459) at org.eclipse.jetty.websocket.common.io.AbstractWebSocketConnection.onFillable(AbstractWebSocketConnection.java:440) at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131) at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:409) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883) at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034) at java.base/java.lang.Thread.run(Thread.java:831) Caused by: org.postgresql.util.PSQLException: ERROR: column "statistics_resolved_identifier.id" must appear in the GROUP BY clause or be used in an aggregate function   Position: 30 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2675) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2365) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:355) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:490) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:408) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:166) at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:118) at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java) at org.jetbrains.exposed.sql.statements.jdbc.JdbcPreparedStatementImpl.executeQuery(JdbcPreparedStatementImpl.kt:24) at org.jetbrains.exposed.sql.Query.executeInternal(Query.kt:102) at org.jetbrains.exposed.sql.Query.executeInternal(Query.kt:18) at org.jetbrains.exposed.sql.statements.Statement.executeIn$exposed_core(Statement.kt:62) ... 57 more

17:48:33.447 DEBUG | HikariPool-1 - Reset (autoCommit) on connection org.postgresql.jdbc.PgConnection@56fc9205

17:48:33.448 WARN | Uncaught exception in WebSocket handler: org.jetbrains.exposed.exceptions.ExposedSQLException: org.postgresql.util.PSQLException: ERROR: column "statistics_resolved_identifier.id" must appear in the GROUP BY clause or be used in an aggregate function   Position: 30 at org.jetbrains.exposed.sql.statements.Statement.executeIn$exposed_core(Statement.kt:64) at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:144) at org.jetbrains.exposed.sql.Query.count(Query.kt:199) at org.jetbrains.exposed.sql.Query.count(Query.kt:192) at com.reposilite.statistics.infrastructure.SqlStatisticsRepository$countUniqueResolvedRequests$1.invoke(SqlStatisticsRepository.kt:133) at com.reposilite.statistics.infrastructure.SqlStatisticsRepository$countUniqueResolvedRequests$1.invoke(SqlStatisticsRepository.kt:130) at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.inTopLevelTransaction$run(ThreadLocalTransactionManager.kt:189) at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.access$inTopLevelTransaction$run(ThreadLocalTransactionManager.kt:1) at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$inTopLevelTransaction$1.invoke(ThreadLocalTransactionManager.kt:215) at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.keepAndRestoreTransactionRefAfterRun(ThreadLocalTransactionManager.kt:223) at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.inTopLevelTransaction(ThreadLocalTransactionManager.kt:214) at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$transaction$1.invoke(ThreadLocalTransactionManager.kt:165) at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.keepAndRestoreTransactionRefAfterRun(ThreadLocalTransactionManager.kt:223) at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction(ThreadLocalTransactionManager.kt:135) at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction(ThreadLocalTransactionManager.kt:132) at com.reposilite.statistics.infrastructure.SqlStatisticsRepository.countUniqueResolvedRequests(SqlStatisticsRepository.kt:130) at com.reposilite.statistics.StatisticsFacade.countUniqueRecords(StatisticsFacade.kt:65) at com.reposilite.statistics.StatsCommand.execute(StatsCommand.kt:41) at com.reposilite.console.CommandExecutor.executeCommand(CommandExecutor.kt:70) at com.reposilite.console.CommandExecutor.execute(CommandExecutor.kt:46) at com.reposilite.console.CommandExecutor.execute(CommandExecutor.kt:43) at com.reposilite.console.ConsoleFacade.executeCommand(ConsoleFacade.kt:48) at com.reposilite.console.infrastructure.CliEndpoint.initializeAuthenticatedContext$lambda-10(ConsoleWebSocketHandler.kt:96) at io.javalin.websocket.WsConnection$onMessage$1.invoke(WsConnection.kt:38) at io.javalin.websocket.WsConnection$onMessage$1.invoke(WsConnection.kt:38) at io.javalin.websocket.WsConnection.tryBeforeAndEndpointHandlers(WsConnection.kt:71) at io.javalin.websocket.WsConnection.onMessage(WsConnection.kt:38) at jdk.internal.reflect.GeneratedMethodAccessor14.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:567) at org.eclipse.jetty.websocket.common.events.annotated.CallableMethod.call(CallableMethod.java:70) at org.eclipse.jetty.websocket.common.events.annotated.OptionalSessionCallableMethod.call(OptionalSessionCallableMethod.java:68) at org.eclipse.jetty.websocket.common.events.JettyAnnotatedEventDriver.onTextMessage(JettyAnnotatedEventDriver.java:301) at org.eclipse.jetty.websocket.common.message.SimpleTextMessage.messageComplete(SimpleTextMessage.java:69) at org.eclipse.jetty.websocket.common.events.AbstractEventDriver.appendMessage(AbstractEventDriver.java:67) at org.eclipse.jetty.websocket.common.events.JettyAnnotatedEventDriver.onTextFrame(JettyAnnotatedEventDriver.java:287) at org.eclipse.jetty.websocket.common.events.AbstractEventDriver.incomingFrame(AbstractEventDriver.java:152) at org.eclipse.jetty.websocket.common.WebSocketSession.incomingFrame(WebSocketSession.java:326) at org.eclipse.jetty.websocket.common.extensions.AbstractExtension.nextIncomingFrame(AbstractExtension.java:148) at org.eclipse.jetty.websocket.common.extensions.compress.PerMessageDeflateExtension.nextIncomingFrame(PerMessageDeflateExtension.java:111) at org.eclipse.jetty.websocket.common.extensions.compress.CompressExtension.forwardIncoming(CompressExtension.java:169) at org.eclipse.jetty.websocket.common.extensions.compress.PerMessageDeflateExtension.incomingFrame(PerMessageDeflateExtension.java:90) at org.eclipse.jetty.websocket.common.extensions.ExtensionStack.incomingFrame(ExtensionStack.java:202) at org.eclipse.jetty.websocket.common.Parser.notifyFrame(Parser.java:225) at org.eclipse.jetty.websocket.common.Parser.parseSingleFrame(Parser.java:259) at org.eclipse.jetty.websocket.common.io.AbstractWebSocketConnection.onFillable(AbstractWebSocketConnection.java:459) at org.eclipse.jetty.websocket.common.io.AbstractWebSocketConnection.onFillable(AbstractWebSocketConnection.java:440) at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131) at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:409) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883) at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034) at java.base/java.lang.Thread.run(Thread.java:831) Caused by: org.postgresql.util.PSQLException: ERROR: column "statistics_resolved_identifier.id" must appear in the GROUP BY clause or be used in an aggregate function   Position: 30 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2675) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2365) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:355) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:490) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:408) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:166) at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:118) at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java) at org.jetbrains.exposed.sql.statements.jdbc.JdbcPreparedStatementImpl.executeQuery(JdbcPreparedStatementImpl.kt:24) at org.jetbrains.exposed.sql.Query.executeInternal(Query.kt:102) at org.jetbrains.exposed.sql.Query.executeInternal(Query.kt:18) at org.jetbrains.exposed.sql.statements.Statement.executeIn$exposed_core(Statement.kt:62) ... 57 more

17:48:33.449 INFO | CLI | florianfriedrich@/xxx.xxx.xxx.xxx:45828 closed connection

Thanks for reporting this, PostgreSQL integration is experimental (not covered by tests) and is based on top of the Exposed framework that assumes that those queries are compatible with our main target (SQLite & MySQL/MariaDB). I'll try to take a look on this to see what we can do about it.

Fortunately, it was caused by a small difference in GROUP BY behavior, fix should be available in alpha.22 :)

Thank you!

authors: dzikoysk ffried

repo: dzikoysk/reposilite


text:
Tng 862 prefix tailwind classes

Ready to review.

Well done!

Well done!

source: gharchive/pull-request

authors: dbarczewski vlapl

repo: e-Spirit/fsxa-ui

license_type: permissive

license_source: github-api


text:
Wantes to access dashboard via ip from remote host within same network

Hello, I deployed EMBA first and realized that I need a dashboard also so I deployed embark and this is in the esx server running a VM with Ubuntu Server 22.04.
I added
10.x.x.x embark.local
embark.local 10.x.x.x
in /etc/hosts
edited /var/www/httpd80/httpd.conf and added ip under redirect permanent but still I couldn’t access the dashboard using http://10.x.x.x:80 within being in the same network.
Please advise.

Hi,
did you try using http://embark.local ?

Hi,
did you try using http://embark.local ?

http://embark.local works fine locally. I mean I can access the dashboard from with in the VM. But I’m trying to access the dashboard from another machine. The machine from which I’m trying to access Embark VM both are on the same network. If I try to access embark host from other machine using http://10.x.x.x:80 I get you don’t have permission to access the resource message, even though I have registered a account to access embark dashboard.

The url has to stay the same regardless of the IP, since the Apache server only accepts requests with the same name. (name-virtual host)
That's why the /etc/hosts entry is needed.

Run server on VM/Server
Do routing if necessary
Add DNS resolve for embark.local to the correct host/ip:

if dns server: add entry
no dns -> edit hosts file (c:\windows\system32\drivers\etc\hosts.file on windows) on every client

Alternatively you could try adding an alias:
--server-alias <HOSTNAME/IP> at run-server.sh line 205
but I never tried that

Was also looking for this. Just tried to modify the run-server.sh and added the line --server-alias  and it works. Would be great to have this as an option (e.g. command line or config file) and/or quickly describe this in the README. Makes it possible to run EMBARK on a headless server.

Again, this works if the dashboard is accessed from the same host where the instance is deployed. Did you trying accessing the dashboard using the ip:port from a different host within the same network.?

@senthilkumarmoorthy Yes, just tried it. I added the line to run-server.sh at line 205 (--server-alias 192.168.0.55). The server runs in a VM with the IP 192.168.0.55. I can access EMBARK from a Browser on another system with http://192.168.0.55
Did not change anything else in EMBARK or host.

I will do a fresh installation then. Thank you so much everyone so far.

Great. It worked. I deployed it in a new VM and works flawlessly. Thank you @BenediktMKuehne & @jblu42

Hello @BenediktMKuehne looks like there is a change in the run-server.sh file in the recent release. I just wanted to ask adding the line as mentioned under line 205 does not work, so what is that in need to do now.? Please advise.

source: gharchive/issue

repo: e-m-b-a/embark

license: MIT


text:
New Feature Planning: add aggregation based on JsonPath

Would be nice to add JSON Path aggregation, besides the regular expression based.

we can have generic aggregation with parallec

repo: eBay/restcommander

license_source: bigquery


text:
RTUutils.cpp patches

A project using this library requires some patching to make modbus work correctly.
See https://github.com/SmartEVSE/SmartEVSE-3/issues/2
I'm not sure why this patch is needed and I'm not familiar with modbus.
However, is this patch of such a nature that it could become a permanent fix in this library?
If not, maybe this worth a toggle?

This has been discussed before and is no bug. The symptom that may be cured with the changes is caused by improper biasing of the RS485 bus.

repo: eModbus/eModbus