时间戳

首页 > 解决方案 > mariadb 连接问题

mysql - mariadb 连接问题

问题描述

嘿，我必须在 node 和 mariadb 中创建一个 api。时不时会出现这个错误，我不知道为什么。该应用程序已经运行了一段时间，我收到此错误

终端

/home/marcel/workspace/reactlogic/node_modules/mariadb/lib/connection.js:1337
          if (!avoidThrowError && !errorThrownByCmd) throw err;
                                                     ^

SqlError: (conn=2292122, no: 45009, SQLState: 08S01) socket has unexpectedly been closed
    at Object.module.exports.createError (/home/marcel/workspace/reactlogic/node_modules/mariadb/lib/misc/errors.js:55:10)
    at ConnectionCallback._socketErrorHandler (/home/marcel/workspace/reactlogic/node_modules/mariadb/lib/connection.js:1266:20)
    at Socket.emit (events.js:327:22)
    at endReadableNT (internal/streams/readable.js:1327:12)
    at processTicksAndRejections (internal/process/task_queues.js:80:21) {
  fatal: true,
  errno: 45009,
  sqlState: '08S01',
  code: 'ER_SOCKET_UNEXPECTED_CLOSE'

db.js 文件

const dbConfig = require("./config.js");
const mariadb = require("mariadb/callback");

const connection = mariadb.createConnection({
  host: dbConfig.HOST,
  port: dbConfig.PORT,
  user: dbConfig.USER,
  password: dbConfig.PASSWORD,
  database: dbConfig.DB,
});

module.exports = connection;

我试过了，connection.connect()但我仍然有这个错误。

标签： mysqlnode.jsmariadb

解决方案

推荐阅读