jackwills-op commented on issue #8634: URL: https://github.com/apache/incubator-devlake/issues/8634#issuecomment-3498424777
You are right, running 'SELECT name, type FROM cicd_tasks WHERE type = 'DEPLOYMENT';' showed no deployment types. I then adjusted the mapping to include all the valid tasks in that table so the regex is now '(?i)(deploy|deployment|code_deploy_ecs)' and then re transformed the data and that made all those tasks have type 'DEPLOYMENT' but still no DORA data and cicd_deployment_commits table is still empty. What do we look at next? Side note: I also tried running a fresh collect data command and got this error for circleci run: attached stack trace -- stack trace: | github.com/apache/incubator-devlake/core/runner.RunPluginSubTasks | /app/core/runner/run_task.go:333 | [...repeated from below...] Wraps: (2) subtask collectJobs 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).Cursor | /app/impls/dalgorm/dalgorm.go:189 | github.com/apache/incubator-devlake/plugins/circleci/tasks.CollectJobs.func1 | /app/plugins/circleci/tasks/job_collector.go:67 | github.com/apache/incubator-devlake/helpers/pluginhelper/api.NewStatefulApiCollectorForFinalizableEntity | /app/helpers/pluginhelper/api/api_collector_stateful.go:144 | github.com/apache/incubator-devlake/plugins/circleci/tasks.CollectJobs | /app/plugins/circleci/tasks/job_collector.go:49 | github.com/apache/incubator-devlake/core/runner.runSubtask | /app/core/runner/run_ task.go:425 | github.com/apache/incubator-devlake/core/runner.RunPluginSubTasks | /app/core/runner/run_task.go:330 | github.com/apache/incubator-devlake/core/runner.RunPluginTask | /app/core/runner/run_task.go:165 | github.com/apache/incubator-devlake/core/runner.RunTask | /app/core/runner/run_task.go:139 | 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 1054 (42S22): Unknown column 'created_date' in 'where clause' (500) Wraps: (5) Error 1054 (42S22): Unknown column 'created_date' in 'where clause' Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *withstack.withStack (4) *errutil.withPrefix (5) *mysql.MySQLError -- 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]
