Stock Quantity incorrect bug

[Jace996]

@ameir Good day,

i found 3 Pages show different quantity for 1 item.

Inventory Item Details (Correct quantity)

Inventory valuation (Incorrect quantity)

Item List (Incorrect quantity)

The Inventory Item Details page is showing quantity correctly. Others two is incorrect.
In addition, the quantity on hand in item list bugs can reproduce following steps below

1. Go to create Sales or Purchase invoice
2. Must add two inventory item above to the invoice. (single inventory item no issue)
3. Go to edit created invoice
4. No need change anything. Just click Edit and save it.
5. Go to check item list.

I attached video for reference.

Screen.Recording.2025-01-14.at.5.25.06.AM.mov

[linear]

BIG-276 Stock Quantity incorrect bug

[tusada]

I confirmed this bug too.
Beside the bug, my instance becomes irresponsive and crashed few seconds after editing the bill or invoice

KnexTimeoutError: Knex: Timeout acquiring a connection. The pool is probably full. Are you missing a .transacting(trx) call?
bigcapital-server | at Client_MySQL.acquireConnection (/app/node_modules/.pnpm/knex@3.1.0_mysql2@1.7.0_mysql@2.18.1/node_modules/knex/lib/client.js:332:26)
...
bigcapital-server | at async PaginationQueryBuilder.execute (/app/node_modules/.pnpm/objection@3.1.4_knex@3.1.0_mysql2@1.7.0_mysql@2.18.1_/node_modules/objection/lib/queryBuilder/QueryBuilder.js:446:22)
bigcapital-server | at async GetItems.getItems (/app/packages/server/build/index.js:97243:48)
bigcapital-server | at async ItemsController.getItemsList (/app/packages/server/build/index.js:8832:55)
bigcapital-server | KnexTimeoutError: Knex: Timeout acquiring a connection. The pool is probably full. Are you missing a .transacting(trx) call?
...
bigcapital-server | at async DashboardService.getBootAbilities (/app/packages/server/build/index.js:66148:32)
bigcapital-server | at async DashboardService.getBootMeta (/app/packages/server/build/index.js:66122:31)
bigcapital-server | at async DashboardMetaController.getDashboardBoot (/app/packages/server/build/index.js:4189:30)

Then, it crashed after this error

bigcapital-server | /app/node_modules/.pnpm/knex@3.1.0_mysql2@1.7.0_mysql@2.18.1/node_modules/knex/lib/client.js:332
bigcapital-server | convertedError = new KnexTimeoutError(
bigcapital-server | ^
bigcapital-server |
bigcapital-server | KnexTimeoutError: Knex: Timeout acquiring a connection. The pool is probably full. Are you missing a .transacting(trx) call?
bigcapital-server | at Client_MySQL.acquireConnection (/app/node_modules/.pnpm/knex@3.1.0_mysql2@1.7.0_mysql@2.18.1/node_modules/knex/lib/client.js:332:26)
bigcapital-server | at async Runner.ensureConnection (/app/node_modules/.pnpm/knex@3.1.0_mysql2@1.7.0_mysql@2.18.1/node_modules/knex/lib/execution/runner.js:305:28)
bigcapital-server | at async Runner.run (/app/node_modules/.pnpm/knex@3.1.0_mysql2@1.7.0_mysql@2.18.1/node_modules/knex/lib/execution/runner.js:30:19)
bigcapital-server | at async PaginationQueryBuilder.execute (/app/node_modules/.pnpm/objection@3.1.4_knex@3.1.0_mysql2@1.7.0_mysql@2.18.1_/node_modules/objection/lib/queryBuilder/QueryBuilder.js:446:22)
bigcapital-server | at async SettingsStore.load (/app/packages/server/build/index.js:25170:26)
bigcapital-server | at async webpack_modules.57181.exports.default (/app/packages/server/build/index.js:18808:5) {
bigcapital-server | sql: undefined,
bigcapital-server | bindings: undefined
bigcapital-server | }
bigcapital-mysql | 2025-0X-XX X:01:46 XXXXXXXXXXXXXX [Warning] Aborted connection 109 to db: 'bigcapital_tenant_XXXXXXXXXXXXXXXX' user: 'bigcapital' host: '172.18.0.7' (Got an error reading communication packets)
bigcapital-server exited with code 0