Skip to content

Unable to create case insensitive email index #6465

Closed
@mtrezza

Description

@mtrezza

Issue Description

Upgrading to parse server 3.10.0 to 4.1.0 fails with this error message:

warn: Unable to create case insensitive email index: WiredTigerIndex::insert: key too large to index, failing 1157 { ... }

The indices on username and email both fail to create with the same error message.

  • Issue seems related to fix Case insensitive signup #5634
  • Issue occurs with parse sever 4.1.0 on mongoDB 3.6.17
  • Issue does not occur with parse server 3.10.0 on mongoDB 4.2

Steps to reproduce

Expected Results

Indices should create.

Actual Outcome

Indices fail to create.

Environment Setup

  • Server

    • parse-server version (Be specific! Don't say 'latest'.) : 4.1.0
    • Localhost or remote server? (AWS, Heroku, Azure, Digital Ocean, etc): AWS
  • Database

    • MongoDB version: 3.6.17
    • Storage engine: WT
    • Localhost or remote server? (AWS, mLab, ObjectRocket, Digital Ocean, etc): AWS

Logs/Trace

mongoDB log:

2020-03-05T01:03:07.605+0000 I COMMAND [conn356038] command my-database.$cmd command: createIndexes { createIndexes: "_User", indexes: [ { name: "case_insensitive_username", key: { username: 1 }, background: true, sparse: true, collation: { locale: "en_US", strength: 2 } } ], writeConcern: { w: "majority" }, lsid: { id: UUID("xxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx") }, $clusterTime: { clusterTime: Timestamp(1583370186, 29), signature: { hash: BinData(0, 123456789), keyId: 123456789 } }, $db: "my-database" } exception: WiredTigerIndex::insert: key too large to index, failing 1157 { : "..." } code:KeyTooLong numYields:574 reslen:419 locks:{ Global: { acquireCount: { r: 576, w: 576 } }, Database: { acquireCount: { w: 577, W: 2 }, acquireWaitCount: { W: 2 }, timeAcquiringMicros: { W: 16745 } }, Collection: { acquireCount: { w: 576 } } } protocol:op_msg 1475ms

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions