Created
August 18, 2015 09:40
-
-
Save sheilatron/7ce4b1de6f4a18d73993 to your computer and use it in GitHub Desktop.
While running SA tests against mxODBC 3.3.4, unixODBC 2.3.2, Microsoft ODBC for Linux (Fedora 22)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| test/orm/test_session.py::SessionStateTest::test_autocommit_doesnt_raise_on_pending PASSED | |
| test/orm/test_session.py::SessionStateTest::test_autoflush ^CTraceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 608 | |
| DEBUG:sqlalchemy.pool.QueuePool:Created new connection <mx.ODBC.unixODBC connection object at 0x7ff9c0d122f0> | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 498 | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c0d122f0> checked out from pool | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 870, in emit | |
| stream.write(ufs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1097 | |
| INFO:sqlalchemy.engine.base.Engine:DELETE FROM order_items | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1100 | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 686 | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 870, in emit | |
| stream.write(ufs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1097 | |
| INFO:sqlalchemy.engine.base.Engine:DELETE FROM orders | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1100 | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 686 | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 870, in emit | |
| stream.write(ufs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1097 | |
| INFO:sqlalchemy.engine.base.Engine:DELETE FROM email_bounces | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1100 | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 686 | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 870, in emit | |
| stream.write(ufs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1097 | |
| INFO:sqlalchemy.engine.base.Engine:DELETE FROM dingalings | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1100 | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 686 | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 870, in emit | |
| stream.write(ufs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1097 | |
| INFO:sqlalchemy.engine.base.Engine:DELETE FROM item_keywords | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1100 | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 686 | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 870, in emit | |
| stream.write(ufs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1097 | |
| INFO:sqlalchemy.engine.base.Engine:DELETE FROM addresses | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1100 | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 686 | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 870, in emit | |
| stream.write(ufs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1097 | |
| INFO:sqlalchemy.engine.base.Engine:DELETE FROM users | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1100 | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 686 | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 870, in emit | |
| stream.write(ufs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1097 | |
| INFO:sqlalchemy.engine.base.Engine:DELETE FROM nodes | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1100 | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 686 | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 870, in emit | |
| stream.write(ufs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1097 | |
| INFO:sqlalchemy.engine.base.Engine:DELETE FROM keywords | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1100 | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 686 | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 870, in emit | |
| stream.write(ufs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1097 | |
| INFO:sqlalchemy.engine.base.Engine:DELETE FROM items | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1100 | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 686 | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 870, in emit | |
| stream.write(ufs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1097 | |
| INFO:sqlalchemy.engine.base.Engine:DELETE FROM composite_pk_table | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1100 | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 686 | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 630 | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c0d122f0> being returned to pool | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 772 | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c0d122f0> rollback-on-return | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 498 | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c0bfbbe0> checked out from pool | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 870, in emit | |
| stream.write(ufs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1097 | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1100 | |
| INFO:sqlalchemy.engine.base.Engine:('email_bounces', u'jiva_user') | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file result.py, line 527 | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file result.py, line 937 | |
| DEBUG:sqlalchemy.engine.base.Engine:Row (u'jiva_user', u'email_bounces', u'id', 'YES', u'int', 1, None, 10, 0, None, None) | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 870, in emit | |
| stream.write(ufs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1097 | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1100 | |
| INFO:sqlalchemy.engine.base.Engine:('composite_pk_table', u'jiva_user') | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file result.py, line 527 | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file result.py, line 937 | |
| DEBUG:sqlalchemy.engine.base.Engine:Row (u'jiva_user', u'composite_pk_table', u'i', 'NO', u'int', 1, None, 10, 0, None, None) | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 870, in emit | |
| stream.write(ufs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1097 | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1100 | |
| INFO:sqlalchemy.engine.base.Engine:('users', u'jiva_user') | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file result.py, line 527 | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file result.py, line 937 | |
| DEBUG:sqlalchemy.engine.base.Engine:Row (u'jiva_user', u'users', u'id', 'NO', u'int', 1, None, 10, 0, None, None) | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 870, in emit | |
| stream.write(ufs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1097 | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1100 | |
| INFO:sqlalchemy.engine.base.Engine:('items', u'jiva_user') | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file result.py, line 527 | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file result.py, line 937 | |
| DEBUG:sqlalchemy.engine.base.Engine:Row (u'jiva_user', u'items', u'id', 'NO', u'int', 1, None, 10, 0, None, None) | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 870, in emit | |
| stream.write(ufs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1097 | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1100 | |
| INFO:sqlalchemy.engine.base.Engine:('order_items', u'jiva_user') | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file result.py, line 527 | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file result.py, line 937 | |
| DEBUG:sqlalchemy.engine.base.Engine:Row (u'jiva_user', u'order_items', u'item_id', 'YES', u'int', 1, None, 10, 0, None, None) | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 870, in emit | |
| stream.write(ufs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1097 | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1100 | |
| INFO:sqlalchemy.engine.base.Engine:('item_keywords', u'jiva_user') | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file result.py, line 527 | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file result.py, line 937 | |
| DEBUG:sqlalchemy.engine.base.Engine:Row (u'jiva_user', u'item_keywords', u'item_id', 'YES', u'int', 1, None, 10, 0, None, None) | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 870, in emit | |
| stream.write(ufs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1097 | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1100 | |
| INFO:sqlalchemy.engine.base.Engine:('dingalings', u'jiva_user') | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file result.py, line 527 | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file result.py, line 937 | |
| DEBUG:sqlalchemy.engine.base.Engine:Row (u'jiva_user', u'dingalings', u'id', 'NO', u'int', 1, None, 10, 0, None, None) | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 870, in emit | |
| stream.write(ufs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1097 | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1100 | |
| INFO:sqlalchemy.engine.base.Engine:('keywords', u'jiva_user') | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file result.py, line 527 | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file result.py, line 937 | |
| DEBUG:sqlalchemy.engine.base.Engine:Row (u'jiva_user', u'keywords', u'id', 'NO', u'int', 1, None, 10, 0, None, None) | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 870, in emit | |
| stream.write(ufs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1097 | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1100 | |
| INFO:sqlalchemy.engine.base.Engine:('nodes', u'jiva_user') | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file result.py, line 527 | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file result.py, line 937 | |
| DEBUG:sqlalchemy.engine.base.Engine:Row (u'jiva_user', u'nodes', u'id', 'NO', u'int', 1, None, 10, 0, None, None) | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 870, in emit | |
| stream.write(ufs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1097 | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1100 | |
| INFO:sqlalchemy.engine.base.Engine:('orders', u'jiva_user') | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file result.py, line 527 | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file result.py, line 937 | |
| DEBUG:sqlalchemy.engine.base.Engine:Row (u'jiva_user', u'orders', u'id', 'NO', u'int', 1, None, 10, 0, None, None) | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 870, in emit | |
| stream.write(ufs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1097 | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1100 | |
| INFO:sqlalchemy.engine.base.Engine:('addresses', u'jiva_user') | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file result.py, line 527 | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file result.py, line 937 | |
| DEBUG:sqlalchemy.engine.base.Engine:Row (u'jiva_user', u'addresses', u'id', 'NO', u'int', 1, None, 10, 0, None, None) | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 870, in emit | |
| stream.write(ufs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1097 | |
| INFO:sqlalchemy.engine.base.Engine: | |
| DROP TABLE order_items | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1100 | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 686 | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 870, in emit | |
| stream.write(ufs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1097 | |
| INFO:sqlalchemy.engine.base.Engine: | |
| DROP TABLE orders | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1100 | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 686 | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 870, in emit | |
| stream.write(ufs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1097 | |
| INFO:sqlalchemy.engine.base.Engine: | |
| DROP TABLE dingalings | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1100 | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 686 | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 870, in emit | |
| stream.write(ufs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1097 | |
| INFO:sqlalchemy.engine.base.Engine: | |
| DROP TABLE email_bounces | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1100 | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 686 | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 870, in emit | |
| stream.write(ufs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1097 | |
| INFO:sqlalchemy.engine.base.Engine: | |
| DROP TABLE addresses | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1100 | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 686 | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 870, in emit | |
| stream.write(ufs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1097 | |
| INFO:sqlalchemy.engine.base.Engine: | |
| DROP TABLE item_keywords | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1100 | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 686 | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 870, in emit | |
| stream.write(ufs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1097 | |
| INFO:sqlalchemy.engine.base.Engine: | |
| DROP TABLE nodes | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1100 | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 686 | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 870, in emit | |
| stream.write(ufs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1097 | |
| INFO:sqlalchemy.engine.base.Engine: | |
| DROP TABLE keywords | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1100 | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 686 | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 870, in emit | |
| stream.write(ufs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1097 | |
| INFO:sqlalchemy.engine.base.Engine: | |
| DROP TABLE items | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1100 | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 686 | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 870, in emit | |
| stream.write(ufs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1097 | |
| INFO:sqlalchemy.engine.base.Engine: | |
| DROP TABLE users | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1100 | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 686 | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 870, in emit | |
| stream.write(ufs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1097 | |
| INFO:sqlalchemy.engine.base.Engine: | |
| DROP TABLE composite_pk_table | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 1100 | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file base.py, line 686 | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 630 | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c0bfbbe0> being returned to pool | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 772 | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c0bfbbe0> rollback-on-return | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1104 | |
| INFO:sqlalchemy.pool.QueuePool:Pool disposed. Pool size: 5 Connections in pool: 0 Current Overflow: -5 Current Checked out connections: 0 | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1084 | |
| INFO:sqlalchemy.pool.QueuePool:Pool recreating | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1104 | |
| INFO:sqlalchemy.pool.QueuePool:Pool disposed. Pool size: 5 Connections in pool: 0 Current Overflow: -5 Current Checked out connections: 0 | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1084 | |
| INFO:sqlalchemy.pool.QueuePool:Pool recreating | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1104 | |
| INFO:sqlalchemy.pool.QueuePool:Pool disposed. Pool size: 5 Connections in pool: 0 Current Overflow: -5 Current Checked out connections: 0 | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1084 | |
| INFO:sqlalchemy.pool.QueuePool:Pool recreating | |
| INFO:sqlalchemy.pool.NullPool:Pool recreating | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1104 | |
| INFO:sqlalchemy.pool.QueuePool:Pool disposed. Pool size: 5 Connections in pool: 0 Current Overflow: -5 Current Checked out connections: 0 | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1084 | |
| INFO:sqlalchemy.pool.QueuePool:Pool recreating | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1104 | |
| INFO:sqlalchemy.pool.QueuePool:Pool disposed. Pool size: 5 Connections in pool: 0 Current Overflow: -5 Current Checked out connections: 0 | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1084 | |
| INFO:sqlalchemy.pool.QueuePool:Pool recreating | |
| INFO:sqlalchemy.pool.NullPool:Pool recreating | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1104 | |
| INFO:sqlalchemy.pool.QueuePool:Pool disposed. Pool size: 5 Connections in pool: 0 Current Overflow: -5 Current Checked out connections: 0 | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1084 | |
| INFO:sqlalchemy.pool.QueuePool:Pool recreating | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1104 | |
| INFO:sqlalchemy.pool.QueuePool:Pool disposed. Pool size: 5 Connections in pool: 0 Current Overflow: -5 Current Checked out connections: 0 | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1084 | |
| INFO:sqlalchemy.pool.QueuePool:Pool recreating | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1104 | |
| INFO:sqlalchemy.pool.QueuePool:Pool disposed. Pool size: 5 Connections in pool: 0 Current Overflow: -5 Current Checked out connections: 0 | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1084 | |
| INFO:sqlalchemy.pool.QueuePool:Pool recreating | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1104 | |
| INFO:sqlalchemy.pool.QueuePool:Pool disposed. Pool size: 5 Connections in pool: 0 Current Overflow: -5 Current Checked out connections: 0 | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1084 | |
| INFO:sqlalchemy.pool.QueuePool:Pool recreating | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1104 | |
| INFO:sqlalchemy.pool.QueuePool:Pool disposed. Pool size: 5 Connections in pool: 0 Current Overflow: -5 Current Checked out connections: 0 | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1084 | |
| INFO:sqlalchemy.pool.QueuePool:Pool recreating | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1104 | |
| INFO:sqlalchemy.pool.QueuePool:Pool disposed. Pool size: 5 Connections in pool: 0 Current Overflow: -5 Current Checked out connections: 0 | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1084 | |
| INFO:sqlalchemy.pool.QueuePool:Pool recreating | |
| INFO:sqlalchemy.pool.NullPool:Pool recreating | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1104 | |
| INFO:sqlalchemy.pool.QueuePool:Pool disposed. Pool size: 5 Connections in pool: 0 Current Overflow: -5 Current Checked out connections: 0 | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1084 | |
| INFO:sqlalchemy.pool.QueuePool:Pool recreating | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1104 | |
| INFO:sqlalchemy.pool.QueuePool:Pool disposed. Pool size: 5 Connections in pool: 0 Current Overflow: -5 Current Checked out connections: 0 | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1084 | |
| INFO:sqlalchemy.pool.QueuePool:Pool recreating | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 924 | |
| INFO:sqlalchemy.pool.SingletonThreadPool:Pool recreating | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1104 | |
| INFO:sqlalchemy.pool.QueuePool:Pool disposed. Pool size: 5 Connections in pool: 0 Current Overflow: -5 Current Checked out connections: 0 | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1084 | |
| INFO:sqlalchemy.pool.QueuePool:Pool recreating | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1104 | |
| INFO:sqlalchemy.pool.QueuePool:Pool disposed. Pool size: 5 Connections in pool: 0 Current Overflow: -5 Current Checked out connections: 0 | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1084 | |
| INFO:sqlalchemy.pool.QueuePool:Pool recreating | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1104 | |
| INFO:sqlalchemy.pool.QueuePool:Pool disposed. Pool size: 5 Connections in pool: 0 Current Overflow: -5 Current Checked out connections: 0 | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1084 | |
| INFO:sqlalchemy.pool.QueuePool:Pool recreating | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1104 | |
| INFO:sqlalchemy.pool.QueuePool:Pool disposed. Pool size: 5 Connections in pool: 0 Current Overflow: -5 Current Checked out connections: 0 | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1084 | |
| INFO:sqlalchemy.pool.QueuePool:Pool recreating | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1104 | |
| INFO:sqlalchemy.pool.QueuePool:Pool disposed. Pool size: 5 Connections in pool: 0 Current Overflow: -5 Current Checked out connections: 0 | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1084 | |
| INFO:sqlalchemy.pool.QueuePool:Pool recreating | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1104 | |
| INFO:sqlalchemy.pool.QueuePool:Pool disposed. Pool size: 5 Connections in pool: 0 Current Overflow: -5 Current Checked out connections: 0 | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1084 | |
| INFO:sqlalchemy.pool.QueuePool:Pool recreating | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1104 | |
| INFO:sqlalchemy.pool.QueuePool:Pool disposed. Pool size: 5 Connections in pool: 0 Current Overflow: -5 Current Checked out connections: 0 | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1084 | |
| INFO:sqlalchemy.pool.QueuePool:Pool recreating | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1104 | |
| INFO:sqlalchemy.pool.QueuePool:Pool disposed. Pool size: 5 Connections in pool: 0 Current Overflow: -5 Current Checked out connections: 0 | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1084 | |
| INFO:sqlalchemy.pool.QueuePool:Pool recreating | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1104 | |
| INFO:sqlalchemy.pool.QueuePool:Pool disposed. Pool size: 5 Connections in pool: 0 Current Overflow: -5 Current Checked out connections: 0 | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1084 | |
| INFO:sqlalchemy.pool.QueuePool:Pool recreating | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1104 | |
| INFO:sqlalchemy.pool.QueuePool:Pool disposed. Pool size: 5 Connections in pool: 0 Current Overflow: -5 Current Checked out connections: 0 | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1084 | |
| INFO:sqlalchemy.pool.QueuePool:Pool recreating | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1104 | |
| INFO:sqlalchemy.pool.QueuePool:Pool disposed. Pool size: 5 Connections in pool: 0 Current Overflow: -5 Current Checked out connections: 0 | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1084 | |
| INFO:sqlalchemy.pool.QueuePool:Pool recreating | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1104 | |
| INFO:sqlalchemy.pool.QueuePool:Pool disposed. Pool size: 5 Connections in pool: 0 Current Overflow: -5 Current Checked out connections: 0 | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1084 | |
| INFO:sqlalchemy.pool.QueuePool:Pool recreating | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1104 | |
| INFO:sqlalchemy.pool.QueuePool:Pool disposed. Pool size: 5 Connections in pool: 0 Current Overflow: -5 Current Checked out connections: 0 | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1084 | |
| INFO:sqlalchemy.pool.QueuePool:Pool recreating | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1104 | |
| INFO:sqlalchemy.pool.QueuePool:Pool disposed. Pool size: 5 Connections in pool: 0 Current Overflow: -5 Current Checked out connections: 0 | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1084 | |
| INFO:sqlalchemy.pool.QueuePool:Pool recreating | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1104 | |
| INFO:sqlalchemy.pool.QueuePool:Pool disposed. Pool size: 5 Connections in pool: 0 Current Overflow: -5 Current Checked out connections: 0 | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1084 | |
| INFO:sqlalchemy.pool.QueuePool:Pool recreating | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1104 | |
| INFO:sqlalchemy.pool.QueuePool:Pool disposed. Pool size: 5 Connections in pool: 0 Current Overflow: -5 Current Checked out connections: 0 | |
| Traceback (most recent call last): | |
| File "/usr/lib64/python2.7/logging/__init__.py", line 880, in emit | |
| stream.write(fs % msg) | |
| File "/home/sallen/env/testmx334d2/lib/python2.7/site-packages/_pytest/capture.py", line 229, in write | |
| self.buffer.write(obj) | |
| ValueError: I/O operation on closed file | |
| Logged from file pool.py, line 1084 | |
| INFO:sqlalchemy.pool.QueuePool:Pool recreating | |
| INFO:sqlalchemy.pool.NullPool:Pool recreating | |
| ===================================================================================================== ERRORS ====================================================================================================== | |
| _____________________________________________________________________________ ERROR at setup of SortOnlyOnImportantFKsTest.test_flush _____________________________________________________________________________ | |
| Traceback (most recent call last): | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 266, in setup_class | |
| cls._setup_once_tables() | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables | |
| cls.metadata.create_all(cls.bind) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/schema.py", line 3687, in create_all | |
| tables=tables) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1856, in _run_visitor | |
| conn._run_visitor(visitorcallable, element, **kwargs) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1481, in _run_visitor | |
| **kwargs).traverse_single(element) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single | |
| return meth(obj, **kw) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 733, in visit_metadata | |
| self.traverse_single(fkc) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single | |
| return meth(obj, **kw) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 780, in visit_foreign_key_constraint | |
| self.connection.execute(AddConstraint(constraint)) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 914, in execute | |
| return meth(self, multiparams, params) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection | |
| return connection._execute_ddl(self, multiparams, params) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl | |
| compiled | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context | |
| context) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception | |
| exc_info | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/util/compat.py", line 199, in raise_from_cause | |
| reraise(type(exception), exception, tb=exc_tb) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context | |
| context) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 150, in do_execute | |
| cursor.execute(statement, parameters, direct=self._get_direct(context)) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 86, in error_handler | |
| raise errorclass(errorvalue) | |
| InterfaceError: (mx.ODBC.Error.InterfaceError) ('42S01', 2714, "[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]There is already an object named 'b' in the database.", 11245) [SQL: u'ALTER TABLE a ADD CONSTRAINT b FOREIGN KEY(b_id) REFERENCES b (id)'] | |
| ---------------------------------------------------------------------------------------------- Captured stdout setup ---------------------------------------------------------------------------------------------- | |
| 2015-08-18 03:25:35,261 DEBUG sqlalchemy.pool.QueuePool Created new connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a002f0> | |
| 2015-08-18 03:25:35,262 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a002f0> checked out from pool | |
| 2015-08-18 03:25:35,268 INFO sqlalchemy.engine.base.Engine SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| 2015-08-18 03:25:35,268 INFO sqlalchemy.engine.base.Engine ('a', u'jiva_user') | |
| 2015-08-18 03:25:35,344 DEBUG sqlalchemy.engine.base.Engine Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| 2015-08-18 03:25:35,346 INFO sqlalchemy.engine.base.Engine SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| 2015-08-18 03:25:35,346 INFO sqlalchemy.engine.base.Engine ('b', u'jiva_user') | |
| 2015-08-18 03:25:35,420 DEBUG sqlalchemy.engine.base.Engine Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| 2015-08-18 03:25:35,421 INFO sqlalchemy.engine.base.Engine | |
| CREATE TABLE a ( | |
| id INTEGER NOT NULL IDENTITY(1,1), | |
| b_id INTEGER NULL, | |
| PRIMARY KEY (id) | |
| ) | |
| 2015-08-18 03:25:35,422 INFO sqlalchemy.engine.base.Engine () | |
| 2015-08-18 03:25:35,455 INFO sqlalchemy.engine.base.Engine COMMIT | |
| 2015-08-18 03:25:35,485 INFO sqlalchemy.engine.base.Engine | |
| CREATE TABLE b ( | |
| id INTEGER NOT NULL, | |
| PRIMARY KEY (id), | |
| FOREIGN KEY(id) REFERENCES a (id) | |
| ) | |
| 2015-08-18 03:25:35,486 INFO sqlalchemy.engine.base.Engine () | |
| 2015-08-18 03:25:35,524 INFO sqlalchemy.engine.base.Engine COMMIT | |
| 2015-08-18 03:25:35,552 INFO sqlalchemy.engine.base.Engine ALTER TABLE a ADD CONSTRAINT b FOREIGN KEY(b_id) REFERENCES b (id) | |
| 2015-08-18 03:25:35,553 INFO sqlalchemy.engine.base.Engine () | |
| 2015-08-18 03:25:35,583 INFO sqlalchemy.engine.base.Engine ROLLBACK | |
| 2015-08-18 03:25:35,583 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a002f0> being returned to pool | |
| 2015-08-18 03:25:35,584 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a002f0> rollback-on-return | |
| ---------------------------------------------------------------------------------------------- Captured stderr setup ---------------------------------------------------------------------------------------------- | |
| DEBUG:sqlalchemy.pool.QueuePool:Created new connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a002f0> | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a002f0> checked out from pool | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| INFO:sqlalchemy.engine.base.Engine:('a', u'jiva_user') | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| INFO:sqlalchemy.engine.base.Engine:('b', u'jiva_user') | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| INFO:sqlalchemy.engine.base.Engine: | |
| CREATE TABLE a ( | |
| id INTEGER NOT NULL IDENTITY(1,1), | |
| b_id INTEGER NULL, | |
| PRIMARY KEY (id) | |
| ) | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| INFO:sqlalchemy.engine.base.Engine: | |
| CREATE TABLE b ( | |
| id INTEGER NOT NULL, | |
| PRIMARY KEY (id), | |
| FOREIGN KEY(id) REFERENCES a (id) | |
| ) | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| INFO:sqlalchemy.engine.base.Engine:ALTER TABLE a ADD CONSTRAINT b FOREIGN KEY(b_id) REFERENCES b (id) | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:ROLLBACK | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a002f0> being returned to pool | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a002f0> rollback-on-return | |
| __________________________________________________________________________________ ERROR at setup of SyncCompileTest.test_joins ___________________________________________________________________________________ | |
| Traceback (most recent call last): | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 266, in setup_class | |
| cls._setup_once_tables() | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables | |
| cls.metadata.create_all(cls.bind) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/schema.py", line 3687, in create_all | |
| tables=tables) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1856, in _run_visitor | |
| conn._run_visitor(visitorcallable, element, **kwargs) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1481, in _run_visitor | |
| **kwargs).traverse_single(element) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single | |
| return meth(obj, **kw) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 730, in visit_metadata | |
| _is_metadata_operation=True) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single | |
| return meth(obj, **kw) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 764, in visit_table | |
| include_foreign_key_constraints=include_foreign_key_constraints | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 914, in execute | |
| return meth(self, multiparams, params) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection | |
| return connection._execute_ddl(self, multiparams, params) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl | |
| compiled | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context | |
| context) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception | |
| exc_info | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/util/compat.py", line 199, in raise_from_cause | |
| reraise(type(exception), exception, tb=exc_tb) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context | |
| context) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 150, in do_execute | |
| cursor.execute(statement, parameters, direct=self._get_direct(context)) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 86, in error_handler | |
| raise errorclass(errorvalue) | |
| ProgrammingError: (mx.ODBC.Error.ProgrammingError) ('42000', 1770, "[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Foreign key 'FK__c__b_a_id__6565E83E' references invalid column 'a_id' in referenced table 'b'.", 11245) [SQL: u'\nCREATE TABLE c (\n\tb_a_id INTEGER NOT NULL, \n\tdata3 VARCHAR(128) NULL, \n\tPRIMARY KEY (b_a_id), \n\tFOREIGN KEY(b_a_id) REFERENCES b (a_id)\n)\n\n'] | |
| ---------------------------------------------------------------------------------------------- Captured stdout setup ---------------------------------------------------------------------------------------------- | |
| 2015-08-18 03:25:35,811 DEBUG sqlalchemy.pool.QueuePool Created new connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344190> | |
| 2015-08-18 03:25:35,813 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344190> checked out from pool | |
| 2015-08-18 03:25:35,819 INFO sqlalchemy.engine.base.Engine SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| 2015-08-18 03:25:35,820 INFO sqlalchemy.engine.base.Engine ('a', u'jiva_user') | |
| 2015-08-18 03:25:35,880 DEBUG sqlalchemy.engine.base.Engine Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| 2015-08-18 03:25:35,881 DEBUG sqlalchemy.engine.base.Engine Row (u'jiva_user', u'a', u'id', 'NO', u'int', 1, None, 10, 0, None, None) | |
| 2015-08-18 03:25:35,887 INFO sqlalchemy.engine.base.Engine SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| 2015-08-18 03:25:35,888 INFO sqlalchemy.engine.base.Engine ('c', u'jiva_user') | |
| 2015-08-18 03:25:35,947 DEBUG sqlalchemy.engine.base.Engine Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| 2015-08-18 03:25:35,954 INFO sqlalchemy.engine.base.Engine SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| 2015-08-18 03:25:35,954 INFO sqlalchemy.engine.base.Engine ('b', u'jiva_user') | |
| 2015-08-18 03:25:36,013 DEBUG sqlalchemy.engine.base.Engine Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| 2015-08-18 03:25:36,014 DEBUG sqlalchemy.engine.base.Engine Row (u'jiva_user', u'b', u'id', 'NO', u'int', 1, None, 10, 0, None, None) | |
| 2015-08-18 03:25:36,015 INFO sqlalchemy.engine.base.Engine | |
| CREATE TABLE c ( | |
| b_a_id INTEGER NOT NULL, | |
| data3 VARCHAR(128) NULL, | |
| PRIMARY KEY (b_a_id), | |
| FOREIGN KEY(b_a_id) REFERENCES b (a_id) | |
| ) | |
| 2015-08-18 03:25:36,016 INFO sqlalchemy.engine.base.Engine () | |
| 2015-08-18 03:25:36,053 INFO sqlalchemy.engine.base.Engine ROLLBACK | |
| 2015-08-18 03:25:36,054 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344190> being returned to pool | |
| 2015-08-18 03:25:36,054 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344190> rollback-on-return | |
| ---------------------------------------------------------------------------------------------- Captured stderr setup ---------------------------------------------------------------------------------------------- | |
| DEBUG:sqlalchemy.pool.QueuePool:Created new connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344190> | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344190> checked out from pool | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| INFO:sqlalchemy.engine.base.Engine:('a', u'jiva_user') | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| DEBUG:sqlalchemy.engine.base.Engine:Row (u'jiva_user', u'a', u'id', 'NO', u'int', 1, None, 10, 0, None, None) | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| INFO:sqlalchemy.engine.base.Engine:('c', u'jiva_user') | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| INFO:sqlalchemy.engine.base.Engine:('b', u'jiva_user') | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| DEBUG:sqlalchemy.engine.base.Engine:Row (u'jiva_user', u'b', u'id', 'NO', u'int', 1, None, 10, 0, None, None) | |
| INFO:sqlalchemy.engine.base.Engine: | |
| CREATE TABLE c ( | |
| b_a_id INTEGER NOT NULL, | |
| data3 VARCHAR(128) NULL, | |
| PRIMARY KEY (b_a_id), | |
| FOREIGN KEY(b_a_id) REFERENCES b (a_id) | |
| ) | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:ROLLBACK | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344190> being returned to pool | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344190> rollback-on-return | |
| ==================================================================================================== FAILURES ===================================================================================================== | |
| _____________________________________________________________________________________ ReflectionTest.test_db_qualified_items ______________________________________________________________________________________ | |
| Traceback (most recent call last): | |
| File "<string>", line 2, in test_db_qualified_items | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/util.py", line 196, in provide_metadata | |
| return fn(*args, **kw) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/dialect/mssql/test_reflection.py", line 111, in test_db_qualified_items | |
| 'constrained_columns': ['foo_id']}] | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/assertions.py", line 209, in eq_ | |
| assert a == b, msg or "%r != %r" % (a, b) | |
| AssertionError: [{'referred_table': u'foo', 'referred_columns': [u'id'], 'referred_schema': u'test_sqlalchemy.jiva_user', 'name': u'fkfoo', 'constrained_columns': [u'foo_id']}] != [{'referred_table': 'foo', 'constrained_columns': ['foo_id'], 'referred_schema': 'test.dbo', 'name': 'fkfoo', 'referred_columns': ['id']}] | |
| ---------------------------------------------------------------------------------------------- Captured stderr call ----------------------------------------------------------------------------------------------- | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c45af030> checked out from pool | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| INFO:sqlalchemy.engine.base.Engine:('foo', u'jiva_user') | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| INFO:sqlalchemy.engine.base.Engine:('bar', u'jiva_user') | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| INFO:sqlalchemy.engine.base.Engine: | |
| CREATE TABLE foo ( | |
| id INTEGER NOT NULL IDENTITY(1,1), | |
| PRIMARY KEY (id) | |
| ) | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| INFO:sqlalchemy.engine.base.Engine: | |
| CREATE TABLE bar ( | |
| id INTEGER NOT NULL IDENTITY(1,1), | |
| foo_id INTEGER NULL, | |
| PRIMARY KEY (id), | |
| CONSTRAINT fkfoo FOREIGN KEY(foo_id) REFERENCES foo (id) | |
| ) | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c45af030> being returned to pool | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c45af030> rollback-on-return | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c45af030> checked out from pool | |
| INFO:sqlalchemy.engine.base.Engine:select db_name() | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('',) | |
| DEBUG:sqlalchemy.engine.base.Engine:Row (u'test_sqlalchemy',) | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c45af030> being returned to pool | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c45af030> rollback-on-return | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c45af030> checked out from pool | |
| INFO:sqlalchemy.engine.base.Engine:SELECT user_name() | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('',) | |
| DEBUG:sqlalchemy.engine.base.Engine:Row (u'jiva_user',) | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c45af030> being returned to pool | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c45af030> rollback-on-return | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c45af030> checked out from pool | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c45af030> being returned to pool | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c45af030> rollback-on-return | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c45af030> checked out from pool | |
| INFO:sqlalchemy.engine.base.Engine:select db_name() | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('',) | |
| DEBUG:sqlalchemy.engine.base.Engine:Row (u'test_sqlalchemy',) | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c45af030> being returned to pool | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c45af030> rollback-on-return | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c45af030> checked out from pool | |
| INFO:sqlalchemy.engine.base.Engine:use test_sqlalchemy | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| /home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py:150: Warning: ('01000', 5701, "[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Changed database context to 'test_sqlalchemy'.", 11245) | |
| cursor.execute(statement, parameters, direct=self._get_direct(context)) | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c45af030> being returned to pool | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c45af030> rollback-on-return | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c45af030> checked out from pool | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [C].[COLUMN_NAME], [R].[TABLE_SCHEMA], [R].[TABLE_NAME], [R].[COLUMN_NAME], [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS].[CONSTRAINT_NAME], [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS].[MATCH_OPTION], [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS].[UPDATE_RULE], [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS].[DELETE_RULE] | |
| FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] AS [C], [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] AS [R], [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] | |
| WHERE [C].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [C].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) AND [C].[CONSTRAINT_NAME] = [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS].[CONSTRAINT_NAME] AND [R].[CONSTRAINT_NAME] = [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS].[UNIQUE_CONSTRAINT_NAME] AND [C].[ORDINAL_POSITION] = [R].[ORDINAL_POSITION] ORDER BY [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS].[CONSTRAINT_NAME], [R].[ORDINAL_POSITION] | |
| INFO:sqlalchemy.engine.base.Engine:(u'bar', u'jiva_user') | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('COLUMN_NAME', 'TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'CONSTRAINT_NAME', 'MATCH_OPTION', 'UPDATE_RULE', 'DELETE_RULE') | |
| DEBUG:sqlalchemy.engine.base.Engine:Row (u'foo_id', u'jiva_user', u'foo', u'id', u'fkfoo', 'SIMPLE', 'NO ACTION', 'NO ACTION') | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c45af030> being returned to pool | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c45af030> rollback-on-return | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c45af030> checked out from pool | |
| INFO:sqlalchemy.engine.base.Engine:use test_sqlalchemy | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c45af030> being returned to pool | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c45af030> rollback-on-return | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c45af030> checked out from pool | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| INFO:sqlalchemy.engine.base.Engine:('foo', u'jiva_user') | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| DEBUG:sqlalchemy.engine.base.Engine:Row (u'jiva_user', u'foo', u'id', 'NO', u'int', 1, None, 10, 0, None, None) | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| INFO:sqlalchemy.engine.base.Engine:('bar', u'jiva_user') | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| DEBUG:sqlalchemy.engine.base.Engine:Row (u'jiva_user', u'bar', u'id', 'NO', u'int', 1, None, 10, 0, None, None) | |
| INFO:sqlalchemy.engine.base.Engine: | |
| DROP TABLE bar | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| INFO:sqlalchemy.engine.base.Engine: | |
| DROP TABLE foo | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c45af030> being returned to pool | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c45af030> rollback-on-return | |
| _____________________________________________________________________ CompoundSelectTest_mssql_mxodbc.test_limit_offset_selectable_in_unions ______________________________________________________________________ | |
| Traceback (most recent call last): | |
| File "<string>", line 2, in test_limit_offset_selectable_in_unions | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/exclusions.py", line 94, in decorate | |
| return self._do(config._current, fn, *args, **kw) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/exclusions.py", line 123, in _do | |
| self._expect_failure(config, ex, name=fn.__name__) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/exclusions.py", line 135, in _expect_failure | |
| util.raise_from_cause(ex) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/util/compat.py", line 199, in raise_from_cause | |
| reraise(type(exception), exception, tb=exc_tb) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/exclusions.py", line 121, in _do | |
| return_value = fn(*args, **kw) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/suite/test_select.py", line 256, in test_limit_offset_selectable_in_unions | |
| [(2, 2, 3), (3, 3, 4)] | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/suite/test_select.py", line 219, in _assert_result | |
| config.db.execute(select, params).fetchall(), | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1991, in execute | |
| return connection.execute(statement, *multiparams, **params) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 914, in execute | |
| return meth(self, multiparams, params) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection | |
| return connection._execute_clauseelement(self, multiparams, params) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement | |
| compiled_sql, distilled_params | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context | |
| context) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception | |
| exc_info | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/util/compat.py", line 199, in raise_from_cause | |
| reraise(type(exception), exception, tb=exc_tb) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context | |
| context) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 150, in do_execute | |
| cursor.execute(statement, parameters, direct=self._get_direct(context)) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 86, in error_handler | |
| raise errorclass(errorvalue) | |
| ProgrammingError: (mx.ODBC.Error.ProgrammingError) ('42000', 156, "[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near the keyword 'ORDER'.", 11159) [SQL: u'(SELECT TOP 1 some_table.id, some_table.x, some_table.y \nFROM some_table \nWHERE some_table.id = ? ORDER BY some_table.id) UNION (SELECT TOP 1 some_table.id, some_table.x, some_table.y \nFROM some_table \nWHERE some_table.id = ? ORDER BY some_table.id) ORDER BY id'] [parameters: (2, 3)] | |
| ---------------------------------------------------------------------------------------------- Captured stderr setup ---------------------------------------------------------------------------------------------- | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a002f0> checked out from pool | |
| INFO:sqlalchemy.engine.base.Engine:SET IDENTITY_INSERT some_table ON | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:INSERT INTO some_table (id, x, y) VALUES (?, ?, ?) | |
| INFO:sqlalchemy.engine.base.Engine:((1, 1, 2), (2, 2, 3), (3, 3, 4), (4, 4, 5)) | |
| INFO:sqlalchemy.engine.base.Engine:SET IDENTITY_INSERT some_table OFF | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a002f0> being returned to pool | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a002f0> rollback-on-return | |
| ---------------------------------------------------------------------------------------------- Captured stderr call ----------------------------------------------------------------------------------------------- | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a002f0> checked out from pool | |
| INFO:sqlalchemy.engine.base.Engine:(SELECT TOP 1 some_table.id, some_table.x, some_table.y | |
| FROM some_table | |
| WHERE some_table.id = ? ORDER BY some_table.id) UNION (SELECT TOP 1 some_table.id, some_table.x, some_table.y | |
| FROM some_table | |
| WHERE some_table.id = ? ORDER BY some_table.id) ORDER BY id | |
| INFO:sqlalchemy.engine.base.Engine:(2, 3) | |
| INFO:sqlalchemy.engine.base.Engine:ROLLBACK | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a002f0> being returned to pool | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a002f0> rollback-on-return | |
| _________________________________________________________________________________ NumericTest_mssql_mxodbc.test_float_as_decimal __________________________________________________________________________________ | |
| Traceback (most recent call last): | |
| File "<string>", line 2, in test_float_as_decimal | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/exclusions.py", line 94, in decorate | |
| return self._do(config._current, fn, *args, **kw) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/exclusions.py", line 123, in _do | |
| self._expect_failure(config, ex, name=fn.__name__) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/exclusions.py", line 135, in _expect_failure | |
| util.raise_from_cause(ex) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/util/compat.py", line 199, in raise_from_cause | |
| reraise(type(exception), exception, tb=exc_tb) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/exclusions.py", line 121, in _do | |
| return_value = fn(*args, **kw) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/suite/test_types.py", line 423, in test_float_as_decimal | |
| [decimal.Decimal("15.7563"), None], | |
| File "<string>", line 2, in _do_test | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/assertions.py", line 69, in decorate | |
| return fn(*args, **kw) | |
| File "<string>", line 2, in _do_test | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/util.py", line 196, in provide_metadata | |
| return fn(*args, **kw) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/suite/test_types.py", line 348, in _do_test | |
| eq_(result, output) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/assertions.py", line 209, in eq_ | |
| assert a == b, msg or "%r != %r" % (a, b) | |
| AssertionError: set([15.75629997253418, None]) != set([None, Decimal('15.7563')]) | |
| ---------------------------------------------------------------------------------------------- Captured stderr call ----------------------------------------------------------------------------------------------- | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00450> checked out from pool | |
| INFO:sqlalchemy.engine.base.Engine: | |
| CREATE TABLE t ( | |
| x FLOAT(8) NULL | |
| ) | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00450> being returned to pool | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00450> rollback-on-return | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00450> checked out from pool | |
| INFO:sqlalchemy.engine.base.Engine:INSERT INTO t (x) VALUES (?) | |
| INFO:sqlalchemy.engine.base.Engine:((15.7563,), (Decimal('15.7563'),), (None,)) | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00450> being returned to pool | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00450> rollback-on-return | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00450> checked out from pool | |
| INFO:sqlalchemy.engine.base.Engine:SELECT t.x | |
| FROM t | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('x',) | |
| DEBUG:sqlalchemy.engine.base.Engine:Row (15.75629997253418,) | |
| DEBUG:sqlalchemy.engine.base.Engine:Row (15.75629997253418,) | |
| DEBUG:sqlalchemy.engine.base.Engine:Row (None,) | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00450> being returned to pool | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00450> rollback-on-return | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00450> checked out from pool | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| INFO:sqlalchemy.engine.base.Engine:('t', u'jiva_user') | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| DEBUG:sqlalchemy.engine.base.Engine:Row (u'jiva_user', u't', u'x', 'YES', u'real', 1, None, 24, None, None, None) | |
| INFO:sqlalchemy.engine.base.Engine: | |
| DROP TABLE t | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00450> being returned to pool | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00450> rollback-on-return | |
| ________________________________________________________________________________ NumericTest_mssql_mxodbc.test_float_custom_scale _________________________________________________________________________________ | |
| Traceback (most recent call last): | |
| File "<string>", line 2, in test_float_custom_scale | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/exclusions.py", line 94, in decorate | |
| return self._do(config._current, fn, *args, **kw) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/exclusions.py", line 123, in _do | |
| self._expect_failure(config, ex, name=fn.__name__) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/exclusions.py", line 135, in _expect_failure | |
| util.raise_from_cause(ex) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/util/compat.py", line 199, in raise_from_cause | |
| reraise(type(exception), exception, tb=exc_tb) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/exclusions.py", line 121, in _do | |
| return_value = fn(*args, **kw) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/suite/test_types.py", line 385, in test_float_custom_scale | |
| check_scale=True | |
| File "<string>", line 2, in _do_test | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/assertions.py", line 69, in decorate | |
| return fn(*args, **kw) | |
| File "<string>", line 2, in _do_test | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/util.py", line 196, in provide_metadata | |
| return fn(*args, **kw) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/suite/test_types.py", line 348, in _do_test | |
| eq_(result, output) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/assertions.py", line 209, in eq_ | |
| assert a == b, msg or "%r != %r" % (a, b) | |
| AssertionError: set([15.7563827]) != set([Decimal('15.7563827')]) | |
| ---------------------------------------------------------------------------------------------- Captured stderr call ----------------------------------------------------------------------------------------------- | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00450> checked out from pool | |
| INFO:sqlalchemy.engine.base.Engine: | |
| CREATE TABLE t ( | |
| x FLOAT NULL | |
| ) | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00450> being returned to pool | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00450> rollback-on-return | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00450> checked out from pool | |
| INFO:sqlalchemy.engine.base.Engine:INSERT INTO t (x) VALUES (?) | |
| INFO:sqlalchemy.engine.base.Engine:((15.7563827,), (Decimal('15.7563827'),)) | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00450> being returned to pool | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00450> rollback-on-return | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00450> checked out from pool | |
| INFO:sqlalchemy.engine.base.Engine:SELECT t.x | |
| FROM t | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('x',) | |
| DEBUG:sqlalchemy.engine.base.Engine:Row (15.7563827,) | |
| DEBUG:sqlalchemy.engine.base.Engine:Row (15.7563827,) | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00450> being returned to pool | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00450> rollback-on-return | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00450> checked out from pool | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| INFO:sqlalchemy.engine.base.Engine:('t', u'jiva_user') | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| DEBUG:sqlalchemy.engine.base.Engine:Row (u'jiva_user', u't', u'x', 'YES', u'float', 1, None, 53, None, None, None) | |
| INFO:sqlalchemy.engine.base.Engine: | |
| DROP TABLE t | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00450> being returned to pool | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00450> rollback-on-return | |
| _____________________________________________________________________________________ Ticket2419Test.test_join_w_eager_w_any ______________________________________________________________________________________ | |
| Traceback (most recent call last): | |
| File "<string>", line 2, in test_join_w_eager_w_any | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/exclusions.py", line 94, in decorate | |
| return self._do(config._current, fn, *args, **kw) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/exclusions.py", line 123, in _do | |
| self._expect_failure(config, ex, name=fn.__name__) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/exclusions.py", line 135, in _expect_failure | |
| util.raise_from_cause(ex) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/util/compat.py", line 199, in raise_from_cause | |
| reraise(type(exception), exception, tb=exc_tb) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/exclusions.py", line 121, in _do | |
| return_value = fn(*args, **kw) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/orm/inheritance/test_assorted_poly.py", line 1521, in test_join_w_eager_w_any | |
| q.all(), | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/orm/query.py", line 2411, in all | |
| return list(self) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/orm/query.py", line 2528, in __iter__ | |
| return self._execute_and_instances(context) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/orm/query.py", line 2543, in _execute_and_instances | |
| result = conn.execute(querycontext.statement, self._params) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 914, in execute | |
| return meth(self, multiparams, params) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection | |
| return connection._execute_clauseelement(self, multiparams, params) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement | |
| compiled_sql, distilled_params | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context | |
| context) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception | |
| exc_info | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/util/compat.py", line 199, in raise_from_cause | |
| reraise(type(exception), exception, tb=exc_tb) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context | |
| context) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 150, in do_execute | |
| cursor.execute(statement, parameters, direct=self._get_direct(context)) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 86, in error_handler | |
| raise errorclass(errorvalue) | |
| ProgrammingError: (mx.ODBC.Error.ProgrammingError) ('42000', 156, "[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near the keyword 'EXISTS'.", 11159) [SQL: u'SELECT anon_1.b_id AS anon_1_b_id, anon_1.anon_2 AS anon_1_anon_2, e_1.id AS e_1_id, e_1.b_id AS e_1_b_id \nFROM (SELECT TOP 5 b.id AS b_id, EXISTS (SELECT 1 \nFROM d \nWHERE b.id = d.b_id AND d.id = ?) AS anon_2 \nFROM b JOIN (a JOIN c ON a.id = c.id) ON c.b_id = b.id) AS anon_1 LEFT OUTER JOIN e AS e_1 ON anon_1.b_id = e_1.b_id'] [parameters: (1,)] | |
| ---------------------------------------------------------------------------------------------- Captured stdout setup ---------------------------------------------------------------------------------------------- | |
| 2015-08-18 03:24:45,590 DEBUG sqlalchemy.pool.QueuePool Created new connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00f50> | |
| 2015-08-18 03:24:45,592 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00f50> checked out from pool | |
| 2015-08-18 03:24:45,598 INFO sqlalchemy.engine.base.Engine SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| 2015-08-18 03:24:45,599 INFO sqlalchemy.engine.base.Engine ('a', u'jiva_user') | |
| 2015-08-18 03:24:45,692 DEBUG sqlalchemy.engine.base.Engine Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| 2015-08-18 03:24:45,698 INFO sqlalchemy.engine.base.Engine SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| 2015-08-18 03:24:45,699 INFO sqlalchemy.engine.base.Engine ('c', u'jiva_user') | |
| 2015-08-18 03:24:45,757 DEBUG sqlalchemy.engine.base.Engine Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| 2015-08-18 03:24:45,761 INFO sqlalchemy.engine.base.Engine SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| 2015-08-18 03:24:45,762 INFO sqlalchemy.engine.base.Engine ('b', u'jiva_user') | |
| 2015-08-18 03:24:45,820 DEBUG sqlalchemy.engine.base.Engine Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| 2015-08-18 03:24:45,826 INFO sqlalchemy.engine.base.Engine SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| 2015-08-18 03:24:45,827 INFO sqlalchemy.engine.base.Engine ('e', u'jiva_user') | |
| 2015-08-18 03:24:45,885 DEBUG sqlalchemy.engine.base.Engine Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| 2015-08-18 03:24:45,892 INFO sqlalchemy.engine.base.Engine SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| 2015-08-18 03:24:45,893 INFO sqlalchemy.engine.base.Engine ('d', u'jiva_user') | |
| 2015-08-18 03:24:45,955 DEBUG sqlalchemy.engine.base.Engine Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| 2015-08-18 03:24:45,958 INFO sqlalchemy.engine.base.Engine | |
| CREATE TABLE a ( | |
| id INTEGER NOT NULL IDENTITY(1,1), | |
| PRIMARY KEY (id) | |
| ) | |
| 2015-08-18 03:24:45,959 INFO sqlalchemy.engine.base.Engine () | |
| 2015-08-18 03:24:46,000 INFO sqlalchemy.engine.base.Engine COMMIT | |
| 2015-08-18 03:24:46,032 INFO sqlalchemy.engine.base.Engine | |
| CREATE TABLE b ( | |
| id INTEGER NOT NULL IDENTITY(1,1), | |
| PRIMARY KEY (id) | |
| ) | |
| 2015-08-18 03:24:46,033 INFO sqlalchemy.engine.base.Engine () | |
| 2015-08-18 03:24:46,069 INFO sqlalchemy.engine.base.Engine COMMIT | |
| 2015-08-18 03:24:46,102 INFO sqlalchemy.engine.base.Engine | |
| CREATE TABLE c ( | |
| id INTEGER NOT NULL, | |
| b_id INTEGER NULL, | |
| PRIMARY KEY (id), | |
| FOREIGN KEY(id) REFERENCES a (id), | |
| FOREIGN KEY(b_id) REFERENCES b (id) | |
| ) | |
| 2015-08-18 03:24:46,102 INFO sqlalchemy.engine.base.Engine () | |
| 2015-08-18 03:24:46,139 INFO sqlalchemy.engine.base.Engine COMMIT | |
| 2015-08-18 03:24:46,170 INFO sqlalchemy.engine.base.Engine | |
| CREATE TABLE e ( | |
| id INTEGER NOT NULL IDENTITY(1,1), | |
| b_id INTEGER NULL, | |
| PRIMARY KEY (id), | |
| FOREIGN KEY(b_id) REFERENCES b (id) | |
| ) | |
| 2015-08-18 03:24:46,171 INFO sqlalchemy.engine.base.Engine () | |
| 2015-08-18 03:24:46,207 INFO sqlalchemy.engine.base.Engine COMMIT | |
| 2015-08-18 03:24:46,239 INFO sqlalchemy.engine.base.Engine | |
| CREATE TABLE d ( | |
| id INTEGER NOT NULL IDENTITY(1,1), | |
| b_id INTEGER NULL, | |
| PRIMARY KEY (id), | |
| FOREIGN KEY(b_id) REFERENCES b (id) | |
| ) | |
| 2015-08-18 03:24:46,239 INFO sqlalchemy.engine.base.Engine () | |
| 2015-08-18 03:24:46,273 INFO sqlalchemy.engine.base.Engine COMMIT | |
| 2015-08-18 03:24:46,303 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00f50> being returned to pool | |
| 2015-08-18 03:24:46,303 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00f50> rollback-on-return | |
| 2015-08-18 03:24:46,305 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00f50> checked out from pool | |
| 2015-08-18 03:24:46,311 INFO sqlalchemy.engine.base.Engine SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| 2015-08-18 03:24:46,312 INFO sqlalchemy.engine.base.Engine ('a', u'jiva_user') | |
| 2015-08-18 03:24:46,371 DEBUG sqlalchemy.engine.base.Engine Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| 2015-08-18 03:24:46,371 DEBUG sqlalchemy.engine.base.Engine Row (u'jiva_user', u'a', u'id', 'NO', u'int', 1, None, 10, 0, None, None) | |
| 2015-08-18 03:24:46,375 INFO sqlalchemy.engine.base.Engine SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| 2015-08-18 03:24:46,375 INFO sqlalchemy.engine.base.Engine ('c', u'jiva_user') | |
| 2015-08-18 03:24:46,433 DEBUG sqlalchemy.engine.base.Engine Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| 2015-08-18 03:24:46,434 DEBUG sqlalchemy.engine.base.Engine Row (u'jiva_user', u'c', u'id', 'NO', u'int', 1, None, 10, 0, None, None) | |
| 2015-08-18 03:24:46,436 INFO sqlalchemy.engine.base.Engine SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| 2015-08-18 03:24:46,437 INFO sqlalchemy.engine.base.Engine ('b', u'jiva_user') | |
| 2015-08-18 03:24:46,498 DEBUG sqlalchemy.engine.base.Engine Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| 2015-08-18 03:24:46,498 DEBUG sqlalchemy.engine.base.Engine Row (u'jiva_user', u'b', u'id', 'NO', u'int', 1, None, 10, 0, None, None) | |
| 2015-08-18 03:24:46,500 INFO sqlalchemy.engine.base.Engine SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| 2015-08-18 03:24:46,501 INFO sqlalchemy.engine.base.Engine ('e', u'jiva_user') | |
| 2015-08-18 03:24:46,563 DEBUG sqlalchemy.engine.base.Engine Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| 2015-08-18 03:24:46,564 DEBUG sqlalchemy.engine.base.Engine Row (u'jiva_user', u'e', u'id', 'NO', u'int', 1, None, 10, 0, None, None) | |
| 2015-08-18 03:24:46,570 INFO sqlalchemy.engine.base.Engine SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| 2015-08-18 03:24:46,571 INFO sqlalchemy.engine.base.Engine ('d', u'jiva_user') | |
| 2015-08-18 03:24:46,634 DEBUG sqlalchemy.engine.base.Engine Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| 2015-08-18 03:24:46,634 DEBUG sqlalchemy.engine.base.Engine Row (u'jiva_user', u'd', u'id', 'NO', u'int', 1, None, 10, 0, None, None) | |
| 2015-08-18 03:24:46,635 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00f50> being returned to pool | |
| 2015-08-18 03:24:46,636 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00f50> rollback-on-return | |
| ---------------------------------------------------------------------------------------------- Captured stderr setup ---------------------------------------------------------------------------------------------- | |
| DEBUG:sqlalchemy.pool.QueuePool:Created new connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00f50> | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00f50> checked out from pool | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| INFO:sqlalchemy.engine.base.Engine:('a', u'jiva_user') | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| INFO:sqlalchemy.engine.base.Engine:('c', u'jiva_user') | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| INFO:sqlalchemy.engine.base.Engine:('b', u'jiva_user') | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| INFO:sqlalchemy.engine.base.Engine:('e', u'jiva_user') | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| INFO:sqlalchemy.engine.base.Engine:('d', u'jiva_user') | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| INFO:sqlalchemy.engine.base.Engine: | |
| CREATE TABLE a ( | |
| id INTEGER NOT NULL IDENTITY(1,1), | |
| PRIMARY KEY (id) | |
| ) | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| INFO:sqlalchemy.engine.base.Engine: | |
| CREATE TABLE b ( | |
| id INTEGER NOT NULL IDENTITY(1,1), | |
| PRIMARY KEY (id) | |
| ) | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| INFO:sqlalchemy.engine.base.Engine: | |
| CREATE TABLE c ( | |
| id INTEGER NOT NULL, | |
| b_id INTEGER NULL, | |
| PRIMARY KEY (id), | |
| FOREIGN KEY(id) REFERENCES a (id), | |
| FOREIGN KEY(b_id) REFERENCES b (id) | |
| ) | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| INFO:sqlalchemy.engine.base.Engine: | |
| CREATE TABLE e ( | |
| id INTEGER NOT NULL IDENTITY(1,1), | |
| b_id INTEGER NULL, | |
| PRIMARY KEY (id), | |
| FOREIGN KEY(b_id) REFERENCES b (id) | |
| ) | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| INFO:sqlalchemy.engine.base.Engine: | |
| CREATE TABLE d ( | |
| id INTEGER NOT NULL IDENTITY(1,1), | |
| b_id INTEGER NULL, | |
| PRIMARY KEY (id), | |
| FOREIGN KEY(b_id) REFERENCES b (id) | |
| ) | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00f50> being returned to pool | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00f50> rollback-on-return | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00f50> checked out from pool | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| INFO:sqlalchemy.engine.base.Engine:('a', u'jiva_user') | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| DEBUG:sqlalchemy.engine.base.Engine:Row (u'jiva_user', u'a', u'id', 'NO', u'int', 1, None, 10, 0, None, None) | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| INFO:sqlalchemy.engine.base.Engine:('c', u'jiva_user') | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| DEBUG:sqlalchemy.engine.base.Engine:Row (u'jiva_user', u'c', u'id', 'NO', u'int', 1, None, 10, 0, None, None) | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| INFO:sqlalchemy.engine.base.Engine:('b', u'jiva_user') | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| DEBUG:sqlalchemy.engine.base.Engine:Row (u'jiva_user', u'b', u'id', 'NO', u'int', 1, None, 10, 0, None, None) | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| INFO:sqlalchemy.engine.base.Engine:('e', u'jiva_user') | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| DEBUG:sqlalchemy.engine.base.Engine:Row (u'jiva_user', u'e', u'id', 'NO', u'int', 1, None, 10, 0, None, None) | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| INFO:sqlalchemy.engine.base.Engine:('d', u'jiva_user') | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| DEBUG:sqlalchemy.engine.base.Engine:Row (u'jiva_user', u'd', u'id', 'NO', u'int', 1, None, 10, 0, None, None) | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00f50> being returned to pool | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00f50> rollback-on-return | |
| ---------------------------------------------------------------------------------------------- Captured stdout call ----------------------------------------------------------------------------------------------- | |
| 2015-08-18 03:24:46,677 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00f50> checked out from pool | |
| 2015-08-18 03:24:46,677 INFO sqlalchemy.engine.base.Engine BEGIN (implicit) | |
| 2015-08-18 03:24:46,679 INFO sqlalchemy.engine.base.Engine INSERT INTO b OUTPUT inserted.id DEFAULT VALUES | |
| 2015-08-18 03:24:46,679 INFO sqlalchemy.engine.base.Engine () | |
| 2015-08-18 03:24:46,709 DEBUG sqlalchemy.engine.base.Engine Col ('id',) | |
| 2015-08-18 03:24:46,709 DEBUG sqlalchemy.engine.base.Engine Row (1,) | |
| 2015-08-18 03:24:46,712 INFO sqlalchemy.engine.base.Engine INSERT INTO a OUTPUT inserted.id DEFAULT VALUES | |
| 2015-08-18 03:24:46,712 INFO sqlalchemy.engine.base.Engine () | |
| 2015-08-18 03:24:46,742 DEBUG sqlalchemy.engine.base.Engine Col ('id',) | |
| 2015-08-18 03:24:46,743 DEBUG sqlalchemy.engine.base.Engine Row (1,) | |
| 2015-08-18 03:24:46,744 INFO sqlalchemy.engine.base.Engine INSERT INTO c (id, b_id) VALUES (?, ?) | |
| 2015-08-18 03:24:46,744 INFO sqlalchemy.engine.base.Engine (1, 1) | |
| 2015-08-18 03:24:46,779 INFO sqlalchemy.engine.base.Engine INSERT INTO d (b_id) OUTPUT inserted.id VALUES (?) | |
| 2015-08-18 03:24:46,779 INFO sqlalchemy.engine.base.Engine (1,) | |
| 2015-08-18 03:24:46,811 DEBUG sqlalchemy.engine.base.Engine Col ('id',) | |
| 2015-08-18 03:24:46,812 DEBUG sqlalchemy.engine.base.Engine Row (1,) | |
| 2015-08-18 03:24:46,813 INFO sqlalchemy.engine.base.Engine COMMIT | |
| 2015-08-18 03:24:46,844 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00f50> being returned to pool | |
| 2015-08-18 03:24:46,844 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00f50> rollback-on-return | |
| 2015-08-18 03:24:46,855 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00f50> checked out from pool | |
| 2015-08-18 03:24:46,856 INFO sqlalchemy.engine.base.Engine BEGIN (implicit) | |
| 2015-08-18 03:24:46,863 INFO sqlalchemy.engine.base.Engine SELECT anon_1.b_id AS anon_1_b_id, anon_1.anon_2 AS anon_1_anon_2, e_1.id AS e_1_id, e_1.b_id AS e_1_b_id | |
| FROM (SELECT TOP 5 b.id AS b_id, EXISTS (SELECT 1 | |
| FROM d | |
| WHERE b.id = d.b_id AND d.id = ?) AS anon_2 | |
| FROM b JOIN (a JOIN c ON a.id = c.id) ON c.b_id = b.id) AS anon_1 LEFT OUTER JOIN e AS e_1 ON anon_1.b_id = e_1.b_id | |
| 2015-08-18 03:24:46,864 INFO sqlalchemy.engine.base.Engine (1,) | |
| ---------------------------------------------------------------------------------------------- Captured stderr call ----------------------------------------------------------------------------------------------- | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00f50> checked out from pool | |
| INFO:sqlalchemy.engine.base.Engine:BEGIN (implicit) | |
| INFO:sqlalchemy.engine.base.Engine:INSERT INTO b OUTPUT inserted.id DEFAULT VALUES | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('id',) | |
| DEBUG:sqlalchemy.engine.base.Engine:Row (1,) | |
| INFO:sqlalchemy.engine.base.Engine:INSERT INTO a OUTPUT inserted.id DEFAULT VALUES | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('id',) | |
| DEBUG:sqlalchemy.engine.base.Engine:Row (1,) | |
| INFO:sqlalchemy.engine.base.Engine:INSERT INTO c (id, b_id) VALUES (?, ?) | |
| INFO:sqlalchemy.engine.base.Engine:(1, 1) | |
| INFO:sqlalchemy.engine.base.Engine:INSERT INTO d (b_id) OUTPUT inserted.id VALUES (?) | |
| INFO:sqlalchemy.engine.base.Engine:(1,) | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('id',) | |
| DEBUG:sqlalchemy.engine.base.Engine:Row (1,) | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00f50> being returned to pool | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00f50> rollback-on-return | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c3a00f50> checked out from pool | |
| INFO:sqlalchemy.engine.base.Engine:BEGIN (implicit) | |
| INFO:sqlalchemy.engine.base.Engine:SELECT anon_1.b_id AS anon_1_b_id, anon_1.anon_2 AS anon_1_anon_2, e_1.id AS e_1_id, e_1.b_id AS e_1_b_id | |
| FROM (SELECT TOP 5 b.id AS b_id, EXISTS (SELECT 1 | |
| FROM d | |
| WHERE b.id = d.b_id AND d.id = ?) AS anon_2 | |
| FROM b JOIN (a JOIN c ON a.id = c.id) ON c.b_id = b.id) AS anon_1 LEFT OUTER JOIN e AS e_1 ON anon_1.b_id = e_1.b_id | |
| INFO:sqlalchemy.engine.base.Engine:(1,) | |
| ________________________________________________________________________________________ InstancesTest.test_contains_eager ________________________________________________________________________________________ | |
| Traceback (most recent call last): | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/orm/test_froms.py", line 758, in test_contains_eager | |
| self.assert_sql_count(testing.db, go, 1) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/assertions.py", line 479, in assert_sql_count | |
| db, callable_, assertsql.CountStatements(count)) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/assertions.py", line 460, in assert_sql_execution | |
| callable_() | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/orm/test_froms.py", line 757, in go | |
| eq_(self.static.user_address_result, q.order_by(User.id).all()) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/orm/query.py", line 2411, in all | |
| return list(self) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/orm/query.py", line 2528, in __iter__ | |
| return self._execute_and_instances(context) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/orm/query.py", line 2543, in _execute_and_instances | |
| result = conn.execute(querycontext.statement, self._params) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 914, in execute | |
| return meth(self, multiparams, params) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection | |
| return connection._execute_clauseelement(self, multiparams, params) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement | |
| compiled_sql, distilled_params | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context | |
| context) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception | |
| exc_info | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/util/compat.py", line 199, in raise_from_cause | |
| reraise(type(exception), exception, tb=exc_tb) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context | |
| context) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 150, in do_execute | |
| cursor.execute(statement, parameters, direct=self._get_direct(context)) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 86, in error_handler | |
| raise errorclass(errorvalue) | |
| ProgrammingError: (mx.ODBC.Error.ProgrammingError) ('42000', 169, '[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]A column has been specified more than once in the order by list. Columns in the order by list must be unique.', 11245) [SQL: u'SELECT addresses_1.id AS addresses_1_id, addresses_1.user_id AS addresses_1_user_id, addresses_1.email_address AS addresses_1_email_address, users.id AS users_id, users.name AS users_name \nFROM users LEFT OUTER JOIN addresses AS addresses_1 ON users.id = addresses_1.user_id ORDER BY users.id, addresses_1.id, users.id'] | |
| ---------------------------------------------------------------------------------------------- Captured stdout setup ---------------------------------------------------------------------------------------------- | |
| 2015-08-18 03:45:56,278 DEBUG sqlalchemy.pool.QueuePool Created new connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> | |
| 2015-08-18 03:45:56,278 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> checked out from pool | |
| 2015-08-18 03:45:56,285 INFO sqlalchemy.engine.base.Engine SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| 2015-08-18 03:45:56,286 INFO sqlalchemy.engine.base.Engine ('email_bounces', u'jiva_user') | |
| 2015-08-18 03:45:56,344 DEBUG sqlalchemy.engine.base.Engine Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| 2015-08-18 03:45:56,348 INFO sqlalchemy.engine.base.Engine SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| 2015-08-18 03:45:56,349 INFO sqlalchemy.engine.base.Engine ('composite_pk_table', u'jiva_user') | |
| 2015-08-18 03:45:56,407 DEBUG sqlalchemy.engine.base.Engine Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| 2015-08-18 03:45:56,412 INFO sqlalchemy.engine.base.Engine SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| 2015-08-18 03:45:56,412 INFO sqlalchemy.engine.base.Engine ('users', u'jiva_user') | |
| 2015-08-18 03:45:56,469 DEBUG sqlalchemy.engine.base.Engine Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| 2015-08-18 03:45:56,474 INFO sqlalchemy.engine.base.Engine SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| 2015-08-18 03:45:56,474 INFO sqlalchemy.engine.base.Engine ('items', u'jiva_user') | |
| 2015-08-18 03:45:56,532 DEBUG sqlalchemy.engine.base.Engine Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| 2015-08-18 03:45:56,536 INFO sqlalchemy.engine.base.Engine SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| 2015-08-18 03:45:56,537 INFO sqlalchemy.engine.base.Engine ('order_items', u'jiva_user') | |
| 2015-08-18 03:45:56,595 DEBUG sqlalchemy.engine.base.Engine Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| 2015-08-18 03:45:56,600 INFO sqlalchemy.engine.base.Engine SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| 2015-08-18 03:45:56,601 INFO sqlalchemy.engine.base.Engine ('item_keywords', u'jiva_user') | |
| 2015-08-18 03:45:56,659 DEBUG sqlalchemy.engine.base.Engine Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| 2015-08-18 03:45:56,667 INFO sqlalchemy.engine.base.Engine SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| 2015-08-18 03:45:56,668 INFO sqlalchemy.engine.base.Engine ('dingalings', u'jiva_user') | |
| 2015-08-18 03:45:56,726 DEBUG sqlalchemy.engine.base.Engine Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| 2015-08-18 03:45:56,728 INFO sqlalchemy.engine.base.Engine SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| 2015-08-18 03:45:56,729 INFO sqlalchemy.engine.base.Engine ('keywords', u'jiva_user') | |
| 2015-08-18 03:45:56,787 DEBUG sqlalchemy.engine.base.Engine Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| 2015-08-18 03:45:56,792 INFO sqlalchemy.engine.base.Engine SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| 2015-08-18 03:45:56,793 INFO sqlalchemy.engine.base.Engine ('nodes', u'jiva_user') | |
| 2015-08-18 03:45:56,851 DEBUG sqlalchemy.engine.base.Engine Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| 2015-08-18 03:45:56,857 INFO sqlalchemy.engine.base.Engine SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| 2015-08-18 03:45:56,857 INFO sqlalchemy.engine.base.Engine ('orders', u'jiva_user') | |
| 2015-08-18 03:45:56,914 DEBUG sqlalchemy.engine.base.Engine Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| 2015-08-18 03:45:56,919 INFO sqlalchemy.engine.base.Engine SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| 2015-08-18 03:45:56,919 INFO sqlalchemy.engine.base.Engine ('addresses', u'jiva_user') | |
| 2015-08-18 03:45:56,977 DEBUG sqlalchemy.engine.base.Engine Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| 2015-08-18 03:45:56,981 INFO sqlalchemy.engine.base.Engine | |
| CREATE TABLE composite_pk_table ( | |
| i INTEGER NOT NULL IDENTITY(1,1), | |
| j INTEGER NOT NULL, | |
| k INTEGER NOT NULL, | |
| PRIMARY KEY (i, j) | |
| ) | |
| 2015-08-18 03:45:56,981 INFO sqlalchemy.engine.base.Engine () | |
| 2015-08-18 03:45:57,013 INFO sqlalchemy.engine.base.Engine COMMIT | |
| 2015-08-18 03:45:57,044 INFO sqlalchemy.engine.base.Engine | |
| CREATE TABLE users ( | |
| id INTEGER NOT NULL IDENTITY(1,1), | |
| name VARCHAR(30) NOT NULL, | |
| PRIMARY KEY (id) | |
| ) | |
| 2015-08-18 03:45:57,045 INFO sqlalchemy.engine.base.Engine () | |
| 2015-08-18 03:45:57,076 INFO sqlalchemy.engine.base.Engine COMMIT | |
| 2015-08-18 03:45:57,105 INFO sqlalchemy.engine.base.Engine | |
| CREATE TABLE items ( | |
| id INTEGER NOT NULL IDENTITY(1,1), | |
| description VARCHAR(30) NOT NULL, | |
| PRIMARY KEY (id) | |
| ) | |
| 2015-08-18 03:45:57,105 INFO sqlalchemy.engine.base.Engine () | |
| 2015-08-18 03:45:57,137 INFO sqlalchemy.engine.base.Engine COMMIT | |
| 2015-08-18 03:45:57,168 INFO sqlalchemy.engine.base.Engine | |
| CREATE TABLE keywords ( | |
| id INTEGER NOT NULL IDENTITY(1,1), | |
| name VARCHAR(30) NOT NULL, | |
| PRIMARY KEY (id) | |
| ) | |
| 2015-08-18 03:45:57,169 INFO sqlalchemy.engine.base.Engine () | |
| 2015-08-18 03:45:57,202 INFO sqlalchemy.engine.base.Engine COMMIT | |
| 2015-08-18 03:45:57,232 INFO sqlalchemy.engine.base.Engine | |
| CREATE TABLE nodes ( | |
| id INTEGER NOT NULL IDENTITY(1,1), | |
| parent_id INTEGER NULL, | |
| data VARCHAR(30) NULL, | |
| PRIMARY KEY (id), | |
| FOREIGN KEY(parent_id) REFERENCES nodes (id) | |
| ) | |
| 2015-08-18 03:45:57,232 INFO sqlalchemy.engine.base.Engine () | |
| 2015-08-18 03:45:57,265 INFO sqlalchemy.engine.base.Engine COMMIT | |
| 2015-08-18 03:45:57,295 INFO sqlalchemy.engine.base.Engine | |
| CREATE TABLE item_keywords ( | |
| item_id INTEGER NULL, | |
| keyword_id INTEGER NULL, | |
| FOREIGN KEY(item_id) REFERENCES items (id), | |
| FOREIGN KEY(keyword_id) REFERENCES keywords (id) | |
| ) | |
| 2015-08-18 03:45:57,295 INFO sqlalchemy.engine.base.Engine () | |
| 2015-08-18 03:45:57,328 INFO sqlalchemy.engine.base.Engine COMMIT | |
| 2015-08-18 03:45:57,357 INFO sqlalchemy.engine.base.Engine | |
| CREATE TABLE addresses ( | |
| id INTEGER NOT NULL IDENTITY(1,1), | |
| user_id INTEGER NULL, | |
| email_address VARCHAR(50) NOT NULL, | |
| PRIMARY KEY (id), | |
| FOREIGN KEY(user_id) REFERENCES users (id) | |
| ) | |
| 2015-08-18 03:45:57,357 INFO sqlalchemy.engine.base.Engine () | |
| 2015-08-18 03:45:57,389 INFO sqlalchemy.engine.base.Engine COMMIT | |
| 2015-08-18 03:45:57,424 INFO sqlalchemy.engine.base.Engine | |
| CREATE TABLE email_bounces ( | |
| id INTEGER NULL, | |
| bounces INTEGER NULL, | |
| FOREIGN KEY(id) REFERENCES addresses (id) | |
| ) | |
| 2015-08-18 03:45:57,425 INFO sqlalchemy.engine.base.Engine () | |
| 2015-08-18 03:45:57,458 INFO sqlalchemy.engine.base.Engine COMMIT | |
| 2015-08-18 03:45:57,490 INFO sqlalchemy.engine.base.Engine | |
| CREATE TABLE dingalings ( | |
| id INTEGER NOT NULL IDENTITY(1,1), | |
| address_id INTEGER NULL, | |
| data VARCHAR(30) NULL, | |
| PRIMARY KEY (id), | |
| FOREIGN KEY(address_id) REFERENCES addresses (id) | |
| ) | |
| 2015-08-18 03:45:57,491 INFO sqlalchemy.engine.base.Engine () | |
| 2015-08-18 03:45:57,525 INFO sqlalchemy.engine.base.Engine COMMIT | |
| 2015-08-18 03:45:57,556 INFO sqlalchemy.engine.base.Engine | |
| CREATE TABLE orders ( | |
| id INTEGER NOT NULL IDENTITY(1,1), | |
| user_id INTEGER NULL, | |
| address_id INTEGER NULL, | |
| description VARCHAR(30) NULL, | |
| isopen INTEGER NULL, | |
| PRIMARY KEY (id), | |
| FOREIGN KEY(user_id) REFERENCES users (id), | |
| FOREIGN KEY(address_id) REFERENCES addresses (id) | |
| ) | |
| 2015-08-18 03:45:57,556 INFO sqlalchemy.engine.base.Engine () | |
| 2015-08-18 03:45:57,592 INFO sqlalchemy.engine.base.Engine COMMIT | |
| 2015-08-18 03:45:57,621 INFO sqlalchemy.engine.base.Engine | |
| CREATE TABLE order_items ( | |
| item_id INTEGER NULL, | |
| order_id INTEGER NULL, | |
| FOREIGN KEY(item_id) REFERENCES items (id), | |
| FOREIGN KEY(order_id) REFERENCES orders (id) | |
| ) | |
| 2015-08-18 03:45:57,623 INFO sqlalchemy.engine.base.Engine () | |
| 2015-08-18 03:45:57,658 INFO sqlalchemy.engine.base.Engine COMMIT | |
| 2015-08-18 03:45:57,688 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> being returned to pool | |
| 2015-08-18 03:45:57,689 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> rollback-on-return | |
| 2015-08-18 03:45:57,807 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> checked out from pool | |
| 2015-08-18 03:45:57,808 INFO sqlalchemy.engine.base.Engine SET IDENTITY_INSERT composite_pk_table ON | |
| 2015-08-18 03:45:57,808 INFO sqlalchemy.engine.base.Engine () | |
| 2015-08-18 03:45:57,835 INFO sqlalchemy.engine.base.Engine INSERT INTO composite_pk_table (i, j, k) VALUES (?, ?, ?) | |
| 2015-08-18 03:45:57,835 INFO sqlalchemy.engine.base.Engine ((1, 2, 3), (2, 1, 4), (1, 1, 5), (2, 2, 6)) | |
| 2015-08-18 03:45:57,949 INFO sqlalchemy.engine.base.Engine SET IDENTITY_INSERT composite_pk_table OFF | |
| 2015-08-18 03:45:57,951 INFO sqlalchemy.engine.base.Engine () | |
| 2015-08-18 03:45:57,978 INFO sqlalchemy.engine.base.Engine COMMIT | |
| 2015-08-18 03:45:58,006 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> being returned to pool | |
| 2015-08-18 03:45:58,007 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> rollback-on-return | |
| 2015-08-18 03:45:58,008 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> checked out from pool | |
| 2015-08-18 03:45:58,009 INFO sqlalchemy.engine.base.Engine SET IDENTITY_INSERT items ON | |
| 2015-08-18 03:45:58,009 INFO sqlalchemy.engine.base.Engine () | |
| 2015-08-18 03:45:58,038 INFO sqlalchemy.engine.base.Engine INSERT INTO items (id, description) VALUES (?, ?) | |
| 2015-08-18 03:45:58,038 INFO sqlalchemy.engine.base.Engine ((1, 'item 1'), (2, 'item 2'), (3, 'item 3'), (4, 'item 4'), (5, 'item 5')) | |
| 2015-08-18 03:45:58,177 INFO sqlalchemy.engine.base.Engine SET IDENTITY_INSERT items OFF | |
| 2015-08-18 03:45:58,178 INFO sqlalchemy.engine.base.Engine () | |
| 2015-08-18 03:45:58,212 INFO sqlalchemy.engine.base.Engine COMMIT | |
| 2015-08-18 03:45:58,242 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> being returned to pool | |
| 2015-08-18 03:45:58,242 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> rollback-on-return | |
| 2015-08-18 03:45:58,242 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> checked out from pool | |
| 2015-08-18 03:45:58,243 INFO sqlalchemy.engine.base.Engine SET IDENTITY_INSERT keywords ON | |
| 2015-08-18 03:45:58,243 INFO sqlalchemy.engine.base.Engine () | |
| 2015-08-18 03:45:58,274 INFO sqlalchemy.engine.base.Engine INSERT INTO keywords (id, name) VALUES (?, ?) | |
| 2015-08-18 03:45:58,275 INFO sqlalchemy.engine.base.Engine ((1, 'blue'), (2, 'red'), (3, 'green'), (4, 'big'), (5, 'small'), (6, 'round'), (7, 'square')) | |
| 2015-08-18 03:45:58,485 INFO sqlalchemy.engine.base.Engine SET IDENTITY_INSERT keywords OFF | |
| 2015-08-18 03:45:58,486 INFO sqlalchemy.engine.base.Engine () | |
| 2015-08-18 03:45:58,514 INFO sqlalchemy.engine.base.Engine COMMIT | |
| 2015-08-18 03:45:58,542 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> being returned to pool | |
| 2015-08-18 03:45:58,543 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> rollback-on-return | |
| 2015-08-18 03:45:58,543 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> checked out from pool | |
| 2015-08-18 03:45:58,544 INFO sqlalchemy.engine.base.Engine SET IDENTITY_INSERT users ON | |
| 2015-08-18 03:45:58,545 INFO sqlalchemy.engine.base.Engine () | |
| 2015-08-18 03:45:58,572 INFO sqlalchemy.engine.base.Engine INSERT INTO users (id, name) VALUES (?, ?) | |
| 2015-08-18 03:45:58,573 INFO sqlalchemy.engine.base.Engine ((7, 'jack'), (8, 'ed'), (9, 'fred'), (10, 'chuck')) | |
| 2015-08-18 03:45:58,689 INFO sqlalchemy.engine.base.Engine SET IDENTITY_INSERT users OFF | |
| 2015-08-18 03:45:58,690 INFO sqlalchemy.engine.base.Engine () | |
| 2015-08-18 03:45:58,717 INFO sqlalchemy.engine.base.Engine COMMIT | |
| 2015-08-18 03:45:58,745 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> being returned to pool | |
| 2015-08-18 03:45:58,745 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> rollback-on-return | |
| 2015-08-18 03:45:58,746 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> checked out from pool | |
| 2015-08-18 03:45:58,747 INFO sqlalchemy.engine.base.Engine SET IDENTITY_INSERT addresses ON | |
| 2015-08-18 03:45:58,747 INFO sqlalchemy.engine.base.Engine () | |
| 2015-08-18 03:45:58,775 INFO sqlalchemy.engine.base.Engine INSERT INTO addresses (id, user_id, email_address) VALUES (?, ?, ?) | |
| 2015-08-18 03:45:58,776 INFO sqlalchemy.engine.base.Engine ((1, 7, '[email protected]'), (2, 8, '[email protected]'), (3, 8, '[email protected]'), (4, 8, '[email protected]'), (5, 9, '[email protected]')) | |
| 2015-08-18 03:45:58,924 INFO sqlalchemy.engine.base.Engine SET IDENTITY_INSERT addresses OFF | |
| 2015-08-18 03:45:58,924 INFO sqlalchemy.engine.base.Engine () | |
| 2015-08-18 03:45:58,951 INFO sqlalchemy.engine.base.Engine COMMIT | |
| 2015-08-18 03:45:58,980 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> being returned to pool | |
| 2015-08-18 03:45:58,981 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> rollback-on-return | |
| 2015-08-18 03:45:58,982 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> checked out from pool | |
| 2015-08-18 03:45:58,984 INFO sqlalchemy.engine.base.Engine INSERT INTO item_keywords (item_id, keyword_id) VALUES (?, ?) | |
| 2015-08-18 03:45:58,985 INFO sqlalchemy.engine.base.Engine ((1, 2), (2, 2), (1, 4), (1, 6), (2, 5), (3, 3), (3, 4), (2, 7), (3, 6)) | |
| 2015-08-18 03:45:59,247 INFO sqlalchemy.engine.base.Engine COMMIT | |
| 2015-08-18 03:45:59,280 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> being returned to pool | |
| 2015-08-18 03:45:59,281 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> rollback-on-return | |
| 2015-08-18 03:45:59,282 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> checked out from pool | |
| 2015-08-18 03:45:59,284 INFO sqlalchemy.engine.base.Engine SET IDENTITY_INSERT dingalings ON | |
| 2015-08-18 03:45:59,284 INFO sqlalchemy.engine.base.Engine () | |
| 2015-08-18 03:45:59,311 INFO sqlalchemy.engine.base.Engine INSERT INTO dingalings (id, address_id, data) VALUES (?, ?, ?) | |
| 2015-08-18 03:45:59,312 INFO sqlalchemy.engine.base.Engine ((1, 2, 'ding 1/2'), (2, 5, 'ding 2/5')) | |
| 2015-08-18 03:45:59,372 INFO sqlalchemy.engine.base.Engine SET IDENTITY_INSERT dingalings OFF | |
| 2015-08-18 03:45:59,373 INFO sqlalchemy.engine.base.Engine () | |
| 2015-08-18 03:45:59,399 INFO sqlalchemy.engine.base.Engine COMMIT | |
| 2015-08-18 03:45:59,430 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> being returned to pool | |
| 2015-08-18 03:45:59,431 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> rollback-on-return | |
| 2015-08-18 03:45:59,432 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> checked out from pool | |
| 2015-08-18 03:45:59,435 INFO sqlalchemy.engine.base.Engine INSERT INTO email_bounces (id, bounces) VALUES (?, ?) | |
| 2015-08-18 03:45:59,435 INFO sqlalchemy.engine.base.Engine ((1, 1), (2, 0), (3, 5), (4, 0), (5, 0)) | |
| 2015-08-18 03:45:59,578 INFO sqlalchemy.engine.base.Engine COMMIT | |
| 2015-08-18 03:45:59,606 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> being returned to pool | |
| 2015-08-18 03:45:59,607 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> rollback-on-return | |
| 2015-08-18 03:45:59,607 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> checked out from pool | |
| 2015-08-18 03:45:59,610 INFO sqlalchemy.engine.base.Engine SET IDENTITY_INSERT orders ON | |
| 2015-08-18 03:45:59,610 INFO sqlalchemy.engine.base.Engine () | |
| 2015-08-18 03:45:59,638 INFO sqlalchemy.engine.base.Engine INSERT INTO orders (id, user_id, address_id, description, isopen) VALUES (?, ?, ?, ?, ?) | |
| 2015-08-18 03:45:59,639 INFO sqlalchemy.engine.base.Engine ((1, 7, 1, 'order 1', 0), (2, 9, 4, 'order 2', 0), (3, 7, 1, 'order 3', 1), (4, 9, 4, 'order 4', 1), (5, 7, None, 'order 5', 0)) | |
| 2015-08-18 03:45:59,792 INFO sqlalchemy.engine.base.Engine SET IDENTITY_INSERT orders OFF | |
| 2015-08-18 03:45:59,793 INFO sqlalchemy.engine.base.Engine () | |
| 2015-08-18 03:45:59,821 INFO sqlalchemy.engine.base.Engine COMMIT | |
| 2015-08-18 03:45:59,851 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> being returned to pool | |
| 2015-08-18 03:45:59,852 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> rollback-on-return | |
| 2015-08-18 03:45:59,853 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> checked out from pool | |
| 2015-08-18 03:45:59,855 INFO sqlalchemy.engine.base.Engine INSERT INTO order_items (item_id, order_id) VALUES (?, ?) | |
| 2015-08-18 03:45:59,855 INFO sqlalchemy.engine.base.Engine ((1, 1), (2, 1), (3, 1), (1, 2), (2, 2), (3, 2), (3, 3), (4, 3) ... displaying 10 of 12 total bound parameter sets ... (5, 4), (5, 5)) | |
| 2015-08-18 03:46:00,198 INFO sqlalchemy.engine.base.Engine COMMIT | |
| 2015-08-18 03:46:00,229 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> being returned to pool | |
| 2015-08-18 03:46:00,230 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> rollback-on-return | |
| ---------------------------------------------------------------------------------------------- Captured stderr setup ---------------------------------------------------------------------------------------------- | |
| DEBUG:sqlalchemy.pool.QueuePool:Created new connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> checked out from pool | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| INFO:sqlalchemy.engine.base.Engine:('email_bounces', u'jiva_user') | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| INFO:sqlalchemy.engine.base.Engine:('composite_pk_table', u'jiva_user') | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| INFO:sqlalchemy.engine.base.Engine:('users', u'jiva_user') | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| INFO:sqlalchemy.engine.base.Engine:('items', u'jiva_user') | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| INFO:sqlalchemy.engine.base.Engine:('order_items', u'jiva_user') | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| INFO:sqlalchemy.engine.base.Engine:('item_keywords', u'jiva_user') | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| INFO:sqlalchemy.engine.base.Engine:('dingalings', u'jiva_user') | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| INFO:sqlalchemy.engine.base.Engine:('keywords', u'jiva_user') | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| INFO:sqlalchemy.engine.base.Engine:('nodes', u'jiva_user') | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| INFO:sqlalchemy.engine.base.Engine:('orders', u'jiva_user') | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| INFO:sqlalchemy.engine.base.Engine:SELECT [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA], [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_NAME], [INFORMATION_SCHEMA].[COLUMNS].[IS_NULLABLE], [INFORMATION_SCHEMA].[COLUMNS].[DATA_TYPE], [INFORMATION_SCHEMA].[COLUMNS].[ORDINAL_POSITION], [INFORMATION_SCHEMA].[COLUMNS].[CHARACTER_MAXIMUM_LENGTH], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_PRECISION], [INFORMATION_SCHEMA].[COLUMNS].[NUMERIC_SCALE], [INFORMATION_SCHEMA].[COLUMNS].[COLUMN_DEFAULT], [INFORMATION_SCHEMA].[COLUMNS].[COLLATION_NAME] | |
| FROM [INFORMATION_SCHEMA].[COLUMNS] | |
| WHERE [INFORMATION_SCHEMA].[COLUMNS].[TABLE_NAME] = CAST(? AS NVARCHAR(max)) AND [INFORMATION_SCHEMA].[COLUMNS].[TABLE_SCHEMA] = CAST(? AS NVARCHAR(max)) | |
| INFO:sqlalchemy.engine.base.Engine:('addresses', u'jiva_user') | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('TABLE_SCHEMA', 'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION', 'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE', 'COLUMN_DEFAULT', 'COLLATION_NAME') | |
| INFO:sqlalchemy.engine.base.Engine: | |
| CREATE TABLE composite_pk_table ( | |
| i INTEGER NOT NULL IDENTITY(1,1), | |
| j INTEGER NOT NULL, | |
| k INTEGER NOT NULL, | |
| PRIMARY KEY (i, j) | |
| ) | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| INFO:sqlalchemy.engine.base.Engine: | |
| CREATE TABLE users ( | |
| id INTEGER NOT NULL IDENTITY(1,1), | |
| name VARCHAR(30) NOT NULL, | |
| PRIMARY KEY (id) | |
| ) | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| INFO:sqlalchemy.engine.base.Engine: | |
| CREATE TABLE items ( | |
| id INTEGER NOT NULL IDENTITY(1,1), | |
| description VARCHAR(30) NOT NULL, | |
| PRIMARY KEY (id) | |
| ) | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| INFO:sqlalchemy.engine.base.Engine: | |
| CREATE TABLE keywords ( | |
| id INTEGER NOT NULL IDENTITY(1,1), | |
| name VARCHAR(30) NOT NULL, | |
| PRIMARY KEY (id) | |
| ) | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| INFO:sqlalchemy.engine.base.Engine: | |
| CREATE TABLE nodes ( | |
| id INTEGER NOT NULL IDENTITY(1,1), | |
| parent_id INTEGER NULL, | |
| data VARCHAR(30) NULL, | |
| PRIMARY KEY (id), | |
| FOREIGN KEY(parent_id) REFERENCES nodes (id) | |
| ) | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| INFO:sqlalchemy.engine.base.Engine: | |
| CREATE TABLE item_keywords ( | |
| item_id INTEGER NULL, | |
| keyword_id INTEGER NULL, | |
| FOREIGN KEY(item_id) REFERENCES items (id), | |
| FOREIGN KEY(keyword_id) REFERENCES keywords (id) | |
| ) | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| INFO:sqlalchemy.engine.base.Engine: | |
| CREATE TABLE addresses ( | |
| id INTEGER NOT NULL IDENTITY(1,1), | |
| user_id INTEGER NULL, | |
| email_address VARCHAR(50) NOT NULL, | |
| PRIMARY KEY (id), | |
| FOREIGN KEY(user_id) REFERENCES users (id) | |
| ) | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| INFO:sqlalchemy.engine.base.Engine: | |
| CREATE TABLE email_bounces ( | |
| id INTEGER NULL, | |
| bounces INTEGER NULL, | |
| FOREIGN KEY(id) REFERENCES addresses (id) | |
| ) | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| INFO:sqlalchemy.engine.base.Engine: | |
| CREATE TABLE dingalings ( | |
| id INTEGER NOT NULL IDENTITY(1,1), | |
| address_id INTEGER NULL, | |
| data VARCHAR(30) NULL, | |
| PRIMARY KEY (id), | |
| FOREIGN KEY(address_id) REFERENCES addresses (id) | |
| ) | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| INFO:sqlalchemy.engine.base.Engine: | |
| CREATE TABLE orders ( | |
| id INTEGER NOT NULL IDENTITY(1,1), | |
| user_id INTEGER NULL, | |
| address_id INTEGER NULL, | |
| description VARCHAR(30) NULL, | |
| isopen INTEGER NULL, | |
| PRIMARY KEY (id), | |
| FOREIGN KEY(user_id) REFERENCES users (id), | |
| FOREIGN KEY(address_id) REFERENCES addresses (id) | |
| ) | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| INFO:sqlalchemy.engine.base.Engine: | |
| CREATE TABLE order_items ( | |
| item_id INTEGER NULL, | |
| order_id INTEGER NULL, | |
| FOREIGN KEY(item_id) REFERENCES items (id), | |
| FOREIGN KEY(order_id) REFERENCES orders (id) | |
| ) | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> being returned to pool | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> rollback-on-return | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> checked out from pool | |
| INFO:sqlalchemy.engine.base.Engine:SET IDENTITY_INSERT composite_pk_table ON | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:INSERT INTO composite_pk_table (i, j, k) VALUES (?, ?, ?) | |
| INFO:sqlalchemy.engine.base.Engine:((1, 2, 3), (2, 1, 4), (1, 1, 5), (2, 2, 6)) | |
| INFO:sqlalchemy.engine.base.Engine:SET IDENTITY_INSERT composite_pk_table OFF | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> being returned to pool | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> rollback-on-return | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> checked out from pool | |
| INFO:sqlalchemy.engine.base.Engine:SET IDENTITY_INSERT items ON | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:INSERT INTO items (id, description) VALUES (?, ?) | |
| INFO:sqlalchemy.engine.base.Engine:((1, 'item 1'), (2, 'item 2'), (3, 'item 3'), (4, 'item 4'), (5, 'item 5')) | |
| INFO:sqlalchemy.engine.base.Engine:SET IDENTITY_INSERT items OFF | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> being returned to pool | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> rollback-on-return | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> checked out from pool | |
| INFO:sqlalchemy.engine.base.Engine:SET IDENTITY_INSERT keywords ON | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:INSERT INTO keywords (id, name) VALUES (?, ?) | |
| INFO:sqlalchemy.engine.base.Engine:((1, 'blue'), (2, 'red'), (3, 'green'), (4, 'big'), (5, 'small'), (6, 'round'), (7, 'square')) | |
| INFO:sqlalchemy.engine.base.Engine:SET IDENTITY_INSERT keywords OFF | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> being returned to pool | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> rollback-on-return | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> checked out from pool | |
| INFO:sqlalchemy.engine.base.Engine:SET IDENTITY_INSERT users ON | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:INSERT INTO users (id, name) VALUES (?, ?) | |
| INFO:sqlalchemy.engine.base.Engine:((7, 'jack'), (8, 'ed'), (9, 'fred'), (10, 'chuck')) | |
| INFO:sqlalchemy.engine.base.Engine:SET IDENTITY_INSERT users OFF | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> being returned to pool | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> rollback-on-return | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> checked out from pool | |
| INFO:sqlalchemy.engine.base.Engine:SET IDENTITY_INSERT addresses ON | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:INSERT INTO addresses (id, user_id, email_address) VALUES (?, ?, ?) | |
| INFO:sqlalchemy.engine.base.Engine:((1, 7, '[email protected]'), (2, 8, '[email protected]'), (3, 8, '[email protected]'), (4, 8, '[email protected]'), (5, 9, '[email protected]')) | |
| INFO:sqlalchemy.engine.base.Engine:SET IDENTITY_INSERT addresses OFF | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> being returned to pool | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> rollback-on-return | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> checked out from pool | |
| INFO:sqlalchemy.engine.base.Engine:INSERT INTO item_keywords (item_id, keyword_id) VALUES (?, ?) | |
| INFO:sqlalchemy.engine.base.Engine:((1, 2), (2, 2), (1, 4), (1, 6), (2, 5), (3, 3), (3, 4), (2, 7), (3, 6)) | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> being returned to pool | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> rollback-on-return | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> checked out from pool | |
| INFO:sqlalchemy.engine.base.Engine:SET IDENTITY_INSERT dingalings ON | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:INSERT INTO dingalings (id, address_id, data) VALUES (?, ?, ?) | |
| INFO:sqlalchemy.engine.base.Engine:((1, 2, 'ding 1/2'), (2, 5, 'ding 2/5')) | |
| INFO:sqlalchemy.engine.base.Engine:SET IDENTITY_INSERT dingalings OFF | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> being returned to pool | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> rollback-on-return | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> checked out from pool | |
| INFO:sqlalchemy.engine.base.Engine:INSERT INTO email_bounces (id, bounces) VALUES (?, ?) | |
| INFO:sqlalchemy.engine.base.Engine:((1, 1), (2, 0), (3, 5), (4, 0), (5, 0)) | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> being returned to pool | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> rollback-on-return | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> checked out from pool | |
| INFO:sqlalchemy.engine.base.Engine:SET IDENTITY_INSERT orders ON | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:INSERT INTO orders (id, user_id, address_id, description, isopen) VALUES (?, ?, ?, ?, ?) | |
| INFO:sqlalchemy.engine.base.Engine:((1, 7, 1, 'order 1', 0), (2, 9, 4, 'order 2', 0), (3, 7, 1, 'order 3', 1), (4, 9, 4, 'order 4', 1), (5, 7, None, 'order 5', 0)) | |
| INFO:sqlalchemy.engine.base.Engine:SET IDENTITY_INSERT orders OFF | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> being returned to pool | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> rollback-on-return | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> checked out from pool | |
| INFO:sqlalchemy.engine.base.Engine:INSERT INTO order_items (item_id, order_id) VALUES (?, ?) | |
| INFO:sqlalchemy.engine.base.Engine:((1, 1), (2, 1), (3, 1), (1, 2), (2, 2), (3, 2), (3, 3), (4, 3) ... displaying 10 of 12 total bound parameter sets ... (5, 4), (5, 5)) | |
| INFO:sqlalchemy.engine.base.Engine:COMMIT | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> being returned to pool | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> rollback-on-return | |
| ---------------------------------------------------------------------------------------------- Captured stdout call ----------------------------------------------------------------------------------------------- | |
| SQL String: | |
| SELECT addresses.id AS addresses_id, addresses.user_id AS addresses_user_id, addresses.email_address AS addresses_email_address, users.id AS users_id, users.name AS users_name | |
| FROM users LEFT OUTER JOIN addresses ON users.id = addresses.user_id ORDER BY users.id, addresses.id{} | |
| 2015-08-18 03:46:00,255 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> checked out from pool | |
| 2015-08-18 03:46:00,256 INFO sqlalchemy.engine.base.Engine SELECT addresses.id AS addresses_id, addresses.user_id AS addresses_user_id, addresses.email_address AS addresses_email_address, users.id AS users_id, users.name AS users_name | |
| FROM users LEFT OUTER JOIN addresses ON users.id = addresses.user_id ORDER BY users.id, addresses.id | |
| 2015-08-18 03:46:00,256 INFO sqlalchemy.engine.base.Engine () | |
| 2015-08-18 03:46:00,294 DEBUG sqlalchemy.engine.base.Engine Col ('addresses_id', 'addresses_user_id', 'addresses_email_address', 'users_id', 'users_name') | |
| 2015-08-18 03:46:00,295 DEBUG sqlalchemy.engine.base.Engine Row (1, 7, '[email protected]', 7, 'jack') | |
| 2015-08-18 03:46:00,296 DEBUG sqlalchemy.engine.base.Engine Row (2, 8, '[email protected]', 8, 'ed') | |
| 2015-08-18 03:46:00,296 DEBUG sqlalchemy.engine.base.Engine Row (3, 8, '[email protected]', 8, 'ed') | |
| 2015-08-18 03:46:00,296 DEBUG sqlalchemy.engine.base.Engine Row (4, 8, '[email protected]', 8, 'ed') | |
| 2015-08-18 03:46:00,296 DEBUG sqlalchemy.engine.base.Engine Row (5, 9, '[email protected]', 9, 'fred') | |
| 2015-08-18 03:46:00,296 DEBUG sqlalchemy.engine.base.Engine Row (None, None, None, 10, 'chuck') | |
| 2015-08-18 03:46:00,296 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> being returned to pool | |
| 2015-08-18 03:46:00,296 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> rollback-on-return | |
| 2015-08-18 03:46:00,325 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> checked out from pool | |
| 2015-08-18 03:46:00,326 INFO sqlalchemy.engine.base.Engine SELECT addresses_1.id AS addresses_1_id, addresses_1.user_id AS addresses_1_user_id, addresses_1.email_address AS addresses_1_email_address, users.id AS users_id, users.name AS users_name | |
| FROM users LEFT OUTER JOIN addresses AS addresses_1 ON users.id = addresses_1.user_id ORDER BY users.id, addresses_1.id, users.id | |
| 2015-08-18 03:46:00,326 INFO sqlalchemy.engine.base.Engine () | |
| 2015-08-18 03:46:00,356 INFO sqlalchemy.engine.base.Engine ROLLBACK | |
| 2015-08-18 03:46:00,383 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> being returned to pool | |
| 2015-08-18 03:46:00,383 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> rollback-on-return | |
| ---------------------------------------------------------------------------------------------- Captured stderr call ----------------------------------------------------------------------------------------------- | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> checked out from pool | |
| INFO:sqlalchemy.engine.base.Engine:SELECT addresses.id AS addresses_id, addresses.user_id AS addresses_user_id, addresses.email_address AS addresses_email_address, users.id AS users_id, users.name AS users_name | |
| FROM users LEFT OUTER JOIN addresses ON users.id = addresses.user_id ORDER BY users.id, addresses.id | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('addresses_id', 'addresses_user_id', 'addresses_email_address', 'users_id', 'users_name') | |
| DEBUG:sqlalchemy.engine.base.Engine:Row (1, 7, '[email protected]', 7, 'jack') | |
| DEBUG:sqlalchemy.engine.base.Engine:Row (2, 8, '[email protected]', 8, 'ed') | |
| DEBUG:sqlalchemy.engine.base.Engine:Row (3, 8, '[email protected]', 8, 'ed') | |
| DEBUG:sqlalchemy.engine.base.Engine:Row (4, 8, '[email protected]', 8, 'ed') | |
| DEBUG:sqlalchemy.engine.base.Engine:Row (5, 9, '[email protected]', 9, 'fred') | |
| DEBUG:sqlalchemy.engine.base.Engine:Row (None, None, None, 10, 'chuck') | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> being returned to pool | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> rollback-on-return | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> checked out from pool | |
| INFO:sqlalchemy.engine.base.Engine:SELECT addresses_1.id AS addresses_1_id, addresses_1.user_id AS addresses_1_user_id, addresses_1.email_address AS addresses_1_email_address, users.id AS users_id, users.name AS users_name | |
| FROM users LEFT OUTER JOIN addresses AS addresses_1 ON users.id = addresses_1.user_id ORDER BY users.id, addresses_1.id, users.id | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| INFO:sqlalchemy.engine.base.Engine:ROLLBACK | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> being returned to pool | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c1344500> rollback-on-return | |
| ______________________________________________________________________________ ParentRemovalTest.test_stale_state_positive_pk_change ______________________________________________________________________________ | |
| Traceback (most recent call last): | |
| File "<string>", line 2, in test_stale_state_positive_pk_change | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/exclusions.py", line 94, in decorate | |
| return self._do(config._current, fn, *args, **kw) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/exclusions.py", line 123, in _do | |
| self._expect_failure(config, ex, name=fn.__name__) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/exclusions.py", line 135, in _expect_failure | |
| util.raise_from_cause(ex) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/util/compat.py", line 199, in raise_from_cause | |
| reraise(type(exception), exception, tb=exc_tb) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/exclusions.py", line 121, in _do | |
| return_value = fn(*args, **kw) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/orm/test_hasparent.py", line 130, in test_stale_state_positive_pk_change | |
| s.flush() | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/orm/session.py", line 2004, in flush | |
| self._flush(objects) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/orm/session.py", line 2122, in _flush | |
| transaction.rollback(_capture_exception=True) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/util/langhelpers.py", line 60, in __exit__ | |
| compat.reraise(exc_type, exc_value, exc_tb) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/orm/session.py", line 2086, in _flush | |
| flush_context.execute() | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/orm/unitofwork.py", line 373, in execute | |
| rec.execute(self) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/orm/unitofwork.py", line 532, in execute | |
| uow | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/orm/persistence.py", line 170, in save_obj | |
| mapper, table, update) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/orm/persistence.py", line 694, in _emit_update_statements | |
| execute(statement, multiparams) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 914, in execute | |
| return meth(self, multiparams, params) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection | |
| return connection._execute_clauseelement(self, multiparams, params) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement | |
| compiled_sql, distilled_params | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context | |
| context) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception | |
| exc_info | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/util/compat.py", line 199, in raise_from_cause | |
| reraise(type(exception), exception, tb=exc_tb) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context | |
| context) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 150, in do_execute | |
| cursor.execute(statement, parameters, direct=self._get_direct(context)) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 86, in error_handler | |
| raise errorclass(errorvalue) | |
| ProgrammingError: (mx.ODBC.Error.ProgrammingError) ('42000', 8102, "[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Cannot update identity column 'id'.", 11159) [SQL: u'UPDATE users SET id=? WHERE users.id = ?'] [parameters: (5, 8)] | |
| ---------------------------------------------------------------------------------------------- Captured stdout call ----------------------------------------------------------------------------------------------- | |
| 2015-08-18 03:46:53,528 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c0fbddf0> checked out from pool | |
| 2015-08-18 03:46:53,528 INFO sqlalchemy.engine.base.Engine BEGIN (implicit) | |
| 2015-08-18 03:46:53,530 INFO sqlalchemy.engine.base.Engine INSERT INTO users OUTPUT inserted.id DEFAULT VALUES | |
| 2015-08-18 03:46:53,530 INFO sqlalchemy.engine.base.Engine () | |
| 2015-08-18 03:46:53,563 DEBUG sqlalchemy.engine.base.Engine Col ('id',) | |
| 2015-08-18 03:46:53,564 DEBUG sqlalchemy.engine.base.Engine Row (8,) | |
| 2015-08-18 03:46:53,571 INFO sqlalchemy.engine.base.Engine INSERT INTO addresses (user_id) OUTPUT inserted.id VALUES (?) | |
| 2015-08-18 03:46:53,572 INFO sqlalchemy.engine.base.Engine (8,) | |
| 2015-08-18 03:46:53,601 DEBUG sqlalchemy.engine.base.Engine Col ('id',) | |
| 2015-08-18 03:46:53,602 DEBUG sqlalchemy.engine.base.Engine Row (7,) | |
| 2015-08-18 03:46:53,903 INFO sqlalchemy.engine.base.Engine SELECT TOP 1 users.id AS users_id | |
| FROM users | |
| 2015-08-18 03:46:53,903 INFO sqlalchemy.engine.base.Engine () | |
| 2015-08-18 03:46:53,931 DEBUG sqlalchemy.engine.base.Engine Col ('users_id',) | |
| 2015-08-18 03:46:53,932 DEBUG sqlalchemy.engine.base.Engine Row (8,) | |
| 2015-08-18 03:46:53,933 INFO sqlalchemy.engine.base.Engine UPDATE users SET id=? WHERE users.id = ? | |
| 2015-08-18 03:46:53,933 INFO sqlalchemy.engine.base.Engine (5, 8) | |
| 2015-08-18 03:46:53,963 INFO sqlalchemy.engine.base.Engine ROLLBACK | |
| ---------------------------------------------------------------------------------------------- Captured stderr call ----------------------------------------------------------------------------------------------- | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c0fbddf0> checked out from pool | |
| INFO:sqlalchemy.engine.base.Engine:BEGIN (implicit) | |
| INFO:sqlalchemy.engine.base.Engine:INSERT INTO users OUTPUT inserted.id DEFAULT VALUES | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('id',) | |
| DEBUG:sqlalchemy.engine.base.Engine:Row (8,) | |
| INFO:sqlalchemy.engine.base.Engine:INSERT INTO addresses (user_id) OUTPUT inserted.id VALUES (?) | |
| INFO:sqlalchemy.engine.base.Engine:(8,) | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('id',) | |
| DEBUG:sqlalchemy.engine.base.Engine:Row (7,) | |
| INFO:sqlalchemy.engine.base.Engine:SELECT TOP 1 users.id AS users_id | |
| FROM users | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| DEBUG:sqlalchemy.engine.base.Engine:Col ('users_id',) | |
| DEBUG:sqlalchemy.engine.base.Engine:Row (8,) | |
| INFO:sqlalchemy.engine.base.Engine:UPDATE users SET id=? WHERE users.id = ? | |
| INFO:sqlalchemy.engine.base.Engine:(5, 8) | |
| INFO:sqlalchemy.engine.base.Engine:ROLLBACK | |
| ___________________________________________________________________________________ SessionBindTest.test_column_property_select ___________________________________________________________________________________ | |
| Traceback (most recent call last): | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/orm/test_query.py", line 3860, in test_column_property_select | |
| session.query(func.max(User.score)).scalar() | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/orm/query.py", line 2516, in scalar | |
| ret = self.one() | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/orm/query.py", line 2485, in one | |
| ret = list(self) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/orm/query.py", line 2528, in __iter__ | |
| return self._execute_and_instances(context) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/orm/query.py", line 2543, in _execute_and_instances | |
| result = conn.execute(querycontext.statement, self._params) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 914, in execute | |
| return meth(self, multiparams, params) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection | |
| return connection._execute_clauseelement(self, multiparams, params) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement | |
| compiled_sql, distilled_params | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context | |
| context) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception | |
| exc_info | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/util/compat.py", line 199, in raise_from_cause | |
| reraise(type(exception), exception, tb=exc_tb) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context | |
| context) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 150, in do_execute | |
| cursor.execute(statement, parameters, direct=self._get_direct(context)) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 86, in error_handler | |
| raise errorclass(errorvalue) | |
| ProgrammingError: (mx.ODBC.Error.ProgrammingError) ('42000', 130, '[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Cannot perform an aggregate function on an expression containing an aggregate or a subquery.', 11245) [SQL: u'SELECT max((SELECT sum(addresses.id) AS sum_1 \nFROM addresses, users \nWHERE addresses.user_id = users.id)) AS max_1'] | |
| ---------------------------------------------------------------------------------------------- Captured stdout call ----------------------------------------------------------------------------------------------- | |
| 2015-08-18 04:02:11,338 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c0bfbbe0> checked out from pool | |
| 2015-08-18 04:02:11,339 INFO sqlalchemy.engine.base.Engine BEGIN (implicit) | |
| 2015-08-18 04:02:11,340 INFO sqlalchemy.engine.base.Engine SELECT max((SELECT sum(addresses.id) AS sum_1 | |
| FROM addresses, users | |
| WHERE addresses.user_id = users.id)) AS max_1 | |
| 2015-08-18 04:02:11,340 INFO sqlalchemy.engine.base.Engine () | |
| ---------------------------------------------------------------------------------------------- Captured stderr call ----------------------------------------------------------------------------------------------- | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c0bfbbe0> checked out from pool | |
| INFO:sqlalchemy.engine.base.Engine:BEGIN (implicit) | |
| INFO:sqlalchemy.engine.base.Engine:SELECT max((SELECT sum(addresses.id) AS sum_1 | |
| FROM addresses, users | |
| WHERE addresses.user_id = users.id)) AS max_1 | |
| INFO:sqlalchemy.engine.base.Engine:() | |
| _______________________________________________________________________________________ SliceTest.test_limit_offset_applies _______________________________________________________________________________________ | |
| Traceback (most recent call last): | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/orm/test_query.py", line 1769, in test_limit_offset_applies | |
| {'param_1': 10, 'param_2': 10})]) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/assertions.py", line 475, in assert_sql | |
| self.assert_sql_execution(db, callable_, *newrules) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/assertions.py", line 460, in assert_sql_execution | |
| callable_() | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/orm/test_query.py", line 1765, in <lambda> | |
| testing.db, lambda: q[10:20], [ | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/orm/query.py", line 2293, in __getitem__ | |
| return list(res) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/orm/query.py", line 2528, in __iter__ | |
| return self._execute_and_instances(context) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/orm/query.py", line 2543, in _execute_and_instances | |
| result = conn.execute(querycontext.statement, self._params) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 914, in execute | |
| return meth(self, multiparams, params) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection | |
| return connection._execute_clauseelement(self, multiparams, params) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1003, in _execute_clauseelement | |
| inline=len(distilled_params) > 1) | |
| File "<string>", line 1, in <lambda> | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/elements.py", line 494, in compile | |
| return self._compiler(dialect, bind=bind, **kw) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/elements.py", line 500, in _compiler | |
| return dialect.statement_compiler(dialect, self, **kw) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/dialects/mssql/base.py", line 1001, in __init__ | |
| super(MSSQLCompiler, self).__init__(*args, **kwargs) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/compiler.py", line 392, in __init__ | |
| Compiled.__init__(self, dialect, statement, **kwargs) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/compiler.py", line 190, in __init__ | |
| self.string = self.process(self.statement, **compile_kwargs) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/compiler.py", line 213, in process | |
| return obj._compiler_dispatch(self, **kwargs) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 81, in _compiler_dispatch | |
| return meth(self, **kw) | |
| File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/dialects/mssql/base.py", line 1086, in visit_select | |
| raise exc.CompileError('MSSQL requires an order_by when ' | |
| CompileError: MSSQL requires an order_by when using an OFFSET or a non-simple LIMIT clause | |
| ---------------------------------------------------------------------------------------------- Captured stdout call ----------------------------------------------------------------------------------------------- | |
| 2015-08-18 04:02:24,135 DEBUG sqlalchemy.pool.QueuePool Connection <mx.ODBC.unixODBC connection object at 0x7ff9c0d12c90> checked out from pool | |
| ---------------------------------------------------------------------------------------------- Captured stderr call ----------------------------------------------------------------------------------------------- | |
| DEBUG:sqlalchemy.pool.QueuePool:Connection <mx.ODBC.unixODBC connection object at 0x7ff9c0d12c90> checked out from pool | |
| ============================================================================================= short test summary info ============================================================================================= | |
| FAIL test/dialect/mssql/test_reflection.py::ReflectionTest::()::test_db_qualified_items | |
| FAIL test/dialect/test_suite.py::CompoundSelectTest_mssql_mxodbc::()::test_limit_offset_selectable_in_unions | |
| FAIL test/dialect/test_suite.py::NumericTest_mssql_mxodbc::()::test_float_as_decimal | |
| FAIL test/dialect/test_suite.py::NumericTest_mssql_mxodbc::()::test_float_custom_scale | |
| FAIL test/orm/inheritance/test_assorted_poly.py::Ticket2419Test::()::test_join_w_eager_w_any | |
| FAIL test/orm/test_froms.py::InstancesTest::()::test_contains_eager | |
| FAIL test/orm/test_hasparent.py::ParentRemovalTest::()::test_stale_state_positive_pk_change | |
| FAIL test/orm/test_query.py::SessionBindTest::()::test_column_property_select | |
| FAIL test/orm/test_query.py::SliceTest::()::test_limit_offset_applies | |
| !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! KeyboardInterrupt !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! | |
| /home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py:79: KeyboardInterrupt | |
| ========================================================================= 9 failed, 4432 passed, 709 skipped, 2 error in 5413.43 seconds ========================================================================== | |
| Segmentation fault (core dumped) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment