[ https://issues.apache.org/jira/browse/PHOENIX-6267?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17250804#comment-17250804 ]
Hadoop QA commented on PHOENIX-6267: ------------------------------------ | (x) *{color:red}-1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || | {color:blue}0{color} | {color:blue} reexec {color} | {color:blue} 0m 37s{color} | {color:blue} Docker mode activated. {color} | || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} dupname {color} | {color:green} 0m 0s{color} | {color:green} No case conflicting files found. {color} | | {color:green}+1{color} | {color:green} hbaseanti {color} | {color:green} 0m 0s{color} | {color:green} Patch does not have any anti-patterns. {color} | | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | | {color:red}-1{color} | {color:red} test4tests {color} | {color:red} 0m 0s{color} | {color:red} The patch doesn't appear to include any new or modified tests. Please justify why no new tests are needed for this patch. Also please list what manual steps were performed to verify this patch. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 7m 45s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 0m 51s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 48s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 43s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} spotbugs {color} | {color:blue} 3m 0s{color} | {color:blue} phoenix-core in master has 972 extant spotbugs warnings. {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 7m 47s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 0m 52s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 0m 52s{color} | {color:green} the patch passed {color} | | {color:red}-1{color} | {color:red} checkstyle {color} | {color:red} 0m 53s{color} | {color:red} phoenix-core: The patch generated 8 new + 851 unchanged - 8 fixed = 859 total (was 859) {color} | | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 0s{color} | {color:green} The patch has no whitespace issues. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 45s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} spotbugs {color} | {color:green} 3m 10s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:red}-1{color} | {color:red} unit {color} | {color:red}107m 51s{color} | {color:red} phoenix-core in the patch failed. {color} | | {color:red}-1{color} | {color:red} asflicense {color} | {color:red} 0m 21s{color} | {color:red} The patch generated 1 ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black}135m 59s{color} | {color:black} {color} | \\ \\ || Reason || Tests || | Failed junit tests | phoenix.end2end.SystemTablesCreationOnConnectionIT | \\ \\ || Subsystem || Report/Notes || | Docker | ClientAPI=1.41 ServerAPI=1.41 base: https://ci-hadoop.apache.org/job/PreCommit-PHOENIX-Build/317/artifact/patchprocess/Dockerfile | | JIRA Issue | PHOENIX-6267 | | JIRA Patch URL | https://issues.apache.org/jira/secure/attachment/13017278/PHOENIX-6267.master.002.patch | | Optional Tests | dupname asflicense javac javadoc unit spotbugs hbaseanti checkstyle compile | | uname | Linux 3e300a1f62c0 4.15.0-112-generic #113-Ubuntu SMP Thu Jul 9 23:41:39 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux | | Build tool | maven | | Personality | dev/phoenix-personality.sh | | git revision | master / 6e019dd | | Default Java | Private Build-1.8.0_242-8u242-b08-0ubuntu3~16.04-b08 | | checkstyle | https://ci-hadoop.apache.org/job/PreCommit-PHOENIX-Build/317/artifact/patchprocess/diff-checkstyle-phoenix-core.txt | | unit | https://ci-hadoop.apache.org/job/PreCommit-PHOENIX-Build/317/artifact/patchprocess/patch-unit-phoenix-core.txt | | Test Results | https://ci-hadoop.apache.org/job/PreCommit-PHOENIX-Build/317/testReport/ | | asflicense | https://ci-hadoop.apache.org/job/PreCommit-PHOENIX-Build/317/artifact/patchprocess/patch-asflicense-problems.txt | | Max. process+thread count | 7096 (vs. ulimit of 30000) | | modules | C: phoenix-core U: phoenix-core | | Console output | https://ci-hadoop.apache.org/job/PreCommit-PHOENIX-Build/317/console | | versions | git=2.7.4 maven=3.3.9 spotbugs=4.1.3 | | Powered by | Apache Yetus 0.12.0 https://yetus.apache.org | This message was automatically generated. > View Index PK Fixed Width Field Truncation > ------------------------------------------- > > Key: PHOENIX-6267 > URL: https://issues.apache.org/jira/browse/PHOENIX-6267 > Project: Phoenix > Issue Type: Bug > Affects Versions: 5.0.0, 4.15.0, 4.14.3 > Reporter: Geoffrey Jacoby > Assignee: Gokcen Iskender > Priority: Blocker > Fix For: 5.1.0, 4.16.0 > > Attachments: PHOENIX-6267.4.x.001.patch, > PHOENIX-6267.master.001.patch, PHOENIX-6267.master.002.patch, > PHOENIX-6267.master.003.patch > > > 1. Create a table T > 2. Create a view V that extends the PK of T, where the last field of the > view's PK is a fixed width column C such as an INTEGER or BIGINT > 3. Create a view index VI on V that does NOT contain C in its index key > 4. Select C from the view with a query that runs against the view index > You will get the following error: > {code:java} > java.sql.SQLException: ERROR 201 (22000): Illegal data. Expected length of > at least 8 bytes, but had 7 > {code} > [~giskender], [~kadir], [~tkhurana] and I investigated. It appears the > problem comes from > IndexMaintainer.buildRowKey:707-713 > {code:java} > int length = stream.size(); > int minLength = length - maxTrailingNulls; > byte[] indexRowKey = stream.getBuffer(); > // Remove trailing nulls > while (length > minLength && indexRowKey[length-1] == > QueryConstants.SEPARATOR_BYTE) { > length--; > } > {code} > The logic to remove trailing separator bytes shouldn't run if the end of the > index key (i.e the end of the base PK) is a fixed width column. Otherwise, > we'll truncate whenever the last byte of the fixed width field happens to be > \x00 > > This only happens for view indexes (mutitenant or not) -- This message was sent by Atlassian Jira (v8.3.4#803005)