Ticket #1277 (closed defect: fixed)
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
Note: See
TracTickets for help on using
tickets.
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.