Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-9738

Documentation point on mysql db conversion script

    XMLWordPrintable

    Details

    • Type: Task
    • Status: CLOSED
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 2.4.0
    • Fix Version/s: 2.4.0
    • Labels:
      None
    • Environment:
      mysql linux

      Description

      Saw the following errors with the 012 tag, the rwiki messages being new I thought I'd reopen in case people feel they are a big problem:

      Might just need some kind of "if exists" on the rwiki index drops...?

      ERROR 1062 (23000) at line 621: Duplicate entry 'chat.delete.channel' for key 2
      ERROR 1062 (23000) at line 622: Duplicate entry 'chat.new.channel' for key 2
      ERROR 1062 (23000) at line 623: Duplicate entry 'chat.revise.channel' for key 2
      ERROR 1062 (23000) at line 628: Duplicate entry '8-6-124' for key 1
      ERROR 1062 (23000) at line 632: Duplicate entry '8-6-125' for key 1
      ERROR 1062 (23000) at line 636: Duplicate entry '8-6-126' for key 1
      ERROR 1062 (23000) at line 654: Duplicate entry '19-6-124' for key 1
      ERROR 1062 (23000) at line 658: Duplicate entry '19-6-125' for key 1
      ERROR 1062 (23000) at line 662: Duplicate entry '19-6-126' for key 1
      ERROR 1062 (23000) at line 671: Duplicate entry '9-5-124' for key 1
      ERROR 1062 (23000) at line 675: Duplicate entry '9-5-125' for key 1
      ERROR 1062 (23000) at line 679: Duplicate entry '9-5-126' for key 1
      ERROR 1091 (42000) at line 1069: Can't DROP 'irwikiproperties_name'; check that column/key exists
      ERROR 1091 (42000) at line 1070: Can't DROP 'irwikicurrentcontent_rwi'; check that column/key exists
      ERROR 1091 (42000) at line 1071: Can't DROP 'irwikihistorycontent_rwi'; check that column/key exists
      ERROR 1091 (42000) at line 1072: Can't DROP 'irwikipagepresence_sid'; check that column/key exists
      ERROR 1091 (42000) at line 1073: Can't DROP 'irwikihistory_name'; check that column/key exists
      ERROR 1091 (42000) at line 1074: Can't DROP 'irwikihistory_realm'; check that column/key exists
      ERROR 1091 (42000) at line 1075: Can't DROP 'irwikihistory_ref'; check that column/key exists
      ERROR 1091 (42000) at line 1076: Can't DROP 'irwikihistoryobj_rwid'; check that column/key exists
      ERROR 1091 (42000) at line 1077: Can't DROP 'irwikiobject_name'; check that column/key exists
      ERROR 1091 (42000) at line 1078: Can't DROP 'irwikiobject_realm'; check that column/key exists
      ERROR 1091 (42000) at line 1079: Can't DROP 'irwikiobject_ref'; check that column/key exists
      ERROR 1091 (42000) at line 1081: Can't DROP 'irwikipr_userid'; check that column/key exists
      ERROR 1091 (42000) at line 1082: Can't DROP 'irwikipm_sessionid'; check that column/key exists
      ERROR 1091 (42000) at line 1083: Can't DROP 'irwikipm_user'; check that column/key exists
      ERROR 1091 (42000) at line 1084: Can't DROP 'irwikipm_pagespace'; check that column/key exists
      ERROR 1091 (42000) at line 1085: Can't DROP 'irwikipm_pagename'; check that column/key exists
      ERROR 1091 (42000) at line 1086: Can't DROP 'irwikipt_user'; check that column/key exists
      ERROR 1091 (42000) at line 1087: Can't DROP 'irwikipt_pagespace'; check that column/key exists
      ERROR 1091 (42000) at line 1088: Can't DROP 'irwikipt_pavename'; check that column/key exists

      Daniel Parry [21-Apr-2007 16:11] Saw the following errors with the 012 tag, the rwiki messages being new I thought I'd reopen in case people feel they are a big problem: Might just need some kind of "if exists" on the rwiki index drops...? ERROR 1062 (23000) at line 621: Duplicate entry 'chat.delete.channel' for key 2 ERROR 1062 (23000) at line 622: Duplicate entry 'chat.new.channel' for key 2 ERROR 1062 (23000) at line 623: Duplicate entry 'chat.revise.channel' for key 2 ERROR 1062 (23000) at line 628: Duplicate entry '8-6-124' for key 1 ERROR 1062 (23000) at line 632: Duplicate entry '8-6-125' for key 1 ERROR 1062 (23000) at line 636: Duplicate entry '8-6-126' for key 1 ERROR 1062 (23000) at line 654: Duplicate entry '19-6-124' for key 1 ERROR 1062 (23000) at line 658: Duplicate entry '19-6-125' for key 1 ERROR 1062 (23000) at line 662: Duplicate entry '19-6-126' for key 1 ERROR 1062 (23000) at line 671: Duplicate entry '9-5-124' for key 1 ERROR 1062 (23000) at line 675: Duplicate entry '9-5-125' for key 1 ERROR 1062 (23000) at line 679: Duplicate entry '9-5-126' for key 1 ERROR 1091 (42000) at line 1069: Can't DROP 'irwikiproperties_name'; check that column/key exists ERROR 1091 (42000) at line 1070: Can't DROP 'irwikicurrentcontent_rwi'; check that column/key exists ERROR 1091 (42000) at line 1071: Can't DROP 'irwikihistorycontent_rwi'; check that column/key exists ERROR 1091 (42000) at line 1072: Can't DROP 'irwikipagepresence_sid'; check that column/key exists ERROR 1091 (42000) at line 1073: Can't DROP 'irwikihistory_name'; check that column/key exists ERROR 1091 (42000) at line 1074: Can't DROP 'irwikihistory_realm'; check that column/key exists ERROR 1091 (42000) at line 1075: Can't DROP 'irwikihistory_ref'; check that column/key exists ERROR 1091 (42000) at line 1076: Can't DROP 'irwikihistoryobj_rwid'; check that column/key exists ERROR 1091 (42000) at line 1077: Can't DROP 'irwikiobject_name'; check that column/key exists ERROR 1091 (42000) at line 1078: Can't DROP 'irwikiobject_realm'; check that column/key exists ERROR 1091 (42000) at line 1079: Can't DROP 'irwikiobject_ref'; check that column/key exists ERROR 1091 (42000) at line 1081: Can't DROP 'irwikipr_userid'; check that column/key exists ERROR 1091 (42000) at line 1082: Can't DROP 'irwikipm_sessionid'; check that column/key exists ERROR 1091 (42000) at line 1083: Can't DROP 'irwikipm_user'; check that column/key exists ERROR 1091 (42000) at line 1084: Can't DROP 'irwikipm_pagespace'; check that column/key exists ERROR 1091 (42000) at line 1085: Can't DROP 'irwikipm_pagename'; check that column/key exists ERROR 1091 (42000) at line 1086: Can't DROP 'irwikipt_user'; check that column/key exists ERROR 1091 (42000) at line 1087: Can't DROP 'irwikipt_pagespace'; check that column/key exists ERROR 1091 (42000) at line 1088: Can't DROP 'irwikipt_pavename'; check that column/key exists

      Andrew Poland [21-Apr-2007 16:58]
      Thanks Daniel. The Rwiki errors are harmless, we expect that most installations will not have those indexes. We will add 'if exists' to supress them. Thanks!
      [ Show ยป ]
      Andrew Poland [21-Apr-2007 16:58] Thanks Daniel. The Rwiki errors are harmless, we expect that most installations will not have those indexes. We will add 'if exists' to supress them. Thanks!

      Andrew Poland [21-Apr-2007 17:22]
      Apparently MySQL does not support DROP INDEX IF EXISTS. There is a feature request in their tracking system to add this functionality, but it is not there yet. We should note in the release documentation that these errors are harmless.

        Gliffy Diagrams

          Zeplin

            Attachments

              Issue Links

                Activity

                  People

                  Assignee:
                  clayf Clay Fenlason (Inactive)
                  Reporter:
                  daniel Daniel Parry (Inactive)
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  0 Start watching this issue

                    Dates

                    Created:
                    Updated:
                    Resolved:

                      Git Integration