View Issue Details

IDProjectCategoryView StatusLast Update
0007207Talerauditorpublic2022-11-04 20:53
Reporterttn Assigned ToChristian Grothoff  
PrioritynormalSeverityminorReproducibilityhave not tried
Status closedResolutionfixed 
PlatformLinuxOSDevuanOS Version4 (chimaera)
Product Versiongit (master) 
Target Version0.9Fixed in Version0.9 
Summary0007207: "make check" fails in test-sync.sh
DescriptionHEAD 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.
TagsNo 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)

test-suite.log (1,830 bytes)   

Activities

Christian Grothoff

2022-03-24 19:10

manager   ~0018838

deposits_by_ready MUST NOT be in the sync table. I'll look into this tomorrow, it's 3am...

Christian Grothoff

2022-03-25 14:08

manager   ~0018839

The DBs had to be regenerated after the last schema-change. Fixed in Git master.

Issue History

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