Dexie.js RxStorage: find() and findOne() with a selector always returns empty or null respectively

[mmgfrcs]

Setup

My app is storing their data using RxDB using the Dexie.js storage adapter. The (reduced) setup is as follows:

import { getRxStorageDexie } from 'rxdb/plugins/storage-dexie';
import { addRxPlugin } from 'rxdb/plugins/core';
import { RxDBDevModePlugin } from 'rxdb/plugins/dev-mode';
import { wrappedValidateAjvStorage } from 'rxdb/plugins/validate-ajv';
import { createRxDatabase } from 'rxdb/plugins/core';
import { RxDBCleanupPlugin } from 'rxdb/plugins/cleanup';
import { RxDBLeaderElectionPlugin } from 'rxdb/plugins/leader-election'

let storage = wrappedValidateAjvStorage({ storage: getRxStorageDexie() });
addRxPlugin(RxDBDevModePlugin);
addRxPlugin(RxDBCleanupPlugin);
addRxPlugin(RxDBLeaderElectionPlugin);

const db = await createRxDatabase({
  name: 'assetTracker',
  storage: storage
});

await db.addCollections({
  // name of the collection
  assets: {
    localDocuments: true,
    // we use the JSON-schema standard
    schema: {
      version: 0,
      primaryKey: 'id',
      type: 'object',
      properties: {
        id: {
          type: 'string',
          maxLength: 100 // <- the primary key must have maxLength
        },
        value: {
          type: 'string',
        }
      },
      required: ['id', 'value']
    }
  }
});

Everything works well, I inserted some data as follows, and I can see them in the browser devtools

const assetMod = import.meta.glob<ImageMetadata>("/src/assets/**/*.webp", {import: "default"})

for(let assetPth in assetMod) {
    await db.assets.insert({id: assetPth, value: (await assetMod[assetPth]()).src})
}

Calling db.assets.find().exec() finds all of them successfully.

Problem

However, when I wanted to filter them with db.assets.findOne(iid).exec(), where iid is an id that exists, it returns null. Calling db.assets.find(iid).exec() also fails to return any results, resulting in an empty array ([])

Calling the following also returns null

1. db.assets.findOne({selector: {id: iid}}).exec()
2. db.assets.findOne({selector: {id: {$eq: iid}}}).exec()

And the same for the find version of the above, returning empty array.

Investigation

My bug-fixing session led me to a discovery. I tried to query a non-existent field it and it returns the raw query as follows:

query: {
  "selector": {
    "it": {
      "$eq": "101.webp"
    },
    "_deleted": {
      "$eq": false
    }
  },
  "limit": 1,
  "skip": 0,
  "sort": [
    {
      "_deleted": "asc"
    },
    {
      "id": "asc"
    }
  ]
}

find() and findOne() tries to find data that is not deleted, where _deleted = false, as the query states. However, in the db, _deleted is a string value of "0"

[pubkey]

Could not reproduce this: #9062

[mmgfrcs]

Narrowed it down to the cleanup function

The reproduction is as follows. Run it in a browser context (using e.g Vite)

import { getRxStorageDexie } from 'rxdb/plugins/storage-dexie';
import { addRxPlugin } from 'rxdb/plugins/core';
import { RxDBDevModePlugin } from 'rxdb/plugins/dev-mode';
import { wrappedValidateAjvStorage } from 'rxdb/plugins/validate-ajv';
import { createRxDatabase } from 'rxdb/plugins/core';
import { RxDBCleanupPlugin } from 'rxdb/plugins/cleanup';
import { RxDBLeaderElectionPlugin } from 'rxdb/plugins/leader-election'

let storage = wrappedValidateAjvStorage({ storage: getRxStorageDexie() });
addRxPlugin(RxDBDevModePlugin);
addRxPlugin(RxDBCleanupPlugin);
addRxPlugin(RxDBLeaderElectionPlugin);

const db = await createRxDatabase({
  name: 'assets-tracker',
  storage: storage
});

await db.addCollections({
  // name of the collection
  assets: {
    localDocuments: true,
    // we use the JSON-schema standard
    schema: {
      version: 0,
      primaryKey: 'id',
      type: 'object',
      properties: {
        id: {
          type: 'string',
          maxLength: 100
        },
        value: {
          type: 'string',
        }
      },
      required: ['id', 'value']
    }
  }
});

await db.assets.find().remove()
await db.assets.cleanup(0);

await db.assets.insert({id: "234", value: "456"})

console.log(await db.assets.findOne("234").exec())

Run it at least twice

• The first run prints correctly
• The second run and afterwards prints null but the inserted object exists on IndexedDB as it should

[pubkey]

cant reproduce, please make a PR with a test case #9062

[mmgfrcs]

Will do

The most annoying thing is that I can't seem to replicate it in the test but I can replicate it in the browser console itself

[mmgfrcs]

It seems to happen only on Vite-based sites (Sveltekit, Astro, etc)

Can't replicate on the unit test since I need Vite. Should I add Vite to the test or something?