Also FWIW if I use the same example to connect to my MySQL 4.1 server I get a
different exception
>>> ================================ RESTART ================================
>>>
Traceback (most recent call last):
File "C:/Users/jlaughlin/Documents/tmp/oursqltest.py", line 6, in <module>
print curs.fetchall()
File "cursor.pyx", line 228, in oursql.Cursor.fetchall
(oursqlx\oursql.c:16568)
File "statement.pyx", line 549, in oursql._Statement.fetchall
(oursqlx\oursql.c:11364)
File "statement.pyx", line 556, in oursql._Statement.buffer_results
(oursqlx\oursql.c:11447)
File "statement.pyx", line 126, in oursql._Statement._raise_error
(oursqlx\oursql.c:6997)
InterfaceError: (2014, "Commands out of sync; you can't run this command now",
None)
>>>
--
You received this bug notification because you are a member of Agesys
Team, which is subscribed to oursql.
https://bugs.launchpad.net/bugs/713202
Title:
InterfaceError truncated column
Status in oursql:
New
Bug description:
I'm not sure if this is a bug, please bear with me.
I just switched to oursql 0.9.2 from mysqldb 1.2.2. Running Python 2.6
on win32. I am using SQLAlchemy 0.6.6. I didn't change my code, just
the SQLalchemy import statements. I am now getting a bunch of
exceptions.
Traceback (most recent call last):
File "c:\Python26\Lib\threading.py", line 532, in __bootstrap_inner
self.run()
File
"c:\users\jlaughlin\documents\smartview-svn\python\branches\python2.6\smartview\eventd\eventd.py",
line 470, in r
un
self.device.process()
File
"c:\users\jlaughlin\documents\smartview-svn\python\branches\python2.6\smartview\eventd\eventd.py",
line 363, in p
rocess
event_logger.process()
File
"c:\users\jlaughlin\documents\smartview-svn\python\branches\python2.6\smartview\eventd\eventlogger.py",
line 69,
in process
conn = dls.connection()
File "c:\Python26\lib\site-packages\sqlalchemy\orm\session.py", line 656,
in connection
return self._connection_for_bind(self.get_bind(mapper, clause))
File "c:\Python26\lib\site-packages\sqlalchemy\orm\session.py", line 660,
in _connection_for_bind
return self.transaction._connection_for_bind(engine)
File "c:\Python26\lib\site-packages\sqlalchemy\orm\session.py", line 336,
in _connection_for_bind
conn = bind.contextual_connect()
File "c:\Python26\lib\site-packages\sqlalchemy\engine\base.py", line 1829,
in contextual_connect
self.pool.connect(),
File "c:\Python26\lib\site-packages\sqlalchemy\pool.py", line 182, in
connect
return _ConnectionFairy(self).checkout()
File "c:\Python26\lib\site-packages\sqlalchemy\pool.py", line 369, in
__init__
rec = self._connection_record = pool.get()
File "c:\Python26\lib\site-packages\sqlalchemy\pool.py", line 213, in get
return self.do_get()
File "c:\Python26\lib\site-packages\sqlalchemy\pool.py", line 732, in do_get
con = self.create_connection()
File "c:\Python26\lib\site-packages\sqlalchemy\pool.py", line 147, in
create_connection
return _ConnectionRecord(self)
File "c:\Python26\lib\site-packages\sqlalchemy\pool.py", line 258, in
__init__
l.first_connect(self.connection, self)
File "c:\Python26\lib\site-packages\sqlalchemy\engine\strategies.py", line
151, in first_connect
dialect.initialize(c)
File "c:\Python26\lib\site-packages\sqlalchemy\dialects\mysql\oursql.py",
line 188, in initialize
connection.execution_options(_oursql_plain_query=True)
File "c:\Python26\lib\site-packages\sqlalchemy\dialects\mysql\base.py",
line 1753, in initialize
default.DefaultDialect.initialize(self, connection)
File "c:\Python26\lib\site-packages\sqlalchemy\engine\default.py", line
159, in initialize
self.returns_unicode_strings = self._check_unicode_returns(connection)
File "c:\Python26\lib\site-packages\sqlalchemy\engine\default.py", line
205, in _check_unicode_returns
unicode_for_varchar = check_unicode(sqltypes.VARCHAR(60))
File "c:\Python26\lib\site-packages\sqlalchemy\engine\default.py", line
198, in check_unicode
row = cursor.fetchone()
File "cursor.pyx", line 185, in oursql.Cursor.fetchone
(oursqlx\oursql.c:16162)
File "statement.pyx", line 541, in oursql._Statement.fetchone
(oursqlx\oursql.c:11281)
InterfaceError: (None, 'truncated column 0, type 253', None)
Also this one:
Traceback (most recent call last):
File
"c:\users\jlaughlin\documents\smartview-svn\python\branches\python2.6\smartview\eventd\eventlogger.py",
line 91,
in run
queuedevts =
dls.query(model.EventQueue).order_by(model.EventQueue.idx).all()
File "c:\Python26\lib\site-packages\sqlalchemy\orm\query.py", line 1579, in
all
return list(self)
File "c:\Python26\lib\site-packages\sqlalchemy\orm\query.py", line 1791, in
instances
fetch = cursor.fetchall()
File "c:\Python26\lib\site-packages\sqlalchemy\engine\base.py", line 2504,
in fetchall
self.cursor, self.context)
File "c:\Python26\lib\site-packages\sqlalchemy\engine\base.py", line 2498,
in fetchall
l = self.process_rows(self._fetchall_impl())
File "c:\Python26\lib\site-packages\sqlalchemy\engine\base.py", line 2465,
in _fetchall_impl
return self.cursor.fetchall()
File "cursor.pyx", line 228, in oursql.Cursor.fetchall
(oursqlx\oursql.c:16568)
File "statement.pyx", line 550, in oursql._Statement.fetchall
(oursqlx\oursql.c:11377)
File "statement.pyx", line 541, in oursql._Statement.fetchone
(oursqlx\oursql.c:11281)
InterfaceError: (InterfaceError) (None, 'truncated column 0, type 3', None)
None None
_______________________________________________
Mailing list: https://launchpad.net/~agesys-dev
Post to : [email protected]
Unsubscribe : https://launchpad.net/~agesys-dev
More help : https://help.launchpad.net/ListHelp
