Syncjob after deliting products in database

[Former Member]

We deleted ~150k Products from the Online Catalog directly on the db with a sql query. After starting the syncjob the log is full with those lines:

 found ambigous sync timestamps for 8806218366977 and job sync ProductCatalog:Staged->Online : expected target 8810740219905 but found [null]

Is there a way to recover from this state? Like Deleting all those Synctimestamps? But how would I get exactly those?

 SELECT count(*) FROM itemsynctimestamps s WHERE p_targetversion= AND NOT EXISTS (SELECT * FROM products WHERE pk = s.p_targetitem);

gives me everything from synctimestamps where there is no entry in the products table, so also price rows...

Would it be safe to delete all itemsynctimestamps with target catalogversion ProductCatalog:online?

[Former Member · Accepted solution]

I solved my problem with a sql query that removes synctimestamps where the target catalog is product online catalog and there is a source product in the staging catalog but no target item in the online catalog

 DELETE s FROM itemsynctimestamps s WHERE s.p_targetversion= 8796093153881 AND NOT EXISTS (SELECT * FROM products WHERE pk = s.p_targetitem) AND EXISTS (SELECT * FROM products WHERE pk = s.p_sourceitem);