mariaDB 10.1 change innodb transactional

[Dutch2007]

Ik wil graag samen met mariaDB een owncloud installatie starten..

Het volgende heb ik al geprobeerd uit te voeren...

code:

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 6
Server version: 10.1.18-MariaDB-1~xenial mariadb.org binary distribution

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> SELECT @@GLOBAL.tx_isolation, @@tx_isolation;
+-----------------------+-----------------+
| @@GLOBAL.tx_isolation | @@tx_isolation  |
+-----------------------+-----------------+
| REPEATABLE-READ       | REPEATABLE-READ |
+-----------------------+-----------------+
1 row in set (0.00 sec)

MariaDB [(none)]> SET GLOBAL tx_isolation='READ COMMITTED';
ERROR 1231 (42000): Variable 'tx_isolation' can't be set to the value of 'READ COMMITTED'
MariaDB [(none)]> SET GLOBAL tx_isolation='READ-COMMITTED';
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> SELECT @@GLOBAL.tx_isolation, @@tx_isolation;
+-----------------------+-----------------+
| @@GLOBAL.tx_isolation | @@tx_isolation  |
+-----------------------+-----------------+
| READ-COMMITTED        | REPEATABLE-READ |
+-----------------------+-----------------+
1 row in set (0.00 sec)

MariaDB [(none)]> SET SESSION tx_isolation='READ-COMMITTED';
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> SELECT @@GLOBAL.tx_isolation, @@tx_isolation;
+-----------------------+----------------+
| @@GLOBAL.tx_isolation | @@tx_isolation |
+-----------------------+----------------+
| READ-COMMITTED        | READ-COMMITTED |
+-----------------------+----------------+
1 row in set (0.00 sec)

MariaDB [(none)]>

https://dev.mysql.com/doc/refman/5.7/en/set-transaction.html

Het geeft "mooi" aan dat het werkt, of goed zou moeten staan, maar blijf de error krijgen

code:

xxxxxx@xxxxxx:/etc/mysql# service mysql restart
xxxxxx@kxxxxxx:/etc/mysql# mysql -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 10.1.18-MariaDB-1~xenial mariadb.org binary distribution

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> SELECT @@GLOBAL.tx_isolation, @@tx_isolation;
+-----------------------+-----------------+
| @@GLOBAL.tx_isolation | @@tx_isolation  |
+-----------------------+-----------------+
| REPEATABLE-READ       | REPEATABLE-READ |
+-----------------------+-----------------+
1 row in set (0.00 sec)

Suggesties wat het kan zijn? (en eigenlijk belangrijker, hoe op te lossen?)

[Hmail]

Ik heb er volgens mij geen last van gehad met een standaard mysql installatie van Debian. Hoe heb je de database gemaakt?

Voor het instellen van de transaction-isolation denk ik dat je deze puntjes uit de documentatie gemist hebt:

Scope of Transaction Characteristics

You can set transaction characteristics globally, for the current session, or for the next transaction:

With the GLOBAL keyword, the statement applies globally for all subsequent sessions. Existing sessions are unaffected.

En:

To set the global default isolation level at server startup, use the --transaction-isolation=level option to mysqld on the command line or in an option file. Values of level for this option use dashes rather than spaces, so the permissible values are READ-UNCOMMITTED, READ-COMMITTED, REPEATABLE-READ, or SERIALIZABLE. For example, to set the default isolation level to REPEATABLE READ, use these lines in the [mysqld] section of an option file:

code:

[mysqld]
transaction-isolation = REPEATABLE-READ

edit: Heb je dit issue al gezien? https://github.com/owncloud/core/issues/16008

[ Voor 3% gewijzigd door Hmail op 26-10-2016 09:02 ]