Bug 1591353

Summary: python-sqlalchemy FTFBS on rawhide
Product: [Fedora] Fedora Reporter: Miro Hrončok <mhroncok>
Component: python-sqlalchemyAssignee: Nils Philippsen <nphilipp>
Status: CLOSED RAWHIDE QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: rawhideCC: lewk, mbacovsk, mbayer, nphilipp, rbarlow
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: python-sqlalchemy-1.2.8-3.fc29 Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2018-06-18 07:15:26 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 1565020    
Attachments:
Description Flags
build.log from Koji
none
root.log from koji none

Description Miro Hrončok 2018-06-14 14:17:33 UTC 
Created attachment 1451420 [details]
build.log from Koji

Python 2 test failure:

=================================== FAILURES ===================================
___________ TypeReflectionTest.test_round_trip_direct_type_affinity ____________
Traceback (most recent call last):
  File "/builddir/build/BUILD/SQLAlchemy-1.2.8/test/dialect/test_sqlite.py", line 1709, in test_round_trip_direct_type_affinity
    self._test_round_trip(self._type_affinity_fixture())
  File "/builddir/build/BUILD/SQLAlchemy-1.2.8/test/dialect/test_sqlite.py", line 1669, in _test_round_trip
    conn.execute("CREATE TABLE foo (data %s)" % from_)
  File "/builddir/build/BUILD/SQLAlchemy-1.2.8/test/../lib/sqlalchemy/engine/base.py", line 942, in execute
    return self._execute_text(object, multiparams, params)
  File "/builddir/build/BUILD/SQLAlchemy-1.2.8/test/../lib/sqlalchemy/engine/base.py", line 1104, in _execute_text
    statement, parameters
  File "/builddir/build/BUILD/SQLAlchemy-1.2.8/test/../lib/sqlalchemy/engine/base.py", line 1200, in _execute_context
    context)
  File "/builddir/build/BUILD/SQLAlchemy-1.2.8/test/../lib/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
    exc_info
  File "/builddir/build/BUILD/SQLAlchemy-1.2.8/test/../lib/sqlalchemy/util/compat.py", line 203, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb, cause=cause)
  File "/builddir/build/BUILD/SQLAlchemy-1.2.8/test/../lib/sqlalchemy/engine/base.py", line 1193, in _execute_context
    context)
  File "/builddir/build/BUILD/SQLAlchemy-1.2.8/test/../lib/sqlalchemy/engine/default.py", line 508, in do_execute
    cursor.execute(statement, parameters)
OperationalError: (sqlite3.OperationalError) near "NOTHING": syntax error [SQL: 'CREATE TABLE foo (data NOTHING WE KNOW)'] (Background on this error at: http://sqlalche.me/e/e3q8)
=========================== short test summary info ============================

Version: python-sqlalchemy-1.2.8-2.fc29

Scratch build: https://koji.fedoraproject.org/koji/taskinfo?taskID=27616974

Logs attached.

This blocks the 3.7 rebuild.
Comment 1 Miro Hrončok 2018-06-14 14:18:01 UTC 
Created attachment 1451422 [details]
root.log from koji
Comment 2 Miro Hrončok 2018-06-14 14:57:36 UTC 
There are even more problems on Python 3.7.

I've created https://src.fedoraproject.org/rpms/python-sqlalchemy/pull-request/2 and will need to get it there soon.
Comment 3 Miro Hrončok 2018-06-15 08:57:18 UTC 
I've merged the PR. Let me know if I should keep this open and reenable the tests, or close it and be done with it.
Comment 4 Miro Hrončok 2018-06-18 07:15:26 UTC 
Thanks.