• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion
  • Please beaware of a breaking change in the REST API on the next Plesk release (18.0.62).
    Starting from Plesk Obsidian 18.0.62, requests to REST API containing the Content-Type header with a media-type directive other than “application/json” will result in the HTTP “415 Unsupported Media Type” client error response code. Read more here

Strange Plan Sync Error Message

MorrisC

Basic Pleskian
When I am syncing plans with subscription, it shows

Error: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '16-servicePlanId' for key 'PRIMARY'

Which table should I check for the problem in mysql database?

Thanks

Morris
 
Hi MorrisC,

you find the definition "servicePlanId" in the psa - database - table: "longtaskparams"
 
Thanks, UFHH01,

I found there are so many longtasks params and in long tasks, therefore, I delete all of them from the record.
I then move customers to another plan and delete the original plan. And create the plan again and move them back.
No more sync problem message anymore.

From my understanding, since the primary key should be unique, therefore, deleting records in longtasks and longtakparams tables should resolve the issues.
 
Last edited:
Back
Top