search

realm / realm-kotlin

Kotlin Multiplatform and Android SDK for the Realm Mobile Database: Build Better Apps Faster.
Apache License 2.0
959 stars 59 forks source link

Crash in RealmSet query #1183

Closed KevinBoulongne closed 1 year ago

KevinBoulongne commented 1 year ago

Hello there !

I've got a weird crash when querying a RealmSet.

The Thread object contains a messagesIds :

var messagesIds: RealmSet<String> = realmSetOf()

I'm trying to get all threads in Realm that contains in their messagesIds at list 1 messageId from the input Set :

private fun getThreadsQuery(input: Set<String>, realm: TypedRealm): RealmQuery<Thread> {
    val byMessagesIds = "ANY ${Thread::messagesIds.name} IN {${input.joinToString { "'$it'" }}}"
    return realm.query(byMessagesIds)
}

And it works !

But sometimes, the query crashes. I was not able to understand why, I logged the data and everything seems fine. It looks random, never on the same item, and I don't really understand the error message.

I've just started very recently to use RealmSets, so I don't really know if there's any specific aspect to them, compared to RealmLists.

The code is available here on the branch realmBug : https://github.com/Infomaniak/android-mail/tree/realmBug

Stacktrace below :

10:54:41.000 REALM                 E  /Users/realm/workspace-realm-kotlin/main/packages/external/core/src/realm/mixed.cpp:337: [realm-core-13.1.2] Assertion failed: false && "Compare not supported for this column type"
                                      <backtrace not supported on this platform>!!! IMPORTANT: Please report this at https://github.com/realm/realm-core/issues/new/choose
--------- beginning of crash
10:54:41.134 libc                  A  Fatal signal 6 (SIGABRT), code -1 (SI_QUEUE) in tid 21464 (2-1901061.realm), pid 21370 (infomaniak.mail)
10:54:41.424 DEBUG                 A  Cmdline: com.infomaniak.mail
10:54:41.424                       A  pid: 21370, tid: 21464, name: 2-1901061.realm  >>> com.infomaniak.mail <<<
10:54:41.424                       A        #01 pc 0000000000da7bbc  /data/app/~~LLOj0LBHvp22mRf3jIABXg==/com.infomaniak.mail-OaLAKnoLR5y4It8dJzFR-w==/base.apk!librealmc.so (BuildId: 666549597b05bcac0372d465a1219f7ac49f20c8)
10:54:41.424                       A        #02 pc 0000000000da7e04  /data/app/~~LLOj0LBHvp22mRf3jIABXg==/com.infomaniak.mail-OaLAKnoLR5y4It8dJzFR-w==/base.apk!librealmc.so (BuildId: 666549597b05bcac0372d465a1219f7ac49f20c8)
10:54:41.424                       A        #03 pc 0000000000da7c8c  /data/app/~~LLOj0LBHvp22mRf3jIABXg==/com.infomaniak.mail-OaLAKnoLR5y4It8dJzFR-w==/base.apk!librealmc.so (BuildId: 666549597b05bcac0372d465a1219f7ac49f20c8)
10:54:41.424                       A        #04 pc 0000000000cbc110  /data/app/~~LLOj0LBHvp22mRf3jIABXg==/com.infomaniak.mail-OaLAKnoLR5y4It8dJzFR-w==/base.apk!librealmc.so (BuildId: 666549597b05bcac0372d465a1219f7ac49f20c8)
10:54:41.424                       A        #05 pc 00000000006b7044  /data/app/~~LLOj0LBHvp22mRf3jIABXg==/com.infomaniak.mail-OaLAKnoLR5y4It8dJzFR-w==/base.apk!librealmc.so (BuildId: 666549597b05bcac0372d465a1219f7ac49f20c8)
10:54:41.424                       A        #06 pc 00000000008dc35c  /data/app/~~LLOj0LBHvp22mRf3jIABXg==/com.infomaniak.mail-OaLAKnoLR5y4It8dJzFR-w==/base.apk!librealmc.so (BuildId: 666549597b05bcac0372d465a1219f7ac49f20c8)
10:54:41.424                       A        #07 pc 0000000000ce6094  /data/app/~~LLOj0LBHvp22mRf3jIABXg==/com.infomaniak.mail-OaLAKnoLR5y4It8dJzFR-w==/base.apk!librealmc.so (BuildId: 666549597b05bcac0372d465a1219f7ac49f20c8)
10:54:41.424                       A        #08 pc 0000000000ce2b04  /data/app/~~LLOj0LBHvp22mRf3jIABXg==/com.infomaniak.mail-OaLAKnoLR5y4It8dJzFR-w==/base.apk!librealmc.so (BuildId: 666549597b05bcac0372d465a1219f7ac49f20c8)
10:54:41.424                       A        #09 pc 0000000000ce27e0  /data/app/~~LLOj0LBHvp22mRf3jIABXg==/com.infomaniak.mail-OaLAKnoLR5y4It8dJzFR-w==/base.apk!librealmc.so (BuildId: 666549597b05bcac0372d465a1219f7ac49f20c8)
10:54:41.424                       A        #10 pc 0000000000af7628  /data/app/~~LLOj0LBHvp22mRf3jIABXg==/com.infomaniak.mail-OaLAKnoLR5y4It8dJzFR-w==/base.apk!librealmc.so (BuildId: 666549597b05bcac0372d465a1219f7ac49f20c8)
10:54:41.424                       A        #11 pc 0000000000afd1e4  /data/app/~~LLOj0LBHvp22mRf3jIABXg==/com.infomaniak.mail-OaLAKnoLR5y4It8dJzFR-w==/base.apk!librealmc.so (BuildId: 666549597b05bcac0372d465a1219f7ac49f20c8)
10:54:41.424                       A        #12 pc 0000000000afd120  /data/app/~~LLOj0LBHvp22mRf3jIABXg==/com.infomaniak.mail-OaLAKnoLR5y4It8dJzFR-w==/base.apk!librealmc.so (BuildId: 666549597b05bcac0372d465a1219f7ac49f20c8)
10:54:41.424                       A        #13 pc 0000000000afd0d0  /data/app/~~LLOj0LBHvp22mRf3jIABXg==/com.infomaniak.mail-OaLAKnoLR5y4It8dJzFR-w==/base.apk!librealmc.so (BuildId: 666549597b05bcac0372d465a1219f7ac49f20c8)
10:54:41.424                       A        #14 pc 0000000000bd5fe0  /data/app/~~LLOj0LBHvp22mRf3jIABXg==/com.infomaniak.mail-OaLAKnoLR5y4It8dJzFR-w==/base.apk!librealmc.so (BuildId: 666549597b05bcac0372d465a1219f7ac49f20c8)
10:54:41.424                       A        #15 pc 0000000000bd5e08  /data/app/~~LLOj0LBHvp22mRf3jIABXg==/com.infomaniak.mail-OaLAKnoLR5y4It8dJzFR-w==/base.apk!librealmc.so (BuildId: 666549597b05bcac0372d465a1219f7ac49f20c8)
10:54:41.424                       A        #16 pc 0000000000bd7244  /data/app/~~LLOj0LBHvp22mRf3jIABXg==/com.infomaniak.mail-OaLAKnoLR5y4It8dJzFR-w==/base.apk!librealmc.so (BuildId: 666549597b05bcac0372d465a1219f7ac49f20c8)
10:54:41.424                       A        #17 pc 0000000000af8f98  /data/app/~~LLOj0LBHvp22mRf3jIABXg==/com.infomaniak.mail-OaLAKnoLR5y4It8dJzFR-w==/base.apk!librealmc.so (BuildId: 666549597b05bcac0372d465a1219f7ac49f20c8)
10:54:41.424                       A        #18 pc 0000000000af9c7c  /data/app/~~LLOj0LBHvp22mRf3jIABXg==/com.infomaniak.mail-OaLAKnoLR5y4It8dJzFR-w==/base.apk!librealmc.so (BuildId: 666549597b05bcac0372d465a1219f7ac49f20c8)
10:54:41.424                       A        #19 pc 0000000000afa2e0  /data/app/~~LLOj0LBHvp22mRf3jIABXg==/com.infomaniak.mail-OaLAKnoLR5y4It8dJzFR-w==/base.apk!librealmc.so (BuildId: 666549597b05bcac0372d465a1219f7ac49f20c8)
10:54:41.424                       A        #20 pc 000000000068c078  /data/app/~~LLOj0LBHvp22mRf3jIABXg==/com.infomaniak.mail-OaLAKnoLR5y4It8dJzFR-w==/base.apk!librealmc.so (BuildId: 666549597b05bcac0372d465a1219f7ac49f20c8)
10:54:41.424                       A        #21 pc 000000000068f90c  /data/app/~~LLOj0LBHvp22mRf3jIABXg==/com.infomaniak.mail-OaLAKnoLR5y4It8dJzFR-w==/base.apk!librealmc.so (BuildId: 666549597b05bcac0372d465a1219f7ac49f20c8)
10:54:41.424                       A        #22 pc 00000000005f48ac  /data/app/~~LLOj0LBHvp22mRf3jIABXg==/com.infomaniak.mail-OaLAKnoLR5y4It8dJzFR-w==/base.apk!librealmc.so (BuildId: 666549597b05bcac0372d465a1219f7ac49f20c8)
10:54:41.424                       A        #23 pc 00000000005e8a84  /data/app/~~LLOj0LBHvp22mRf3jIABXg==/com.infomaniak.mail-OaLAKnoLR5y4It8dJzFR-w==/base.apk!librealmc.so (BuildId: 666549597b05bcac0372d465a1219f7ac49f20c8)
10:54:41.424                       A        #24 pc 00000000005e8a30  /data/app/~~LLOj0LBHvp22mRf3jIABXg==/com.infomaniak.mail-OaLAKnoLR5y4It8dJzFR-w==/base.apk!librealmc.so (realm_results_count+52) (BuildId: 666549597b05bcac0372d465a1219f7ac49f20c8)
10:54:41.424                       A        #25 pc 0000000000585f58  /data/app/~~LLOj0LBHvp22mRf3jIABXg==/com.infomaniak.mail-OaLAKnoLR5y4It8dJzFR-w==/base.apk!librealmc.so (Java_io_realm_kotlin_internal_interop_realmcJNI_realm_1results_1count+116) (BuildId: 666549597b05bcac0372d465a1219f7ac49f20c8)
10:54:41.424                       A        #28 pc 00000000004aca90  [anon:dalvik-classes.dex extracted in memory from /data/app/~~LLOj0LBHvp22mRf3jIABXg==/com.infomaniak.mail-OaLAKnoLR5y4It8dJzFR-w==/base.apk] (io.realm.kotlin.internal.interop.realmc.realm_results_count+0)
10:54:41.424                       A        #30 pc 00000000004a3eb6  [anon:dalvik-classes.dex extracted in memory from /data/app/~~LLOj0LBHvp22mRf3jIABXg==/com.infomaniak.mail-OaLAKnoLR5y4It8dJzFR-w==/base.apk] (io.realm.kotlin.internal.interop.RealmInterop.realm_results_count+26)
10:54:41.424                       A        #32 pc 0000000000497cf8  [anon:dalvik-classes.dex extracted in memory from /data/app/~~LLOj0LBHvp22mRf3jIABXg==/com.infomaniak.mail-OaLAKnoLR5y4It8dJzFR-w==/base.apk] (io.realm.kotlin.internal.RealmResultsImpl.getSize+8)
10:54:41.424                       A        #34 pc 0000000000108c74  [anon:dalvik-classes26.dex extracted in memory from /data/app/~~LLOj0LBHvp22mRf3jIABXg==/com.infomaniak.mail-OaLAKnoLR5y4It8dJzFR-w==/base.apk!classes26.dex] (kotlin.collections.AbstractCollection.size+0)
10:54:41.424                       A        #37 pc 00000000000093e4  /data/data/com.infomaniak.mail/code_cache/.overlay/base.apk/classes20.dex (com.infomaniak.mail.data.cache.mailboxContent.MessageController.createMultiMessagesThreads+144)
10:54:41.424                       A        #39 pc 00000000000086d6  /data/data/com.infomaniak.mail/code_cache/.overlay/base.apk/classes20.dex (com.infomaniak.mail.data.cache.mailboxContent.MessageController$handleAddedUids$1$1.invoke+74)
10:54:41.424                       A        #41 pc 0000000000008722  /data/data/com.infomaniak.mail/code_cache/.overlay/base.apk/classes20.dex (com.infomaniak.mail.data.cache.mailboxContent.MessageController$handleAddedUids$1$1.invoke+6)
10:54:41.424                       A        #43 pc 000000000049b020  [anon:dalvik-classes.dex extracted in memory from /data/app/~~LLOj0LBHvp22mRf3jIABXg==/com.infomaniak.mail-OaLAKnoLR5y4It8dJzFR-w==/base.apk] (io.realm.kotlin.internal.SuspendableWriter$write$2.invokeSuspend+228)
10:54:41.424                       A        #45 pc 000000000016b3ea  [anon:dalvik-classes26.dex extracted in memory from /data/app/~~LLOj0LBHvp22mRf3jIABXg==/com.infomaniak.mail-OaLAKnoLR5y4It8dJzFR-w==/base.apk!classes26.dex] (kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith+42)
---------------------------- PROCESS ENDED (21370) for package com.infomaniak.mail ----------------------------
KevinBoulongne commented 1 year ago

I've just realised that I was supposed to report the issue in this project instead https://github.com/realm/realm-core ? Do I copy it there, or here is enough ?

edualonso commented 1 year ago

Hi @KevinBoulongne Would it be possible for you to provide any of the query strings that are causing the code to crash? Maybe the generated byMessagesIds string is somehow wrong and causes the query to fail?

KevinBoulongne commented 1 year ago

Thanks for the quick answer !

This query doesn't work :

ANY messagesIds IN {'x5LclNY3e-kXVGv47HcigEmKsgZ0uAp_ml0JkuKc1H0KixHY0CooZacQaza_yR2zZoCg5ApQ1tRYLc-QmJ48iypv7U0Ns0fgLaYMC-5TuAw=@protonmail.com', 'Qui9GguOBHwGi_li4yC1yJdAvtW6j--phPAxDAZAWJMjDS7n9fK7wJi8MppKuHEFxbXmWUMkoxquaSvj4HH36kxw2xFmJlbbcCfmtTrjWiU=@protonmail.com', '4EE5F598-DE13-4D7F-AB4D-F6C0CA1CD6BF@infomaniak.com', '303150E9-1156-44BC-989D-43D79F260F63@infomaniak.com', 'ytS7w3_-HAsBKR7qfBKXKkKjrhd9YML3Xf8YaqwPsLHL72L95e3P_A4jaNB2hBDkKsNZu0df53yHp79BWM6tDTuOmj65fFxQAhyIEjWzCR0=@protonmail.com', 'E67C63BE-0B00-4CB0-86D1-F1984032B9B6@infomaniak.com', '43F3A152-0C66-4463-900C-0133F7E1AD2D@infomaniak.com'}

At first I thought maybe the query is too long, but this one works, and it's even longer :

ANY messagesIds IN {'66fb5ce1cfc6f2a10ddf1779beacf1c2@mail.infomaniak.com', '607c224d-4268-483e-964e-cca84addaffe@Spark', '9b1e1425-25d2-4761-a554-669122083fb1@Spark', '44EDE1F7-8AB4-4D58-B114-7B3853826EB9@dataphone.ch', 'PR3PR05MB716282FC30939E1256EA892288329@PR3PR05MB7162.eurprd05.prod.outlook.com', '5A5B28E8-27A4-49CB-BC08-0277331F31C6@infomaniak.com', 'PR3PR05MB7162F4B069B0EB72849FEE8B88329@PR3PR05MB7162.eurprd05.prod.outlook.com', 'B7F4DFEA-3E8F-44EA-9FAA-6F29BBD72C92@infomaniak.com', 'PR3PR05MB7162A015B11422AC1EBDB5DF88379@PR3PR05MB7162.eurprd05.prod.outlook.com', '51e52191-695d-472c-be10-83db65d171ba@Spark', 'PR3PR05MB71624ED868C07B816DD21A2688379@PR3PR05MB7162.eurprd05.prod.outlook.com', 'DB7PR05MB5004804DB8FCBFD6031821A4973E9@DB7PR05MB5004.eurprd05.prod.outlook.com', '354FEAA5-DC1D-459D-8C48-5724A5D218A3@infomaniak.com', 'B881323F-332F-46F7-BF93-B7D68C643030@dataphone.ch', '882C643A-959A-481F-9A0B-52CCFA855568@infomaniak.com', 'DB7PR05MB50043C7EA073E660FC89298897049@DB7PR05MB5004.eurprd05.prod.outlook.com', 'DB7PR05MB50045BA3C5EE85AA1BEF906C97049@DB7PR05MB5004.eurprd05.prod.outlook.com', '21179B0D-B1D2-4235-B43B-8D3B0D7722A1@infomaniak.com', 'PR3PR05MB71622178613AE1ADD4F05B6788099@PR3PR05MB7162.eurprd05.prod.outlook.com', 'DB7PR05MB50048F2CB026CC0D6147934197149@DB7PR05MB5004.eurprd05.prod.outlook.com', '71A7929D-C4DE-4EA9-9147-91691F5C9E8F@infomaniak.com', '5086558be69e7900e7de5ca7ef8192fd@mail.infomaniak.com', '17B11C71-99DE-41A8-819F-DC9A5AD4EC77@infomaniak.com', '0f83c76fb4d9b7461a5c99ee79b1d66b@mail.infomaniak.com'}
clementetb commented 1 year ago

You are using a snapshot release, could you check if you can reproduce with the Realm's latest stable version (1.5.1).

KevinBoulongne commented 1 year ago

Same with Realm's stable version 1.5.1 :

ANY messagesIds IN {'5rvpGLS-VXbNEQ56laDfrlA3v-dD-V1V_3fvcCo5P8lz_BkeDG2eM7tJ3gZZxImWmGQ77qzqX3QmdTYyXm2HkuuhOcLSQa5nwS3YtGUNfBw=@protonmail.com', '73045E97-77A3-4881-B67B-016FBF189A18@infomaniak.com', 'yD2YHRVVuuMmm0vrUQShajZMW1WqBHZuwV-_xyRHLjL8-_bn-zp5iPpRr-DPqjz2rspJS5Yl2lAM17aUc1pJxeZmYCH88b_J9AMpvud1rFA=@protonmail.com', '96F6FE44-A397-4C85-B12B-1CC493A252D6@infomaniak.com', 'KiNVS_dHAP2jYEb3PM39Za2jDz2KX_5oZhyBxzQF7ON-EBCG3lKa-iW7M8B8gWUOjI7h-ok88P06afoFSFbvjhFimSfYnQ60hGXeOOCLb1g=@protonmail.com', '3B77783B-167C-4C09-A4FB-5FE2200AA36D@infomaniak.com', 'fL6HtmmNREhg9bYRtv6jv4wA8snVRxoQi1c-FpHckiJxCKCpQzpskcEMubAyN1v_AGT-u2Xs4sUOwsBNnDDM6gb7q7bfyI7Xe3JdWy_hyOk=@protonmail.com', '372C1BFA-409A-46D0-B3D9-1680D23256D3@infomaniak.com'}
clementetb commented 1 year ago

We are not able to reproduce the issue at our end, would you be able to create a test project that reproduces the issue?

rorbech commented 1 year ago

@KevinBoulongne As mentioned we are not able to reproduce this by defining a model with a string set field and querying with you example string. The error message sounds like you are feeding some completely different to the query method. Do you have any further observations around this ... Are you imposing a subquery on the query returned from getThreadsQuery, etc?

github-actions[bot] commented 1 year ago

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.

JorisBodin commented 1 year ago

Forgive us for our late response.

The line of code that produces this crash: https://github.com/Infomaniak/android-mail/blob/realmBug/app/src/main/java/com/infomaniak/mail/data/cache/mailboxContent/MessageController.kt#L274

Example of a request made until it crashes. And it always crashes with this last thread id

