OwlCyberSecurity - MANAGER

Edit File: index-error.log

❌ FULL ERROR LOG: ConnectionError [SequelizeConnectionError]: Too many connections
    at ConnectionManager.connect (/home/oneboxpk/backend/node_modules/sequelize/lib/dialects/mysql/connection-manager.js:102:17)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async ConnectionManager._connect (/home/oneboxpk/backend/node_modules/sequelize/lib/dialects/abstract/connection-manager.js:222:24) {
  parent: Error: Too many connections
      at Packet.asError (/home/oneboxpk/backend/node_modules/mysql2/lib/packets/packet.js:740:17)
      at ClientHandshake.execute (/home/oneboxpk/backend/node_modules/mysql2/lib/commands/command.js:29:26)
      at Connection.handlePacket (/home/oneboxpk/backend/node_modules/mysql2/lib/base/connection.js:475:34)
      at PacketParser.onPacket (/home/oneboxpk/backend/node_modules/mysql2/lib/base/connection.js:93:12)
      at PacketParser.executeStart (/home/oneboxpk/backend/node_modules/mysql2/lib/packet_parser.js:75:16)
      at Socket.<anonymous> (/home/oneboxpk/backend/node_modules/mysql2/lib/base/connection.js:100:25)
      at Socket.emit (node:events:524:28)
      at addChunk (node:internal/streams/readable:561:12)
      at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
      at Readable.push (node:internal/streams/readable:392:5) {
    code: 'ER_CON_COUNT_ERROR',
    errno: 1040,
    sqlState: '08004',
    sqlMessage: 'Too many connections',
    sql: undefined
  },
  original: Error: Too many connections
      at Packet.asError (/home/oneboxpk/backend/node_modules/mysql2/lib/packets/packet.js:740:17)
      at ClientHandshake.execute (/home/oneboxpk/backend/node_modules/mysql2/lib/commands/command.js:29:26)
      at Connection.handlePacket (/home/oneboxpk/backend/node_modules/mysql2/lib/base/connection.js:475:34)
      at PacketParser.onPacket (/home/oneboxpk/backend/node_modules/mysql2/lib/base/connection.js:93:12)
      at PacketParser.executeStart (/home/oneboxpk/backend/node_modules/mysql2/lib/packet_parser.js:75:16)
      at Socket.<anonymous> (/home/oneboxpk/backend/node_modules/mysql2/lib/base/connection.js:100:25)
      at Socket.emit (node:events:524:28)
      at addChunk (node:internal/streams/readable:561:12)
      at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
      at Readable.push (node:internal/streams/readable:392:5) {
    code: 'ER_CON_COUNT_ERROR',
    errno: 1040,
    sqlState: '08004',
    sqlMessage: 'Too many connections',
    sql: undefined
  }
}
❌ Update Error: Error
    at Query.run (/home/oneboxpk/backend/node_modules/sequelize/lib/dialects/mysql/query.js:52:25)
    at /home/oneboxpk/backend/node_modules/sequelize/lib/sequelize.js:315:28
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async MySQLQueryInterface.bulkUpdate (/home/oneboxpk/backend/node_modules/sequelize/lib/dialects/abstract/query-interface.js:366:12)
    at async Leave.update (/home/oneboxpk/backend/node_modules/sequelize/lib/model.js:2010:28)
    at async updateLeave (file:///home/oneboxpk/backend/controllers/leaveController.mjs:118:21) {
  name: 'SequelizeDatabaseError',
  parent: Error: Data truncated for column 'LeaveStatus' at row 1
      at Packet.asError (/home/oneboxpk/backend/node_modules/mysql2/lib/packets/packet.js:740:17)
      at Execute.execute (/home/oneboxpk/backend/node_modules/mysql2/lib/commands/command.js:29:26)
      at Connection.handlePacket (/home/oneboxpk/backend/node_modules/mysql2/lib/base/connection.js:475:34)
      at PacketParser.onPacket (/home/oneboxpk/backend/node_modules/mysql2/lib/base/connection.js:93:12)
      at PacketParser.executeStart (/home/oneboxpk/backend/node_modules/mysql2/lib/packet_parser.js:75:16)
      at Socket.<anonymous> (/home/oneboxpk/backend/node_modules/mysql2/lib/base/connection.js:100:25)
      at Socket.emit (node:events:524:28)
      at addChunk (node:internal/streams/readable:561:12)
      at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
      at Readable.push (node:internal/streams/readable:392:5) {
    code: 'WARN_DATA_TRUNCATED',
    errno: 1265,
    sqlState: '01000',
    sqlMessage: "Data truncated for column 'LeaveStatus' at row 1",
    sql: 'UPDATE `Leaves` SET `LeaveID`=?,`LeaveDate`=?,`EmployeeName`=?,`EmpNo`=?,`EmpStatus`=?,`Department`=?,`Designation`=?,`LeaveType`=?,`LeavePurpose`=?,`NoOfDaysRequired`=?,`ImmediateOfficer`=?,`GeneralManager`=?,`LeaveStatus`=? WHERE `LeaveID` = ?',
    parameters: [
      1,
      '2025-07-02',
      'Aroosa Shahwar',
      'EMP002',
      'Daily Wage',
      'IT',
      'Android developer ',
      'Casual',
      "I'm out of town",
      '2',
      'Abc',
      'Admin',
      'Approved',
      '1'
    ]
  },
  original: Error: Data truncated for column 'LeaveStatus' at row 1
      at Packet.asError (/home/oneboxpk/backend/node_modules/mysql2/lib/packets/packet.js:740:17)
      at Execute.execute (/home/oneboxpk/backend/node_modules/mysql2/lib/commands/command.js:29:26)
      at Connection.handlePacket (/home/oneboxpk/backend/node_modules/mysql2/lib/base/connection.js:475:34)
      at PacketParser.onPacket (/home/oneboxpk/backend/node_modules/mysql2/lib/base/connection.js:93:12)
      at PacketParser.executeStart (/home/oneboxpk/backend/node_modules/mysql2/lib/packet_parser.js:75:16)
      at Socket.<anonymous> (/home/oneboxpk/backend/node_modules/mysql2/lib/base/connection.js:100:25)
      at Socket.emit (node:events:524:28)
      at addChunk (node:internal/streams/readable:561:12)
      at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
      at Readable.push (node:internal/streams/readable:392:5) {
    code: 'WARN_DATA_TRUNCATED',
    errno: 1265,
    sqlState: '01000',
    sqlMessage: "Data truncated for column 'LeaveStatus' at row 1",
    sql: 'UPDATE `Leaves` SET `LeaveID`=?,`LeaveDate`=?,`EmployeeName`=?,`EmpNo`=?,`EmpStatus`=?,`Department`=?,`Designation`=?,`LeaveType`=?,`LeavePurpose`=?,`NoOfDaysRequired`=?,`ImmediateOfficer`=?,`GeneralManager`=?,`LeaveStatus`=? WHERE `LeaveID` = ?',
    parameters: [
      1,
      '2025-07-02',
      'Aroosa Shahwar',
      'EMP002',
      'Daily Wage',
      'IT',
      'Android developer ',
      'Casual',
      "I'm out of town",
      '2',
      'Abc',
      'Admin',
      'Approved',
      '1'
    ]
  },
  sql: 'UPDATE `Leaves` SET `LeaveID`=?,`LeaveDate`=?,`EmployeeName`=?,`EmpNo`=?,`EmpStatus`=?,`Department`=?,`Designation`=?,`LeaveType`=?,`LeavePurpose`=?,`NoOfDaysRequired`=?,`ImmediateOfficer`=?,`GeneralManager`=?,`LeaveStatus`=? WHERE `LeaveID` = ?',
  parameters: [
    1,
    '2025-07-02',
    'Aroosa Shahwar',
    'EMP002',
    'Daily Wage',
    'IT',
    'Android developer ',
    'Casual',
    "I'm out of town",
    '2',
    'Abc',
    'Admin',
    'Approved',
    '1'
  ]
}
❌ Update Error: Error
    at Query.run (/home/oneboxpk/backend/node_modules/sequelize/lib/dialects/mysql/query.js:52:25)
    at /home/oneboxpk/backend/node_modules/sequelize/lib/sequelize.js:315:28
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async MySQLQueryInterface.bulkUpdate (/home/oneboxpk/backend/node_modules/sequelize/lib/dialects/abstract/query-interface.js:366:12)
    at async Leave.update (/home/oneboxpk/backend/node_modules/sequelize/lib/model.js:2010:28)
    at async updateLeave (file:///home/oneboxpk/backend/controllers/leaveController.mjs:118:21) {
  name: 'SequelizeDatabaseError',
  parent: Error: Data truncated for column 'LeaveStatus' at row 1
      at Packet.asError (/home/oneboxpk/backend/node_modules/mysql2/lib/packets/packet.js:740:17)
      at Execute.execute (/home/oneboxpk/backend/node_modules/mysql2/lib/commands/command.js:29:26)
      at Connection.handlePacket (/home/oneboxpk/backend/node_modules/mysql2/lib/base/connection.js:475:34)
      at PacketParser.onPacket (/home/oneboxpk/backend/node_modules/mysql2/lib/base/connection.js:93:12)
      at PacketParser.executeStart (/home/oneboxpk/backend/node_modules/mysql2/lib/packet_parser.js:75:16)
      at Socket.<anonymous> (/home/oneboxpk/backend/node_modules/mysql2/lib/base/connection.js:100:25)
      at Socket.emit (node:events:524:28)
      at addChunk (node:internal/streams/readable:561:12)
      at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
      at Readable.push (node:internal/streams/readable:392:5) {
    code: 'WARN_DATA_TRUNCATED',
    errno: 1265,
    sqlState: '01000',
    sqlMessage: "Data truncated for column 'LeaveStatus' at row 1",
    sql: 'UPDATE `Leaves` SET `LeaveID`=?,`LeaveDate`=?,`EmployeeName`=?,`EmpNo`=?,`EmpStatus`=?,`Department`=?,`Designation`=?,`LeaveType`=?,`LeavePurpose`=?,`NoOfDaysRequired`=?,`ImmediateOfficer`=?,`GeneralManager`=?,`LeaveStatus`=? WHERE `LeaveID` = ?',
    parameters: [
      1,
      '2025-07-02',
      'Aroosa Shahwar',
      'EMP002',
      'Daily Wage',
      'IT',
      'Android developer ',
      'Casual',
      "I'm out of town",
      '2',
      'Abc',
      'Admin',
      'Approved',
      '1'
    ]
  },
  original: Error: Data truncated for column 'LeaveStatus' at row 1
      at Packet.asError (/home/oneboxpk/backend/node_modules/mysql2/lib/packets/packet.js:740:17)
      at Execute.execute (/home/oneboxpk/backend/node_modules/mysql2/lib/commands/command.js:29:26)
      at Connection.handlePacket (/home/oneboxpk/backend/node_modules/mysql2/lib/base/connection.js:475:34)
      at PacketParser.onPacket (/home/oneboxpk/backend/node_modules/mysql2/lib/base/connection.js:93:12)
      at PacketParser.executeStart (/home/oneboxpk/backend/node_modules/mysql2/lib/packet_parser.js:75:16)
      at Socket.<anonymous> (/home/oneboxpk/backend/node_modules/mysql2/lib/base/connection.js:100:25)
      at Socket.emit (node:events:524:28)
      at addChunk (node:internal/streams/readable:561:12)
      at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
      at Readable.push (node:internal/streams/readable:392:5) {
    code: 'WARN_DATA_TRUNCATED',
    errno: 1265,
    sqlState: '01000',
    sqlMessage: "Data truncated for column 'LeaveStatus' at row 1",
    sql: 'UPDATE `Leaves` SET `LeaveID`=?,`LeaveDate`=?,`EmployeeName`=?,`EmpNo`=?,`EmpStatus`=?,`Department`=?,`Designation`=?,`LeaveType`=?,`LeavePurpose`=?,`NoOfDaysRequired`=?,`ImmediateOfficer`=?,`GeneralManager`=?,`LeaveStatus`=? WHERE `LeaveID` = ?',
    parameters: [
      1,
      '2025-07-02',
      'Aroosa Shahwar',
      'EMP002',
      'Daily Wage',
      'IT',
      'Android developer ',
      'Casual',
      "I'm out of town",
      '2',
      'Abc',
      'Admin',
      'Approved',
      '1'
    ]
  },
  sql: 'UPDATE `Leaves` SET `LeaveID`=?,`LeaveDate`=?,`EmployeeName`=?,`EmpNo`=?,`EmpStatus`=?,`Department`=?,`Designation`=?,`LeaveType`=?,`LeavePurpose`=?,`NoOfDaysRequired`=?,`ImmediateOfficer`=?,`GeneralManager`=?,`LeaveStatus`=? WHERE `LeaveID` = ?',
  parameters: [
    1,
    '2025-07-02',
    'Aroosa Shahwar',
    'EMP002',
    'Daily Wage',
    'IT',
    'Android developer ',
    'Casual',
    "I'm out of town",
    '2',
    'Abc',
    'Admin',
    'Approved',
    '1'
  ]
}
❌ Update Error: Error
    at Query.run (/home/oneboxpk/backend/node_modules/sequelize/lib/dialects/mysql/query.js:52:25)
    at /home/oneboxpk/backend/node_modules/sequelize/lib/sequelize.js:315:28
    at async MySQLQueryInterface.bulkUpdate (/home/oneboxpk/backend/node_modules/sequelize/lib/dialects/abstract/query-interface.js:366:12)
    at async Leave.update (/home/oneboxpk/backend/node_modules/sequelize/lib/model.js:2010:28)
    at async updateLeave (file:///home/oneboxpk/backend/controllers/leaveController.mjs:118:21) {
  name: 'SequelizeDatabaseError',
  parent: Error: Data truncated for column 'LeaveStatus' at row 1
      at Packet.asError (/home/oneboxpk/backend/node_modules/mysql2/lib/packets/packet.js:740:17)
      at Execute.execute (/home/oneboxpk/backend/node_modules/mysql2/lib/commands/command.js:29:26)
      at Connection.handlePacket (/home/oneboxpk/backend/node_modules/mysql2/lib/base/connection.js:475:34)
      at PacketParser.onPacket (/home/oneboxpk/backend/node_modules/mysql2/lib/base/connection.js:93:12)
      at PacketParser.executeStart (/home/oneboxpk/backend/node_modules/mysql2/lib/packet_parser.js:75:16)
      at Socket.<anonymous> (/home/oneboxpk/backend/node_modules/mysql2/lib/base/connection.js:100:25)
      at Socket.emit (node:events:524:28)
      at addChunk (node:internal/streams/readable:561:12)
      at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
      at Readable.push (node:internal/streams/readable:392:5) {
    code: 'WARN_DATA_TRUNCATED',
    errno: 1265,
    sqlState: '01000',
    sqlMessage: "Data truncated for column 'LeaveStatus' at row 1",
    sql: 'UPDATE `Leaves` SET `LeaveID`=?,`LeaveDate`=?,`EmployeeName`=?,`EmpNo`=?,`EmpStatus`=?,`Department`=?,`Designation`=?,`LeaveType`=?,`LeavePurpose`=?,`NoOfDaysRequired`=?,`ImmediateOfficer`=?,`GeneralManager`=?,`LeaveStatus`=? WHERE `LeaveID` = ?',
    parameters: [
      1,
      '2025-07-02',
      'Aroosa Shahwar',
      'EMP002',
      'Daily Wage',
      'IT',
      'Android developer ',
      'Casual',
      "I'm out of town",
      '2',
      'Abc',
      'Admin',
      'Approved',
      '1'
    ]
  },
  original: Error: Data truncated for column 'LeaveStatus' at row 1
      at Packet.asError (/home/oneboxpk/backend/node_modules/mysql2/lib/packets/packet.js:740:17)
      at Execute.execute (/home/oneboxpk/backend/node_modules/mysql2/lib/commands/command.js:29:26)
      at Connection.handlePacket (/home/oneboxpk/backend/node_modules/mysql2/lib/base/connection.js:475:34)
      at PacketParser.onPacket (/home/oneboxpk/backend/node_modules/mysql2/lib/base/connection.js:93:12)
      at PacketParser.executeStart (/home/oneboxpk/backend/node_modules/mysql2/lib/packet_parser.js:75:16)
      at Socket.<anonymous> (/home/oneboxpk/backend/node_modules/mysql2/lib/base/connection.js:100:25)
      at Socket.emit (node:events:524:28)
      at addChunk (node:internal/streams/readable:561:12)
      at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
      at Readable.push (node:internal/streams/readable:392:5) {
    code: 'WARN_DATA_TRUNCATED',
    errno: 1265,
    sqlState: '01000',
    sqlMessage: "Data truncated for column 'LeaveStatus' at row 1",
    sql: 'UPDATE `Leaves` SET `LeaveID`=?,`LeaveDate`=?,`EmployeeName`=?,`EmpNo`=?,`EmpStatus`=?,`Department`=?,`Designation`=?,`LeaveType`=?,`LeavePurpose`=?,`NoOfDaysRequired`=?,`ImmediateOfficer`=?,`GeneralManager`=?,`LeaveStatus`=? WHERE `LeaveID` = ?',
    parameters: [
      1,
      '2025-07-02',
      'Aroosa Shahwar',
      'EMP002',
      'Daily Wage',
      'IT',
      'Android developer ',
      'Casual',
      "I'm out of town",
      '2',
      'Abc',
      'Admin',
      'Approved',
      '1'
    ]
  },
  sql: 'UPDATE `Leaves` SET `LeaveID`=?,`LeaveDate`=?,`EmployeeName`=?,`EmpNo`=?,`EmpStatus`=?,`Department`=?,`Designation`=?,`LeaveType`=?,`LeavePurpose`=?,`NoOfDaysRequired`=?,`ImmediateOfficer`=?,`GeneralManager`=?,`LeaveStatus`=? WHERE `LeaveID` = ?',
  parameters: [
    1,
    '2025-07-02',
    'Aroosa Shahwar',
    'EMP002',
    'Daily Wage',
    'IT',
    'Android developer ',
    'Casual',
    "I'm out of town",
    '2',
    'Abc',
    'Admin',
    'Approved',
    '1'
  ]
}