Sorry, I changed the sqlalchemy URLs, not the import statements.
FWIW I turned echo on, here's the log leading up to the second exception:
2011-02-04 11:40:41,437 INFO sqlalchemy.engine.base.Engine.0x...8490 BEGIN (implicit)
2011-02-04 11:40:41,443 INFO sqlalchemy.engine.base.Engine.0x...8490 SELECT event_queue.idx AS event_queue_idx
FROM event_queue ORDER BY event_queue.idx
2011-02-04 11:40:41,444 INFO sqlalchemy.engine.base.Engine.0x...8490 ()
2011-02-04 11:40:41,446 DEBUG sqlalchemy.engine.base.Engine.0x...8490 Col ('event_queue_idx',)
2011-02-04T11:40:41|eventd|ERROR |Exception in RemoteDBThread
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
This table is trivial:
CREATE TABLE `rtu_prod`.`event_queue` (
`idx` int(11) NOT NULL,
PRIMARY KEY (`idx`),
CONSTRAINT `event_queue_ibfk_1` FOREIGN KEY (`idx`) REFERENCES `events2` (`idx`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
every record appears to be populated with a normal int.
Sorry, I changed the sqlalchemy URLs, not the import statements.
FWIW I turned echo on, here's the log leading up to the second exception:
2011-02-04 11:40:41,437 INFO sqlalchemy. engine. base.Engine. 0x...8490 BEGIN (implicit) engine. base.Engine. 0x...8490 SELECT event_queue.idx AS event_queue_idx engine. base.Engine. 0x...8490 () engine. base.Engine. 0x...8490 Col ('event_ queue_idx' ,) 04T11:40: 41|eventd| ERROR |Exception in RemoteDBThread jlaughlin\ documents\ smartview- svn\python\ branches\ python2. 6\smartview\ eventd\ eventlogger. py", line 91, model.EventQueu e).order_ by(model. EventQueue. idx).all( ) lib\site- packages\ sqlalchemy\ orm\query. py", line 1579, in all lib\site- packages\ sqlalchemy\ orm\query. py", line 1791, in instances lib\site- packages\ sqlalchemy\ engine\ base.py" , line 2504, in fetchall lib\site- packages\ sqlalchemy\ engine\ base.py" , line 2498, in fetchall rows(self. _fetchall_ impl()) lib\site- packages\ sqlalchemy\ engine\ base.py" , line 2465, in _fetchall_impl fetchall( ) Cursor. fetchall (oursqlx\ oursql. c:16568) _Statement. fetchall (oursqlx\ oursql. c:11377) _Statement. fetchone (oursqlx\ oursql. c:11281)
2011-02-04 11:40:41,443 INFO sqlalchemy.
FROM event_queue ORDER BY event_queue.idx
2011-02-04 11:40:41,444 INFO sqlalchemy.
2011-02-04 11:40:41,446 DEBUG sqlalchemy.
2011-02-
Traceback (most recent call last):
File "c:\users\
in run
queuedevts = dls.query(
File "c:\Python26\
return list(self)
File "c:\Python26\
fetch = cursor.fetchall()
File "c:\Python26\
self.cursor, self.context)
File "c:\Python26\
l = self.process_
File "c:\Python26\
return self.cursor.
File "cursor.pyx", line 228, in oursql.
File "statement.pyx", line 550, in oursql.
File "statement.pyx", line 541, in oursql.
InterfaceError: (InterfaceError) (None, 'truncated column 0, type 3', None) None None
This table is trivial: .`event_ queue` ( queue_ibfk_ 1` FOREIGN KEY (`idx`) REFERENCES `events2` (`idx`)
CREATE TABLE `rtu_prod`
`idx` int(11) NOT NULL,
PRIMARY KEY (`idx`),
CONSTRAINT `event_
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
every record appears to be populated with a normal int.