Navigation

    Kopano
    • Register
    • Login
    • Search
    • Categories
    • Get Official Kopano Support
    • Recent
    Statement regarding the closure of the Kopano community forum and the end of the community edition

    Error with kopano-dbadm k-1216

    Kopano Groupware Core
    2
    2
    524
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • A Former User
      A Former User last edited by

      Hi,

      I run kopano-dbadm k-1216 on a 128 GB database. Unfortunately we see this errors:

      # kopano-dbadm k-1216
      dbadm: executing action "np-remove-highid"
      dbadm: executing action "np-repair-dups"
      dup: 4834 duplicates to repair
      dbadm: adding temporary helper index on properties
      Fri May 11 19:48:03 2018: [error  ] 0x17f7f08: SQL Failed: The table 'properties' is full, Query: "ALTER TABLE properties ADD INDEX tmptag (tag)"
      Fri May 11 19:48:03 2018: [error  ] KDatabase::I_Update() query failed: "The table 'properties' is full", query: ALTER TABLE properties ADD INDEX tmptag (tag)
      dbadm: adding temporary helper index on tproperties
      Fri May 11 19:48:54 2018: [error  ] 0x17f7f08: SQL Failed: The table 'tproperties' is full, Query: "ALTER TABLE tproperties ADD INDEX tmptag (tag)"
      Fri May 11 19:48:54 2018: [error  ] KDatabase::I_Update() query failed: "The table 'tproperties' is full", query: ALTER TABLE tproperties ADD INDEX tmptag (tag)
      dbadm: adding temporary helper index on mvproperties
      dbadm: adding temporary helper index on indexedproperties
      dbadm: adding temporary helper index on singleinstances
      dbadm: adding temporary helper index on lob
      dup: merging #3769 into #3768 in "properties"...
      

      Debian 8.10 with all patches installed, enough space on all volumes.

      Question, is it save to continue with “kopano-dbadm k-1216” or should we restore db from backup?

      Walter

      1 Reply Last reply Reply Quote 0
      • jengelh
        jengelh Banned last edited by

        The helper indices are completely optional; not having them is no harm, except that it takes more time (possibly a lot more time). However, Ctrl-C/termination during “merge” operations is something not yet supported as of 8.5.8.39.

        1 Reply Last reply Reply Quote 0
        • First post
          Last post