CmsWing无法编辑?【解决中】

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:\work202105\CmsWing\node_modules\mysql\lib\protocol\sequences\Sequence.js:47:14)
    at Query.ErrorPacket (E:\work202105\CmsWing\node_modules\mysql\lib\protocol\sequences\Query.js:79:18)
    at Protocol._parsePacket (E:\work202105\CmsWing\node_modules\mysql\lib\protocol\Protocol.js:291:23)
    at Parser._parsePacket (E:\work202105\CmsWing\node_modules\mysql\lib\protocol\Parser.js:433:10)
    at Parser.write (E:\work202105\CmsWing\node_modules\mysql\lib\protocol\Parser.js:43:10)
    at Protocol.write (E:\work202105\CmsWing\node_modules\mysql\lib\protocol\Protocol.js:38:16)
    at Socket.<anonymous> (E:\work202105\CmsWing\node_modules\mysql\lib\Connection.js:88:28)
    at Socket.<anonymous> (E:\work202105\CmsWing\node_modules\mysql\lib\Connection.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:\work202105\CmsWing\node_modules\mysql\lib\protocol\Protocol.js:144:48)
    at PoolConnection.query (E:\work202105\CmsWing\node_modules\mysql\lib\Connection.js:198:25)
    at E:\work202105\CmsWing\node_modules\think-helper\index.js:83:10
    at new Promise (<anonymous>)
    at E:\work202105\CmsWing\node_modules\think-helper\index.js:82:12
    at ThinkMysql.[think-mysql-query] (E:\work202105\CmsWing\node_modules\think-mysql\index.js:169:12)
    at E:\work202105\CmsWing\node_modules\think-mysql\index.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无法编辑?【解决中】

上一篇:devops之 gitlab-ci + mesos + docker + marathon 持续发布③marathon常用api的使用


下一篇:.Net(C#)对象判等