node.js - PostgreSQL NodeJS 中无法识别的配置参数 "autocommit"

Question

{"message":"Err on translation create, for key blah blah blah ","name":"SequelizeDatabaseError","stack":"SequelizeDatabaseError: unrecognized configuration parameter \"autocommit\"\n at Query.module.exports.Query.formatError (/var/www/courses/courses.com.mm/dist/node_modules/sequelize/lib/dialects/postgres/query.js:361:16)\n at Query. (/var/www/courses/courses.com.mm/dist/node_modules/sequelize/lib/dialects/postgres/query.js:79:21)\n at emitOne (events.js:96:13)\n at Query.emit (events.js:188:7)\n
at Query.handleError (/var/www/courses/courses.com.mm/dist/node_modules/pg/lib/query.js:108:8)\n at Connection. (/var/www/courses/courses.com.mm/dist/node_modules/pg/lib/client.js:171:26)\n at emitOne (events.js:96:13)\n at Connection.emit (events.js:188:7)\n at Socket. (/var/www/courses/courses.com.mm/dist/node_modules/pg/lib/connection.js:109:12)\n at emitOne (events.js:96:13)\n at Socket.emit (events.js:188:7)\n
at readableAddChunk (_stream_readable.js:176:18)\n at Socket.Readable.push (_stream_readable.js:134:10)\n at TCP.onread (net.js:543:20)","parent":{"name":"error","length":102,"severity":"ERROR","code":"42704","file":"guc.c","line":"5692","routine":"set_config_option","sql":"SET autocommit = 1;"},"original":{"name":"error","length":102,"severity":"ERROR","code":"42704","file":"guc.c","line":"5692","routine":"set_config_option","sql":"SET autocommit = 1;"},"sql":"SET autocommit = 1;","isOperational":true,"level":"info","timestamp":"2016-11-09T16:56:44.885Z"}

我在通过终端检查日志文件时遇到了上述错误。我不确定这是 postgresql 错误还是其他原因。请帮助我如何解决它。这是我的 postgresql 版本:

PostgreSQL 9.5.2 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.2 20140120 (Red Hat 4.8.2-16), 64-bit (1 row)

Answer 1

自 2003 年发布的 7.4 版本以来，配置参数 autocommit 已被禁用。

直到 PostgreSQL 版本 9.4，该参数仍然存在，但没有任何效果。

从 PostgreSQL 9.5 开始(2016 年 1 月发布)，该参数已被删除，尝试设置它会导致错误消息。

尝试将您的客户端软件更新到更新的版本。