Certain model structures cause SchemaUtils.create and

<a class="user-mention notranslate" data-hovercard-type="user" data-hovercard-url="/us

Cycle references detected, can't sort table references about exposed HOT 3 CLOSED

jetbrains commented on May 16, 2024

Cycle references detected, can't sort table references

from exposed.

Comments (3)

gcscaglia commented on May 16, 2024

Just in case downloading and running the example is cumbersome or otherwise inviable, here is the offending model:

object Boards : IntIdTable(name = "board") {
    val name = varchar("name", 255).index(isUnique = true)
}

object Posts : IntIdTable(name = "posts") {
    val board = optReference("board", Boards)
    val parent = optReference("parent", Posts)
}

The full exception with stacktrace (omitting JUnit stuff) is:

java.lang.IllegalStateException: Cycle references detected, can't sort table references!
    at org.jetbrains.exposed.dao.EntityCache$Companion.sortTablesByReferences(Entity.kt:437)
    at org.jetbrains.exposed.sql.SchemaUtils.createStatements(SchemaUtils.kt:15)
    at org.jetbrains.exposed.sql.SchemaUtils.create(SchemaUtils.kt:102)
    at example.TestMetaModels$testCreate$1.invoke(TestMetaModels.kt:22)
    at example.TestMetaModels$testCreate$1.invoke(TestMetaModels.kt:12)
    at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.inTopLevelTransaction(ThreadLocalTransactionManager.kt:69)
    at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction(ThreadLocalTransactionManager.kt:57)
    at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction(ThreadLocalTransactionManager.kt:48)
    at example.TestMetaModels.testCreate(TestMetaModels.kt:21)

from exposed.