Postgres Errors

[coldestheart]

When creating product in dashboard ottemo(postgresql), getting system error has occurred
users can be created but cannot be edited

[vastbinderj]

@vnaz can you take a look?

@coldestheart - can you post the version of golang you are using and platform?

Also, look in the logs located in the var/logs directory created when you start commerce. You should see a better error message.

[coldestheart]

go version go1.12.7 linux/amd64

logs.zip

[vnaz]

should be fixed now (there was SQL syntax error with "DOUBLE PRECISION" type)

[vastbinderj]

@coldestheart can you verify this fixes your issue?

[coldestheart]

Sorry for waiting, postgres still
error when editing user after creating.
log.zip

2019-08-12T07:06:28Z [ERROR]: db/postgres:4:8c3f2f99-4d08-412b-9dd4-fb6834c44c2b - SQL "INSERT INTO "visitor" ("facebook_id","password","first_name","last_name","is_admin","created_at","google_id","validate","_id","email") VALUES ('','62e7c0e9efe6eaf472bbae61c31baeff','ЩЬПЩАП','asff',false,to_timestamp(1565604375),'','',1,'silenthunter.46@yandex.ru') RETURNING _id" error: pq: duplicate key value violates unique constraint "visitor_pkey"
/home/cold/go/src/github.com/ottemo/commerce/db/postgres/internal.go:85
/home/cold/go/src/github.com/ottemo/commerce/db/postgres/collection.i_dbcollection.go:253
/home/cold/go/src/github.com/ottemo/commerce/app/actors/visitor/visitor.i_storable.go:131
/home/cold/go/src/github.com/ottemo/commerce/app/actors/visitor/api.go:263
/home/cold/go/src/github.com/ottemo/commerce/api/rest/i_restservice.go:241
/home/cold/go/src/github.com/ottemo/commerce/api/context/context.go:11
/home/cold/go/src/github.com/ottemo/commerce/api/context/context.go:387
/home/cold/go/src/github.com/ottemo/commerce/api/context/context.go:435
/home/cold/go/src/github.com/ottemo/commerce/api/rest/i_restservice.go:232
/home/cold/go/src/github.com/julienschmidt/httprouter/router.go:334
/home/cold/go/src/github.com/ottemo/commerce/api/rest/i_restservice.go:402
/usr/local/go/src/net/http/server.go:2774
/usr/local/go/src/net/http/server.go:1878
/usr/local/go/src/runtime/asm_amd64.s:1337

[vastbinderj]

ouch - @vnaz see the duplicate key constraint issue.

@coldestheart do you mind dropping a backup of your db here? We are just getting started on pgsql support and don't have more than our test db right now.

[coldestheart]

its fully new database creating by ottemo on start(

[vastbinderj]

@coldestheart we are seeing these errors. We are working through several issues, but we were able to repro this bug and a few more. May be a week or so until we fix this.

You can use the sqlite or mongodb adapters which are more mature if you are in a rush. Longer term, postgres is our preferred production db.