com.mapd.tests.EagainConcurrencyTest Class Reference

Collaboration diagram for com.mapd.tests.EagainConcurrencyTest:

Public Member Functions
void	testCatalogConcurrency () throws Exception

Static Public Member Functions
static void	main (String[] args) throws Exception

Static Package Attributes
static final Logger	logger = LoggerFactory.getLogger(EagainConcurrencyTest.class)

Private Member Functions
void	run_test (HeavyDBTestClient dba, String db, String dbUser, String dbPassword, String prefix, int max) throws Exception
void	runTest (String db, String dbaUser, String dbaPassword, String dbUser, String dbPassword) throws Exception

Detailed Description

Definition at line 23 of file EagainConcurrencyTest.java.

Member Function Documentation

static void com.mapd.tests.EagainConcurrencyTest.main ( String[]  args ) throws Exception

inlinestatic

Definition at line 26 of file EagainConcurrencyTest.java.

                                                          {
    EagainConcurrencyTest test = new EagainConcurrencyTest();
    test.testCatalogConcurrency();
  }

void com.mapd.tests.EagainConcurrencyTest.run_test ( HeavyDBTestClient  dba, String  db, String  dbUser, String  dbPassword, String  prefix, int  max  ) throws Exception

inlineprivate

Definition at line 31 of file EagainConcurrencyTest.java.

Referenced by com.mapd.tests.EagainConcurrencyTest.runTest().

                                    {
    String tableName = "table_" + prefix + "_";
    String viewName = "view_" + prefix + "_";
    long tid = Thread.currentThread().getId();

    logger.info("[" + tid + "]"
            + "FIRST USER CONNECT");
    HeavyDBTestClient first_user =
            HeavyDBTestClient.getClient("localhost", 6274, db, dbUser, dbPassword);

    logger.info("[" + tid + "]"
            + "CREATE " + tableName);
    first_user.runSql("CREATE TABLE " + tableName + " (id integer);");

    logger.info("[" + tid + "]"
            + "CREATE VIEW " + viewName);
    first_user.runSql(
            "CREATE VIEW " + viewName + " AS (SELECT id * 2 FROM " + tableName + ");");

    logger.info("[" + tid + "]"
            + "FIRST USER DISCONNECT");
    first_user.disconnect();

    for (int i = 0; i < max; i++) {
      logger.info("[" + tid + "]"
              + "USER CONNECT");
      HeavyDBTestClient user =
              HeavyDBTestClient.getClient("localhost", 6274, db, dbUser, dbPassword);

      logger.info("[" + tid + "]"
              + "INSERT INTO " + tableName);
      user.runSql("INSERT INTO " + tableName + " VALUES (" + i + ");");

      user.get_status();
      user.get_server_status();
      user.get_hardware_info();

      logger.info("[" + tid + "]"
              + "SELECT FROM " + tableName);
      user.runSql("SELECT * FROM " + tableName + ";");

      user.get_memory("cpu");
      user.get_dashboards();
      //       user.get_tables_meta(); // TODO(adb): re-enable after fixing up catalog/db
      //       locking

      logger.info("[" + tid + "]"
              + "USER DISCONNECT");
      user.disconnect();
    }

    logger.info("[" + tid + "]"
            + "DROP " + viewName);
    dba.runSql("DROP VIEW " + viewName + ";");

    logger.info("[" + tid + "]"
            + "DROP " + tableName);
    dba.runSql("DROP TABLE " + tableName + ";");
  }

Here is the caller graph for this function:

void com.mapd.tests.EagainConcurrencyTest.runTest ( String  db, String  dbaUser, String  dbaPassword, String  dbUser, String  dbPassword  ) throws Exception

inlineprivate

Definition at line 96 of file EagainConcurrencyTest.java.

References run, and com.mapd.tests.EagainConcurrencyTest.run_test().

Referenced by com.mapd.tests.EagainConcurrencyTest.testCatalogConcurrency().

                           {
    int num_threads = 5;
    final int runs = 25;
    Exception exceptions[] = new Exception[num_threads];

    ArrayList<Thread> threads = new ArrayList<>();
    for (int i = 0; i < num_threads; i++) {
      logger.info("Starting " + i);
      final String prefix = "for_bob_" + i + "_";
      final int threadId = i;
      Thread t = new Thread(new Runnable() {
        @Override
        public void run() {
          try {
            HeavyDBTestClient dba = HeavyDBTestClient.getClient(
                    "localhost", 6274, db, dbaUser, dbaPassword);
            run_test(dba, db, dbUser, dbPassword, prefix, runs);
          } catch (Exception e) {
            logger.error("[" + Thread.currentThread().getId() + "]"
                            + "Caught Exception: " + e.getMessage(),
                    e);
            exceptions[threadId] = e;
          }
        }
      });
      t.start();
      threads.add(t);
    }

    for (Thread t : threads) {
      t.join();
    }

    for (Exception e : exceptions) {
      if (null != e) {
        logger.error("Exception: " + e.getMessage(), e);
        throw new Exception(e.getMessage(), e);
      }
    }
  }

Here is the call graph for this function:

Here is the caller graph for this function:

void com.mapd.tests.EagainConcurrencyTest.testCatalogConcurrency ( ) throws Exception

inline

Definition at line 139 of file EagainConcurrencyTest.java.

References com.mapd.tests.EagainConcurrencyTest.runTest().

                                                        {
    logger.info("testCatalogConcurrency()");

    HeavyDBTestClient su = HeavyDBTestClient.getClient(
            "localhost", 6274, "heavyai", "admin", "HyperInteractive");
    su.runSql("CREATE USER dba (password = 'password', is_super = 'true');");
    su.runSql("CREATE USER bob (password = 'password', is_super = 'false');");

    su.runSql("GRANT CREATE on DATABASE heavyai TO bob;");
    su.runSql("GRANT CREATE VIEW on DATABASE heavyai TO bob;");
    su.runSql("GRANT CREATE DASHBOARD on DATABASE heavyai TO bob;");

    su.runSql("GRANT DROP on DATABASE heavyai TO bob;");
    su.runSql("GRANT DROP VIEW on DATABASE heavyai TO bob;");
    su.runSql("GRANT DELETE DASHBOARD on DATABASE heavyai TO bob;");

    su.runSql("CREATE DATABASE db1;");

    su.runSql("GRANT CREATE on DATABASE db1 TO bob;");
    su.runSql("GRANT CREATE VIEW on DATABASE db1 TO bob;");
    su.runSql("GRANT CREATE DASHBOARD on DATABASE db1 TO bob;");

    su.runSql("GRANT DROP on DATABASE db1 TO bob;");
    su.runSql("GRANT DROP VIEW on DATABASE db1 TO bob;");
    su.runSql("GRANT DELETE DASHBOARD on DATABASE db1 TO bob;");

    su.runSql("GRANT ACCESS on database heavyai TO dba;");
    su.runSql("GRANT ACCESS on database heavyai TO bob;");
    su.runSql("GRANT ACCESS on database db1 TO dba;");
    su.runSql("GRANT ACCESS on database db1 TO bob;");

    runTest("db1", "admin", "HyperInteractive", "admin", "HyperInteractive");
    runTest("db1", "admin", "HyperInteractive", "dba", "password");
    runTest("db1", "admin", "HyperInteractive", "bob", "password");
    runTest("db1", "dba", "password", "admin", "HyperInteractive");
    runTest("db1", "dba", "password", "bob", "password");

    runTest("heavyai", "admin", "HyperInteractive", "admin", "HyperInteractive");
    runTest("heavyai", "admin", "HyperInteractive", "dba", "password");
    runTest("heavyai", "admin", "HyperInteractive", "bob", "password");
    runTest("heavyai", "dba", "password", "admin", "HyperInteractive");
    runTest("heavyai", "dba", "password", "bob", "password");

    su.runSql("DROP DATABASE db1;");
    su.runSql("DROP USER bob;");
    su.runSql("DROP USER dba;");

    logger.info("testCatalogConcurrency() done");
  }

Here is the call graph for this function:

Member Data Documentation

final Logger com.mapd.tests.EagainConcurrencyTest.logger = LoggerFactory.getLogger(EagainConcurrencyTest.class)

staticpackage

Definition at line 24 of file EagainConcurrencyTest.java.

---

The documentation for this class was generated from the following file:

• /home/jenkins-slave/workspace/core-os-doxygen/java/utility/src/main/java/com/mapd/tests/EagainConcurrencyTest.java