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

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Duplicate
    • 10.2.5
    • N/A
    • None
    • 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

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

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.