Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-2480

Write paths to opened sqlite3 databases in log when log_info is set

    Details

    • Sprint:
      MXS-SPRINT-82

      Description

      MaxScale caches a lot of information in SQLite databases. These databases can cause issues sometimes. For example, if the schema of the database is not in sync with the current MaxScale version due to a downgrade, then you will see issues. When that happens, MaxScale will not fix itself and the locations of some of these databases can be difficult to track down.

      If log_info is set, and if MaxScale opens an SQLite database, it would be extremely helpful if it could write the path of that database to the log file.

      As an example, I downgraded from MaxScale 2.3 to 2.2 and have been trying to fix this error for what seems like ages:

      2019-05-10 22:48:37   notice : [PAMAuth] Loaded 1 users for service Splitter-Service.
      2019-05-10 22:48:37   error  : [PAMAuth] Failed to insert user: table pam_users has 6 columns but 5 values were supplied
      

      And the error was still present after deleting almost every single file in /var/lib/maxscale and /var/cache/maxscale. Apparently this database was in /var/log/maxscale, which is a bit counterintuitive.

        Attachments

          Activity

            People

            • Assignee:
              marko.rajala Marko Rajala
              Reporter:
              GeoffMontee Geoff Montee
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: