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

Variable connect_conv_size doesn't change

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 10.2.24

    Description

      I was trying to sync information from a server with MySQL 5.6. The schema that I wanted to sync has so many text type columns, so I needed to set connect_conv_size and connect_type_conv variables, and I didn't have any problem to do that in MariaDB version 10.2.14 but I couldn't do it with version 10.2.24, connect_type_conv it could set to YES but connect_conv_size it couldn't set to another value that the default value.

      I tried to put the value with --connect-conv-size=1024 and in the configuration file. In both case I got that when I used show variables command:

      mariadb> SHOW VARIABLES LIKE 'connect%';
      +-----------------------+------------------------+
      | Variable_name         | Value                  |
      +-----------------------+------------------------+
      | connect_class_path    |                        |
      | connect_cond_push     | ON                     |
      | connect_conv_size     | 0                      |
      | connect_enable_mongo  | ON                     |
      | connect_exact_info    | OFF                    |
      | connect_indx_map      | OFF                    |
      | connect_java_wrapper  | wrappers/JdbcInterface |
      | connect_json_grp_size | 10                     |
      | connect_json_null     | <null>                 |
      | connect_jvm_path      |                        |
      | connect_timeout       | 10                     |
      | connect_type_conv     | YES                    |
      | connect_use_tempfile  | AUTO                   |
      | connect_work_size     | 67108864               |
      | connect_xtrace        |                        |
      +-----------------------+------------------------+
      15 rows in set (0.03 sec)
      

      That thing avoid that "discovery method" could get the real size of varchar column, I fixed manually column size and it worked. I think that's a bug in configuration file or I missed something. Thanks in advance.

      Attachments

        Activity

          People

            bertrandop Olivier Bertrand
            hbro23 Sebastian Cardona Osorio
            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.