Uploaded image for project: 'Sqoop'
  1. Sqoop
  2. SQOOP-2971

OraOop does not close connections properly

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.4.6, 1.4.7
    • Component/s: None
    • Labels:
      None

      Description

      When importing with OraOop for every mapper task two connections are created, and those connections are not closed until the end of the import process, thus Sqoop use twice of the necessary amount, and kinda leaks the expensive resources. This could cause problem when the number of the connections is limited on the DB server side, however the user would like to leverage from having more mappers (e.g. right now with 10 avail connections the user cannot use 10 mappers, but instead only 4).

      Please provide a fix for this issue either by sharing the connection, or closing the connections when they are not needed anymore.

        Attachments

        1. SQOOP-2971.patch
          2 kB
          Szabolcs Vasas
        2. SQOOP-2971.patch
          7 kB
          Szabolcs Vasas

          Issue Links

            Activity

              People

              • Assignee:
                vasas Szabolcs Vasas
                Reporter:
                maugli Attila Szabo
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: