Announcement

Collapse
No announcement yet.

KMail won't start after upgrade from 14.04 to 16.04

Collapse
This topic is closed.
X
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    KMail won't start after upgrade from 14.04 to 16.04

    After upgrade from 14.04 to 16.04, KMail won't give me access to my data.

    The problem with the deprecated innodb_additional_mempool variable has already been fixed.

    Now the problem is that the Akonadi server won't start, and the reason appears to be that my database was created with MySQL 5.5 or so, and now 16.04 runs with 5.7 or so.

    There's a mysql.err file with messages like

    2017-01-25T18:19:57.920135Z 0 [ERROR] Column count of performance_schema.events_waits_current is wrong. Expected 19, found 16. Created with MySQL 50538, now running 50717. Please use mysql_upgrade to fix this error.

    Perfectly willing to try this, but no idea where to find mysql_upgrade, let alone how to start it, let alone how to use it.

    Can anyone help me out with this ?

    #2
    See http://manpages.ubuntu.com/manpages/...upgrade.1.html
    Using Kubuntu Linux since March 23, 2007
    "It is a capital mistake to theorize before one has data." - Sherlock Holmes

    Comment


      #3
      Thank you. That page says "make sure the server is running". (consistent with the "cannot connect" message I get when I try mysql_upgrade.)

      How do I do that ? (I don't have a separate mysql. I always used the one that came with Akonadi. And akonadictl start won't work because it gets a query error upon some CREATE INDEX.)

      Comment


        #4
        What do you get when you execute akonadictl start in a konsole?
        Using Kubuntu Linux since March 23, 2007
        "It is a capital mistake to theorize before one has data." - Sherlock Holmes

        Comment


          #5
          Found mysql_install_db: "/usr/bin/mysql_install_db"
          Found mysqlcheck: "/usr/bin/mysqlcheck"
          akonadi.collectionattributetable OK
          akonadi.collectionmimetyperelation OK
          akonadi.collectionpimitemrelation OK
          akonadi.collectiontable OK
          akonadi.flagtable OK
          akonadi.mimetypetable OK
          akonadi.parttable OK
          akonadi.parttypetable OK
          akonadi.pimitemflagrelation OK
          akonadi.pimitemtable
          error : Table rebuild required. Please do "ALTER TABLE `pimitemtable` FORCE" or dump/reload to fix it!
          akonadi.pimitemtagrelation OK
          akonadi.relationtable OK
          akonadi.relationtypetable OK
          akonadi.resourcetable OK
          akonadi.schemaversiontable OK
          akonadi.tagattributetable OK
          akonadi.tagremoteidresourcerelationtable OK
          akonadi.tagtable OK
          akonadi.tagtypetable OK
          mysql.columns_priv OK
          mysql.db OK
          mysql.event
          error : Table upgrade required. Please do "REPAIR TABLE `event`" or dump/reload to fix it!
          mysql.func OK
          mysql.general_log OK
          mysql.help_category OK
          mysql.help_keyword OK
          mysql.help_relation OK
          mysql.help_topic OK
          mysql.host OK
          mysql.ndb_binlog_index OK
          mysql.plugin OK
          mysql.proc
          error : Table upgrade required. Please do "REPAIR TABLE `proc`" or dump/reload to fix it!
          mysql.procs_priv OK
          mysql.proxies_priv OK
          mysql.servers OK
          mysql.slow_log OK
          mysql.tables_priv OK
          mysql.time_zone OK
          mysql.time_zone_leap_second OK
          mysql.time_zone_name OK
          mysql.time_zone_transition OK
          mysql.time_zone_transition_type OK
          mysql.user OK


          Repairing tables
          mysql.event
          Note : TIME/TIMESTAMP/DATETIME columns of old format have been upgraded to the new format.
          Warning : Incorrect datetime value: '0000-00-00 00:00:00' for column 'modified' at row 1
          Error : Invalid default value for 'modified'
          status : Operation failed
          mysql.proc
          Note : TIME/TIMESTAMP/DATETIME columns of old format have been upgraded to the new format.
          Warning : Incorrect datetime value: '0000-00-00 00:00:00' for column 'modified' at row 1
          Error : Invalid default value for 'modified'
          status : Operation failed
          Failed to ALTER TABLE `akonadi`.`pimitemtable` FORCE

          Error: Invalid default value for 'atime'

          ... some OK stuff here ...

          Updating indexes
          "CREATE INDEX PimItemTable_ridIndex ON PimItemTable (remoteId)"
          Updating index failed:
          Sql error: Invalid default value for 'atime' QMYSQL: Unable to execute query
          Query: CREATE INDEX PimItemTable_ridIndex ON PimItemTable (remoteId)

          ""
          Unable to initialize database.
          terminating service threads
          terminating connection threads
          stopping db process
          mysqladmin: The query to get the server's pid file failed, error: 'Table 'performance_schema.session_variables' doesn't exist'. Continuing.
          Application 'akonadiserver' exited normally...
          Last edited by Erwin Smout; Jan 26, 2017, 10:03 AM.

          Comment


            #6
            Solved thanks to Opensuse . https://forums.opensuse.org/showthre...Mageia-4-fails
            Rename the local akonadi db stuff to _bad, akonadi will re-initialize its db and KMail will start up.
            The search for a more reliable mail client now begins.

            Comment

            Working...
            X