See <https://builds.apache.org/job/Phoenix-3.0-hadoop1/115/changes>
Changes: [jtaylor] PHOENIX-1028 Prevent declaration of non PK columns as NOT NULL (Ravi) ------------------------------------------ [...truncated 835 lines...] at org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:54) at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:236) at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:952) at org.apache.phoenix.query.BaseTest.createTestTable(BaseTest.java:624) at org.apache.phoenix.query.BaseTest.createTestTable(BaseTest.java:598) at org.apache.phoenix.end2end.ToCharFunctionIT.initTable(ToCharFunctionIT.java:83) testDecimalProjection(org.apache.phoenix.end2end.ToCharFunctionIT) Time elapsed: 0.063 sec <<< ERROR! java.sql.SQLException: ERROR 517 (42895): Invalid not null constraint on non primary key column columnName=COL_DATE at org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:310) at org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:133) at org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:948) at org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:422) at org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompiler.java:183) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:246) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:237) at org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:54) at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:236) at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:952) at org.apache.phoenix.query.BaseTest.createTestTable(BaseTest.java:624) at org.apache.phoenix.query.BaseTest.createTestTable(BaseTest.java:598) at org.apache.phoenix.end2end.ToCharFunctionIT.initTable(ToCharFunctionIT.java:83) testDecimalFilter(org.apache.phoenix.end2end.ToCharFunctionIT) Time elapsed: 0.069 sec <<< ERROR! java.sql.SQLException: ERROR 517 (42895): Invalid not null constraint on non primary key column columnName=COL_DATE at org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:310) at org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:133) at org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:948) at org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:422) at org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompiler.java:183) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:246) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:237) at org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:54) at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:236) at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:952) at org.apache.phoenix.query.BaseTest.createTestTable(BaseTest.java:624) at org.apache.phoenix.query.BaseTest.createTestTable(BaseTest.java:598) at org.apache.phoenix.end2end.ToCharFunctionIT.initTable(ToCharFunctionIT.java:83) testDateFilter(org.apache.phoenix.end2end.ToCharFunctionIT) Time elapsed: 0.095 sec <<< ERROR! java.sql.SQLException: ERROR 517 (42895): Invalid not null constraint on non primary key column columnName=COL_DATE at org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:310) at org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:133) at org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:948) at org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:422) at org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompiler.java:183) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:246) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:237) at org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:54) at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:236) at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:952) at org.apache.phoenix.query.BaseTest.createTestTable(BaseTest.java:624) at org.apache.phoenix.query.BaseTest.createTestTable(BaseTest.java:598) at org.apache.phoenix.end2end.ToCharFunctionIT.initTable(ToCharFunctionIT.java:83) testTimeProjection(org.apache.phoenix.end2end.ToCharFunctionIT) Time elapsed: 0.069 sec <<< ERROR! java.sql.SQLException: ERROR 517 (42895): Invalid not null constraint on non primary key column columnName=COL_DATE at org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:310) at org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:133) at org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:948) at org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:422) at org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompiler.java:183) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:246) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:237) at org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:54) at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:236) at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:952) at org.apache.phoenix.query.BaseTest.createTestTable(BaseTest.java:624) at org.apache.phoenix.query.BaseTest.createTestTable(BaseTest.java:598) at org.apache.phoenix.end2end.ToCharFunctionIT.initTable(ToCharFunctionIT.java:83) testTimeFilter(org.apache.phoenix.end2end.ToCharFunctionIT) Time elapsed: 0.061 sec <<< ERROR! java.sql.SQLException: ERROR 517 (42895): Invalid not null constraint on non primary key column columnName=COL_DATE at org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:310) at org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:133) at org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:948) at org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:422) at org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompiler.java:183) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:246) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:237) at org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:54) at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:236) at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:952) at org.apache.phoenix.query.BaseTest.createTestTable(BaseTest.java:624) at org.apache.phoenix.query.BaseTest.createTestTable(BaseTest.java:598) at org.apache.phoenix.end2end.ToCharFunctionIT.initTable(ToCharFunctionIT.java:83) testIntegerFilter(org.apache.phoenix.end2end.ToCharFunctionIT) Time elapsed: 0.069 sec <<< ERROR! java.sql.SQLException: ERROR 517 (42895): Invalid not null constraint on non primary key column columnName=COL_DATE at org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:310) at org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:133) at org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:948) at org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:422) at org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompiler.java:183) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:246) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:237) at org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:54) at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:236) at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:952) at org.apache.phoenix.query.BaseTest.createTestTable(BaseTest.java:624) at org.apache.phoenix.query.BaseTest.createTestTable(BaseTest.java:598) at org.apache.phoenix.end2end.ToCharFunctionIT.initTable(ToCharFunctionIT.java:83) testTimestampProjection(org.apache.phoenix.end2end.ToCharFunctionIT) Time elapsed: 0.065 sec <<< ERROR! java.sql.SQLException: ERROR 517 (42895): Invalid not null constraint on non primary key column columnName=COL_DATE at org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:310) at org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:133) at org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:948) at org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:422) at org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompiler.java:183) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:246) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:237) at org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:54) at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:236) at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:952) at org.apache.phoenix.query.BaseTest.createTestTable(BaseTest.java:624) at org.apache.phoenix.query.BaseTest.createTestTable(BaseTest.java:598) at org.apache.phoenix.end2end.ToCharFunctionIT.initTable(ToCharFunctionIT.java:83) Running org.apache.phoenix.end2end.DefaultParallelIteratorsRegionSplitterIT Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 7.531 sec - in org.apache.phoenix.end2end.DefaultParallelIteratorsRegionSplitterIT Running org.apache.phoenix.end2end.SequenceIT Tests run: 16, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 20.695 sec - in org.apache.phoenix.end2end.DerivedTableIT Running org.apache.phoenix.end2end.GroupByCaseIT Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 4.978 sec - in org.apache.phoenix.end2end.GroupByCaseIT Running org.apache.phoenix.end2end.MultiCfQueryExecIT Tests run: 12, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 42.46 sec - in org.apache.phoenix.end2end.UpsertValuesIT Running org.apache.phoenix.end2end.IsNullIT Tests run: 23, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 29.377 sec - in org.apache.phoenix.end2end.SequenceIT Running org.apache.phoenix.end2end.SpooledOrderByIT Tests run: 7, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 13.594 sec - in org.apache.phoenix.end2end.MultiCfQueryExecIT Running org.apache.phoenix.end2end.RowValueConstructorIT Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 10.471 sec - in org.apache.phoenix.end2end.IsNullIT Running org.apache.phoenix.end2end.PercentileIT Tests run: 3, Failures: 0, Errors: 0, Skipped: 1, Time elapsed: 7.255 sec - in org.apache.phoenix.end2end.SpooledOrderByIT Tests run: 10, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 49.459 sec - in org.apache.phoenix.end2end.CreateTableIT Tests run: 17, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 15.738 sec - in org.apache.phoenix.end2end.PercentileIT Tests run: 25, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 28.918 sec - in org.apache.phoenix.end2end.RowValueConstructorIT Results : Tests in error: ToNumberFunctionIT.initTable:93->BaseTest.createTestTable:598->BaseTest.createTestTable:624 ? SQL ToNumberFunctionIT.initTable:93->BaseTest.createTestTable:598->BaseTest.createTestTable:624 ? SQL ToNumberFunctionIT.initTable:93->BaseTest.createTestTable:598->BaseTest.createTestTable:624 ? SQL ToNumberFunctionIT.initTable:93->BaseTest.createTestTable:598->BaseTest.createTestTable:624 ? SQL ToNumberFunctionIT.initTable:93->BaseTest.createTestTable:598->BaseTest.createTestTable:624 ? SQL ToNumberFunctionIT.initTable:93->BaseTest.createTestTable:598->BaseTest.createTestTable:624 ? SQL ToNumberFunctionIT.initTable:93->BaseTest.createTestTable:598->BaseTest.createTestTable:624 ? SQL ToNumberFunctionIT.initTable:93->BaseTest.createTestTable:598->BaseTest.createTestTable:624 ? SQL ToNumberFunctionIT.initTable:93->BaseTest.createTestTable:598->BaseTest.createTestTable:624 ? SQL ToNumberFunctionIT.initTable:93->BaseTest.createTestTable:598->BaseTest.createTestTable:624 ? SQL ToNumberFunctionIT.initTable:93->BaseTest.createTestTable:598->BaseTest.createTestTable:624 ? SQL ToNumberFunctionIT.initTable:93->BaseTest.createTestTable:598->BaseTest.createTestTable:624 ? SQL ToNumberFunctionIT.initTable:93->BaseTest.createTestTable:598->BaseTest.createTestTable:624 ? SQL ToNumberFunctionIT.initTable:93->BaseTest.createTestTable:598->BaseTest.createTestTable:624 ? SQL ToNumberFunctionIT.initTable:93->BaseTest.createTestTable:598->BaseTest.createTestTable:624 ? SQL ToNumberFunctionIT.initTable:93->BaseTest.createTestTable:598->BaseTest.createTestTable:624 ? SQL ToNumberFunctionIT.initTable:93->BaseTest.createTestTable:598->BaseTest.createTestTable:624 ? SQL ToNumberFunctionIT.initTable:93->BaseTest.createTestTable:598->BaseTest.createTestTable:624 ? SQL ToCharFunctionIT.initTable:83->BaseTest.createTestTable:598->BaseTest.createTestTable:624 ? SQL ToCharFunctionIT.initTable:83->BaseTest.createTestTable:598->BaseTest.createTestTable:624 ? SQL ToCharFunctionIT.initTable:83->BaseTest.createTestTable:598->BaseTest.createTestTable:624 ? SQL ToCharFunctionIT.initTable:83->BaseTest.createTestTable:598->BaseTest.createTestTable:624 ? SQL ToCharFunctionIT.initTable:83->BaseTest.createTestTable:598->BaseTest.createTestTable:624 ? SQL ToCharFunctionIT.initTable:83->BaseTest.createTestTable:598->BaseTest.createTestTable:624 ? SQL ToCharFunctionIT.initTable:83->BaseTest.createTestTable:598->BaseTest.createTestTable:624 ? SQL ToCharFunctionIT.initTable:83->BaseTest.createTestTable:598->BaseTest.createTestTable:624 ? SQL ToCharFunctionIT.initTable:83->BaseTest.createTestTable:598->BaseTest.createTestTable:624 ? SQL ToCharFunctionIT.initTable:83->BaseTest.createTestTable:598->BaseTest.createTestTable:624 ? SQL Tests run: 1482, Failures: 0, Errors: 28, Skipped: 3 [INFO] [INFO] --- maven-failsafe-plugin:2.17:integration-test (NeedTheirOwnClusterTests) @ phoenix-core --- [INFO] Failsafe report directory: <https://builds.apache.org/job/Phoenix-3.0-hadoop1/ws/phoenix-core/target/failsafe-reports> [INFO] parallel='none', perCoreThreadCount=true, threadCount=0, useUnlimitedThreads=false, threadCountSuites=0, threadCountClasses=0, threadCountMethods=0, parallelOptimized=true ------------------------------------------------------- T E S T S ------------------------------------------------------- ------------------------------------------------------- T E S T S ------------------------------------------------------- Running org.apache.phoenix.hbase.index.covered.example.EndtoEndIndexingWithCompressionIT Running org.apache.phoenix.hbase.index.covered.example.FailWithoutRetriesIT Running org.apache.phoenix.hbase.index.covered.EndToEndCoveredColumnsIndexBuilderIT Running org.apache.phoenix.hbase.index.covered.example.EndToEndCoveredIndexingIT Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 8.43 sec - in org.apache.phoenix.hbase.index.covered.example.FailWithoutRetriesIT Running org.apache.phoenix.hbase.index.FailForUnsupportedHBaseVersionsIT Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 18.624 sec - in org.apache.phoenix.hbase.index.covered.EndToEndCoveredColumnsIndexBuilderIT Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 24.655 sec - in org.apache.phoenix.hbase.index.FailForUnsupportedHBaseVersionsIT Running org.apache.phoenix.end2end.index.MutableIndexFailureIT Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 15.376 sec - in org.apache.phoenix.end2end.index.MutableIndexFailureIT Running org.apache.phoenix.end2end.ContextClassloaderIT Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 13.135 sec - in org.apache.phoenix.end2end.ContextClassloaderIT Running org.apache.phoenix.mapreduce.CsvBulkLoadToolIT Tests run: 11, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 109.545 sec - in org.apache.phoenix.hbase.index.covered.example.EndToEndCoveredIndexingIT Tests run: 11, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 118.52 sec - in org.apache.phoenix.hbase.index.covered.example.EndtoEndIndexingWithCompressionIT Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 92.748 sec - in org.apache.phoenix.mapreduce.CsvBulkLoadToolIT Results : Tests run: 33, Failures: 0, Errors: 0, Skipped: 0 [INFO] [INFO] --- maven-failsafe-plugin:2.17:verify (HBaseManagedTimeTests) @ phoenix-core --- [INFO] Failsafe report directory: <https://builds.apache.org/job/Phoenix-3.0-hadoop1/ws/phoenix-core/target/failsafe-reports> [INFO] ------------------------------------------------------------------------ [INFO] Reactor Summary: [INFO] [INFO] Apache Phoenix .................................... SUCCESS [1.909s] [INFO] Phoenix Hadoop Compatibility ...................... SUCCESS [0.480s] [INFO] Phoenix Core ...................................... FAILURE [13:52.245s] [INFO] Phoenix - Flume ................................... SKIPPED [INFO] Phoenix - Pig ..................................... SKIPPED [INFO] Phoenix Hadoop1 Compatibility ..................... SKIPPED [INFO] Phoenix Assembly .................................. SKIPPED [INFO] ------------------------------------------------------------------------ [INFO] BUILD FAILURE [INFO] ------------------------------------------------------------------------ [INFO] Total time: 13:55.058s [INFO] Finished at: Mon Jun 09 05:00:36 UTC 2014 [INFO] Final Memory: 32M/585M [INFO] ------------------------------------------------------------------------ [ERROR] Failed to execute goal org.apache.maven.plugins:maven-failsafe-plugin:2.17:verify (HBaseManagedTimeTests) on project phoenix-core: There are test failures. [ERROR] [ERROR] Please refer to <https://builds.apache.org/job/Phoenix-3.0-hadoop1/ws/phoenix-core/target/failsafe-reports> for the individual test results. [ERROR] -> [Help 1] [ERROR] [ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch. [ERROR] Re-run Maven using the -X switch to enable full debug logging. [ERROR] [ERROR] For more information about the errors and possible solutions, please read the following articles: [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoFailureException [ERROR] [ERROR] After correcting the problems, you can resume the build with the command [ERROR] mvn <goals> -rf :phoenix-core Build step 'Invoke top-level Maven targets' marked build as failure Archiving artifacts Sending artifact delta relative to Phoenix | 3.0 | Hadoop1 #114 Archived 504 artifacts Archive block size is 32768 Received 1104 blocks and 141521147 bytes Compression is 20.4% Took 1 min 18 sec Updating PHOENIX-1028 Recording test results