1035957 - raw_adi "received_at" column default wrong

Status: RESOLVED FIXED

(Socorro :: Database, task)

Description

[Robert Helmer [:rhelmer]]

The default for raw_adi "received_at" column should be NOW(), it is instead a date:

 received_at         | timestamp with time zone | default '2014-06-24 00:29:17.218147+00'::timestamp with time zone

Presumably this was the time the migration was run, and it evaluated NOW() instead of inserting it directly (using e.g. 'NOW()' vs. sa.TEXT('NOW()'))

Comment 1

[[github robot]]

Commits pushed to master at https://github.com/mozilla/socorro

https://github.com/mozilla/socorro/commit/1dc795fcf3e6c09a9a77fb008ee3b5fe5c7c3719
fix bug 1035957 - correct received_at column

https://github.com/mozilla/socorro/commit/47fcc5916d7aadfab8f8c840dba20e33994ee749
Merge pull request #2175 from rhelmer/bug1035957-raw_adi-received_at-column-wrong

fix bug 1035957 - correct received_at column

Comment 2

[Robert Helmer [:rhelmer]]

Migration run in prod:

INFO  [alembic.migration] Running upgrade 495bf3fcdb63 -> 391e42da94dd, bug 1035957 - use literal NOW() for received_at, do not evaluate at migration time