Database insert error after migrating to Postgres

[JijeshP]

Getting the following error after migrating to postgres Database

where: undefined, schema: 'public', table: 'hitl_messages', column: undefined, dataType: undefined, constraint: 'tmp_hitl_messages_pkey', file: 'nbtinsert.c', line: '434', routine: '_bt_check_unique' } } Reason: { message: 'insert into "hitl_messages" ("direction", "raw_message", "session_id", "text", "ts", "type") values ($1, $2, $3, $4, now(), $5) - duplicate key value violates unique constraint "tmp_hitl_messages_pkey"', stack: 'error: duplicate key value violates unique constraint "tmp_hitl_messages_pkey"\n at Connection.parseE (/Works/bot/mb-bot/node_modules/pg/lib/connection.js:567:11)\n at Connection.parseMessage (/Works/bot/mb-bot/node_modules/pg/lib/connection.js:391:17)\n at Socket.<anonymous> (/Works/bot/mb-bot/node_modules/pg/lib/connection.js:129:22)\n at emitOne (events.js:116:13)\n at Socket.emit (events.js:211:7)\n at addChunk (_stream_readable.js:263:12)\n at readableAddChunk (_stream_readable.js:250:11)\n at Socket.Readable.push (_stream_readable.js:208:10)\n at TCP.onread (net.js:594:20)', name: 'error', length: 212,

Botpress version: 10.46.4

Channels: Webchat, Webhook

[shamoh19]

+1 Facing same issue

[epaminond]

This one seems to be introduced by botpress/botpress#972 and botpress/botpress#978 : module migration that was added runs each time the bot gets started. The migration that was added to hitl recreates table which causes it sequence to reset and thus fail later on.