Uploaded image for project: 'MariaDB Connector/Python'
  1. MariaDB Connector/Python
  2. CONPY-159

raises Parameter option not supported when update from 1.0.7 to 1.1.0

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 1.1.0a1
    • 1.1.0b1
    • Generic
    • None
    • windows 10 x64
    • CPython 3.9.6

    Description

      The example code:

      config = {
          "host": "192.168.1.7", # not the localhost
          "user": "the_user",
          "password": "the_password",
          "database": "the_database"
      }
      conn_pool = mariadb.ConnectionPool(
          pool_name = 'default',
          pool_size = 10,
          pool_reset_connection = True,
          ** config
      )
      

      When I use v1.0.7, it works fine. After update to v1.1.0, it crash with:

      ......
        File "C:\Users\skyof\repos\Delog\delog\app.py", line 98, in main
          conn_pool = mariadb.ConnectionPool(
        File "C:\Users\skyof\repos\Delog\.venv\lib\site-packages\mariadb\connectionpool.py", line 94, in __init__
          connection= mariadb.Connection(**self._conn_args)
        File "C:\Users\skyof\repos\Delog\.venv\lib\site-packages\mariadb\__init__.py", line 129, in connect
          connection= connectionclass(*args, **kwargs)
        File "C:\Users\skyof\repos\Delog\.venv\lib\site-packages\mariadb\connections.py", line 67, in __init__
          self.autocommit= autocommit
        File "C:\Users\skyof\repos\Delog\.venv\lib\site-packages\mariadb\connections.py", line 539, in autocommit
          if bool(mode) == self.autocommit:
        File "C:\Users\skyof\repos\Delog\.venv\lib\site-packages\mariadb\connections.py", line 535, in autocommit
          return bool(self.server_status & STATUS.AUTOCOMMIT)
        File "C:\Users\skyof\repos\Delog\.venv\lib\site-packages\mariadb\connections.py", line 501, in server_status
          return self._mariadb_get_info(INFO.SERVER_STATUS, int)
      mariadb.ProgrammingError: Parameter option not supported
      

      Attachments

        Activity

          desxcc the name created issue -
          desxcc the name made changes -
          Field Original Value New Value
          Description The example code:


          {code:python}
          config = {
              "host": "192.168.1.7", # not the localhost
              "user": "the_user",
              "password": "the_password",
              "database": "the_database"
          }
          conn_pool = mariadb.ConnectionPool(
                  # for pool
                  pool_name = 'default',
                  pool_size = 10,
                  pool_reset_connection = True,
                  ** config
          )
          {code}

          When I use v1.0.7, it works fine. After update to v1.1.0, it crash with:

          {code:logs}
          ......
            File "C:\Users\skyof\repos\Delog\delog\app.py", line 98, in main
              conn_pool = mariadb.ConnectionPool(
            File "C:\Users\skyof\repos\Delog\.venv\lib\site-packages\mariadb\connectionpool.py", line 94, in __init__
              connection= mariadb.Connection(**self._conn_args)
            File "C:\Users\skyof\repos\Delog\.venv\lib\site-packages\mariadb\__init__.py", line 129, in connect
              connection= connectionclass(*args, **kwargs)
            File "C:\Users\skyof\repos\Delog\.venv\lib\site-packages\mariadb\connections.py", line 67, in __init__
              self.autocommit= autocommit
            File "C:\Users\skyof\repos\Delog\.venv\lib\site-packages\mariadb\connections.py", line 539, in autocommit
              if bool(mode) == self.autocommit:
            File "C:\Users\skyof\repos\Delog\.venv\lib\site-packages\mariadb\connections.py", line 535, in autocommit
              return bool(self.server_status & STATUS.AUTOCOMMIT)
            File "C:\Users\skyof\repos\Delog\.venv\lib\site-packages\mariadb\connections.py", line 501, in server_status
              return self._mariadb_get_info(INFO.SERVER_STATUS, int)
          mariadb.ProgrammingError: Parameter option not supported
          {code}
          The example code:


          {code:python}
          config = {
              "host": "192.168.1.7", # not the localhost
              "user": "the_user",
              "password": "the_password",
              "database": "the_database"
          }
          conn_pool = mariadb.ConnectionPool(
              pool_name = 'default',
              pool_size = 10,
              pool_reset_connection = True,
              ** config
          )
          {code}

          When I use v1.0.7, it works fine. After update to v1.1.0, it crash with:

          {code:logs}
          ......
            File "C:\Users\skyof\repos\Delog\delog\app.py", line 98, in main
              conn_pool = mariadb.ConnectionPool(
            File "C:\Users\skyof\repos\Delog\.venv\lib\site-packages\mariadb\connectionpool.py", line 94, in __init__
              connection= mariadb.Connection(**self._conn_args)
            File "C:\Users\skyof\repos\Delog\.venv\lib\site-packages\mariadb\__init__.py", line 129, in connect
              connection= connectionclass(*args, **kwargs)
            File "C:\Users\skyof\repos\Delog\.venv\lib\site-packages\mariadb\connections.py", line 67, in __init__
              self.autocommit= autocommit
            File "C:\Users\skyof\repos\Delog\.venv\lib\site-packages\mariadb\connections.py", line 539, in autocommit
              if bool(mode) == self.autocommit:
            File "C:\Users\skyof\repos\Delog\.venv\lib\site-packages\mariadb\connections.py", line 535, in autocommit
              return bool(self.server_status & STATUS.AUTOCOMMIT)
            File "C:\Users\skyof\repos\Delog\.venv\lib\site-packages\mariadb\connections.py", line 501, in server_status
              return self._mariadb_get_info(INFO.SERVER_STATUS, int)
          mariadb.ProgrammingError: Parameter option not supported
          {code}
          desxcc the name made changes -
          Summary app crash when update from 1.0.7 to 1.1.0 raises Parameter option not supported when update from 1.0.7 to 1.1.0
          georg Georg Richter made changes -
          Fix Version/s 1.1.1 [ 26093 ]
          georg Georg Richter made changes -
          Status Open [ 1 ] Confirmed [ 10101 ]
          georg Georg Richter made changes -
          Priority Major [ 3 ] Critical [ 2 ]
          georg Georg Richter made changes -
          issue.field.resolutiondate 2021-08-22 06:13:44.0 2021-08-22 06:13:44.959
          georg Georg Richter made changes -
          Component/s Generic [ 14515 ]
          Resolution Fixed [ 1 ]
          Status Confirmed [ 10101 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 124508 ] MariaDB v4 [ 135711 ]
          ralf.gebhardt Ralf Gebhardt made changes -
          Affects Version/s 1.1.0a1 [ 26100 ]
          Affects Version/s 1.1.0 [ 25706 ]

          People

            georg Georg Richter
            desxcc the name
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.