Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Not a Bug
-
10.6.17
-
None
Description
Select next value from the sequence fails with below error in MariaDB Galera Cluster
|
ERROR 1235 (42000): This version of MariaDB doesn't yet support 'SEQUENCEs with streaming replication in Galera cluster'
|
|
Test case :-
|
MariaDB [test]> show global variables like 'version';
|
+---------------+---------------------+
|
| Variable_name | Value |
|
+---------------+---------------------+
|
| version | 10.6.17-MariaDB-log |
|
+---------------+---------------------+
|
1 row in set (0.001 sec)
|
|
|
MariaDB [(none)]> SHOW STATUS LIKE 'wsrep_provider_version';
|
+------------------------+-------------------+
|
| Variable_name | Value |
|
+------------------------+-------------------+
|
| wsrep_provider_version | 26.4.16(r7dce514) |
|
+------------------------+-------------------+
|
1 row in set (0.001 sec)
|
|
MariaDB [(none)]> show global variables like '%wsrep_trx%';
|
+-------------------------+----------+
|
| Variable_name | Value |
|
+-------------------------+----------+
|
| wsrep_trx_fragment_size | 10240000 |
|
| wsrep_trx_fragment_unit | bytes |
|
+-------------------------+----------+
|
2 rows in set (0.001 sec)
|
|
MariaDB [(none)]> select * from mysql.wsrep_cluster;
|
+--------------------------------------+---------+------------+------------------+--------------+
|
| cluster_uuid | view_id | view_seqno | protocol_version | capabilities |
|
+--------------------------------------+---------+------------+------------------+--------------+
|
| b47c150a-eb39-11ee-a832-528b77b9f3c4 | 41 | 172 | 4 | 184703 |
|
+--------------------------------------+---------+------------+------------------+--------------+
|
1 row in set (0.001 sec)
|
|
MariaDB [(none)]> select * from mysql.wsrep_cluster_members;
|
+--------------------------------------+--------------------------------------+-----------+-----------------------+
|
| node_uuid | cluster_uuid | node_name | node_incoming_address |
|
+--------------------------------------+--------------------------------------+-----------+-----------------------+
|
| 4227e2e0-0dae-11ef-b33f-878f0cd70cd5 | b47c150a-eb39-11ee-a832-528b77b9f3c4 | gcn-02 | 192.168.47.42:3306 |
|
| 84c84e8c-0dae-11ef-aca4-1377bfb10b11 | b47c150a-eb39-11ee-a832-528b77b9f3c4 | gcn-03 | 192.168.47.43:3306 |
|
| a664e68f-0dad-11ef-8c20-6249933a39f0 | b47c150a-eb39-11ee-a832-528b77b9f3c4 | gcn-01 | 192.168.47.41:3306 |
|
+--------------------------------------+--------------------------------------+-----------+-----------------------+
|
3 rows in set (0.001 sec)
|
|
MariaDB [(none)]> use test;
|
Database changed
|
|
|
MariaDB [test]> create sequence test_sequence start with 1 increment by 0;
|
Query OK, 0 rows affected (0.015 sec)
|
|
MariaDB [test]> select next value for test_sequence;
|
ERROR 1235 (42000): This version of MariaDB doesn't yet support 'SEQUENCEs with streaming replication in Galera cluster'
|
|
|
Attachments
Issue Links
- relates to
-
MDEV-28971 Assertion `total_length + thd->wsrep_sr().log_position() == saved_pos' failed in int wsrep_write_cache_inc(THD*, IO_CACHE*, size_t*)
- Closed