[pkg-go] Bug#839461: golang-github-mattn-go-sqlite3: FTBFS: dh_auto_test: go test -v -p 1 github.com/mattn/go-sqlite3 github.com/mattn/go-sqlite3/sqlite3_test returned exit code 1

[Lucas Nussbaum]

Source: golang-github-mattn-go-sqlite3
Version: 1.1.0~dfsg1-1
Severity: serious
Tags: stretch sid
User: debian-qa at lists.debian.org
Usertags: qa-ftbfs-20161001 qa-ftbfs
Justification: FTBFS on amd64

Hi,

During a rebuild of all packages in sid, your package failed to build on
amd64.

Relevant part (hopefully):
>  debian/rules build
> dh build --buildsystem=golang --with=golang
>    dh_testdir -O--buildsystem=golang
>    dh_update_autotools_config -O--buildsystem=golang
>    dh_auto_configure -O--buildsystem=golang
>    dh_auto_build -O--buildsystem=golang
> 	go install -v -p 1 github.com/mattn/go-sqlite3 github.com/mattn/go-sqlite3/sqlite3_test
> github.com/mattn/go-sqlite3
> github.com/mattn/go-sqlite3/sqlite3_test
>    dh_auto_test -O--buildsystem=golang
> 	go test -v -p 1 github.com/mattn/go-sqlite3 github.com/mattn/go-sqlite3/sqlite3_test
> === RUN   TestSimpleError
> --- PASS: TestSimpleError (0.00s)
> === RUN   TestCorruptDbErrors
> --- PASS: TestCorruptDbErrors (0.00s)
> === RUN   TestSqlLogicErrors
> --- PASS: TestSqlLogicErrors (0.02s)
> === RUN   TestExtendedErrorCodes_ForeignKey
> --- PASS: TestExtendedErrorCodes_ForeignKey (0.01s)
> === RUN   TestExtendedErrorCodes_NotNull
> --- PASS: TestExtendedErrorCodes_NotNull (0.01s)
> === RUN   TestExtendedErrorCodes_Unique
> --- PASS: TestExtendedErrorCodes_Unique (0.01s)
> === RUN   TestFTS3
> --- PASS: TestFTS3 (0.01s)
> === RUN   TestOpen
> --- PASS: TestOpen (0.02s)
> === RUN   TestClose
> --- PASS: TestClose (0.00s)
> === RUN   TestInsert
> --- PASS: TestInsert (0.01s)
> === RUN   TestUpdate
> --- PASS: TestUpdate (0.01s)
> === RUN   TestDelete
> --- PASS: TestDelete (0.03s)
> === RUN   TestBooleanRoundtrip
> --- PASS: TestBooleanRoundtrip (0.01s)
> === RUN   TestTimestamp
> --- PASS: TestTimestamp (0.07s)
> === RUN   TestBoolean
> --- PASS: TestBoolean (0.03s)
> === RUN   TestFloat32
> --- PASS: TestFloat32 (0.01s)
> === RUN   TestNull
> --- PASS: TestNull (0.00s)
> === RUN   TestTransaction
> --- PASS: TestTransaction (0.01s)
> === RUN   TestWAL
> --- PASS: TestWAL (0.01s)
> === RUN   TestTimezoneConversion
> --- FAIL: TestTimezoneConversion (0.09s)
> 	sqlite3_test.go:689: Failed to create table: Invalid _loc: US/Central: open /usr/lib/go-1.7/lib/time/zoneinfo.zip: no such file or directory
> === RUN   TestSuite
> === RUN   TestBlobs
> --- PASS: TestBlobs (0.01s)
> === RUN   TestManyQueryRow
> --- PASS: TestManyQueryRow (0.22s)
> === RUN   TestTxQuery
> --- PASS: TestTxQuery (0.00s)
> === RUN   TestPreparedStmt
> --- PASS: TestPreparedStmt (0.55s)
> BenchmarkExec           300000     198736 req/s
> BenchmarkQuery          100000      59647 req/s
> BenchmarkParams         100000      50013 req/s
> BenchmarkStmt           200000      95124 req/s
> BenchmarkRows             3000       1875 req/s
> BenchmarkStmtRows         3000       1969 req/s
> --- PASS: TestSuite (12.32s)
> === RUN   TestExecer
> --- PASS: TestExecer (0.01s)
> === RUN   TestQueryer
> --- PASS: TestQueryer (0.00s)
> === RUN   TestStress
> --- PASS: TestStress (2.08s)
> === RUN   TestDateTimeLocal
> --- FAIL: TestDateTimeLocal (0.00s)
> 	sqlite3_test.go:897: Failed to scan datetime: Invalid _loc: Asia/Tokyo: open /usr/lib/go-1.7/lib/time/zoneinfo.zip: no such file or directory
> === RUN   TestVersion
> --- PASS: TestVersion (0.00s)
> === RUN   TestNumberNamedParams
> --- PASS: TestNumberNamedParams (0.01s)
> === RUN   TestStringContainingZero
> --- PASS: TestStringContainingZero (0.02s)
> === RUN   TestDateTimeNow
> --- PASS: TestDateTimeNow (0.00s)
> FAIL
> exit status 1
> FAIL	github.com/mattn/go-sqlite3	14.802s
> ?   	github.com/mattn/go-sqlite3/sqlite3_test	[no test files]
> dh_auto_test: go test -v -p 1 github.com/mattn/go-sqlite3 github.com/mattn/go-sqlite3/sqlite3_test returned exit code 1

If the failure looks somehow time/timezone related:
Note that this rebuild was performed without the 'tzdata' package
installed in the chroot. tzdata used be (transitively) part of
build-essential, but it no longer is. If this package requires it to
build, it should be added to build-depends. For the release team's
opinion on this, see
https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=836940#185

If the failure looks LSB-related:
similarly to tzdata, lsb-base is not installed in the build chroot.

The full build log is available from:
   http://aws-logs.debian.net/2016/10/01/golang-github-mattn-go-sqlite3_1.1.0~dfsg1-1_unstable.log

A list of current common problems and possible solutions is available at
http://wiki.debian.org/qa.debian.org/FTBFS . You're welcome to contribute!

About the archive rebuild: The rebuild was done on EC2 VM instances from
Amazon Web Services, using a clean, minimal and up-to-date chroot. Every
failed build was retried once to eliminate random failures.