klemen-df commented on issue #7715:
URL:
https://github.com/apache/incubator-devlake/issues/7715#issuecomment-2681290688
why is this closed if the problem still persist?
my last 10 migrations:
```
| 2024-09-25 07:31:02.496 | 20240813154445 | change
_tool_gitee_issues.component type to text |
gitee |
| 2024-09-25 07:31:02.627 | 20240813154633 | change
_tool_github_issues.component type to text |
github |
| 2024-09-25 07:31:02.641 | 20240813155602 | increase
_tool_sonarqube_projects.project_key length to 500 |
sonarqube |
| 2024-09-25 07:31:02.648 | 20240821141954 | flush jira convertIssues data
from devlake_subtask_states table | jira |
| 2024-09-25 07:31:02.686 | 20240821160000 | add index to _tool_github_jobs
| github |
| 2024-11-20 09:54:39.427 | 20240906120000 | add is_child to cicd_pipelines
| Framework |
| 2024-11-20 09:54:39.495 | 20240906150000 | add is_child to table
_tool_gitlab_pipelines and _tool_gitlab_pipeline_projects | gitlab |
| 2024-11-20 09:58:17.025 | 20240930151715 | add organizations to the
connections table | sonarqube |
| 2024-11-20 09:58:17.063 | 20241010162658 | add cq_issue_impacts table
| Framework |
| 2024-11-20 09:58:17.104 | 20241010162943 | add issue_impacts table for
sonarcloud | sonarqube |
```
```
mysql> show columns in _tool_sonarqube_projects;
+--------------------+-----------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+-----------------+------+-----+---------+-------+
| created_at | datetime(3) | YES | | NULL | |
| updated_at | datetime(3) | YES | | NULL | |
| _raw_data_params | varchar(255) | YES | MUL | NULL | |
| _raw_data_table | varchar(255) | YES | | NULL | |
| _raw_data_id | bigint unsigned | YES | | NULL | |
| _raw_data_remark | longtext | YES | | NULL | |
| connection_id | bigint unsigned | NO | PRI | NULL | |
| project_key | varchar(500) | NO | PRI | NULL | |
| name | varchar(500) | YES | | NULL | |
| qualifier | varchar(255) | YES | | NULL | |
| visibility | varchar(64) | YES | | NULL | |
| last_analysis_date | datetime(3) | YES | | NULL | |
| revision | varchar(128) | YES | | NULL | |
| scope_config_id | bigint unsigned | YES | | NULL | |
+--------------------+-----------------+------+-----+---------+-------+
14 rows in set (0.01 sec)
```
and my project
`sonarqube:SonarqubeProject:1:Xyyyyyy_xyyyyyy.data-service.device-parameters-manager_AY51PdzPWFjHTJF4SDr_`
But the issue that I'm getting is in 'cq_issues':
`INSERT INTO `cq_issues`
(`id`,`created_at`,`updated_at`,`_raw_data_params`,`_raw_data_table`,`_raw_data_id`,`_raw_data_remark`,`rule`,`severity`,`component`,`project_key`,`line`,`status`,`message`,`debt`,`effort`,`commit_author_email`,`assignee`,`hash`,`tags`,`type`,`scope`,`start_line`,`end_line`,`start_offset`,`end_offset`,`vulnerability_probability`,`security_category`,`created_date`,`updated_date`)`
```
mysql> show columns in cq_issues;
+---------------------------+-----------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra
|
+---------------------------+-----------------+------+-----+---------+-------+
| id | varchar(255) | NO | PRI | NULL |
|
| created_at | datetime(3) | YES | | NULL |
|
| updated_at | datetime(3) | YES | | NULL |
|
| _raw_data_params | varchar(255) | YES | MUL | NULL |
|
| _raw_data_table | varchar(255) | YES | | NULL |
|
| _raw_data_id | bigint unsigned | YES | | NULL |
|
| _raw_data_remark | longtext | YES | | NULL |
|
| rule | varchar(255) | YES | | NULL |
|
| severity | varchar(100) | YES | | NULL |
|
| component | varchar(255) | YES | | NULL |
|
| project_key | varchar(100) | YES | MUL | NULL |
|
```
--
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]
