Test failures with Python 3.7

Issue #4291 resolved
Robert Schütz
created an issue

When I run the tests of SQLAlchemy's latest version using Python 3.7, I get

============================= test session starts ==============================
platform linux -- Python 3.7.0, pytest-3.6.2, py-1.5.3, pluggy-0.6.0 -- /nix/store/3hkchkmcz4kjldka2jpvfibpz12w847g-python3-3.7.0/bin/python3.7m
cachedir: .pytest_cache
rootdir: /build/SQLAlchemy-1.2.8, inifile: setup.cfg
collecting ...
==================================== ERRORS ====================================
_____________ ERROR collecting test/aaa_profiling/test_memusage.py _____________
test/aaa_profiling/test_memusage.py:168: in <module>
    class MemUsageTest(EnsureZeroed):
test/aaa_profiling/test_memusage.py:182: in MemUsageTest
    @testing.requires.cextensions
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/testing/exclusions.py:96: in __call__
    decorated = decorate(fn)
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:128: in decorate
    metadata.update(format_argspec_plus(spec, grouped=False))
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:374: in format_argspec_plus
    args = inspect.formatargspec(*spec)
/nix/store/3hkchkmcz4kjldka2jpvfibpz12w847g-python3-3.7.0/lib/python3.7/inspect.py:1225: in formatargspec
    stacklevel=2)
E   DeprecationWarning: `formatargspec` is deprecated since Python 3.5. Use `signature` and the `Signature` object directly
__________________ ERROR collecting test/base/test_events.py ___________________
test/base/test_events.py:1094: in <module>
    class RemovalTest(fixtures.TestBase):
test/base/test_events.py:1247: in RemovalTest
    @testing.requires.predictable_gc
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/testing/exclusions.py:96: in __call__
    decorated = decorate(fn)
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:128: in decorate
    metadata.update(format_argspec_plus(spec, grouped=False))
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:374: in format_argspec_plus
    args = inspect.formatargspec(*spec)
/nix/store/3hkchkmcz4kjldka2jpvfibpz12w847g-python3-3.7.0/lib/python3.7/inspect.py:1225: in formatargspec
    stacklevel=2)
E   DeprecationWarning: `formatargspec` is deprecated since Python 3.5. Use `signature` and the `Signature` object directly
___________________ ERROR collecting test/base/test_utils.py ___________________
test/base/test_utils.py:135: in <module>
    class WeakSequenceTest(fixtures.TestBase):
test/base/test_utils.py:136: in WeakSequenceTest
    @testing.requires.predictable_gc
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/testing/exclusions.py:96: in __call__
    decorated = decorate(fn)
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:128: in decorate
    metadata.update(format_argspec_plus(spec, grouped=False))
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:374: in format_argspec_plus
    args = inspect.formatargspec(*spec)
/nix/store/3hkchkmcz4kjldka2jpvfibpz12w847g-python3-3.7.0/lib/python3.7/inspect.py:1225: in formatargspec
    stacklevel=2)
E   DeprecationWarning: `formatargspec` is deprecated since Python 3.5. Use `signature` and the `Signature` object directly
________________ ERROR collecting test/dialect/test_firebird.py ________________
test/dialect/test_firebird.py:3: in <module>
    from sqlalchemy.databases import firebird
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/databases/__init__.py:13: in <module>
    from ..dialects.postgresql import base as postgresql
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/postgresql/__init__.py:8: in <module>
    from . import base, psycopg2, pg8000, pypostgresql, pygresql, \
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/postgresql/base.py:2153: in <module>
    class PGDialect(default.DefaultDialect):
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/postgresql/base.py:2436: in PGDialect
    def get_table_oid(self, connection, table_name, schema=None, **kw):
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:128: in decorate
    metadata.update(format_argspec_plus(spec, grouped=False))
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:374: in format_argspec_plus
    args = inspect.formatargspec(*spec)
/nix/store/3hkchkmcz4kjldka2jpvfibpz12w847g-python3-3.7.0/lib/python3.7/inspect.py:1225: in formatargspec
    stacklevel=2)
E   DeprecationWarning: `formatargspec` is deprecated since Python 3.5. Use `signature` and the `Signature` object directly
_________________ ERROR collecting test/dialect/test_sqlite.py _________________
test/dialect/test_sqlite.py:28: in <module>
    class TestTypes(fixtures.TestBase, AssertsExecutionResults):
test/dialect/test_sqlite.py:107: in TestTypes
    @testing.provide_metadata
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:128: in decorate
    metadata.update(format_argspec_plus(spec, grouped=False))
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:374: in format_argspec_plus
    args = inspect.formatargspec(*spec)
/nix/store/3hkchkmcz4kjldka2jpvfibpz12w847g-python3-3.7.0/lib/python3.7/inspect.py:1225: in formatargspec
    stacklevel=2)
E   DeprecationWarning: `formatargspec` is deprecated since Python 3.5. Use `signature` and the `Signature` object directly
_________________ ERROR collecting test/dialect/test_suite.py __________________
test/dialect/test_suite.py:1: in <module>
    from sqlalchemy.testing.suite import *
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/testing/suite/__init__.py:2: in <module>
    from sqlalchemy.testing.suite.test_dialect import *
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/testing/suite/test_dialect.py:11: in <module>
    class ExceptionTest(fixtures.TablesTest):
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/testing/suite/test_dialect.py:29: in ExceptionTest
    @requirements.duplicate_key_raises_integrity_error
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/testing/exclusions.py:96: in __call__
    decorated = decorate(fn)
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:128: in decorate
    metadata.update(format_argspec_plus(spec, grouped=False))
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:374: in format_argspec_plus
    args = inspect.formatargspec(*spec)
/nix/store/3hkchkmcz4kjldka2jpvfibpz12w847g-python3-3.7.0/lib/python3.7/inspect.py:1225: in formatargspec
    stacklevel=2)
E   DeprecationWarning: `formatargspec` is deprecated since Python 3.5. Use `signature` and the `Signature` object directly
_________________ ERROR collecting test/dialect/test_sybase.py _________________
test/dialect/test_sybase.py:3: in <module>
    from sqlalchemy.databases import sybase
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/databases/__init__.py:13: in <module>
    from ..dialects.postgresql import base as postgresql
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/postgresql/__init__.py:8: in <module>
    from . import base, psycopg2, pg8000, pypostgresql, pygresql, \
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/postgresql/base.py:2153: in <module>
    class PGDialect(default.DefaultDialect):
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/postgresql/base.py:2436: in PGDialect
    def get_table_oid(self, connection, table_name, schema=None, **kw):
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:128: in decorate
    metadata.update(format_argspec_plus(spec, grouped=False))
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:374: in format_argspec_plus
    args = inspect.formatargspec(*spec)
/nix/store/3hkchkmcz4kjldka2jpvfibpz12w847g-python3-3.7.0/lib/python3.7/inspect.py:1225: in formatargspec
    stacklevel=2)
E   DeprecationWarning: `formatargspec` is deprecated since Python 3.5. Use `signature` and the `Signature` object directly
_____________ ERROR collecting test/dialect/mssql/test_compiler.py _____________
test/dialect/mssql/test_compiler.py:5: in <module>
    from sqlalchemy.dialects import mssql
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/mssql/__init__.py:8: in <module>
    from . import base, pyodbc, adodbapi, pymssql, zxjdbc, mxodbc  # noqa
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/mssql/base.py:1802: in <module>
    class MSDialect(default.DefaultDialect):
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/mssql/base.py:1982: in MSDialect
    @reflection.cache
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:128: in decorate
    metadata.update(format_argspec_plus(spec, grouped=False))
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:374: in format_argspec_plus
    args = inspect.formatargspec(*spec)
/nix/store/3hkchkmcz4kjldka2jpvfibpz12w847g-python3-3.7.0/lib/python3.7/inspect.py:1225: in formatargspec
    stacklevel=2)
E   DeprecationWarning: `formatargspec` is deprecated since Python 3.5. Use `signature` and the `Signature` object directly
______________ ERROR collecting test/dialect/mssql/test_engine.py ______________
test/dialect/mssql/test_engine.py:5: in <module>
    from sqlalchemy.dialects.mssql import pyodbc, pymssql, adodbapi
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/mssql/__init__.py:8: in <module>
    from . import base, pyodbc, adodbapi, pymssql, zxjdbc, mxodbc  # noqa
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/mssql/base.py:1802: in <module>
    class MSDialect(default.DefaultDialect):
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/mssql/base.py:1982: in MSDialect
    @reflection.cache
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:128: in decorate
    metadata.update(format_argspec_plus(spec, grouped=False))
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:374: in format_argspec_plus
    args = inspect.formatargspec(*spec)
/nix/store/3hkchkmcz4kjldka2jpvfibpz12w847g-python3-3.7.0/lib/python3.7/inspect.py:1225: in formatargspec
    stacklevel=2)
E   DeprecationWarning: `formatargspec` is deprecated since Python 3.5. Use `signature` and the `Signature` object directly
______________ ERROR collecting test/dialect/mssql/test_query.py _______________
test/dialect/mssql/test_query.py:4: in <module>
    from sqlalchemy.databases import mssql
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/databases/__init__.py:13: in <module>
    from ..dialects.postgresql import base as postgresql
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/postgresql/__init__.py:8: in <module>
    from . import base, psycopg2, pg8000, pypostgresql, pygresql, \
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/postgresql/base.py:2153: in <module>
    class PGDialect(default.DefaultDialect):
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/postgresql/base.py:2436: in PGDialect
    def get_table_oid(self, connection, table_name, schema=None, **kw):
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:128: in decorate
    metadata.update(format_argspec_plus(spec, grouped=False))
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:374: in format_argspec_plus
    args = inspect.formatargspec(*spec)
/nix/store/3hkchkmcz4kjldka2jpvfibpz12w847g-python3-3.7.0/lib/python3.7/inspect.py:1225: in formatargspec
    stacklevel=2)
E   DeprecationWarning: `formatargspec` is deprecated since Python 3.5. Use `signature` and the `Signature` object directly
____________ ERROR collecting test/dialect/mssql/test_reflection.py ____________
test/dialect/mssql/test_reflection.py:5: in <module>
    from sqlalchemy.databases import mssql
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/databases/__init__.py:13: in <module>
    from ..dialects.postgresql import base as postgresql
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/postgresql/__init__.py:8: in <module>
    from . import base, psycopg2, pg8000, pypostgresql, pygresql, \
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/postgresql/base.py:2153: in <module>
    class PGDialect(default.DefaultDialect):
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/postgresql/base.py:2436: in PGDialect
    def get_table_oid(self, connection, table_name, schema=None, **kw):
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:128: in decorate
    metadata.update(format_argspec_plus(spec, grouped=False))
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:374: in format_argspec_plus
    args = inspect.formatargspec(*spec)
/nix/store/3hkchkmcz4kjldka2jpvfibpz12w847g-python3-3.7.0/lib/python3.7/inspect.py:1225: in formatargspec
    stacklevel=2)
E   DeprecationWarning: `formatargspec` is deprecated since Python 3.5. Use `signature` and the `Signature` object directly
______________ ERROR collecting test/dialect/mssql/test_types.py _______________
test/dialect/mssql/test_types.py:10: in <module>
    from sqlalchemy.dialects.mssql import TIMESTAMP, ROWVERSION
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/mssql/__init__.py:8: in <module>
    from . import base, pyodbc, adodbapi, pymssql, zxjdbc, mxodbc  # noqa
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/mssql/base.py:1802: in <module>
    class MSDialect(default.DefaultDialect):
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/mssql/base.py:1982: in MSDialect
    @reflection.cache
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:128: in decorate
    metadata.update(format_argspec_plus(spec, grouped=False))
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:374: in format_argspec_plus
    args = inspect.formatargspec(*spec)
/nix/store/3hkchkmcz4kjldka2jpvfibpz12w847g-python3-3.7.0/lib/python3.7/inspect.py:1225: in formatargspec
    stacklevel=2)
E   DeprecationWarning: `formatargspec` is deprecated since Python 3.5. Use `signature` and the `Signature` object directly
_____________ ERROR collecting test/dialect/mysql/test_compiler.py _____________
test/dialect/mysql/test_compiler.py:13: in <module>
    from sqlalchemy.dialects.mysql import insert
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/mysql/__init__.py:8: in <module>
    from . import base, mysqldb, oursql, \
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/mysql/base.py:1643: in <module>
    class MySQLDialect(default.DefaultDialect):
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/mysql/base.py:1959: in MySQLDialect
    @reflection.cache
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:128: in decorate
    metadata.update(format_argspec_plus(spec, grouped=False))
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:374: in format_argspec_plus
    args = inspect.formatargspec(*spec)
/nix/store/3hkchkmcz4kjldka2jpvfibpz12w847g-python3-3.7.0/lib/python3.7/inspect.py:1225: in formatargspec
    stacklevel=2)
E   DeprecationWarning: `formatargspec` is deprecated since Python 3.5. Use `signature` and the `Signature` object directly
_____________ ERROR collecting test/dialect/mysql/test_dialect.py ______________
test/dialect/mysql/test_dialect.py:9: in <module>
    from ...engine import test_execute
<frozen importlib._bootstrap>:983: in _find_and_load
    ???
<frozen importlib._bootstrap>:967: in _find_and_load_unlocked
    ???
<frozen importlib._bootstrap>:668: in _load_unlocked
    ???
<frozen importlib._bootstrap>:638: in _load_backward_compatible
    ???
/nix/store/kc826j8kxs4kfhipjg99a3c9wdwm2a7v-python3.7-pytest-3.6.2/lib/python3.7/site-packages/_pytest/assertion/rewrite.py:216: in load_module
    py.builtin.exec_(co, mod.__dict__)
test/engine/test_execute.py:20: in <module>
    from sqlalchemy.dialects.oracle.zxjdbc import ReturningParam
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/oracle/__init__.py:8: in <module>
    from . import base, cx_oracle, zxjdbc  # noqa
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/oracle/base.py:1025: in <module>
    class OracleDialect(default.DefaultDialect):
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/oracle/base.py:1219: in OracleDialect
    resolve_synonyms=False, dblink='', **kw):
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:128: in decorate
    metadata.update(format_argspec_plus(spec, grouped=False))
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:374: in format_argspec_plus
    args = inspect.formatargspec(*spec)
/nix/store/3hkchkmcz4kjldka2jpvfibpz12w847g-python3-3.7.0/lib/python3.7/inspect.py:1225: in formatargspec
    stacklevel=2)
E   DeprecationWarning: `formatargspec` is deprecated since Python 3.5. Use `signature` and the `Signature` object directly
___________ ERROR collecting test/dialect/mysql/test_on_duplicate.py ___________
test/dialect/mysql/test_on_duplicate.py:4: in <module>
    from sqlalchemy.dialects.mysql import insert
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/mysql/__init__.py:8: in <module>
    from . import base, mysqldb, oursql, \
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/mysql/base.py:1643: in <module>
    class MySQLDialect(default.DefaultDialect):
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/mysql/base.py:1959: in MySQLDialect
    @reflection.cache
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:128: in decorate
    metadata.update(format_argspec_plus(spec, grouped=False))
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:374: in format_argspec_plus
    args = inspect.formatargspec(*spec)
/nix/store/3hkchkmcz4kjldka2jpvfibpz12w847g-python3-3.7.0/lib/python3.7/inspect.py:1225: in formatargspec
    stacklevel=2)
E   DeprecationWarning: `formatargspec` is deprecated since Python 3.5. Use `signature` and the `Signature` object directly
______________ ERROR collecting test/dialect/mysql/test_query.py _______________
test/dialect/mysql/test_query.py:9: in <module>
    class IdiosyncrasyTest(fixtures.TestBase):
test/dialect/mysql/test_query.py:13: in IdiosyncrasyTest
    @testing.emits_warning()
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:128: in decorate
    metadata.update(format_argspec_plus(spec, grouped=False))
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:374: in format_argspec_plus
    args = inspect.formatargspec(*spec)
/nix/store/3hkchkmcz4kjldka2jpvfibpz12w847g-python3-3.7.0/lib/python3.7/inspect.py:1225: in formatargspec
    stacklevel=2)
E   DeprecationWarning: `formatargspec` is deprecated since Python 3.5. Use `signature` and the `Signature` object directly
____________ ERROR collecting test/dialect/mysql/test_reflection.py ____________
test/dialect/mysql/test_reflection.py:12: in <module>
    from sqlalchemy.dialects.mysql import base as mysql
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/mysql/__init__.py:8: in <module>
    from . import base, mysqldb, oursql, \
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/mysql/base.py:1643: in <module>
    class MySQLDialect(default.DefaultDialect):
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/mysql/base.py:1959: in MySQLDialect
    @reflection.cache
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:128: in decorate
    metadata.update(format_argspec_plus(spec, grouped=False))
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:374: in format_argspec_plus
    args = inspect.formatargspec(*spec)
/nix/store/3hkchkmcz4kjldka2jpvfibpz12w847g-python3-3.7.0/lib/python3.7/inspect.py:1225: in formatargspec
    stacklevel=2)
