SbloodyS commented on issue #9068:
URL:
https://github.com/apache/dolphinscheduler/issues/9068#issuecomment-1074825330
> > > > > > I had trace all the sql operation of postgresql. found the
result of the process query is fine, but the web page show error...
> > > > >
> > > > >
> > > > > Did the error log you paste is when you entering process instance
page happened?
> > > >
> > > >
> > > > I trace sql operation from Postgresql side, not ds code The error
log show when I enter the process define page. The process instance page and
task instance page shows no error in the log
> > >
> > >
> > > Base on the error log you pasted. It seems like there are some dirty
data in the process definition.
> > > Could you please execute the following sql to check if there are
`null` or `""` value in `operator` in it?
> > > ```
> > > SELECT td.id, td.code, td.name, td.version, td.release_state,
td.project_code, td.user_id, td.description,
> > > td.global_params, td.flag, td.warning_group_id, td.timeout,
td.tenant_id, td.update_time, td.create_time,
> > > sc.schedule_release_state, tu.user_name
> > > FROM t_ds_process_definition td
> > > left join (select process_definition_code,release_state as
schedule_release_state from t_ds_schedules group by
> > > process_definition_code,release_state) sc on
sc.process_definition_code = td.code
> > > left join t_ds_user tu on td.user_id = tu.id
> > > where td.project_code = #{projectCode}
> > > and td.user_id = #{userId}
> > > order by sc.schedule_release_state desc,td.update_time desc,td.id asc
> > > limit 10
> > > ```
> >
> >
> > After this sql, it will execute the following sql base on the above
sql's result data. And then throws NPE. There are some dirty data between these
two sql's result.
> > ```
> > select
> > *
> > from t_ds_process_definition_log
> > where code = #{code}
> > and version = #{version}
> > ```
>
> This sql return none and "where code = #{code}" should be "where
project_code = #{code}" ??
No, it's ```t_ds_process_definition.code``` and
```t_ds_process_definition.version```
--
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]
