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

Unknown system variable 'transaction_isolation'

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Duplicate
    • 10.5.5
    • N/A
    • Variables
    • linux - debian 10

    Description

      Hello,

      I installed mariadb 10.5 on my linux debian 10 server. I tried to connect with few applictions to the database server, but it fails, because of the "Unknown system variable 'transaction_isolation" error.

      Is there a way to add an alias to the new variable 'tx_isolation'? The most applications doesnt understand the new variable.

      Regards
      lukas

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-21921 Make transaction_isolation into a system variable

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            View 5 older comments
            ludgart Lukas added a comment -

            It look like, you didnt understand the problem with it. I'm not developing any applications with that problem. The best way to solve the issue is, to add an alias too the variable 'tx_isolation'.
            With the mariadb version 10.3.22 it work, but not in the newest versions.

            Regards
            Lukas

            ludgart Lukas added a comment - It look like, you didnt understand the problem with it. I'm not developing any applications with that problem. The best way to solve the issue is, to add an alias too the variable 'tx_isolation'. With the mariadb version 10.3.22 it work, but not in the newest versions. Regards Lukas
            elenst Elena Stepanova added a comment -

            Please execute 

            select @@transaction_isolation;
            		 
            select @@version;

            via the command-line client on MariaDB 10.3.22 server and paste the unmodified output to demonstrate how it works.

            elenst Elena Stepanova added a comment - Please execute select @@transaction_isolation; select @@version; via the command-line client on MariaDB 10.3.22 server and paste the unmodified output to demonstrate how it works.
            ludgart Lukas added a comment -

            I dont have the old mariadb server anymore.

            ludgart Lukas added a comment - I dont have the old mariadb server anymore.
            elenst Elena Stepanova added a comment -

            You can download any version of your choosing from here: https://downloads.mariadb.org/mariadb/+releases/

            elenst Elena Stepanova added a comment - You can download any version of your choosing from here: https://downloads.mariadb.org/mariadb/+releases/
            ludgart Lukas added a comment - - edited

            Oke, I checked it and I found out, the variable also doesnt exists on 10.3.22. Very strange, but why does it work on this version and not on the newest versions?

            Is there any special setting for it?

            Regards
            Lukas

            ludgart Lukas added a comment - - edited Oke, I checked it and I found out, the variable also doesnt exists on 10.3.22. Very strange, but why does it work on this version and not on the newest versions? Is there any special setting for it? Regards Lukas

            People

              Unassigned Unassigned
              ludgart Lukas
              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.