Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-7939

Entries in the general query log truncated at 500 characters.

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Incomplete
    • 10.0.17-galera
    • N/A
    • OTHER
    • None
    • Mac OS X 10.10.2

    Description

      This bug was reported and corrected in MySQL some time ago. Though, in MySQL the mex. length is 1000 characters, not 500 as I experienced.

      https://bugs.mysql.com/bug.php?id=21557

      Current steps to reproduce:
      1. in my.cnf, enabled general log
      2. execute SQL query - select statement - which exceeds 500 characters in length.

      Error: The text shown in the general log output is truncated.

      This makes debugging problematic SQL statements more trouble by requiring the debugging to happen upstream. Not always possible or convenient.

      Attachments

        Activity

          People

            Unassigned Unassigned
            mtjoseph Maurice Joseph
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.