Uploaded image for project: 'Data Management'
  1. Data Management
  2. DM-13526

Fixed a bug in the schema migration tool for worker databases

    Details

    • Type: Bug
    • Status: Done
    • Resolution: Done
    • Fix Version/s: None
    • Component/s: Qserv
    • Labels:
      None

      Description

      The original implementation of the schema migration tool deployed for worker side databases qservw_worker as per DM-13301 won't work for tables which have '_' in their base names. The original tool was designed and tested for the LSST-style table names:

      Object_<chunk>

      However, it won't work for tables like:

      Sart_More_<chunk>
      

      The first symbol '_' will confuse the stored procedure implemented in the original version of the tool.

      A goal of this ticket is to fix this problem by making the stored procedure to look for the last '_' when separating the base names of tables from the trailing chunk numbers.

        Attachments

          Container Issues

            Issue Links

              Activity

                People

                • Assignee:
                  gapon Igor Gaponenko
                  Reporter:
                  gapon Igor Gaponenko
                  Watchers:
                  Fritz Mueller, Igor Gaponenko
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Summary Panel