forum.bitel.ru http://forum.bitel.ru/ |
|
[8.0] Statement violates GTID consistency http://forum.bitel.ru/viewtopic.php?f=22&t=13423 |
Страница 1 из 1 |
Автор: | Вторник [ 15 авг 2019, 07:55 ] |
Заголовок сообщения: | [8.0] Statement violates GTID consistency |
Планируется ли поддержка GTID в версии 8? На стенде столкнулся с проблемами уже в двух местах: В ядре 8.0_1045: Код: server 08-14/17:18:39 ERROR [http-nio-0.0.0.0-8080-exec-4] CommonExecutor - Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functi java.sql.SQLException: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-stat at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478) at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1274) at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:780) at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2073) at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2009) at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5094) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1994) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at bitel.billing.server.contract.bean.ContractUtils.addContractParameters(ContractUtils.java:813) at bitel.billing.server.contract.bean.ContractUtils.addContractXML(ContractUtils.java:342) at bitel.billing.server.contract.bean.ContractUtils.addContractXML(ContractUtils.java:179) При установке плагина documents 8.0_145: Код: (1786) Statement violates GTID consistency: CREATE TABLE ... SELECT.
(1786) Statement violates GTID consistency: CREATE TABLE ... SELECT. (1786) Statement violates GTID consistency: CREATE TABLE ... SELECT. (1786) Statement violates GTID consistency: CREATE TABLE ... SELECT. (1786) Statement violates GTID consistency: CREATE TABLE ... SELECT. |
Автор: | Cromeshnic [ 15 авг 2019, 08:15 ] |
Заголовок сообщения: | Re: [8.0] Statement violates GTID consistency |
Плюсую тему https://forum.bitel.ru/viewtopic.php?f=19&t=12694 |
Автор: | skn [ 15 авг 2019, 15:01 ] |
Заголовок сообщения: | Re: [8.0] Statement violates GTID consistency |
пока таких планов нет |
Страница 1 из 1 | Часовой пояс: UTC + 5 часов [ Летнее время ] |
Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |