Uploaded image for project: 'ONAP Operations Manager'
  1. ONAP Operations Manager
  2. OOM-2626

network-name-gen reports sql error

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Low Low
    • None
    • Guilin Release
    • None
    • Hide

      Commit https://gerrit.onap.org/r/c/oom/+/114569 introduced new image for network-name-gen component: onap/ccsdk-apps-ms-neng: 0.7.1 --> onap/ccsdk-apps-ms-neng:1.0.1.

      This causes network-name-gen pod init failure with error:

      Caused by: liquibase.exception.DatabaseException: (conn=3190) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(0,100), [Failed SQL: (1064) CREATE TABLE GENERATED_NAME (GENERATED_NAME_ID INTEGER PRIMARY KEY AUTO_INCREMENT(0,100),
      EXTERNAL_ID VARCHAR(500) NOT NULL COMMENT 'Key sent by SDNC',
      SEQUNCE_NUMBER INTEGER COMMENT 'Sequence number used for this name',
      SEQUENCE_NUMBER_ENC VARCHAR(100) COMMENT 'Alpha numeric equivalent of sequence_number column',
      ELEMENT_TYPE VARCHAR(100) COMMENT 'The type of network element vnf-name, vm-name etc',
      NAME VARCHAR(500) COMMENT 'Generated name',
      PREFIX VARCHAR(100) COMMENT 'The prefix for the name. (The part of the name before the sequence number.)',
      SUFFIX VARCHAR(100) COMMENT 'The suffix for the name. (The part of the name after the sequence number.)',
      IS_RELEASED CHAR(1) COMMENT 'Indicating if the entry is released/unassigned',
      CREATED_TIME DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL,
      CREATED_BY VARCHAR(50),
      LAST_UPDATED_TIME DATETIME,
      LAST_UPDATED_BY VARCHAR(50))]

       

      Show
      Commit https://gerrit.onap.org/r/c/oom/+/114569 introduced new image for network-name-gen component: onap/ccsdk-apps-ms-neng: 0.7.1 --> onap/ccsdk-apps-ms-neng:1.0.1. This causes network-name-gen pod init failure with error: Caused by: liquibase.exception.DatabaseException: (conn=3190) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(0,100), [Failed SQL: (1064) CREATE TABLE GENERATED_NAME (GENERATED_NAME_ID INTEGER PRIMARY KEY AUTO_INCREMENT(0,100), EXTERNAL_ID VARCHAR(500) NOT NULL COMMENT 'Key sent by SDNC', SEQUNCE_NUMBER INTEGER COMMENT 'Sequence number used for this name', SEQUENCE_NUMBER_ENC VARCHAR(100) COMMENT 'Alpha numeric equivalent of sequence_number column', ELEMENT_TYPE VARCHAR(100) COMMENT 'The type of network element vnf-name, vm-name etc', NAME VARCHAR(500) COMMENT 'Generated name', PREFIX VARCHAR(100) COMMENT 'The prefix for the name. (The part of the name before the sequence number.)', SUFFIX VARCHAR(100) COMMENT 'The suffix for the name. (The part of the name after the sequence number.)', IS_RELEASED CHAR(1) COMMENT 'Indicating if the entry is released/unassigned', CREATED_TIME DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, CREATED_BY VARCHAR(50), LAST_UPDATED_TIME DATETIME, LAST_UPDATED_BY VARCHAR(50))]  

      Seems it doesn't occur anymore.

            sdesbure sdesbure
            kosewski kosewski
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: