Hi, I have an odd issue with sqlachemy==1.2.11 that I haven't seen before. My unit tests were failing locally after the upgrade for Lemur ( https://github.com/Netflix/lemur/ ) . When I test locally, tests pass fine with sqlachemy==1.2.10, but fail with sqlachemy==1.2.11 .
Here is the travis CI: https://travis-ci.org/Netflix/lemur/builds/421142451 The table it's complaining about is defined here: https://github.com/Netflix/lemur/blob/master/lemur/dns_providers/schemas.py . It could certainly be an error with the schema, but it's odd to me that I am not able to reproduce this error on earlier versions. Could this be related to the newline I see in the traceback below? ' \nFROM dns_providers' ? I can run the query defined below on the Postgres database directly (without the \n character) without any issues: 'SELECT dns_providers.id AS dns_providers_id, dns_providers.name AS dns_providers_name, dns_providers.description AS dns_providers_description, dns_providers.provider_type AS dns_providers_provider_type, dns_providers.credentials AS dns_providers_credentials, dns_providers.api_endpoint AS dns_providers_api_endpoint, dns_providers.date_created AS dns_providers_date_created, dns_providers.status AS dns_providers_status, dns_providers.options AS dns_providers_options, dns_providers.domains AS dns_providers_domains FROM dns_providers' Here's an excerpt from the traceback: "Traceback (most recent call last): File "/Users/ccastrapel/localrepos/lemur/lemur/common/managers.py", line 60, in all results.append(cls()) File "/Users/ccastrapel/localrepos/lemur/lemur/plugins/lemur_acme/plugin.py", line 332, in __init__ self.acme = AcmeHandler() File "/Users/ccastrapel/localrepos/lemur/lemur/plugins/lemur_acme/plugin.py", line 47, in __init__ self.all_dns_providers = dns_provider_service.get_all_dns_providers() File "/Users/ccastrapel/localrepos/lemur/lemur/dns_providers/service.py", line 31, in get_all_dns_providers return DnsProvider.query.all() File "/Users/ccastrapel/localrepos/lemur/env/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 2836, in all return list(self) File "/Users/ccastrapel/localrepos/lemur/env/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 2988, in __iter__ return self._execute_and_instances(context) File "/Users/ccastrapel/localrepos/lemur/env/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3011, in _execute_and_instances result = conn.execute(querycontext.statement, self._params) File "/Users/ccastrapel/localrepos/lemur/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 948, in execute return meth(self, multiparams, params) File "/Users/ccastrapel/localrepos/lemur/env/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/Users/ccastrapel/localrepos/lemur/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement compiled_sql, distilled_params File "/Users/ccastrapel/localrepos/lemur/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context context) File "/Users/ccastrapel/localrepos/lemur/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception exc_info File "/Users/ccastrapel/localrepos/lemur/env/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 265, in raise_from_cause reraise(type(exception), exception, tb=exc_tb, cause=cause) File "/Users/ccastrapel/localrepos/lemur/env/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 248, in reraise raise value.with_traceback(tb) File "/Users/ccastrapel/localrepos/lemur/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context context) File "/Users/ccastrapel/localrepos/lemur/env/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 509, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) relation "dns_providers" does not exist LINE 2: FROM dns_providers ^ [SQL: 'SELECT dns_providers.id AS dns_providers_id, dns_providers.name AS dns_providers_name, dns_providers.description AS dns_providers_description, dns_providers.provider_type AS dns_providers_provider_type, dns_providers.credentials AS dns_providers_credentials, dns_providers.api_endpoint AS dns_providers_api_endpoint, dns_providers.date_created AS dns_providers_date_created, dns_providers.status AS dns_providers_status, dns_providers.options AS dns_providers_options, dns_providers.domains AS dns_providers_domains \nFROM dns_providers'] (Background on this error at: http://sqlalche.me/e/f405)" Thanks, Curtis -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
