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

Unable to find a record to delete-mark just after upgrading from 10.2.4 to 10.2.5

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Duplicate
    • Affects Version/s: 10.2.5
    • Fix Version/s: N/A
    • Labels:
      None
    • Environment:
      Debian Jessie

      Description

      Hi!

      Just after apt-upgrading from 10.2.4 to 10.2.5, I've got a warning in the log file :

      2017-04-06 22:57:16 125067273648000 [Note] Reading of all Master_info entries succeded
      2017-04-06 22:57:16 125067273648000 [Note] Added new Master_info '' to hash table
      2017-04-06 22:57:16 125067273648000 [Note] /usr/sbin/mysqld: ready for connections.
      Version: '10.2.5-MariaDB-10.2.5+maria~jessie'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution
      2017-04-06 22:57:17 125062776846080 [ERROR] InnoDB: Unable to find a record to delete-mark
      InnoDB: tuple DATA TUPLE: 2 fields;
       0: len 8; hex 0000000000053b79; asc       ;y;;
       1: len 29; hex 77707a5f736f6674697a792f77707a5f65777777696f5f696d61676573; asc wpz_softizy/wpz_ewwwio_images;;
       
      InnoDB: record PHYSICAL RECORD: n_fields 2; 1-byte offsets; info bits 0
       0: len 8; hex 0000000000053b76; asc       ;v;;
       1: len 23; hex 77707a5f736f6674697a792f77707a5f6f7074696f6e73; asc wpz_softizy/wpz_options;;
      2017-04-06 22:57:17 125062776846080 [ERROR] InnoDB: page [page id: space=0, page number=684] (122 records, index id 5).
      2017-04-06 22:57:17 125062776846080 [ERROR] InnoDB: Submit a detailed bug report to http://bugs.mysql.com
      

      The definitions of the tables:

      CREATE TABLE `wpz_ewwwio_images` (
        `id` int(14) unsigned NOT NULL AUTO_INCREMENT,
        `path` text DEFAULT NULL,
        `image_md5` varchar(55) DEFAULT NULL,
        `results` varchar(75) NOT NULL,
        `gallery` varchar(10) DEFAULT NULL,
        `image_size` int(10) unsigned DEFAULT NULL,
        `orig_size` int(10) unsigned DEFAULT NULL,
        `updates` int(5) unsigned DEFAULT NULL,
        `updated` timestamp NOT NULL DEFAULT '1971-01-01 00:00:00' ON UPDATE current_timestamp(),
        `trace` blob DEFAULT NULL,
        `attachment_id` bigint(20) unsigned DEFAULT NULL,
        `resize` varchar(75) DEFAULT NULL,
        `converted` text NOT NULL,
        `backup` varchar(100) DEFAULT NULL,
        `level` int(5) unsigned DEFAULT NULL,
        `pending` tinyint(1) NOT NULL DEFAULT 0,
        UNIQUE KEY `id` (`id`),
        KEY `path_image_size` (`path`(191),`image_size`),
        KEY `attachment_info` (`gallery`(3),`attachment_id`)
      ) ENGINE=InnoDB AUTO_INCREMENT=518 DEFAULT CHARSET=utf8mb4
       
      CREATE TABLE `wpz_options` (
        `option_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
        `option_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
        `option_value` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
        `autoload` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'yes',
        PRIMARY KEY (`option_id`),
        UNIQUE KEY `option_name` (`option_name`)
      ) ENGINE=InnoDB AUTO_INCREMENT=174329 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
      

      Let me know if you need more informations.

      BR,
      Jocelyn Fournier

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                marko Marko Mäkelä
                Reporter:
                joce jocelyn fournier
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: