narrowizard opened a new issue, #8676: URL: https://github.com/apache/incubator-devlake/issues/8676
### Search before asking - [x] I had searched in the [issues](https://github.com/apache/incubator-devlake/issues?q=is%3Aissue) and found no similar issues. ### What happened The migration script 20230412_add_custom_field_value.go (located at backend/plugins/tapd/models/migrationscripts/) takes significantly longer to execute in PostgreSQL databases compared to MySQL databases during DevLake setup. Performance measurements show: With only TAPD plugin enabled: - PostgreSQL: ~22 seconds - MySQL: ~3 seconds With all plugins enabled: - PostgreSQL: ~55 seconds - MySQL: ~6 seconds The execution time in PostgreSQL is approximately 7-9 times slower than in MySQL for the same migration operation. > Note that these timings are measured on a fresh database with no existing data. Performance degradation is expected to be more severe in production environments with existing data. ### What do you expect to happen The migration script should execute with similar performance characteristics across supported database backends (PostgreSQL and MySQL). While some performance variation between database systems is expected, the current difference (7-9x slower in PostgreSQL) indicates a potential optimization issue or implementation problem specific to PostgreSQL. ### How to reproduce 1. Set up a DevLake instance with PostgreSQL database 2. Start devlake with `make godev`, it starts with migration automatically. 3. Measure the execution time for the migration. 4. Repeat the same process with MySQL database 5. Compare execution times between the two database systems ### Anything else migration log for pg ```log $ DEVLAKE_PLUGINS=tapd make godev make godev -C backend DISABLED_REMOTE_PLUGINS=true make build-plugin run scripts/build-plugins.sh Usage: build all plugins: scripts/build-plugins.sh [golang build flags...] build and keep specified plugins only: DEVLAKE_PLUGINS=github,jira scripts/build-plugins.sh [golang build flags...] Building the following plugins: Building plugin tapd to bin/plugins/tapd/tapd.so with args: --gcflags= go run server/main.go Version: dev time="2026-01-07 07:13:18" level=info msg="migrator has been initialized" time="2026-01-07 07:13:21" level=info msg="plugin loaded tapd" time="2026-01-07 07:13:21" level=info msg="all plugins have been loaded" time="2026-01-07 07:13:21" level=info msg="register plugin:tapd's migrations scripts" time="2026-01-07 07:13:21" level=info msg="has pending scripts? false, FORCE_MIGRATION: true" time="2026-01-07 07:13:21" level=info msg=" [migrator] [Execute] pending scripts: 129, executed scripts: 0, total: 129" time="2026-01-07 07:13:21" level=info msg=" [migrator] applying migration script add commit line change table:202209221033" time="2026-01-07 07:13:21" level=info msg=" [migrator] applying migration script create init schemas:20220406212344" time="2026-01-07 07:13:21" level=info msg=" [migrator] applying migration script Rename step to stage :20220505212344" time="2026-01-07 07:13:21" level=info msg=" [migrator] applying migration script add column `subtasks` at _devlake_tasks:20220601000005" time="2026-01-07 07:13:21" level=info msg=" [migrator] applying migration script add mode field to blueprint:20220616110537" time="2026-01-07 07:13:21" level=info msg=" [migrator] applying migration script blueprint normal mode support:20220622110537" time="2026-01-07 07:13:21" level=info msg=" [migrator] applying migration script create domain layer init schemas:20220707232344" time="2026-01-07 07:13:21" level=info msg=" [migrator] applying migration script create subtask schema:20220711000001" time="2026-01-07 07:13:21" level=info msg=" [migrator] applying migration script add commit_file_components components table,update commit_files table:20220722165805" time="2026-01-07 07:13:21" level=info msg=" [migrator] applying migration script add project_mapping table to domain layer:20220725152355" time="2026-01-07 07:13:21" level=info msg=" [migrator] applying migration script remove notes from domain layer:20220727165805" time="2026-01-07 07:13:21" level=info msg=" [migrator] applying migration script rename pull_request_number to pull_request_key, issue_number to issue_key:20220729165805" time="2026-01-07 07:13:21" level=info msg=" [migrator] applying migration script add NoPKModel to commit_parents:20220801162735" time="2026-01-07 07:13:21" level=info msg=" [migrator] applying migration script add cicd models:20220818232735" time="2026-01-07 07:13:21" level=info msg=" [migrator] applying migration script rename user_id to account_id in pull_request_comments and issue_comments:20220826120824" time="2026-01-07 07:13:21" level=info msg=" [migrator] applying migration script modify tables for dora:20220829232735" time="2026-01-07 07:13:21" level=info msg=" [migrator] applying migration script add column `type` at boards:20220830142321" time="2026-01-07 07:13:21" level=info msg=" [migrator] applying migration script encrypt Blueprint:20220904142321" time="2026-01-07 07:13:21" level=info msg="\x1b[31;1m/Users/wangcong/code/go/incubator-devlake/backend/impls/dalgorm/dalgorm.go:215 \x1b[35;1mERROR: cached plan must not change result type (SQLSTATE 0A000)\n\x1b[0m\x1b[33m[0.425ms] \x1b[34;1m[rows:0]\x1b[0m SELECT * FROM \"_devlake_blueprints\" ORDER BY \"_devlake_blueprints\".\"id\" LIMIT 1" time="2026-01-07 07:13:21" level=info msg=" [migrator] applying migration script encrypt Pipeline:20220904162121" time="2026-01-07 07:13:21" level=info msg="\x1b[31;1m/Users/wangcong/code/go/incubator-devlake/backend/impls/dalgorm/dalgorm.go:215 \x1b[35;1mERROR: cached plan must not change result type (SQLSTATE 0A000)\n\x1b[0m\x1b[33m[0.391ms] \x1b[34;1m[rows:0]\x1b[0m SELECT * FROM \"_devlake_pipelines\" ORDER BY \"_devlake_pipelines\".\"id\" LIMIT 1" time="2026-01-07 07:13:21" level=info msg=" [migrator] applying migration script modify cicd pipeline:20220905232735" time="2026-01-07 07:13:21" level=info msg=" [migrator] applying migration script modify cicd tasks:20220909232735" time="2026-01-07 07:13:21" level=info msg=" [migrator] applying migration script add length of commit_file file_path:20220913165805" time="2026-01-07 07:13:21" level=info msg="\x1b[31;1m/Users/wangcong/code/go/incubator-devlake/backend/impls/dalgorm/dalgorm.go:215 \x1b[35;1mERROR: cached plan must not change result type (SQLSTATE 0A000)\n\x1b[0m\x1b[33m[0.381ms] \x1b[34;1m[rows:0]\x1b[0m SELECT * FROM \"commit_files\" ORDER BY \"commit_files\".\"id\" LIMIT 1" time="2026-01-07 07:13:21" level=info msg=" [migrator] applying migration script modify board repos:20220913232735" time="2026-01-07 07:13:21" level=info msg=" [migrator] applying migration script add origin change lead time for pr:20220913235535" time="2026-01-07 07:13:21" level=info msg=" [migrator] applying migration script UpdateSchemas for renamePipelineCommits:20220915000025" time="2026-01-07 07:13:21" level=info msg=" [migrator] applying migration script modify lead_time_minutes:20220929145125" time="2026-01-07 07:13:21" level=info msg=" [migrator] applying migration script add snapshot table:20221009111241" time="2026-01-07 07:13:21" level=info msg=" [migrator] applying migration script Create collector state table:20221101000001" time="2026-01-07 07:13:21" level=info msg=" [migrator] applying migration script Remove cicd_pipeline_relation:20221107000001" time="2026-01-07 07:13:21" level=info msg=" [migrator] applying migration script add skip_on_fail to _devlake_pipelines and _devlake_blueprint:20221107095744" time="2026-01-07 07:13:22" level=info msg=" [migrator] applying migration script add project tables:20221109194734" time="2026-01-07 07:13:22" level=info msg=" [migrator] applying migration script Tapd init schemas:20221109201138" time="2026-01-07 07:13:22" level=info msg=" [migrator] applying migration script modify commits diffs:20221109232735" time="2026-01-07 07:13:22" level=info msg=" [migrator] applying migration script add project pr metric tables:20221111000001" time="2026-01-07 07:13:22" level=info msg=" [migrator] applying migration script add labels' schema for blueprint and pipeline:20221115000034" time="2026-01-07 07:13:22" level=info msg=" [migrator] applying migration script add project to blueprint:20221117184342" time="2026-01-07 07:13:22" level=info msg=" [migrator] applying migration script add project issue metric tables:20221120000001" time="2026-01-07 07:13:22" level=info msg=" [migrator] applying migration script save state for collector:20221125000038" time="2026-01-07 07:13:22" level=info msg=" [migrator] applying migration script rename fields in project pr metric tables:20221201000001" time="2026-01-07 07:13:22" level=info msg=" [migrator] applying migration script add enable to project metric:20221201190341" time="2026-01-07 07:13:22" level=info msg=" [migrator] applying migration script add cicd scope and add cicd_scope_id and drop builds&jobs:20221207000001" time="2026-01-07 07:13:22" level=info msg=" [migrator] applying migration script add original_project to issues:20221215142543" time="2026-01-07 07:13:22" level=info msg=" [migrator] applying migration script add error_name to _devlake_tasks and _devlake_pipelines:20221221150548" time="2026-01-07 07:13:22" level=info msg=" [migrator] applying migration script encrypt task.options:20221221162121" time="2026-01-07 07:13:22" level=info msg="\x1b[31;1m/Users/wangcong/code/go/incubator-devlake/backend/impls/dalgorm/dalgorm.go:215 \x1b[35;1mERROR: cached plan must not change result type (SQLSTATE 0A000)\n\x1b[0m\x1b[33m[0.588ms] \x1b[34;1m[rows:0]\x1b[0m SELECT * FROM \"_devlake_tasks\" ORDER BY \"_devlake_tasks\".\"id\" LIMIT 1" time="2026-01-07 07:13:22" level=info msg=" [migrator] applying migration script add original type to issue:20221230162121" time="2026-01-07 07:13:22" level=info msg=" [migrator] applying migration script rename project metrics:20222123191424" time="2026-01-07 07:13:22" level=info msg=" [migrator] applying migration script Tapd encode connection token:20230115201138" time="2026-01-07 07:13:22" level=info msg=" [migrator] applying migration script add time_after to _devlake_collector_latest_state:20230213200040" time="2026-01-07 07:13:22" level=info msg=" [migrator] applying migration script modify issues story_point from int64 to float64:20230214145125" time="2026-01-07 07:13:22" level=info msg=" [migrator] applying migration script add commit_sha index for commit_files:20230222145127" time="2026-01-07 07:13:22" level=info msg=" [migrator] applying migration script add host, namespace, repo_name to issue_repo_commits:20230222153154" time="2026-01-07 07:13:22" level=info msg=" [migrator] applying migration script remove created_date_after from _devlake_collector_latest_state:20230223200040" time="2026-01-07 07:13:22" level=info msg=" [migrator] applying migration script add code quality domain:20230301000082" time="2026-01-07 07:13:22" level=info msg=" [migrator] applying migration script Tapd add transformation, update _raw_data_params:20230323000003" time="2026-01-07 07:13:22" level=info msg=" [migrator] applying migration script Tapd delete issue and remote link:20230323000004" time="2026-01-07 07:13:22" level=info msg=" [migrator] applying migration script add issue_assignees table:20230402000041" time="2026-01-07 07:13:22" level=info msg=" [migrator] applying migration script Rename Collector state table for Singer Taps:20230405000001" time="2026-01-07 07:13:22" level=info msg=" [migrator] applying migration script Rename cicd_piopeline_commits repo to repo_url:20230406170701" time="2026-01-07 07:13:22" level=info msg=" [migrator] applying migration script modify tapd custom field name:20230411000004" time="2026-01-07 07:13:44" level=info msg=" [migrator] applying migration script modify tapd custom field name:20230412000015" time="2026-01-07 07:13:44" level=info msg=" [migrator] applying migration script Rename project_pr_metrics.deployment_id to deployment_commit_id:20230416080701" time="2026-01-07 07:13:44" level=info msg=" [migrator] applying migration script add commit author info to pull_request_commits table:20230419145129" time="2026-01-07 07:13:44" level=info msg=" [migrator] applying migration script add cicd_deployment_commits table:20230426150702" time="2026-01-07 07:13:44" level=info msg=" [migrator] applying migration script add original status to pull_requests:20230508162121" time="2026-01-07 07:13:44" level=info msg=" [migrator] applying migration script add calendar months:20230511000001" time="2026-01-07 07:13:44" level=info msg=" [migrator] applying migration script change pull_request_comments.pr_id to varchar(255) type:20230516000001" time="2026-01-07 07:13:44" level=info msg=" [migrator] applying migration script Rename finished_commits_diffs to _tool_refdiff_finished_commits_diffs:20230516000002" time="2026-01-07 07:13:44" level=info msg=" [migrator] applying migration script add updated_date to issue_comments:20230517162121" time="2026-01-07 07:13:44" level=info msg=" [migrator] applying migration script rename transformation rule to scope config for tapd:20230531135926" time="2026-01-07 07:13:44" level=info msg="\x1b[31;1m/Users/wangcong/code/go/incubator-devlake/backend/impls/dalgorm/dalgorm.go:215 \x1b[35;1mERROR: could not identify an ordering operator for type json (SQLSTATE 42883)\n\x1b[0m\x1b[33m[0.351ms] \x1b[34;1m[rows:0]\x1b[0m SELECT * FROM \"_tool_tapd_scope_configs\" ORDER BY \"_tool_tapd_scope_configs\".\"entities\" LIMIT 1" time="2026-01-07 07:13:44" level=info msg="\x1b[31;1m/Users/wangcong/code/go/incubator-devlake/backend/impls/dalgorm/dalgorm.go:215 \x1b[35;1mERROR: could not identify an ordering operator for type json (SQLSTATE 42883)\n\x1b[0m\x1b[33m[0.269ms] \x1b[34;1m[rows:0]\x1b[0m SELECT * FROM \"_tool_tapd_scope_configs\" ORDER BY \"_tool_tapd_scope_configs\".\"entities\" LIMIT 1" time="2026-01-07 07:13:44" level=info msg=" [migrator] applying migration script populated _raw_data columns for tapd workspaces:20230630000002" time="2026-01-07 07:13:44" level=info msg=" [migrator] applying migration script add api key tables:20230725142900" time="2026-01-07 07:13:44" level=info msg=" [migrator] applying migration script tasks uses json:20230728162121" time="2026-01-07 07:13:44" level=info msg=" [migrator] applying migration script add issue_relationships table:20230816000001" time="2026-01-07 07:13:44" level=info msg=" [migrator] applying migration script modify cicd_pipelines name from varchar to text:20230821145125" time="2026-01-07 07:13:44" level=info msg=" [migrator] applying migration script drop _devlake_collector_tap_state table:20230822145125" time="2026-01-07 07:13:44" level=info msg=" [migrator] applying migration script normalize bp settings to multiple tables:20230829145125" time="2026-01-07 07:13:44" level=info msg=" [migrator] applying migration script add cicd deployments table:20230831162403" time="2026-01-07 07:13:44" level=info msg=" [migrator] applying migration script add sync policy to _devlake_blueprints and _devlake_pipelines table:20230911000041" time="2026-01-07 07:13:44" level=info msg=" [migrator] applying migration script add issue custom array field:20230921000083" time="2026-01-07 07:13:44" level=info msg=" [migrator] applying migration script add ConnectionId to Labels tables:20231026000002" time="2026-01-07 07:13:44" level=info msg=" [migrator] applying migration script remove position field from pull_request_comments:20231103102700" time="2026-01-07 07:13:44" level=info msg=" [migrator] applying migration script change duration_sec field to float64 in all related tables:20231115170000" time="2026-01-07 07:13:44" level=info msg=" [migrator] applying migration script add original status and original result to all related devops tables:20231116142100" time="2026-01-07 07:13:44" level=info msg=" [migrator] applying migration script change duration_sec field to float64 in all related tables:20231122140000" time="2026-01-07 07:13:44" level=info msg=" [migrator] applying migration script add commit_msg to cicd_deployment_commits table:20231127142100" time="2026-01-07 07:13:45" level=info msg=" [migrator] applying migration script add queued_duration_sec field to devops tables:20231128140000" time="2026-01-07 07:13:45" level=info msg=" [migrator] applying migration script modify issues original_type length from 100 to 500:20231205155129" time="2026-01-07 07:13:45" level=info msg="\x1b[31;1m/Users/wangcong/code/go/incubator-devlake/backend/impls/dalgorm/dalgorm.go:215 \x1b[35;1mERROR: cached plan must not change result type (SQLSTATE 0A000)\n\x1b[0m\x1b[33m[0.324ms] \x1b[34;1m[rows:0]\x1b[0m SELECT * FROM \"issues\" ORDER BY \"issues\".\"original_type\" LIMIT 1" time="2026-01-07 07:13:45" level=info msg=" [migrator] applying migration script add commit_msg to cicd_pipeline_commits table:20231208142100" time="2026-01-07 07:13:45" level=info msg=" [migrator] applying migration script modify issues lead_time_minutes to *uint:20240115170000" time="2026-01-07 07:13:45" level=info msg="\x1b[31;1m/Users/wangcong/code/go/incubator-devlake/backend/impls/dalgorm/dalgorm.go:215 \x1b[35;1mERROR: cached plan must not change result type (SQLSTATE 0A000)\n\x1b[0m\x1b[33m[0.527ms] \x1b[34;1m[rows:0]\x1b[0m SELECT * FROM \"issues\" ORDER BY \"issues\".\"lead_time_minutes\" LIMIT 1" time="2026-01-07 07:13:45" level=info msg=" [migrator] applying migration script fix some tables fields sort:20240116000011" time="2026-01-07 07:13:45" level=info msg=" [migrator] applying migration script add urgency to issues table:20240117142100" time="2026-01-07 07:13:45" level=info msg=" [migrator] applying migration script modify refs id length from 255 to 500:20240124155129" time="2026-01-07 07:13:45" level=info msg="\x1b[31;1m/Users/wangcong/code/go/incubator-devlake/backend/impls/dalgorm/dalgorm.go:215 \x1b[35;1mERROR: cached plan must not change result type (SQLSTATE 0A000)\n\x1b[0m\x1b[33m[0.445ms] \x1b[34;1m[rows:0]\x1b[0m SELECT * FROM \"refs\" ORDER BY \"refs\".\"id\" LIMIT 1" time="2026-01-07 07:13:45" level=info msg=" [migrator] applying migration script add original_environment to cicd_deployments and cicd_deployment_commits:20240129150000" time="2026-01-07 07:13:45" level=info msg=" [migrator] applying migration script add subtaskname to deployment:20240308142101" time="2026-01-07 07:13:45" level=info msg=" [migrator] applying migration script add _devlake_store table:20240318111247" time="2026-01-07 07:13:45" level=info msg=" [migrator] applying migration script add some fields to _devlake_subtasks table:20240322111247" time="2026-01-07 07:13:45" level=info msg=" [migrator] applying migration script add display title and url to deployments and pipelines:20240410111248" time="2026-01-07 07:13:45" level=info msg=" [migrator] applying migration script add CompanyId to Connection:20240415000000" time="2026-01-07 07:13:45" level=info msg=" [migrator] applying migration script add _devlake_subtask_states:20240424152734" time="2026-01-07 07:13:45" level=info msg=" [migrator] applying migration script add cicd_releases table:20240514181200" time="2026-01-07 07:13:45" level=info msg=" [migrator] applying migration script add commit_sha to cicd_releases:20240515194901" time="2026-01-07 07:13:45" level=info msg=" [migrator] applying migration script modify cicd_deployment_commits repo_url from 191 to 500:20240521200500" time="2026-01-07 07:13:45" level=info msg=" [migrator] applying migration script modify cicd_pipeline_commits repo_url from 255 to 500:20240521201000" time="2026-01-07 07:13:45" level=info msg=" [migrator] applying migration script update issue_key's type in pull_request_issues:20240523174200" time="2026-01-07 07:13:45" level=info msg=" [migrator] applying migration script update plugin_option's type in project_metric_settings:20240523194205" time="2026-01-07 07:13:45" level=info msg="\x1b[31;1m/Users/wangcong/code/go/incubator-devlake/backend/impls/dalgorm/dalgorm.go:215 \x1b[35;1mERROR: could not identify an ordering operator for type json (SQLSTATE 42883)\n\x1b[0m\x1b[33m[0.410ms] \x1b[34;1m[rows:0]\x1b[0m SELECT * FROM \"project_metric_settings\" ORDER BY \"project_metric_settings\".\"plugin_option\" LIMIT 1" time="2026-01-07 07:13:45" level=info msg=" [migrator] applying migration script add pull_request_reviewers and pull_request_assignees tables:20240531000041" time="2026-01-07 07:13:45" level=info msg=" [migrator] applying migration script changing pull_request_commits primary key columns order:20240602103400" time="2026-01-07 07:13:45" level=info msg=" [migrator] applying migration script add pull_request_id index for pull_request_comments:20240602103401" time="2026-01-07 07:13:45" level=info msg="\x1b[31;1m/Users/wangcong/code/go/incubator-devlake/backend/impls/dalgorm/dalgorm.go:215 \x1b[35;1mERROR: cached plan must not change result type (SQLSTATE 0A000)\n\x1b[0m\x1b[33m[0.344ms] \x1b[34;1m[rows:0]\x1b[0m SELECT * FROM \"pull_request_comments\" ORDER BY \"pull_request_comments\".\"pull_request_id\" LIMIT 1" time="2026-01-07 07:13:45" level=info msg=" [migrator] applying migration script modify pull_request_reviewers and pull_request_assignees id columns:20240607000041" time="2026-01-07 07:13:45" level=info msg=" [migrator] applying migration script init tables: incidents and incident_assignees:20240621152500" time="2026-01-07 07:13:45" level=info msg=" [migrator] applying migration script rename project_issue_metrics to project_incident_deployment_relationships:20240621162000" time="2026-01-07 07:13:45" level=info msg=" [migrator] applying migration script add additions and deletions to pr:20240710142100" time="2026-01-07 07:13:45" level=info msg=" [migrator] applying migration script add merged by to pull_requests:20240710142101" time="2026-01-07 07:13:45" level=info msg=" [migrator] applying migration script add is_draft to pull_requests:20240725142101" time="2026-01-07 07:13:45" level=info msg=" [migrator] applying migration script add date fields to project_pr_metrics according to #7775:20240731154944" time="2026-01-07 07:13:45" level=info msg=" [migrator] applying migration script add table and scope_id to incidents:20240731180000" time="2026-01-07 07:13:45" level=info msg=" [migrator] applying migration script add assignee info to incidents:20240801110000" time="2026-01-07 07:13:45" level=info msg=" [migrator] applying migration script add is_subtask to issues:20240813142101" time="2026-01-07 07:13:46" level=info msg=" [migrator] applying migration script add is_child to cicd_pipelines:20240906120000" time="2026-01-07 07:13:46" level=info msg=" [migrator] applying migration script increase cq_issues.component length to text:20240919160242" time="2026-01-07 07:13:46" level=info msg=" [migrator] applying migration script add cq_issue_impacts table:20241010162658" time="2026-01-07 07:13:46" level=info msg=" [migrator] applying migration script add tapd lifetime tables:20250221000000" time="2026-01-07 07:13:46" level=info msg=" [migrator] applying migration script add due_date to issues:20250303142101" time="2026-01-07 07:13:46" level=info msg=" [migrator] applying migration script tapd update scope config, add due date fields:20250305093400" time="2026-01-07 07:13:46" level=info msg=" [migrator] applying migration script create QA tables:20250421104500" time="2026-01-07 07:13:46" level=info msg=" [migrator] applying migration script extend field size for cq:20250527000000" time="2026-01-07 07:13:46" level=info msg=" [migrator] applying migration script add missing issues.fix_versions:20250710140418" time="2026-01-07 07:13:46" level=info msg=" [migrator] applying migration script add priority to blueprints and pipelines:20250813151534" time="2026-01-07 07:13:46" level=info msg=" [migrator] applying migration script fix null priority values in blueprints and pipelines:20251022195645" time="2026-01-07 07:13:46" level=info msg="total 0 blueprints were scheduled" time="2026-01-07 07:13:46" level=info msg="no db migration needed" time="2026-01-07 07:13:46" level=info msg=" [pipeline service] get lock and wait next pipeline" [GIN-debug] [WARNING] Creating an Engine instance with the Logger and Recovery middleware already attached. [GIN-debug] [WARNING] Running in "debug" mode. Switch to "release" mode in production. - using env: export GIN_MODE=release - using code: gin.SetMode(gin.ReleaseMode) [GIN-debug] GET /ping --> github.com/apache/incubator-devlake/server/api/ping.Get (3 handlers) [GIN-debug] GET /ready --> github.com/apache/incubator-devlake/server/api/ping.Ready (3 handlers) [GIN-debug] GET /health --> github.com/apache/incubator-devlake/server/api/ping.Health (3 handlers) [GIN-debug] GET /version --> github.com/apache/incubator-devlake/server/api/version.Get (3 handlers) ``` migration log for mysql ```log $ DEVLAKE_PLUGINS=tapd make godev make godev -C backend DISABLED_REMOTE_PLUGINS=true make build-plugin run scripts/build-plugins.sh Usage: build all plugins: scripts/build-plugins.sh [golang build flags...] build and keep specified plugins only: DEVLAKE_PLUGINS=github,jira scripts/build-plugins.sh [golang build flags...] Building the following plugins: Building plugin tapd to bin/plugins/tapd/tapd.so with args: --gcflags= go run server/main.go Version: dev time="2026-01-07 07:16:45" level=info msg="migrator has been initialized" time="2026-01-07 07:16:45" level=info msg="plugin loaded tapd" time="2026-01-07 07:16:45" level=info msg="all plugins have been loaded" time="2026-01-07 07:16:45" level=info msg="register plugin:tapd's migrations scripts" time="2026-01-07 07:16:45" level=info msg="has pending scripts? false, FORCE_MIGRATION: true" time="2026-01-07 07:16:45" level=info msg=" [migrator] [Execute] pending scripts: 129, executed scripts: 0, total: 129" time="2026-01-07 07:16:45" level=info msg=" [migrator] applying migration script add commit line change table:202209221033" time="2026-01-07 07:16:45" level=info msg=" [migrator] applying migration script create init schemas:20220406212344" time="2026-01-07 07:16:45" level=info msg=" [migrator] applying migration script Rename step to stage :20220505212344" time="2026-01-07 07:16:45" level=info msg=" [migrator] applying migration script add column `subtasks` at _devlake_tasks:20220601000005" time="2026-01-07 07:16:45" level=info msg=" [migrator] applying migration script add mode field to blueprint:20220616110537" time="2026-01-07 07:16:45" level=info msg=" [migrator] applying migration script blueprint normal mode support:20220622110537" time="2026-01-07 07:16:45" level=info msg=" [migrator] applying migration script create domain layer init schemas:20220707232344" time="2026-01-07 07:16:46" level=info msg=" [migrator] applying migration script create subtask schema:20220711000001" time="2026-01-07 07:16:46" level=info msg=" [migrator] applying migration script add commit_file_components components table,update commit_files table:20220722165805" time="2026-01-07 07:16:46" level=info msg=" [migrator] applying migration script add project_mapping table to domain layer:20220725152355" time="2026-01-07 07:16:46" level=info msg=" [migrator] applying migration script remove notes from domain layer:20220727165805" time="2026-01-07 07:16:46" level=info msg=" [migrator] applying migration script rename pull_request_number to pull_request_key, issue_number to issue_key:20220729165805" time="2026-01-07 07:16:46" level=info msg=" [migrator] applying migration script add NoPKModel to commit_parents:20220801162735" time="2026-01-07 07:16:46" level=info msg=" [migrator] applying migration script add cicd models:20220818232735" time="2026-01-07 07:16:46" level=info msg=" [migrator] applying migration script rename user_id to account_id in pull_request_comments and issue_comments:20220826120824" time="2026-01-07 07:16:46" level=info msg=" [migrator] applying migration script modify tables for dora:20220829232735" time="2026-01-07 07:16:46" level=info msg=" [migrator] applying migration script add column `type` at boards:20220830142321" time="2026-01-07 07:16:46" level=info msg=" [migrator] applying migration script encrypt Blueprint:20220904142321" time="2026-01-07 07:16:46" level=info msg=" [migrator] applying migration script encrypt Pipeline:20220904162121" time="2026-01-07 07:16:46" level=info msg=" [migrator] applying migration script modify cicd pipeline:20220905232735" time="2026-01-07 07:16:46" level=info msg=" [migrator] applying migration script modify cicd tasks:20220909232735" time="2026-01-07 07:16:46" level=info msg=" [migrator] applying migration script add length of commit_file file_path:20220913165805" time="2026-01-07 07:16:46" level=info msg=" [migrator] applying migration script modify board repos:20220913232735" time="2026-01-07 07:16:46" level=info msg=" [migrator] applying migration script add origin change lead time for pr:20220913235535" time="2026-01-07 07:16:46" level=info msg=" [migrator] applying migration script UpdateSchemas for renamePipelineCommits:20220915000025" time="2026-01-07 07:16:46" level=info msg=" [migrator] applying migration script modify lead_time_minutes:20220929145125" time="2026-01-07 07:16:46" level=info msg=" [migrator] applying migration script add snapshot table:20221009111241" time="2026-01-07 07:16:46" level=info msg=" [migrator] applying migration script Create collector state table:20221101000001" time="2026-01-07 07:16:46" level=info msg=" [migrator] applying migration script Remove cicd_pipeline_relation:20221107000001" time="2026-01-07 07:16:46" level=info msg=" [migrator] applying migration script add skip_on_fail to _devlake_pipelines and _devlake_blueprint:20221107095744" time="2026-01-07 07:16:46" level=info msg=" [migrator] applying migration script add project tables:20221109194734" time="2026-01-07 07:16:46" level=info msg=" [migrator] applying migration script Tapd init schemas:20221109201138" time="2026-01-07 07:16:46" level=info msg=" [migrator] applying migration script modify commits diffs:20221109232735" time="2026-01-07 07:16:46" level=info msg=" [migrator] applying migration script add project pr metric tables:20221111000001" time="2026-01-07 07:16:47" level=info msg=" [migrator] applying migration script add labels' schema for blueprint and pipeline:20221115000034" time="2026-01-07 07:16:47" level=info msg=" [migrator] applying migration script add project to blueprint:20221117184342" time="2026-01-07 07:16:47" level=info msg=" [migrator] applying migration script add project issue metric tables:20221120000001" time="2026-01-07 07:16:47" level=info msg=" [migrator] applying migration script save state for collector:20221125000038" time="2026-01-07 07:16:47" level=info msg=" [migrator] applying migration script rename fields in project pr metric tables:20221201000001" time="2026-01-07 07:16:47" level=info msg=" [migrator] applying migration script add enable to project metric:20221201190341" time="2026-01-07 07:16:47" level=info msg=" [migrator] applying migration script add cicd scope and add cicd_scope_id and drop builds&jobs:20221207000001" time="2026-01-07 07:16:47" level=info msg=" [migrator] applying migration script add original_project to issues:20221215142543" time="2026-01-07 07:16:47" level=info msg=" [migrator] applying migration script add error_name to _devlake_tasks and _devlake_pipelines:20221221150548" time="2026-01-07 07:16:47" level=info msg=" [migrator] applying migration script encrypt task.options:20221221162121" time="2026-01-07 07:16:47" level=info msg=" [migrator] applying migration script add original type to issue:20221230162121" time="2026-01-07 07:16:47" level=info msg=" [migrator] applying migration script rename project metrics:20222123191424" time="2026-01-07 07:16:47" level=info msg=" [migrator] applying migration script Tapd encode connection token:20230115201138" time="2026-01-07 07:16:47" level=info msg=" [migrator] applying migration script add time_after to _devlake_collector_latest_state:20230213200040" time="2026-01-07 07:16:47" level=info msg=" [migrator] applying migration script modify issues story_point from int64 to float64:20230214145125" time="2026-01-07 07:16:47" level=info msg=" [migrator] applying migration script add commit_sha index for commit_files:20230222145127" time="2026-01-07 07:16:47" level=info msg=" [migrator] applying migration script add host, namespace, repo_name to issue_repo_commits:20230222153154" time="2026-01-07 07:16:47" level=info msg=" [migrator] applying migration script remove created_date_after from _devlake_collector_latest_state:20230223200040" time="2026-01-07 07:16:47" level=info msg=" [migrator] applying migration script add code quality domain:20230301000082" time="2026-01-07 07:16:47" level=info msg=" [migrator] applying migration script Tapd add transformation, update _raw_data_params:20230323000003" time="2026-01-07 07:16:47" level=info msg=" [migrator] applying migration script Tapd delete issue and remote link:20230323000004" time="2026-01-07 07:16:47" level=info msg=" [migrator] applying migration script add issue_assignees table:20230402000041" time="2026-01-07 07:16:47" level=info msg=" [migrator] applying migration script Rename Collector state table for Singer Taps:20230405000001" time="2026-01-07 07:16:47" level=info msg=" [migrator] applying migration script Rename cicd_piopeline_commits repo to repo_url:20230406170701" time="2026-01-07 07:16:47" level=info msg=" [migrator] applying migration script modify tapd custom field name:20230411000004" time="2026-01-07 07:16:50" level=info msg=" [migrator] applying migration script modify tapd custom field name:20230412000015" time="2026-01-07 07:16:50" level=info msg=" [migrator] applying migration script Rename project_pr_metrics.deployment_id to deployment_commit_id:20230416080701" time="2026-01-07 07:16:50" level=info msg=" [migrator] applying migration script add commit author info to pull_request_commits table:20230419145129" time="2026-01-07 07:16:50" level=info msg=" [migrator] applying migration script add cicd_deployment_commits table:20230426150702" time="2026-01-07 07:16:50" level=info msg=" [migrator] applying migration script add original status to pull_requests:20230508162121" time="2026-01-07 07:16:50" level=info msg=" [migrator] applying migration script add calendar months:20230511000001" time="2026-01-07 07:16:50" level=info msg=" [migrator] applying migration script change pull_request_comments.pr_id to varchar(255) type:20230516000001" time="2026-01-07 07:16:50" level=info msg=" [migrator] applying migration script Rename finished_commits_diffs to _tool_refdiff_finished_commits_diffs:20230516000002" time="2026-01-07 07:16:50" level=info msg=" [migrator] applying migration script add updated_date to issue_comments:20230517162121" time="2026-01-07 07:16:50" level=info msg=" [migrator] applying migration script rename transformation rule to scope config for tapd:20230531135926" time="2026-01-07 07:16:50" level=info msg=" [migrator] applying migration script populated _raw_data columns for tapd workspaces:20230630000002" time="2026-01-07 07:16:50" level=info msg=" [migrator] applying migration script add api key tables:20230725142900" time="2026-01-07 07:16:50" level=info msg=" [migrator] applying migration script tasks uses json:20230728162121" time="2026-01-07 07:16:51" level=info msg=" [migrator] applying migration script add issue_relationships table:20230816000001" time="2026-01-07 07:16:51" level=info msg=" [migrator] applying migration script modify cicd_pipelines name from varchar to text:20230821145125" time="2026-01-07 07:16:51" level=info msg=" [migrator] applying migration script drop _devlake_collector_tap_state table:20230822145125" time="2026-01-07 07:16:51" level=info msg=" [migrator] applying migration script normalize bp settings to multiple tables:20230829145125" time="2026-01-07 07:16:51" level=info msg=" [migrator] applying migration script add cicd deployments table:20230831162403" time="2026-01-07 07:16:51" level=info msg=" [migrator] applying migration script add sync policy to _devlake_blueprints and _devlake_pipelines table:20230911000041" time="2026-01-07 07:16:51" level=info msg=" [migrator] applying migration script add issue custom array field:20230921000083" time="2026-01-07 07:16:51" level=info msg=" [migrator] applying migration script add ConnectionId to Labels tables:20231026000002" time="2026-01-07 07:16:51" level=info msg=" [migrator] applying migration script remove position field from pull_request_comments:20231103102700" time="2026-01-07 07:16:51" level=info msg=" [migrator] applying migration script change duration_sec field to float64 in all related tables:20231115170000" time="2026-01-07 07:16:51" level=info msg=" [migrator] applying migration script add original status and original result to all related devops tables:20231116142100" time="2026-01-07 07:16:52" level=info msg=" [migrator] applying migration script change duration_sec field to float64 in all related tables:20231122140000" time="2026-01-07 07:16:52" level=info msg=" [migrator] applying migration script add commit_msg to cicd_deployment_commits table:20231127142100" time="2026-01-07 07:16:52" level=info msg=" [migrator] applying migration script add queued_duration_sec field to devops tables:20231128140000" time="2026-01-07 07:16:52" level=info msg=" [migrator] applying migration script modify issues original_type length from 100 to 500:20231205155129" time="2026-01-07 07:16:52" level=info msg=" [migrator] applying migration script add commit_msg to cicd_pipeline_commits table:20231208142100" time="2026-01-07 07:16:52" level=info msg=" [migrator] applying migration script modify issues lead_time_minutes to *uint:20240115170000" time="2026-01-07 07:16:52" level=info msg=" [migrator] applying migration script fix some tables fields sort:20240116000011" time="2026-01-07 07:16:54" level=info msg=" [migrator] applying migration script add urgency to issues table:20240117142100" time="2026-01-07 07:16:54" level=info msg=" [migrator] applying migration script modify refs id length from 255 to 500:20240124155129" time="2026-01-07 07:16:54" level=info msg=" [migrator] applying migration script add original_environment to cicd_deployments and cicd_deployment_commits:20240129150000" time="2026-01-07 07:16:54" level=info msg=" [migrator] applying migration script add subtaskname to deployment:20240308142101" time="2026-01-07 07:16:54" level=info msg=" [migrator] applying migration script add _devlake_store table:20240318111247" time="2026-01-07 07:16:54" level=info msg=" [migrator] applying migration script add some fields to _devlake_subtasks table:20240322111247" time="2026-01-07 07:16:54" level=info msg=" [migrator] applying migration script add display title and url to deployments and pipelines:20240410111248" time="2026-01-07 07:16:54" level=info msg=" [migrator] applying migration script add CompanyId to Connection:20240415000000" time="2026-01-07 07:16:54" level=info msg=" [migrator] applying migration script add _devlake_subtask_states:20240424152734" time="2026-01-07 07:16:54" level=info msg=" [migrator] applying migration script add cicd_releases table:20240514181200" time="2026-01-07 07:16:54" level=info msg=" [migrator] applying migration script add commit_sha to cicd_releases:20240515194901" time="2026-01-07 07:16:54" level=info msg=" [migrator] applying migration script modify cicd_deployment_commits repo_url from 191 to 500:20240521200500" time="2026-01-07 07:16:54" level=info msg=" [migrator] applying migration script modify cicd_pipeline_commits repo_url from 255 to 500:20240521201000" time="2026-01-07 07:16:54" level=info msg=" [migrator] applying migration script update issue_key's type in pull_request_issues:20240523174200" time="2026-01-07 07:16:54" level=info msg=" [migrator] applying migration script update plugin_option's type in project_metric_settings:20240523194205" time="2026-01-07 07:16:55" level=info msg=" [migrator] applying migration script add pull_request_reviewers and pull_request_assignees tables:20240531000041" time="2026-01-07 07:16:55" level=info msg=" [migrator] applying migration script changing pull_request_commits primary key columns order:20240602103400" time="2026-01-07 07:16:55" level=info msg=" [migrator] applying migration script add pull_request_id index for pull_request_comments:20240602103401" time="2026-01-07 07:16:55" level=info msg=" [migrator] applying migration script modify pull_request_reviewers and pull_request_assignees id columns:20240607000041" time="2026-01-07 07:16:55" level=info msg=" [migrator] applying migration script init tables: incidents and incident_assignees:20240621152500" time="2026-01-07 07:16:55" level=info msg=" [migrator] applying migration script rename project_issue_metrics to project_incident_deployment_relationships:20240621162000" time="2026-01-07 07:16:55" level=info msg=" [migrator] applying migration script add additions and deletions to pr:20240710142100" time="2026-01-07 07:16:55" level=info msg=" [migrator] applying migration script add merged by to pull_requests:20240710142101" time="2026-01-07 07:16:55" level=info msg=" [migrator] applying migration script add is_draft to pull_requests:20240725142101" time="2026-01-07 07:16:55" level=info msg=" [migrator] applying migration script add date fields to project_pr_metrics according to #7775:20240731154944" time="2026-01-07 07:16:55" level=info msg=" [migrator] applying migration script add table and scope_id to incidents:20240731180000" time="2026-01-07 07:16:55" level=info msg=" [migrator] applying migration script add assignee info to incidents:20240801110000" time="2026-01-07 07:16:55" level=info msg=" [migrator] applying migration script add is_subtask to issues:20240813142101" time="2026-01-07 07:16:55" level=info msg=" [migrator] applying migration script add is_child to cicd_pipelines:20240906120000" time="2026-01-07 07:16:55" level=info msg=" [migrator] applying migration script increase cq_issues.component length to text:20240919160242" time="2026-01-07 07:16:55" level=info msg=" [migrator] applying migration script add cq_issue_impacts table:20241010162658" time="2026-01-07 07:16:55" level=info msg=" [migrator] applying migration script add tapd lifetime tables:20250221000000" time="2026-01-07 07:16:55" level=info msg=" [migrator] applying migration script add due_date to issues:20250303142101" time="2026-01-07 07:16:55" level=info msg=" [migrator] applying migration script tapd update scope config, add due date fields:20250305093400" time="2026-01-07 07:16:56" level=info msg=" [migrator] applying migration script create QA tables:20250421104500" time="2026-01-07 07:16:56" level=info msg=" [migrator] applying migration script extend field size for cq:20250527000000" time="2026-01-07 07:16:56" level=info msg=" [migrator] applying migration script add missing issues.fix_versions:20250710140418" time="2026-01-07 07:16:56" level=info msg=" [migrator] applying migration script add priority to blueprints and pipelines:20250813151534" time="2026-01-07 07:16:56" level=info msg=" [migrator] applying migration script fix null priority values in blueprints and pipelines:20251022195645" time="2026-01-07 07:16:56" level=info msg="total 0 blueprints were scheduled" time="2026-01-07 07:16:56" level=info msg="no db migration needed" [GIN-debug] [WARNING] Creating an Engine instance with the Logger and Recovery middleware already attached. [GIN-debug] [WARNING] Running in "debug" mode. Switch to "release" mode in production. - using env: export GIN_MODE=release - using code: gin.SetMode(gin.ReleaseMode) [GIN-debug] GET /ping --> github.com/apache/incubator-devlake/server/api/ping.Get (3 handlers) [GIN-debug] GET /ready --> github.com/apache/incubator-devlake/server/api/ping.Ready (3 handlers) [GIN-debug] GET /health --> github.com/apache/incubator-devlake/server/api/ping.Health (3 handlers) [GIN-debug] GET /version --> github.com/apache/incubator-devlake/server/api/version.Get (3 handlers) time="2026-01-07 07:16:56" level=info msg=" [pipeline service] get lock and wait next pipeline" ``` ### Version main ### Are you willing to submit PR? - [x] Yes I am willing to submit a PR! ### Code of Conduct - [x] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
