Recently @matthelm observed an unexpected behaviour when creating new resources.
The problem was caused when the transaction isolation in Materialize was set to serializable causing the read function to intermittently fail right after a create statement is executed.
The suggested fix is to explicitly run SET transaction_isolation = 'strict serializable' whenever we create a new connection in Terraform.
Feature request
Recently @matthelm observed an unexpected behaviour when creating new resources.
The problem was caused when the transaction isolation in Materialize was set to
serializablecausing the read function to intermittently fail right after a create statement is executed.The suggested fix is to explicitly run
SET transaction_isolation = 'strict serializable'whenever we create a new connection in Terraform.