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

Error on close of 'C:\xampp\mysql\data\aria_log_control' (Errcode: 9 "Bad file descriptor") (large import)

    XMLWordPrintable

Details

    Description

      from stackoverflow question:

      I noticed the 2nd time now that MySQL crashes/corrupts itself a while after doing a (big) database import from an SQL file which was created by exporting the database from the server in PHPMyAdmin

      2022-07-18  0:17:24 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
      2022-07-18  0:17:24 0 [Note] InnoDB: Uses event mutexes
      2022-07-18  0:17:24 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
      2022-07-18  0:17:24 0 [Note] InnoDB: Number of pools: 1
      2022-07-18  0:17:24 0 [Note] InnoDB: Using SSE2 crc32 instructions
      2022-07-18  0:17:24 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
      2022-07-18  0:17:24 0 [Note] InnoDB: Completed initialization of buffer pool
      2022-07-18  0:17:24 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
      2022-07-18  0:17:24 0 [Note] InnoDB: Creating shared tablespace for temporary tables
      2022-07-18  0:17:24 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
      2022-07-18  0:17:24 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
      2022-07-18  0:17:24 0 [Note] InnoDB: Waiting for purge to start
      2022-07-18  0:17:24 0 [Note] InnoDB: 10.4.24 started; log sequence number 56544792; transaction id 997
      2022-07-18  0:17:24 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
      2022-07-18  0:17:24 0 [Note] Plugin 'FEEDBACK' is disabled.
      2022-07-18  0:17:24 0 [Note] InnoDB: Buffer pool(s) load completed at 220718  0:17:24
      2022-07-18  0:17:24 0 [Note] Server socket created on IP: '::'.
      

      Event log

      The description for Event ID 100 from source MariaDB cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
       
      If the event originated on another computer, the display information had to be saved with the event.
       
      The following information was included with the event: 
       
      mysqld.exe: Error on close of 'C:\xampp\mysql\data\aria_log_control' (Errcode: 9 "Bad file descriptor")
       
      The system cannot find the file specified
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            danblack Daniel Black
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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