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

Mariadb was crashed after bulk insert

    XMLWordPrintable

Details

    Description

      Hi Team,

      Mariadb was crashed after some delete insert operations on the server.Programmer use php code and console for executing scipts 2 times with 50002 rows (Offset + limit 50002 for every iteration).He was began from 0.I have attached all configs,log,scripts,php code too in ticket.KIndly please help and assist me.Please share recovery steps too.

      PHP version 7.4
      Storage Engine is Innodb
      Row format is compressed
      Version is 7.4 php.
      Mariadb version is 11.4.2-MariaDB, client 15.2 for Linux (x86_64) using EditLine wrapper.
      OS is : Operating System: CentOS Stream 8
      CPE OS Name: cpe:/o:centos:centos:8
      Kernel: Linux 4.18.0-553.6.1.el8.x86_64
      Architecture: x86-64

      TABLE_NAME TABLE_SIZE_in_MB
      translation_usa_1 597.99609375
      translation_usa 502.99609375

      DBNAME DB SIZE IN MB
      prologis2 1140355.58593750

      Attachments

        1. config.txt
          3 kB
        2. copy_translation_usa.php.txt
          2 kB
        3. delete_translation_usa.txt
          2 kB
        4. journactl log-1.txt
          18 kB
        5. main error.txt
          0.7 kB
        6. main error from journactl log-1.txt
          2 kB
        7. script-1.txt
          0.2 kB

        Activity

          People

            Unassigned Unassigned
            ilaha.aghayeva Ilaha Aghayeva
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.