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

Server crashed and impossible start it

    XMLWordPrintable

Details

    Description

      I have very very simple identical query with one WRERE which will return only one row result. After random time from 1 minute to few hours with same query will return nothing, but that row is in table. My PHP 7.4.xx PDO client will not throw any exception, no error, no warning, nothing. Just return 0 rowCount.
      Otherwise it works well and always return requested row.
      At the moment when this happen, I send my ping() command which is like "SELECT 1+1" and it will return 2 without problem.

      options:
      PDO::ATTR_PERSISTENT => false,
      PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
      PDO::ATTR_EMULATE_PREPARES => false,
      PDO::MYSQL_ATTR_FOUND_ROWS => true,

      queries after connections:
      SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci;
      SET CHARACTER SET utf8mb4;
      SET SESSION sql_mode = "NO_BACKSLASH_ESCAPES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION";
      SET collation_connection = utf8mb4_unicode_ci;
      SET collation_server = utf8mb4_unicode_ci;

      By me query is not soo important as the fact.
      CREATE TABLE IF NOT EXISTS `datas`
      (
      `id` varchar(32) NOT NULL,
      `access` int(10) unsigned DEFAULT NULL,
      `data` text NULL,
      PRIMARY KEY (`session_id`)
      ) ROW_FORMAT = DYNAMIC
      ENGINE = InnoDB
      DEFAULT CHARSET = utf8mb4
      COLLATE = utf8mb4_unicode_ci;

      I made all possible debugs which I can do but nothing found.
      Today I tried create test with some procedure which will select same row and after some correct calls my DB crashed and its impossible start it.

      My test with Win10 machine is everything OK.

      Attachments

        1. _session.log
          29 kB
        2. mysql_error.log
          94 kB
        3. mysql.JPG
          mysql.JPG
          24 kB

        Activity

          People

            Unassigned Unassigned
            standus stanley h
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.