QuickPotato crashes when large payload are sent to database (SQLite Only)

[JoeyHendricks]

The why:

When running in SQLite mode (not attached to a proper database server) QuickPotato will crash when the insert payload is over 999. This crash can happen every time when turning on system resource collection or when your stacks are large.

Work around:

Turn off system resource collection in the options file and for now refrain from measuring large and complex piece of code when running in SQLite mode. Or you can just connect to a database server like MySQL where to problem does not exist.

Reason:

SQLite cannot insert payload greater than 999 SQL variables therefore it would spit out the following error:

"too many SQL variables"

Link to problem description on stack overflow:

• https://stackoverflow.com/questions/7106016/too-many-sql-variables-error-in-django-with-sqlite3

Solution

Within the interpreter classes I need to make changes so the following action could be preformed:

• [x] Check if SQLite is used as a database server within the interpreter class
• [x] Split payload (if payload is over 999 and SQLite is used) in multiple chunks

[JoeyHendricks]

Made the changes required to fix the issues. Still need to do the following things before fix can be pushed to master branch:

• [x] Test if the problem is fixed when processing large stack sizes.
• [x] Create a test that uses a large stack to be able to retest this in the future.

[JoeyHendricks]

Problem is solved will add more tests to project soon