gistfile1.txt

10-24 10:05:57.902 [WARNING] studyRussianBot - 
dev.inmo.tgbotapi.bot.exceptions.CommonBotException: Something went wrong
	at dev.inmo.tgbotapi.bot.ktor.base.DefaultKtorRequestsExecutor.execute(DefaultKtorRequestsExecutor.kt:99)
	at dev.inmo.tgbotapi.bot.ktor.base.DefaultKtorRequestsExecutor$execute$1.invokeSuspend(DefaultKtorRequestsExecutor.kt)
	at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(ContinuationImpl.kt:33)
	at kotlinx.coroutines.DispatchedTask.run(DispatchedTask.kt:101)
	at kotlinx.coroutines.internal.LimitedDispatcher$Worker.run(LimitedDispatcher.kt:113)
	at kotlinx.coroutines.scheduling.TaskImpl.run(Tasks.kt:89)
	at kotlinx.coroutines.scheduling.CoroutineScheduler.runSafely(CoroutineScheduler.kt:589)
	at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.executeTask(CoroutineScheduler.kt:823)
	at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.runWorker(CoroutineScheduler.kt:720)
	at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.run(CoroutineScheduler.kt:707)
Caused by: java.sql.SQLException: Code: 349. DB::Exception: Cannot convert NULL value to non-Nullable type: while converting source column username to destination column username: while executing 'FUNCTION _CAST(username :: 1, SimpleAggregateFunction(anyLast, LowCardinality(String)) :: 7) -> _CAST(username, SimpleAggregateFunction(anyLast, LowCardinality(String))) SimpleAggregateFunction(anyLast, LowCardinality(String)) : 6': while pushing to view bot_log.user_stat_mv (4200b420-76d1-4df6-a9d0-cd4a1dd34c7d). (CANNOT_INSERT_NULL_IN_ORDINARY_COLUMN) (version 24.9.2.42 (official build))

	at com.clickhouse.jdbc.SqlExceptionUtils.handle(SqlExceptionUtils.java:85)
	at com.clickhouse.jdbc.SqlExceptionUtils.create(SqlExceptionUtils.java:31)
	at com.clickhouse.jdbc.SqlExceptionUtils.handle(SqlExceptionUtils.java:90)
	at com.clickhouse.jdbc.internal.ClickHouseStatementImpl.sendRequest(ClickHouseStatementImpl.java:375)
	at com.clickhouse.jdbc.internal.ClickHouseStatementImpl.executeInsert(ClickHouseStatementImpl.java:386)
	at com.clickhouse.jdbc.internal.InputBasedPreparedStatement.executeAny(InputBasedPreparedStatement.java:124)
	at com.clickhouse.jdbc.internal.InputBasedPreparedStatement.execute(InputBasedPreparedStatement.java:312)
	at kotliquery.Session$execute$1.invoke(Session.kt:261)
	at kotliquery.Session$execute$1.invoke(Session.kt:260)
	at kotliquery.LoanPattern.using(LoanPattern.kt:11)
	at kotliquery.Session.execute(Session.kt:260)
	at dev.inmo.tgbotapi.LoggingMiddleware.save(LoggingMiddleware.kt:34)
	at dev.inmo.tgbotapi.LoggingMiddleware.onRequestResultPresented(LoggingMiddleware.kt:95)
	at dev.inmo.tgbotapi.bot.ktor.base.DefaultKtorRequestsExecutor$execute$2$2.invokeSuspend(DefaultKtorRequestsExecutor.kt:75)
	... 8 more
Caused by: java.io.IOException: Code: 349. DB::Exception: Cannot convert NULL value to non-Nullable type: while converting source column username to destination column username: while executing 'FUNCTION _CAST(username :: 1, SimpleAggregateFunction(anyLast, LowCardinality(String)) :: 7) -> _CAST(username, SimpleAggregateFunction(anyLast, LowCardinality(String))) SimpleAggregateFunction(anyLast, LowCardinality(String)) : 6': while pushing to view bot_log.user_stat_mv (4200b420-76d1-4df6-a9d0-cd4a1dd34c7d). (CANNOT_INSERT_NULL_IN_ORDINARY_COLUMN) (version 24.9.2.42 (official build))

	at com.clickhouse.client.http.ApacheHttpConnectionImpl.checkResponse(ApacheHttpConnectionImpl.java:241)
	at com.clickhouse.client.http.ApacheHttpConnectionImpl.post(ApacheHttpConnectionImpl.java:304)
	at com.clickhouse.client.http.ClickHouseHttpClient.send(ClickHouseHttpClient.java:195)
	at com.clickhouse.client.AbstractClient.execute(AbstractClient.java:280)
	at com.clickhouse.client.ClickHouseClientBuilder$Agent.sendOnce(ClickHouseClientBuilder.java:282)
	at com.clickhouse.client.ClickHouseClientBuilder$Agent.send(ClickHouseClientBuilder.java:294)
	at com.clickhouse.client.ClickHouseClientBuilder$Agent.execute(ClickHouseClientBuilder.java:349)
	at com.clickhouse.client.ClickHouseClient.executeAndWait(ClickHouseClient.java:878)
	at com.clickhouse.client.ClickHouseRequest.executeAndWait(ClickHouseRequest.java:2154)
	at com.clickhouse.jdbc.internal.ClickHouseStatementImpl.sendRequest(ClickHouseStatementImpl.java:366)
	... 18 more