This is causing existing transactions to be re-inserted somehow.

[todo]

This is causing existing transactions to be re-inserted somehow.

[elliotcourant]

INFO[1331] starting job                                  jobId=4a929dc2dc0170166a1aae05 name=PullLatestTransactions
INFO[1331] pulling account balances                      accountId=1 id=4a929dc2dc0170166a1aae05 job=PullLatestTransactions
TRAC[1331] BEGIN                                        
TRAC[1331] SELECT "link"."link_id", "link"."account_id", "link"."link_type", "link"."plaid_link_id", "link"."institution_name", "link"."custom_institution_name", "link"."created_at", "link"."created_by_user_id", "link"."updated_at", "link"."updated_by_user_id", "plaid_link"."plaid_link_id" AS "plaid_link__plaid_link_id", "plaid_link"."item_id" AS "plaid_link__item_id", "plaid_link"."access_token" AS "plaid_link__access_token", "plaid_link"."products" AS "plaid_link__products", "plaid_link"."webhook_url" AS "plaid_link__webhook_url", "plaid_link"."institution_id" AS "plaid_link__institution_id", "plaid_link"."institution_name" AS "plaid_link__institution_name" FROM "links" AS "link" LEFT JOIN "plaid_links" AS "plaid_link" ON "plaid_link"."plaid_link_id" = "link"."plaid_link_id" WHERE ("link"."link_id" = 1 AND "link"."account_id" = 1) LIMIT 1 
TRAC[1331] SELECT "bank_account"."bank_account_id", "bank_account"."account_id", "bank_account"."link_id", "bank_account"."plaid_account_id", "bank_account"."available_balance", "bank_account"."current_balance", "bank_account"."mask", "bank_account"."name", "bank_account"."plaid_name", "bank_account"."plaid_official_name", "bank_account"."account_type", "bank_account"."account_sub_type" FROM "bank_accounts" AS "bank_account" WHERE (("bank_account"."link_id", "bank_account"."account_id") IN ((1, 1))) 
TRAC[1331] SELECT "bank_account"."bank_account_id", "bank_account"."account_id", "bank_account"."link_id", "bank_account"."plaid_account_id", "bank_account"."available_balance", "bank_account"."current_balance", "bank_account"."mask", "bank_account"."name", "bank_account"."plaid_name", "bank_account"."plaid_official_name", "bank_account"."account_type", "bank_account"."account_sub_type" FROM "bank_accounts" AS "bank_account" WHERE ("bank_account"."account_id" = 1) AND ("bank_account"."link_id" = 1 ) 
TRAC[1331] retrieving transactions for 2 bank account(s)  accountId=1 id=4a929dc2dc0170166a1aae05 job=PullLatestTransactions
TRAC[1331] SELECT "transaction"."transaction_id", "transaction"."bank_account_id", "transaction"."amount" FROM "transactions" AS "transaction" INNER JOIN "bank_accounts" AS "bank_account" ON ("bank_account"."bank_account_id" = "transaction"."bank_account_id" AND "bank_account"."account_id" = "transaction"."account_id") WHERE ("transaction"."account_id" = 1) AND ("bank_account"."link_id" = 1) AND ("transaction"."plaid_transaction_id" IN ('WnkN3XqzdDtJZoplAZwzCKJpj8xDg6UWPg7Nz')) 
TRAC[1331] INSERT INTO "transactions" ("transaction_id", "account_id", "bank_account_id", "plaid_transaction_id", "amount", "expense_id", "categories", "original_categories", "date", "authorized_date", "name", "original_name", "merchant_name", "original_merchant_name", "is_pending", "created_at") VALUES (DEFAULT, 1, 1, 'WnkN3XqzdDtJZoplAZwzCKJpj8xDg6UWPg7Nz', 633, DEFAULT, '{"Travel","Taxi"}', '{"Travel","Taxi"}', '2021-02-22 00:00:00+00:00:00', DEFAULT, 'Uber 072515 SF**POOL**', 'Uber 072515 SF**POOL**', 'Uber', 'Uber', FALSE, '2021-02-26 04:32:32.793462+00:00:00') RETURNING "transaction_id", "expense_id", "authorized_date" 
ERRO[1331] failed to insert new transactions             accountId=1 error="failed to insert transactions: ERROR #23505 duplicate key value violates unique constraint \"transactions_bank_account_id_plaid_transaction_id_key\"" id=4a929dc2dc0170166a1aae05 job=PullLatestTransactions
TRAC[1331] ROLLBACK