Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

The task configured as boot2 application cannot be executed in SCDF 2.11.0 RC1. #5459

Closed
wqld opened this issue Sep 7, 2023 · 10 comments
Closed
Milestone

Comments

@wqld
Copy link

wqld commented Sep 7, 2023

Description:
application: Spring Batch 4
task: Consists of a single application
dataflow: 2.11.0-RC1
env: k8s

When I try to run a task, the following error pop-up occurs.

PreparedStatementCallback; SQL [INSERT INTO BOOT3_TASK_EXECUTION_METADATA (ID, TASK_EXECUTION_ID, TASK_EXECUTION_MANIFEST) VALUES (?, ?, ?)]; ERROR: insert or update on table "boot3_task_execution_metadata" violates foreign key constraint "boot3_task_metadata_fk" Detail: Key (task_execution_id)=(66) is not present in table "boot3_task_execution".; nested exception is org.postgresql.util.PSQLException: ERROR: insert or update on table "boot3_task_execution_metadata" violates foreign key constraint "boot3_task_metadata_fk" Detail: Key (task_execution_id)=(66) is not present in table "boot3_task_execution".

Is this a bug? or did I miss some setting?

Release versions:
2.11.0-RC1

@github-actions github-actions bot added the status/need-triage Team needs to triage and take a first look label Sep 7, 2023
@onobc onobc added this to the 2.11.0 milestone Sep 7, 2023
@cppwfs
Copy link
Contributor

cppwfs commented Sep 7, 2023

Can you share with us the steps that you took to register the Boot 2 application with spring cloud dataflow?
Thank you

@cppwfs cppwfs added status/need-feedback Calling participant to provide feedback and removed status/need-triage Team needs to triage and take a first look labels Sep 7, 2023
@corneil
Copy link
Contributor

corneil commented Sep 8, 2023

Executed <timestamp || timestamp-batch> && <timestamp3 || timestamp-batch3> with PostgreSQL.

@wqld
Copy link
Author

wqld commented Sep 11, 2023

Can you share with us the steps that you took to register the Boot 2 application with spring cloud dataflow? Thank you

Hello @cppwfs, thank you for reply first.

I registered the boot 2 application through the following proccess.

  1. click the ADD APPLICATION(S) button in the Applications.
  2. click Register one or more applications and enter the name, type(task), boot version(2.x) and uri(container image uri created with spring batch 4.0 in aws ecr).
  3. click IMPORT APPLICATION(S) button to complete the registration.

@github-actions github-actions bot added for/team-attention For team attention and removed status/need-feedback Calling participant to provide feedback labels Sep 11, 2023
@wqld
Copy link
Author

wqld commented Sep 11, 2023

After several registrations and deletions, we confirmed that the container was running with the correct arguments.

    --spring.cloud.deployer.bootVersion=2
    --spring.cloud.task.schemaTarget=boot2
    --spring.batch.jdbc.table-prefix=BATCH_ 
    --spring.cloud.task.tablePrefix=TASK_

@cppwfs
Copy link
Contributor

cppwfs commented Sep 11, 2023

When you created the application did you include the Spring Cloud Task as a dependency and add the @EnableTask annotations?

@github-actions github-actions bot added status/need-feedback Calling participant to provide feedback and removed for/team-attention For team attention labels Sep 11, 2023
@onobc
Copy link
Contributor

onobc commented Sep 11, 2023

Hi @21kyu ,

So did the issue go away? Or are you still seeing problems?

Thanks

@wqld
Copy link
Author

wqld commented Sep 12, 2023

When you created the application did you include the Spring Cloud Task as a dependency and add the @EnableTask annotations?

Yes, that's right, all spring batch applications used in SCDF have the @EnableTask annotation added.

@github-actions github-actions bot added for/team-attention For team attention and removed status/need-feedback Calling participant to provide feedback labels Sep 12, 2023
@wqld
Copy link
Author

wqld commented Sep 12, 2023

Hi @onobc ,

Yes, it's working fine for now. Can I close this issue?

Thank you.

@onobc
Copy link
Contributor

onobc commented Sep 12, 2023

Thanks for confirming @21kyu ,
We want to take another look tomorrow at our team meeting tomorrow and we will probably close it then.

@github-actions github-actions bot added status/need-feedback Calling participant to provide feedback and removed for/team-attention For team attention labels Sep 12, 2023
@onobc
Copy link
Contributor

onobc commented Sep 13, 2023

Closing as cannot reproduce.

@onobc onobc closed this as completed Sep 13, 2023
@onobc onobc removed the status/need-feedback Calling participant to provide feedback label Sep 13, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants