Bug#1085475: sqitch: flaky autopkgtest: t/sqlite.t

[Paul Gevers]

Source: sqitch
Version: 1.4.1-1
Severity: serious
User: debian-ci at lists.debian.org
Usertags: flaky

Dear maintainer(s),

I looked at the results of the autopkgtest of your package because it's 
currently blocking perl. I noticed that it regularly fails.

Because the unstable-to-testing migration software now blocks on
regressions in testing, flaky tests, i.e. tests that flip between
passing and failing without changes to the list of installed packages,
are causing people unrelated to your package to spend time on these
tests.

Don't hesitate to reach out if you need help and some more information
from our infrastructure.

Paul

https://ci.debian.net/packages/s/sqitch/testing/ppc64el/53081633/

  52s ok 127 - live database
  52s UNIQUE constraint failed: events.change_id, events.committed_at
  52s DBD::SQLite::db do failed: UNIQUE constraint failed: 
events.change_id, events.committed_at
  52s Trace begun at /usr/share/perl5/App/Sqitch/Role/DBIEngine.pm line 613
  52s 
App::Sqitch::Role::DBIEngine::_log_event('App::Sqitch::Engine::sqlite=HASH(0x1335b4868)', 
'deploy', 'App::Sqitch::Plan::Change=HASH(0x131f8a658)') called at 
/usr/share/perl5/App/Sqitch/Role/DBIEngine.pm line 582
  52s 
App::Sqitch::Role::DBIEngine::log_deploy_change('App::Sqitch::Engine::sqlite=HASH(0x1335b4868)', 
'App::Sqitch::Plan::Change=HASH(0x131f8a658)') called at 
t/lib/DBIEngineTest.pm line 1603
  52s DBIEngineTest::__ANON__ at /usr/share/perl/5.38/Test/Builder.pm 
line 374
  52s eval {...} at /usr/share/perl/5.38/Test/Builder.pm line 374
  52s Test::Builder::subtest('Test::Builder=HASH(0x130482928)', 'live 
database', 'CODE(0x1335a2a90)') called at 
/usr/share/perl/5.38/Test/More.pm line 831
  52s Test::More::subtest('live database', 'CODE(0x1335a2a90)') called 
at t/lib/DBIEngineTest.pm line 1825
  52s DBIEngineTest::run('DBIEngineTest', 'class', 
'App::Sqitch::Engine::sqlite', 'version_query', 'select \'SQLite \' || 
sqlite_version()', 'target_params', 'ARRAY(0x132fb29e8)', 
'alt_target_params', 'ARRAY(0x133419390)', 'skip_unless', 
'CODE(0x132813160)', 'engine_err_regex', 'Regexp=REGEXP(0x13359dbf8)', 
'init_error', 'Sqitch database /tmp/9fPqS9ZFoC/sqitchtestsjzqac4e.db 
already initialized', 'test_dbh', 'CODE(0x132818020)', 
'add_second_format', 'strftime(\'%%Y-%%m-%%d %%H:%%M:%%f\', 
strftime(\'%%J\', %s) + (1/86400.0))') called at t/sqlite.t line 403
-------------- next part --------------
A non-text attachment was scrubbed...
Name: OpenPGP_signature.asc
Type: application/pgp-signature
Size: 495 bytes
Desc: OpenPGP digital signature
URL: <http://alioth-lists.debian.net/pipermail/pkg-perl-maintainers/attachments/20241019/e30115b1/attachment.sig>