Skip to content

ANALYZE needs to be run as root #87

Closed
@vjeeva

Description

@vjeeva

Describe the bug
When using belt to run the sync command, the ANALYZE step fails because of a statement timeout. In some of the databases we are touching, the owner of the database objects/tables have a statement timeout but such a statement timeout won't really be applied to the root user of a database.

Better to make the ANALYZE command be run by the root user.

To Reproduce
During a migration, run belt sync or belt analyze.

Expected behavior
The ANALYZE command runs to completion no matter how long it takes.

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions