Flakey APIs need many retries.

Hello, I tried updating from the (discontinued?) ghcr.io/beeper/linkedin:latest container to dock.mau.dev/mautrix/linkedin:latest (is that supported?) and run into the following error when starting the bridge:

"pq: column \"identifiers\" is of type jsonb but expression is of type text"

The ghost.identifiers column has the type jsonb: https://github.com/mautrix/go/blob/27769dfc98bebdcec16bb2293029904109a2b9df/bridgev2/database/upgrades/00-latest.sql#L80

But this expression retuned text:

mautrix_linkedin=# select pg_typeof('["linkedin:' || li_member_urn || '"]') from puppet;
 pg_typeof
-----------
 text

This isn't compatible with sqlite. Has to be more like https://github.com/mautrix/whatsapp/blob/main/cmd/mautrix-whatsapp/legacymigrate.sql#L93-L99, I think it's json_array in sqlite and jsonb_build_array in postgres

Oh, sorry, I didn't realize that this was used for sqlite too, my bad! I'll see if I can fix that.

Thanks for pointing me in the right direction. I verified that the postgres function does what we want here. I don't have the sqlite database to test the sqlite equivalent, but from the docs it looks like it should work.

I'm not familiar with the templating format you are using here to support both postgres and sqlite, so I just copied the example you provided, I hope it's ok like that.