cattr-app / server-application

Public clone of https://git.amazingcat.net/cattr/core/app
https://cattr.app
Other
60 stars 29 forks source link

server-application cannot create new database because of timeout #285

Open outofsight opened 5 months ago

outofsight commented 5 months ago

From what I understand the new server application (backend+frontend) running in a docker container cannot create the database because of timeout:

s6-rc: info: service s6rc-oneshot-runner: starting
s6-rc: info: service s6rc-oneshot-runner successfully started
s6-rc: info: service fix-attrs: starting
s6-rc: info: service fix-attrs successfully started
s6-rc: info: service legacy-cont-init: starting
s6-rc: info: service legacy-cont-init successfully started
s6-rc: info: service prepare-filesystem: starting
s6-rc: info: service supercronic: starting
s6-rc: info: service supercronic successfully started
s6-rc: info: service prepare-filesystem successfully started
s6-rc: info: service prepare-cache: starting
s6-rc: info: service nginx: starting
s6-rc: info: service nginx successfully started
time="2024-05-30T11:12:32Z" level=info msg="read crontab: /crontab"

   INFO  Configuration cached successfully.

s6-rc: info: service prepare-cache successfully started
s6-rc: info: service prepare-database: starting

   INFO  Preparing database.

  Creating migration table ........................................ 132ms DONE

   INFO  Running migrations.

  0000_00_00_000000_create_websockets_statistics_entries_table .... 102ms DONE
  2014_10_12_000000_create_users_table ............................ 225ms DONE
  2014_10_12_100000_create_password_resets_table .................. 289ms DONE
  2018_02_26_105516_create_projects_table ......................... 108ms DONE
  2018_02_26_110729_create_projects_users_table ................... 698ms DONE
  2018_02_26_111407_create_tasks_table ............................ 276ms DONE
  2018_02_26_114952_create_time_intervals_table ................... 251ms DONE
  2018_02_26_115120_create_screenshots_table ...................... 251ms DONE
  2018_03_07_141643_create_roles .................................. 868ms DONE
  2018_03_13_094625_create_properties_table ....................... 349ms DONE
  2018_04_05_093510_add_mouse_and_keyboard_counters_to_time_interval  129ms DONE
  2018_05_16_160406_add_user_id_to_time_interval .................. 322ms DONE
  2018_05_28_134823_modifire_columns_users_table .................. 257ms DONE
  2018_05_31_110006_create_relations_users_table .................. 599ms DONE
  2018_06_01_070035_drop_column_role_projects_users_table ......... 129ms DONE
  2018_06_08_114524_add_deleted_at_column_to_rule_table ........... 113ms DONE
  2018_06_22_142252_change_company_id_column_projects_table ....... 185ms DONE
  2018_06_28_114513_add_timezone_column_to_users_table ............ 145ms DONE
  2018_08_22_121825_create_projects_roles_table ................... 801ms DONE
  2018_09_11_100952_add_index ................................... 1,098ms DONE
  2018_09_18_055949_add_thumbnail_path_to_screenshots_table ....... 140ms DONE
  2018_09_25_093329_convert_user_active_to_boolean ................ 365ms DONE
  2018_09_27_100017_update_rules .................................... 1ms DONE
  2018_10_01_134048_add_project_report_view ........................ 40ms DONE
  2018_10_02_112003_fix_time_durations_cache ...................... 490ms DONE
  2018_10_08_072020_add_task_priority ............................. 140ms DONE
  2018_10_10_075224_create_priorities_table ....................... 203ms DONE
  2018_10_12_094835_create_tokens_table ............................ 67ms DONE
  2018_10_30_114117_remove_tokens_composite_key ..................... 1ms DONE
  2018_10_30_114125_add_tokens_autoincrement_key .................... 1ms DONE
  2018_11_02_121027_create_registrations_table .................... 201ms DONE
  2019_01_22_062511_add_important_flag ............................ 523ms DONE
  2019_01_23_064646_add_removed_flag .............................. 126ms DONE
  2019_01_25_092401_fix_roles ....................................... 1ms DONE
  2019_03_26_113406_add_user_last_time_usage_view .................. 57ms DONE
  2019_04_26_084335_make_description_nullable ..................... 188ms DONE
  2019_04_26_112522_add_comment_to_task ........................... 476ms DONE
  2019_05_28_125455_remove_firstname_and_lastname ................. 288ms DONE
  2019_07_22_120600_drop_relations_users_table ..................... 68ms DONE
  2019_08_08_142801_add_change_password_to_user ................... 186ms DONE
  2019_08_12_091905_create_gitlab_projects_relations_table ........ 272ms DONE
  2019_08_12_091921_create_gitlab_tasks_relations_table ........... 226ms DONE
  2019_09_04_050531_add_multiply_roles .......................... 1,483ms DONE
  2019_09_24_054346_fix_project_report_view ........................ 52ms DONE
  2019_10_15_092422_drop_level_column_from_users .................. 126ms DONE
  2019_10_24_024043_add_is_administrator_column_to_users_table .... 122ms DONE
  2019_10_25_084958_add_is_manual_to_time_intervals ............... 115ms DONE
  2019_10_31_132937_add_foreign_key_to_tokens ..................... 366ms DONE
  2019_11_29_071129_add_role_to_users 
All roles set to users.
............................. 624ms DONE
  2019_12_11_095546_add_issue_iid_column .......................... 121ms DONE
  2019_12_12_063757_create_gitlab_intervals ........................ 88ms DONE
  2019_12_14_000001_create_personal_access_tokens_table ........... 355ms DONE
  2019_12_16_140349_add_index_to_role_table ....................... 157ms DONE
  2019_12_19_094440_fix_for_project_report_view .................... 58ms DONE
  2019_12_20_023630_add_entity_type_entity_name_index_to_properties_table  203ms DONE
  2019_12_20_050918_add_index_to_deleted_at_to_screenshots_table .. 302ms DONE
  2019_12_20_073840_fix_project_report ............................. 81ms DONE
  2019_12_24_013902_add_foreign_key_and_index_to_tasks_table ...... 684ms DONE
  2020_01_14_061358_fixes_for_roles ................................. 1ms DONE
  2020_01_15_110213_add_user_language_column ...................... 130ms DONE
  2020_01_31_101101_add_role_to_user_role ........................... 1ms DONE
  2020_02_04_080909_fix_user_roles .................................. 1ms DONE
  2020_02_06_080530_add_user_permissions ............................ 1ms DONE
  2020_02_10_092114_drop_index_on_deleted_at ...................... 275ms DONE
  2020_02_12_081847_add_intervals_bulk_edit_rule_to_managers ........ 1ms DONE
  2020_02_12_134247_recreate_roles .................................. 0ms DONE
  2020_02_18_104344_fix_recreate_roles .............................. 0ms DONE
  2020_02_18_121448_add_task_edit_rule_to_users ..................... 1ms DONE
  2020_03_10_065430_add_user_type ................................. 135ms DONE
  2020_03_21_064304_create_jobs_table ............................. 259ms DONE
  2020_03_21_071658_create_failed_jobs_table ....................... 93ms DONE
  2020_03_24_064952_add_project_source ............................ 163ms DONE
  2020_05_06_054551_add_invitation_sent_column_to_users ........... 134ms DONE
  2020_05_19_121037_rename_registration_table ...................... 63ms DONE
s6-rc: fatal: timed out
s6-sudoc: fatal: unable to get exit status from server: Operation timed out

Relevant part of my compose file is:

  cattr:
    image: registry.git.amazingcat.net/cattr/core/app:v4.0.0-RC47  
    container_name: cattr
    hostname: cattr
    restart: unless-stopped
    healthcheck:
      test: ['CMD-SHELL', 'wget --spider -q "http://127.0.0.1:8090/status"']
      interval: 10s
      timeout: 2s
    # depends_on:
    #   cattr-db:
    #     condition: service_healthy
    environment:
      DB_CONNECTION: mysql
      DB_HOST: mariadb
      DB_USERNAME: cattr
      DB_PASSWORD: ...
      APP_ADMIN_NAME: ...
      APP_ADMIN_EMAIL: ...
      APP_ADMIN_PASSWORD: ...
    volumes:
      - ../../data/cattr:/app/storage
    networks:
      - basebridge
      - database
    ports:
      - 35080:80

Is this the correct/best way to launch an up-to-date instance of cattr?