topic Re: Error Restoring the repository database in Management & Governance

Error Restoring the repository database

djakubiak — Fri, 02 Sep 2022 13:40:31 GMT

Hello,

When I restore the backup of repository database on a clean server, I have this message :

pg_restore: error : could not execute query: ERROR: "the “public” schema already exists"

The command was : CREATE SCHEMA public;

What coud I do to continue the restore ?

Best Regards

Re: Error Restoring the repository database

Alan_Slaughter — Fri, 02 Sep 2022 14:19:01 GMT

Hi djakubiak, did you follow this article:

https://community.qlik.com/t5/Knowledge/How-To-Take-Backup-And-Restore-Qlik-Sense-Enterprise-on-Windows/ta-p/1717548

Re: Error Restoring the repository database

djakubiak — Mon, 05 Sep 2022 14:42:13 GMT

Hi Allan,

Yes, I follow this article.

The only solution that I found is to delete the "public" schema with pgAdmin.

I don't know if it's the right solution but the service "Qlik Sense Repository Service" don't running after.

I have these messages in Windows Event Viewer :

"The description for Event ID 300 in the Qlik Sense Service Dispatcher source could not be found. Either the component that triggered this event is not installed on the local computer or the installation is corrupted. You can install or repair the component on the local computer."

And

ERROR: relationship '_locktable' does not exist at character 18

INSTRUCTION : DELETE FROM _locktable WHERE name = $1 AND node = $2 AND inactive = 'false'

"ERROR: relationship '_locktable' does not exist at character 32

INSTRUCTION : SELECT COUNT(id) FROM _locktable
WHERE name = $1 AND inactive = 'true'
"

Best regards.

David

Re: Error Restoring the repository database

Albert_Candelario — Mon, 05 Sep 2022 19:28:05 GMT

Hello @djakubiak ,

Wouldn't be better to drop all the database and start the restoring process from scratch?

Cheers,

Albert

Re: Error Restoring the repository database

djakubiak — Tue, 06 Sep 2022 09:24:48 GMT

Hi Albert,

I execute the drop command before and I have the same error...

Best Regards.

David

Re: Error Restoring the repository database

Albert_Candelario — Tue, 06 Sep 2022 10:22:50 GMT

Hello @djakubiak ,

The original error or the latest one that you posted?

Cheers,

Albert

Re: Error Restoring the repository database

djakubiak — Tue, 06 Sep 2022 10:29:35 GMT

Excuse me,

When restoring the QSR_backup.tar, I have this message :

pg_restore: error : could not execute query: ERROR: "the “public” schema already exists"
The command was : CREATE SCHEMA public;

-> Dropping the database not solve this error -> I must drop the schema with pgAdmin

When I run "Repository.exe -bootstrap -standalone -restorehostname" :

[ERROR] Fatal exception during bootstrap: Inactive lock existance check for database 'QSR' failed: ERROR: 42P01: the relation « _locktable » not exist

Best Regards

David

Re: Error Restoring the repository database

Alan_Slaughter — Tue, 06 Sep 2022 11:33:51 GMT

Please apply this article:

https://community.qlik.com/t5/Knowledge/Qlik-Sense-Repository-won-t-start-Inactive-lock-existance-check/ta-p/1714559

Re: Error Restoring the repository database

djakubiak — Thu, 08 Sep 2022 09:30:57 GMT

Hi Allan,

The script is executed correctly but the error is the same.

pg_restore: during PROCESSING TOC:
pg_restore: of TOC entry 3; 2615 2200 SCHEMA public postgres
pg_restore: error: could not execute query: ERROR: schema "public" already exists
The command was: CREATE SCHEMA public;

Best Regards

David

Re: Error Restoring the repository database

Albert_Candelario — Fri, 09 Sep 2022 06:43:26 GMT

Hello @djakubiak ,

We saw @Alan_Slaughter response was accepted as solution, did it work at the end?

Cheers,

Albert

Re: Error Restoring the repository database

djakubiak — Fri, 09 Sep 2022 12:19:48 GMT

Hello Albert,

In addition, I had to change the owner of the QSR database with pgAdmin and put qliksenserepository.

Best Regards.

David