org.postgresql.util.PSQLException: The column index is out of range: 65, number of columns: 64.

Atlassian JIRA | Julian Rahmadiputra [Atlassian] | 2 years ago
  1. 0

    h3. Summary When configuring Global Filters for Activity Streams, the username textbox is a free text field. Adding more than one user separated by commas causes a SQL Exception in the logs. h3. Steps to Reproduce # Add an Activity Stream to a Dashboard # Add a Global filter with the configuration below: #* {{Username}} {{is/is not}} \[*user1, user2*\] Obs: The usernames may be valid or invalid ones and the exception still happens. h3. Expected Results No exception in the logs. h3. Actual Results The following exception is thrown in the atlassian-jira.log file: *MySQL:* {noformat} 2015-01-14 15:58:09,739 StreamsCompletionService::thread-21 ERROR admin 958x1381x1 158u8c6 10.60.4.135 /plugins/servlet/streams [atlassian.streams.internal.LocalActivityProvider] Exception building feed com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library: Database: - name:MySQL - version:5.6.21-log - minor version:6 - major version:5 Driver: - name:MySQL Connector Java - version:mysql-connector-java-5.1.26 ( Revision: ${bzr.revision-id} ) java.sql.SQLException: Parameter index out of range (51 > number of parameters, which is 50). at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.find(EntityManagedActiveObjects.java:179) at com.atlassian.activeobjects.osgi.DelegatingActiveObjects.find(DelegatingActiveObjects.java:93) <+2> {noformat} *PostgreSQL* {noformat} 2015-10-21 15:59:30,806 StreamsCompletionService::thread-1993 ERROR admin 959x74842x1 17b6pej 192.168.10.137 /plugins/servlet/streams [atlassian.streams.internal.LocalActivityProvider] Exception building feed com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library: Database: - name:PostgreSQL - version:9.4.0 - minor version:4 - major version:9 Driver: - name:PostgreSQL Native Driver - version:PostgreSQL 9.0 JDBC4 (build 801) org.postgresql.util.PSQLException: The column index is out of range: 65, number of columns: 64. at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.find(EntityManagedActiveObjects.java:185) at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects.find(TenantAwareActiveObjects.java:335) <+2> (DelegatingMethodAccessorImpl.java:43) {noformat} *PostgreSQL (JIRA 7)* {noformat} 2015-10-21 16:00:59,187 StreamsCompletionService::thread-98 ERROR admin 960x4399x1 az6hzx 192.168.10.174 /plugins/servlet/streams [c.a.streams.internal.LocalActivityProvider] Exception building feed com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library: Database: - name:PostgreSQL - version:9.4.0 - minor version:4 - major version:9 Driver: - name:PostgreSQL Native Driver - version:PostgreSQL 9.0 JDBC4 (build 801) org.postgresql.util.PSQLException: The column index is out of range: 14, number of columns: 13. at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.find(EntityManagedActiveObjects.java:136) at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects.find(TenantAwareActiveObjects.java:291) {noformat} h3. Notes Although the exception is written to the logs, the Activity Stream applies the global filter correctly. h3.Workaround (!) *Important*: This workaround might prevent troubleshooting real problems with the Activity Stream, since *any errors will be suppressed*. [Set the logging level|https://confluence.atlassian.com/display/JIRAKB/How+to+set+logging+level+for+a+package+in+JIRA] for the package below to {{OFF}}: * {{atlassian.streams.internal.LocalActivityProvider}}

    Atlassian JIRA | 2 years ago | Julian Rahmadiputra [Atlassian]
    org.postgresql.util.PSQLException: The column index is out of range: 65, number of columns: 64.
  2. 0

    h3. Summary When configuring Global Filters for Activity Streams, the username textbox is a free text field. Adding more than one user separated by commas causes a SQL Exception in the logs. h3. Steps to Reproduce # Add an Activity Stream to a Dashboard # Add a Global filter with the configuration below: #* {{Username}} {{is/is not}} \[*user1, user2*\] Obs: The usernames may be valid or invalid ones and the exception still happens. h3. Expected Results No exception in the logs. h3. Actual Results The following exception is thrown in the atlassian-jira.log file: *MySQL:* {noformat} 2015-01-14 15:58:09,739 StreamsCompletionService::thread-21 ERROR admin 958x1381x1 158u8c6 10.60.4.135 /plugins/servlet/streams [atlassian.streams.internal.LocalActivityProvider] Exception building feed com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library: Database: - name:MySQL - version:5.6.21-log - minor version:6 - major version:5 Driver: - name:MySQL Connector Java - version:mysql-connector-java-5.1.26 ( Revision: ${bzr.revision-id} ) java.sql.SQLException: Parameter index out of range (51 > number of parameters, which is 50). at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.find(EntityManagedActiveObjects.java:179) at com.atlassian.activeobjects.osgi.DelegatingActiveObjects.find(DelegatingActiveObjects.java:93) <+2> {noformat} *PostgreSQL* {noformat} 2015-10-21 15:59:30,806 StreamsCompletionService::thread-1993 ERROR admin 959x74842x1 17b6pej 192.168.10.137 /plugins/servlet/streams [atlassian.streams.internal.LocalActivityProvider] Exception building feed com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library: Database: - name:PostgreSQL - version:9.4.0 - minor version:4 - major version:9 Driver: - name:PostgreSQL Native Driver - version:PostgreSQL 9.0 JDBC4 (build 801) org.postgresql.util.PSQLException: The column index is out of range: 65, number of columns: 64. at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.find(EntityManagedActiveObjects.java:185) at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects.find(TenantAwareActiveObjects.java:335) <+2> (DelegatingMethodAccessorImpl.java:43) {noformat} *PostgreSQL (JIRA 7)* {noformat} 2015-10-21 16:00:59,187 StreamsCompletionService::thread-98 ERROR admin 960x4399x1 az6hzx 192.168.10.174 /plugins/servlet/streams [c.a.streams.internal.LocalActivityProvider] Exception building feed com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library: Database: - name:PostgreSQL - version:9.4.0 - minor version:4 - major version:9 Driver: - name:PostgreSQL Native Driver - version:PostgreSQL 9.0 JDBC4 (build 801) org.postgresql.util.PSQLException: The column index is out of range: 14, number of columns: 13. at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.find(EntityManagedActiveObjects.java:136) at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects.find(TenantAwareActiveObjects.java:291) {noformat} h3. Notes Although the exception is written to the logs, the Activity Stream applies the global filter correctly. h3.Workaround (!) *Important*: This workaround might prevent troubleshooting real problems with the Activity Stream, since *any errors will be suppressed*. [Set the logging level|https://confluence.atlassian.com/display/JIRAKB/How+to+set+logging+level+for+a+package+in+JIRA] for the package below to {{OFF}}: * {{atlassian.streams.internal.LocalActivityProvider}}

    Atlassian JIRA | 2 years ago | Julian Rahmadiputra [Atlassian]
    org.postgresql.util.PSQLException: The column index is out of range: 65, number of columns: 64.
  3. 0

    Database access problem - Atlassian Answers

    atlassian.com | 1 year ago
    org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Database access problem - Atlassian Answers

    atlassian.com | 1 year ago
    org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command
  6. 0

    h3. Summary When configuring Global Filters for Activity Streams, the username textbox is a free text field. Adding more than one user separated by commas causes a SQL Exception in the logs. h3. Steps to Reproduce # Add an Activity Stream to a Dashboard # Add a Global filter with the configuration below: #* {{Username}} {{is/is not}} \[*user1, user2*\] Obs: The usernames may be valid or invalid ones and the exception still happens. h3. Expected Results No exception in the logs. h3. Actual Results The following exception is thrown in the atlassian-jira.log file: *MySQL:* {noformat} 2015-01-14 15:58:09,739 StreamsCompletionService::thread-21 ERROR admin 958x1381x1 158u8c6 10.60.4.135 /plugins/servlet/streams [atlassian.streams.internal.LocalActivityProvider] Exception building feed com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library: Database: - name:MySQL - version:5.6.21-log - minor version:6 - major version:5 Driver: - name:MySQL Connector Java - version:mysql-connector-java-5.1.26 ( Revision: ${bzr.revision-id} ) java.sql.SQLException: Parameter index out of range (51 > number of parameters, which is 50). at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.find(EntityManagedActiveObjects.java:179) at com.atlassian.activeobjects.osgi.DelegatingActiveObjects.find(DelegatingActiveObjects.java:93) <+2> {noformat} *PostgreSQL* {noformat} 2015-10-21 15:59:30,806 StreamsCompletionService::thread-1993 ERROR admin 959x74842x1 17b6pej 192.168.10.137 /plugins/servlet/streams [atlassian.streams.internal.LocalActivityProvider] Exception building feed com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library: Database: - name:PostgreSQL - version:9.4.0 - minor version:4 - major version:9 Driver: - name:PostgreSQL Native Driver - version:PostgreSQL 9.0 JDBC4 (build 801) org.postgresql.util.PSQLException: The column index is out of range: 65, number of columns: 64. at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.find(EntityManagedActiveObjects.java:185) at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects.find(TenantAwareActiveObjects.java:335) <+2> (DelegatingMethodAccessorImpl.java:43) {noformat} *PostgreSQL (JIRA 7)* {noformat} 2015-10-21 16:00:59,187 StreamsCompletionService::thread-98 ERROR admin 960x4399x1 az6hzx 192.168.10.174 /plugins/servlet/streams [c.a.streams.internal.LocalActivityProvider] Exception building feed com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library: Database: - name:PostgreSQL - version:9.4.0 - minor version:4 - major version:9 Driver: - name:PostgreSQL Native Driver - version:PostgreSQL 9.0 JDBC4 (build 801) org.postgresql.util.PSQLException: The column index is out of range: 14, number of columns: 13. at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.find(EntityManagedActiveObjects.java:136) at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects.find(TenantAwareActiveObjects.java:291) {noformat} h3. Notes Although the exception is written to the logs, the Activity Stream applies the global filter correctly. h3.Workaround (!) *Important*: This workaround might prevent troubleshooting real problems with the Activity Stream, since *any errors will be suppressed*. [Set the logging level|https://confluence.atlassian.com/display/JIRAKB/How+to+set+logging+level+for+a+package+in+JIRA] for the package below to {{OFF}}: * {{atlassian.streams.internal.LocalActivityProvider}}

    Atlassian JIRA | 2 years ago | Julian Rahmadiputra [Atlassian]
    org.postgresql.util.PSQLException: The column index is out of range: 14, number of columns: 13.

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.postgresql.util.PSQLException

      The column index is out of range: 65, number of columns: 64.

      at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.find()
    2. com.atlassian.activeobjects
      EntityManagedActiveObjects.find
      1. com.atlassian.activeobjects.internal.EntityManagedActiveObjects.find(EntityManagedActiveObjects.java:185)
      1 frame