fix: too many open files error

[ArnaudSene]

as a team: fix the "too many open files error"

in order to stabilize the task listener

Dod:

• The task listener is running without error
• To validate, execute at least 20 bridge operation

Here is a error message:

Task exception was never retrieved future: <Task finished name='Task-113' coro=<consumer() done, defined at /Users/arnaudsene/Documents/Code/blockchain/projects/Allfunding/bridge-relay-poc/relayer-py/.venv/lib/python3.12/site-packages/aio_pika/queue.py:31> exception=OSError(24, 'Too many open files')> Traceback (most recent call last): File "/Users/arnaudsene/Documents/Code/blockchain/projects/Allfunding/bridge-relay-poc/relayer-py/.venv/lib/python3.12/site-packages/aio_pika/queue.py", line 37, in consumer File "/Users/arnaudsene/Documents/Code/blockchain/projects/Allfunding/bridge-relay-poc/relayer-py/src/relayer/provider/relayer_register_aio_pika.py", line 196, in _callback File "/Users/arnaudsene/Documents/Code/blockchain/projects/Allfunding/bridge-relay-poc/relayer-py/src/relayer/application/consume_events.py", line 576, in callback File "/Users/arnaudsene/Documents/Code/blockchain/projects/Allfunding/bridge-relay-poc/relayer-py/src/relayer/application/consume_events.py", line 537, in manage_event_with_rules File "/Users/arnaudsene/Documents/Code/blockchain/projects/Allfunding/bridge-relay-poc/relayer-py/src/relayer/application/consume_events.py", line 435, in execute_smart_contract_function File "/Users/arnaudsene/Documents/Code/blockchain/projects/Allfunding/bridge-relay-poc/relayer-py/src/relayer/application/execute_contracts.py", line 30, in init File "/Users/arnaudsene/Documents/Code/blockchain/projects/Allfunding/bridge-relay-poc/relayer-py/src/relayer/application/base_logging.py", line 73, in init File "/opt/homebrew/Cellar/python@3.12/3.12.2_1/Frameworks/Python.framework/Versions/3.12/lib/python3.12/logging/init.py", line 1214, in init File "", line 423, in abspath OSError: [Errno 24] Too many open files

[ArnaudSene]

• Add a new repository provider using sqlite Async
• Unit test done
• Need to implement the logic

[ArnaudSene]

Fixed issue with logging Implemented databases (sqlite, postgres, leveldb) Need to validate rocksdb and/or lmdb for concurrent