User Sync not Syncing

When attempting to sync between 2 sites the following error is thrown in debug.log

PHP Warning: mysqli_real_connect(): (42000/1203): User {dbuser} already has more than 'max_user_connections' active connections in /home1/{user}/public_html/wp-includes/wp-db.php on line 1603

Host was contacted and is not willing to increase max_user_connections.

  • Predrag Dubajic

    Hi Ben,

    Hope you're doing well :slight_smile:

    User Sync requires more resources on the initial sync since it's syncing large number of users, after that future sync processes will be way smaller and don't require nearly that high resources.

    Can you get in touch with your host and ask them if it's possible to increase max user connections just until this initial process is finished and then restore it back to old value?

    Let us know how it goes.

    Best regards,
    Predrag