dazzling-sky / COMP4111-project

COMP4111 project - RESTful Web Service for Library Book Management
https://course.cse.ust.hk/comp4111/project.html
0 stars 0 forks source link

Database only supports up to ~20 concurrent transactions #19

Open Derppening opened 4 years ago

Derppening commented 4 years ago

Issue description

When there are more than around 15 concurrent users conducting a transaction, additional users are unable to start a new transaction and the server does not respond.

Steps to reproduce this issue

  1. Login to the server using valid credentials
  2. Initiate a transaction using the token from the previous step
  3. Repeat until the message com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up. is shown in the server console.

What's the expected result?

What's the actual result?

comp4111ta commented 4 years ago

It is required to perform concurrent transactions in Phase 2