search

kevoreilly / CAPEv2

Malware Configuration And Payload Extraction
https://capesandbox.com/analysis/
Other
1.91k stars 411 forks source link

[processing] sqlalchemy.exc.InvalidRequestError: A transaction is already begun on this Session. #2187

Closed dfr-fands closed 3 months ago

dfr-fands commented 3 months ago

On a fresh installation (Ubuntu 22.04) on the latest master branch commit, with default DB settings, the following error occurs when processing any task:

process.py ran with the following arguments: sudo -u cape /usr/bin/python3 -m poetry run python process.py -d -p7 auto -pt 900

image

I've tried rebooting the server, restarting CAPE, manually clearing the transaction from postgres, but it seems it's happening every time and its not something leftover from a failed analysis or anything like that.

doomedraven commented 3 months ago

@tbeadle can you get a look plz?

tbeadle commented 3 months ago

This should be fixed with https://github.com/CAPESandbox/community/pull/437. So just update your checkout of the community repo.

doomedraven commented 3 months ago

thanks @tbeadle

dfr-fands commented 3 months ago

Can confirm its working now, thanks.

Yatogaii commented 3 weeks ago

After applying the updated community repo, it still throws an exception: image

Reboot does not help, any ideas?

Thanks

doomedraven commented 3 weeks ago

Restart of service is needed for sure

Yatogaii commented 3 weeks ago

Thank you for your quick reply!

But I'm running process.py by sudo -u cape poetry run python /opt/CAPEv2/utils/process.py -p6 auto, so I think there is no cape-processor.service.

And systemctl status cape-processor.service return not found, maybe it is not a service issue?

doomedraven commented 3 weeks ago

Well if there is no service, then you installed cape in wrong way or installation failed