Edgewall Software
Modify

Opened 15 years ago

Closed 12 years ago

#150 closed defect (worksforme)

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

Reported by: ben@… Owned by: cmlenz
Priority: major Milestone:
Component: Build master Version: dev
Keywords: Cc:
Operating System: BSD

Description

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

Attachments (0)

Change History (2)

comment:1 Changed 15 years ago by 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.

comment:2 Changed 12 years ago by osimons

  • Resolution set to worksforme
  • Status changed from new to closed

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.

Add Comment

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain cmlenz.
The resolution will be deleted. Next status will be 'reopened'.
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.