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

Got error 128 when reading "Table Name" - when i tried to truncate a partition in a table

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.3.12, 10.3.21
    • Fix Version/s: None
    • Labels:
      None
    • Environment:
      Mariadb 10.3.12 32bit Windows 2008 R1

      Description

      When I was trying to truncate a partition i received the following error
      2019-05-28 4:47:50 24189 [ERROR] Got error 128 when reading table '.\datafactorydb\rjis_jqi_perf'

      I am on Windows 2008 R1, 32-bit

      the statement
      alter table rjis_jqi_perf truncate partition p20 just hangs; and then I get the above error 128 in the mariadb log file.

      I cancel the statement; and retry 5minutes later and still the same problem.

      I tried a third time and the statement worked.

      The statements I was running on a large table was (all worked first time except it hung on P20):-
      alter table rjis_jqi_perf truncate partition p1;
      alter table rjis_jqi_perf truncate partition p2;
      alter table rjis_jqi_perf truncate partition p3;
      alter table rjis_jqi_perf truncate partition p4;
      alter table rjis_jqi_perf truncate partition p5;
      alter table rjis_jqi_perf truncate partition p6;
      alter table rjis_jqi_perf truncate partition p7;
      alter table rjis_jqi_perf truncate partition p8;
      alter table rjis_jqi_perf truncate partition p9;
      alter table rjis_jqi_perf truncate partition p10;
      alter table rjis_jqi_perf truncate partition p11;
      alter table rjis_jqi_perf truncate partition p12;
      alter table rjis_jqi_perf truncate partition p13;
      alter table rjis_jqi_perf truncate partition p14;
      alter table rjis_jqi_perf truncate partition p15;
      alter table rjis_jqi_perf truncate partition p16;
      alter table rjis_jqi_perf truncate partition p17;
      alter table rjis_jqi_perf truncate partition p18;
      alter table rjis_jqi_perf truncate partition p19;
      alter table rjis_jqi_perf truncate partition p20;
      alter table rjis_jqi_perf truncate partition p21;
      alter table rjis_jqi_perf truncate partition p22;
      alter table rjis_jqi_perf truncate partition p23;
      alter table rjis_jqi_perf truncate partition p24;
      alter table rjis_jqi_perf truncate partition p25;
      alter table rjis_jqi_perf truncate partition p29;
      alter table rjis_jqi_perf truncate partition p30;
      alter table rjis_jqi_perf truncate partition p31;

      Not sure if this relates to the bug in MDEV-17877

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              slaterss Stuart Slater
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated: