RyanESmith7 Posted April 21, 2016 Posted April 21, 2016 Is it bad to delete all the records in the EasySync_Payloads table? It's kind of building up.
Joshua Willing Halpern Posted April 21, 2016 Posted April 21, 2016 Hmm, with regular syncing the only reasons records should be building up in the payloads table are The delete settings variable is set to save payloads, or The sync isn't working properly. It should automatically delete successful/all payloads depending on the setting. Check out the easysync settings scripts and confirm they're set the way you want. Oh, and yes you can safely delete records from payload table as long as they're not logged deletions. I.e. ES_Deletion_UUID should be empty.
RyanESmith7 Posted April 21, 2016 Author Posted April 21, 2016 It is set to "Successful", but I had 3500 records in that table on the server.
Joshua Willing Halpern Posted April 21, 2016 Posted April 21, 2016 Woah. Does the account running the script have delete privileges for the payloads table?
RyanESmith7 Posted April 22, 2016 Author Posted April 22, 2016 (edited) Yes, there were several accounts, and they all do. Many of the payloads were mine.Which is really weird, cause I didn't have that many failures. Edited April 22, 2016 by RyanESmith7
Joshua Willing Halpern Posted April 22, 2016 Posted April 22, 2016 Hmm. I think this calls for a debug session. If the sync is behaving properly you might be fine just deleting these occasionally, but really they should not be accumulating. I'd use the debugger and set a breakpoint where the delete should occur. See if the the deletion returns an error. For this you may have to switch the settings to not perform script on server for the relevant scripts. Wish I had more insight.
Recommended Posts
This topic is 3226 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now