Error happened during query after delete referenced data ：cascade obj is not exist #1772

New Issue

xiaogan18 · 2020-08-24T10:02:54Z

xiaogan18 commented

2020-08-24 10:02:54 +00:00

table definition

type ClusterGroup struct {
	Id                   int64                  `json:"id" xorm:"pk autoincr unique notnull 'id'"`
	Name                 string                 `json:"name" xorm:"notnull"`
	Description          string                 `json:"description"`
	models.Common        `xorm:"extends"`
}

type Cluster struct {
	Id               int64               `json:"id" xorm:"pk autoincr unique notnull 'id'"`
	Name             string              `json:"name" xorm:"notnull"`
	ClusterGroup     *ClusterGroup       `json:"cluster_group"`
	models.Common    `xorm:"extends"`
}

issue

When I deleted row from ClusterGroup which is referenced by Cluster, all query with table Cluster were failed if result include the reference-missing rows, error message: cascade obj is not exist. Is there any solution for this?

## table definition ```go type ClusterGroup struct { Id int64 `json:"id" xorm:"pk autoincr unique notnull 'id'"` Name string `json:"name" xorm:"notnull"` Description string `json:"description"` models.Common `xorm:"extends"` } type Cluster struct { Id int64 `json:"id" xorm:"pk autoincr unique notnull 'id'"` Name string `json:"name" xorm:"notnull"` ClusterGroup *ClusterGroup `json:"cluster_group"` models.Common `xorm:"extends"` } ``` ## issue When I deleted row from `ClusterGroup` which is referenced by `Cluster`, all query with table `Cluster` were failed if result include the reference-missing rows, error message: `cascade obj is not exist`. Is there any solution for this?

lunny commented

2020-08-24 13:20:02 +00:00

Did you enabled cache?