Repo migration fails on Postgres

[rspeicher]

• Go: 1.2.1 darwin/amd64
• Postgres: 9.3.4
• Gogs: latest HEAD 2401e68

When running Gogs using a Postgres database, I'm unable to migrate a repository from GitHub. I get the following error: An error is occurred : pq: date/time field value out of range: "0000-12-31 20:00:00"

I tried debugging this myself and got as far as the problem being related to xorm, specifically the auto-updating created and/or updated fields, but with my limited Go knowledge, couldn't get much further.

[unknwon]

Thanks for your feedback and locating the issue, I'm notifying @lunny here, he's the author of xorm.

[lunny]

@tsigo, Which repository did you import? I have tested for importing https://github.com/go-xorm/xorm.git and https://github.com/gogits/gogs.git via postgres v9.3.2 on Mac OSX 10.9. Both are OK.

[lunny]

My xorm's reversion is HEAD 8a1f48e

[rspeicher]

@lunny Same xorm revision as you. It seems to fail with all of the projects I tried in my profile here on GitHub. Also just tried gogits/gogs itself and got the same error.

[rspeicher]

Postgres configuration seems ok.

root=# SELECT NOW();
             now
------------------------------
 2014-04-29 22:48:58.53123-04

Added some debug output to xorm/engine.go (find the lines with *********************). This is the entire run for running the migration operation:

https://gist.github.com/tsigo/3aa3e705889c227319ec

First output after the marking is runtime.Caller(0), the second is the value of v in that block, line 1124 in engine.go

You can see the actual problem on line 52 of that gist. For some reason it gets the wrong value and then immediately right after gets the correct one.

[lunny]

I will brew upgrade to use postgres 9.3.4 to test again.

[lunny]

I have upgraded postgres from 9.3.2 to 9.3.4 and create a new database. And I tested import https://github.com/go-xorm/xorm.git via private or mirror. All tests are ok.
Did you have used NeedAuthorization?

[rspeicher]

I didn't. They were all public repos so they shouldn't need it, right?

On Tuesday, April 29, 2014, Lunny Xiao notifications@github.com wrote:

I have upgraded postgres from 9.3.2 to 9.3.4 and create a new database.
And I tested import https://github.com/go-xorm/xorm.git via private or
mirror. All tests are ok.
Did you have used NeedAuthorization?

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/141#issuecomment-41756778
.

[clee]

Using postgresql on Fedora 20 here and importing public repos works great for me with the latest master.

[unknwon]

Any progress on this issue?

[rspeicher]

No change. If no one else can duplicate it I guess you can close this.

On Thursday, May 1, 2014, 无闻 notifications@github.com wrote:

Any progress on this issue?

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/141#issuecomment-41903593
.

[unknwon]

I've tested on my Mac and I reproduced this issue. @lunny (clone https://github.com/gpmgo/gopm.git) exactly the same system and version, is it the issue only happens on Mac?

[unknwon]

@tsigo good news, try go get -u github.com/go-xorm/xorm and recompile gogs, my problem has been solved.

[rspeicher]

@unknwon @lunny All fixed! Thank you both.

[lunny]

@tsigo You are welcome!

[bit4bit]

hi,

the same problem,
only when create a issue or milestone,

An error is occurred : pq: date/time field value out of range: "0000-12-31 20:00:00"

gogs version: Application Version: 0.4.3.0610 Alpha

i try:

• postgresql 9.1, 9.3 and same problem.
• go get -u github.com/go-xorm/xorm
• install from http://gobuild.io/github.com/gogits/gogs/v0.4.2/linux/amd64
• and from source

nothing work.

i try:

• gogs v0.4.2 and v0.4.0

nothing work.

thanks, great project!! :)

[unknwon]

@bit4bit Thanks for your feedback, @lunny will get in touch with you.

[lunny]

OK. @bit4bit, I will test this.

[chumpalump]

Same problem with 0.4.2.0605 Alpha and psql (9.3.5)

An error is occurred : pq: date/time field value out of range: "0000-12-31 19:00:00"

[unknwon]

@lunny

[chumpalump]

I'm getting this on issue creation. Let me know if I should file a new bug.

[martini] Started POST /dhjr/gtest/issues/new
2014/09/01 22:09:52 [repo.go:24] [T] []
2014/09/01 22:09:52 [repo.go:236] [D] displayBare: false; IsBare: false
2014/09/01 22:09:52 [context.go:124] [E] issue.CreateIssue(NewIssue): pq: date/time field value out of range: "0000-12-31 19:00:00"
[martini] Completed 500 Internal Server Error in 14.538355ms

[unknwon]

@chumpalump does go get -u github.com/go-xorm/xorm solve your problem?

[chumpalump]

Updated xorm and gogs, and now I get a 200. So, xorm problem is solved. Oddly, the submission results in json being returned, not html.

{
  "data": "/dhjr/gtest2/issues/1",
  "ok": true,
  "status": 200
}

For reference:

2014/09/01 22:27:11 [T] Custom path: /home/dhjr/lib/gocode/src/github.com/gogits/gogs/custom
2014/09/01 22:27:11 [T] Log path: /home/dhjr/lib/gocode/src/github.com/gogits/gogs/log
2014/09/01 22:27:11 [I] Gogs: Go Git Service 0.4.9.0831 Beta
2014/09/01 22:27:11 [I] Log Mode: Console(Trace)
2014/09/01 22:27:11 [I] Cache Service Enabled
2014/09/01 22:27:11 [I] Session Service Enabled
2014/09/01 22:27:11 [I] Run Mode: Development
2014/09/01 22:27:11 [I] Listen: http://0.0.0.0:3000

...

[Macaron] Started POST /dhjr/gtest2/issues/new for 127.0.0.1:51414
2014/09/01 22:30:37 [T] 2 Issue created: 1
[Macaron] Completed /dhjr/gtest2/issues/new 200 OK in 45.327968ms