View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0011242 | Taler | merchant backend | public | 2026-03-12 13:04 | 2026-03-12 22:20 |
| Reporter | Florian Dold | Assigned To | Florian Dold | ||
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | feedback | Resolution | open | ||
| Target Version | 1.5 | ||||
| Summary | 0011242: when multiple bank accounts are configured, the order is non-deterministic and causes extra notifications | ||||
| Description | See additional information for two e-mails that contain exactly the same info but in different order. We send these out every few hours, despite nothing changing except the order of bank accounts. | ||||
| Additional Information | GNU Taler Merchant — Compliance Onboarding Status ================================================= ──────────────────────────────────────── Your account : payto://iban/CH8300762663925291837 Payment service: https://exchange.taler-ops.ch/ Currency : CHF ──────────────────────────────────────── * TRANSACTION within 1 day is allowed up to CHF:1000. * MERGE within 30 days is allowed up to CHF:2500. * WITHDRAW within 30 days is allowed up to CHF:2500. * MERGE within 365 days is allowed up to CHF:15000. * WITHDRAW within 365 days is allowed up to CHF:15000. * DEPOSIT within is allowed up to CHF:0. This limit may be relaxed after additional legitimization steps. * MERGE within is allowed up to CHF:0. This limit may be relaxed after additional legitimization steps. Status: kyc-wire-required ──────────────────────────────────────── Your account : payto://iban/CH8300762663925291837 Payment service: https://exchange.stage.taler-ops.ch/ Currency : CHF ──────────────────────────────────────── * TRANSACTION within is allowed up to CHF:1000. * AGGREGATE within is allowed up to CHF:2500. This limit may be relaxed after additional legitimization steps. * WITHDRAW within is allowed up to CHF:200. This limit may be relaxed after additional legitimization steps. * WITHDRAW within is allowed up to CHF:2500. * AGGREGATE within is allowed up to CHF:15000. This limit may be relaxed after additional legitimization steps. * WITHDRAW within is allowed up to CHF:15000. Status: ready =========================================================== GNU Taler Merchant — Compliance Onboarding Status ================================================= ──────────────────────────────────────── Your account : payto://iban/CH8300762663925291837 Payment service: https://exchange.stage.taler-ops.ch/ Currency : CHF ──────────────────────────────────────── * TRANSACTION within is allowed up to CHF:1000. * AGGREGATE within is allowed up to CHF:2500. This limit may be relaxed after additional legitimization steps. * WITHDRAW within is allowed up to CHF:200. This limit may be relaxed after additional legitimization steps. * WITHDRAW within is allowed up to CHF:2500. * AGGREGATE within is allowed up to CHF:15000. This limit may be relaxed after additional legitimization steps. * WITHDRAW within is allowed up to CHF:15000. Status: ready ──────────────────────────────────────── Your account : payto://iban/CH8300762663925291837 Payment service: https://exchange.taler-ops.ch/ Currency : CHF ──────────────────────────────────────── * TRANSACTION within 1 day is allowed up to CHF:1000. * MERGE within 30 days is allowed up to CHF:2500. * WITHDRAW within 30 days is allowed up to CHF:2500. * MERGE within 365 days is allowed up to CHF:15000. * WITHDRAW within 365 days is allowed up to CHF:15000. * DEPOSIT within is allowed up to CHF:0. This limit may be relaxed after additional legitimization steps. * MERGE within is allowed up to CHF:0. This limit may be relaxed after additional legitimization steps. Status: kyc-wire-required | ||||
| Tags | No tags attached. | ||||
| child of | 0011172 | confirmed | Florian Dold | send notification to merchant when KYC status changes [meta] |
|
|
Eh, are you sure this is recent? I did add ORDER BY in a a patch earlier in the week... |
|
|
Are you sure this problem exists after this patch: $ git diff 58f315885efa6f7835074ef1ab154ed39e07ea82..2ff04f3608220043cf5c025679a6f26344c4c9ab pg_account_kyc_get_status.sql diff --git a/src/backenddb/pg_account_kyc_get_status.sql b/src/backenddb/pg_account_kyc_get_status.> index b5e37475..2c034393 100644 --- a/src/backenddb/pg_account_kyc_get_status.sql +++ b/src/backenddb/pg_account_kyc_get_status.sql @@ -60,6 +60,7 @@ BEGIN WHERE merchant_serial = my_merchant_serial AND active AND (in_h_wire IS NULL OR h_wire = in_h_wire) + ORDER BY account_serial ASC LOOP -- Fetch KYC info for this account (can have multiple results) @@ -77,6 +78,7 @@ BEGIN FROM merchant_kyc mk WHERE mk.account_serial = my_account_serial AND (in_exchange_url IS NULL OR mk.exchange_url = in_exchange_url) + ORDER BY mk.kyc_serial_id ASC LOOP -- Ask taler-merchant-kyccheck to get us an update on the status ASAP UPDATE merchant_kyc commit 2ff04f3608220043cf5c025679a6f26344c4c9ab Author: Christian Grothoff <christian@grothoff.org> Date: Tue Mar 10 01:17:14 2026 +0100 |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2026-03-12 13:04 | Florian Dold | New Issue | |
| 2026-03-12 18:35 | Florian Dold | Relationship added | child of 0011172 |
| 2026-03-12 21:46 | Christian Grothoff | Note Added: 0028124 | |
| 2026-03-12 22:14 | Christian Grothoff | Assigned To | => Christian Grothoff |
| 2026-03-12 22:14 | Christian Grothoff | Status | new => assigned |
| 2026-03-12 22:20 | Christian Grothoff | Note Added: 0028125 | |
| 2026-03-12 22:20 | Christian Grothoff | Assigned To | Christian Grothoff => Florian Dold |
| 2026-03-12 22:20 | Christian Grothoff | Status | assigned => feedback |
