Details
Description
- start and init 1 node cluster
- execute query: select count from users where login='alex' and password='123'
The problem is that server logs contain an error like:
2024-09-26 08:57:05:391 +0000 [INFO][%poc-tester-SERVER-172.24.1.2-id-0%sql-execution-pool-1][JdbcQueryEventHandlerImpl] Exception while executing query [query=select count(*) from users where login='alex' and password='123'] org.apache.ignite.sql.SqlException: IGN-SQL-4 TraceId:deb3621b-1ecf-49b1-a072-fc77ddbf579b Failed to validate query. From line 1, column 22 to line 1, column 26: Object 'USERS' not found
If the user's application retries the query on any error it'll lead to log overflow and rotation. It makes logs useless for DBA.
Also, it's not safe to log query text, it could contain sensitive information.
Let's move messages like this (low priority messages with well known user errors like a bad query) into a separate log files to let them rotate individually.