View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0007207 | Taler | auditor | public | 2022-03-24 19:00 | 2022-11-04 20:53 |
| Reporter | ttn | Assigned To | Christian Grothoff | ||
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | ||
| Platform | Linux | OS | Devuan | OS Version | 4 (chimaera) |
| Product Version | git (master) | ||||
| Target Version | 0.9 | Fixed in Version | 0.9 | ||
| Summary | 0007207: "make check" fails in test-sync.sh | ||||
| Description | HEAD at b856d56d95f92eb9dedb0af49493350ea8ea2268. Log (from src/auditor/) attached. My guess is that a recent update added table deposits_by_ready but this test was not accordingly updated. I tried to add deposits_by_ready to the list of tables on line 22 of test-sync.sh, but that did not resolve the problem. | ||||
| Tags | No tags attached. | ||||
| Attached Files | test-suite.log (1,830 bytes)
======================================================
taler-exchange 0.8.5: src/auditor/test-suite.log
======================================================
# TOTAL: 3
# PASS: 0
# SKIP: 2
# XFAIL: 0
# FAIL: 1
# XPASS: 0
# ERROR: 0
.. contents:: :depth: 2
SKIP: test-auditor.sh
=====================
Testing for jq
./test-auditor.sh: riga 1876: jq: comando non trovato
jq required
SKIP test-auditor.sh (exit status: 77)
SKIP: test-revocation.sh
========================
Testing for jq
./test-revocation.sh: riga 494: jq: comando non trovato
jq required
SKIP test-revocation.sh (exit status: 77)
FAIL: test-sync.sh
==================
Testing synchronization logic ......2022-03-24T13:51:31.475242-0400 pq-29787 ERROR PQprepare (`SELECT dep.deposit_serial_id,amount_with_fee_val,amount_with_fee_frac,denom.fee_deposit_val,denom.fee_deposit_frac,h_contract_terms,payto_uri,wire_target_serial_id,merchant_pub,kc.coin_pub FROM deposits_by_ready dbr JOIN deposits dep ON (dbr.coin_pub = dep.coin_pub AND dbr.deposit_serial_id = dep.deposit_serial_id) JOIN wire_targets USING (wire_target_h_payto) JOIN known_coins kc ON (kc.coin_pub = dep.coin_pub) JOIN denominations denom USING (denominations_serial) WHERE dbr.wire_deadline<=$1 AND dbr.shard >= $2 AND dbr.shard <= $3 AND (kyc_ok OR $4) ORDER BY dbr.wire_deadline ASC ,dbr.shard ASC LIMIT 1;' as `deposits_get_ready') failed with error: ERROR: relation "deposits_by_ready" does not exist
LINE 1: ...re_target_serial_id,merchant_pub,kc.coin_pub FROM deposits_b...
^
2022-03-24T13:51:31.475396-0400 taler-auditor-sync-29787 ERROR Failed to begin transaction with data source. Exiting
.FAIL
Record count mismatch: 424 / 0 in table denominations
FAIL test-sync.sh (exit status: 1)
| ||||
|
|
deposits_by_ready MUST NOT be in the sync table. I'll look into this tomorrow, it's 3am... |
|
|
The DBs had to be regenerated after the last schema-change. Fixed in Git master. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2022-03-24 19:00 | ttn | New Issue | |
| 2022-03-24 19:00 | ttn | Status | new => assigned |
| 2022-03-24 19:00 | ttn | Assigned To | => Christian Grothoff |
| 2022-03-24 19:00 | ttn | File Added: test-suite.log | |
| 2022-03-24 19:10 | Christian Grothoff | Note Added: 0018838 | |
| 2022-03-25 14:08 | Christian Grothoff | Status | assigned => resolved |
| 2022-03-25 14:08 | Christian Grothoff | Resolution | open => fixed |
| 2022-03-25 14:08 | Christian Grothoff | Note Added: 0018839 | |
| 2022-03-25 14:08 | Christian Grothoff | Fixed in Version | => 0.9 |
| 2022-03-25 14:08 | Christian Grothoff | Target Version | => 0.9 |
| 2022-11-04 20:53 | Christian Grothoff | Status | resolved => closed |
