Replicate error `sqlite3_prepare_v2() : no such table` in Jenkins pipeline.

[cborla]

Wazuh version	Related issue	Component	Install type
4.8.0-rc2	22847	Database	Manager

Description

Referring to the issue:

• Broken database during Vulnerability Detector tests

Both the core team and the QA team have failed to reproduce the bug locally, we need the following from the QA team:

• Run the Jenkins pipeline and wait for it to fail. If it is intermittent, run it several times consecutively.
• Keep the environments without deleting.
• Provide us access to the environment.

DoD

• [x] The goal of this issue is the vm with the error message and access for analysis.

[juliamagan]

Launched https://ci.wazuh.info/job/Test_e2e_system/267/console. When the test is finished, the AMI of the instances will have to be created and access will have to be granted.

[juliamagan]

Provisioned environment and credentials sent to @cborla privately.

[cborla]

Hi @juliamagan, we have not yet closed the issue because the environment does not currently have the problem, we found no logs or corrupted databases that refer to the error.

• https://github.com/wazuh/wazuh/issues/22847#issuecomment-2087032988

[vikman90]

Please let's run the instances again with these branches, as I'm suspecting of a process termination timeout issue:

• 22847-lower-timeout
• 22847-greater-timeout

[cborla]

Since the issue Broken database during Vulnerability Detector tests for which access to these vm's was requested. I consider that the present issue can be closed.

[juliamagan]

Provisioned environment and credentials sent to @cborla and @vikman90

[juliamagan]

New environment provisioned and credentials sent to @LucioDonda

[vikman90]

Thank you @juliamagan, we can close this issue as we've managed to reproduce https://github.com/wazuh/wazuh/issues/22847 locally.

Best!