Error when running db-sync with governance set to disabled

[ArturWieczorek]

I can't finish sync for cardano-db-sync version 13.6.0.5 with governance set to disabled - it will result in:

Error SNErrDefault: "resolveGovActionProposal.queryGovActionProposalId missing GovAction (TxKey {unTxKey = SqlBackendKey {unSqlBackendKey = ABCDEF...}}, 0)" .

during Conway era.
only_utxo and disable-all presets seem to work fine.

I am using cardano-node version:

[workstat:cardano.node.basicInfo.version:Notice:5] [2025-09-08 22:00:15.19 UTC] 10.3.1
[workstat:cardano.node.basicInfo.commit:Notice:5] [2025-09-08 22:00:15.19 UTC] b3f237b75e64f4d8142af95b053e2828221d707f

and cardano-db-sync version:

[db-sync-node:Info:6] [2025-09-08 22:05:10.24 UTC] Version number: 13.6.0.5
[db-sync-node:Info:6] [2025-09-08 22:05:10.24 UTC] Git hash: cb61094c82254464fc9de777225e04d154d9c782

This is log example from preview (but network does not matter - it originally happened while I was writing automated test on local testnet).

[db-sync-node:Info:142] [2025-09-09 02:38:30.30 UTC] Starting epoch 677
[db-sync-node:Info:142] [2025-09-09 02:38:30.30 UTC] Insert Conway Block: epoch 677, slot 58492808, block 2438958, hash d0a3ea139c1e97b41064d10a448fa91a74345f72aa92ab2c88cc637fa9a15c14
[db-sync-node:Info:142] [2025-09-09 02:38:31.27 UTC] 
Inserted epoch 676 from updateEpochWhenSyncing with Cache. 
 epoch: Epoch {epochOutSum = 288943934941419, epochFees = DbLovelace 706371408, epochTxCount = 1644, epochBlkCount = 3215, epochNo = 676, epochStartTime = 2024-08-31 00:01:19 UTC, epochEndTime = 2024-08-31 23:59:43 UTC}
[db-sync-node:Info:142] [2025-09-09 02:38:34.32 UTC] Inserted 7932 EpochStake for EpochNo 678
[db-sync-node:Info:142] [2025-09-09 02:38:37.67 UTC] Insert Conway Block: epoch 677, slot 58520634, block 2440000, hash 1375531afdee3e03cdd2a51cbe5ff2df733e2bcf5f32cf0cd3cf574074e6a0e1
[db-sync-node:Info:150] [2025-09-09 02:38:39.44 UTC] Asynchronously wrote a ledger snapshot to ledger-state/preview_disable_gov/58492783-718f54de10-676.lstate in 9.221704947s.
[db-sync-node:Info:142] [2025-09-09 02:38:44.56 UTC] Removing old epoch boundary file ledger-state/preview_disable_gov/58233591-abb2dca283-673.lstate
[db-sync-node:Info:142] [2025-09-09 02:38:44.63 UTC] Inserted 1 deposit refund rewards
[db-sync-node:Info:142] [2025-09-09 02:38:44.63 UTC] Removing 0 orphaned rewards
[db-sync-node:Info:142] [2025-09-09 02:38:44.64 UTC] Validate Epoch Rewards: total rewards that become spendable in epoch 678 are 5929
[db-sync-node:Error:142] [2025-09-09 02:38:44.66 UTC] Error SNErrDefault: "resolveGovActionProposal.queryGovActionProposalId missing GovAction (TxKey {unTxKey = SqlBackendKey {unSqlBackendKey = 4820625}}, 0)"
[db-sync-node:Info:142] [2025-09-09 02:38:44.66 UTC] Shutting down DB thread
[db-sync-node:Info:150] [2025-09-09 02:38:53.71 UTC] Asynchronously wrote a ledger snapshot to ledger-state/preview_disable_gov/58579153-34b7b6ed1e-677.lstate in 9.153898811s.

This is the config I am using:

{
  "EnableFutureGenesis": true,
  "EnableLogMetrics": false,
  "EnableLogging": true,
  "NetworkName": "preview",
  "NodeConfigFile": "../../cardano-node/preview/config.json",
  "PrometheusPort": 8081,
  "RequiresNetworkMagic": "RequiresMagic",

  "insert_options": {
    "tx_cbor": "disable",
    "tx_out": {
      "value": "enable",
      "force_tx_in": false,
      "use_address_table": false
    },
    "ledger": "enable",
    "shelley": {
      "enable": true
    },
    "multi_asset": {
      "enable": true
    },
    "metadata": {
      "enable": true
    },
    "plutus": {
      "enable": true
    },
    "governance": "disable",
    "offchain_pool_data": "enable",
    "json_type": "text"
  },

[ArturWieczorek]

Test: IntersectMBO/cardano-node-tests#3130
Attempt to fix: #2000 - unfortunately after running it, it fails with double rewards error.