Details
-
Bug
-
Resolution: Won't Fix
-
Low
-
44
-
Severity 3 - Minor
-
Description
NOTE: This bug report is for JIRA Cloud. Using JIRA Server? See the corresponding bug report.
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.
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.
Expected Results
No exception in the logs.
Actual Results
The following exception is thrown in the atlassian-jira.log file:
MySQL:
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>
PostgreSQL
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)
PostgreSQL (JIRA 7)
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)
Notes
Although the exception is written to the logs, the Activity Stream applies the global filter correctly.
Workaround
Important: This workaround might prevent troubleshooting real problems with the Activity Stream, since any errors will be suppressed.
Set the logging level for the package below to OFF:
- atlassian.streams.internal.LocalActivityProvider
Attachments
Issue Links
- is related to
-
JRASERVER-41617 Adding multiple users to username field in a Global Filter for Activity Streams throws 'parameter index out of range'
- Gathering Impact