Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Setup doesn't create all tables #55

Open
ghost opened this issue Feb 7, 2021 · 5 comments
Open

Setup doesn't create all tables #55

ghost opened this issue Feb 7, 2021 · 5 comments

Comments

@ghost
Copy link

ghost commented Feb 7, 2021 •
edited by ghost
Loading

Hello,

I can't get icescrum running with a customized configuration. I use the icescrum docker image and MySQL 5.7 (also tested with MySQL 5.7.32).

The very interesting part about this issue is that all tables will be created if I go through the setup with the default configuration (I only change the database connection from H2 to MySQL everything else stays the same) but it doesn't create all tables when I use a custom configuration like this one:

  • Enable email alerts
  • Allow users to reset their passwords
  • Disable user registration
  • Disable Gravatar
  • Disable project import
  • Disable project creation
  • New projects private as default enabled
  • Disable project export
  • Disable private projects

Tables created with custom configuration:

| is_acceptance_test                                   |
| is_acceptance_test_is_activity                       |
| is_acceptance_test_is_metadata                       |
| is_activity                                          |
| is_actor                                             |
| is_availability                                      |
| is_availability_preferences                          |
| is_backlog                                           |
| is_bugtracker                                        |
| is_bugtracker_import                                 |
| is_bugtracker_sync                                   |
| is_build                                             |
| is_build_is_task                                     |
| is_cliche                                            |
| is_event                                             |
| is_feature                                           |
| is_feature_is_activity                               |
| is_feature_is_metadata                               |
| is_featuremap_config                                 |
| is_hook                                              |
| is_hook_events                                       |
| is_invitation                                        |
| is_label                                             |
| is_label_list                                        |
| is_meeting                                           |
| is_metadata                                          |
| is_mood                                              |
| is_mssg_preferences                                  |
| is_oauth_a_token

Tables not found with custom configuration:

