Hello!
After a storage crash I had to reinstall bitbucket from scratch. The Backup of the database ist postgresql 9.3 but not a dump. It is a file Backup.
I can connect to the DB with pgadmin. But when I setup bitbucket and I connect to the DB I get the following error:
The specified target database could not be validated due to an unexpected error. As a result, Bitbucket cannot migrate to the specified database.
Wenn Sie weiterhin Probleme haben, wenden Sie sich an unser Support-Team. Wir helfen Ihnen weiter.
Details ausblenden
The specified target database could not be validated due to an unexpected error. As a result, Bitbucket cannot migrate to the specified database. com.atlassian.stash.internal.db.DefaultDatabaseManager.validateConfiguration(DefaultDatabaseManager.java:224) com.atlassian.stash.internal.migration.DefaultDatabaseMigrationService.validateConfiguration(DefaultDatabaseMigrationService.java:85) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ... Failed to obtain snapshot. Database type: postgresql; nested exception is liquibase.exception.DatabaseException: org.postgresql.util.PSQLException: ERROR: catalog is missing 2 attribute(s) for relid 163467 com.atlassian.stash.internal.backup.liquibase.DefaultLiquibaseSession.getSnapshot(DefaultLiquibaseSession.java:77) com.atlassian.stash.internal.backup.liquibase.LiquibaseMigrationTarget.hasNoClashingTables(LiquibaseMigrationTarget.java:54) com.atlassian.stash.internal.db.DefaultDatabaseValidator.validate(DefaultDatabaseValidator.java:63) ... org.postgresql.util.PSQLException: ERROR: catalog is missing 2 attribute(s) for relid 163467 liquibase.snapshot.ResultSetCache.get(ResultSetCache.java:101) liquibase.snapshot.JdbcDatabaseSnapshot$CachingDatabaseMetaData.getColumns(JdbcDatabaseSnapshot.java:539) liquibase.snapshot.jvm.ColumnSnapshotGenerator.addTo(ColumnSnapshotGenerator.java:106) ...
Can you help me please?
I'm not a DB specialist. :-( And its some kind of urgent as you can assume.... ;-)
bg
Günther Pfannhauser
Hey Günther,
Keying in on the following error snippet:
ERROR: catalog is missing 2 attribute(s) for relid 163467
it appears that there is some sort of database corruption with your catalog. Your first step is to review their resource before taking any actions and follow their instructions:
- https://wiki.postgresql.org/wiki/Corruption
You will likely have to rebuild the database and or restore to a point in time before the corruption as your database catalog is missing entries. Your file system for Bitbucket Server will also need to be restored to that same point in time to ensure that the application and database are in sync.
-Mark
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.