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. | ||||
|
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 |