RyanESmith7 Posted April 21, 2016 Share Posted April 21, 2016 Is it bad to delete all the records in the EasySync_Payloads table? It's kind of building up. Link to comment Share on other sites More sharing options...
Joshua Willing Halpern Posted April 21, 2016 Share 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. Link to comment Share on other sites More sharing options...
RyanESmith7 Posted April 21, 2016 Author Share Posted April 21, 2016 It is set to "Successful", but I had 3500 records in that table on the server. Link to comment Share on other sites More sharing options...
Joshua Willing Halpern Posted April 21, 2016 Share Posted April 21, 2016 Woah. Does the account running the script have delete privileges for the payloads table? Link to comment Share on other sites More sharing options...
RyanESmith7 Posted April 22, 2016 Author Share 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 Link to comment Share on other sites More sharing options...
Joshua Willing Halpern Posted April 22, 2016 Share 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 2897 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