root@69b93f776727:~/logs# tail -n 200 icescrum.log
2021-02-07 21:56:47,408 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_sprint
2021-02-07 21:56:47,408 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_story
2021-02-07 21:56:47,409 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_story_actors
2021-02-07 21:56:47,409 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_story_is_activity
2021-02-07 21:56:47,410 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_story_is_metadata
2021-02-07 21:56:47,410 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_story_is_user
2021-02-07 21:56:47,411 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_story_workflow_state
2021-02-07 21:56:47,411 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_task
2021-02-07 21:56:47,411 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_task_is_activity
2021-02-07 21:56:47,412 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_task_is_metadata
2021-02-07 21:56:47,412 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_task_is_user
2021-02-07 21:56:47,413 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_tbn_tpls
2021-02-07 21:56:47,413 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_team
2021-02-07 21:56:47,414 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_team_members
2021-02-07 21:56:47,414 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_template
2021-02-07 21:56:47,415 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_timebox
2021-02-07 21:56:47,415 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_timebox_is_activity
2021-02-07 21:56:47,416 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_timebox_is_metadata
2021-02-07 21:56:47,416 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_up_widgets
2021-02-07 21:56:47,416 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_up_window
2021-02-07 21:56:47,417 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_user
2021-02-07 21:56:47,417 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_user_preferences
2021-02-07 21:56:47,418 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_user_preferences_menu
2021-02-07 21:56:47,418 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_user_tokens
2021-02-07 21:56:47,419 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: tag_links
2021-02-07 21:56:47,419 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: tags
2021-02-07 21:56:47,420 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: user_authority
2021-02-07 21:56:47,420 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: acl_class
2021-02-07 21:56:47,420 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: acl_entry
2021-02-07 21:56:47,421 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: acl_object_identity
2021-02-07 21:56:47,422 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: acl_sid
2021-02-07 21:56:47,422 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: attachmentable_attachment
2021-02-07 21:56:47,422 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: attachmentable_attachmentlink
2021-02-07 21:56:47,423 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: authority
2021-02-07 21:56:47,423 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: comment
2021-02-07 21:56:47,424 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: comment_link
2021-02-07 21:56:47,424 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_acceptance_test
2021-02-07 21:56:47,425 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_acceptance_test_is_activity
2021-02-07 21:56:47,425 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_acceptance_test_is_metadata
2021-02-07 21:56:47,426 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_activity
2021-02-07 21:56:47,426 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_actor
2021-02-07 21:56:47,427 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_availability
2021-02-07 21:56:47,427 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_availability_preferences
2021-02-07 21:56:47,428 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_backlog
2021-02-07 21:56:47,428 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_bugtracker
2021-02-07 21:56:47,429 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_bugtracker_import
2021-02-07 21:56:47,429 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_bugtracker_sync
2021-02-07 21:56:47,429 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_build
2021-02-07 21:56:47,430 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_build_is_task
2021-02-07 21:56:47,430 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_cliche
2021-02-07 21:56:47,431 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_event
2021-02-07 21:56:47,431 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_feature
2021-02-07 21:56:47,432 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_feature_is_activity
2021-02-07 21:56:47,432 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_feature_is_metadata
2021-02-07 21:56:47,433 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_featuremap_config
2021-02-07 21:56:47,433 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_hook
2021-02-07 21:56:47,433 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_hook_events
2021-02-07 21:56:47,434 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_invitation
2021-02-07 21:56:47,434 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_label
2021-02-07 21:56:47,435 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_label_list
2021-02-07 21:56:47,435 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_meeting
2021-02-07 21:56:47,436 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_metadata
2021-02-07 21:56:47,436 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_mood
2021-02-07 21:56:47,436 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_mssg_preferences
2021-02-07 21:56:47,437 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_oauth_a_token
2021-02-07 21:56:47,437 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_oauth_a_token_additional_information
2021-02-07 21:56:47,438 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_oauth_a_token_scope
2021-02-07 21:56:47,438 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_oauth_auth_code
2021-02-07 21:56:47,439 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_oauth_client
2021-02-07 21:56:47,439 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_oauth_client_additional_information
2021-02-07 21:56:47,439 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_oauth_client_authorities
2021-02-07 21:56:47,439 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_oauth_client_authorized_grant_types
2021-02-07 21:56:47,440 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_oauth_client_auto_approve_scopes
2021-02-07 21:56:47,440 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_oauth_client_redirect_uris
2021-02-07 21:56:47,440 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_oauth_client_resource_ids
2021-02-07 21:56:47,441 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_oauth_client_scopes
2021-02-07 21:56:47,441 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_oauth_r_token
2021-02-07 21:56:47,441 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_portfolio
2021-02-07 21:56:47,442 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_project
2021-02-07 21:56:47,442 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_project_preferences
2021-02-07 21:56:47,443 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_project_teams
2021-02-07 21:56:47,443 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_release
2021-02-07 21:56:47,443 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_roadmap
2021-02-07 21:56:47,444 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_scm_commit
2021-02-07 21:56:47,444 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_scm_commit_is_task
2021-02-07 21:56:47,444 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_share_link
2021-02-07 21:56:47,445 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_simple_project_app
2021-02-07 21:56:47,445 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_sprint
2021-02-07 21:56:47,445 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_story
2021-02-07 21:56:47,446 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_story_actors
2021-02-07 21:56:47,446 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_story_is_activity
2021-02-07 21:56:47,447 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_story_is_metadata
2021-02-07 21:56:47,447 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_story_is_user
2021-02-07 21:56:47,447 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_story_workflow_state
2021-02-07 21:56:47,448 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_task
2021-02-07 21:56:47,448 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_task_is_activity
2021-02-07 21:56:47,449 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_task_is_metadata
2021-02-07 21:56:47,449 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_task_is_user
2021-02-07 21:56:47,449 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_tbn_tpls
2021-02-07 21:56:47,450 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_team
2021-02-07 21:56:47,450 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_team_members
2021-02-07 21:56:47,451 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_template
2021-02-07 21:56:47,451 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_timebox
2021-02-07 21:56:47,451 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_timebox_is_activity
2021-02-07 21:56:47,452 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_timebox_is_metadata
2021-02-07 21:56:47,452 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_up_widgets
2021-02-07 21:56:47,453 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_up_window
2021-02-07 21:56:47,453 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_user
2021-02-07 21:56:47,453 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_user_preferences
2021-02-07 21:56:47,454 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_user_preferences_menu
2021-02-07 21:56:47,454 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: is_user_tokens
2021-02-07 21:56:47,454 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: tag_links
2021-02-07 21:56:47,455 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: tags
2021-02-07 21:56:47,455 [localhost-startStop-1] INFO  java.sql.DatabaseMetaData  - HHH000262: Table not found: user_authority
@ghost ghost changed the title Setup doesn Setup doesn't create tables Feb 7, 2021
@ghost ghost changed the title Setup doesn't create tables Setup doesn't create all tables Feb 7, 2021
@vbarrier
Copy link
Member

vbarrier commented Feb 9, 2021

Hi,

In the wizard setup when you put the MySQL server details, is there any error when iceScrum try to connect?

@ghost
Copy link
Author

ghost commented Feb 10, 2021

No error message and the login credentials are valid (if I don't customize the setup the tables will be created)

@cantevenpronounceyourname
Copy link

cantevenpronounceyourname commented Feb 20, 2021 •
edited
Loading

MySQL 5.7.32 isn't working - as soon as I change something on the default configuration (within the setup) the tables won't created (Can't read packets error message within iceScrum).
With Postgres (9.6.21-alpine) everything works fine (with the same configuration as before).

@vbarrier
Copy link
Member

Can you share the error:

(Can't read packets error message within iceScrum).

Please copy/paste any error you have read

@RodolfoZaGa
Copy link

Hola, presento el mismo error, no crea todas mis tablas y detiene el icescrum, sin embargo al crear las tablas de manera manual me deja correr el aplicativo, pero al querer agregar story o feature me arroja un error referente al grovy, pero mi tablas estas bien definidas y la bd de igual manera

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@vbarrier @cantevenpronounceyourname @RodolfoZaGa