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

Variable connect_conv_size doesn't change

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 10.2.24
    • Fix Version/s: 10.2
    • Labels:
    • Environment:

      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

            • Assignee:
              bertrandop Olivier Bertrand
              Reporter:
              hbro23 Sebastian Cardona Osorio
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: