Uploaded image for project: 'WiredTiger'
  1. WiredTiger
  2. WT-1643

EBUSY from truncate()

    XMLWordPrintableJSON

Details

    • Task
    • Status: Closed
    • Resolution: Done
    • None
    • WT2.5.2
    • None

    Description

      Hi!

      Sometimes when converting DB from BDB to WiredTiger we get EBUSY when trying to truncate() index file.
      The conversion code basically looks like the following:

      =============================
      system("rm -rf \"" WT_HOME "\" && mkdir \"" WT_HOME "\"");

      wiredtiger_open(WT_HOME, NULL, "create,checkpoint=(wait=30)", &conn);

      conn->open_session(conn, NULL, NULL, &session);
      session->create(session, "table:main", "key_format=u,value_format=u,columns=(k,v)");
      session->create(session, "index:main:index", "columns=(v)");
      session->create(session, "index:main:index1", "columns=(v)");

      /_ open BDB table, create cursor _/

      while (/_ BDB cursor next() returns records _/) {
      WT_ITEM ki, vi;
      /_ fill ki and vi from BDB record _/

      cursor->set_key(cursor, &ki);
      cursor->set_value(cursor, &vi);
      cursor->insert(cursor);
      }

      cursor->close(cursor);

      session->truncate(session, "file:main_index.wti", NULL, NULL, NULL);

      ============================= END

      The last truncate() call fails sometimes with EBUSY (Device or resource busy)
      In cases where I saw this problem conversion takes quite a long time so probably it's somehow related to periodic checkpoints configured with 30 sec period.
      I was able to reproduce it only on both 2.5.0 and develop.

      Please advise!

      Attachments

        Issue Links

          is related to

          Task - A task that needs to be done. WT-1404 Test/format seeing EBUSY return in verify

          • Closed
          related to

          Task - A task that needs to be done. WT-2 What does metadata look like?

          • Closed

          Task - A task that needs to be done. WT-3 What file formats are required?

          • Closed

          Task - A task that needs to be done. WT-4 Flexible cursor traversals

          • Closed

          Task - A task that needs to be done. WT-5 How does pget work: is it necessary?

          • Closed

          Task - A task that needs to be done. WT-6 Complex schema example

          • Closed

          Task - A task that needs to be done. WT-7 Do we need the handle->err/errx methods?

          • Closed

          Task - A task that needs to be done. WT-8 Do we need table load, bulk-load and/or dump methods?

          • Closed

          Task - A task that needs to be done. WT-9 Does adding schema need to be transactional?

          • Closed

          Task - A task that needs to be done. WT-10 Basic "getting started" tutorial

          • Closed

          Task - A task that needs to be done. WT-11 placeholder #11

          • Closed

          Task - A task that needs to be done. WT-12 Write more examples

          • Closed

          Task - A task that needs to be done. WT-13 Define supported platforms

          • Closed

          Task - A task that needs to be done. WT-15 Automated build/test infrastructure

          • Closed

          Task - A task that needs to be done. WT-16 Test suite

          • Closed

          Task - A task that needs to be done. WT-17 Multithreaded tests

          • Closed

          Task - A task that needs to be done. WT-18 Coverage tests

          • Closed

          Task - A task that needs to be done. WT-19 Memory access / leak tests

          • Closed

          Task - A task that needs to be done. WT-20 API design

          • Closed

          Task - A task that needs to be done. WT-1767 If the session-level attempt to lock a handle gets EBUSY, fall back to the slow path

          • Closed

          Task - A task that needs to be done. WT-1782 Avoid EBUSY errors from truncate caused by checkpoints.

          • Closed

          Task - A task that needs to be done. WT-1598 Remove the schema, table locks

          • Major - P3 - Major loss of function.
          • Closed

          Activity

            People

              donald.anderson@mongodb.com Donald Anderson
              dmitri-shubin Dmitri Shubin
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: