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

InnoDB: Fatal: Trying to access page number 57 in space 182 space name zabbix/items.

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Incomplete
    • 10.1.38, 5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6
    • N/A
    • Server, Storage Engine - InnoDB
    • Debian release 9.9
      4 core: Version: Intel(R) Xeon(R) CPU E5-2660 0 @ 2.20GHz
      Storage:
      Size Used Avail Use% Mounted on
      484G 272G 190G 59% /

    Description

      Hi guys, I was trying to solve “outside tablespace bounds” MySQL error but I could not up the even the MySQL server.
      I got this message:
      Status: "InnoDB: Fatal: Trying to access page number 57 in space 182 space name zabbix/items, which is outside the tablespace bounds. Byte offset 0, len 16384 i/o ty...

      I tried to set innodb_force_recovery=1 and then up to 6 and but still got the same error.
      When I try to start mysql service I got the message:

      ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111 "Connection refused")

      But there is mysqld.sock in this folder.

      Could someone show me a light?

      Attachments

        1. Mysql_log.rar
          1.73 MB
          Everton Barbosa Kopec

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18194 Incremental prepare tries to access page which is out of tablespace bounds.

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13542 Crashing on a corrupted page is unhelpful

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            People

              marko Marko Mäkelä
              evertonkopec Everton Barbosa Kopec
              Votes:
              0 Vote for this issue
              Watchers:
              8 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.