Content manager plugin issue

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.

Hey Oleg, having the same issue. Could you figure out what solves the problem?