Unable to Unreserve Node 997 via Mycelium Cloud– 'Contract Not Found' Error

[shangreiyo]

Describe the bug

Username: Rvalenz
Email id: rvalenz@protonmail.com

A user is currently encountering an issue when attempting to unreserve Node 997. Each time they try to unreserve the node, the system returns the error message: "Contract ID not found for user."

Upon verification in GraphQL, contract ID 2085932 is still shown as being in an active state.

Screenshots

Ops repo link: https://forge.ourworld.tf/mycelium/circle_ops/issues/730#issue-3094

[mahendravarmayadala93]

Team, the client is still encountering an error when trying to unreserve the Node.

[AhmedHanafy725]

The flow that happened made this issue

• The workflow created the contract on the chain
• The workflow tried to add the contract info into the Mycelium Cloud DB. But failed with ID duplication

• The workflow tried to re-run the failed step and create the contract again, but it failed as it's already rented in the first try

So it ended up creating the contract, but has no record in the Mycelium cloud DB.

NOTE: This might happen because of the migration from SQLite to PostgreSQL.

kubecloud/backend/internal/core/workflows/node_activities.go

Lines 37 to 50 in 60affe8

	contractID, err := gridClient.CreateRentContract(config.Mnemonic, nodeID)
	if err != nil {
	return fmt.Errorf("failed to create rent contract for node_id=%d (user_id=%d): %w", nodeID, config.UserID, err)
	}
	err = userNodesRepo.CreateUserNode(&models.UserNodes{
	UserID: config.UserID,
	ContractID: contractID,
	NodeID: nodeID,
	CreatedAt: time.Now(),
	})
	if err != nil {
	return fmt.Errorf("failed to create user node record for node_id=%d (user_id=%d): %w", nodeID, config.UserID, err)
	}