build fails on latest trac svn with bitten-master with postgres

[ben@…]

When running bitten-master, the bitten-slave is unable to get past the Registration phase as bitten-master fails with the following message:

Traceback (most recent call last):
  File "/usr/local/bin/bitten-master", line 7, in ?
    sys.exit(
  File "/usr/local/src/bitten/bitten/master.py", line 467, in main
    master.run(timeout=5.0)
  File "/usr/local/src/bitten/bitten/util/beep.py", line 134, in run
    callback()
  File "/usr/local/src/bitten/bitten/master.py", line 67, in _enqueue_builds
    queue.populate()
  File "/usr/local/src/bitten/bitten/queue.py", line 194, in populate
    build.insert(db=db)
  File "/usr/local/src/bitten/bitten/model.py", line 413, in insert
    (self.config, self.rev, self.rev_time, self.platform,
  File "/usr/local/src/trac/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/local/src/trac/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/local/lib/python2.4/site-packages/pyPgSQL/PgSQL.py", line 3111, in execute
    raise OperationalError, msg
libpq.OperationalError: ERROR:  syntax error at or near ""UTC"" at character 179

[ben@…]

After updating to 8.2.3 postgres, I was able to get a little more insight into the issue, new traceback with postgres error from the logs:

  File "/usr/local/bin/bitten-master", line 7, in ?
    sys.exit(
  File "/usr/local/src/bitten/bitten/master.py", line 467, in main
    master.run(timeout=5.0)
  File "/usr/local/src/bitten/bitten/util/beep.py", line 134, in run
    callback()
  File "/usr/local/src/bitten/bitten/master.py", line 67, in _enqueue_builds
    queue.populate()
  File "/usr/local/src/bitten/bitten/queue.py", line 194, in populate
    build.insert(db=db)
  File "/usr/local/src/bitten/bitten/model.py", line 413, in insert
    (self.config, self.rev, self.rev_time, self.platform,
  File "/usr/local/src/trac/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/local/src/trac/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/local/lib/python2.4/site-packages/pyPgSQL/PgSQL.py", line 3111, in execute
    raise OperationalError, msg
libpq.OperationalError: ERROR:  syntax error at or near ""UTC""
LINE 1: ...etime(2007, 2, 15, 3, 25, 31, tzinfo=<FixedOffset "UTC" 0:00...

Postgres error log:
Feb 14 20:47:25 ns postgres[7661]: [1-1] ERROR:  syntax error at or near ""UTC"" at character 178
Feb 14 20:47:25 ns postgres[7661]: [1-2] STATEMENT:  INSERT INTO bitten_build (config,rev,rev_time,platform,slave,started,stopped,status) VALUES
Feb 14 20:47:25 ns postgres[7661]: [1-3]  ('pylons_trunk','1863',datetime.datetime(2007, 2, 15, 3, 25, 31, tzinfo=<FixedOffset "UTC" 0:00:00>),2,'',0,0,'P')

It would appear the repr of a datetime object is not being done properly into a valid SQL datetime.

[osimons]

I'm quite sure this has been fixed since ticket was created, as many users run Postgres without reporting this issue. I'm closing it, but please reopen if this is still a problem with recent Trac and recent Bitten trunk.