[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Bug#1003678: sqlite3 breaks crowdsec autopkgtest: invalid type \"INTEGER\" for column

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: debian-ci@lists.debian.org
User: debian-ci@lists.debian.org
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 [0]     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 [1]. 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


[0] 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.
[1] https://qa.debian.org/excuses.php?package=sqlite3


=== 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]

Attachment: OpenPGP_signature
Description: OpenPGP digital signature

Reply to: