Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-23284

SQL text in server logs on errors

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 3.0
    • None
    • sql
    • Docs Required, Release Notes Required

    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.

      Attachments

        Activity

          People

            Unassigned Unassigned
            Berkov Alexander Belyak
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: