Package Manager's long running Composer operations can run afoul of short database connection timeouts

Created on 13 August 2025, 2 days ago

Problem/Motivation

Package Manager invokes Composer repeatedly. Some of those processes can take a while, and on some hosts, that long wait time will exceed the configured wait timeout for the database (i.e., how long it will wait for a connection to do something before it drops it), which can cause Package Manager to fail with "MySQL server has gone away" errors.

Steps to reproduce

Not sure exactly how to reproduce this, but it has happened when using Package Manager on some hosts.

Proposed resolution

If the database is MySQL, Package Manager's Composer runner should send a SET SESSION wait_timeout = $timeout query to it.

User interface changes

None.

Introduced terminology

None.

API changes

None, this would be an internal change to an internal, final class.

Data model changes

None.

Release notes snippet

TBD.

🐛 Bug report
Status

Active

Version

11.0 🔥

Component

package_manager.module

Created by

🇺🇸United States phenaproxima Massachusetts

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Merge Requests

Comments & Activities

  • Issue created by @phenaproxima
  • Merge request !12982Resolve #3541137 "Package managers long" → (Open) created by phenaproxima
  • 🇺🇸United States phenaproxima Massachusetts
  • Pipeline finished with Failed
    2 days ago
    Total: 218s
    #572047
  • Pipeline finished with Canceled
    2 days ago
    Total: 130s
    #572095
  • Pipeline finished with Canceled
    2 days ago
    Total: 133s
    #572101
  • 🇺🇸United States phenaproxima Massachusetts
  • Pipeline finished with Failed
    2 days ago
    Total: 1248s
    #572107
  • Pipeline finished with Canceled
    2 days ago
    Total: 282s
    #572187
  • 🇺🇸United States phenaproxima Massachusetts

    Crediting @sjpeters79 for helping me with some database-related questions in Slack.

  • Pipeline finished with Success
    2 days ago
    Total: 1318s
    #572193
  • 🇮🇹Italy mondrake 🇮🇹

    Commented inline.

  • Pipeline finished with Canceled
    1 day ago
    Total: 131s
    #572500
  • Pipeline finished with Canceled
    1 day ago
    Total: 93s
    #572501
  • Pipeline finished with Failed
    1 day ago
    Total: 307s
    #572502
  • Pipeline finished with Failed
    1 day ago
    Total: 384s
    #572505
  • Pipeline finished with Failed
    1 day ago
    Total: 621s
    #572510
  • Pipeline finished with Canceled
    about 6 hours ago
    Total: 71s
    #573781
  • Pipeline finished with Success
    about 6 hours ago
    Total: 1219s
    #573782
Production build 0.71.5 2024