Uploaded image for project: 'MariaDB Connector/J'
  1. MariaDB Connector/J
  2. CONJ-397

Query run by connector/j hungs in 'sending data' status

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 1.5.5
    • N/A
    • Other
    • None
    • mariadb 10.1.19
      os ubuntu 16.10
      oracle jdk 1.8

    Description

      I am experiencing issue which crops up as long running query (25s). When I copy that query to heidysql it finishes within 300ms.
      I've tried to debug it and figured out that when I set connector option 'rewriteBatchedStatements=true' the query is executed quickly. Set only useServerPrepStmts parameter to 'false' doesn't solve the issue.

      Additionally the issue could depend on some DB server statistic because it is reproduced when I run it with filtering by 11/27/16 date. Probably some periods when there are more data are more likely to reproduce the bug.

      Attachments

        1. long_batch_false.trace.txt
          24 kB
          Ostap Demkovych
        2. short_batch_true.trace.txt
          29 kB
          Ostap Demkovych

        Activity

          People

            diego dupin Diego Dupin
            odemkovych Ostap Demkovych
            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.