Uploaded image for project: 'JS - JobScheduler'
  1. JS - JobScheduler
  2. JS-49

Create Table Command for Table SCHEDULER_CLUSTERS contains unsupported DB2 data types

    XMLWordPrintable

Details

    Description

      15:02:00.805 scheduler 0 1544.5B4 204.254MB ....[xc.insert 3, "executeQuery"]
      15:02:00.805 scheduler 0 1544.5B4 204.254MB ...

      {scheduler} [debug3] (Database) select count from SCHEDULER_CLUSTERS where 1=0 (sos::scheduler::database::Database::create_table_when_needed)
      15:02:00.805 scheduler 0 1544.5B4 204.254MB ...{scheduler}

      [debug3] (Database) [com.ibm.db2.jcc.a.SqlException] ["DB2ADMIN.SCHEDULER_CLUSTERS" is an undefined name.] [executeQuery] []
      15:02:00.805 scheduler 0 1544.5B4 204.254MB ...

      {scheduler} [WARN] (Database) [com.ibm.db2.jcc.a.SqlException] ["DB2ADMIN.SCHEDULER_CLUSTERS" is an undefined name.] [executeQuery] []
      15:02:00.805 scheduler 0 1544.5B4 204.254MB ...{scheduler}

      [info] (Database) SCHEDULER-909 Creating database table SCHEDULER_CLUSTERS
      15:02:00.805 scheduler 0 1544.5B4 204.254MB ...

      {scheduler} sos::scheduler::database::Transaction::execute COMMIT (sos::scheduler::database::Database::create_table_when_needed)
      15:02:00.805 scheduler 0 1544.5B4 204.254MB ...sos::Sos_database_session::execute_direct_single COMMIT
      15:02:00.805 scheduler 0 1544.5B4 204.254MB ...{scheduler}

      sos::scheduler::database::Transaction::execute CREATE TABLE SCHEDULER_CLUSTERS (`member_id` varchar(100) not null, `scheduler_id` varchar(100) not null, `precedence` integer, `last_heart_beat` integer, `next_heart_beat` integer, `active` boolean, `exclusive` boolean, `dead` boolean, `command` varchar(250), `http_url` varchar(100), `deactivating_member_id` varchar(100), `xml` clob, primary key( `member_id` )) (sos::scheduler::database::Database::create_table_when_needed)
      15:02:00.805 scheduler 0 1544.5B4 204.254MB ...jdbc: executeUpdate CREATE TABLE SCHEDULER_CLUSTERS ("MEMBER_ID" varchar(100) not null, "SCHEDULER_ID" varchar(100) not null, "PRECEDENCE" integer, "LAST_HEART_BEAT" integer, "NEXT_HEART_BEAT" integer, "ACTIVE" boolean, "EXCLUSIVE" boolean, "DEAD" boolean, "COMMAND" varchar(250), "HTTP_URL" varchar(100), "DEACTIVATING_MEMBER_ID" varchar(100), "XML" CLOB, primary key( "MEMBER_ID" ))Vm::static_vm=00D8A0E8 _debug=0
      15:02:00.836 scheduler 31 1544.5B4 204.254MB ...[xc.insert 1, "com.ibm.db2.jcc.a.SqlException"]
      15:02:00.836 scheduler 0 1544.5B4 204.254MB ...[xc.insert 2, "The BOOLEAN data type is currently only supported internally."]
      15:02:00.836 scheduler 0 1544.5B4 204.254MB ...[xc.insert 3, "executeUpdate"]
      15:02:00.852 scheduler 16 1544.5B4 204.254MB ...

      {scheduler} [none] (Database) CREATE TABLE SCHEDULER_CLUSTERS ("MEMBER_ID" varchar(100) not null, "SCHEDULER_ID" varchar(100) not null, "PRECEDENCE" integer, "LAST_HEART_BEAT" integer, "NEXT_HEART_BEAT" integer, "ACTIVE" boolean, "EXCLUSIVE" boolean, "DEAD" boolean, "COMMAND" varchar(250), "HTTP_URL" varchar(100), "DEACTIVATING_MEMBER_ID" varchar(100), "XML" CLOB, primary key( "MEMBER_ID" )) (sos::scheduler::database::Database::create_table_when_needed)
      15:02:00.852 scheduler 0 1544.5B4 204.254MB ...{scheduler}

      [none] (Database) [com.ibm.db2.jcc.a.SqlException] [The BOOLEAN data type is currently only supported internally.] [executeUpdate] []
      15:02:00.852 scheduler 0 1544.5B4 204.254MB ...[xc.append "sos::scheduler::database::Database::create_table_when_needed"]
      15:02:00.852 scheduler 0 1544.5B4 204.254MB ...[ERROR SCHEDULER-363 Error when creating SQL table SCHEDULER_CLUSTERS: [com.ibm.db2.jcc.a.SqlException] [The BOOLEAN data type is currently only supported internally.] [executeUpdate] [] / sos::scheduler::database::Database::create_table_when_needed]

      Attachments

        Activity

          People

            jz Joacim Zschimmer
            al Andreas Liebert (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: