Source: sqlite3, crowdsec Control: found -1 sqlite3/3.37.2-1 Control: found -1 crowdsec/1.0.9-3 Severity: serious Tags: sid bookworm X-Debbugs-CC: firstname.lastname@example.org User: email@example.com Usertags: breaks needs-update Dear maintainer(s),With a recent upload of sqlite3 the autopkgtest of crowdsec fails in testing when that autopkgtest is run with the binary packages of sqlite3 from unstable. It passes when run with only packages from testing. In tabular form:
pass fail sqlite3 from testing 3.37.2-1 crowdsec from testing 1.0.9-3 versioned deps  from testing from unstable all others from testing from testing I copied some of the output at the bottom of this report.Currently this regression is blocking the migration of sqlite3 to testing . Due to the nature of this issue, I filed this bug report against both packages. Can you please investigate the situation and reassign the bug to the right package?
More information about this bug and the reason for filing it can be found on https://wiki.debian.org/ContinuousIntegration/RegressionEmailInformation Paul You can see what packages were added from the second line of the log file quoted below. The migration software adds source package from unstable to the list if they are needed to install packages from sqlite3/3.37.2-1. I.e. due to versioned dependencies or breaks/conflicts.
 https://qa.debian.org/excuses.php?package=sqlite3 https://ci.debian.net/data/autopkgtest/testing/amd64/c/crowdsec/18271072/log.gz === RUN TestSimulatedAlert time="2022-01-12T20:11:40Z" level=info msg="Creating new API server"- [Wed, 12 Jan 2022 20:11:41 UTC] "POST /v1/watchers HTTP/1.1 201 98.133294ms "crowdsec-test/" " time="2022-01-12T20:11:41Z" level=fatal msg="unable to create new database client: failed creating schema resources: sql/schema: invalid type \"INTEGER\" for column \"events_count\""
FAIL github.com/crowdsecurity/crowdsec/pkg/apiserver 0.130s? github.com/crowdsecurity/crowdsec/pkg/apiserver/controllers [no test files] ? github.com/crowdsecurity/crowdsec/pkg/apiserver/controllers/v1 [no test files] ? github.com/crowdsecurity/crowdsec/pkg/apiserver/middlewares/v1 [no test files]
Description: OpenPGP digital signature