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

LP:908914 - akonadi & mariadb 5.5; xtradb seems to crash

    Details

    • Type: Bug
    • Status: Closed
    • Resolution: Cannot Reproduce
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      Description

      not all details yet, but see error log

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            maartenvanraes Maarten Vanraes added a comment -

            mysql.err.old
            LPexportBug908914_mysql.err.old

            Show
            maartenvanraes Maarten Vanraes added a comment - mysql.err.old LPexportBug908914_mysql.err.old
            Hide
            maartenvanraes Maarten Vanraes added a comment -

            Re: akonadi & mariadb 5.5; xtradb seems to crash

            Show
            maartenvanraes Maarten Vanraes added a comment - Re: akonadi & mariadb 5.5; xtradb seems to crash
            Hide
            maartenvanraes Maarten Vanraes added a comment -

            this one is from another user, it doesn't have the error itself, i'm waiting for that atm, but if you look through it you see that several times the'res no shutdown between starts, which means it just shut down hard, or something.

            but; with innodb there is no recovery procedure started, while with xtradb there is.

            i'll post the error when i get it
            mysql.err.old.txt
            LPexportBug908914_mysql.err.old.txt

            Show
            maartenvanraes Maarten Vanraes added a comment - this one is from another user, it doesn't have the error itself, i'm waiting for that atm, but if you look through it you see that several times the'res no shutdown between starts, which means it just shut down hard, or something. but; with innodb there is no recovery procedure started, while with xtradb there is. i'll post the error when i get it mysql.err.old.txt LPexportBug908914_mysql.err.old.txt
            Hide
            maartenvanraes Maarten Vanraes added a comment -

            Re: akonadi & mariadb 5.5; xtradb seems to crash
            this one is from another user, it doesn't have the error itself, i'm waiting for that atm, but if you look through it you see that several times the'res no shutdown between starts, which means it just shut down hard, or something.

            but; with innodb there is no recovery procedure started, while with xtradb there is.

            i'll post the error when i get it

            Show
            maartenvanraes Maarten Vanraes added a comment - Re: akonadi & mariadb 5.5; xtradb seems to crash this one is from another user, it doesn't have the error itself, i'm waiting for that atm, but if you look through it you see that several times the'res no shutdown between starts, which means it just shut down hard, or something. but; with innodb there is no recovery procedure started, while with xtradb there is. i'll post the error when i get it
            Hide
            elenst Elena Stepanova added a comment -

            Re: akonadi & mariadb 5.5; xtradb seems to crash
            From what I see, there is recovery each time after the server didn't shutdown normally, be it innodb or xtradb. Example:

            111106 12:44:07 InnoDB: 1.1.8 started; log sequence number 835797051
            111106 12:44:08 [Note] /usr/sbin/mysqld: ready for connections.
            Version: '5.5.15' socket: '/home/pnunn/.local/share/akonadi/socket-localhost.localdomain/mysql.socket' port: 0 Mageia - MySQL Community Edition (GPL)

            -> here the previous instance didn't end properly <-

            111106 21:52:14 InnoDB: The InnoDB memory heap is disabled
            111106 21:52:14 InnoDB: Mutexes and rw_locks use GCC atomic builtins
            111106 21:52:14 InnoDB: Compressed tables use zlib 1.2.5
            111106 21:52:14 InnoDB: Using Linux native AIO
            111106 21:52:16 InnoDB: Initializing buffer pool, size = 80.0M
            111106 21:52:16 InnoDB: Completed initialization of buffer pool
            111106 21:52:17 InnoDB: highest supported file format is Barracuda.
            InnoDB: The log sequence number in ibdata files does not match
            InnoDB: the log sequence number in the ib_logfiles!

            -> recovery <-

            111106 21:52:17 InnoDB: Database was not shut down normally!
            InnoDB: Starting crash recovery.
            InnoDB: Reading tablespace information from the .ibd files...
            InnoDB: Restoring possible half-written data pages from the doublewrite
            InnoDB: buffer...
            111106 21:52:23 InnoDB: Waiting for the background threads to start

            Show
            elenst Elena Stepanova added a comment - Re: akonadi & mariadb 5.5; xtradb seems to crash From what I see, there is recovery each time after the server didn't shutdown normally, be it innodb or xtradb. Example: 111106 12:44:07 InnoDB: 1.1.8 started; log sequence number 835797051 111106 12:44:08 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.15' socket: '/home/pnunn/.local/share/akonadi/socket-localhost.localdomain/mysql.socket' port: 0 Mageia - MySQL Community Edition (GPL) - > here the previous instance didn't end properly < - 111106 21:52:14 InnoDB: The InnoDB memory heap is disabled 111106 21:52:14 InnoDB: Mutexes and rw_locks use GCC atomic builtins 111106 21:52:14 InnoDB: Compressed tables use zlib 1.2.5 111106 21:52:14 InnoDB: Using Linux native AIO 111106 21:52:16 InnoDB: Initializing buffer pool, size = 80.0M 111106 21:52:16 InnoDB: Completed initialization of buffer pool 111106 21:52:17 InnoDB: highest supported file format is Barracuda. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! - > recovery < - 111106 21:52:17 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 111106 21:52:23 InnoDB: Waiting for the background threads to start
            Hide
            maartenvanraes Maarten Vanraes added a comment -

            this is finally the real log from the 2nd person (this time with the error)

            i see it stopping and sometimes not completing the shutdown, but likely killed off and then started up again

            then there's a weird thing, innodb log files gone??? ibdata looks like it being opened by something else?

            mysql.err.old.txt
            LPexportBug908914_mysql.err.old.txt

            Show
            maartenvanraes Maarten Vanraes added a comment - this is finally the real log from the 2nd person (this time with the error) i see it stopping and sometimes not completing the shutdown, but likely killed off and then started up again then there's a weird thing, innodb log files gone??? ibdata looks like it being opened by something else? mysql.err.old.txt LPexportBug908914_mysql.err.old.txt
            Hide
            maartenvanraes Maarten Vanraes added a comment -

            Re: akonadi & mariadb 5.5; xtradb seems to crash
            this is finally the real log from the 2nd person (this time with the error)

            i see it stopping and sometimes not completing the shutdown, but likely killed off and then started up again

            then there's a weird thing, innodb log files gone??? ibdata looks like it being opened by something else?

            Show
            maartenvanraes Maarten Vanraes added a comment - Re: akonadi & mariadb 5.5; xtradb seems to crash this is finally the real log from the 2nd person (this time with the error) i see it stopping and sometimes not completing the shutdown, but likely killed off and then started up again then there's a weird thing, innodb log files gone??? ibdata looks like it being opened by something else?
            Hide
            ratzpo Rasmus Johansson added a comment -

            Launchpad bug id: 908914

            Show
            ratzpo Rasmus Johansson added a comment - Launchpad bug id: 908914

              People

              • Assignee:
                Unassigned
                Reporter:
                maartenvanraes Maarten Vanraes
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: