Advertisement
Guest User

Untitled

a guest
May 29th, 2020
16
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.69 KB | None | 0 0
  1. ============================================================================================== FAILURES
  2. ___________________________________________________________ ComputedReturningTest_oracle+cx_oracle_18_4_0_0_0.test_computed_update_warning
  3. [gw1] win32 -- Python 3.7.5 C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\Scripts\python.EXE
  4. Traceback (most recent call last):
  5. File "C:\Users\Gord\git\sqla-gerrit\test\dialect\oracle\test_dialect.py", line 275, in test_computed_update_warning
  6. eq_(result.returned_defaults, (47,))
  7. File "C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\lib\site-packages\sqlalchemy\testing\assertions.py", line 203, in eq_
  8. assert a == b, msg or "%r != %r" % (a, b)
  9. AssertionError: (52,) != (47,)
  10. assert (52,) == (47,)
  11. At index 0 diff: 52 != 47
  12. Full diff:
  13. - (47,)
  14. + (52,)
  15. __________________________________________________________________ DBLinkReflectionTest_oracle+cx_oracle_18_4_0_0_0.test_reflection
  16. [gw1] win32 -- Python 3.7.5 C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\Scripts\python.EXE
  17. Traceback (most recent call last):
  18. File "C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\lib\site-packages\sqlalchemy\engine\base.py", line 1515, in _execute_context
  19. cursor, statement, parameters, context
  20. File "C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\lib\site-packages\sqlalchemy\engine\default.py", line 589, in do_execute
  21. cursor.execute(statement, parameters)
  22. cx_Oracle.DatabaseError: ORA-02019: connection description for remote database not found
  23.  
  24. The above exception was the direct cause of the following exception:
  25.  
  26. Traceback (most recent call last):
  27. File "C:\Users\Gord\git\sqla-gerrit\test\dialect\oracle\test_reflection.py", line 667, in test_reflection
  28. oracle_resolve_synonyms=True,
  29. File "C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\lib\site-packages\sqlalchemy\testing\schema.py", line 68, in Table
  30. return schema.Table(*args, **kw)
  31. File "C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\lib\site-packages\sqlalchemy\sql\schema.py", line 534, in __new__
  32. metadata._remove_table(name, schema)
  33. File "C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\lib\site-packages\sqlalchemy\util\langhelpers.py", line 69, in __exit__
  34. exc_value, with_traceback=exc_tb,
  35. File "C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\lib\site-packages\sqlalchemy\util\compat.py", line 169, in raise_
  36. raise exception
  37. File "C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\lib\site-packages\sqlalchemy\sql\schema.py", line 529, in __new__
  38. table._init(name, metadata, *args, **kw)
  39. File "C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\lib\site-packages\sqlalchemy\sql\schema.py", line 608, in _init
  40. resolve_fks=resolve_fks,
  41. File "C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\lib\site-packages\sqlalchemy\sql\schema.py", line 638, in _autoload
  42. _extend_on=_extend_on,
  43. File "C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\lib\site-packages\sqlalchemy\engine\reflection.py", line 728, in reflect_table
  44. table_name, schema, **table.dialect_kwargs
  45. File "C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\lib\site-packages\sqlalchemy\engine\reflection.py", line 387, in get_table_options
  46. conn, table_name, schema, info_cache=self.info_cache, **kw
  47. File "<string>", line 2, in get_table_options
  48. File "C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\lib\site-packages\sqlalchemy\engine\reflection.py", line 55, in cache
  49. ret = fn(self, con, *args, **kw)
  50. File "C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\lib\site-packages\sqlalchemy\dialects\oracle\base.py", line 1673, in get_table_options
  51. result = connection.execute(sql.text(text), params)
  52. File "C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\lib\site-packages\sqlalchemy\engine\base.py", line 1056, in execute
  53. return meth(self, multiparams, params, _EMPTY_EXECUTION_OPTS)
  54. File "C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\lib\site-packages\sqlalchemy\sql\elements.py", line 309, in _execute_on_connection
  55. self, multiparams, params, execution_options
  56. File "C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\lib\site-packages\sqlalchemy\engine\base.py", line 1227, in _execute_clauseelement
  57. extracted_params,
  58. File "C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\lib\site-packages\sqlalchemy\engine\base.py", line 1559, in _execute_context
  59. e, statement, parameters, cursor, context
  60. File "C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\lib\site-packages\sqlalchemy\engine\base.py", line 1740, in _handle_dbapi_exception
  61. sqlalchemy_exception, with_traceback=exc_info[2], from_=e
  62. File "C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\lib\site-packages\sqlalchemy\util\compat.py", line 169, in raise_
  63. raise exception
  64. File "C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\lib\site-packages\sqlalchemy\engine\base.py", line 1515, in _execute_context
  65. cursor, statement, parameters, context
  66. File "C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\lib\site-packages\sqlalchemy\engine\default.py", line 589, in do_execute
  67. cursor.execute(statement, parameters)
  68. sqlalchemy.exc.DatabaseError: (cx_Oracle.DatabaseError) ORA-02019: connection description for remote database not found
  69. [SQL: SELECT table_name, compression, compress_for FROM ALL_TABLES@TEST_LINK WHERE table_name = :table_name]
  70. [parameters: {'table_name': 'TEST_TABLE'}]
  71. (Background on this error at: http://sqlalche.me/e/4xp6)
  72. ___________________________________________________________ TableReflectionTest_oracle+cx_oracle_18_4_0_0_0.test_reflect_basic_compression
  73. [gw0] win32 -- Python 3.7.5 C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\Scripts\python.EXE
  74. Traceback (most recent call last):
  75. File "C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\lib\site-packages\sqlalchemy\testing\util.py", line 211, in provide_metadata
  76. return fn(*args, **kw)
  77. File "<string>", line 2, in test_reflect_basic_compression
  78. File "C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\lib\site-packages\sqlalchemy\testing\exclusions.py", line 97, in decorate
  79. return self._do(config._current, fn, *args, **kw)
  80. File "C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\lib\site-packages\sqlalchemy\testing\exclusions.py", line 129, in _do
  81. self._expect_success(cfg, name=fn.__name__)
  82. File "C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\lib\site-packages\sqlalchemy\testing\exclusions.py", line 162, in _expect_success
  83. fail._as_string(config) for fail in self.fails
  84. AssertionError: Unexpected success for 'test_reflect_basic_compression' (custom function)
  85. _______________________________________________________________ FutureTableDDLTest_oracle+cx_oracle_18_4_0_0_0.test_create_table_schema
  86. [gw0] win32 -- Python 3.7.5 C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\Scripts\python.EXE
  87. Traceback (most recent call last):
  88. File "C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\lib\site-packages\sqlalchemy\engine\base.py", line 1515, in _execute_context
  89. cursor, statement, parameters, context
  90. File "C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\lib\site-packages\sqlalchemy\engine\default.py", line 589, in do_execute
  91. cursor.execute(statement, parameters)
  92. cx_Oracle.DatabaseError: ORA-01918: user 'TEST_SCHEMA' does not exist
  93.  
  94. The above exception was the direct cause of the following exception:
  95.  
  96. Traceback (most recent call last):
  97. File "C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\lib\site-packages\sqlalchemy\testing\suite\test_ddl.py", line 52, in test_create_table_schema
  98. table.create(config.db, checkfirst=False)
  99. File "C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\lib\site-packages\sqlalchemy\sql\schema.py", line 852, in create
  100. bind._run_ddl_visitor(ddl.SchemaGenerator, self, checkfirst=checkfirst)
  101. File "C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\lib\site-packages\sqlalchemy\future\engine.py", line 348, in _run_ddl_visitor
  102. conn._run_ddl_visitor(visitorcallable, element, **kwargs)
  103. File "C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\lib\site-packages\sqlalchemy\engine\base.py", line 1826, in _run_ddl_visitor
  104. visitorcallable(self.dialect, self, **kwargs).traverse_single(element)
  105. File "C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\lib\site-packages\sqlalchemy\sql\visitors.py", line 465, in traverse_single
  106. return meth(obj, **kw)
  107. File "C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\lib\site-packages\sqlalchemy\sql\ddl.py", line 728, in visit_table
  108. include_foreign_key_constraints, # noqa
  109. File "C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\lib\site-packages\sqlalchemy\future\engine.py", line 287, in execute
  110. statement, parameters, execution_options or NO_OPTIONS
  111. File "C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\lib\site-packages\sqlalchemy\engine\base.py", line 1328, in _execute_20
  112. return meth(self, multiparams, params, execution_options)
  113. File "C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\lib\site-packages\sqlalchemy\sql\ddl.py", line 75, in _execute_on_connection
  114. self, multiparams, params, execution_options
  115. File "C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\lib\site-packages\sqlalchemy\engine\base.py", line 1137, in _execute_ddl
  116. compiled,
  117. File "C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\lib\site-packages\sqlalchemy\engine\base.py", line 1559, in _execute_context
  118. e, statement, parameters, cursor, context
  119. File "C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\lib\site-packages\sqlalchemy\engine\base.py", line 1740, in _handle_dbapi_exception
  120. sqlalchemy_exception, with_traceback=exc_info[2], from_=e
  121. File "C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\lib\site-packages\sqlalchemy\util\compat.py", line 169, in raise_
  122. raise exception
  123. File "C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\lib\site-packages\sqlalchemy\engine\base.py", line 1515, in _execute_context
  124. cursor, statement, parameters, context
  125. File "C:\Users\Gord\git\sqla-gerrit\.tox\py37-oracle-backendonly\lib\site-packages\sqlalchemy\engine\default.py", line 589, in do_execute
  126. cursor.execute(statement, parameters)
  127. sqlalchemy.exc.DatabaseError: (cx_Oracle.DatabaseError) ORA-01918: user 'TEST_SCHEMA' does not exist
  128. [SQL:
  129. CREATE TABLE test_schema.test_table (
  130. id INTEGER NOT NULL,
  131. data VARCHAR2(50 CHAR),
  132. PRIMARY KEY (id)
  133. )
  134.  
  135. ]
  136. (Background on this error at: http://sqlalche.me/e/4xp6)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement