Update object relationship is trying to create it again

[mMarcos208]

How frequently does the bug occur?

Always

Description

I'm trying to update a relationship.

const realm = this.getRealm()
const [user] = realm.objects<User>(User.schema.name)

user.currentFarm = newCurrentFarm

[Error: Attempting to create an object of type 'Farm' with an existing primary key value '2311'.]

Realm 11.9.0 works well.

Stacktrace & log output

[Error: Attempting to create an object of type 'Farm' with an existing primary key value '2311'.]

Can you reproduce the bug?

Always

Reproduction Steps

No response

Version

12.3.1

What services are you using?

Local Database only

Are you using encryption?

No

Platform OS and version(s)

Android

Build environment

Flipper

"react-native": "0.72.7",

Cocoapods version

No response

[kneth]

@mMarcos208

In order to understand the issue better, can you provide the schema for User and Farm. Moreover, it would be good to know the properties of currentFarm and newCurrentFarm.

I am speculating if is related to #6239. Can you downgrade to v12.3.0 and see if you get the same error?

[mMarcos208]

@kneth My code.

import {ObjectSchema} from 'realm'

import {Farm} from './Farm'

export class User {
  id!: number

  // current farm id
  currentFarm?: Farm

  static schema: ObjectSchema = {
    name: 'User',
    primaryKey: 'id',
    properties: {
      id: 'int',
      currentFarm: 'Farm?',
    },
  }
}

import Realm from 'realm'

export class Farm {
  id!: number

  static schema: Realm.ObjectSchema = {
    name: 'Farm',
    primaryKey: 'id',
    properties: {
      id: 'int',
    },
  }
}

Downgrade my version to 12.3.0 and I get the same issue.

[kneth]

@mMarcos208 I am trying to reproduce the observed behavior in #6330. How does it match your code?

[mMarcos208]

@kneth try update Farmer with existing id again.

For exemple:

const farmer = this.realm.objectForPrimaryKey("Farmer", 11);
const farm = this.realm.objectForPrimaryKey("Farm", 22);

this.realm.write(() => {
farmer.currentFarm = farm
}

[kneth]

@mMarcos208 I have added a test like that, and it seems to work,

[mMarcos208]

@kneth can you test this cenary?

it("Update - same object", function (this: RealmContext) {
  this.realm.write(() => {
    this.realm.create("Farmer", { id: 11, currentFarm: { id: 22 } });
  });

  this.realm.write(() => {
    const newFarm = this.realm.create(Farm, { id: 33 });
    //@ts-expect-error cannot be null
    farmer.currentFarm = newFarm;
  });

  const farmer = this.realm.objectForPrimaryKey<Farmer>(Farmer, 11);
  const oldFarm = this.realm.objectForPrimaryKey<Farm>(Farm, 22);

  this.realm.write(() => {
    //@ts-expect-error cannot be null
    farmer.currentFarm = oldFarm;
  });

  expect(this.realm.objects<Farmer>(Farmer).length).equals(1);
  expect(this.realm.objects<Farm>(Farm).length).equals(2);
  expect(this.realm.objects<Farmer>(Farmer).currentFarm.id).equals(22);

}); 

[kneth]

@mMarcos208 I have added the suggested test, and the test passes.

[kneth]

As we haven't been able to reproduce it, I must ask you to create a unit test (like I did in #6330) to reproduce the observed behavior.

[mMarcos208]

Migration with same error. I change my schema:

I'm using realm 12.6.2

from

import {ObjectSchema} from 'realm'

export class Mapa {
  id!: number
  areaFazendaId!: number
 
  static schema: ObjectSchema = {
    name: 'Mapa',
    primaryKey: 'id',
    properties: {
      id: 'int',
      areaFazendaId: 'int'
    },
  }
}

to

import {ObjectSchema} from 'realm'

import {AreaFazenda} from '.'

export class Mapa {
  id!: number
  areaFazenda?: AreaFazenda
 
  static schema: ObjectSchema = {
    name: 'Mapa',
    primaryKey: 'id',
    properties: {
      id: 'int',
      areaFazenda: 'AreaFazenda?'
    },
  }
}

Remove areaFazendaId and add object AreaFazenda cause same error.

[Error: Attempting to create an object of type 'AreaFazenda' with an existing primary key value '60912'.]

My migration

  if (oldRealm.schemaVersion < 21 && newRealm.schemaVersion === 21) {
    const areasKeyById = keyBy(oldRealm.objects<schemas.AreaFazenda>(schemas.AreaFazenda.schema.name), 'id')
    const oldsMaps = oldRealm.objects<schemas.Mapa>(schemas.Mapa.schema.name)
    const newMaps = newRealm.objects<schemas.Mapa>(schemas.Mapa.schema.name)

    oldsMaps.forEach((x, index) => {
      console.log('line error', index)
      // eslint-disable-next-line @typescript-eslint/ban-ts-comment
      //@ts-ignore
      newMaps[index].areaFazenda = areasKeyById[x.areaFazendaId]
      // eslint-disable-next-line @typescript-eslint/ban-ts-comment
      // @ts-ignore
      delete x.areaFazendaId
    })
  }

[nirinchev]

As @kneth mentioned, if you have a project that we can run and repro (not just code snippets we have to assemble ourselves), please share it with us.

[github-actions]

This issue has been automatically closed because there has been no response to our request for more information from the original author. With only the information that is currently in the issue, we don't have enough information to take action. Please reach out if you have or find the answers we need so that we can investigate further.