Ticket #1277 (closed defect: fixed)

Opened 8 years ago

Last modified 8 years ago

dasnapshot doesn't work on Precise

Reported by: jdreed Owned by:
Priority: normal Milestone: The Distant Future
Component: -- Keywords:
Cc: Fixed in version:
Upstream bug:

Description

Noting that dasnapshot is actually /mit/debathena/Scripts/snapshot/snapshot
and the error occurs in _insert_mirrorrun

Something either Postgres or Ruby changed such that it errors out with

/usr/lib/ruby/vendor_ruby/dbd/pg/statement.rb:62:in `execute': ERROR:  invalid input syntax for type timestamp: "17:33:59.000000000" (DBI::ProgrammingError)

The exact same code works fine on zulu. I'll note that magrathea has ruby dbi/dbd installed from the Ubuntu repos, whereas zulu appears to have them built locally.

Change History

comment:1 Changed 8 years ago by jdreed

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

Fixed. Ruby's DBI/DBD or Postgres itself changed how it handles strings with timezones. Previously it ignored the timezone if the column type didn't have timezones, now it throws an error (correctly). Fixed by not passing the timezone and committed in git.

Note: See TracTickets for help on using tickets.