E   DeprecationWarning: `formatargspec` is deprecated since Python 3.5. Use `signature` and the `Signature` object directly
______________ ERROR collecting test/dialect/mysql/test_types.py _______________
test/dialect/mysql/test_types.py:8: in <module>
    from sqlalchemy.dialects.mysql import base as mysql
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/mysql/__init__.py:8: in <module>
    from . import base, mysqldb, oursql, \
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/mysql/base.py:1643: in <module>
    class MySQLDialect(default.DefaultDialect):
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/mysql/base.py:1959: in MySQLDialect
    @reflection.cache
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:128: in decorate
    metadata.update(format_argspec_plus(spec, grouped=False))
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:374: in format_argspec_plus
    args = inspect.formatargspec(*spec)
/nix/store/3hkchkmcz4kjldka2jpvfibpz12w847g-python3-3.7.0/lib/python3.7/inspect.py:1225: in formatargspec
    stacklevel=2)
E   DeprecationWarning: `formatargspec` is deprecated since Python 3.5. Use `signature` and the `Signature` object directly
____________ ERROR collecting test/dialect/oracle/test_compiler.py _____________
test/dialect/oracle/test_compiler.py:23: in <module>
    from sqlalchemy.dialects.oracle import cx_oracle, base as oracle
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/oracle/__init__.py:8: in <module>
    from . import base, cx_oracle, zxjdbc  # noqa
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/oracle/base.py:1025: in <module>
    class OracleDialect(default.DefaultDialect):
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/oracle/base.py:1219: in OracleDialect
    resolve_synonyms=False, dblink='', **kw):
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:128: in decorate
    metadata.update(format_argspec_plus(spec, grouped=False))
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:374: in format_argspec_plus
    args = inspect.formatargspec(*spec)
/nix/store/3hkchkmcz4kjldka2jpvfibpz12w847g-python3-3.7.0/lib/python3.7/inspect.py:1225: in formatargspec
    stacklevel=2)
E   DeprecationWarning: `formatargspec` is deprecated since Python 3.5. Use `signature` and the `Signature` object directly
_____________ ERROR collecting test/dialect/oracle/test_dialect.py _____________
test/dialect/oracle/test_dialect.py:22: in <module>
    from sqlalchemy.dialects.oracle import cx_oracle, base as oracle
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/oracle/__init__.py:8: in <module>
    from . import base, cx_oracle, zxjdbc  # noqa
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/oracle/base.py:1025: in <module>
    class OracleDialect(default.DefaultDialect):
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/oracle/base.py:1219: in OracleDialect
    resolve_synonyms=False, dblink='', **kw):
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:128: in decorate
    metadata.update(format_argspec_plus(spec, grouped=False))
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:374: in format_argspec_plus
    args = inspect.formatargspec(*spec)
/nix/store/3hkchkmcz4kjldka2jpvfibpz12w847g-python3-3.7.0/lib/python3.7/inspect.py:1225: in formatargspec
    stacklevel=2)
E   DeprecationWarning: `formatargspec` is deprecated since Python 3.5. Use `signature` and the `Signature` object directly
___________ ERROR collecting test/dialect/oracle/test_reflection.py ____________
test/dialect/oracle/test_reflection.py:16: in <module>
    from sqlalchemy.dialects.oracle.base import NUMBER, BINARY_DOUBLE, \
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/oracle/__init__.py:8: in <module>
    from . import base, cx_oracle, zxjdbc  # noqa
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/oracle/base.py:1025: in <module>
    class OracleDialect(default.DefaultDialect):
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/oracle/base.py:1219: in OracleDialect
    resolve_synonyms=False, dblink='', **kw):
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:128: in decorate
    metadata.update(format_argspec_plus(spec, grouped=False))
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:374: in format_argspec_plus
    args = inspect.formatargspec(*spec)
/nix/store/3hkchkmcz4kjldka2jpvfibpz12w847g-python3-3.7.0/lib/python3.7/inspect.py:1225: in formatargspec
    stacklevel=2)
E   DeprecationWarning: `formatargspec` is deprecated since Python 3.5. Use `signature` and the `Signature` object directly
______________ ERROR collecting test/dialect/oracle/test_types.py ______________
test/dialect/oracle/test_types.py:23: in <module>
    from sqlalchemy.dialects.oracle import cx_oracle, base as oracle
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/oracle/__init__.py:8: in <module>
    from . import base, cx_oracle, zxjdbc  # noqa
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/oracle/base.py:1025: in <module>
    class OracleDialect(default.DefaultDialect):
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/oracle/base.py:1219: in OracleDialect
    resolve_synonyms=False, dblink='', **kw):
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:128: in decorate
    metadata.update(format_argspec_plus(spec, grouped=False))
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:374: in format_argspec_plus
    args = inspect.formatargspec(*spec)
/nix/store/3hkchkmcz4kjldka2jpvfibpz12w847g-python3-3.7.0/lib/python3.7/inspect.py:1225: in formatargspec
    stacklevel=2)
E   DeprecationWarning: `formatargspec` is deprecated since Python 3.5. Use `signature` and the `Signature` object directly
__________ ERROR collecting test/dialect/postgresql/test_compiler.py ___________
test/dialect/postgresql/test_compiler.py:10: in <module>
    from sqlalchemy.dialects.postgresql import ExcludeConstraint, array
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/postgresql/__init__.py:8: in <module>
    from . import base, psycopg2, pg8000, pypostgresql, pygresql, \
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/postgresql/base.py:2153: in <module>
    class PGDialect(default.DefaultDialect):
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/postgresql/base.py:2436: in PGDialect
    def get_table_oid(self, connection, table_name, schema=None, **kw):
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:128: in decorate
    metadata.update(format_argspec_plus(spec, grouped=False))
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:374: in format_argspec_plus
    args = inspect.formatargspec(*spec)
/nix/store/3hkchkmcz4kjldka2jpvfibpz12w847g-python3-3.7.0/lib/python3.7/inspect.py:1225: in formatargspec
    stacklevel=2)
E   DeprecationWarning: `formatargspec` is deprecated since Python 3.5. Use `signature` and the `Signature` object directly
___________ ERROR collecting test/dialect/postgresql/test_dialect.py ___________
test/dialect/postgresql/test_dialect.py:14: in <module>
    from sqlalchemy.dialects.postgresql import base as postgresql
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/postgresql/__init__.py:8: in <module>
    from . import base, psycopg2, pg8000, pypostgresql, pygresql, \
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/postgresql/base.py:2153: in <module>
    class PGDialect(default.DefaultDialect):
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/postgresql/base.py:2436: in PGDialect
    def get_table_oid(self, connection, table_name, schema=None, **kw):
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:128: in decorate
    metadata.update(format_argspec_plus(spec, grouped=False))
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:374: in format_argspec_plus
    args = inspect.formatargspec(*spec)
/nix/store/3hkchkmcz4kjldka2jpvfibpz12w847g-python3-3.7.0/lib/python3.7/inspect.py:1225: in formatargspec
    stacklevel=2)
E   DeprecationWarning: `formatargspec` is deprecated since Python 3.5. Use `signature` and the `Signature` object directly
_________ ERROR collecting test/dialect/postgresql/test_on_conflict.py _________
test/dialect/postgresql/test_on_conflict.py:8: in <module>
    from sqlalchemy.dialects.postgresql import insert
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/postgresql/__init__.py:8: in <module>
    from . import base, psycopg2, pg8000, pypostgresql, pygresql, \
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/postgresql/base.py:2153: in <module>
    class PGDialect(default.DefaultDialect):
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/dialects/postgresql/base.py:2436: in PGDialect
    def get_table_oid(self, connection, table_name, schema=None, **kw):
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:128: in decorate
    metadata.update(format_argspec_plus(spec, grouped=False))
/nix/store/qbjcg17f4605zx5gmkfg1z7i2j3zflwm-python3.7-SQLAlchemy-1.2.8/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py:374: in format_argspec_plus
    args = inspect.formatargspec(*spec)
/nix/store/3hkchkmcz4kjldka2jpvfibpz12w847g-python3-3.7.0/lib/python3.7/inspect.py:1225: in formatargspec
    stacklevel=2)
E   DeprecationWarning: `formatargspec` is deprecated since Python 3.5. Use `signature` and the `Signature` object directly
=========================== 25 error in 5.45 seconds ===========================

The same errors appear when running the tests from latest master.

Comments (4)

  1. Michael Bayer repo owner

    Vendor python3 formatargspec

    Replaced the usage of inspect.formatargspec() with a vendored version
    copied from the Python standard library, as inspect.formatargspec()
    is deprecated and as of Python 3.7.0 is emitting a warning.

    Change-Id: I751652fac7f605a3a10b547ba8c5f34fef1de945
    Fixes: #4291

    → <<cset 536d5187a038>>

  2. Log in to comment