dagent 8.7.80.355 Unable to commit message: disk error (80040116) => Mailbox temporarily unavailable



  • @fbartels After try to update with “kopano-dbadm usmp” I have the following issue:

    Mon Jan 14 17:54:24 2019: [notice ] usmp: converting "versions" to utf8mb4...
    Mon Jan 14 17:54:24 2019: [notice ] usmp: converting "objectproperty" to utf8mb4...
    Mon Jan 14 17:54:24 2019: [error  ] 0x55697c529f90: SQL Failed: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead, Query: "ALTER TABLE `objectproperty` MODIFY COLUMN `propname` varchar(185) CHARACTER SET utf8mb4 BINARY DEFAULT NULL"
    Mon Jan 14 17:54:24 2019: [error  ] KDatabase::I_Update() query failed: "All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead", query: ALTER TABLE `objectproperty` MODIFY COLUMN `propname` varchar(185) CHARACTER SET utf8mb4 BINARY DEFAULT NULL
    Mon Jan 14 17:54:24 2019: [error  ] dbadm: action failed: disk error (80000007)
    
    

    And no one can sign up anymore.


  • Kopano

    “Sign up” as in “create a new account” or do you mean “sign in” as in “log in to an existing account”?



  • @fbartels I mean all existing accounts



  • Did you restart kopano-server? I haven’t yet, had the same errors in log and everything ist (still) working.



  • I have restarted the kopano-server several times, unfortunately without success.



  • I make a test system with kopano-core 8.7.80.465.4206adbb5-0+56.1 and new mysql 5.7 DB.
    after create some users I start “kopano-dbadm usmp” and have the same error but I have no issues with login.

    If I use the DB from my production system and execute “kopano-cli --list-users” no users was found:

    User list for Default (1):
    User             Full Name            Homeserver
    ----------------------------------------------------------
    SYSTEM           SYSTEM               Kopano
    

    and all stores are orphan

    kopano-cli --list-orphans
    Stores without users:
    Store guid                       Username             Last login       Store size       Store type
    --------------------------------------------------------------------------------------------------------
    25EE6C4DBE9449709ADBD99A1A8CD6F5                      <unknown>        10.34 MB         private
    EE70C69EDD554758B99610A230328E0B                      <unknown>        0.00 MB          private
    0A09F0CD74D3407695912AB78A96BA14                      <unknown>        0.00 MB          private
    2C8151E0090341A79CD15CCEEACF5FA8                      <unknown>        204.33 MB        private
    3E24FE9A034C436C99DDDE74E59CF45B                      <unknown>        1.21 MB          private
    19A661641F044990AE1A3ACA8C7683C6                      <unknown>        0.05 MB          private
    B15B7158FA7F4A4C8452A917EF6E0EDC                      <unknown>        2.75 MB          private
    0415275BFC3848CCA3A2913E6D8C5307                      <unknown>        1768.48 MB       private
    CF1551436B054851A8BD7D34B05168C5                      <unknown>        0.02 MB          private
    4BDC5A4C216C468AA17C566452062E66                      <unknown>        4423.90 MB       private
    5B8F8A911A334F3781FA9BC06F1E0690                      <unknown>        343.77 MB        private
    827D1FB7BFC0416094F243E70150B0AB                      <unknown>        2141.51 MB       private
    Users without stores (0):
    User             Full Name            Homeserver
    ----------------------------------------------------------
    
    

    I found the issue.

    [kopano]> select * from users;
    +----+------------------+-------------+---------------------+---------+
    | id | externid         | objectclass | signature           | company |
    +----+------------------+-------------+---------------------+---------+
    |  1 | NULL             |      196610 |                     |       0 |
    |  2 | NULL             |       65537 |                     |       0 |
    | 13 | 0f|▒@ތ▒h%▒E}      |      196610 | 2011-07-10 16:54:46 |       0 |
    +----+------------------+-------------+---------------------+---------+
    3 rows in set (0.00 sec)
    

    The users table is damaged after execute kopano-dbadm usmp .

    Before this table looks like this:

    [kopano]> select * from users;
    +----+------------------+-------------+---------------------+---------+
    | id | externid         | objectclass | signature           | company |
    +----+------------------+-------------+---------------------+---------+
    |  1 | NULL             |      196610 |                     |       0 |
    |  2 | NULL             |       65537 |                     |       0 |
    |  9 | ▒yl\9nJj▒▒▒▒-rK▒       |       65537 | 2018-02-28 08:52:38 |       0 |
    | 10 | ▒▒▒▒J▒▒l$[▒▒;▒          |       65537 | 2018-02-28 08:52:31 |       0 |
    | 12 | E~▒▒?C▒▒▒Hʕ+Ky       |       65537 | 2018-03-09 11:21:53 |       0 |
    | 13 | 0f|▒@ތ▒h%▒E}      |      196610 | 2011-07-10 16:54:46 |       0 |
    | 14 | ~
            M▒▒JNJ▒l▒.8▒▒        |       65538 | 2011-07-14 14:06:06 |       0 |
    | 16 | ▒E_▒▒BËy8▒1Z▒       |       65538 | 2011-07-15 20:44:25 |       0 |
    | 44 | ▒^▒▒h B▒▒%▒▒r▒▒▒           |       65537 | 2011-07-18 21:32:45 |       0 |
    | 46 |6,M▒▒s%▒qo▒     |       65537 | 2012-11-29 18:59:40 |       0 |
    | 47 | ▒
    ▒K▒C▒▒,▒▒eOѥ         |       65537 | 2015-02-09 08:59:36 |       0 |
    | 48 | ▒▒Q▒(▒Os▒~▒Qn▒▒z         |       65537 | 2018-02-19 21:34:42 |       0 |
    | 49 |RZ▒`▒B▒▒▒>▒▒Y▒▒          |       65537 | 2015-05-31 23:24:55 |       0 |
    | 50 | ▒▒▒▒▒@B▒r|▒b▒           |       65537 | 2018-01-30 16:57:04 |       0 |
    | 53 | I▒]▒▒EZ▒
                   ▒ ▒t;       |       65537 | 2018-02-28 08:00:32 |       0 |
    +----+------------------+-------------+---------------------+---------+
    15 rows in set (0.00 sec)
    


  • I have had this happen to me.


  • Kopano



  • @avalon said in dagent 8.7.80.355 Unable to commit message: disk error (80040116) => Mailbox temporarily unavailable:

    @fbartels After try to update with “kopano-dbadm usmp” I have the following issue:

    Mon Jan 14 17:54:24 2019: [notice ] usmp: converting "versions" to utf8mb4...
    Mon Jan 14 17:54:24 2019: [notice ] usmp: converting "objectproperty" to utf8mb4...
    Mon Jan 14 17:54:24 2019: [error  ] 0x55697c529f90: SQL Failed: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead, Query: "ALTER TABLE `objectproperty` MODIFY COLUMN `propname` varchar(185) CHARACTER SET utf8mb4 BINARY DEFAULT NULL"
    Mon Jan 14 17:54:24 2019: [error  ] KDatabase::I_Update() query failed: "All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead", query: ALTER TABLE `objectproperty` MODIFY COLUMN `propname` varchar(185) CHARACTER SET utf8mb4 BINARY DEFAULT NULL
    Mon Jan 14 17:54:24 2019: [error  ] dbadm: action failed: disk error (80000007)
    
    

    And no one can sign up anymore.

    I also encountered this problem with dagent 8.7.80.355? How did you solve this? It seams that the

    DEFAULT NULL
    

    is the problem here. It should perhaps be

    DEFAULT ""
    

    Than I alse have the “Disk Error” from OP on another server which is running 8.7.80.307. Is it save to run kopano-dbadm usmp on that version or will I encounter the same DEFAULT NULL issue?


  • Kopano

    @s_wolff said in dagent 8.7.80.355 Unable to commit message: disk error (80040116) => Mailbox temporarily unavailable:

    How did you solve this?

    you have to upgrade to the latest version.


Log in to reply