Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-15786

ERROR 1062 (23000) at line 365: Duplicate entry 'spider' for key 'PRIMARY'

Details

    Description

      Reinstalling the spider plugin after a MariaDB 10.2.13 - - > 10.2.14 upgrade fails with the following error;

      # apt-get install mariadb-plugin-spider
      Reading package lists... Done
      Building dependency tree
      Reading state information... Done
      The following NEW packages will be installed:
        mariadb-plugin-spider
      0 upgraded, 1 newly installed, 0 to remove and 80 not upgraded.
      Need to get 0 B/286 kB of archives.
      After this operation, 916 kB of additional disk space will be used.
      Selecting previously unselected package mariadb-plugin-spider.
      (Reading database ... 20688 files and directories currently installed.)
      Preparing to unpack .../mariadb-plugin-spider_10.2.14+maria~xenial_amd64.deb ...
      Unpacking mariadb-plugin-spider (10.2.14+maria~xenial) ...
      Setting up mariadb-plugin-spider (10.2.14+maria~xenial) ...
      ERROR 1062 (23000) at line 365: Duplicate entry 'spider' for key 'PRIMARY'
      

      Attachments

        Activity

          Dermot.Brereton Dermot Brereton created issue -
          elenst Elena Stepanova made changes -
          Field Original Value New Value
          Labels need_feedback
          elenst Elena Stepanova made changes -
          Labels need_feedback
          elenst Elena Stepanova made changes -
          Fix Version/s 10.2 [ 14601 ]
          Assignee Jacob Mathew [ jacob-mathew ]
          serg Sergei Golubchik made changes -
          Description Reinstalling the spider plugin after a MariaDB 10.2.13 - - > 10.2.14 upgrade fails with the following error;

          # apt-get install mariadb-plugin-spider
          Reading package lists... Done
          Building dependency tree
          Reading state information... Done
          The following NEW packages will be installed:
            mariadb-plugin-spider
          0 upgraded, 1 newly installed, 0 to remove and 80 not upgraded.
          Need to get 0 B/286 kB of archives.
          After this operation, 916 kB of additional disk space will be used.
          Selecting previously unselected package mariadb-plugin-spider.
          (Reading database ... 20688 files and directories currently installed.)
          Preparing to unpack .../mariadb-plugin-spider_10.2.14+maria~xenial_amd64.deb ...
          Unpacking mariadb-plugin-spider (10.2.14+maria~xenial) ...
          Setting up mariadb-plugin-spider (10.2.14+maria~xenial) ...
          ERROR 1062 (23000) at line 365: Duplicate entry 'spider' for key 'PRIMARY'
          Reinstalling the spider plugin after a MariaDB 10.2.13 - - > 10.2.14 upgrade fails with the following error;
          {noformat}
          # apt-get install mariadb-plugin-spider
          Reading package lists... Done
          Building dependency tree
          Reading state information... Done
          The following NEW packages will be installed:
            mariadb-plugin-spider
          0 upgraded, 1 newly installed, 0 to remove and 80 not upgraded.
          Need to get 0 B/286 kB of archives.
          After this operation, 916 kB of additional disk space will be used.
          Selecting previously unselected package mariadb-plugin-spider.
          (Reading database ... 20688 files and directories currently installed.)
          Preparing to unpack .../mariadb-plugin-spider_10.2.14+maria~xenial_amd64.deb ...
          Unpacking mariadb-plugin-spider (10.2.14+maria~xenial) ...
          Setting up mariadb-plugin-spider (10.2.14+maria~xenial) ...
          ERROR 1062 (23000) at line 365: Duplicate entry 'spider' for key 'PRIMARY'
          {noformat}
          elenst Elena Stepanova made changes -
          Status Open [ 1 ] Confirmed [ 10101 ]
          elenst Elena Stepanova made changes -
          Assignee Jacob Mathew [ jacob-mathew ] Otto Kekäläinen [ otto ]
          elenst Elena Stepanova made changes -
          Fix Version/s 10.3 [ 22126 ]
          serg Sergei Golubchik made changes -
          Assignee Otto Kekäläinen [ otto ] Jacob Mathew [ jacob-mathew ]
          jacob-mathew Jacob Mathew (Inactive) made changes -
          Status Confirmed [ 10101 ] In Progress [ 3 ]
          jacob-mathew Jacob Mathew (Inactive) made changes -
          Assignee Jacob Mathew [ jacob-mathew ] Kentoku [ kentoku ]
          Status In Progress [ 3 ] In Review [ 10002 ]
          Kentoku Kentoku Shiba (Inactive) made changes -
          Assignee Kentoku [ kentoku ] Jacob Mathew [ jacob-mathew ]
          Status In Review [ 10002 ] Stalled [ 10000 ]
          jacob-mathew Jacob Mathew (Inactive) made changes -
          Fix Version/s 10.2.17 [ 23111 ]
          Fix Version/s 10.3.9 [ 23114 ]
          Fix Version/s 10.2 [ 14601 ]
          Fix Version/s 10.3 [ 22126 ]
          Resolution Fixed [ 1 ]
          Status Stalled [ 10000 ] Closed [ 6 ]
          jacob-mathew Jacob Mathew (Inactive) made changes -
          Fix Version/s 10.4.0 [ 23115 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 86397 ] MariaDB v4 [ 154098 ]

          People

            jacob-mathew Jacob Mathew (Inactive)
            Dermot.Brereton Dermot Brereton
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.