Uploaded image for project: 'mod-data-export-worker'
  1. mod-data-export-worker
  2. MODEXPW-28

Tenant deletion failed due to hsql error

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: P3
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 1.3.0
    • Labels:
      None
    • Template:
    • Sprint:
      Firebird Sprint 132, Firebird Sprint 133
    • Story Points:
      2
    • Development Team:
      Firebird
    • Release:
      Lotus R1 2022

      Description

      Try to delete a tenant with purge=true and got below error in the log. Looks like mod-data-export-worker does not even use PostgreSQL See the hardcoded hsql config

      | 1628171378520 | 13:49:38.519 [http-nio-8082-exec-3] INFO  org.folio.spring.controller.TenantController - Destroying tenant...                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | 1628171378696 | 13:49:38.684 [http-nio-8082-exec-3] ERROR org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/].[dispatcherServlet] - Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT EXISTS(SELECT 1 FROM pg_namespace WHERE nspname=?)]; nested exception is java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: PG_NAMESPACE in statement [SELECT EXISTS(SELECT 1 FROM pg_namespace WHERE nspname=?)]] with root cause                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | 1628171378696 | org.hsqldb.HsqlException: user lacks privilege or object not found: PG_NAMESPACE                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
      
      

        TestRail: Results

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                Charniak Siarhei Charniak
                Reporter:
                hji Hongwei Ji
                Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases