Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

sqlite: 3.24.0 -> 3.25.3 #46852

Merged
merged 5 commits into from Nov 19, 2018
Merged

sqlite: 3.24.0 -> 3.25.3 #46852

merged 5 commits into from Nov 19, 2018

Conversation

dtzWill
Copy link
Member

@dtzWill dtzWill commented Sep 18, 2018

  • Tested using sandboxing (nix.useSandbox on NixOS, or option sandbox in nix.conf on non-NixOS)
  • Built on platform(s)
    • NixOS
    • macOS
    • other Linux distributions
  • Tested via one or more NixOS test(s) if existing and applicable for the change (look inside nixos/tests)
  • Tested compilation of all pkgs that depend on this change using nix-shell -p nox --run "nox-review wip"
  • Tested execution of all binary files (usually in ./result/bin/)
  • Determined the impact on package closure size (by running nix path-info -S before and after)
  • Fits CONTRIBUTING.md.

@GrahamcOfBorg
Copy link

Success on x86_64-linux (full log)

Attempted: sqlite

Partial log (click to expand)

checking for references to /build in /nix/store/67i2kj53v90x0rsb9ily4aq8bppp6m9p-sqlite-3.25.0-dev...
separating debug info from /nix/store/xddjmwpc98p6yfg0w51jpsmpsh5j370j-sqlite-3.25.0/lib/libsqlite3.so.0.8.6 (build ID 2f7883dc335037379e969ff5f8c7c6a9837bb8c4)
shrinking RPATHs of ELF executables and libraries in /nix/store/xddjmwpc98p6yfg0w51jpsmpsh5j370j-sqlite-3.25.0
shrinking /nix/store/xddjmwpc98p6yfg0w51jpsmpsh5j370j-sqlite-3.25.0/lib/libsqlite3.so.0.8.6
patching script interpreter paths in /nix/store/xddjmwpc98p6yfg0w51jpsmpsh5j370j-sqlite-3.25.0
checking for references to /build in /nix/store/xddjmwpc98p6yfg0w51jpsmpsh5j370j-sqlite-3.25.0...
shrinking RPATHs of ELF executables and libraries in /nix/store/m11ahgp8f276ffjqfr563cbz9p31qzj6-sqlite-3.25.0-debug
patching script interpreter paths in /nix/store/m11ahgp8f276ffjqfr563cbz9p31qzj6-sqlite-3.25.0-debug
checking for references to /build in /nix/store/m11ahgp8f276ffjqfr563cbz9p31qzj6-sqlite-3.25.0-debug...
/nix/store/gwi9rzfg2ps0kyl3gycamjl1dy9iqx6z-sqlite-3.25.0-bin

@GrahamcOfBorg
Copy link

Success on aarch64-linux (full log)

Attempted: sqlite

Partial log (click to expand)

checking for references to /build in /nix/store/6vpar39b5pq43fir8rabbam8b1s3rzg1-sqlite-3.25.0-dev...
separating debug info from /nix/store/fgdxja5fh58jl3vmsjpsmr9clhfcrc02-sqlite-3.25.0/lib/libsqlite3.so.0.8.6 (build ID 41d5815c63d6e6bc76a9b61b3b2114941a4ef25c)
shrinking RPATHs of ELF executables and libraries in /nix/store/fgdxja5fh58jl3vmsjpsmr9clhfcrc02-sqlite-3.25.0
shrinking /nix/store/fgdxja5fh58jl3vmsjpsmr9clhfcrc02-sqlite-3.25.0/lib/libsqlite3.so.0.8.6
patching script interpreter paths in /nix/store/fgdxja5fh58jl3vmsjpsmr9clhfcrc02-sqlite-3.25.0
checking for references to /build in /nix/store/fgdxja5fh58jl3vmsjpsmr9clhfcrc02-sqlite-3.25.0...
shrinking RPATHs of ELF executables and libraries in /nix/store/59jc81filcccvyzdhjnqkngr5pjhj66f-sqlite-3.25.0-debug
patching script interpreter paths in /nix/store/59jc81filcccvyzdhjnqkngr5pjhj66f-sqlite-3.25.0-debug
checking for references to /build in /nix/store/59jc81filcccvyzdhjnqkngr5pjhj66f-sqlite-3.25.0-debug...
/nix/store/4ll9hcmpzj8q24lcxj00rx5ndvnhw0f3-sqlite-3.25.0-bin

@GrahamcOfBorg
Copy link

Timed out, unknown build status on x86_64-darwin (full log)

Attempted: sqlite

Partial log (click to expand)

cannot build derivation '/nix/store/hncycl0hwqhz4k1nskbj9z3va56rzgw2-mirrors-list.drv': 2 dependencies couldn't be built
cannot build derivation '/nix/store/40qfc0rqc05lz3a228p4dpmzx34cxsyh-perl-5.28.0.drv': 4 dependencies couldn't be built
cannot build derivation '/nix/store/gf2kqgkp29kl7dm54wil5i70fhi35gjc-pkg-config-0.29.2.drv': 3 dependencies couldn't be built
cannot build derivation '/nix/store/8vahfvw3hsrrnwl8hagn23y5wfnkzma8-openssl-1.0.2p.drv': 3 dependencies couldn't be built
cannot build derivation '/nix/store/q3hic5qy9ahmk4rx4w79lrb1rr84j839-libssh2-1.8.0.drv': 4 dependencies couldn't be built
cannot build derivation '/nix/store/vbb7d8gvyq40x3917hrbfn7q6nl3xd94-nghttp2-1.32.0.drv': 7 dependencies couldn't be built
cannot build derivation '/nix/store/jxv994dmlciv5d24cljf2akgvvg9wcsh-curl-7.61.1.drv': 8 dependencies couldn't be built
cannot build derivation '/nix/store/1pl57a10x46j4pn1fysr7nykln97l712-sqlite-autoconf-3250000.tar.gz.drv': 4 dependencies couldn't be built
cannot build derivation '/nix/store/a0j9kbd77afdcpm5qmykxdckg9hxj2k8-sqlite-3.25.0.drv': 4 dependencies couldn't be built
error: build of '/nix/store/a0j9kbd77afdcpm5qmykxdckg9hxj2k8-sqlite-3.25.0.drv' failed

@dtzWill dtzWill changed the title sqlite: 3.24.0 -> 3.25.0 sqlite: 3.24.0 -> 3.25.1 Sep 19, 2018
@GrahamcOfBorg
Copy link

Success on x86_64-linux (full log)

Attempted: sqlite

Partial log (click to expand)

checking for references to /build in /nix/store/k14yi9vpl388lxny4b5fcz3k0679q5z6-sqlite-3.25.1-dev...
separating debug info from /nix/store/dxn11jhnlbw43cygwbqk7iimlpf7jfar-sqlite-3.25.1/lib/libsqlite3.so.0.8.6 (build ID c43a54b515da070d22e41ab972a135198f810874)
shrinking RPATHs of ELF executables and libraries in /nix/store/dxn11jhnlbw43cygwbqk7iimlpf7jfar-sqlite-3.25.1
shrinking /nix/store/dxn11jhnlbw43cygwbqk7iimlpf7jfar-sqlite-3.25.1/lib/libsqlite3.so.0.8.6
patching script interpreter paths in /nix/store/dxn11jhnlbw43cygwbqk7iimlpf7jfar-sqlite-3.25.1
checking for references to /build in /nix/store/dxn11jhnlbw43cygwbqk7iimlpf7jfar-sqlite-3.25.1...
shrinking RPATHs of ELF executables and libraries in /nix/store/n2xgrmaln92d06lyggx7zcyz8vfmllld-sqlite-3.25.1-debug
patching script interpreter paths in /nix/store/n2xgrmaln92d06lyggx7zcyz8vfmllld-sqlite-3.25.1-debug
checking for references to /build in /nix/store/n2xgrmaln92d06lyggx7zcyz8vfmllld-sqlite-3.25.1-debug...
/nix/store/5f66mlpxzrd7abwr2ql9kqyf99hp4nli-sqlite-3.25.1-bin

@GrahamcOfBorg
Copy link

Success on aarch64-linux (full log)

Attempted: sqlite

Partial log (click to expand)

checking for references to /build in /nix/store/3rdqvccjw0f8fr3asq0jvrz1sf0h7zgs-sqlite-3.25.1-dev...
separating debug info from /nix/store/djaahidnnbfk5lrz84xb2xgn4bch94wq-sqlite-3.25.1/lib/libsqlite3.so.0.8.6 (build ID fbdf4dc6abe1a59df6fb4ccfb8ad58ab04380e9e)
shrinking RPATHs of ELF executables and libraries in /nix/store/djaahidnnbfk5lrz84xb2xgn4bch94wq-sqlite-3.25.1
shrinking /nix/store/djaahidnnbfk5lrz84xb2xgn4bch94wq-sqlite-3.25.1/lib/libsqlite3.so.0.8.6
patching script interpreter paths in /nix/store/djaahidnnbfk5lrz84xb2xgn4bch94wq-sqlite-3.25.1
checking for references to /build in /nix/store/djaahidnnbfk5lrz84xb2xgn4bch94wq-sqlite-3.25.1...
shrinking RPATHs of ELF executables and libraries in /nix/store/ql6lzdqmkngycnkbj292qpmms3xp8qv8-sqlite-3.25.1-debug
patching script interpreter paths in /nix/store/ql6lzdqmkngycnkbj292qpmms3xp8qv8-sqlite-3.25.1-debug
checking for references to /build in /nix/store/ql6lzdqmkngycnkbj292qpmms3xp8qv8-sqlite-3.25.1-debug...
/nix/store/8j4gfy9l8i7d7ac0335br50ffg8xbw4f-sqlite-3.25.1-bin

@GrahamcOfBorg
Copy link

Timed out, unknown build status on x86_64-darwin (full log)

Attempted: sqlite

Partial log (click to expand)

cannot build derivation '/nix/store/hncycl0hwqhz4k1nskbj9z3va56rzgw2-mirrors-list.drv': 2 dependencies couldn't be built
cannot build derivation '/nix/store/40qfc0rqc05lz3a228p4dpmzx34cxsyh-perl-5.28.0.drv': 4 dependencies couldn't be built
cannot build derivation '/nix/store/gf2kqgkp29kl7dm54wil5i70fhi35gjc-pkg-config-0.29.2.drv': 3 dependencies couldn't be built
cannot build derivation '/nix/store/8vahfvw3hsrrnwl8hagn23y5wfnkzma8-openssl-1.0.2p.drv': 3 dependencies couldn't be built
cannot build derivation '/nix/store/q3hic5qy9ahmk4rx4w79lrb1rr84j839-libssh2-1.8.0.drv': 4 dependencies couldn't be built
cannot build derivation '/nix/store/vbb7d8gvyq40x3917hrbfn7q6nl3xd94-nghttp2-1.32.0.drv': 7 dependencies couldn't be built
cannot build derivation '/nix/store/jxv994dmlciv5d24cljf2akgvvg9wcsh-curl-7.61.1.drv': 8 dependencies couldn't be built
cannot build derivation '/nix/store/5arq6q81zg4a86wh8lyy9nix8g1n2wls-sqlite-autoconf-3250100.tar.gz.drv': 4 dependencies couldn't be built
cannot build derivation '/nix/store/99ljlzj7x404y479czwlrqj17gg89l6c-sqlite-3.25.1.drv': 4 dependencies couldn't be built
error: build of '/nix/store/99ljlzj7x404y479czwlrqj17gg89l6c-sqlite-3.25.1.drv' failed

@dtzWill
Copy link
Member Author

dtzWill commented Sep 24, 2018

SQLalchemy may need updating/fixing? Not sure.

@dtzWill dtzWill changed the title sqlite: 3.24.0 -> 3.25.1 sqlite: 3.24.0 -> 3.25.2 Sep 26, 2018
@GrahamcOfBorg
Copy link

Success on x86_64-linux (full log)

Attempted: sqlite

Partial log (click to expand)

checking for references to /build in /nix/store/xrg6y6m467z7blqr4qg2hjd4qv17sh1b-sqlite-3.25.2-dev...
separating debug info from /nix/store/fvrz0i12xhw5hsvzblv7lv0xizbsycbz-sqlite-3.25.2/lib/libsqlite3.so.0.8.6 (build ID 8963f383843d86690776fc7a0982e267dd343575)
shrinking RPATHs of ELF executables and libraries in /nix/store/fvrz0i12xhw5hsvzblv7lv0xizbsycbz-sqlite-3.25.2
shrinking /nix/store/fvrz0i12xhw5hsvzblv7lv0xizbsycbz-sqlite-3.25.2/lib/libsqlite3.so.0.8.6
patching script interpreter paths in /nix/store/fvrz0i12xhw5hsvzblv7lv0xizbsycbz-sqlite-3.25.2
checking for references to /build in /nix/store/fvrz0i12xhw5hsvzblv7lv0xizbsycbz-sqlite-3.25.2...
shrinking RPATHs of ELF executables and libraries in /nix/store/k2cqpdq8jihcf5w4sg02k9f7y7qvpxhj-sqlite-3.25.2-debug
patching script interpreter paths in /nix/store/k2cqpdq8jihcf5w4sg02k9f7y7qvpxhj-sqlite-3.25.2-debug
checking for references to /build in /nix/store/k2cqpdq8jihcf5w4sg02k9f7y7qvpxhj-sqlite-3.25.2-debug...
/nix/store/68ll37xkx4vrpykpx7i1s75bnm722zdc-sqlite-3.25.2-bin

@GrahamcOfBorg
Copy link

Success on x86_64-darwin (full log)

Attempted: sqlite

Partial log (click to expand)

strip is /nix/store/9xjkb4xz0b5lmizij9ppxy7lkxdxhx6b-cctools-binutils-darwin/bin/strip
stripping (with command strip and flags -S) in /nix/store/l57c162nnhj5170i5wc7v9iq49pqakkk-sqlite-3.25.2-bin/bin
patching script interpreter paths in /nix/store/l57c162nnhj5170i5wc7v9iq49pqakkk-sqlite-3.25.2-bin
strip is /nix/store/9xjkb4xz0b5lmizij9ppxy7lkxdxhx6b-cctools-binutils-darwin/bin/strip
stripping (with command strip and flags -S) in /nix/store/wvpxvzcx1br7k9ciz50ihnipnl60yxr5-sqlite-3.25.2-dev/lib
patching script interpreter paths in /nix/store/wvpxvzcx1br7k9ciz50ihnipnl60yxr5-sqlite-3.25.2-dev
strip is /nix/store/9xjkb4xz0b5lmizij9ppxy7lkxdxhx6b-cctools-binutils-darwin/bin/strip
stripping (with command strip and flags -S) in /nix/store/k3w7fxw55ld6bihmbi79wwqpw2gyv5yn-sqlite-3.25.2/lib
patching script interpreter paths in /nix/store/k3w7fxw55ld6bihmbi79wwqpw2gyv5yn-sqlite-3.25.2
/nix/store/l57c162nnhj5170i5wc7v9iq49pqakkk-sqlite-3.25.2-bin

@GrahamcOfBorg
Copy link

Timed out, unknown build status on aarch64-linux (full log)

Attempted: sqlite

Partial log (click to expand)

cannot build derivation '/nix/store/xcc6y4hx25hawrp46crvmp1whj4j0z1g-perl-5.28.0.drv': 4 dependencies couldn't be built
cannot build derivation '/nix/store/pv3jq1ggnmkyz5cspp31iws1jiwi54d7-pkg-config-0.29.2.drv': 2 dependencies couldn't be built
cannot build derivation '/nix/store/fy27ypmz0kkxld2n47cmgay53g4qxac0-openssl-1.0.2p.drv': 3 dependencies couldn't be built
cannot build derivation '/nix/store/4sv79wad0b08kkdkklf04c8k30qsh78z-libkrb5-1.15.2.drv': 6 dependencies couldn't be built
cannot build derivation '/nix/store/3bsnr4bqk6ai7jyfmnskybz77rhvz2sg-libssh2-1.8.0.drv': 3 dependencies couldn't be built
cannot build derivation '/nix/store/jng0m2idd609wj52vwipk7qayviy4kq9-nghttp2-1.32.0.drv': 6 dependencies couldn't be built
cannot build derivation '/nix/store/k7cjya3hw8nacczpkdkbzhpgj6s0jlbq-curl-7.61.1.drv': 8 dependencies couldn't be built
cannot build derivation '/nix/store/jdgyqnlhirv41rqz7z32rzk6zba8xy65-sqlite-autoconf-3250200.tar.gz.drv': 4 dependencies couldn't be built
cannot build derivation '/nix/store/67i57rjd2wnjvrq3bypsm8flb7gy2yqi-sqlite-3.25.2.drv': 3 dependencies couldn't be built
error: build of '/nix/store/67i57rjd2wnjvrq3bypsm8flb7gy2yqi-sqlite-3.25.2.drv' failed

@dtzWill
Copy link
Member Author

dtzWill commented Sep 26, 2018

pythonPackages.sqlalchemy fails a doctest for some reason, seems to happen with sqlite 3.25+ . Happens on current version of 1.2.11 as well as 1.2.12 and latest git. D'oh.

@dtzWill
Copy link
Member Author

dtzWill commented Sep 26, 2018

@GrahamcOfBorg build pythonPackages.sqlalchemy python3Packages.sqlalchemy

@GrahamcOfBorg
Copy link

Timed out, unknown build status on x86_64-darwin (full log)

Attempted: pythonPackages.sqlalchemy, python3Packages.sqlalchemy

Partial log (click to expand)

cannot build derivation '/nix/store/hikb9d7ci2lyrw2bnrvi37ycxzi706by-python3.6-pluggy-0.7.1.drv': 5 dependencies couldn't be built
cannot build derivation '/nix/store/363k1hqd3my8dm5vlb3j30k3sfc1n26y-python3.6-py-1.5.4.drv': 5 dependencies couldn't be built
cannot build derivation '/nix/store/dj4hl7hkrypglmxyz4skvfafzsdabbwx-python3.6-traceback2-1.4.0.drv': 6 dependencies couldn't be built
cannot build derivation '/nix/store/0ikjhck0vmjia4hw1lrrhhzy1yi4d76x-python2.7-SQLAlchemy-1.2.11.drv': 7 dependencies couldn't be built
cannot build derivation '/nix/store/vjcqvyj0hvpwl2s2dafy97c30xg7kfhf-python3.6-unittest2-1.1.0.drv': 6 dependencies couldn't be built
cannot build derivation '/nix/store/km6a5a1j58hhywhjdqgvjmvrl704d7sz-python3.6-funcsigs-1.0.2.drv': 5 dependencies couldn't be built
cannot build derivation '/nix/store/gixxcpi54qdm7lr47f8bf8fi7xzaik0h-python3.6-mock-2.0.0.drv': 8 dependencies couldn't be built
cannot build derivation '/nix/store/nnjpikvq99wfk1sjsb0r262mdq4fz4qa-python3.6-pytest-3.7.4.drv': 13 dependencies couldn't be built
cannot build derivation '/nix/store/pj9m99zngh0hkx0i2y6hb77cmqkvzbfk-python3.6-SQLAlchemy-1.2.11.drv': 6 dependencies couldn't be built
error: build of '/nix/store/0ikjhck0vmjia4hw1lrrhhzy1yi4d76x-python2.7-SQLAlchemy-1.2.11.drv', '/nix/store/pj9m99zngh0hkx0i2y6hb77cmqkvzbfk-python3.6-SQLAlchemy-1.2.11.drv' failed

@GrahamcOfBorg
Copy link

Timed out, unknown build status on x86_64-linux (full log)

Attempted: pythonPackages.sqlalchemy, python3Packages.sqlalchemy

Partial log (click to expand)

cannot build derivation '/nix/store/ff9az73wl690p4in22lp0si9jd4ii20p-python2.7-funcsigs-1.0.2.drv': 8 dependencies couldn't be built
cannot build derivation '/nix/store/va6dcqsgssdyipjc1yrhc2700icv2bnc-python3.6-funcsigs-1.0.2.drv': 8 dependencies couldn't be built
cannot build derivation '/nix/store/vqaff40sqvqznjcg8ld43k5hf6yjfr1i-python2.7-mock-2.0.0.drv': 11 dependencies couldn't be built
cannot build derivation '/nix/store/9qh0f3sl76kv44bp3shmdv720jmj7a10-python3.6-mock-2.0.0.drv': 11 dependencies couldn't be built
cannot build derivation '/nix/store/qazrw3vjbq1551xzxw26spvfjy557z95-python2.7-pathlib2-2.3.2.drv': 11 dependencies couldn't be built
cannot build derivation '/nix/store/4xrzis97qkhkzy6jap65angl8kvw8zbi-python3.6-pytest-3.7.4.drv': 17 dependencies couldn't be built
cannot build derivation '/nix/store/7i7hj862vn5i6pdzba9s32mpz17fjakw-python2.7-pytest-3.7.4.drv': 19 dependencies couldn't be built
cannot build derivation '/nix/store/97za44djsbh7awas8dgav8g71m94mr2y-python3.6-SQLAlchemy-1.2.11.drv': 9 dependencies couldn't be built
cannot build derivation '/nix/store/ar02xyk6blc91wsbb1wbr1j310z5n044-python2.7-SQLAlchemy-1.2.11.drv': 10 dependencies couldn't be built
error: build of '/nix/store/97za44djsbh7awas8dgav8g71m94mr2y-python3.6-SQLAlchemy-1.2.11.drv', '/nix/store/ar02xyk6blc91wsbb1wbr1j310z5n044-python2.7-SQLAlchemy-1.2.11.drv' failed

@GrahamcOfBorg
Copy link

Failure on aarch64-linux (full log)

Attempted: pythonPackages.sqlalchemy, python3Packages.sqlalchemy

Partial log (click to expand)

SKIP [1] /nix/store/q76nkdv4hzc255iwiz6bclp734kwnkpy-python2.7-SQLAlchemy-1.2.11/lib/python2.7/site-packages/sqlalchemy/testing/config.py:101: 'test_savepoint_lost_still_runs' : savepoints not supported
SKIP [3] /nix/store/q76nkdv4hzc255iwiz6bclp734kwnkpy-python2.7-SQLAlchemy-1.2.11/lib/python2.7/site-packages/sqlalchemy/testing/config.py:101: 'IdentityInsertTest' unsupported on any DB implementation 'sqlite(3.25.2)+pysqlite'
SKIP [15] /nix/store/q76nkdv4hzc255iwiz6bclp734kwnkpy-python2.7-SQLAlchemy-1.2.11/lib/python2.7/site-packages/sqlalchemy/testing/config.py:101: 'ExtractTest' unsupported on any DB implementation 'sqlite(3.25.2)+pysqlite'
SKIP [3] /nix/store/q76nkdv4hzc255iwiz6bclp734kwnkpy-python2.7-SQLAlchemy-1.2.11/lib/python2.7/site-packages/sqlalchemy/testing/config.py:101: 'TimestampTest' unsupported on any DB implementation 'sqlite(3.25.2)+pysqlite'
SKIP [1] /nix/store/q76nkdv4hzc255iwiz6bclp734kwnkpy-python2.7-SQLAlchemy-1.2.11/lib/python2.7/site-packages/sqlalchemy/testing/config.py:101: 'test_update_deleted_on_rollback' : savepoints not supported
SKIP [1] /nix/store/q76nkdv4hzc255iwiz6bclp734kwnkpy-python2.7-SQLAlchemy-1.2.11/lib/python2.7/site-packages/sqlalchemy/testing/config.py:101: 'test_lastrow_accessor_four' : no sequence support
FAIL test/base/test_tutorials.py::DocTest::()::test_core
===== 1 failed, 7883 passed, 912 skipped, 1 deselected in 1682.92 seconds ======
builder for '/nix/store/z0104b321g43qvi1jxmfhiyaamdsnaxl-python2.7-SQLAlchemy-1.2.11.drv' failed with exit code 1
error: build of '/nix/store/y06zpjfa4yghnyfjg9x73ihkb2rv6zka-python3.6-SQLAlchemy-1.2.11.drv', '/nix/store/z0104b321g43qvi1jxmfhiyaamdsnaxl-python2.7-SQLAlchemy-1.2.11.drv' failed

@lukateras
Copy link
Member

lukateras commented Oct 13, 2018

Rebased and bumped SQLAlchemy. Unfortunately, that didn't fix the failed test:

FAIL test/base/test_tutorials.py::DocTest::()::test_core
====== 1 failed, 7902 passed, 914 skipped, 1 deselected in 440.51 seconds ======
builder for '/nix/store/h190m2nwlm7q8h0j9d6z3a0dv9v6sv55-python2.7-SQLAlchemy-1.2.12.drv' failed with exit code 1
error: build of '/nix/store/h190m2nwlm7q8h0j9d6z3a0dv9v6sv55-python2.7-SQLAlchemy-1.2.12.drv' failed

@lukateras
Copy link
Member

**********************************************************************
File "core/tutorial.rst", line 1037, in core/tutorial.rst
Failed example:
    conn.execute(stmt).fetchall()
Expected:
    SELECT addresses.user_id, count(addresses.id) AS num_addresses
    FROM addresses ORDER BY num_addresses
    ()
    [(2, 4)]
Got:
    SELECT addresses.user_id, count(addresses.id) AS num_addresses
    FROM addresses ORDER BY num_addresses
    ()
    [(1, 4)]
2018-10-13 15:23:33,398 INFO sqlalchemy.engine.base.Engine SELECT addresses.user_id, count(addresses.id) AS num_addresses
FROM addresses ORDER BY num_addresses DESC
2018-10-13 15:23:33,398 INFO sqlalchemy.engine.base.Engine ()
**********************************************************************
File "core/tutorial.rst", line 1054, in core/tutorial.rst
Failed example:
    conn.execute(stmt).fetchall()
Expected:
    SELECT addresses.user_id, count(addresses.id) AS num_addresses
    FROM addresses ORDER BY num_addresses DESC
    ()
    [(2, 4)]
Got:
    SELECT addresses.user_id, count(addresses.id) AS num_addresses
    FROM addresses ORDER BY num_addresses DESC
    ()
    [(1, 4)]

@GrahamcOfBorg
Copy link

Success on aarch64-linux (full log)

Attempted: sqlite

Partial log (click to expand)

checking for references to /build in /nix/store/b584l2pr811mzwl7bhi4w49m0fj47rh1-sqlite-3.25.2-dev...
separating debug info from /nix/store/qvraw2yyd0kbg5zzf52rdandlcq76gj4-sqlite-3.25.2/lib/libsqlite3.so.0.8.6 (build ID 5efecbf849803a419d0fd3f5b40ed05f6097963b)
shrinking RPATHs of ELF executables and libraries in /nix/store/qvraw2yyd0kbg5zzf52rdandlcq76gj4-sqlite-3.25.2
shrinking /nix/store/qvraw2yyd0kbg5zzf52rdandlcq76gj4-sqlite-3.25.2/lib/libsqlite3.so.0.8.6
patching script interpreter paths in /nix/store/qvraw2yyd0kbg5zzf52rdandlcq76gj4-sqlite-3.25.2
checking for references to /build in /nix/store/qvraw2yyd0kbg5zzf52rdandlcq76gj4-sqlite-3.25.2...
shrinking RPATHs of ELF executables and libraries in /nix/store/yckd4hsfgli35az14wgn3467girdhkx8-sqlite-3.25.2-debug
patching script interpreter paths in /nix/store/yckd4hsfgli35az14wgn3467girdhkx8-sqlite-3.25.2-debug
checking for references to /build in /nix/store/yckd4hsfgli35az14wgn3467girdhkx8-sqlite-3.25.2-debug...
/nix/store/9q1mqgq3h27y7rlss1dr54vnvihbyprq-sqlite-3.25.2-bin

@GrahamcOfBorg
Copy link

Success on x86_64-linux (full log)

Attempted: sqlite

Partial log (click to expand)

checking for references to /build in /nix/store/50c8n40dbl0b9g89wvadyaqhlfhnf7va-sqlite-3.25.2-dev...
separating debug info from /nix/store/fq1l7fxcbz7xg9izjjhq9nqw73a48lxv-sqlite-3.25.2/lib/libsqlite3.so.0.8.6 (build ID 0160861ef00ef3d531b2befea79c07d4ddc8a964)
shrinking RPATHs of ELF executables and libraries in /nix/store/fq1l7fxcbz7xg9izjjhq9nqw73a48lxv-sqlite-3.25.2
shrinking /nix/store/fq1l7fxcbz7xg9izjjhq9nqw73a48lxv-sqlite-3.25.2/lib/libsqlite3.so.0.8.6
patching script interpreter paths in /nix/store/fq1l7fxcbz7xg9izjjhq9nqw73a48lxv-sqlite-3.25.2
checking for references to /build in /nix/store/fq1l7fxcbz7xg9izjjhq9nqw73a48lxv-sqlite-3.25.2...
shrinking RPATHs of ELF executables and libraries in /nix/store/0ian2mhm81dkfv4bdqnrl1v25ay4dpjr-sqlite-3.25.2-debug
patching script interpreter paths in /nix/store/0ian2mhm81dkfv4bdqnrl1v25ay4dpjr-sqlite-3.25.2-debug
checking for references to /build in /nix/store/0ian2mhm81dkfv4bdqnrl1v25ay4dpjr-sqlite-3.25.2-debug...
/nix/store/vq3cb9sv7jzpqkmg6dpqv294bzyjpgyx-sqlite-3.25.2-bin

@GrahamcOfBorg
Copy link

Timed out, unknown build status on x86_64-darwin (full log)

Attempted: sqlite

Partial log (click to expand)

cannot build derivation '/nix/store/2pqg437s35ymdgpr0d1sccnamml4ahi0-libev-4.24.drv': 1 dependencies couldn't be built
cannot build derivation '/nix/store/yf9nqiagblg664vynvbk2z1njkv0wp25-perl-5.28.0.drv': 3 dependencies couldn't be built
cannot build derivation '/nix/store/aalqxnh2znqdwz8q1b2l6wzwxzm5zf2j-pkg-config-0.29.2.drv': 1 dependencies couldn't be built
cannot build derivation '/nix/store/xfssaxzg03z04p23g1czyr4i6bvnik2d-openssl-1.0.2p.drv': 2 dependencies couldn't be built
cannot build derivation '/nix/store/aliq1vgh5sf5hfijaqmf0mc0ab3kknjl-libssh2-1.8.0.drv': 2 dependencies couldn't be built
cannot build derivation '/nix/store/h1ljgkawk8yh01i3603850fxh4vffa2p-nghttp2-1.32.0.drv': 5 dependencies couldn't be built
cannot build derivation '/nix/store/0782dybi3wk39b41j447mpc2cdfxh9ni-curl-7.61.1.drv': 6 dependencies couldn't be built
cannot build derivation '/nix/store/8baw1ajndaqd3mv2q0fd0yq661h42jwm-sqlite-autoconf-3250200.tar.gz.drv': 3 dependencies couldn't be built
cannot build derivation '/nix/store/0wrhw2i33blcnykxzn9jfa4yv1knrsmx-sqlite-3.25.2.drv': 2 dependencies couldn't be built
error: build of '/nix/store/0wrhw2i33blcnykxzn9jfa4yv1knrsmx-sqlite-3.25.2.drv' failed

@andir
Copy link
Member

andir commented Nov 15, 2018

We should probably open an issue with sqlalchemy? I think the behaviour might be undefined in this case. The first element of the tuple could be either value. If I am wrong then we still have an sqlite issue…

@dtzWill
Copy link
Member Author

dtzWill commented Nov 15, 2018 via email

@andir
Copy link
Member

andir commented Nov 15, 2018

@andir
Copy link
Member

andir commented Nov 16, 2018

We have a patch upstream that fixes this now: https://bitbucket.org/zzzeek/sqlalchemy/commits/63279a69e2b9277df5e97ace161fa3a1bb4f29cd/raw

I updated the branch to carry the fixes and squashed the SQLAlchemy change into one commit.

cc @dtzWill

@andir
Copy link
Member

andir commented Nov 16, 2018

@GrahamcOfBorg build python3Packages.sqlalchemy pythonPackages.sqlalchemy

@GrahamcOfBorg
Copy link

Success on aarch64-linux (full log)

Attempted: sqlite

Partial log (click to expand)

/nix/store/slvpzyzky20d57l68fqmizgbzmrm863c-sqlite-3.25.3-bin

@GrahamcOfBorg
Copy link

Success on x86_64-linux (full log)

Attempted: sqlite

Partial log (click to expand)

checking for references to /build in /nix/store/2p6aydks9kcsbvd0kvs0wr7xhdgws6b1-sqlite-3.25.3-dev...
separating debug info from /nix/store/h780przsv4f9d679dm0qmh7l55v95126-sqlite-3.25.3/lib/libsqlite3.so.0.8.6 (build ID d594a4bbbb3f5e87d385d0a41f11124be0572f14)
shrinking RPATHs of ELF executables and libraries in /nix/store/h780przsv4f9d679dm0qmh7l55v95126-sqlite-3.25.3
shrinking /nix/store/h780przsv4f9d679dm0qmh7l55v95126-sqlite-3.25.3/lib/libsqlite3.so.0.8.6
patching script interpreter paths in /nix/store/h780przsv4f9d679dm0qmh7l55v95126-sqlite-3.25.3
checking for references to /build in /nix/store/h780przsv4f9d679dm0qmh7l55v95126-sqlite-3.25.3...
shrinking RPATHs of ELF executables and libraries in /nix/store/17744756sgmzxw3w8sw3hdwnvn7zyy4g-sqlite-3.25.3-debug
patching script interpreter paths in /nix/store/17744756sgmzxw3w8sw3hdwnvn7zyy4g-sqlite-3.25.3-debug
checking for references to /build in /nix/store/17744756sgmzxw3w8sw3hdwnvn7zyy4g-sqlite-3.25.3-debug...
/nix/store/d761givjzbp477s2wl60m2664wcw5yna-sqlite-3.25.3-bin

@andir
Copy link
Member

andir commented Nov 16, 2018

Rebased and fixed the commit message for sqlalchemy to actually conform to our guidelines (and ofborg should now also build it automagically).

@GrahamcOfBorg
Copy link

Success on x86_64-linux (full log)

Attempted: python3Packages.sqlalchemy, pythonPackages.sqlalchemy

Partial log (click to expand)

SKIP [1] /nix/store/qxg41pgsfq36rag93ibphdikqr2mknjj-python3.7-SQLAlchemy-1.2.13/lib/python3.7/site-packages/sqlalchemy/testing/config.py:101: 'test_safe_reraise_py2k_warning' : Python version 2.xx is required.
SKIP [1] /nix/store/qxg41pgsfq36rag93ibphdikqr2mknjj-python3.7-SQLAlchemy-1.2.13/lib/python3.7/site-packages/sqlalchemy/testing/config.py:101: 'test_sql_expr_w_mods_bump' : sqlite doesn't support 'returning'
SKIP [1] /nix/store/qxg41pgsfq36rag93ibphdikqr2mknjj-python3.7-SQLAlchemy-1.2.13/lib/python3.7/site-packages/sqlalchemy/testing/config.py:101: 'test_versioncheck_for_update' : no FOR UPDATE NOWAIT support
SKIP [1] /nix/store/qxg41pgsfq36rag93ibphdikqr2mknjj-python3.7-SQLAlchemy-1.2.13/lib/python3.7/site-packages/sqlalchemy/testing/config.py:101: 'test_versioncheck_for_update_legacy' : no FOR UPDATE NOWAIT support
SKIP [2] /nix/store/qxg41pgsfq36rag93ibphdikqr2mknjj-python3.7-SQLAlchemy-1.2.13/lib/python3.7/site-packages/sqlalchemy/testing/config.py:101: 'ZooMarkTest' unsupported on any DB implementation 'sqlite(3.25.3)+pysqlite'

=========== 7912 passed, 912 skipped, 1 deselected in 387.10 seconds ===========
pytestcachePhase
/nix/store/qxg41pgsfq36rag93ibphdikqr2mknjj-python3.7-SQLAlchemy-1.2.13
/nix/store/ryrnf6v29f541rkdh61pagjrp6asjqf0-python2.7-SQLAlchemy-1.2.13

@GrahamcOfBorg
Copy link

Success on aarch64-linux (full log)

Attempted: python3Packages.sqlalchemy, pythonPackages.sqlalchemy

Partial log (click to expand)

SKIP [5] /nix/store/qj2qqaqsi09zaihsj3pvsia6zdw1bkkm-python2.7-SQLAlchemy-1.2.13/lib/python2.7/site-packages/sqlalchemy/testing/config.py:101: 'CTEDefaultTest' unsupported on any DB implementation 'sqlite(3.25.3)+pysqlite'custom function and not postgresql and not mssql and not oracle
SKIP [1] /nix/store/qj2qqaqsi09zaihsj3pvsia6zdw1bkkm-python2.7-SQLAlchemy-1.2.13/lib/python2.7/site-packages/sqlalchemy/testing/config.py:101: 'test_with_implicit_returning' : sqlite doesn't support 'returning'
SKIP [1] /nix/store/qj2qqaqsi09zaihsj3pvsia6zdw1bkkm-python2.7-SQLAlchemy-1.2.13/lib/python2.7/site-packages/sqlalchemy/testing/config.py:101: 'test_begin_begin_nested_rollback_commit' : savepoints not supported
SKIP [1] /nix/store/qj2qqaqsi09zaihsj3pvsia6zdw1bkkm-python2.7-SQLAlchemy-1.2.13/lib/python2.7/site-packages/sqlalchemy/testing/config.py:101: 'test_rollback_on_invalid_savepoint' : savepoints not supported
SKIP [7] /nix/store/qj2qqaqsi09zaihsj3pvsia6zdw1bkkm-python2.7-SQLAlchemy-1.2.13/lib/python2.7/site-packages/sqlalchemy/testing/config.py:101: 'PassiveDeletesTest' unsupported on any DB implementation 'sqlite(3.25.3)+pysqlite'not supported by database

=========== 7914 passed, 915 skipped, 1 deselected in 986.85 seconds ===========
pytestcachePhase
/nix/store/1pp72mbg84ii77rnv2m4l9p66knbykwn-python3.7-SQLAlchemy-1.2.13
/nix/store/qj2qqaqsi09zaihsj3pvsia6zdw1bkkm-python2.7-SQLAlchemy-1.2.13

@GrahamcOfBorg
Copy link

Success on aarch64-linux (full log)

Attempted: sqlite

Partial log (click to expand)

/nix/store/slvpzyzky20d57l68fqmizgbzmrm863c-sqlite-3.25.3-bin

@GrahamcOfBorg
Copy link

Success on x86_64-linux (full log)

Attempted: sqlite

Partial log (click to expand)

checking for references to /build in /nix/store/2p6aydks9kcsbvd0kvs0wr7xhdgws6b1-sqlite-3.25.3-dev...
separating debug info from /nix/store/h780przsv4f9d679dm0qmh7l55v95126-sqlite-3.25.3/lib/libsqlite3.so.0.8.6 (build ID d594a4bbbb3f5e87d385d0a41f11124be0572f14)
shrinking RPATHs of ELF executables and libraries in /nix/store/h780przsv4f9d679dm0qmh7l55v95126-sqlite-3.25.3
shrinking /nix/store/h780przsv4f9d679dm0qmh7l55v95126-sqlite-3.25.3/lib/libsqlite3.so.0.8.6
patching script interpreter paths in /nix/store/h780przsv4f9d679dm0qmh7l55v95126-sqlite-3.25.3
checking for references to /build in /nix/store/h780przsv4f9d679dm0qmh7l55v95126-sqlite-3.25.3...
shrinking RPATHs of ELF executables and libraries in /nix/store/17744756sgmzxw3w8sw3hdwnvn7zyy4g-sqlite-3.25.3-debug
patching script interpreter paths in /nix/store/17744756sgmzxw3w8sw3hdwnvn7zyy4g-sqlite-3.25.3-debug
checking for references to /build in /nix/store/17744756sgmzxw3w8sw3hdwnvn7zyy4g-sqlite-3.25.3-debug...
/nix/store/d761givjzbp477s2wl60m2664wcw5yna-sqlite-3.25.3-bin

@GrahamcOfBorg
Copy link

Timed out, unknown build status on x86_64-darwin (full log)

Attempted: python3Packages.sqlalchemy, pythonPackages.sqlalchemy

Partial log (click to expand)

cannot build derivation '/nix/store/z72an4xsc7zyzfgp6lyzvm5gi5m2v3xg-python3.7-pluggy-0.7.1.drv': 7 dependencies couldn't be built
cannot build derivation '/nix/store/v5agbd74ny2w4bzr2hcjnydbdz82l5wd-python3.7-py-1.7.0.drv': 7 dependencies couldn't be built
cannot build derivation '/nix/store/2n0lkbygx1hyzdmd8bmyv8b3653brvb3-python3.7-traceback2-1.4.0.drv': 8 dependencies couldn't be built
cannot build derivation '/nix/store/fzfbn5c5gfmajnsz0b2srhk904ni04yp-python2.7-SQLAlchemy-1.2.13.drv': 10 dependencies couldn't be built
cannot build derivation '/nix/store/6569jbfv7yxg1vi3850kfsqani8kxrr2-python3.7-unittest2-1.1.0.drv': 8 dependencies couldn't be built
cannot build derivation '/nix/store/hw5zgxsgdiq88ca9h0d89qqcxk9a7cwy-python3.7-funcsigs-1.0.2.drv': 7 dependencies couldn't be built
cannot build derivation '/nix/store/rd31pdvpk5sp3y18gg8miln00in7r386-python3.7-mock-2.0.0.drv': 10 dependencies couldn't be built
cannot build derivation '/nix/store/af82h6c35f2lbqcr07gpr6j7wbkb4f39-python3.7-pytest-3.9.3.drv': 16 dependencies couldn't be built
cannot build derivation '/nix/store/3d66ny9zw5cznyvmvhg1ksfb4768hcx7-python3.7-SQLAlchemy-1.2.13.drv': 9 dependencies couldn't be built
error: build of '/nix/store/3d66ny9zw5cznyvmvhg1ksfb4768hcx7-python3.7-SQLAlchemy-1.2.13.drv', '/nix/store/fzfbn5c5gfmajnsz0b2srhk904ni04yp-python2.7-SQLAlchemy-1.2.13.drv' failed

@GrahamcOfBorg
Copy link

Timed out, unknown build status on x86_64-darwin (full log)

Attempted: sqlite

Partial log (click to expand)

building of '/nix/store/s6w5xdj7hb4jj5znmagyq29kjw5gm152-llvm-5.0.2.drv' timed out after 3600 seconds
cannot build derivation '/nix/store/gbdak3p6v7cwq5s3j4bwd29l95y2zkjl-cctools-port-895.drv': 1 dependencies couldn't be built
cannot build derivation '/nix/store/9wz7d7nxi2yhvi5dhq0nzgwlsc0c14vn-clang-5.0.2.drv': 1 dependencies couldn't be built
cannot build derivation '/nix/store/372n5gnp6088yk92cikmdnsrqh6gb1zq-compiler-rt-5.0.2.drv': 1 dependencies couldn't be built
cannot build derivation '/nix/store/pna9s3cspkkx7qfbwl09dblwjgwn08hq-cctools-binutils-darwin.drv': 1 dependencies couldn't be built
cannot build derivation '/nix/store/5rzbmkg7za1rqbcv7blhjj0gqjwklcdh-cctools-binutils-darwin-wrapper.drv': 1 dependencies couldn't be built
cannot build derivation '/nix/store/w2j5zljrlpj07cgc4hq5xw0kl97b9hp4-clang-wrapper-5.0.2.drv': 3 dependencies couldn't be built
cannot build derivation '/nix/store/9y8c66lbibw5hic2bnc7pzpgkvc5pwwk-stdenv-darwin.drv': 7 dependencies couldn't be built
cannot build derivation '/nix/store/1pxdn70q4k9hns2hmw1rcxhdpq4qlrma-sqlite-3.25.3.drv': 1 dependencies couldn't be built
error: build of '/nix/store/1pxdn70q4k9hns2hmw1rcxhdpq4qlrma-sqlite-3.25.3.drv' failed

@GrahamcOfBorg
Copy link

Timed out, unknown build status on x86_64-darwin (full log)

Attempted: sqlite

Partial log (click to expand)

building of '/nix/store/s6w5xdj7hb4jj5znmagyq29kjw5gm152-llvm-5.0.2.drv' timed out after 3600 seconds
cannot build derivation '/nix/store/gbdak3p6v7cwq5s3j4bwd29l95y2zkjl-cctools-port-895.drv': 1 dependencies couldn't be built
cannot build derivation '/nix/store/9wz7d7nxi2yhvi5dhq0nzgwlsc0c14vn-clang-5.0.2.drv': 1 dependencies couldn't be built
cannot build derivation '/nix/store/372n5gnp6088yk92cikmdnsrqh6gb1zq-compiler-rt-5.0.2.drv': 1 dependencies couldn't be built
cannot build derivation '/nix/store/pna9s3cspkkx7qfbwl09dblwjgwn08hq-cctools-binutils-darwin.drv': 1 dependencies couldn't be built
cannot build derivation '/nix/store/5rzbmkg7za1rqbcv7blhjj0gqjwklcdh-cctools-binutils-darwin-wrapper.drv': 1 dependencies couldn't be built
cannot build derivation '/nix/store/w2j5zljrlpj07cgc4hq5xw0kl97b9hp4-clang-wrapper-5.0.2.drv': 3 dependencies couldn't be built
cannot build derivation '/nix/store/9y8c66lbibw5hic2bnc7pzpgkvc5pwwk-stdenv-darwin.drv': 7 dependencies couldn't be built
cannot build derivation '/nix/store/1pxdn70q4k9hns2hmw1rcxhdpq4qlrma-sqlite-3.25.3.drv': 1 dependencies couldn't be built
error: build of '/nix/store/1pxdn70q4k9hns2hmw1rcxhdpq4qlrma-sqlite-3.25.3.drv' failed

@dtzWill
Copy link
Member Author

dtzWill commented Nov 16, 2018

Wow, that's great! LGTM, rebuilding with this now! (but no reason to wait for that)

@andir
Copy link
Member

andir commented Nov 16, 2018

@dtzWill It doesn't hurt if we wait for that. Just hit the button whenever you are happy ;-)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging this pull request may close these issues.

None yet

4 participants