Bug 628242

Summary:	dev-db/sqlite-3.20.1: date.test date-2.2c-* tests fail on x86
Product:	Gentoo Linux	Reporter:	Thomas Deutschmann (RETIRED) <whissi>
Component:	Current packages	Assignee:	Arfrever Frehtes Taifersar Arahesis <arfrever.fta>
Status:	RESOLVED FIXED
Severity:	normal	CC:	proxy-maint, slyfox, toralf
Priority:	Normal	Keywords:	TESTFAILURE
Version:	unspecified
Hardware:	All
OS:	Linux
Whiteboard:
Package list:		Runtime testing required:	---
Attachments:	build.log emerge-info.txt dev-db:sqlite-3.21.0:20171130-003752.log emerge-history.txt environment etc.portage.tbz2 logs.tbz2 temp.tbz2

Description Thomas Deutschmann (RETIRED) gentoo-dev

2017-08-18 22:51:29 UTC

Created attachment 489564 [details]
build.log

[...]
SQLite 2017-06-08 14:26:16 0ee482a1e0eae22e08edc8978c9733a96603d4509645f348ebf55b579e89636b
464 errors out of 186760 tests on vm-gentoo-x86 Linux 32-bit little-endian
!Failures on these tests: date-2.2c-1 date-2.2c-4 date-2.2c-7 date-2.2c-8 date-2.2c-10 date-2.2c-11 date-2.2c-14 date-2.2c-17 date-2.2c-18 date-2.2c-20 date-2.2c-21 date-2.2c-24 date-2.2c-27 date-2.2c-30 date-2.2c-31 date-2.2c-34 date-2.2c-37 date-2.2c-40 date-2.2c-41 date-2.2c-43 date-2.2c-44 date-2.2c-47 date-2.2c-50 date-2.2c-53 date-2.2c-54 date-2.2c-57 date-2.2c-60 date-2.2c-63 date-2.2c-64 date-2.2c-66 date-2.2c-67 date-2.2c-70 date-2.2c-73 date-2.2c-74 date-2.2c-76 date-2.2c-77 date-2.2c-80 date-2.2c-83 date-2.2c-86 date-2.2c-87 date-2.2c-89 date-2.2c-90 date-2.2c-93 date-2.2c-96 date-2.2c-97 date-2.2c-99 date-2.2c-100 date-2.2c-103 date-2.2c-106 date-2.2c-109 date-2.2c-110 date-2.2c-112 date-2.2c-113 date-2.2c-116 date-2.2c-119 date-2.2c-120 date-2.2c-122 date-2.2c-123 date-2.2c-126 date-2.2c-129 date-2.2c-132 date-2.2c-133 date-2.2c-135 date-2.2c-136 date-2.2c-139 date-2.2c-142 date-2.2c-143 date-2.2c-145 date-2.2c-146 date-2.2c-149 date-2.2c-152 date-2.2c-155 date-2.2c-156 date-2.2c-159 date-2.2c-162 date-2.2c-165 date-2.2c-166 date-2.2c-168 date-2.2c-169 date-2.2c-172 date-2.2c-175 date-2.2c-178 date-2.2c-179 date-2.2c-182 date-2.2c-185 date-2.2c-188 date-2.2c-189 date-2.2c-191 date-2.2c-192 date-2.2c-195 date-2.2c-198 date-2.2c-199 date-2.2c-201 date-2.2c-202 date-2.2c-205 date-2.2c-208 date-2.2c-211 date-2.2c-212 date-2.2c-214 date-2.2c-215 date-2.2c-218 date-2.2c-221 date-2.2c-222 date-2.2c-224 date-2.2c-225 date-2.2c-228 date-2.2c-231 date-2.2c-234 date-2.2c-235 date-2.2c-237 date-2.2c-238 date-2.2c-241 date-2.2c-244 date-2.2c-245 date-2.2c-247 date-2.2c-248 date-2.2c-251 date-2.2c-254 date-2.2c-257 date-2.2c-258 date-2.2c-260 date-2.2c-261 date-2.2c-264 date-2.2c-267 date-2.2c-268 date-2.2c-270 date-2.2c-271 date-2.2c-274 date-2.2c-277 date-2.2c-280 date-2.2c-281 date-2.2c-284 date-2.2c-287 date-2.2c-290 date-2.2c-291 date-2.2c-293 date-2.2c-294 date-2.2c-297 date-2.2c-300 date-2.2c-303 date-2.2c-304 date-2.2c-307 date-2.2c-310 date-2.2c-313 date-2.2c-314 date-2.2c-316 date-2.2c-317 date-2.2c-320 date-2.2c-323 date-2.2c-324 date-2.2c-326 date-2.2c-327 date-2.2c-330 date-2.2c-333 date-2.2c-336 date-2.2c-337 date-2.2c-339 date-2.2c-340 date-2.2c-343 date-2.2c-346 date-2.2c-347 date-2.2c-349 date-2.2c-350 date-2.2c-353 date-2.2c-356 date-2.2c-359 date-2.2c-360 date-2.2c-362 date-2.2c-363 date-2.2c-366 date-2.2c-369 date-2.2c-370 date-2.2c-372 date-2.2c-373 date-2.2c-376 date-2.2c-379 date-2.2c-382 date-2.2c-383 date-2.2c-385 date-2.2c-386 date-2.2c-389 date-2.2c-392 date-2.2c-393 date-2.2c-395 date-2.2c-396 date-2.2c-399 date-2.2c-402 date-2.2c-405 date-2.2c-406 date-2.2c-409 date-2.2c-412 date-2.2c-415 date-2.2c-416 date-2.2c-418 date-2.2c-419 date-2.2c-422 date-2.2c-425 date-2.2c-428 date-2.2c-429 date-2.2c-432 date-2.2c-435 date-2.2c-438 date-2.2c-439 date-2.2c-441 date-2.2c-442 date-2.2c-445 date-2.2c-448 date-2.2c-449 date-2.2c-451 date-2.2c-452 date-2.2c-455 date-2.2c-458 date-2.2c-461 date-2.2c-462 date-2.2c-464 date-2.2c-465 date-2.2c-468 date-2.2c-471 date-2.2c-472 date-2.2c-474 date-2.2c-475 date-2.2c-478 date-2.2c-481 date-2.2c-484 date-2.2c-485 date-2.2c-487 date-2.2c-488 date-2.2c-491 date-2.2c-494 date-2.2c-495 date-2.2c-497 date-2.2c-498 date-2.2c-501 date-2.2c-504 date-2.2c-507 date-2.2c-508 date-2.2c-510 date-2.2c-511 date-2.2c-514 date-2.2c-517 date-2.2c-518 date-2.2c-520 date-2.2c-521 date-2.2c-524 date-2.2c-527 date-2.2c-530 date-2.2c-531 date-2.2c-534 date-2.2c-537 date-2.2c-540 date-2.2c-541 date-2.2c-543 date-2.2c-544 date-2.2c-547 date-2.2c-550 date-2.2c-553 date-2.2c-554 date-2.2c-557 date-2.2c-560 date-2.2c-563 date-2.2c-564 date-2.2c-566 date-2.2c-567 date-2.2c-570 date-2.2c-573 date-2.2c-574 date-2.2c-576 date-2.2c-577 date-2.2c-580 date-2.2c-583 date-2.2c-586 date-2.2c-587 date-2.2c-589 date-2.2c-590 date-2.2c-593 date-2.2c-596 date-2.2c-597 date-2.2c-599 date-2.2c-600 date-2.2c-603 date-2.2c-606 date-2.2c-609 date-2.2c-610 date-2.2c-612 date-2.2c-613 date-2.2c-616 date-2.2c-619 date-2.2c-620 date-2.2c-622 date-2.2c-623 date-2.2c-626 date-2.2c-629 date-2.2c-632 date-2.2c-633 date-2.2c-635 date-2.2c-636 date-2.2c-639 date-2.2c-642 date-2.2c-643 date-2.2c-645 date-2.2c-646 date-2.2c-649 date-2.2c-652 date-2.2c-655 date-2.2c-656 date-2.2c-659 date-2.2c-662 date-2.2c-665 date-2.2c-666 date-2.2c-668 date-2.2c-669 date-2.2c-672 date-2.2c-675 date-2.2c-678 date-2.2c-679 date-2.2c-682 date-2.2c-685 date-2.2c-688 date-2.2c-689 date-2.2c-691 date-2.2c-692 date-2.2c-695 date-2.2c-698 date-2.2c-699 date-2.2c-701 date-2.2c-702 date-2.2c-705 date-2.2c-708 date-2.2c-711 date-2.2c-712 date-2.2c-714 date-2.2c-715 date-2.2c-718 date-2.2c-721 date-2.2c-722 date-2.2c-724 date-2.2c-725 date-2.2c-728 date-2.2c-731 date-2.2c-734 date-2.2c-735 date-2.2c-737 date-2.2c-738 date-2.2c-741 date-2.2c-744 date-2.2c-745 date-2.2c-747 date-2.2c-748 date-2.2c-751 date-2.2c-754 date-2.2c-757 date-2.2c-758 date-2.2c-760 date-2.2c-761 date-2.2c-764 date-2.2c-767 date-2.2c-768 date-2.2c-770 date-2.2c-771 date-2.2c-774 date-2.2c-777 date-2.2c-780 date-2.2c-781 date-2.2c-784 date-2.2c-787 date-2.2c-790 date-2.2c-791 date-2.2c-793 date-2.2c-794 date-2.2c-797 date-2.2c-800 date-2.2c-803 date-2.2c-804 date-2.2c-807 date-2.2c-810 date-2.2c-813 date-2.2c-814 date-2.2c-816 date-2.2c-817 date-2.2c-820 date-2.2c-823 date-2.2c-824 date-2.2c-826 date-2.2c-827 date-2.2c-830 date-2.2c-833 date-2.2c-836 date-2.2c-837 date-2.2c-839 date-2.2c-840 date-2.2c-843 date-2.2c-846 date-2.2c-847 date-2.2c-849 date-2.2c-850 date-2.2c-853 date-2.2c-856 date-2.2c-859 date-2.2c-860 date-2.2c-862 date-2.2c-863 date-2.2c-866 date-2.2c-869 date-2.2c-870 date-2.2c-872 date-2.2c-873 date-2.2c-876 date-2.2c-879 date-2.2c-882 date-2.2c-883 date-2.2c-885 date-2.2c-886 date-2.2c-889 date-2.2c-892 date-2.2c-893 date-2.2c-895 date-2.2c-896 date-2.2c-899 date-2.2c-902 date-2.2c-905 date-2.2c-906 date-2.2c-909 date-2.2c-912 date-2.2c-915 date-2.2c-916 date-2.2c-918 date-2.2c-919 date-2.2c-922 date-2.2c-925 date-2.2c-928 date-2.2c-929 date-2.2c-932 date-2.2c-935 date-2.2c-938 date-2.2c-939 date-2.2c-941 date-2.2c-942 date-2.2c-945 date-2.2c-948 date-2.2c-949 date-2.2c-951 date-2.2c-952 date-2.2c-955 date-2.2c-958 date-2.2c-961 date-2.2c-962 date-2.2c-964 date-2.2c-965 date-2.2c-968 date-2.2c-971 date-2.2c-972 date-2.2c-974 date-2.2c-975 date-2.2c-978 date-2.2c-981 date-2.2c-984 date-2.2c-985 date-2.2c-987 date-2.2c-988 date-2.2c-991 date-2.2c-994 date-2.2c-995 date-2.2c-997 date-2.2c-998
All memory allocations freed - no leaks
Maximum memory usage: 120112 bytes
Current memory usage: 0 bytes
Number of malloc()  : -1 calls
make: *** [Makefile:1122: tcltest] Error 1
 * ERROR: dev-db/sqlite-3.19.3::gentoo failed (test phase):
 *   emake failed



Portage 2.3.6 (python 3.4.5-final-0, default/linux/x86/13.0, gcc-5.4.0, glibc-2.23-r4, 4.12.5-gentoo i686)
=================================================================
System uname: Linux-4.12.5-gentoo-i686-Intel-R-_Core-TM-_i7-3770K_CPU_@_3.50GHz-with-gentoo-2.3
KiB Mem:     3108120 total,   1192896 free
KiB Swap:     488276 total,    488276 free
Timestamp of repository gentoo: Fri, 18 Aug 2017 18:43:58 +0000
sh bash 4.3_p48-r1
ld GNU ld (Gentoo 2.26.1 p1.0) 2.26.1
app-shells/bash:          4.3_p48-r1::gentoo
dev-java/java-config:     2.2.0-r3::gentoo
dev-lang/perl:            5.24.1-r2::gentoo
dev-lang/python:          2.7.12::gentoo, 3.4.5::gentoo
dev-util/cmake:           3.7.2::gentoo
dev-util/pkgconfig:       0.28-r2::gentoo
sys-apps/baselayout:      2.3::gentoo
sys-apps/openrc:          0.28::gentoo
sys-apps/sandbox:         2.10-r3::gentoo
sys-devel/autoconf:       2.69::gentoo
sys-devel/automake:       1.13.4::gentoo, 1.15-r2::gentoo
sys-devel/binutils:       2.26.1::gentoo, 2.28-r2::gentoo
sys-devel/gcc:            5.4.0-r3::gentoo
sys-devel/gcc-config:     1.7.3::gentoo
sys-devel/libtool:        2.4.6-r3::gentoo
sys-devel/make:           4.2.1::gentoo
sys-kernel/linux-headers: 4.4::gentoo (virtual/os-headers)
sys-libs/glibc:           2.23-r4::gentoo
Repositories:

gentoo
    location: /usr/portage
    sync-type: git
    sync-uri: https://github.com/gentoo-mirror/gentoo.git
    priority: -1000

whissi-overlay
    location: /usr/overlays/whissi-overlay
    sync-type: git
    sync-uri: https://github.com/Whissi/gentoo-overlay.git
    masters: gentoo

ABI="x86"
ABI_X86="32"
ACCEPT_KEYWORDS="x86"
ACCEPT_LICENSE="* -@EULA"
ACCEPT_PROPERTIES="*"
ACCEPT_RESTRICT="*"
ARCH="x86"
CBUILD="i686-pc-linux-gnu"
CFLAGS="-O2 -pipe -march=ivybridge -mtune=ivybridge -mno-xsaveopt"
CHOST="i686-pc-linux-gnu"
CHOST_x86="i686-pc-linux-gnu"
COLLISION_IGNORE="/lib/modules/* *.py[co] *$py.class */dropin.cache"
CONFIG_PROTECT="/etc /usr/share/gnupg/qualified.txt"
CPU_FLAGS_X86="aes avx mmx mmxext popcnt sse sse2 sse3 sse4_1 sse4_2 ssse3"
CXXFLAGS="-O2 -pipe -march=ivybridge -mtune=ivybridge -mno-xsaveopt"
DEFAULT_ABI="x86"
EDITOR="/usr/bin/mcedit"
ELIBC="glibc"
EPREFIX=""
EROOT="/"
FCFLAGS="-O2 -march=i686 -pipe"
FEATURES="assume-digests binpkg-logs cgroup config-protect-if-modified distlocks downgrade-backup ebuild-locks fixlafiles merge-sync news parallel-fetch preserve-libs protect-owned sandbox sfperms strict unknown-features-warn unmerge-logs unmerge-orphans userfetch userpriv usersandbox usersync xattr"
FFLAGS="-O2 -march=i686 -pipe"
GCC_SPECS=""
GRUB_PLATFORMS="efi-32 pc"
GSETTINGS_BACKEND="dconf"
HOME="/root"
INFOPATH="/usr/share/info:/usr/share/gcc-data/i686-pc-linux-gnu/5.4.0/info:/usr/share/binutils-data/i686-pc-linux-gnu/2.26.1/info"
INPUT_DEVICES="libinput keyboard mouse"
IUSE_IMPLICIT="abi_x86_32 prefix prefix-chain prefix-guest"
JAVAC="/etc/java-config-2/current-system-vm/bin/javac"
JAVA_HOME="/etc/java-config-2/current-system-vm"
JDK_HOME="/etc/java-config-2/current-system-vm"
KERNEL="linux"
L10N="en en-US de de-DE"
LANG="en_US.UTF-8"
LC_ALL="en_US.UTF-8"
LC_MESSAGES="C"
LC_PAPER="de_DE.UTF-8"
LDFLAGS="-Wl,-O1 -Wl,--as-needed"
LIBDIR_x86="lib"
LINGUAS="en de"
LOGNAME="root"
MAIL="/var/mail/root"
MAKEOPTS="--jobs 5 --load-average 7.95"
MOZ_GMP_PATH="/usr/lib/nsbrowser/plugins/gmp-gmpopenh264/system-installed"
MULTILIB_ABIS="x86"
MULTIOSDIRS="../lib"
NOCOLOR="true"
OFFICE_IMPLEMENTATION="libreoffice"
OPENGL_PROFILE="xorg-x11"
PAGER="/usr/bin/less"
PATH="/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/opt/bin:/usr/i686-pc-linux-gnu/gcc-bin/5.4.0"
PHP_TARGETS="php5-6"
POSTGRES_TARGETS="postgres9_5"
PWD="/root"
PYTHONDONTWRITEBYTECODE="1"
PYTHON_SINGLE_TARGET="python3_4"
PYTHON_TARGETS="python2_7 python3_4"
ROOT="/"
ROOTPATH="/opt/bin:/usr/i686-pc-linux-gnu/gcc-bin/5.4.0"
RUBY_TARGETS="ruby21 ruby22"
SHELL="/bin/bash"
SHLVL="2"
SSH_TTY="/dev/pts/0"
TERM="screen"
TMUX="/tmp/tmux-0/default,4585,0"
TMUX_PANE="%1"
TWISTED_DISABLE_WRITING_OF_PLUGIN_CACHE="1"
USER="root"
USERLAND="GNU"
VIDEO_CARDS="intel"

Comment 1 Sergei Trofimovich (RETIRED) gentoo-dev

2017-09-20 21:01:44 UTC

I think test fails due to slight precision variation
caused by FPU being 80-bit internally.

If we add the following to CFLAGS, then:
-mfpmath=387 (default on i686): test fails
-mfpmath=sse (default on x86_64): test passes

Quick reproduce howto:

$ ./configure CFLAGS="-O2 -m32 -mfpmath=387" LDFLAGS=-m32
$ make testfixture
$ ./testfixture test/date.test

Sent email to sqlite-users@mailinglists.sqlite.org with subject
"sqlite-3.20.1: test/date.test fails on i686 target due to FPU wibbles"
as a bug report.

Comment 2 Arfrever Frehtes Taifersar Arahesis 2017-09-27 20:47:27 UTC

*** Bug 632002 has been marked as a duplicate of this bug. ***

Comment 3 Arfrever Frehtes Taifersar Arahesis 2017-09-28 17:44:33 UTC

Fixed:

https://gitweb.gentoo.org/repo/gentoo.git/commit/?id=4ab48e6c1f373ae3f56773a1b9fc31845576d705

Comment 4 Arfrever Frehtes Taifersar Arahesis 2017-10-26 20:57:02 UTC

In SQLite 3.21.0 on x86-32 with default CFLAGS, date-2.2c-* tests still fail and 3 new tests (e_expr-32.2.5, e_expr-32.2.6, e_expr-32.2.8) fail:


! e_expr-32.2.5 expected: [integer 9223372036854775807]
! e_expr-32.2.5 got:      [real 9.22337203685478e+18]
! e_expr-32.2.6 expected: [integer 9223372036854775807]
! e_expr-32.2.6 got:      [real 9.22337203685478e+18]
! e_expr-32.2.8 expected: [integer 9000000000000000001 integer 9000000000000000001 integer 9000000000000000001 integer 9000000000000000001 integer 9000000000000000001 integer 9000000000000000001 integer 9223372036854775807 integer 9223372036854775807 integer 9223372036854775807 real 9.22337203685478e+18 real 9.22337203685478e+18 integer 9223372036854775807 integer 9223372036854775807 integer -5 integer -5]
! e_expr-32.2.8 got:      [integer 9000000000000000001 real 9.0e+18 real 9.0e+18 real 9.0e+18 integer 9000000000000000001 real 9.0e+18 integer 9223372036854775807 real 9.22337203685478e+18 real 9.22337203685478e+18 real 9.22337203685478e+18 real 9.22337203685478e+18 real 9.22337203685478e+18 real 9.22337203685478e+18 integer -5 integer -5]


date-2.2c-* tests will be re-enabled.

The planned solution (in SQLite >=3.21.0) is generally:
  If SSE supported:
    Use -mfpmath=sse
  Else:
    Use -ffloat-store

Comment 5 Toralf Förster gentoo-dev

2017-11-30 19:19:10 UTC

got at the unstable amd64 chroot image 17.0-desktop-plasma-systemd_libressl-test_20171129-194156 this : make: *** [Makefile:<snip>: tcltest] Error 1

Comment 6 Toralf Förster gentoo-dev

2017-11-30 19:19:13 UTC

Created attachment 507282 [details]
emerge-info.txt

Comment 7 Toralf Förster gentoo-dev

2017-11-30 19:19:16 UTC

Created attachment 507284 [details]
dev-db:sqlite-3.21.0:20171130-003752.log

Comment 8 Toralf Förster gentoo-dev

2017-11-30 19:19:19 UTC

Created attachment 507286 [details]
emerge-history.txt

Comment 9 Toralf Förster gentoo-dev

2017-11-30 19:19:22 UTC

Created attachment 507288 [details]
environment

Comment 10 Toralf Förster gentoo-dev

2017-11-30 19:19:25 UTC

Created attachment 507290 [details]
etc.portage.tbz2

Comment 11 Toralf Förster gentoo-dev

2017-11-30 19:19:28 UTC

Created attachment 507292 [details]
logs.tbz2

Comment 12 Toralf Förster gentoo-dev

2017-11-30 19:19:31 UTC

Created attachment 507294 [details]
temp.tbz2

Comment 13 Arfrever Frehtes Taifersar Arahesis 2017-11-30 19:24:08 UTC

This is unrelated. Your log shows failure of fts3expr4-1.8 test, not date-2.2c-* tests.

Comment 14 Arfrever Frehtes Taifersar Arahesis 2017-11-30 19:50:21 UTC

*** Bug 632002 has been marked as a duplicate of this bug. ***