Skip to content

Create Index not working in documentdb-local #218

Closed
@xgerman

Description

@xgerman

Describe the bug

[direct: mongos] test> db.restaurants.insertMany( [
...    { _id: 1, category: "café", status: "Open" },
...    { _id: 2, category: "cafe", status: "open" },
...    { _id: 3, category: "cafE", status: "open" }
... ] )
{ acknowledged: true, insertedIds: { '0': 1, '1': 2, '2': 3 } }
[direct: mongos] test> db.restaurants.createIndex( { category: 1 } )
...
In the logs we find:

2025-06-13T15:55:03.954Z INFO [tokio_postgres::connection] NOTICE: creating collection


Postgres logs:
...
2025-06-13 15:55:03.954 UTC [115] LOG:  Creating and returning documentdb_data.documents_1 for the sentinel database test
2025-06-13 15:55:03.954 UTC [115] CONTEXT:  SQL statement "SELECT documentdb_api.create_collection($1, $2)"
2025-06-13 15:55:03.954 UTC [115] STATEMENT:  SELECT * FROM documentdb_api.insert($1, $2, $3, NULL)
2025-06-13 15:56:00.001 UTC [74] LOG:  cron job 1 starting: CALL documentdb_api_internal.delete_expired_rows();
2025-06-13 15:56:00.006 UTC [74] LOG:  cron job 1 COMMAND completed: CALL
2025-06-13 15:57:00.005 UTC [74] LOG:  cron job 1 starting: CALL documentdb_api_internal.delete_expired_rows();
2025-06-13 15:57:00.010 UTC [74] LOG:  cron job 1 COMMAND completed: CALL
2025-06-13 15:58:00.001 UTC [74] LOG:  cron job 1 starting: CALL documentdb_api_internal.delete_expired_rows();
2025-06-13 15:58:00.004 UTC [74] LOG:  cron job 1 COMMAND completed: CALL

Environment
documentdb-local latest

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't workingdocumentdb-localfor documentdb-local related issuesgatewayfor gateway related issues

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions