chore: simplify migration script

[Ivansete-status]

Description

While running migration scripts we noticed that is better to try to change the table schema directly in the messages table. The reason is that is not possible to keep handle a table backup when the message table occupies 45GiB and the max size allowed in 50GiB

With this PR we try to allow database migration with low disk availability constraints.

We want to avoid errors like:

nim-waku  | ERR 2024-05-06 17:22:42.470+00:00 failed to execute migration statement      topics="waku archive migration" tid=1 file=migrations.nim:81 statement="INSERT INTO messages (\n                        pubsubTopic,\n                        contentTopic,\n                        payload,\n                        version,\n                        timestamp,\n                        id,\n                        messageHash,\n                        storedAt\n                     )\n                SELECT pubsubTopic,\n                       contentTopic,\n                       payload,\n                       version,\n                       timestamp,\n                       id,\n                       messageHash,\n                       storedAt\n                   FROM messages_backup;" error="error in performWriteQuery: error in asyncpool query: error in dbConnQuery calling waitQueryToFinish: error in query: ERROR:  could not extend file \"base/16385/1332673.15\": No space left on device\nHINT:  Check free disk space.\n"
nim-waku  | ERR 2024-05-06 17:22:42.471+00:00 Mounting protocols failed                  tid=1 file=node_factory.nim:433 error="failed to setup archive driver: ArchiveDriver build failed in migration: failed to execute migration statement"
nim-waku  | ERR 2024-05-06 17:22:42.472+00:00 Failed setting up node                     topics="wakunode main" tid=1 file=waku.nim:97 error="Mounting protocols failed: failed to setup archive driver: ArchiveDriver build failed in migration: failed to execute migration statement"
nim-waku  | ERR 2024-05-06 17:22:42.472+00:00 Waku initialization failed                 topics="wakunode main" tid=1 file=wakunode2.nim:139 error="Failed setting up node: Mounting protocols failed: failed to setup archive driver: ArchiveDriver build failed in migration: failed to execute migration statement"

[github-actions]

You can find the image built from this PR at

quay.io/wakuorg/nwaku-pr:2674-rln-v1

Built from 98f38f5

[github-actions]

You can find the image built from this PR at

quay.io/wakuorg/nwaku-pr:2674-rln-v2

Built from 98f38f5

[gabrielmer]

ufff so much better. Thanks so much! 🤩

[SionoiS]

LGTM

The meta field is initialized as null in this case?

[Ivansete-status]

Thanks for the comments guys!
@SionoiS - I just pushed a commit to enforce meta is null by default

[Ivansete-status]

Thanks for the comments guys!
@SionoiS - I just pushed a commit to enforce meta is null by default