[Bug][Jenkins Connector] Data Collection Fails with data too long error for primary_view column

[jvgr019]

Search before asking

• I had searched in the issues and found no similar issues.

What happened

When running Collect Data for a specific project through the Jenkins connector, an error is raised and the data import process stops. Data collection from Jenkins works successfully for other projects.

If I enable the "Skip failed tasks (Recommended when collecting a large volume of data, e.g. 10+ GitHub repositories, Jira boards, etc.)" option, the collection process completes, but the Jenkins data for this project is not imported, that is normally because skip errors is selected.

The error message indicates that the value is too long for the primary_view column. This column is column for _tool_jenkins_jobs that seems to contains url's. Actually this column is varchar(255) that is insuficient for containing url's

This is the error
attached stack trace -- stack trace: | github.com/apache/incubator-devlake/core/runner.RunPluginSubTasks | /app/core/runner/run_task.go:341 | [...repeated from below...] Wraps: (2) subtask extractApiJobs ended unexpectedly Wraps: (3) attached stack trace -- stack trace: | github.com/apache/incubator-devlake/impls/dalgorm.(*Dalgorm).convertGormError | /app/impls/dalgorm/dalgorm.go:547 | github.com/apache/incubator-devlake/impls/dalgorm.(*Dalgorm).CreateOrUpdate | /app/impls/dalgorm/dalgorm.go:265 | github.com/apache/incubator-devlake/helpers/pluginhelper/api.(*BatchSave).flushWithoutLocking | /app/helpers/pluginhelper/api/batch_save.go:131 | github.com/apache/incubator-devlake/helpers/pluginhelper/api.(*BatchSave).Close | /app/helpers/pluginhelper/api/batch_save.go:147 | github.com/apache/incubator-devlake/helpers/pluginhelper/api.(*BatchSaveDivider).Close | /app/helpers/pluginhelper/api/batch_save_divider.go:102 | github.com/apache/incubator-devlake/helpers/pluginhelper/api.(*ApiExtractor).Execute | /app/helpers/pluginhelper/api/api_extractor.go:141 | github.com/apache/incubator-devlake/plugins/jenkins/tasks.ExtractApiJobs | /app/plugins/jenkins/tasks/job_extractor.go:81 | github.com/apache/incubator-devlake/core/runner.runSubtask | /app/core/runner/run_task.go:433 | github.com/apache/incubator-devlake/core/runner.RunPluginSubTasks | /app/core/runner/run_task.go:338 | github.com/apache/incubator-devlake/core/runner.RunPluginTask | /app/core/runner/run_task.go:173 | github.com/apache/incubator-devlake/core/runner.RunTask | /app/core/runner/run_task.go:147 | github.com/apache/incubator-devlake/server/services.runTaskStandalone | /app/server/services/task_runner.go:114 | github.com/apache/incubator-devlake/server/services.RunTasksStandalone.func1 | /app/server/services/task.go:187 | runtime.goexit | /usr/local/go/src/runtime/asm_amd64.s:1598 Wraps: (4) Error 1406 (22001): Data too long for column 'primary_view' at row 11 (500) Wraps: (5) Error 1406 (22001): Data too long for column 'primary_view' at row 11 Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *withstack.withStack (4) *errutil.withPrefix (5) *mysql.MySQLError

What do you expect to happen

The data collection should complete successfully and import all Jenkins data for the project even the path to jenkins view is long as url specification

How to reproduce

• In jenkins create a long path to job creating subfolders and long name jobs
• Collect data form Jenkins connection

Anything else

No response

Version

v1.0.3-beta12@1d21f19

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct