michelengelen commented on issue #8623:
URL: 
https://github.com/apache/incubator-devlake/issues/8623#issuecomment-3441782234

   All right ... seems like the instance keeps trying to restart due to a 
faulty SELECT:
   
   ```bash
   [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="2025-10-24 08:22:09" level=info msg=" [pipeline service] get lock and 
wait next pipeline"
   time="2025-10-24 08:22:09" level=info 
msg="\x1b[31;1m/app/impls/dalgorm/dalgorm.go:227 \x1b[35;1msql: Scan error on 
column index 0, name \"priority\": converting NULL to int is 
unsupported\n\x1b[0m\x1b[33m[0.973ms] \x1b[34;1m[rows:1]\x1b[0m SELECT 
`priority` FROM `_devlake_pipelines` WHERE status IN 
('TASK_CREATED','TASK_RERUN','TASK_RESUME') ORDER BY priority DESC LIMIT 1"
   panic: 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).Pluck
     |     /app/impls/dalgorm/dalgorm.go:227
     | github.com/apache/incubator-devlake/server/services.dequeuePipeline
     |     /app/server/services/pipeline.go:268
     | github.com/apache/incubator-devlake/server/services.RunPipelineInQueue
     |     /app/server/services/pipeline.go:335
     | runtime.goexit
     |     /usr/local/go/src/runtime/asm_amd64.s:1598
   Wraps: (2) sql: Scan error on column index 0, name "priority": converting 
NULL to int is unsupported (500)
   Wraps: (3) sql: Scan error on column index 0, name "priority"
   Wraps: (4) converting NULL to int is unsupported
   Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) 
*fmt.wrapError (4) *errors.errorString
   ```
   
   `Scan error on column index 0, name \"priority\": converting NULL to int is 
unsupported` seems to be the problem here.
   
   cc @klesh @petkostas 


-- 
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]

Reply via email to