chore: store node loses connection if database restarts

[Ivansete-status]

Background

After restarting the database, the store node doesn't connect again. Instead, it shows the following message until manually restarting the nwaku node:

nim-waku-store | ERR 2024-08-20 14:41:15.857+00:00 failed to insert message topics="waku archive" tid=1 file=archive.nim:108 error="could not put msg in messages table: error in runStmt: error in dbConnQueryPrepared calling sendQuery: failed pqsendQueryPrepared: no connection to the server\n"

[jakubgs]

Indeed, it appears only the insert code shows this behavior as we can see on this graph:

Because the query path continued to send statements the DB: