SQL error when MI runtime first sends heartbeat to the backend

[tharindu-nw]

When an MI runtime first connects to the icp backend, I am seeing the following SQL error:

time=2025-12-16T15:03:48.770+05:30 level=ERROR module=wso2/icp_server message="Failed to process heartbeat" error={"causes":[{"message":"Error while executing SQL query:
            INSERT INTO runtime_sequences (
                runtime_id, sequence_name, sequence_type, container, state
            ) VALUES (
                 ? ,  ? ,  ? ,
                 ? ,  ?
            )
        . Unique index or primary key violation: "PUBLIC.UK_RUNTIME_SEQUENCE_INDEX_B ON PUBLIC.RUNTIME_SEQUENCES(RUNTIME_ID NULLS FIRST, SEQUENCE_NAME NULLS FIRST) VALUES ( /* key:4 */ 'sample-mi-runtime-b2376269-4424-4106-9c52-508511f2e436', 'fault')"; SQL statement:

            INSERT INTO runtime_sequences (
                runtime_id, sequence_name, sequence_type, container, state
            ) VALUES (
                 ? ,  ? ,  ? ,
                 ? ,  ?
 [23505-232].","detail":{"errorCode":23505,"sqlState":"23505"},"stackTrace":[{"callableName":"execute","moduleName":"ballerinax.java.jdbc.1.Client","fileName":"client.bal","lineNumber":79},{"callableName":"insertAdditionalMIArtifacts","moduleName":"wso2.icp_server.storage.2","fileName":"heartbeat_repository.bal","lineNumber":607},{"callableName":"insertRuntimeArtifacts","moduleName":"wso2.icp_server.storage.2","fileName":"heartbeat_repository.bal","lineNumber":517},{"callableName":"processHeartbeat","moduleName":"wso2.icp_server.storage.2","fileName":"heartbeat_repository.bal","lineNumber":46},{"callableName":"$post$heartbeat","moduleName":"wso2.icp_server.2.$anonType$_52","fileName":"runtime_service.bal","lineNumber":68}]}],"message":"Failed to process heartbeat for runtime sample-mi-runtime-b2376269-4424-4106-9c52-508511f2e436","detail":{},"stackTrace":[{"callableName":"processHeartbeat","moduleName":"wso2.icp_server.storage.2","fileName":"heartbeat_repository.bal","lineNumber":77},{"callableName":"$post$heartbeat","moduleName":"wso2.icp_server.2.$anonType$_52","fileName":"runtime_service.bal","lineNumber":68}]}

This repeats for 7-8 times but then goes away and works as expected