حاولت في الايام السابقة رفع التطبيق بشتا الطرق
وعندما احاول رفع الخادم على RENDER
هذا الخطاء يظهر لي :
Nov 1 06:40:54 AM Node.js v18.18.2
Nov 1 06:41:24 AM ==> Requesting node version 18.x
Nov 1 06:41:26 AM ==> Using Node version 18.18.2 via /opt/render/project/src/package.json
Nov 1 06:41:26 AM ==> Docs on specifying a Node version: https://render.com/docs/node-version
Nov 1 06:41:26 AM ==> Running 'node app.js'
Nov 1 06:41:29 AM ConnectionRefusedError [SequelizeConnectionRefusedError]: connect ECONNREFUSED ::1:5432
Nov 1 06:41:29 AM at Client._connectionCallback (/opt/render/project/src/node_modules/sequelize/lib/dialects/postgres/connection-manager.js:131:24)
Nov 1 06:41:29 AM at Client._handleErrorWhileConnecting (/opt/render/project/src/node_modules/pg/lib/client.js:327:19)
Nov 1 06:41:29 AM at Client._handleErrorEvent (/opt/render/project/src/node_modules/pg/lib/client.js:337:19)
Nov 1 06:41:29 AM at Connection.emit (node:events:517:28)
Nov 1 06:41:29 AM at Socket.reportStreamError (/opt/render/project/src/node_modules/pg/lib/connection.js:58:12)
Nov 1 06:41:29 AM at Socket.emit (node:events:517:28)
Nov 1 06:41:29 AM at emitErrorNT (node:internal/streams/destroy:151:8)
Nov 1 06:41:29 AM at emitErrorCloseNT (node:internal/streams/destroy:116:3)
Nov 1 06:41:29 AM at process.processTicksAndRejections (node:internal/process/task_queues:82:21) {
Nov 1 06:41:29 AM parent: Error: connect ECONNREFUSED ::1:5432
Nov 1 06:41:29 AM at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1555:16) {
Nov 1 06:41:29 AM errno: -111,
Nov 1 06:41:29 AM code: 'ECONNREFUSED',
Nov 1 06:41:29 AM syscall: 'connect',
Nov 1 06:41:29 AM address: '::1',
Nov 1 06:41:29 AM port: 5432
Nov 1 06:41:29 AM },
Nov 1 06:41:29 AM original: Error: connect ECONNREFUSED ::1:5432
Nov 1 06:41:29 AM at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1555:16) {
Nov 1 06:41:29 AM errno: -111,
Nov 1 06:41:29 AM code: 'ECONNREFUSED',
Nov 1 06:41:29 AM syscall: 'connect',
Nov 1 06:41:29 AM address: '::1',
Nov 1 06:41:29 AM port: 5432
Nov 1 06:41:29 AM }
Nov 1 06:41:29 AM }
Nov 1 06:41:29 AM node:internal/process/promises:288
Nov 1 06:41:29 AM triggerUncaughtException(err, true /* fromPromise */);
Nov 1 06:41:29 AM ^
Nov 1 06:41:29 AM
Nov 1 06:41:29 AM ConnectionRefusedError [SequelizeConnectionRefusedError]: connect ECONNREFUSED ::1:5432
Nov 1 06:41:29 AM at Client._connectionCallback (/opt/render/project/src/node_modules/sequelize/lib/dialects/postgres/connection-manager.js:131:24)
Nov 1 06:41:29 AM at Client._handleErrorWhileConnecting (/opt/render/project/src/node_modules/pg/lib/client.js:327:19)
Nov 1 06:41:29 AM at Client._handleErrorEvent (/opt/render/project/src/node_modules/pg/lib/client.js:337:19)
Nov 1 06:41:29 AM at Connection.emit (node:events:517:28)
Nov 1 06:41:29 AM at Socket.reportStreamError (/opt/render/project/src/node_modules/pg/lib/connection.js:58:12)
Nov 1 06:41:29 AM at Socket.emit (node:events:517:28)
Nov 1 06:41:29 AM at emitErrorNT (node:internal/streams/destroy:151:8)
Nov 1 06:41:29 AM at emitErrorCloseNT (node:internal/streams/destroy:116:3)
Nov 1 06:41:29 AM at process.processTicksAndRejections (node:internal/process/task_queues:82:21) {
Nov 1 06:41:29 AM parent: Error: connect ECONNREFUSED ::1:5432
Nov 1 06:41:29 AM at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1555:16) {
Nov 1 06:41:29 AM errno: -111,
Nov 1 06:41:29 AM code: 'ECONNREFUSED',
Nov 1 06:41:29 AM syscall: 'connect',
Nov 1 06:41:29 AM address: '::1',
Nov 1 06:41:29 AM port: 5432
Nov 1 06:41:29 AM },
Nov 1 06:41:29 AM original: Error: connect ECONNREFUSED ::1:5432
Nov 1 06:41:29 AM at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1555:16) {
Nov 1 06:41:29 AM errno: -111,
Nov 1 06:41:29 AM code: 'ECONNREFUSED',
Nov 1 06:41:29 AM syscall: 'connect',
Nov 1 06:41:29 AM address: '::1',
Nov 1 06:41:29 AM port: 5432
Nov 1 06:41:29 AM }
Nov 1 06:41:29 AM }
Nov 1 06:41:29 AM
Nov 1 06:41:29 AM Node.js v18.18.2
Nov 1 06:42:22 AM ==> Requesting node version 18.x
Nov 1 06:42:24 AM ==> Using Node version 18.18.2 via /opt/render/project/src/package.json
Nov 1 06:42:24 AM ==> Docs on specifying a Node version: https://render.com/docs/node-version
Nov 1 06:42:24 AM ==> Running 'node app.js'
Nov 1 06:42:27 AM ConnectionRefusedError [SequelizeConnectionRefusedError]: connect ECONNREFUSED ::1:5432
Nov 1 06:42:27 AM at Client._connectionCallback (/opt/render/project/src/node_modules/sequelize/lib/dialects/postgres/connection-manager.js:131:24)
Nov 1 06:42:27 AM at Client._handleErrorWhileConnecting (/opt/render/project/src/node_modules/pg/lib/client.js:327:19)
Nov 1 06:42:27 AM at Client._handleErrorEvent (/opt/render/project/src/node_modules/pg/lib/client.js:337:19)
Nov 1 06:42:27 AM at Connection.emit (node:events:517:28)
Nov 1 06:42:27 AM at Socket.reportStreamError (/opt/render/project/src/node_modules/pg/lib/connection.js:58:12)
Nov 1 06:42:27 AM at Socket.emit (node:events:517:28)
Nov 1 06:42:27 AM at emitErrorNT (node:internal/streams/destroy:151:8)
Nov 1 06:42:27 AM at emitErrorCloseNT (node:internal/streams/destroy:116:3)
Nov 1 06:42:27 AM at process.processTicksAndRejections (node:internal/process/task_queues:82:21) {
Nov 1 06:42:27 AM parent: Error: connect ECONNREFUSED ::1:5432
Nov 1 06:42:27 AM at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1555:16) {
Nov 1 06:42:27 AM errno: -111,
Nov 1 06:42:27 AM code: 'ECONNREFUSED',
Nov 1 06:42:27 AM syscall: 'connect',
Nov 1 06:42:27 AM address: '::1',
Nov 1 06:42:27 AM port: 5432
Nov 1 06:42:27 AM },
Nov 1 06:42:27 AM original: Error: connect ECONNREFUSED ::1:5432
Nov 1 06:42:27 AM at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1555:16) {
Nov 1 06:42:27 AM errno: -111,
Nov 1 06:42:27 AM code: 'ECONNREFUSED',
Nov 1 06:42:27 AM syscall: 'connect',
Nov 1 06:42:27 AM address: '::1',
Nov 1 06:42:27 AM port: 5432
Nov 1 06:42:27 AM }
Nov 1 06:42:27 AM }
Nov 1 06:42:27 AM node:internal/process/promises:288
Nov 1 06:42:27 AM triggerUncaughtException(err, true /* fromPromise */);
Nov 1 06:42:27 AM ^
Nov 1 06:42:27 AM
Nov 1 06:42:27 AM ConnectionRefusedError [SequelizeConnectionRefusedError]: connect ECONNREFUSED ::1:5432
Nov 1 06:42:27 AM at Client._connectionCallback (/opt/render/project/src/node_modules/sequelize/lib/dialects/postgres/connection-manager.js:131:24)
Nov 1 06:42:27 AM at Client._handleErrorWhileConnecting (/opt/render/project/src/node_modules/pg/lib/client.js:327:19)
Nov 1 06:42:27 AM at Client._handleErrorEvent (/opt/render/project/src/node_modules/pg/lib/client.js:337:19)
Nov 1 06:42:27 AM at Connection.emit (node:events:517:28)
Nov 1 06:42:27 AM at Socket.reportStreamError (/opt/render/project/src/node_modules/pg/lib/connection.js:58:12)
Nov 1 06:42:27 AM at Socket.emit (node:events:517:28)
Nov 1 06:42:27 AM at emitErrorNT (node:internal/streams/destroy:151:8)
Nov 1 06:42:27 AM at emitErrorCloseNT (node:internal/streams/destroy:116:3)
Nov 1 06:42:27 AM at process.processTicksAndRejections (node:internal/process/task_queues:82:21) {
Nov 1 06:42:27 AM parent: Error: connect ECONNREFUSED ::1:5432
Nov 1 06:42:27 AM at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1555:16) {
Nov 1 06:42:27 AM errno: -111,
Nov 1 06:42:27 AM code: 'ECONNREFUSED',
Nov 1 06:42:27 AM syscall: 'connect',
Nov 1 06:42:27 AM address: '::1',
Nov 1 06:42:27 AM port: 5432
Nov 1 06:42:27 AM },
Nov 1 06:42:27 AM original: Error: connect ECONNREFUSED ::1:5432
Nov 1 06:42:27 AM at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1555:16) {
Nov 1 06:42:27 AM errno: -111,
Nov 1 06:42:27 AM code: 'ECONNREFUSED',
Nov 1 06:42:27 AM syscall: 'connect',
Nov 1 06:42:27 AM address: '::1',
Nov 1 06:42:27 AM port: 5432
Nov 1 06:42:27 AM }
Nov 1 06:42:27 AM }
مع انه يشتغل لدي في الجهاز بلا مشاكل
ولاحظت ان اغلب المطورين يستخدمون {pool} للاتصال بقواعد البيانات بدلا من Sequelize ام انني فهمت بشكل خاطئ؟
server-main.rar