Summary:
In case /tmp directory has noexec attribute - snappy initialization fails. It unpacks the
*.so library to /tmp/... and tries to load it into memory - which fails.
This change makes sure we set a subpath of the YBA storage dir for that as it never has noexec.
Also, picking up the same fix for embedded PA collector.

The failure above was also leaving support bundle in 'in progress' state, even though task was failing. This is becuase it was throwing Error instead of Exception. Making sure we handle all Throwables.

Test Plan:
Set noexec attribute to /tmp
Start YBA. Collect support bundle - make sure it works as expected.

Reviewers: nsingh

Reviewed By: nsingh

Subscribers: yugaware

Differential Revision: https://phorge.dev.yugabyte.com/D55440