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

    • Type: Bug
    • Status: Stalled (View Workflow)
    • Priority: Critical
    • Resolution: Unresolved
    • Affects Version/s: 5.5, 10.1, 10.2, 10.3, 10.1.38, 10.4, 10.5, 10.6, 10.0
    • Fix Version/s: 10.3, 10.4, 10.5
    • Environment:
      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

          Issue Links

            Activity

              People

              Assignee:
              marko Marko Mäkelä
              Reporter:
              evertonkopec Everton Barbosa Kopec
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

                Dates

                Created:
                Updated: