Error: ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same stat ement as updates to transactional tables. at Query.Sequence._packetToError (E:work202105CmsWing ode_modulesmysqllibprotocolsequencesSequence.js:47:14) at Query.ErrorPacket (E:work202105CmsWing ode_modulesmysqllibprotocolsequencesQuery.js:79:18) at Protocol._parsePacket (E:work202105CmsWing ode_modulesmysqllibprotocolProtocol.js:291:23) at Parser._parsePacket (E:work202105CmsWing ode_modulesmysqllibprotocolParser.js:433:10) at Parser.write (E:work202105CmsWing ode_modulesmysqllibprotocolParser.js:43:10) at Protocol.write (E:work202105CmsWing ode_modulesmysqllibprotocolProtocol.js:38:16) at Socket.<anonymous> (E:work202105CmsWing ode_modulesmysqllibConnection.js:88:28) at Socket.<anonymous> (E:work202105CmsWing ode_modulesmysqllibConnection.js:526:10) at Socket.emit (events.js:315:20) at addChunk (internal/streams/readable.js:309:12) at readableAddChunk (internal/streams/readable.js:284:9) at Socket.Readable.push (internal/streams/readable.js:223:10) at TCP.onStreamRead (internal/stream_base_commons.js:188:23) -------------------- at Protocol._enqueue (E:work202105CmsWing ode_modulesmysqllibprotocolProtocol.js:144:48) at PoolConnection.query (E:work202105CmsWing ode_modulesmysqllibConnection.js:198:25) at E:work202105CmsWing ode_modules hink-helperindex.js:83:10 at new Promise (<anonymous>) at E:work202105CmsWing ode_modules hink-helperindex.js:82:12 at ThinkMysql.[think-mysql-query] (E:work202105CmsWing ode_modules hink-mysqlindex.js:169:12) at E:work202105CmsWing ode_modules hink-mysqlindex.js:247:25 at processTicksAndRejections (internal/process/task_queues.js:93:5) { code: 'ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE', errno: 1785, sqlMessage: 'Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactiona l tables.', sqlState: 'HY000', index: 0, sql: "UPDATE `cmswing_search` SET `m_id`=3,`d_id`=106,`data`='迅雷看看播放器2 迅雷 看看 播放 器 2' WHERE ( `d_id` = '106' ) AND ( `m_id` = '3' )" } { request: { method: 'POST', url: '/admin/article/update', header: { host: '127.0.0.1:8360', connection: 'keep-alive', 'content-length': '1424', accept: '*/*', origin: 'http://127.0.0.1:8360', 'x-requested-with': 'XMLHttpRequest', 'user-agent': 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36', 'content-type': 'application/x-www-form-urlencoded; charset=UTF-8', 'sec-fetch-site': 'same-origin', 'sec-fetch-mode': 'cors', referer: 'http://127.0.0.1:8360/admin/article/edit/?id=106&model=1&cate_id=63', 'accept-encoding': 'gzip, deflate, br', 'accept-language': 'zh-CN,zh;q=0.9', cookie: '__guid=96992031.1139838043702490800.1606370030585.7847; thinkjs=fc4b81b4-5e53-4c1b-aa06-68998f107f4f; Hm_lvt_db1838bfd0b81ebff469f5ef62a0621a=1620610018,1620979992; Hm_lpvt_db1838bfd0b81ebff469f5ef62a0621a=1620979992; monitor_count=6' } }, response: { status: 200, message: 'OK', header: [Object: null prototype] { 'x-powered-by': 'thinkjs-3.2.13' } }, app: { subdomainOffset: 2, proxy: false, env: 'development' }, originalUrl: '/admin/article/update', req: '<original node req>', res: '<original node res>', socket: '<original node socket>' }
修改cmswing_search表索引:MyISAM 改为 InnoDB
-------------