https://linen.dev logo
Join Slack
Powered by
I have an issue where after a Reset of my Salesfor...
# ask-community-for-troubleshooting
g
I have an issue where after a Reset of my Salesforce to Postgres connection not all records in Salesforce will be emitted for the given stream (despite other connections such as my Salesforce to BigQuery connection having all records). This doesn’t produce an error and the only related logs I can find refer to a possible state collision. However, this is present on both successful and unsuccessful syncs. Airbyte: 0.44.4, Salesforce: 2.0.13, Postgres: 0.3.27.
Copy code
2023-05-22 18:32:09 WARN i.a.w.i.b.DefaultSyncStatsTracker(updateDestinationStateStats):195 - The message tracker encountered an issue that prevents committed record counts from being reliably computed. This only impacts metadata and does not indicate a problem with actual sync data.
io.airbyte.workers.internal.book_keeping.StateDeltaTracker$StateDeltaTrackerException: State hash 1727035794 was already committed, likely indicating a state hash collision
	at io.airbyte.workers.internal.book_keeping.StateDeltaTracker.commitStateHash(StateDeltaTracker.java:121) ~[io.airbyte-airbyte-commons-worker-0.44.4.jar:?]
	at io.airbyte.workers.internal.book_keeping.DefaultSyncStatsTracker.updateDestinationStateStats(DefaultSyncStatsTracker.java:192) ~[io.airbyte-airbyte-commons-worker-0.44.4.jar:?]
	at io.airbyte.workers.internal.sync_persistence.SyncPersistenceImpl.updateDestinationStateStats(SyncPersistenceImpl.java:447) ~[io.airbyte-airbyte-commons-worker-0.44.4.jar:?]
	at io.airbyte.workers.internal.book_keeping.AirbyteMessageTracker.handleDestinationEmittedState(AirbyteMessageTracker.java:137) ~[io.airbyte-airbyte-commons-worker-0.44.4.jar:?]
	at io.airbyte.workers.internal.book_keeping.AirbyteMessageTracker.acceptFromDestination(AirbyteMessageTracker.java:103) ~[io.airbyte-airbyte-commons-worker-0.44.4.jar:?]
	at io.airbyte.workers.general.DefaultReplicationWorker.lambda$readFromDstRunnable$4(DefaultReplicationWorker.java:324) ~[io.airbyte-airbyte-commons-worker-0.44.4.jar:?]
	at java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1804) ~[?:?]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144) ~[?:?]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642) ~[?:?]
	at java.lang.Thread.run(Thread.java:1589) ~[?:?]
k
A message from kapa.ai
It seems like you're experiencing an issue with the state hash collision in your Salesforce to Postgres connection. Based on the information provided, I don't have enough details to give you a confident solution. However, I can suggest a few things you can try: 1. Update your Airbyte instance and connectors to the latest versions, as this might resolve any known issues. 2. Double-check your connection settings and make sure they are configured correctly. 3. You can try running a full refresh sync to see if it resolves the issue with missing records. If the issue persists, I recommend creating a GitHub issue with the provided logs and details about your setup. The Airbyte team can then investigate the problem further. For more information on Airbyte, you can refer to the [documentation](https://docs.airbyte.com).
s
@Gabriel Levine I am having similar issues, with Snowflake as the destination. Were you able to solve this?
Open in Slack
PreviousNext
Powered by