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.

Sign up for GitHub

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

Jump to bottom

[Postgress] SQL Execution Errors - Missing Relations in Database #22381

Closed
NilukaSripalim opened this issue Jan 23, 2025 · 2 comments
Closed

[Postgress] SQL Execution Errors - Missing Relations in Database #22381

NilukaSripalim opened this issue Jan 23, 2025 · 2 comments
Assignees
@Osara-B
Labels
DB/postgres postgres DB related Issues will be tracked under this label. Fixed/7.1.0 Priority/Highest QA-Reported Issues reported by a QA Severity/Critical Team/Identity Server Core Type/Bug
Milestone
7.1.0-alpha

Comments

@NilukaSripalim
Copy link
Contributor

Description

Error occurred during SQL script execution

Reason:
SQL Error [42P01]: ERROR: relation "idn_saml2_service_provider_seq" does not exist
  Position: 97

Error occurred during SQL script execution

Reason:
SQL Error [42P01]: ERROR: relation "idn_saml2_sp_properties_seq" does not exist
  Position: 94

Error occurred during SQL script execution

Reason:
SQL Error [42P01]: ERROR: relation "idn_saml2_service_provider" does not exist

Error occurred during SQL query execution

Reason:
SQL Error [42P01]: ERROR: relation "idn_saml2_sp_properties" does not exist

Steps to Reproduce

  1. Get the product https://wso2.org/jenkins/job/products/job/product-is/5697/
  2. exratct teh zip
  3. and execute wso2is-7.1.0-m8-SNAPSHOT/dbscripts/identity/postgresql.sql

Version

v7.1.0-m7

Environment Details (with versions)

DB : postgresql 17.2
@NilukaSripalim NilukaSripalim added Type/Bug Priority/Highest Severity/Critical QA-Reported Issues reported by a QA DB/postgres postgres DB related Issues will be tracked under this label. Team/Identity Server Core labels Jan 23, 2025
@Osara-B Osara-B self-assigned this Jan 23, 2025
@Osara-B Osara-B moved this to In Progress in Identity Server 7.1.0 Jan 23, 2025
@Osara-B Osara-B added this to the 7.1.0-alpha milestone Jan 23, 2025
@Osara-B Osara-B mentioned this issue Jan 23, 2025
Merged
@Osara-B
Copy link
Contributor

Osara-B commented Jan 23, 2025

Fixed with

@Osara-B
Copy link
Contributor

Osara-B commented Jan 24, 2025

Verification

Screen.Recording.2025-01-23.at.17.12.27.mov
Screen.Recording.2025-01-23.at.17.13.49.mov

@github-project-automation github-project-automation bot moved this from In Progress to Done in Identity Server 7.1.0 Jan 26, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@Osara-B Osara-B

Labels
DB/postgres postgres DB related Issues will be tracked under this label. Fixed/7.1.0 Priority/Highest QA-Reported Issues reported by a QA Severity/Critical Team/Identity Server Core Type/Bug
Projects
Identity Server 7.1.0
Archived in project
Milestone
7.1.0-alpha
Development

No branches or pull requests
4 participants
@inthirakumaaran @nilasini @NilukaSripalim @Osara-B