[AUTOCUT] Integration Test failed for sql: 2.12.0

[opensearch-ci-bot]

The integration test failed at distribution level for component sql
Version: 2.12.0
Distribution: deb
Architecture: x64
Platform: linux

Please check the logs: https://build.ci.opensearch.org/job/integ-test/7709/display/redirect

* Test-report manifest:*
- https://ci.opensearch.org/ci/dbc/integ-test/2.12.0/9358/linux/x64/deb/test-results/7709/integ-test/test-report.yml

Note: Steps to reproduce, additional logs and other files can be found within the above test-report manifest.
Instructions of this test-report manifest can be found here.

[opensearch-ci-bot]

The integration test failed at distribution level for component sql
Version: 2.12.0
Distribution: rpm
Architecture: arm64
Platform: linux

Please check the logs: https://build.ci.opensearch.org/job/integ-test/7722/display/redirect

* Test-report manifest:*
- https://ci.opensearch.org/ci/dbc/integ-test/2.12.0/9362/linux/arm64/rpm/test-results/7722/integ-test/test-report.yml

Note: Steps to reproduce, additional logs and other files can be found within the above test-report manifest.
Instructions of this test-report manifest can be found here.

[opensearch-ci-bot]

The integration test failed at distribution level for component sql
Version: 2.12.0
Distribution: rpm
Architecture: x64
Platform: linux

Please check the logs: https://build.ci.opensearch.org/job/integ-test/7726/display/redirect

* Test-report manifest:*
- https://ci.opensearch.org/ci/dbc/integ-test/2.12.0/9363/linux/x64/rpm/test-results/7726/integ-test/test-report.yml

Note: Steps to reproduce, additional logs and other files can be found within the above test-report manifest.
Instructions of this test-report manifest can be found here.

[opensearch-ci-bot]

The integration test failed at distribution level for component sql
Version: 2.12.0
Distribution: deb
Architecture: arm64
Platform: linux

Please check the logs: https://build.ci.opensearch.org/job/integ-test/7747/display/redirect

* Test-report manifest:*
- https://ci.opensearch.org/ci/dbc/integ-test/2.12.0/9369/linux/arm64/deb/test-results/7747/integ-test/test-report.yml

Note: Steps to reproduce, additional logs and other files can be found within the above test-report manifest.
Instructions of this test-report manifest can be found here.

[opensearch-ci-bot]

The integration test failed at distribution level for component sql
Version: 2.12.0
Distribution: zip
Architecture: x64
Platform: windows

Please check the logs: https://build.ci.opensearch.org/job/integ-test/7770/display/redirect

* Test-report manifest:*
- https://ci.opensearch.org/ci/dbc/integ-test/2.12.0/9377/windows/x64/zip/test-results/7770/integ-test/test-report.yml

Note: Steps to reproduce, additional logs and other files can be found within the above test-report manifest.
Instructions of this test-report manifest can be found here.

[opensearch-ci-bot]

The integration test failed at distribution level for component sql
Version: 2.12.0
Distribution: tar
Architecture: arm64
Platform: linux

Please check the logs: https://build.ci.opensearch.org/job/integ-test/7819/display/redirect

* Test-report manifest:*
- https://ci.opensearch.org/ci/dbc/integ-test/2.12.0/9394/linux/arm64/tar/test-results/7819/integ-test/test-report.yml

Note: Steps to reproduce, additional logs and other files can be found within the above test-report manifest.
Instructions of this test-report manifest can be found here.

[opensearch-ci-bot]

The integration test failed at distribution level for component sql
Version: 2.12.0
Distribution: tar
Architecture: x64
Platform: linux

Please check the logs: https://build.ci.opensearch.org/job/integ-test/7826/display/redirect

* Test-report manifest:*
- https://ci.opensearch.org/ci/dbc/integ-test/2.12.0/9397/linux/x64/tar/test-results/7826/integ-test/test-report.yml

Note: Steps to reproduce, additional logs and other files can be found within the above test-report manifest.
Instructions of this test-report manifest can be found here.

[opensearch-ci-bot]

The integration test failed at distribution level for component sql
Version: 2.12.0
Distribution: rpm
Architecture: x64
Platform: linux

Please check the logs: https://build.ci.opensearch.org/job/integ-test/7836/display/redirect

* Test-report manifest:*
- https://ci.opensearch.org/ci/dbc/integ-test/2.12.0/9396/linux/x64/rpm/test-results/7836/integ-test/test-report.yml

Note: Steps to reproduce, additional logs and other files can be found within the above test-report manifest.
Instructions of this test-report manifest can be found here.

[opensearch-ci-bot]

The integration test failed at distribution level for component sql
Version: 2.12.0
Distribution: deb
Architecture: arm64
Platform: linux

Please check the logs: https://build.ci.opensearch.org/job/integ-test/7837/display/redirect

* Test-report manifest:*
- https://ci.opensearch.org/ci/dbc/integ-test/2.12.0/9396/linux/arm64/deb/test-results/7837/integ-test/test-report.yml

Note: Steps to reproduce, additional logs and other files can be found within the above test-report manifest.
Instructions of this test-report manifest can be found here.

[opensearch-ci-bot]

The integration test failed at distribution level for component sql
Version: 2.12.0
Distribution: rpm
Architecture: arm64
Platform: linux

Please check the logs: https://build.ci.opensearch.org/job/integ-test/7835/display/redirect

* Test-report manifest:*
- https://ci.opensearch.org/ci/dbc/integ-test/2.12.0/9396/linux/arm64/rpm/test-results/7835/integ-test/test-report.yml

Note: Steps to reproduce, additional logs and other files can be found within the above test-report manifest.
Instructions of this test-report manifest can be found here.

[opensearch-ci-bot]

The integration test failed at distribution level for component sql
Version: 2.12.0
Distribution: zip
Architecture: x64
Platform: windows

Please check the logs: https://build.ci.opensearch.org/job/integ-test/7833/display/redirect

* Test-report manifest:*
- https://ci.opensearch.org/ci/dbc/integ-test/2.12.0/9396/windows/x64/zip/test-results/7833/integ-test/test-report.yml

Note: Steps to reproduce, additional logs and other files can be found within the above test-report manifest.
Instructions of this test-report manifest can be found here.

[noCharger]

@prudhvigodithi it seems not related to SQL plugin, do you know how to fix?

https://build.ci.opensearch.org/blue/organizations/jenkins/integ-test/detail/integ-test/7833/pipeline/98

[WS-CLEANUP] Deleting project workspace...

[WS-CLEANUP] Deferred wipeout is disabled by the job configuration...

ERROR: Cannot delete workspace :Unable to delete 'C:\Users\Administrator\jenkins\workspace\integ-test@3\scripts'. Tried 3 times (of a maximum of 3) waiting 0.1 sec between attempts.

Cannot delete workspace: Unable to delete 'C:\Users\Administrator\jenkins\workspace\integ-test@3\scripts'. Tried 3 times (of a maximum of 3) waiting 0.1 sec between attempts.

[opensearch-ci-bot]

The integration test failed at distribution level for component sql
Version: 2.12.0
Distribution: tar
Architecture: x64
Platform: linux

Please check the logs: https://build.ci.opensearch.org/job/integ-test/7839/display/redirect

* Test-report manifest:*
- https://ci.opensearch.org/ci/dbc/integ-test/2.12.0/9400/linux/x64/tar/test-results/7839/integ-test/test-report.yml

Note: Steps to reproduce, additional logs and other files can be found within the above test-report manifest.
Instructions of this test-report manifest can be found here.

[prudhvigodithi]

This is the exact error https://ci.opensearch.org/ci/dbc/integ-test/2.12.0/9400/linux/x64/tar/test-results/7839/integ-test/sql/without-security/local-cluster-logs/id-1/stdout.txt, looks to me like an error from sql plugin, @noCharger can you please confirm?

component_name: sql
run_id: 7839
test_config: without-security
test_result: FAIL
test_result_files:

• https://ci.opensearch.org/ci/dbc/integ-test/2.12.0/9400/linux/x64/tar/test-results/7839/integ-test/sql/without-security/stdout.txt
• https://ci.opensearch.org/ci/dbc/integ-test/2.12.0/9400/linux/x64/tar/test-results/7839/integ-test/sql/without-security/stderr.txt
• https://ci.opensearch.org/ci/dbc/integ-test/2.12.0/9400/linux/x64/tar/test-results/7839/integ-test/sql/without-security/local-cluster-logs/id-1/stdout.txt
• https://ci.opensearch.org/ci/dbc/integ-test/2.12.0/9400/linux/x64/tar/test-results/7839/integ-test/sql/without-security/local-cluster-logs/id-1/stderr.txt
• https://ci.opensearch.org/ci/dbc/integ-test/2.12.0/9400/linux/x64/tar/test-results/7839/integ-test/sql/without-security/local-cluster-logs/id-1/opensearch-service-logs/gc.log.00
• https://ci.opensearch.org/ci/dbc/integ-test/2.12.0/9400/linux/x64/tar/test-results/7839/integ-test/sql/without-security/local-cluster-logs/id-1/opensearch-service-logs/gc.log
• https://ci.opensearch.org/ci/dbc/integ-test/2.12.0/9400/linux/x64/tar/test-results/7839/integ-test/sql/without-security/local-cluster-logs/id-1/opensearch-service-logs/opensearchcluster1_deprecation.log
• https://ci.opensearch.org/ci/dbc/integ-test/2.12.0/9400/linux/x64/tar/test-results/7839/integ-test/sql/without-security/local-cluster-logs/id-1/opensearch-service-logs/opensearchcluster1_task_detailslog.json
• https://ci.opensearch.org/ci/dbc/integ-test/2.12.0/9400/linux/x64/tar/test-results/7839/integ-test/sql/without-security/local-cluster-logs/id-1/opensearch-service-logs/opensearchcluster1_index_search_slowlog.json
• https://ci.opensearch.org/ci/dbc/integ-test/2.12.0/9400/linux/x64/tar/test-results/7839/integ-test/sql/without-security/local-cluster-logs/id-1/opensearch-service-logs/opensearchcluster1.log
• https://ci.opensearch.org/ci/dbc/integ-test/2.12.0/9400/linux/x64/tar/test-results/7839/integ-test/sql/without-security/local-cluster-logs/id-1/opensearch-service-logs/opensearchcluster1_index_indexing_slowlog.json
• https://ci.opensearch.org/ci/dbc/integ-test/2.12.0/9400/linux/x64/tar/test-results/7839/integ-test/sql/without-security/local-cluster-logs/id-1/opensearch-service-logs/opensearchcluster1_server.json
• https://ci.opensearch.org/ci/dbc/integ-test/2.12.0/9400/linux/x64/tar/test-results/7839/integ-test/sql/without-security/local-cluster-logs/id-1/opensearch-service-logs/opensearchcluster1_deprecation.json
• https://ci.opensearch.org/ci/dbc/integ-test/2.12.0/9400/linux/x64/tar/test-results/7839/integ-test/sql/without-security/local-cluster-logs/id-1/opensearch-service-logs/opensearchcluster1_index_search_slowlog.log
• https://ci.opensearch.org/ci/dbc/integ-test/2.12.0/9400/linux/x64/tar/test-results/7839/integ-test/sql/without-security/local-cluster-logs/id-1/opensearch-service-logs/opensearchcluster1_index_indexing_slowlog.log
• https://ci.opensearch.org/ci/dbc/integ-test/2.12.0/9400/linux/x64/tar/test-results/7839/integ-test/sql/without-security/local-cluster-logs/id-1/opensearch-service-logs/opensearchcluster1_task_detailslog.log
  test_type: integ-test

[noCharger]

This is the exact error https://ci.opensearch.org/ci/dbc/integ-test/2.12.0/9400/linux/x64/tar/test-results/7839/integ-test/sql/without-security/local-cluster-logs/id-1/stdout.txt, looks to me like an error from sql plugin, @noCharger can you please confirm?

@prudhvigodithi I'm not sure where this link originated, but #2488 should address the problem in it. The problem I referred to, #2517 (comment), only failed on the action "Delete workspace when build is done," and all other CI tests succeeded.

[prudhvigodithi]

Thanks @noCharger , please close the issue if you think the tests are fixed.
I see SQL passing here: https://build.ci.opensearch.org/blue/organizations/jenkins/integ-test/detail/integ-test/7862/pipeline

[noCharger]

Thanks @prudhvigodithi, close it now.

[opensearch-ci-bot]

The integration test failed at distribution level for component sql
Version: 2.12.0
Distribution: rpm
Architecture: x64
Platform: linux

Please check the logs: https://build.ci.opensearch.org/job/integ-test/7905/display/redirect

* Test-report manifest:*
- https://ci.opensearch.org/ci/dbc/integ-test/2.12.0/9424/linux/x64/rpm/test-results/7905/integ-test/test-report.yml

Note: Steps to reproduce, additional logs and other files can be found within the above test-report manifest.
Instructions of this test-report manifest can be found here.

[prudhvigodithi]

Closing this issue as the latest Integration test build passed https://build.ci.opensearch.org/blue/organizations/jenkins/integ-test/detail/integ-test/7910/pipeline/108.
@bbarani