Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

When running a backup on my fisheye / crucible server I get the error:

Error reading database: Table 'fisheye.cwd_group_attributes' doesn't exist

Backup failed

When I look in the database, I see a table 'fisheye.cwd_group_attribute'.  This does not have the letter 's' on the end like the error message.

Any idea how to correct this.  

1 answer

1 accepted

0 votes
Answer accepted

Hello @David Culbertson

It has come to my attention that you have raised another question at https://community.atlassian.com/t5/Fisheye-Crucible-questions/Fisheye-4-7-0-Build-20190214100246-database-migration-from-MySQL/qaq-p/1142054 that is related to this one over here because both of them involve a database table named 'cwd_group_attribute'.

As far as I can see in both questions, the database migration script and the backup script are expecting to find the database table 'cwd_group_attribute' in the schema but this table cannot be found - possibly it was dropped somehow. 

Can you please connect to the database used by Fisheye 4.7.0 and verify if the table is really not there? There are no constraints blocking it from being dropped from the schema, so if it cannot be found it most likely was dropped.

In that case, simply creating that table should do the trick. Follow these steps:

1. Shut down Fisheye/Crucible

2. Connect to the database

3. Run this SQL statement:

CREATE TABLE cwd_group_attribute 
  ( 
     id                    BIGINT NOT NULL, 
     group_id              BIGINT NOT NULL, 
     directory_id          BIGINT NOT NULL, 
     attribute_name        VARCHAR(255) NOT NULL, 
     attribute_value       VARCHAR(255), 
     attribute_lower_value VARCHAR(255), 
     PRIMARY KEY (id), 
     CONSTRAINT fk_group_attr_dir_id FOREIGN KEY (directory_id) REFERENCES 
     `cwd_directory` (`id`), 
     CONSTRAINT fk_group_attr_id_group_id FOREIGN KEY (group_id) REFERENCES 
     `cwd_group` (`id`), 
     CONSTRAINT uk_group_name_attr_lval UNIQUE (group_id, attribute_name, 
     attribute_lower_value), 
     INDEX fk_group_attr_dir_id (directory_id), 
     INDEX fk_group_attr_id_group_id (group_id), 
     INDEX idx_group_attr_dir_name_lval (directory_id, attribute_name, 
     attribute_lower_value), 
     INDEX idx_group_attr_group_id (group_id) 
  ) 
engine=innodb 
DEFAULT charset=utf8 
DEFAULT COLLATE=utf8_bin;

4. Make sure that changes are committed

5. Start Fisheye/Crucible

If there aren't any other missing tables from the database, you should be able to backup your instance and also migrate to the new MySQL database.

Please do let me know how this goes!

Regards,

Felipe Kraemer

I fixed this a different way.  I went back to a valid DB from the day before and the migration went fine.  Thanks.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Asked in Jira Service Desk

Calling all Insight users, we need your help!

Hello Insight users,  As part of our (Mindville's) acquisition by Atlassian, our training team is looking to build some new Insight training materials. It would really helpful if you can ...

149 views 1 0
View question

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you