[IGNITE-23284] SQL text in server logs on errors

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0
• Fix Version/s: 3.0
• Component/s: sql
• Labels: ignite-3
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Iurii Gerzhedovich
• Reporter: Alexander Belyak
• Created: 26/Sep/24 09:32
• Updated: 23/Dec/24 11:19
• Resolved: 23/Dec/24 11:19

Description

1. start and init 1 node cluster
2. 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.

Issue Links

• links to: GitHub Pull Request #4943