Just as a heads-up, I'm also seeing this in r608 using Windows XP and PostgreSQL 8.1. It seems related to http://trac.turbogears.org/turbogears/ticket/213
C:\Development\tg_dev\tg_source>svn info Path: . URL: http://www.turbogears.org/svn/turbogears/trunk Repository Root: http://www.turbogears.org/svn/turbogears Repository UUID: 77541ad4-5f01-0410-9ede-a1b63cd9a898 Revision: 608 Node Kind: directory Schedule: normal Last Changed Author: ronald Last Changed Rev: 608 Last Changed Date: 2006-01-30 23:14:43 +0000 (Mon, 30 Jan 2006) Properties Last Updated: 2006-01-20 13:57:54 +0000 (Fri, 20 Jan 2006) C:\DEVELO~1\tg_dev\montest>tg-admin toolbox 31/Jan/2006:11:30:09 CONFIG INFO Server parameters: 31/Jan/2006:11:30:09 CONFIG INFO server.environment: development 31/Jan/2006:11:30:09 CONFIG INFO server.log_to_screen: True 31/Jan/2006:11:30:09 CONFIG INFO server.log_file: 31/Jan/2006:11:30:09 CONFIG INFO server.log_tracebacks: True 31/Jan/2006:11:30:09 CONFIG INFO server.log_request_headers: True 31/Jan/2006:11:30:09 CONFIG INFO server.protocol_version: HTTP/1.0 31/Jan/2006:11:30:09 CONFIG INFO server.socket_host: 31/Jan/2006:11:30:09 CONFIG INFO server.socket_port: 7654 31/Jan/2006:11:30:09 CONFIG INFO server.socket_file: 31/Jan/2006:11:30:09 CONFIG INFO server.reverse_dns: False 31/Jan/2006:11:30:09 CONFIG INFO server.socket_queue_size: 5 31/Jan/2006:11:30:09 CONFIG INFO server.thread_pool: 0 31/Jan/2006:11:30:10 HTTP INFO Serving HTTP on http://localhost:7654/ 2006-01-31 11:30:10,841 turbokid.kidsupport DEBUG Recompiling template for turbo gears.fastdata.templates.sitetemplate 2006-01-31 11:30:10,841 turbokid.kidsupport DEBUG Recompiling template for turbo gears.toolbox.main 2006-01-31 11:30:10,857 turbokid.kidsupport DEBUG Applying template turbogears.t oolbox.main 127.0.0.1 - - [31/Jan/2006:11:30:10] "GET / HTTP/1.1" 200 2635 2006-01-31 11:30:12,247 turbokid.kidsupport DEBUG Recompiling template for turbo gears.toolbox.catwalk.catwalk 2006-01-31 11:30:12,263 turbokid.kidsupport DEBUG Applying template turbogears.t oolbox.catwalk.catwalk 127.0.0.1 - - [31/Jan/2006:11:30:12] "GET /catwalk/ HTTP/1.1" 200 2854 2006-01-31 11:30:13,091 turbogears.controllers DEBUG Returning JSON 127.0.0.1 - - [31/Jan/2006:11:30:13] "GET /catwalk/list HTTP/1.1" 200 205 2006-01-31 11:30:14,559 turbogears.controllers DEBUG Returning JSON 127.0.0.1 - - [31/Jan/2006:11:30:14] "GET /catwalk/columns?objectName=DeviceType s HTTP/1.1" 200 726 2006-01-31 11:30:18,700 turbogears.controllers DEBUG Returning JSON 127.0.0.1 - - [31/Jan/2006:11:30:18] "GET /catwalk/columns?objectName=DeviceType s HTTP/1.1" 200 726 31/Jan/2006:11:30:29 HTTP INFO Page handler: <bound method CatWalk.add of <turbo gears.toolbox.catwalk.CatWalk instance at 0x0128D260>> Traceback (most recent call last): File "c:\python24\lib\site-packages\cherrypy-2.2.0beta-py2.4.egg\cherrypy\_cph ttptools.py", line 99, in _run self.main() File "c:\python24\lib\site-packages\cherrypy-2.2.0beta-py2.4.egg\cherrypy\_cph ttptools.py", line 247, in main body = page_handler(*virtual_path, **self.params) File "c:\python24\lib\site-packages\TurboGears-0.9a0dev_r608-py2.4.egg\turboge ars\controllers.py", line 241, in newfunc html, fragment, *args, **kw) File "c:\python24\lib\site-packages\TurboGears-0.9a0dev_r608-py2.4.egg\turboge ars\database.py", line 189, in run_with_transaction retval = func(*args, **kw) File "c:\python24\lib\site-packages\TurboGears-0.9a0dev_r608-py2.4.egg\turboge ars\controllers.py", line 258, in _execute_func output = func(self, *args, **kw) File "c:\python24\lib\site-packages\TurboGears-0.9a0dev_r608-py2.4.egg\turboge ars\toolbox\catwalk\__init__.py", line 784, in add new_object = obj(**params) File "c:\python24\lib\site-packages\sqlobject-0.7.1dev_r1534-py2.4.egg\sqlobje ct\main.py", line 1197, in __init__ self._create(id, **kw) File "c:\python24\lib\site-packages\sqlobject-0.7.1dev_r1534-py2.4.egg\sqlobje ct\main.py", line 1224, in _create self._SO_finishCreate(id) File "c:\python24\lib\site-packages\sqlobject-0.7.1dev_r1534-py2.4.egg\sqlobje ct\main.py", line 1248, in _SO_finishCreate id, names, values) File "c:\python24\lib\site-packages\sqlobject-0.7.1dev_r1534-py2.4.egg\sqlobje ct\dbconnection.py", line 752, in queryInsertID return self._dbConnection._queryInsertID( File "c:\python24\lib\site-packages\sqlobject-0.7.1dev_r1534-py2.4.egg\sqlobje ct\postgres\pgconnection.py", line 122, in _queryInsertID c.execute("SELECT NEXTVAL('%s')" % sequenceName) ProgrammingError: ERROR: current transaction is aborted, commands ignored until end of transaction block SELECT NEXTVAL('device_types_id_seq') Request Headers: Content-Length: 104 ACCEPT-CHARSET: ISO-8859-1,utf-8;q=0.7,*;q=0.7 USER-AGENT: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8) Gecko/2005 1111 Firefox/1.5 CONNECTION: keep-alive PRAGMA: no-cache CONTENT-LENGTH: 104 HOST: localhost:7654 CACHE-CONTROL: no-cache CONTENT-TYPE: application/x-www-form-urlencoded ACCEPT: text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/pl ain;q=0.8,image/png,*/*;q=0.5 Remote-Addr: 127.0.0.1 ACCEPT-LANGUAGE: en-us,en;q=0.5 Content-Type: application/x-www-form-urlencoded Remote-Host: 127.0.0.1 ACCEPT-ENCODING: gzip,deflate KEEP-ALIVE: 300 127.0.0.1 - - [31/Jan/2006:11:30:29] "POST /catwalk/add HTTP/1.1" 500 2829 devcfg.py contents: # This is where all of your settings go for your development environment # Settings that are the same for both development and production # (such as template engine, encodings, etc.) all go in # yourpackage/config.py # DATABASE # pick the form for your database sqlobject.dburi="postgres://mark:<password removed>@localhost/monitoring" # sqlobject.dburi="mysql://username:[EMAIL PROTECTED]:port/databasename" # sqlobject.dburi="sqlite:///file_name_and_path" #sqlobject.dburi="sqlite:///c|/Development/tg_dev/montest/montest/tmp.db" # if you are using a database or table type without transactions # (MySQL default, for example), you should turn off transactions # by prepending notrans_ on the uri # sqlobject.dburi="notrans_mysql://username:[EMAIL PROTECTED]:port/databasename" # for Windows users, sqlite URIs look like: # sqlobject.dburi="sqlite:///drive_letter|/path/to/file" # SERVER # Some server parameters that you may want to tweak # server.socket_port=8080 # Disable the debug output at the end on pages. # log_debug_info_filter.on = True server.environment="development" autoreload.package="montest"
