Why so slow in dashboard?

badboy_tian · December 22, 2023, 12:38am

111Untitled
why very slow?
schema

export const AVFile = {
    className: "AVFile",
    fields: {
        mime_type: {type: "String"},
        key: {type: "String"},
        name: {type: "String"},
        provider: {type: "String"},
        owner: {type: "String"},
        size: {type: "Number"},
        url: {type: "String"},
    },
    indexes: {
        _AVFile_ownerIndex: {owner: 1},
    },
    classLevelPermissions: {
        find: {},
        count: {},
        get: {},
        update: {},
        create: {},
        delete: {},
        protectedFields: {},
    },
}

badboy_tian · December 22, 2023, 2:14am

indexes: {
        _AVFile_ownerIndex: {owner: 1},
        _AVFile_createdAtIndex: {_created_at: 1},
        _AVFile_updatedAtIndex: {_updated_at: 1},
        _AVFile_objectId: {objectId: 1},
    },

 Failed to run migrations: Error during update of schema for type AVFile: ParseError: 102 Field _created_at does not exist, cannot add index.

I use parse server 6.4.0 parse-dashboard 5.3.0

badboy_tian · December 22, 2023, 2:35am

github.com/parse-community/parse-dashboard

can not create index

opened 02:18AM - 22 Dec 23 UTC

badboy-tian

### New Issue Checklist  - [ ] I am not disclosing a [vulnerability](https://github.com/parse-community/parse-server/blob/master/SECURITY.md). - [ ] I am not just asking a [question](https://github.com/parse-community/.github/blob/master/SUPPORT.md). - [x] I have searched through [existing issues](https://github.com/parse-community/parse-dashboard/issues?q=is%3Aissue). - [ ] I can reproduce the issue with the latest versions of [Parse Server](https://github.com/parse-community/parse-server/releases) and [Parse Dashboard](https://github.com/parse-community/parse-dashboard/releases). ### Issue Description can create _created_at index ### Steps to reproduce ``` export const AVFile = { className: "AVFile", fields: { mime_type: {type: "String"}, key: {type: "String"}, name: {type: "String"}, provider: {type: "String"}, owner: {type: "String"}, size: {type: "Number"}, url: {type: "String"}, objectId: {type: "String"}, }, indexes: { _AVFile_ownerIndex: {owner: 1}, _AVFile_createdAtIndex: {_created_at: 1}, _AVFile_updatedAtIndex: {_updated_at: 1}, _AVFile_objectId: {objectId: 1}, }, classLevelPermissions: { find: {}, count: {}, get: {}, update: {}, create: {}, delete: {}, protectedFields: {}, }, } ``` ### Actual Outcome ``` error: Failed to run migrations: Error during update of schema for type AVFile: ParseError: 102 Field _created_at does not exist, cannot add index ``` ### Expected Outcome success ### Environment Dashboard - Parse Dashboard version: `5.3.0` - Browser (Safari, Chrome, Firefox, Edge, etc.): `chrome` - Browser version: `120.0.6099.109` Server - Parse Server version: `6.4.0` - Operating system: `mac os` - Local or remote host (AWS, Azure, Google Cloud, Heroku, Digital Ocean, etc): `Local` Database - System (MongoDB or Postgres): `MongoDB` - Database version: `7.0` - Local or remote host (MongoDB Atlas, mLab, AWS, Azure, Google Cloud, etc): `Local` ### Logs  ``` 10:12:07 AM - Found 0 errors. Watching for file changes. [TS] DATABASE_URI not specified, falling back to localhost. [TS] databaseUri: mongodb://localhost:27017/dev [TS] redisUri not specified, falling back to localhost. [TS] redisUri: redis://localhost:6379 [TS] warn: DeprecationWarning: The Parse Server option 'allowExpiredAuthDataToken' default will change to 'false' in a future version. [TS] warn: DeprecationWarning: The Parse Server option 'encodeParseObjectInCloudFunction' default will change to 'true' in a future version. [TS] app: 3.186s [TS] Node app is running on port: 1337 [TS] info: Running Migrations [TS] error: Failed to run migrations: Error during update of schema for type AVFile: ParseError: 102 Field _created_at does not exist, cannot add index. [TS] info: Running Migrations Completed ```

badboy_tian · December 25, 2023, 2:10am

export const AVFile = {
    className: "AVFile",
    fields: {
        mime_type: {type: "String"},
        key: {type: "String"},
        name: {type: "String"},
        provider: {type: "String"},
        owner: {type: "String"},
        size: {type: "Number"},
        url: {type: "String"},
    },
    indexes: {
        AVFile_ownerIndex: {owner: 1},
        AVFile_createdAtIndex: {_created_at: 1},
        AVFile_updatedAtIndex: {_updated_at: 1},
    },
    classLevelPermissions: {
        find: {},
        count: {},
        get: {},
        update: {},
        create: {},
        delete: {},
        protectedFields: {},
    },
}

[TS] error: Failed to run migrations: Error during update of schema for type AVFile: ParseError: 102 Field _created_at does not exist, cannot add index.

why cannot create index of _created_at ?

badboy_tian · December 25, 2023, 2:11am

@ Manuel

rgunindi · December 26, 2023, 1:02pm

Error says:

Field _created_at does not exist

Are you sure this field exist?

badboy_tian · December 26, 2023, 2:43pm

I am sure. ervery object has _created_at, _updated_at, _id

rgunindi · December 26, 2023, 7:23pm

What is your migration code

badboy_tian · December 27, 2023, 12:17am

export const AVFile = {
    className: "AVFile",
    fields: {
        mime_type: {type: "String"},
        key: {type: "String"},
        name: {type: "String"},
        provider: {type: "String"},
        owner: {type: "String"},
        size: {type: "Number"},
        url: {type: "String"},
    },
    indexes: {
        AVFile_ownerIndex: {owner: 1},
        AVFile_createdAtIndex: {_created_at: 1},
        AVFile_updatedAtIndex: {_updated_at: 1},
    },
    classLevelPermissions: {
        find: {},
        count: {},
        get: {},
        update: {},
        create: {},
        delete: {},
        protectedFields: {},
    },
}

schema: {
        definitions: [AVFile],
        lockSchemas: false,
        strict: true,
        recreateModifiedFields: true,
        deleteExtraFields: true,
    },
    verbose: false,

rgunindi · December 27, 2023, 12:21am

This is a json not a code

badboy_tian · December 27, 2023, 1:22am

I follow this website

rgunindi · December 27, 2023, 1:43pm

Can you try this

AVFile_createdAtIndex: {createdAt: 1}

createdAt:‘date’

badboy_tian · December 27, 2023, 2:08pm

AVFile_createdAtIndex: { createdAt: 1},
use this can work

[TS] Node app is running on port: 1337
[TS] info: Running Migrations
[TS] info: Running Migrations Completed

but in mongodb, there is no createdAt filed in it

rgunindi · December 27, 2023, 2:25pm

Then connect direct the Db and run this code

db.getCollection('AVFile').CreateIndex({_created_at:1})

badboy_tian · December 27, 2023, 2:39pm

Yes, that’s work fine. I meant to create the _created_at index when defining the schema in the code.

rgunindi · December 27, 2023, 2:54pm

I think the first one you should delete the AVFile Schema and after you should run the migration code, did you try?

badboy_tian · December 28, 2023, 9:26am

I have try, but not work. mybe clear all data of db first ?

rgunindi · December 28, 2023, 10:15am

Which one didnt work _created_ad ?