Description
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