We have an ‘Author’ option in our “gallery_articles” model. And when trying to select it from the admin UI, we get the following error:
error error: select "components_sections_blocks".* from "components_sections_blocks" where "id" in ($1, $2, $3,........and so on......$80194, $80195, $80196, $80197, $80198, $80199, $80200, $80201, $80202, $80203, $80204, $80205, $80206, $80207, $80208, $80209, $80210, $80211, $80212, $80213, $80214, $80215, $80216, $80217, $80218, $80219, $80220) - bind message has 14684 parameter formats but 0 parameters
Here is a “gallery_articles” model where ‘Author’ (“authorName”) field is used:
{
"kind": "collectionType",
"collectionName": "gallery_articles",
"info": {
"name": "Gallery Article",
"description": ""
},
"options": {
"increments": true,
"timestamps": true,
"draftAndPublish": true
},
"pluginOptions": {},
"attributes": {
"title": {
"pluginOptions": {},
"type": "string",
"required": true
},
"authorName": {
"model": "writer",
"via": "gallery_articles"
},
"articleDate": {
"pluginOptions": {},
"type": "date"
},
"imageCredit": {
"pluginOptions": {},
"type": "string"
},
"imageCreditUrl": {
"pluginOptions": {},
"type": "string"
},
"nextArticleId": {
"pluginOptions": {},
"type": "string"
},
"notes": {
"pluginOptions": {},
"type": "richtext"
},
"blocks": {
"type": "component",
"repeatable": true,
"pluginOptions": {},
"component": "sections.blocks"
},
"codeName": {
"pluginOptions": {},
"type": "string",
"maxLength": 5,
"minLength": 5
},
"languageCode": {
"pluginOptions": {},
"type": "string",
"maxLength": 2,
"minLength": 2
},
"version": {
"type": "string",
"required": false,
"maxLength": 3,
"minLength": 3
},
"originalSite": {
"model": "sites",
"via": "gallery_articles"
},
"articleSource": {
"type": "enumeration",
"enum": ["Source", "Inspired", "Original", "NMI"]
},
"idea": {
"type": "enumeration",
"enum": ["B2C", "Content", "B2B", "Native", "NMI"]
},
"category": {
"type": "enumeration",
"enum": ["Gallery", "Story", "Search"]
},
"extensionPossibility": {
"type": "boolean"
},
"extensionDone": {
"type": "boolean"
},
"subCategory": {
"type": "component",
"repeatable": true,
"component": "sections.sub-category"
},
"cover_image": {
"model": "file",
"via": "related",
"allowedTypes": ["images"],
"plugin": "upload",
"required": false,
"pluginOptions": {}
},
"shinezId": {
"type": "string",
"unique": true
}
}
}
And ‘Author’ model:
{
"kind": "collectionType",
"collectionName": "writers",
"info": {
"name": "Writer"
},
"options": {
"increments": true,
"timestamps": true
},
"attributes": {
"name": {
"type": "string"
},
"picture": {
"model": "file",
"via": "related",
"allowedTypes": ["images"],
"plugin": "upload",
"required": false
},
"email": {
"type": "string"
},
"gallery_articles": {
"via": "authorName",
"collection": "gallery-article"
}
}
}
Here is an endpoint where request sent:
/content-manager/relations/application::gallery-article.gallery-article/authorName?_limit=20
Response is: {“statusCode”:500,“error”:“Internal Server Error”,“message”:“An internal server error occurred”}
Whole stacktrace:
error error: select "components_sections_blocks".* from "components_sections_blocks" where "id" in ($1, $2, $3,........and so on......$80194, $80195, $80196, $80197, $80198, $80199, $80200, $80201, $80202, $80203, $80204, $80205, $80206, $80207, $80208, $80209, $80210, $80211, $80212, $80213, $80214, $80215, $80216, $80217, $80218, $80219, $80220) - bind message has 14685 parameter formats but 0 parameters
at Parser.parseErrorMessage (/home/user/Projects/shinez/shinez-strapi/node_modules/pg-protocol/dist/parser.js:287:98)
at Parser.handlePacket (/home/user/Projects/shinez/shinez-strapi/node_modules/pg-protocol/dist/parser.js:126:29)
at Parser.parse (/home/user/Projects/shinez/shinez-strapi/node_modules/pg-protocol/dist/parser.js:39:38)
at Socket.<anonymous> (/home/user/Projects/shinez/shinez-strapi/node_modules/pg-protocol/dist/index.js:11:42)
at Socket.emit (node:events:394:28)
at Socket.emit (node:domain:475:12)
at addChunk (node:internal/streams/readable:315:12)
at readableAddChunk (node:internal/streams/readable:289:9)
at Socket.Readable.push (node:internal/streams/readable:228:10)
at TCP.onStreamRead (node:internal/stream_base_commons:199:23)
at TCP.callbackTrampoline (node:internal/async_hooks:130:17)
From previous event:
at processImmediate (node:internal/timers:464:21)
at process.topLevelDomainCallback (node:domain:152:15)
at process.callbackTrampoline (node:internal/async_hooks:128:24)
From previous event:
at Sync.<anonymous> (/home/user/Projects/shinez/shinez-strapi/node_modules/bookshelf/lib/sync.js:204:8)
From previous event:
at /home/user/Projects/shinez/shinez-strapi/node_modules/bookshelf/lib/eager.js:64:12
at /home/user/Projects/shinez/shinez-strapi/node_modules/lodash/lodash.js:3585:27
at /home/user/Projects/shinez/shinez-strapi/node_modules/lodash/lodash.js:4967:15
at baseForOwn (/home/user/Projects/shinez/shinez-strapi/node_modules/lodash/lodash.js:3032:24)
at /home/user/Projects/shinez/shinez-strapi/node_modules/lodash/lodash.js:4936:18
at baseMap (/home/user/Projects/shinez/shinez-strapi/node_modules/lodash/lodash.js:3584:7)
at Function.map (/home/user/Projects/shinez/shinez-strapi/node_modules/lodash/lodash.js:9622:14)
at EagerRelation.morphToFetch (/home/user/Projects/shinez/shinez-strapi/node_modules/bookshelf/lib/eager.js:56:9)
at EagerRelation.eagerFetch (/home/user/Projects/shinez/shinez-strapi/node_modules/bookshelf/lib/eager.js:25:19)
at EagerRelation.<anonymous> (/home/user/Projects/shinez/shinez-strapi/node_modules/bookshelf/lib/base/eager.js:67:14)
at /home/user/Projects/shinez/shinez-strapi/node_modules/bookshelf/lib/eager.js:96:73
From previous event:
at EagerRelation._eagerLoadHelper (/home/user/Projects/shinez/shinez-strapi/node_modules/bookshelf/lib/eager.js:83:23)
at Sync.<anonymous> (/home/user/Projects/shinez/shinez-strapi/node_modules/bookshelf/lib/eager.js:31:31)
at processImmediate (node:internal/timers:464:21)
at process.topLevelDomainCallback (node:domain:152:15)
at process.callbackTrampoline (node:internal/async_hooks:128:24)
From previous event:
at EagerRelation.eagerFetch (/home/user/Projects/shinez/shinez-strapi/node_modules/bookshelf/lib/eager.js:31:8)
at EagerRelation.<anonymous> (/home/user/Projects/shinez/shinez-strapi/node_modules/bookshelf/lib/base/eager.js:67:14)
From previous event:
at Child._handleEager (/home/user/Projects/shinez/shinez-strapi/node_modules/bookshelf/lib/collection.js:527:73)
at Child.<anonymous> (/home/user/Projects/shinez/shinez-strapi/node_modules/bookshelf/lib/collection.js:179:27)
at processImmediate (node:internal/timers:464:21)
at process.topLevelDomainCallback (node:domain:152:15)
at process.callbackTrampoline (node:internal/async_hooks:128:24)
From previous event:
at Child.<anonymous> (/home/user/Projects/shinez/shinez-strapi/node_modules/bookshelf/lib/collection.js:177:12)
From previous event:
at Child.fetchAll (/home/user/Projects/shinez/shinez-strapi/node_modules/bookshelf/lib/model.js:878:10)
at Object.find (/home/user/Projects/shinez/shinez-strapi/node_modules/strapi-connector-bookshelf/lib/queries.js:81:8)
at fn (/home/user/Projects/shinez/shinez-strapi/node_modules/strapi-database/lib/queries/helpers.js:31:54)
at Object.find (/home/user/Projects/shinez/shinez-strapi/node_modules/strapi-database/lib/queries/helpers.js:15:24)
at processTicksAndRejections (node:internal/process/task_queues:96:5)
at async Object.find (/home/user/Projects/shinez/shinez-strapi/node_modules/strapi-plugin-content-manager/controllers/relations.js:47:18)
at async /home/user/Projects/shinez/shinez-strapi/node_modules/strapi/lib/middlewares/router/utils/routerChecker.js:79:22
at async /home/user/Projects/shinez/shinez-strapi/node_modules/strapi-utils/lib/policy.js:68:5
at async /home/user/Projects/shinez/shinez-strapi/node_modules/strapi/lib/middlewares/parser/index.js:48:23
at async /home/user/Projects/shinez/shinez-strapi/node_modules/strapi/lib/middlewares/xss/index.js:26:9
Maybe someone knows why it happens?
I have an assumption, that data volume, reached some limits. Because before, when we had about 1000 “gallery_articles” items, it was working fine. Now there are 3160 records.
Could you please help?
Thank you.