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

InnoDB: Failed to find tablespace for table

Details

    Description

      Aug 25 11:26:50 gpsdata-01 mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
      		 
      Aug 25 11:26:50 gpsdata-01 mysqld: 2016-08-25 11:26:50 140205837375424 [Note] /usr/sbin/mysqld (mysqld 10.1.13-MariaDB-1~trusty) starting as process 3816 ...
      		 
      Aug 25 11:26:50 gpsdata-01 mysqld: 2016-08-25 11:26:50 140205837375424 [Note] InnoDB: Using mutexes to ref count buffer pool pages
      		 
      Aug 25 11:26:50 gpsdata-01 mysqld: 2016-08-25 11:26:50 140205837375424 [Note] InnoDB: The InnoDB memory heap is disabled
      		 
      Aug 25 11:26:50 gpsdata-01 mysqld: 2016-08-25 11:26:50 140205837375424 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
      		 
      Aug 25 11:26:50 gpsdata-01 mysqld: 2016-08-25 11:26:50 140205837375424 [Note] InnoDB: Memory barrier is not used
      		 
      Aug 25 11:26:50 gpsdata-01 mysqld: 2016-08-25 11:26:50 140205837375424 [Note] InnoDB: Compressed tables use zlib 1.2.8
      		 
      Aug 25 11:26:50 gpsdata-01 mysqld: 2016-08-25 11:26:50 140205837375424 [Note] InnoDB: Using Linux native AIO
      		 
      Aug 25 11:26:50 gpsdata-01 mysqld: 2016-08-25 11:26:50 140205837375424 [Note] InnoDB: Using SSE crc32 instructions
      		 
      Aug 25 11:26:50 gpsdata-01 mysqld: 2016-08-25 11:26:50 140205837375424 [Note] InnoDB: Initializing buffer pool, size = 256.0M
      		 
      Aug 25 11:26:50 gpsdata-01 mysqld: 2016-08-25 11:26:50 140205837375424 [Note] InnoDB: Completed initialization of buffer pool
      		 
      Aug 25 11:26:50 gpsdata-01 mysqld: 2016-08-25 11:26:50 140205837375424 [Note] InnoDB: Highest supported file format is Barracuda.
      		 
      Aug 25 11:26:50 gpsdata-01 mysqld: InnoDB: Transaction 3748540 was in the XA prepared state.
      		 
      Aug 25 11:26:50 gpsdata-01 mysqld: 2016-08-25 11:26:50 140205837375424 [ERROR] InnoDB: Failed to find tablespace for table '"gps"."events"' in the cache. Attempting to load the tablespace with space id 72.
      		 
      Aug 25 11:26:50 gpsdata-01 mysqld: 2016-08-25 11:26:50 140205837375424 [ERROR] InnoDB: Failed to find tablespace for table '"gps"."positions"' in the cache. Attempting to load the tablespace with space id 56.
      		 
      Aug 25 11:26:50 gpsdata-01 mysqld: 2016-08-25 11:26:50 140205837375424 [ERROR] InnoDB: Failed to find tablespace for table '"gps"."user_device"' in the cache. Attempting to load the tablespace with space id 54.
      		 
      Aug 25 11:26:50 gpsdata-01 mysqld: 2016-08-25 11:26:50 140205837375424 [ERROR] InnoDB: Failed to find tablespace for table '"gps"."device_geofence"' in the cache. Attempting to load the tablespace with space id 83.
      		 
      Aug 25 11:26:50 gpsdata-01 mysqld: InnoDB: 1 transaction(s) which must be rolled back or cleaned up

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14717 RENAME TABLE in InnoDB is not crash-safe

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            elenst Elena Stepanova added a comment -

            There isn't much here to work with. What happened before this server session? Did you have a crash? Did you move your database from another location? Did you replace any files in the datadir? Did you do an upgrade?
            Please provide the error log from the previous server session.

            elenst Elena Stepanova added a comment - There isn't much here to work with. What happened before this server session? Did you have a crash? Did you move your database from another location? Did you replace any files in the datadir? Did you do an upgrade? Please provide the error log from the previous server session.
            m-menon Murali added a comment -

            hi,

            Sure. The error just cropped up without anyone touching a thing on the Server (Centos 7), or the Database. As a matter of fact it's a fresh install that's just few weeks old. I am sure no one's touched a thing cos I am the only person with access to this server. And I have set this up personally. No movement of database, not any replacement / addition in datadir. No upgrade as well. I sure can provide the log while in couple of hours. Cheers - M.M

            m-menon Murali added a comment - hi, Sure. The error just cropped up without anyone touching a thing on the Server (Centos 7), or the Database. As a matter of fact it's a fresh install that's just few weeks old. I am sure no one's touched a thing cos I am the only person with access to this server. And I have set this up personally. No movement of database, not any replacement / addition in datadir. No upgrade as well. I sure can provide the log while in couple of hours. Cheers - M.M
            elenst Elena Stepanova added a comment -

            Any luck with the log?
            If nobody touched (restarted) the server, it means it crashed, because the fragment that you pasted clearly indicates server startup.

            elenst Elena Stepanova added a comment - Any luck with the log? If nobody touched (restarted) the server, it means it crashed, because the fragment that you pasted clearly indicates server startup.
            elenst Elena Stepanova added a comment -

            Please comment to re-open the issue if you have more information.

            elenst Elena Stepanova added a comment - Please comment to re-open the issue if you have more information.
            marko Marko Mäkelä added a comment -

            If the server was previously killed and restarted during a RENAME TABLE or ALTER TABLE operation, MDEV-14717 might explain this.

            marko Marko Mäkelä added a comment - If the server was previously killed and restarted during a RENAME TABLE or ALTER TABLE operation, MDEV-14717 might explain this.

            People

              Unassigned Unassigned
              m-menon Murali
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.