16:10:58.270  E  ANY messagesIds IN {'E2327257-0446-49DE-9D59-2EB1E7DEB282@infomaniak.com', 'A6214C33-842F-4196-B07B-DEECB28B1F29@infomaniak.com', 'df093a5e1e3ab8014690cca469aefb09@mail.infomaniak.com', '7455a0e7296fc4a5219012b6db939392@mail.infomaniak.com'}
16:10:58.272  E  ANY messagesIds IN {'47b9825ce902f33cd5856ef9a22c1823@mail.infomaniak.com', 'A6214C33-842F-4196-B07B-DEECB28B1F29@infomaniak.com', 'df093a5e1e3ab8014690cca469aefb09@mail.infomaniak.com', '7455a0e7296fc4a5219012b6db939392@mail.infomaniak.com', 'E2327257-0446-49DE-9D59-2EB1E7DEB282@infomaniak.com', 'C2866053-981D-476F-B27D-D02EB4D9FE49@infomaniak.com'}
16:10:58.272  E  ANY messagesIds IN {'0f22160968e994e522f971a297d217e7@mail.infomaniak.com'}
16:10:58.273  E  ANY messagesIds IN {'98a5c61ed3872c9728bb7155976b0b8a@mail.infomaniak.com'}
16:10:58.274  E  ANY messagesIds IN {'C2E7012D-525B-49C9-9FCC-53293FB304B7@infomaniak.com'}
16:10:58.275  E  ANY messagesIds IN {'9878cd890f00fad31e10cb8d772bf0e1@mail.infomaniak.com', '607c224d-4268-483e-964e-cca84addaffe@Spark', '9b1e1425-25d2-4761-a554-669122083fb1@Spark', '44EDE1F7-8AB4-4D58-B114-7B3853826EB9@dataphone.ch', 'PR3PR05MB716282FC30939E1256EA892288329@PR3PR05MB7162.eurprd05.prod.outlook.com', '5A5B28E8-27A4-49CB-BC08-0277331F31C6@infomaniak.com', 'PR3PR05MB7162F4B069B0EB72849FEE8B88329@PR3PR05MB7162.eurprd05.prod.outlook.com', 'B7F4DFEA-3E8F-44EA-9FAA-6F29BBD72C92@infomaniak.com', 'PR3PR05MB7162A015B11422AC1EBDB5DF88379@PR3PR05MB7162.eurprd05.prod.outlook.com', '51e52191-695d-472c-be10-83db65d171ba@Spark', 'PR3PR05MB71624ED868C07B816DD21A2688379@PR3PR05MB7162.eurprd05.prod.outlook.com', 'DB7PR05MB5004804DB8FCBFD6031821A4973E9@DB7PR05MB5004.eurprd05.prod.outlook.com', '354FEAA5-DC1D-459D-8C48-5724A5D218A3@infomaniak.com', 'B881323F-332F-46F7-BF93-B7D68C643030@dataphone.ch', '882C643A-959A-481F-9A0B-52CCFA855568@infomaniak.com', 'DB7PR05MB50043C7EA073E660FC89298897049@DB7PR05MB5004.eurprd05.prod.outlook.com', 'DB7PR05MB50045BA3C5EE85AA1BEF906C97049@DB7PR05MB5004.eurprd05.prod.outlook.com', '21179B0D-B1D2-4235-B43B-8D3B0D7722A1@infomaniak.com', 'PR3PR05MB71622178613AE1ADD4F05B6788099@PR3PR05MB7162.eurprd05.prod.outlook.com', '45fa34f0-1a09-4184-9336-decb7aa670fb@Spark', 'PR3PR05MB71620700B38C7FDA170102A3881A9@PR3PR05MB7162.eurprd05.prod.outlook.com', '4ad13126-0d71-4c97-8dc7-7d081f413c07@Spark', 'a19d5486b08a660a83f90611ecd8e740@mail.infomaniak.com'}
16:10:58.276  E  ANY messagesIds IN {'9cda4a2b26748d94a9ff83c42294203a@mail.infomaniak.com'}
16:10:58.277  E  ANY messagesIds IN {'6e8c63a2bef31fc17a1af87f611ad181@mail.infomaniak.com'}
16:10:58.277  E  ANY messagesIds IN {'3e42f7a0-4e70-4478-851c-df792c2897ab@Spark', '607c224d-4268-483e-964e-cca84addaffe@Spark', '9b1e1425-25d2-4761-a554-669122083fb1@Spark', '44EDE1F7-8AB4-4D58-B114-7B3853826EB9@dataphone.ch', 'PR3PR05MB716282FC30939E1256EA892288329@PR3PR05MB7162.eurprd05.prod.outlook.com', '5A5B28E8-27A4-49CB-BC08-0277331F31C6@infomaniak.com', 'PR3PR05MB7162F4B069B0EB72849FEE8B88329@PR3PR05MB7162.eurprd05.prod.outlook.com', 'B7F4DFEA-3E8F-44EA-9FAA-6F29BBD72C92@infomaniak.com', 'PR3PR05MB7162A015B11422AC1EBDB5DF88379@PR3PR05MB7162.eurprd05.prod.outlook.com', '51e52191-695d-472c-be10-83db65d171ba@Spark', 'PR3PR05MB71624ED868C07B816DD21A2688379@PR3PR05MB7162.eurprd05.prod.outlook.com', 'DB7PR05MB5004804DB8FCBFD6031821A4973E9@DB7PR05MB5004.eurprd05.prod.outlook.com', '354FEAA5-DC1D-459D-8C48-5724A5D218A3@infomaniak.com', 'B881323F-332F-46F7-BF93-B7D68C643030@dataphone.ch', '882C643A-959A-481F-9A0B-52CCFA855568@infomaniak.com', 'DB7PR05MB50043C7EA073E660FC89298897049@DB7PR05MB5004.eurprd05.prod.outlook.com', 'DB7PR05MB50045BA3C5EE85AA1BEF906C97049@DB7PR05MB5004.eurprd05.prod.outlook.com', '21179B0D-B1D2-4235-B43B-8D3B0D7722A1@infomaniak.com', 'PR3PR05MB71622178613AE1ADD4F05B6788099@PR3PR05MB7162.eurprd05.prod.outlook.com', '45fa34f0-1a09-4184-9336-decb7aa670fb@Spark', 'PR3PR05MB71620700B38C7FDA170102A3881A9@PR3PR05MB7162.eurprd05.prod.outlook.com', '4ad13126-0d71-4c97-8dc7-7d081f413c07@Spark', 'a19d5486b08a660a83f90611ecd8e740@mail.infomaniak.com', '9878cd890f00fad31e10cb8d772bf0e1@mail.infomaniak.com', 'C467BE9D-1F09-4047-BF90-A8B910C4AB91@infomaniak.com'}
16:10:58.278  E  ANY messagesIds IN {'a063c53f7d6c903cb79c675a75cc84b4@mail.infomaniak.com'}
16:10:58.279  E  ANY messagesIds IN {'a7eddca604a2b3e1662df4a618552fda@mail.infomaniak.com'}
16:10:58.279  E  ANY messagesIds IN {'20230123120056.56.10474@infomaniak.com'}
16:10:58.280  E  ANY messagesIds IN {'r1x2G000000000000000000000000000000000000000000000ROXUNQ007Uz8E_dYRpOOZ4qpFVUdXg@sfdc.net'}
16:10:58.281  E  ANY messagesIds IN {'reply-6651-2104272534-6352444191-1674487646-1324560410@helpscout.net', '81C44744-6494-40A3-8040-FD8DAB1A73E8@infomaniak.com', 'reply-6651-2104272534-6345707091-1674224893-541718340@helpscout.net'}
16:10:58.282  E  ANY messagesIds IN {'7A4D75DC-652A-47AE-BE38-6CCB0F3AC768@infomaniak.com', '17E705D7-2D0B-479F-935D-1DF9C08B4457@infomaniak.com', 'FB049826-CB88-43F4-80C8-F21C31DA17B7@infomaniak.com', '5F79E5A7-6F00-4D14-919F-2AA5C4A59C21@infomaniak.com', '3207CD10-4287-48CA-99F8-F172538DC2D1@infomaniak.com', 'F02F1C7A-1014-46F1-8879-B1E5F6B40224@infomaniak.com', '5B6C1ABB-8D5B-4320-A1E6-1F20484AC490@infomaniak.com'}
16:10:58.283  E  ANY messagesIds IN {'8634173B-A8F5-4D78-A044-83ABB473E644@infomaniak.com'}
16:10:58.283  E  ANY messagesIds IN {'0b839f8bd5084d0f3f26ea52a002726c@mail.infomaniak.com'}
16:10:58.284  E  ANY messagesIds IN {'01000185e3bbbc1c-a71a781b-b701-48c3-b19d-34012e864ab8-000000@email.amazonses.com'}
16:10:58.285  E  ANY messagesIds IN {'a71a51aab6636692bb564ae361a727ec@mail.infomaniak.com', '1567983446.5816161.1674554415251@email.apple.com'}
16:10:58.286  E  ANY messagesIds IN {'e5a5fc0560f1ca1fda8bb2ee5b43249c@mail.infomaniak.com'}
16:10:58.287  E  ANY messagesIds IN {'a5c1029a70c135a53dd86e86591c3144@mail.infomaniak.com'}
16:10:58.288  E  ANY messagesIds IN {'978410386461f5e0fb6994adf888f331@mail.infomaniak.com', '1567983446.5816161.1674554415251@email.apple.com', 'a71a51aab6636692bb564ae361a727ec@mail.infomaniak.com', 'bf55dc51f358e89a3a8639a05e93c85b@mail.infomaniak.com'}
16:10:58.289  E  ANY messagesIds IN {'d1ceec202c9ae628061a3d24279d3f8f@mail.infomaniak.com', '1567983446.5816161.1674554415251@email.apple.com', 'a71a51aab6636692bb564ae361a727ec@mail.infomaniak.com', 'bf55dc51f358e89a3a8639a05e93c85b@mail.infomaniak.com', '978410386461f5e0fb6994adf888f331@mail.infomaniak.com', 'A58E76F0-F1AE-4657-8571-B4F3C1611623@infomaniak.com'}
16:10:58.291  E  ANY messagesIds IN {'1356950-6cd67f96-f834-493d-92b1-ba5b41dde09d@apple.com', '202301261445.30QEj8Q8011235@mr47p01nt-wwdrlapp002.ise.apple.com'}
16:10:58.292  E  ANY messagesIds IN {'3461ABD9-4281-4EE6-8A11-0DE22C7F457F@infomaniak.com'}
16:10:58.292  E  ANY messagesIds IN {'12a21455585b503f00a950224fdb85c8@mail.infomaniak.com'}
16:10:58.293  E  ANY messagesIds IN {'115FD8C7-46EA-4F12-B3A3-3999266E56BA@infomaniak.com'}
16:10:58.294  E  ANY messagesIds IN {'E194DBD6-986F-4DF3-A6C7-8964EDCD1D45@infomaniak.com'}
16:10:58.295  E  ANY messagesIds IN {'77133666-8EC2-40F0-9B31-5CA041E76F9F@infomaniak.com'}
16:10:58.295  E  ANY messagesIds IN {'135DC2D6-B413-4DA5-94DA-AC38A549238A@infomaniak.com'}
16:10:58.296  E  ANY messagesIds IN {'9BD65C61-F864-4619-86E7-7BF869C173D4@infomaniak.com', '115FD8C7-46EA-4F12-B3A3-3999266E56BA@infomaniak.com', '3A6FEEE4-15F5-4BBD-A70F-F865A19A21F2@infomaniak.com'}
16:10:58.298  E  ANY messagesIds IN {'153f22d0-5990-e0ae-4b62-52d400757bef@infomaniak.com', '351662D5-707B-4880-A46E-30476CA21954@infomaniak.com', '1c5ffae2-f10d-4a5e-d693-5e7bc08b3f57@infomaniak.com'}
16:10:58.298  E  ANY messagesIds IN {'f455b57ba8709a167ae5f2068354420f@mail.infomaniak.com'}
16:10:58.300  E  ANY messagesIds IN {'0102018608c3a973-6da5d90d-d676-4606-935e-536d4b370356-000000@eu-west-1.amazonses.com'}
16:10:58.300  E  ANY messagesIds IN {'6D184455-0B4A-4425-9497-61D0B45A26A9@infomaniak.com'}
16:10:58.301  E  ANY messagesIds IN {'02D15697-23A1-4CFF-8796-80747F976FC1@infomaniak.com', '189C3134-6E61-47C1-9C26-4665D1DC9188@infomaniak.com'}
16:10:58.301  E  ANY messagesIds IN {'423FA3C5-0269-445B-AF78-407D0B6D808E@infomaniak.com'}
16:10:58.302  E  ANY messagesIds IN {'A4E807C0-77C1-428A-84DB-8CBC01070B12@infomaniak.com'}
16:10:58.303  E  ANY messagesIds IN {'56A21790-FC37-494F-BA91-BE2E314246F5@infomaniak.com'}
16:10:58.303  E  ANY messagesIds IN {'9FB6CB57-BD77-4345-B90A-C1F112BA79F6@infomaniak.com'}
16:10:58.304  E  ANY messagesIds IN {'1FCF4A9C-B232-41BF-B996-313667D3EA0E@infomaniak.com'}
16:10:58.304  E  ANY messagesIds IN {'010201860c89cc45-d38d2ce2-12b4-4527-8b47-14b132ac933a-000000@eu-west-1.amazonses.com'}
16:10:58.305  E  ANY messagesIds IN {'6D3B209B-BD8B-48A6-866A-1C4A8D719CBC@infomaniak.com'}
16:10:58.467  E  ANY messagesIds IN {'49fc34878c17e919cd358890fcb1de6e@mail.infomaniak.com', 'FB03D5AD-6015-4077-9BD3-40868B67CFAB@infomaniak.com', '4E2BC42C-2C72-4A84-92FF-7ECFF6455468@infomaniak.com', 'B180F48A-3A95-4646-9049-96779A7A7B12@infomaniak.com', '886B7A97-E0CA-4BBB-84C6-03F1C4490DE6@infomaniak.com', '086D0F3E-4004-4E89-927E-B8B342C1E339@infomaniak.com', '2D80AD93-72AE-401B-893D-A2BFB5F6875A@infomaniak.com'}
16:10:58.468  E  ANY messagesIds IN {'LNwj3oZJIO23lQb3H3bqyg0BA0iUKoPM6clZptGag@www.droidcon.com'}
16:10:58.468  E  ANY messagesIds IN {'5c8feb39006da369066807a0e16bb37d@mail.infomaniak.com'}
16:10:58.469  E  ANY messagesIds IN {'8B015F92-AD6D-4AC1-AB63-69945E1CDCC6@gmail.com', '6D15FD0C-3503-49AC-9957-0049C4B30816@infomaniak.com'}
16:10:58.470  E  ANY messagesIds IN {'8B015F92-AD6D-4AC1-AB63-69945E1CDCC6@gmail.com', '6D15FD0C-3503-49AC-9957-0049C4B30816@infomaniak.com'}
16:10:58.472  E  ANY messagesIds IN {'ade990997d7229c9f37eab600e3e554a@mail.infomaniak.com'}
16:10:58.473  E  ANY messagesIds IN {'A34776CF-26E4-4725-A277-8753DC54EA6B@infomaniak.com'}
16:10:58.474  E  ANY messagesIds IN {'1673002807291_160770_29537_4380.sc-10_9_179_197-inbound0@mail.oscs1024.com'}
16:10:58.475  E  ANY messagesIds IN {'49CFC283-AB9A-4D90-9165-77AA2ADC2F26@infomaniak.ch', 'D04F80E1-B6FA-4989-9A3C-B0829ED20B90@infomaniak.com'}
16:10:58.475  E  ANY messagesIds IN {'A87AB859-9881-413C-90D3-69DDCADD360A@infomaniak.com'}
16:10:58.476  E  ANY messagesIds IN {'7qYTpybZS-OoSfVatLJnzQ@geopod-ismtpd-6-2'}
16:10:58.477  E  ANY messagesIds IN {'1753901d9226a$17f2b4c0$47d81e40$@acropole-paris-hotel.com', 'B211FB03-A501-4056-8A8A-EED7BB1AB0E5@infomaniak.com'}
16:10:58.477  E  ANY messagesIds IN {'OtNwVZYgJ14PFMfZcnyraeXqhTrlA5l1hKkf9lBHM@www.droidcon.com'}
16:10:58.479  E  ANY messagesIds IN {'E77963A3-1DBA-4E20-9834-C3002817351B@infomaniak.com'}
16:10:58.480  E  ANY messagesIds IN {'df093a5e1e3ab8014690cca469aefb09@mail.infomaniak.com', 'A6214C33-842F-4196-B07B-DEECB28B1F29@infomaniak.com'}
16:10:58.481  E  ANY messagesIds IN {'mid-d95efd386a393f4de03f56211de47368-1@sisglobalresearch.com'}
16:10:58.482  E  ANY messagesIds IN {'010001859b2d28cf-704950b7-8e9e-4c82-8dbb-6cdd23c34994-000000@email.amazonses.com'}
16:10:58.482  E  ANY messagesIds IN {'010001859b2d64dc-c924d248-45fe-4eea-8726-d00b5dfe3ee9-000000@email.amazonses.com'}
16:10:58.483  E  ANY messagesIds IN {'D616276A-0E1B-4CA8-A778-FF967D8F4849@infomaniak.com'}
16:10:58.484  E  ANY messagesIds IN {'b853409b22b8bc9f835a1281fc11db35@mail.infomaniak.com'}
16:10:58.484  E  ANY messagesIds IN {'230960f55dd0ec71133b717203430fe9@mail.infomaniak.com', '010001859b2d28cf-704950b7-8e9e-4c82-8dbb-6cdd23c34994-000000@email.amazonses.com', '1FE0F483-C384-4A6E-A80C-626F54B4C547@infomaniak.com'}
16:10:58.485  E  ANY messagesIds IN {'d3c0390aa8972ab990ec13d6ac65855d@mail.infomaniak.com', '010001859b2d64dc-c924d248-45fe-4eea-8726-d00b5dfe3ee9-000000@email.amazonses.com', 'F09015B8-44BE-43C6-A5C2-81FA9CC857D9@infomaniak.com'}
16:10:58.485  E  /Users/realm/workspace-realm-kotlin/releases/packages/external/core/src/realm/mixed.cpp:337: [realm-core-13.2.0] Assertion failed: false && "Compare not supported for this column type"
                 <backtrace not supported on this platform>!!! IMPORTANT: Please report this at https://github.com/realm/realm-core/issues/new/choose
16:21:14.144  A  pid: 13731, tid: 14187, name: 72-385928.realm  >>> com.infomaniak.mail <<<
16:21:14.144  A        #01 pc 000000000064225c  /data/app/~~oGBPyYbJ7QP8MKsBi6cd0A==/com.infomaniak.mail-Hf_SLtdDhoazC2PCpzezpA==/base.apk!librealmc.so (BuildId: e84dcf1724c85d91beeb32fe855ef4142d673de9)
16:21:14.144  A        #02 pc 00000000006424d4  /data/app/~~oGBPyYbJ7QP8MKsBi6cd0A==/com.infomaniak.mail-Hf_SLtdDhoazC2PCpzezpA==/base.apk!librealmc.so (BuildId: e84dcf1724c85d91beeb32fe855ef4142d673de9)
16:21:14.144  A        #03 pc 000000000064239c  /data/app/~~oGBPyYbJ7QP8MKsBi6cd0A==/com.infomaniak.mail-Hf_SLtdDhoazC2PCpzezpA==/base.apk!librealmc.so (BuildId: e84dcf1724c85d91beeb32fe855ef4142d673de9)
16:21:14.144  A        #04 pc 00000000005d0138  /data/app/~~oGBPyYbJ7QP8MKsBi6cd0A==/com.infomaniak.mail-Hf_SLtdDhoazC2PCpzezpA==/base.apk!librealmc.so (BuildId: e84dcf1724c85d91beeb32fe855ef4142d673de9)
16:21:14.144  A        #05 pc 0000000000446e8c  /data/app/~~oGBPyYbJ7QP8MKsBi6cd0A==/com.infomaniak.mail-Hf_SLtdDhoazC2PCpzezpA==/base.apk!librealmc.so (BuildId: e84dcf1724c85d91beeb32fe855ef4142d673de9)
16:21:14.144  A        #06 pc 00000000005e5ea8  /data/app/~~oGBPyYbJ7QP8MKsBi6cd0A==/com.infomaniak.mail-Hf_SLtdDhoazC2PCpzezpA==/base.apk!librealmc.so (BuildId: e84dcf1724c85d91beeb32fe855ef4142d673de9)
16:21:14.144  A        #07 pc 00000000005e5c80  /data/app/~~oGBPyYbJ7QP8MKsBi6cd0A==/com.infomaniak.mail-Hf_SLtdDhoazC2PCpzezpA==/base.apk!librealmc.so (BuildId: e84dcf1724c85d91beeb32fe855ef4142d673de9)
16:21:14.144  A        #08 pc 0000000000517a70  /data/app/~~oGBPyYbJ7QP8MKsBi6cd0A==/com.infomaniak.mail-Hf_SLtdDhoazC2PCpzezpA==/base.apk!librealmc.so (BuildId: e84dcf1724c85d91beeb32fe855ef4142d673de9)
16:21:14.144  A        #09 pc 000000000051ad90  /data/app/~~oGBPyYbJ7QP8MKsBi6cd0A==/com.infomaniak.mail-Hf_SLtdDhoazC2PCpzezpA==/base.apk!librealmc.so (BuildId: e84dcf1724c85d91beeb32fe855ef4142d673de9)
16:21:14.144  A        #10 pc 0000000000570cb0  /data/app/~~oGBPyYbJ7QP8MKsBi6cd0A==/com.infomaniak.mail-Hf_SLtdDhoazC2PCpzezpA==/base.apk!librealmc.so (BuildId: e84dcf1724c85d91beeb32fe855ef4142d673de9)
16:21:14.144  A        #11 pc 0000000000519420  /data/app/~~oGBPyYbJ7QP8MKsBi6cd0A==/com.infomaniak.mail-Hf_SLtdDhoazC2PCpzezpA==/base.apk!librealmc.so (BuildId: e84dcf1724c85d91beeb32fe855ef4142d673de9)
16:21:14.144  A        #12 pc 00000000005196c8  /data/app/~~oGBPyYbJ7QP8MKsBi6cd0A==/com.infomaniak.mail-Hf_SLtdDhoazC2PCpzezpA==/base.apk!librealmc.so (BuildId: e84dcf1724c85d91beeb32fe855ef4142d673de9)
16:21:14.144  A        #13 pc 0000000000352908  /data/app/~~oGBPyYbJ7QP8MKsBi6cd0A==/com.infomaniak.mail-Hf_SLtdDhoazC2PCpzezpA==/base.apk!librealmc.so (BuildId: e84dcf1724c85d91beeb32fe855ef4142d673de9)
16:21:14.144  A        #14 pc 00000000003141e4  /data/app/~~oGBPyYbJ7QP8MKsBi6cd0A==/com.infomaniak.mail-Hf_SLtdDhoazC2PCpzezpA==/base.apk!librealmc.so (BuildId: e84dcf1724c85d91beeb32fe855ef4142d673de9)
16:21:14.144  A        #15 pc 00000000002f0b78  /data/app/~~oGBPyYbJ7QP8MKsBi6cd0A==/com.infomaniak.mail-Hf_SLtdDhoazC2PCpzezpA==/base.apk!librealmc.so (Java_io_realm_kotlin_internal_interop_realmcJNI_realm_1results_1count+80) (BuildId: e84dcf1724c85d91beeb32fe855ef4142d673de9)
16:21:14.144  A        #18 pc 00000000004c0554  [anon:dalvik-classes.dex extracted in memory from /data/app/~~oGBPyYbJ7QP8MKsBi6cd0A==/com.infomaniak.mail-Hf_SLtdDhoazC2PCpzezpA==/base.apk] (io.realm.kotlin.internal.interop.realmc.realm_results_count+0)
16:21:14.144  A        #20 pc 00000000004b6f06  [anon:dalvik-classes.dex extracted in memory from /data/app/~~oGBPyYbJ7QP8MKsBi6cd0A==/com.infomaniak.mail-Hf_SLtdDhoazC2PCpzezpA==/base.apk] (io.realm.kotlin.internal.interop.RealmInterop.realm_results_count+26)
16:21:14.144  A        #22 pc 00000000004aa2a8  [anon:dalvik-classes.dex extracted in memory from /data/app/~~oGBPyYbJ7QP8MKsBi6cd0A==/com.infomaniak.mail-Hf_SLtdDhoazC2PCpzezpA==/base.apk] (io.realm.kotlin.internal.RealmResultsImpl.getSize+8)
16:21:14.144  A        #24 pc 000000000014d480  [anon:dalvik-classes26.dex extracted in memory from /data/app/~~oGBPyYbJ7QP8MKsBi6cd0A==/com.infomaniak.mail-Hf_SLtdDhoazC2PCpzezpA==/base.apk!classes26.dex] (kotlin.collections.AbstractCollection.size+0)
JorisBodin commented 1 year ago

@clementetb @rorbech Should I reopen another issue?

rorbech commented 1 year ago

@JorisBodin No, I have just reopened this one. I am still not able to reproduce by replicating parts of your schema, some artificial test data and your failing query. Would you be able to share a realm file where you see this behavior? There might be some indicators if we can pull the schema and inspect the data. You can send it to realm-help@mongodb.com

github-actions[bot] commented 1 year ago

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.

github-actions[bot] commented 1 year ago

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.

JorisBodin commented 1 year ago

@JorisBodin No, I have just reopened this one. I am still not able to reproduce by replicating parts of your schema, some artificial test data and your failing query. Would you be able to share a realm file where you see this behavior? There might be some indicators if we can pull the schema and inspect the data. You can send it to realm-help@mongodb.com

We check to make you this, we reproduce on a confidential email address. The complexity is to create one with non-confidential data that reproduces the bug.

JorisBodin commented 1 year ago

@rorbech I sent an email to realm-help@mongodb.com

JorisBodin commented 1 year ago

Were you able to reproduce?

github-actions[bot] commented 1 year ago

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.

github-actions[bot] commented 1 year ago

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.

JorisBodin commented 1 year ago

A little bit violent this bot 😅

bmunkholm commented 1 year ago

Poor bot :-( It was bored... But it helps when removing the label for More-information-needed.

rorbech commented 1 year ago

I have managed to reproduce this. The callstack leading up to this is

E/REALM: /Users/claus.rorbech/proj/realm-kotlin/packages/external/core/src/realm/mixed.cpp:337: [realm-core-13.4.0] Assertion failed: false && "Compare not supported for this column type"
realm::Mixed::compare(const realm::Mixed &) const mixed.cpp:337
realm::operator<(const realm::Mixed &, const realm::Mixed &) mixed.hpp:225
realm::ValueBase::compare<…>(realm::ValueBase &, realm::ValueBase &, std::__ndk1::optional<…>, std::__ndk1::optional<…>) query_expression.hpp:485
realm::Compare::find_first(unsigned long, unsigned long) const query_expression.hpp:4218
realm::ExpressionNode::find_first_local(unsigned long, unsigned long) query_engine.cpp:799
realm::ParentNode::find_all_local(unsigned long, unsigned long) query_engine.cpp:154
realm::ParentNode::aggregate_local(realm::QueryStateBase *, unsigned long, unsigned long, unsigned long, realm::ArrayPayload *) query_engine.cpp:106
realm::Query::aggregate_internal(realm::ParentNode *, realm::QueryStateBase *, unsigned long, unsigned long, realm::ArrayPayload *) const query.cpp:1063
$_3::operator()(const realm::Cluster *) const query.cpp:1319
<lambda>::operator()(void *, const realm::Cluster *) const function_ref.hpp:106
<lambda>::__invoke(void *, const realm::Cluster *) function_ref.hpp:105
realm::util::FunctionRef::operator()(const realm::Cluster *) const function_ref.hpp:119
realm::ClusterTree::traverse(realm::util::FunctionRef<…>) const cluster_tree.cpp:1064
realm::Table::traverse_clusters(realm::util::FunctionRef<…>) const table.hpp:324
realm::Query::do_find_all(realm::TableView &, unsigned long) const query.cpp:1324
realm::TableView::do_sync() table_view.cpp:493
realm::Query::find_all(unsigned long) const query.cpp:1339
realm::Query::find_all(const realm::DescriptorOrdering &) const query.cpp:1434
realm::Results::ensure_up_to_date(realm::Results::EvaluateMode) results.cpp:290
realm::Results::get_any(unsigned long) results.cpp:415
realm_results_get::$_16::operator()() const query.cpp:414
realm::c_api::wrap_err<…>(realm_results_get::$_16 &&) util.hpp:14
realm_results_get(realm_results_t *, size_t, realm_value_t *) query.cpp:413
Java_io_realm_kotlin_internal_interop_realmcJNI_realm_1results_1get(JNIEnv *, jclass, jlong, jlong, jlong, jobject) realmc.cpp:9775
art_quick_generic_jni_trampoline 0x0000007936e22248
art_quick_invoke_static_stub 0x0000007936e18bec
art::ArtMethod::Invoke(art::Thread*, unsigned int*, unsigned int, art::JValue*, char const*) 0x0000007936e84228
art::interpreter::ArtInterpreterToCompiledCodeBridge(art::Thread*, art::ArtMethod*, art::ShadowFrame*, unsigned short, art::JValue*) 0x0000007936fe34b0
bool art::interpreter::DoCall<true, false>(art::ArtMethod*, art::Thread*, art::ShadowFrame&, art::Instruction const*, unsigned short, art::JValue*) 0x0000007936fdf504
void art::interpreter::ExecuteSwitchImplCpp<false, false>(art::interpreter::SwitchImplContext*) 0x0000007936e2ca0c
ExecuteSwitchImplAsm 0x0000007936e24bdc
art::interpreter::ExecuteSwitch(art::Thread*, art::CodeItemDataAccessor const&, art::ShadowFrame&, art::JValue, bool) 0x0000007936fddd04
art::interpreter::Execute(art::Thread*, art::CodeItemDataAccessor const&, art::ShadowFrame&, art::JValue, bool, bool) 0x0000007936fd60fc
artQuickToInterpreterBridge 0x000000793733b6bc
art_quick_to_interpreter_bridge 0x0000007936e2237c
<unknown> 0x000000009b7e38bc

And the values leading to the assert are

this = {const realm::Mixed *} 0xb4000079ee466e48 
 m_type = {uint32_t} 2386903032
  = {realm::Mixed::(anonymous union)} 
  int_val = {int64_t} 0
  bool_val = {bool} false
  float_val = {float} 0
  double_val = {double} 0
  string_val = {realm::StringData} 
  binary_val = {realm::BinaryData} 
  date_val = {realm::Timestamp} 
  id_val = {realm::ObjectId} 
  decimal_val = {realm::Decimal128} 
  link_val = {realm::ObjLink} 
  uuid_val = {realm::UUID} 
b = {const realm::Mixed &} 
 m_type = {uint32_t} 3
  = {realm::Mixed::(anonymous union)} 
  int_val = {int64_t} -5476376624804579088
  bool_val = {bool} true
  float_val = {float} -2.43095391E-30
  double_val = {double} -3.1865531793207977E-58
  string_val = {realm::StringData} 
  binary_val = {realm::BinaryData} 
  date_val = {realm::Timestamp} 
  id_val = {realm::ObjectId} 
  decimal_val = {realm::Decimal128} 
  link_val = {realm::ObjLink} 
  uuid_val = {realm::UUID} 
type = {realm::DataType} 
 m_type = {realm::DataType::Type} Mixed | UUID | 0x8e453fe0
realm::(anonymous namespace)::sorting_rank = {const int [19]} 
 [0] = {const int} -1
 [1] = {const int} 1
 [2] = {const int} 0
 [3] = {const int} 2
 [4] = {const int} -1
 [5] = {const int} 2
 [6] = {const int} -1
 [7] = {const int} -1
 [8] = {const int} -1
 [9] = {const int} 3
 [10] = {const int} 1
 [11] = {const int} 1
 [12] = {const int} 1
 [13] = {const int} 7
 [14] = {const int} -1
 [15] = {const int} -1
 [16] = {const int} 4
 [17] = {const int} 6
 [18] = {const int} 5

But I will need some core assistance to know what is actually going wrong.

rorbech commented 1 year ago

This is somehow related to being a query on a mutable realm. I haven't been able to pin point the exact issue, but if I traverse the messages in the reverse order then it doesn't crash. Once the threading details is initially updated and persisted then it doesn't happen anymore even though traversed in the original order. So it doesn't seem to be the actual query but some state dependant on previous updates when doing the transaction. The amount of updates done per query is quite large, so it is really difficult to see a pattern/relation. @JorisBodin Are you able to supply a smaller reproduction dataset and eliminate any of the intermediate update operations?

sirambd commented 1 year ago

This is somehow related to being a query on a mutable realm. I haven't been able to pin point the exact issue, but if I traverse the messages in the reverse order then it doesn't crash. Once the threading details is initially updated and persisted then it doesn't happen anymore even though traversed in the original order. So it doesn't seem to be the actual query but some state dependant on previous updates when doing the transaction. The amount of updates done per query is quite large, so it is really difficult to see a pattern/relation. @JorisBodin Are you able to supply a smaller reproduction dataset and eliminate any of the intermediate update operations?

@rorbech I tested it and I'm on the same analysis as you. When I do a reverse foreach it seems to work, or when I remove the updates in the loop, it also seems to work.

I also noticed that when the crash happens, it's on an object that was previously inserted in realm. Is it possible that the object is still being transacted because of all the transactions that are done in the loop, and that it is pending or in progress? And so we query it and it creates the crash?

In this case the reverse would work in our current dataset because the object that causes concern would be processed first, and the other elements have no common keys.

On the other hand a small dataset doesn't seem feasible, you need enough data to make it work, with transaction updates in the loop.

rorbech commented 1 year ago

The stack trace that I posted above shows that it is an uninitialized Mixed that is compared. I have tried various ways of importing an object an query it following the approach in the issue but cannot provoke the issue, so might be a matter of multiple updates

    @Test
    fun query_onNewLiveObject() {
        realm.writeBlocking {
            val parent = copyToRealm(RealmSetContainer())

            // Set initialized fully from unmanaged object
//            parent.objectListField.add ( RealmSetContainer().apply {  stringSetField = realmSetOf("a", "b", "c") })

            // Add object for later update
            // Either through new realm list
            parent.objectListField = realmListOf(RealmSetContainer())
            // Or by adding to existing list
//            parent.objectListField.add (RealmSetContainer())

            val first = parent.objectListField.first()

            // Set initialized by setting attributes on already managed object
            // Either as realm set
            first.stringSetField = realmSetOf("a", "b")
            // Or adding individual entries
//            first.stringSetField.add("a")
//            first.stringSetField.add("b")
//            first.stringSetField.add("c")
            // Try updating the
            first.stringSetField.remove("a")
            // Try updating object before querying
            first.stringField = "ASDF"
            val matching = query<RealmSetContainer>("ANY stringSetField IN {'a', 'b', 'c'}").find().toList()
            assertEquals(1, matching.size)
            val nonmatching = query<RealmSetContainer>("ANY stringSetField IN {'d', 'e', 'f'}").find().toList()
            assertEquals(0, nonmatching.size)
        }
    }
sirambd commented 1 year ago

@rorbech As you can see below it took several loops for it to crash, and we can observe that the line where it crashes (the last line ANY messagesIds) we find the id "reply-6651-2104272534-6345707091-1674224893-541718340@helpscout.net" that we find in the line 2023-03-07 14:42:28.481 just after an upsert in realm.

So I think that doing a test on a single case is useless, but the problem would come from upserts in the loop, followed by a realm query on an element that was previously upserted in realm.

And by the way the problem would not come from the RealmSet but even with a RealmList, I can reproduce the problem. But how is it possible that an element previously added in realm, when queried, causes the problem?

But then, it confirms that the problem would come from updates realms in the loop, but why?

Logs

2023-03-07 14:42:28.390 I start for 50 messages
2023-03-07 14:42:28.394 E ANY messagesIds IN {'98a5c61ed3872c9728bb7155976b0b8a@mail.infomaniak.com'}
2023-03-07 14:42:28.395 I Upsert new thread in realm
2023-03-07 14:42:28.396 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.396 E ANY messagesIds IN {'1669812436d11e5355c824283367ed7c8f7b2497fc@worker-69d6ccb78d-gpjzc'}
2023-03-07 14:42:28.397 I Upsert new thread in realm
2023-03-07 14:42:28.397 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.397 E ANY messagesIds IN {'CABdc5tGzJFZyANr0TtreinZBdYzRcz0haMhDe_tUWoOscz=P1Q@mail.gmail.com'}
2023-03-07 14:42:28.397 I Upsert new thread in realm
2023-03-07 14:42:28.398 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.398 E ANY messagesIds IN {'zcb.3zc6d5cae13bc599c0204dfa1f3d506d10.12f018642675bee.1664278973552@mail1.zgpm.zcsend.eu'}
2023-03-07 14:42:28.398 I Upsert new thread in realm
2023-03-07 14:42:28.399 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.399 E ANY messagesIds IN {'d95464aa7663407bf154a5da7806d30e@mail.infomaniak.com'}
2023-03-07 14:42:28.399 I Upsert new thread in realm
2023-03-07 14:42:28.401 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.401 E ANY messagesIds IN {'1bf5f8916327d8a27948d7abc6030a18@localhost.localdomain'}
2023-03-07 14:42:28.401 I Upsert new thread in realm
2023-03-07 14:42:28.402 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.402 E ANY messagesIds IN {'6356539e93c99_23ee2adeea33e408844bd@lpappvz211.mail'}
2023-03-07 14:42:28.402 I Upsert new thread in realm
2023-03-07 14:42:28.403 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.404 E ANY messagesIds IN {'c029d572b01d9f6a9ca0777f1bf601d7@mail.infomaniak.com'}
2023-03-07 14:42:28.404 I Upsert new thread in realm
2023-03-07 14:42:28.405 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.405 E ANY messagesIds IN {'2c9db50105c68c882225d3196067f0f2@mail.infomaniak.com'}
2023-03-07 14:42:28.405 I Upsert new thread in realm
2023-03-07 14:42:28.405 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.406 E ANY messagesIds IN {'121145ec39e267128cfa00d0466411da@www.urbankart-in.com'}
2023-03-07 14:42:28.406 I Upsert new thread in realm
2023-03-07 14:42:28.406 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.406 E ANY messagesIds IN {'DwYY4-U1TimcaH65y08G3g@geopod-ismtpd-6-0'}
2023-03-07 14:42:28.407 I Upsert new thread in realm
2023-03-07 14:42:28.407 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.408 E ANY messagesIds IN {'02CBD67B-0D94-2A43-BA6E-E57BACF379D9@hxcore.ol'}
2023-03-07 14:42:28.408 I Upsert new thread in realm
2023-03-07 14:42:28.408 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.408 E ANY messagesIds IN {'7xVf2W5wXwk5bnl5wZIemcyNmyDjIAWQ2vR78ZEkJie-DVwzjzj3Ea_A0NhGABeEnApPkbEw5n8HUKkbpPcg6BDCoKwb0qyi2XK-I2mtU3A=@proton.me', 'K9X98RSRFB43A4XBWJK9JBP5NR@notify.proton.me'}
2023-03-07 14:42:28.408 I Upsert new thread in realm
2023-03-07 14:42:28.409 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.409 E ANY messagesIds IN {'4MRkx45HKLzD2@mailrouter-202.lon1.prod.booking.com'}
2023-03-07 14:42:28.409 I Upsert new thread in realm
2023-03-07 14:42:28.410 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.410 E ANY messagesIds IN {'1213734517.4619823.1668010814110@email.apple.com'}
2023-03-07 14:42:28.410 I Upsert new thread in realm
2023-03-07 14:42:28.411 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.411 E ANY messagesIds IN {'4MTNft4htZzMt@mailrouter-203.lon1.prod.booking.com'}
2023-03-07 14:42:28.411 I Upsert new thread in realm
2023-03-07 14:42:28.412 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.412 E ANY messagesIds IN {'57de94d0-10c1-1833-29f0-c1e242a66ede@localise.biz', '010b01842d9691c7-790db8f9-29da-4cd7-9a35-60ff6cc62a04-000000@eu-west-2.amazonses.com', 'b4b98d9e-d2eb-b976-621a-9d0d8ac4d03b@localise.biz'}
2023-03-07 14:42:28.412 I Upsert new thread in realm
2023-03-07 14:42:28.413 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.413 E ANY messagesIds IN {'69135107-621b-4d4a-4384-986dcf75e4a1@infomaniak.com'}
2023-03-07 14:42:28.413 I Upsert new thread in realm
2023-03-07 14:42:28.413 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.414 E ANY messagesIds IN {'mid-d95efd386a393f4de03f56211de47368-1@sisglobalresearch.com'}
2023-03-07 14:42:28.414 I Upsert new thread in realm
2023-03-07 14:42:28.414 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.415 E ANY messagesIds IN {'010201837ebcd0b2-3866461e-b32b-4ca2-aeee-f4565d73263f-000000@eu-west-1.amazonses.com'}
2023-03-07 14:42:28.415 I Upsert new thread in realm
2023-03-07 14:42:28.415 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.416 E ANY messagesIds IN {'1109979388.21966578.1675177355300.JavaMail.zimbra@univ-fcomte.fr', '4fc5c9ce4c977be52fe875541738aeabe99.20230130124838@mail148.atl171.mctxapp.net', '646655837.20745839.1675083093611.JavaMail.zimbra@univ-fcomte.fr', '1920382757.21796014.1675170148073.JavaMail.zimbra@univ-fcomte.fr'}
2023-03-07 14:42:28.416 I Upsert new thread in realm
2023-03-07 14:42:28.417 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.418 E ANY messagesIds IN {'317fd414-f03f-986f-020c-e8af0cf65119@localise.biz', '010b0184e7e308fd-3520c2fe-bbf2-4f70-9b26-97e4a5cd0ced-000000@eu-west-2.amazonses.com', '4ee8bbc3-43b1-971c-29b2-89173b2efb40@localise.biz', '7197F9D1-C643-4817-84D2-8B9C8E04FA8C@infomaniak.com', 'B27E3821-BF20-47FB-B305-8975516DD886@infomaniak.com'}
2023-03-07 14:42:28.418 I Upsert new thread in realm
2023-03-07 14:42:28.419 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.424 E ANY messagesIds IN {'tGUy5xBZRkW88D8wD6TulQ@geopod-ismtpd-3-0'}
2023-03-07 14:42:28.424 I Upsert new thread in realm
2023-03-07 14:42:28.424 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.425 E ANY messagesIds IN {'A7847777-D700-47BD-9727-027880FE103C@infomaniak.com'}
2023-03-07 14:42:28.425 I Upsert new thread in realm
2023-03-07 14:42:28.425 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.426 E ANY messagesIds IN {'6360f4013e8_5d272abe43d3e9d410081c@lpappvz111.mail'}
2023-03-07 14:42:28.427 I Upsert new thread in realm
2023-03-07 14:42:28.428 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.428 E ANY messagesIds IN {'4MRkx24hP9zyTs@mailrouter-106.ams4.prod.booking.com'}
2023-03-07 14:42:28.428 I Upsert new thread in realm
2023-03-07 14:42:28.429 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.429 E ANY messagesIds IN {'c96055e6660d835f5c2d338e43dea592@etickets.infomaniak.com'}
2023-03-07 14:42:28.430 I Upsert new thread in realm
2023-03-07 14:42:28.430 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.430 E ANY messagesIds IN {'010201843347913f-48db43ca-718f-4c0f-a305-e8144ea5313f-000000@eu-west-1.amazonses.com'}
2023-03-07 14:42:28.431 I Upsert new thread in realm
2023-03-07 14:42:28.431 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.432 E ANY messagesIds IN {'366201618.50843.1666172290653@6f0543cb39e3'}
2023-03-07 14:42:28.432 I Upsert new thread in realm
2023-03-07 14:42:28.433 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.434 E ANY messagesIds IN {'f95e9f9f60d96e64e70dffac9.0c247c7d36.20221007124612.889b6b770e.e03ea474@mail112.atl231.mcsv.net'}
2023-03-07 14:42:28.434 I Upsert new thread in realm
2023-03-07 14:42:28.435 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.435 E ANY messagesIds IN {'1.0.C.29.1D9165C89414F34.0@mail29241.apostello.io'}
2023-03-07 14:42:28.436 I Upsert new thread in realm
2023-03-07 14:42:28.437 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.438 E ANY messagesIds IN {'r1x2G000000000000000000000000000000000000000000000ROXUNQ007Uz8E_dYRpOOZ4qpFVUdXg@sfdc.net'}
2023-03-07 14:42:28.438 I Upsert new thread in realm
2023-03-07 14:42:28.439 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.439 E ANY messagesIds IN {'4ee8bbc3-43b1-971c-29b2-89173b2efb40@localise.biz', '010b0184e7e308fd-3520c2fe-bbf2-4f70-9b26-97e4a5cd0ced-000000@eu-west-2.amazonses.com'}
2023-03-07 14:42:28.441 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.441 E ANY messagesIds IN {'637212a1b547f_55092b1258a48a7c938d5@lpappvz111.mail'}
2023-03-07 14:42:28.442 I Upsert new thread in realm
2023-03-07 14:42:28.443 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.444 E ANY messagesIds IN {'6332c46dae441_1e042ab3ce3804e4904bc@lpappvz111.mail'}
2023-03-07 14:42:28.444 I Upsert new thread in realm
2023-03-07 14:42:28.445 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.445 E ANY messagesIds IN {'20221217032820.928d60be000f9925@c.lusha-notice.com'}
2023-03-07 14:42:28.445 I Upsert new thread in realm
2023-03-07 14:42:28.446 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.447 E ANY messagesIds IN {'88353a57-4473-ccd5-4d42-c6536c4feeb5@localise.biz', '010b0184e7e308fd-3520c2fe-bbf2-4f70-9b26-97e4a5cd0ced-000000@eu-west-2.amazonses.com', '4ee8bbc3-43b1-971c-29b2-89173b2efb40@localise.biz', '7197F9D1-C643-4817-84D2-8B9C8E04FA8C@infomaniak.com', 'B27E3821-BF20-47FB-B305-8975516DD886@infomaniak.com', '317fd414-f03f-986f-020c-e8af0cf65119@localise.biz', '837B169E-6656-4E86-B9FE-1A941209D057@infomaniak.com'}
2023-03-07 14:42:28.449 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.449 E ANY messagesIds IN {'1673002807291_160770_29537_4380.sc-10_9_179_197-inbound0@mail.oscs1024.com'}
2023-03-07 14:42:28.450 I Upsert new thread in realm
2023-03-07 14:42:28.451 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.452 E ANY messagesIds IN {'699ab4d65d4e637887b7334acd5ca786@mail.infomaniak.com'}
2023-03-07 14:42:28.452 I Upsert new thread in realm
2023-03-07 14:42:28.453 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.454 E ANY messagesIds IN {'0102018379477b93-8a1456eb-ec74-424d-baba-a8bd9d57f377-000000@eu-west-1.amazonses.com'}
2023-03-07 14:42:28.454 I Upsert new thread in realm
2023-03-07 14:42:28.454 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.456 E ANY messagesIds IN {'reply-6651-1961377505-5930710460-1662119040-1080571732@helpscout.net', '542CC4EF-4285-412D-9DFC-C46853CCF0D3@infomaniak.com', 'reply-6651-1961377505-5858379191-1660218014-2059419613@helpscout.net'}
2023-03-07 14:42:28.456 I Upsert new thread in realm
2023-03-07 14:42:28.458 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.459 E ANY messagesIds IN {'67edae729a806c336a76467e87afaeba@mail.infomaniak.com', '0ACFC67F-BD9A-4C06-AC88-3A5AA5BD0BA1@infomaniak.com', '7753C10E-2C56-46F2-BED6-2B77542E0A5A@infomaniak.com'}
2023-03-07 14:42:28.459 I Upsert new thread in realm
2023-03-07 14:42:28.460 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.461 E ANY messagesIds IN {'reply-6651-1961377505-5931807824-1662137402-902426052@helpscout.net', '2a92ec8b932d767be9c2728c511cab15@mail.infomaniak.com', 'reply-6651-1961377505-5930710460-1662119040-1080571732@helpscout.net'}
2023-03-07 14:42:28.463 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.464 E ANY messagesIds IN {'2a92ec8b932d767be9c2728c511cab15@mail.infomaniak.com', '542CC4EF-4285-412D-9DFC-C46853CCF0D3@infomaniak.com', 'reply-6651-1961377505-5858379191-1660218014-2059419613@helpscout.net', 'reply-6651-1961377505-5930710460-1662119040-1080571732@helpscout.net'}
2023-03-07 14:42:28.466 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.468 E ANY messagesIds IN {'reply-6651-1961377505-5858379191-1660218014-2059419613@helpscout.net', '11488F3F-7755-460E-819D-CFFB9E2F6037@infomaniak.com', 'reply-6651-1961377505-5858027894-1660207882-1271696797@helpscout.net'}
2023-03-07 14:42:28.470 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.471 E ANY messagesIds IN {'reply-6651-1961377505-5858027894-1660207882-1271696797@helpscout.net', '0C4AC08C-E837-4A72-A00D-B85314BD13F8@infomaniak.com', 'reply-6651-1961377505-5855635254-1660144709-661772268@helpscout.net'}
2023-03-07 14:42:28.473 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.474 E ANY messagesIds IN {'reply-6651-1961377505-5855635254-1660144709-661772268@helpscout.net', '0ACFC67F-BD9A-4C06-AC88-3A5AA5BD0BA1@infomaniak.com'}
2023-03-07 14:42:28.480 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.481 E ANY messagesIds IN {'reply-6651-2104272534-6345707091-1674224893-541718340@helpscout.net', 'CA1BC2D1-8EAC-4C8D-BBB7-6C416819D135@infomaniak.com', 'reply-6651-2104272534-6259478842-1671640333-618132964@helpscout.net'}
2023-03-07 14:42:28.481 I Upsert new thread in realm
2023-03-07 14:42:28.483 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.484 E ANY messagesIds IN {'reply-6651-2104272534-6259478842-1671640333-618132964@helpscout.net', 'DC5AA57B-52C0-49E3-A289-C416BE1CA9FB@infomaniak.com'}
2023-03-07 14:42:28.486 E message added in the thread and thread has been upsert with success
2023-03-07 14:42:28.488 E ANY messagesIds IN {'reply-6651-2104272534-6352444191-1674487646-1324560410@helpscout.net', '81C44744-6494-40A3-8040-FD8DAB1A73E8@infomaniak.com', 'reply-6651-2104272534-6345707091-1674224893-541718340@helpscout.net'}
2023-03-07 14:42:28.492 Users/realm/workspace-realm-kotlin/releases/packages/external/core/src/realm/mixed.cpp:337: [realm-core-13.2.0] Assertion failed: false && "Compare not supported for this column type"
                                                                                                    <backtrace not supported on this platform>!!! IMPORTANT: Please report this at https://github.com/realm/realm-core/issues/new/choose
2023-03-07 14:42:28.922 Fatal signal 6 (SIGABRT), code -1 (SI_QUEUE) in tid 11725 (0-1392461.realm), pid 14:42:29.127 app_time_stats: avg=21.48ms min=1.42ms max=155.98ms count=46
2023-03-07 14:42:29.341 11879-11879 DEBUG                   pid-11879                            A  Cmdline: com.infomaniak.mail
rorbech commented 1 year ago

Awaiting merge of the fix in core https://github.com/realm/realm-core/pull/6545