[Twisted-Python] twisted.enterprise error

Erik Myllymaki erik.myllymaki at starpointe.ca
Wed Jan 29 12:39:18 EST 2003


I get the folowing error with the twisted Enterprise Example -
row_example.py
on win2k using SAPDB(v7.3.00.29 of the win32 python2.2 driver).

However, it works if I don't declare a PRIMARY KEY on the furniture or rugs
tables...
(an older version of row_schema.sql had no PRIMARY KEYs declared at all and
this works...)


V:\Python22>python row_example.py
Connecting to database: SAPDB.sapdbapi () {'host': '192.168.33.99',
'password':
'DBA', 'user': 'DBA', 'database': 'TST'}
Enabling Multithreading.
starting waker
adbapi connecting: SAPDB.sapdbapi {'host': '192.168.33.99', 'password':
'DBA', '
user': 'DBA', 'database': 'TST'}
Exception in SQL interaction!  rolling back...
Traceback (most recent call last):
  File "V:\Python22\lib\threading.py", line 408, in __bootstrap
    self.run()
  File "V:\Python22\lib\threading.py", line 396, in run
    apply(self.__target, self.__args, self.__kwargs)
  File "V:\Python22\Lib\site-packages\twisted\python\threadpool.py", line
136, i
n _worker
    apply(function, args, kwargs)
  File "V:\Python22\Lib\site-packages\twisted\internet\threads.py", line 37,
in
_putResultInDeferred
    result = apply(f, args, kwargs)
--- <exception caught here> ---
  File "V:\Python22\lib\site-packages\twisted\enterprise\adbapi.py", line
157, i
n _runInteraction
    result = apply(interaction, (trans,)+args, kw)
  File "V:\Python22\Lib\site-packages\twisted\enterprise\sqlreflector.py",
line
118, in _rowLoader
    tableInfo = self.schema[tableName]
exceptions.KeyError: testrooms
Unhandled error in Deferred:
Traceback (most recent call last):
  File "V:\Python22\lib\threading.py", line 408, in __bootstrap
    self.run()
  File "V:\Python22\lib\threading.py", line 396, in run
    apply(self.__target, self.__args, self.__kwargs)
  File "V:\Python22\Lib\site-packages\twisted\python\threadpool.py", line
136, i
n _worker
    apply(function, args, kwargs)
--- <exception caught here> ---
  File "V:\Python22\Lib\site-packages\twisted\internet\threads.py", line 37,
in
_putResultInDeferred
    result = apply(f, args, kwargs)
  File "V:\Python22\lib\site-packages\twisted\enterprise\adbapi.py", line
157, i
n _runInteraction
    result = apply(interaction, (trans,)+args, kw)
  File "V:\Python22\Lib\site-packages\twisted\enterprise\sqlreflector.py",
line
118, in _rowLoader
    tableInfo = self.schema[tableName]
exceptions.KeyError: testrooms
Main loop terminated.





More information about the Twisted-Python mailing list