Unable to Restore

[documizeoc]

Currently running Documize Community v5.10.0 (1695054225). When I tried to restore a backup from the Cloud hosted version, it runs for a while and then throws the error "Restore failed -- please check server logs". I have no idea where the server logs are located, nothing on Documize guides.

[girish]

@documizeoc Just want to double check if your question is cloudron related. This is the forum for Documize installed using Cloudron. If you installed using other means, the solutions here won't apply .

[documizeoc]

Yes, I am running Documize on Cloudron. I suspected that it was the LDAP authentication because I lost the ability to login afterwards. So on the 2nd attempt, I disabled LDAP and was able to login to a partially restored the Documize site.
This are the logs related to the Restore.

Oct 13 10:44:23Restored attempted by user: ckkas43v7n4s73ad8i00
Oct 13 10:44:27Restore file: dmz_backup_mydocumizebackup.zip 415827855
Oct 13 10:44:27Extracted manifest.json
Oct 13 10:44:27Extracted dmz_org.json
Oct 13 10:44:27Processed dmz_org.json 1 records
Oct 13 10:44:27Extracted dmz_user.json
Oct 13 10:44:27Processed dmz_user.json 10 records
Oct 13 10:44:27Extracted dmz_user_account.json
Oct 13 10:44:27Processed dmz_user_account.json 10 records
Oct 13 10:44:27Extracted dmz_user_activity.json
Oct 13 10:44:30Processed dmz_user_activity.json 10241 records
Oct 13 10:44:30Extracted dmz_user_config.json
Oct 13 10:44:30Processed dmz_user_config.json 0 records
Oct 13 10:44:30Extracted dmz_config.json
Oct 13 10:44:30Processed dmz_config.json 0 records
Oct 13 10:44:30Extracted dmz_audit_log.json
Oct 13 10:44:32Processed dmz_audit_log.json 7426 records
Oct 13 10:44:32Extracted dmz_action.json
Oct 13 10:44:32Processed dmz_action.json 1 records
Oct 13 10:44:32Extracted dmz_space_label.json
Oct 13 10:44:33Processed dmz_space_label.json 5 records
Oct 13 10:44:33Extracted dmz_space.json
Oct 13 10:44:33Processed dmz_space.json 12 records
Oct 13 10:44:33Extracted dmz_category.json
Oct 13 10:44:33Processed dmz_category.json 8 records
Oct 13 10:44:33Extracted dmz_category_member.json
Oct 13 10:44:33Processed dmz_category_member.json 0 records
Oct 13 10:44:33Extracted dmz_group.json
Oct 13 10:44:33Processed dmz_group.json 10 records
Oct 13 10:44:33Extracted dmz_group_member.json
Oct 13 10:44:33Processed dmz_group_member.json 44 records
Oct 13 10:44:33Extracted dmz_permission.json
Oct 13 10:44:33Processed dmz_permission.json 437 records
Oct 13 10:44:33Extracted dmz_pin.json
Oct 13 10:44:33Processed dmz_pin.json 3 records
Oct 13 10:44:34Extracted dmz_section.json
Oct 13 10:44:38Processed dmz_section.json 374 records
Oct 13 10:44:39Extracted dmz_section_meta.json
Oct 13 10:44:52system.restore
Oct 13 10:44:52unable to insert dmz_section_meta.json cfuqsqjrtgms2rijd3lg: driver: bad connection
Oct 13 10:44:52goroutine 79 [running]:
Oct 13 10:44:52github.com/documize/community/edition/logging.Logger.Error({0x0?, 0xc0003bc5a0?, 0xc4?}, {0xb2b5e8?, 0xc0005541c0?}, {0x32d2d60?, 0xc0003e8060})
Oct 13 10:44:52github.com/documize/community/edition/logging/logger.go:56 +0x17f
Oct 13 10:44:52github.com/documize/community/domain/backup.(*Handler).Restore(0xc0000221e0, {0x7fb614e2e8b8, 0xc00055a458}, 0xc00081c800)
Oct 13 10:44:52github.com/documize/community/domain/backup/endpoint.go:200 +0x9b9
Oct 13 10:44:52net/http.HandlerFunc.ServeHTTP(0xc00081c700?, {0x7fb614e2e8b8?, 0xc00055a458?}, 0x4193f3?)
Oct 13 10:44:52net/http/server.go:2136 +0x29
Oct 13 10:44:52github.com/gorilla/mux.(*Router).ServeHTTP(0xc0000e43c0, {0x7fb614e2e8b8, 0xc00055a458}, 0xc00081c500)
Oct 13 10:44:52github.com/gorilla/mux@v1.7.4/mux.go:210 +0x1c5
Oct 13 10:44:52github.com/documize/community/server.Start.Wrap.func3({0x7fb614e2e8b8, 0xc00055a458}, 0xa96fc0?, 0xc0005f8000)
Oct 13 10:44:52github.com/codegangsta/negroni@v1.0.0/negroni.go:46 +0x45
Oct 13 10:44:52github.com/codegangsta/negroni.HandlerFunc.ServeHTTP(0x410225?, {0x7fb614e2e8b8?, 0xc00055a458?}, 0xf8?, 0xb11400?)
Oct 13 10:44:52github.com/codegangsta/negroni@v1.0.0/negroni.go:29 +0x2d
Oct 13 10:44:52github.com/codegangsta/negroni.middleware.ServeHTTP({{0x32d2820?, 0xc000087968?}, 0xc0000879c8?}, {0x7fb614e2e8b8, 0xc00055a458}, 0x32d0701?)
Oct 13 10:44:52github.com/codegangsta/negroni@v1.0.0/negroni.go:38 +0xa8
Oct 13 10:44:52github.com/documize/community/server.(*middleware).Authorize(0xc00044a1b0, {0x7fb614e2e8b8, 0xc00055a458}, 0xc00081c200, 0xc0005f8d80)
Oct 13 10:44:52github.com/documize/community/server/middleware.go:241 +0x1478
Oct 13 10:44:52github.com/codegangsta/negroni.HandlerFunc.ServeHTTP(0x8?, {0x7fb614e2e8b8?, 0xc00055a458?}, 0xc00043d040?, 0xc000061420?)
Oct 13 10:44:52github.com/codegangsta/negroni@v1.0.0/negroni.go:29 +0x2d
Oct 13 10:44:52github.com/codegangsta/negroni.middleware.ServeHTTP({{0x32d2820?, 0xc0007162c0?}, 0xc0000879b0?}, {0x7fb614e2e8b8, 0xc00055a458}, 0xb2e30d?)
Oct 13 10:44:52github.com/codegangsta/negroni@v1.0.0/negroni.go:38 +0xa8
Oct 13 10:44:52github.com/codegangsta/negroni.(*Negroni).ServeHTTP(0xc000572f60, {0x7fb614e2e8b8?, 0xc00055a450}, 0xc00080c5d0?)
Oct 13 10:44:52github.com/codegangsta/negroni@v1.0.0/negroni.go:96 +0x114
Oct 13 10:44:52github.com/gorilla/handlers.ProxyHeaders.func1({0x7fb614e2e8b8, 0xc00055a450}, 0xc00081c200)
Oct 13 10:44:52github.com/gorilla/handlers@v1.4.2/proxy_headers.go:59 +0x143
Oct 13 10:44:52net/http.HandlerFunc.ServeHTTP(0xc00081c100?, {0x7fb614e2e8b8?, 0xc00055a450?}, 0xc0005c9490?)
Oct 13 10:44:52net/http/server.go:2136 +0x29
Oct 13 10:44:52github.com/gorilla/mux.(*Router).ServeHTTP(0xc0000e40c0, {0x7fb614e2e8b8, 0xc00055a450}, 0xc0006b5e00)
Oct 13 10:44:52github.com/gorilla/mux@v1.7.4/mux.go:210 +0x1c5
Oct 13 10:44:52github.com/codegangsta/negroni.(*Negroni).UseHandler.Wrap.func1({0x7fb614e2e8b8, 0xc00055a450}, 0x100000000000?, 0xc0005f8d60)
Oct 13 10:44:52github.com/codegangsta/negroni@v1.0.0/negroni.go:46 +0x45
Oct 13 10:44:52github.com/codegangsta/negroni.HandlerFunc.ServeHTTP(0xc000054800?, {0x7fb614e2e8b8?, 0xc00055a450?}, 0xc0005c3720?, 0x4505ef?)
Oct 13 10:44:52github.com/codegangsta/negroni@v1.0.0/negroni.go:29 +0x2d
Oct 13 10:44:52github.com/codegangsta/negroni.middleware.ServeHTTP({{0x32d2820?, 0xc000087da0?}, 0xc000087e48?}, {0x7fb614e2e8b8, 0xc00055a450}, 0x554556b999aeee66?)
Oct 13 10:44:52github.com/codegangsta/negroni@v1.0.0/negroni.go:38 +0xa8
Oct 13 10:44:52github.com/documize/community/server.(*middleware).cors(0xc00044a1b0, {0x7fb614e2e8b8, 0xc00055a450}, 0xc0006b5e00, 0xc0005f8d40)
Oct 13 10:44:52github.com/documize/community/server/middleware.go:55 +0x590
Oct 13 10:44:52github.com/codegangsta/negroni.HandlerFunc.ServeHTTP(0x100?, {0x7fb614e2e8b8?, 0xc00055a450?}, 0xc0005c38a8?, 0x464519?)
Oct 13 10:44:52github.com/codegangsta/negroni@v1.0.0/negroni.go:29 +0x2d
Oct 13 10:44:52github.com/codegangsta/negroni.middleware.ServeHTTP({{0x32d2820?, 0xc00040a470?}, 0xc000087e30?}, {0x7fb614e2e8b8, 0xc00055a450}, 0xc0007903e8?)
Oct 13 10:44:52github.com/codegangsta/negroni@v1.0.0/negroni.go:38 +0xa8
Oct 13 10:44:52github.com/codegangsta/negroni.(*Static).ServeHTTP(0x8?, {0x7fb614e2e8b8?, 0xc00055a450?}, 0xc00043d040?, 0xc0005c3ac8?)
Oct 13 10:44:52github.com/codegangsta/negroni@v1.0.0/static.go:34 +0x6a
Oct 13 10:44:52github.com/codegangsta/negroni.middleware.ServeHTTP({{0x32d2860?, 0xc00059cd50?}, 0xc000087dd0?}, {0x7fb614e2e8b8, 0xc00055a450}, 0xa95e40?)
Oct 13 10:44:52github.com/codegangsta/negroni@v1.0.0/negroni.go:38 +0xa8
Oct 13 10:44:52github.com/codegangsta/negroni.(*Negroni).ServeHTTP(0xc00059cd20, {0x32d6508?, 0xc0005a90a0}, 0x555554b999aeee66?)
Oct 13 10:44:52github

[girish]

@documizeoc I guess you are using https://docs.documize.com/s/WNEpptWJ9AABRnha/administration-guides/d/bh3i5ca1b54as00dsh20/in-app-backup-and-restore-process to backup and restore?

Oct 13 10:44:52unable to insert dmz_section_meta.json cfuqsqjrtgms2rijd3lg: driver: bad connection

It seems from the backtrace you posted, documize is maybe losing connection to the database? If so, please try again by giving postgres much more memory. Usually, databases require a lot more memory during restore time . Services -> PostgreSQL -> Edit -> Bump the memory up. Maybe that helps.

[documizeoc]

Thank you, this is exactly the problem. I was able to successfully restore after increasing the PostgresSQL memory.