PDconsumeInput: error while importing from zendesk

Technical assistance
1

Infos:

  • Used Zammad version: 6.5.1-1758529346.a4e079f4.noble
  • Used Zammad installation type: package (systemd service zammad.service)
  • Operating system: Ubuntu 24.04.3 LTS
  • Browser + version: Chrome (latest)
  • VM Details: 4vCPU - 16GB RAM - 200GB DISK

Expected behavior:

  • Zendesk import should start and complete successfully, without backend/database errors.

Actual behavior:

  • When starting the Zendesk import from the web interface, Zammad shows:
    PQconsumeInput() FATAL: terminating connection due to administrator command – server closed the connection unexpectedly. This probably means the server terminated abnormally before or while processing the request.

image
image424×481 17.6 KB

Steps to reproduce the behavior:

  • Fresh Ubuntu 24.04.3 system → Zammad installation → Import from Zendesk
2

Please configure your postgres accordingly, like the documentation states here:

You do not have enough connections (you need a minimum of 200 by default without tuning).
Then reset the installation and start over.