Uploaded image for project: 'Jira Software Data Center'
  1. Jira Software Data Center
  2. JSWSERVER-19821

MS SQL related error while updating development summary panel

XMLWordPrintable

      Issue Summary

      When user triggers certain action with the following conditions:

      1. Bambo connected to a JIRA instance
      2. JIRA is using MS SQL database

      error will be thrown in JIRA's log when the build tries to update more than 2100 issues.

      Environment

      1. JIRA 7.7.2
      2. MS SQL database

      Steps to Reproduce

      1. Connect JIRA to Bamboo.
      2. Try to perform any action in Bamboo which will make JIRA update more than 2100 issues from development panel.

      Expected Results

      All the issues's development panel is updated.

      Actual Results

      The below exception is thrown in the log:

      2018-12-11 00:07:48,387 https-jsse-nio-6080-exec-238 ERROR anonymous 6x15598966x1 3c0e9q 127.0.0.1 /rest/dev-status/1.0/webhooks/update-summary [c.a.p.r.c.error.jersey.ThrowableExceptionMapper] Uncaught exception thrown by REST service: com.querydsl.core.QueryException: Caught SQLServerException for update "dbo"."AO_575BF5_PROVIDER_ISSUE"
          set "STALE_AFTER" = ? where "AO_575BF5_PROVIDER_ISSUE"."PROVIDER_SOURCE_ID" = ? and ("AO_575BF5_PROVIDER_ISSUE"."ISSUE_ID" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ...
      com.google.common.util.concurrent.UncheckedExecutionException: com.querydsl.core.QueryException: Caught SQLServerException for update "dbo"."AO_575BF5_PROVIDER_ISSUE"
      set "STALE_AFTER" = ? where "AO_575BF5_PROVIDER_ISSUE"."PROVIDER_SOURCE_ID" = ? and ("AO_575BF5_PROVIDER_ISSUE"."ISSUE_ID" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ...
      Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request.
      	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:258)
      	at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1535)
      	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:467)
      	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:409)
      	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7151)
      	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:219)
      	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:199)
      	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:356)
      	at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
      	at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
      	at com.querydsl.sql.dml.SQLUpdateClause.execute(SQLUpdateClause.java:191)
      	... 48 more
      

      Following stack trace will also be thrown from in Bamboo's log:

      2018-12-11 08:07:39,401 INFO [events.remote.ratelimit.threads:thread-1] [RemoteEventDispatcher] Failed to send events {"sourceId":"<applink id>","sourceUrl":"https://test.bamboo:8085","capabilities":["update-devtool-summary-request","atlassian-remote-event"],"issueKeys":["TEST-4081","TEST-4082","ETQC-6289","TEST-4083","ETQC-6298","TEST-4098","TEST-4099","TEST-4097","TEST-4095","TEST-4065","TEST-4069","TEST-4060","TEST-4078","TEST-4079","TEST-4076","TEST-4077","TEST-4071","TEST-4074","TEST-4072","TEST-3808","TEST-3806","TEST-3807","TEST-3800","TEST-3801","TEST-3805","TEST-2925","VIC-685","VIC-694","ETQC-1664","VIC-692","TEST-4009","TEST-4249","TEST-3153","TEST-3395","TEST-4001","TEST-4485","TEST-3394","TEST-4002","TEST-3397","TEST-4483","TEST-3396","TEST-4242","TEST-3157","TEST-3399","TEST-4005","TEST-4489","TEST-3156","TEST-3398","TEST-4006","TEST-4003","TEST-4487","TEST-4004","TEST-4246","TEST-3391","TEST-3390","TEST-3393","TEST-3150","TEST-3392","TEST-4480","TEST-4018","TEST-4019","TEST-4012","TEST-4254","TEST-4496","TEST-4013","TEST-4497","TEST-3166","TEST-4010","TEST-4494","TEST-4011","TEST-4495","TEST-3168","TEST-4258","TEST-3167","TEST-4017","TEST-4259","TEST-4014","TEST-4498","TEST-4257","TEST-4499","TEST-4250","TEST-4251","TEST-4490","TEST-4491","ETQC-1218","TEST-4229","TEST-4221","TEST-4463","TEST-3372","TEST-4464","TEST-3375","TEST-3374","TEST-3135","TEST-3377","TEST-3376","TEST-4468","TEST-3378","TEST-4460","TEST-3371","TEST-3370","TEST-3149","TEST-4232","TEST-4474","TEST-4475","VIC-1831","TEST-3386","TEST-4230","TEST-4472","TEST-3385","TEST-4231","TEST-4473","TEST-3388","TEST-3145","TEST-3387","TEST-4237","TEST-3147","TEST-3389","TEST-4235","TEST-4477","TEST-3380","TEST-4470","TEST-4471","TEST-3197","TEST-3196","TEST-4046","TEST-3199","TEST-4043","TEST-4285","TEST-3198","TEST-4044","TEST-4286","TEST-4047","TEST-4048","ETQC-4984","TEST-4280","TEST-3191","TEST-3193","TEST-4042","TEST-3194","ETQC-5845","TEST-4056","TEST-4296","TEST-4297","TEST-4291","TEST-4052","TEST-4294","TEST-4053","TEST-4295","TEST-4050","TEST-4292","TEST-4293","ETQC-1017","ETQC-5615","ETQC-4528","TEST-4029","TEST-4023","TEST-4265","TEST-4024","TEST-4021","TEST-3176","TEST-4022","TEST-4269","TEST-4028","TEST-4025","AGFCZSC-1436","TEST-4261","TEST-4020","ETQC-3430","TEST-4260","TEST-3186","TEST-4034","TEST-4276","TEST-3185","TEST-4277","TEST-4274","TEST-3187","TEST-4033","TEST-4275","TEST-3189","TEST-4279","TEST-3180","TEST-4272","TEST-4270","TEST-4271","ETQC-3337","TEST-4405","TEST-4648","TEST-3317","TEST-3556","TEST-3798","TEST-4403","TEST-3316","TEST-3799","TEST-4409","TEST-4408","TEST-3550","AGFCZSC-1577","TEST-3551","TEST-4640","TEST-3796","TEST-4401","TEST-4643","TEST-3555","TEST-3797","TEST-4402","TEST-4644","TEST-4641","TEST-3553","TEST-4416","CEBQC-7241","TEST-4414","TEST-3568","TEST-4415","TEST-4418","TEST-4419","TEST-3561","TEST-3562","TEST-3322","TEST-4412","TEST-3563","TEST-3564","TEST-4411","PORTGLF-830","TEST-3536","TEST-4625","TEST-3537","TEST-3779","TEST-3534","TEST-3776","TEST-4623","TEST-3777","TEST-4624","TEST-3539","TEST-3771","TEST-3532","ETQC-1171","TEST-3533","TEST-3775","TEST-4622","TEST-3530","TEST-3773","TEST-3303","TEST-4634","TEST-3546","TEST-3788","TEST-3781","TEST-3540","TEST-1","TEST-3780","TEST-3300","TEST-3543","TEST-2452","TEST-3544","TEST-3302","TEST-3541","TEST-3542","TEST-4631","TEST-110","ETQC-6408","TEST-3359","TEST-4207","TEST-4449","TEST-3358","TEST-4208","TEST-4689","TEST-4441","TEST-3595","TEST-4442","TEST-3353","TEST-3592","TEST-4681","TEST-3593","TEST-4440","ETQC-703","TEST-3598","TEST-4203","TEST-4445","TEST-4687","TEST-3354","TEST-3599","TEST-4204","TEST-4446","TEST-3596","TEST-4201","TEST-4443","TEST-3356","TEST-3597","TEST-4202","TEST-4444","ETQC-5314","ETQC-5315","TEST-3591","TEST-4680","PORTGLF-3034","TEST-4216","TEST-4458","TEST-4217","TEST-3362","TEST-4452","TEST-4694","TEST-3361","TEST-4450","TEST-4692","TEST-3363","TEST-4451","TEST-4693","TEST-3366","TEST-4214","TEST-4456","TEST-4457","TEST-4699","TEST-3126","TEST-3368","TEST-4696","TEST-3125","TEST-3367","TEST-4697","ETQC-5321","TEST-4690","ETQC-4474","TEST-4691","TEST-3360","TEST-3578","TEST-3338","TEST-3579","TEST-4426","PORTGLF-3268","TEST-4429","TEST-3572","TEST-4661","TEST-3570","TEST-3571","TEST-4660","TEST-3576","TEST-4665","TEST-3577","TEST-4424","TEST-4666","TEST-4421","TEST-4663","TEST-3575","TEST-4422","TEST-4664","TEST-3348","TEST-4438","TEST-4439","TEST-3108","TEST-4436","TEST-3107","TEST-4437","TEST-3340","TEST-3583","TEST-4672","TEST-3584","TEST-4431","TEST-3342","TEST-4670","TEST-3341","TEST-3582","TEST-4671","TEST-4434","TEST-3588","TEST-4435","TEST-4432","TEST-4433","TEST-4675","ORA-01400","ETQC-5344","TEST-3718","TEST-3719","ETQC-5119","TEST-3712","TEST-3954","TEST-3713","TEST-3955","TEST-3711","TEST-3953","TEST-3716","TEST-3958","TEST-3717","TEST-3959","TEST-3956","TEST-3715","TEST-3957","ETQC-5594","TEST-3950","ETQC-5590","TEST-3721","TEST-3963","TEST-3722","TEST-3964","TEST-3727","TEST-3728","TEST-3725","TEST-3968","TEST-3961","TEST-3720","TEST-2872","TEST-3938","TEST-3939","TEST-3936","TEST-3937","TEST-3934","TEST-3935","ETQC-5371","ETQC-6460","TEST-3707","TEST-3708","TEST-3701","TEST-3943","TEST-3944","TEST-3700","TEST-3705","TEST-3947","TEST-3706","TEST-3945","TEST-3704","ETQC-5382","ETQC-5149","TEST-4609","TEST-3514","TEST-3756","TEST-4603","TEST-3757","TEST-3512","TEST-3754","TEST-3996","TEST-3513","TEST-3755","TEST-3997","TEST-4602","TEST-3516","TEST-3758","TEST-4605","TEST-3759","TEST-4606","TEST-3990","ETQC-5393","TEST-3510","TEST-3752","TEST-3994","TEST-3511","TEST-3753","TEST-4600","TEST-3750","TEST-3992","TEST-3751","TEST-3993","TEST-3525","TEST-3526","TEST-4615","TEST-3765","TEST-4612","TEST-3529","TEST-4618","TEST-4619","TEST-3527","TEST-4616","TEST-3528","TEST-3760","ETQC-5165","TEST-4610","TEST-3734","TEST-3976","TEST-3977","TEST-3974","TEST-3733","TEST-3979","TEST-3730","TEST-3970","TEST-3509","TEST-3503","TEST-3745","TEST-3504","TEST-3501","TEST-3985","TEST-3502","TEST-3986","TEST-3507","TEST-3508","TEST-3747","TEST-3506","TEST-3980","TEST-3741","TEST-3983","TEST-3500","TEST-3981","TEST-3740","TEST-3982","ETQC-6278","TEST-4180","TEST-3092","TEST-3091","TEST-3093","TEST-4182","TEST-4183","ETQC-1742","TEST-4198","TEST-4191","TEST-4195","TEST-4193","TEST-4194","TEST-3919","TEST-3917","TEST-3910","TEST-3911","TEST-3914","TEST-3913","TEST-3929","TEST-3927","TEST-3928","ETQC-2616","TEST-3921","TEST-3922","TEST-3920","TEST-3925","TEST-3926","TEST-3924","ETQC-3952","TEST-3907","TEST-3908","TEST-3905","TEST-3906","CEBQC-30","TEST-3900","TEST-3904","TEST-3901","VIC-577","ETQC-1783","TEST-4129","TEST-3274","TEST-4123","TEST-3276","TEST-4120","TEST-4362","TEST-3275","TEST-4363","TEST-3278","TEST-4126","TEST-4368","TEST-3277","TEST-4369","TEST-4124","TEST-3279","TEST-4367","TEST-3270","TEST-4360","TEST-3271","TEST-3285","TEST-3284","TEST-4134","TEST-3045","TEST-3287","TEST-4373","TEST-3286","TEST-4137","TEST-4379","TEST-4138","TEST-4377","TEST-4371","TEST-3280","TEST-4130","TEST-3282","ETQC-4844","ETQC-4847","TEST-3259","TEST-4348","TEST-4107","ELBSD-1612","TEST-3252","TEST-3495","TEST-4100","TEST-4342","TEST-3251","TEST-3496","TEST-3254","TEST-3493","TEST-4340","TEST-3253","TEST-3494","TEST-3256","TEST-4346","TEST-4588","TEST-4347","TEST-4589","TEST-3258","TEST-3497","TEST-3257","TEST-3498","TEST-3492","TEST-3250","SSPUP-100071","TEST-4119","TEST-4117","TEST-4359","TEST-3263","TEST-4111","TEST-4353","TEST-4112","TEST-4596","TEST-3265","TEST-4593","TEST-4110","TEST-4352","TEST-4594","TEST-3267","TEST-4115","TEST-4357","TEST-4599","TEST-3266","TEST-4116","TEST-4358","TEST-4355","TEST-4356","TEST-4598","TEST-4591","TEST-4590","TEST-4166","TEST-4165","TEST-4168","TEST-4169","ETQC-4863","TEST-4162","TEST-4163","TEST-4161","ETQC-4877","TEST-189","UTF-8","TEST-4177","TEST-4176","TEST-4170","TEST-4174","TEST-4171","PORTGLF-110","TEST-4144","TEST-4386","TEST-3295","TEST-4387","TEST-3297","TEST-4385","TEST-3299","TEST-4149","TEST-4146","TEST-4388","TEST-4389","TEST-3290","ETQC-5970","TEST-4140","TEST-4382","TEST-3291","TEST-4383","TEST-3294","TEST-4380","ETQC-1133","TEST-4381","TEST-4155","TEST-4397","TEST-4156","TEST-4398","TEST-4154","TEST-4396","TEST-4399","TEST-4158","TEST-4390","TEST-4151","TEST-4152","TEST-4394","TEST-4391","TEST-4150","TEST-4392","TEST-3437","TEST-3679","TEST-4526","TEST-3438","TEST-4527","TEST-3435","TEST-3436","TEST-4525","TEST-3439","TEST-4528","TEST-3671","TEST-3430","TEST-3670","TEST-3433","TEST-3676","TEST-4523","TEST-3431","TEST-4520","TEST-3432","TEST-4521","ETQC-1049","TEST-3205","TEST-3448","TEST-3449","TEST-3207","TEST-3446","TEST-3688","TEST-3206","TEST-3447","TEST-3689","TEST-3440","TEST-4530","TEST-3201","TEST-3200","TEST-3445","TEST-3687","TEST-2356","TEST-3442","TEST-3202","ETQC-2132","TEST-3415","TEST-3899","TEST-3658","TEST-4505","TEST-3897","TEST-3656","TEST-3898","TEST-3419","TEST-4508","TEST-3417","TEST-3659","TEST-4506","TEST-3418","TEST-4507","TEST-3891","TEST-3650","TEST-3890","ETQC-1051","TEST-3411","TEST-3653","TEST-3895","TEST-4500","TEST-3896","TEST-4501","TEST-3893","TEST-3652","ETQC-1055","ETQC-1054","ETQC-1053","TEST-3668","TEST-3427","TEST-3424","TEST-3666","TEST-3425","TEST-4517","TEST-3429","TEST-4518","ETQC-1062","TEST-3422","TEST-3664","TEST-4511","ETQC-1061","TEST-3423","TEST-3662","TEST-3421","TEST-4510","ETQC-4331","ETQC-5422","TEST-3238","TEST-4328","TEST-3479","TEST-4326","TEST-4568","TEST-3239","TEST-4569","TEST-3230","TEST-4321","TEST-3232","TEST-4560","TEST-3472","TEST-4561","TEST-3233","TEST-3475","TEST-4323","TEST-4565","TEST-3248","NPW-1513","TEST-4338","TEST-3241","TEST-3484","TEST-3485","TEST-3243","TEST-3482","TEST-3483","TEST-3245","TEST-3244","TEST-3489","TEST-4336","TEST-3486","TEST-3246","TEST-3480","TEST-3481","TEST-3216","TEST-3459","TEST-4306","TEST-4548","TEST-3215","TEST-4307","TEST-4549","TEST-3457","TEST-3699","TEST-3458","TEST-4305","TEST-4547","TEST-3451","TEST-4540","TEST-3452","TEST-3210","TEST-3450","TEST-2365","TEST-3212","TEST-3455","TEST-3456","TEST-3453","TEST-3695","TEST-4300","TEST-4542","TEST-3213","TEST-3696","TEST-4543","ETQC-6304","ETQC-6318","TEST-3227","TEST-3229","TEST-3468","TEST-3228","TEST-3469","TEST-4319","TEST-3462","TEST-4550","TEST-3223","TEST-3467","TEST-4314","ETQC-5227","ETQC-6311","TEST-3839","TEST-3833","TEST-3834","TEST-3831","TEST-3832","TEST-3837","TEST-3835","TEST-1659","TEST-3830","ETQC-5474","TEST-3609","TEST-3602","TEST-3603","TEST-3600","TEST-3601","TEST-3606","TEST-3607","TEST-3846","TEST-3819","TEST-3817","TEST-3818","TEST-3815","TEST-3816","TEST-3814","ETQC-5018","ETQC-5015","ETQC-5498","TEST-3829","TEST-3822","TEST-3820","TEST-3826","TEST-3824","TEST-3825","VIC-2003","VIC-2004","TEST-3635","TEST-3878","TEST-3634","TEST-3876","TEST-3637","TEST-3879","TEST-3870","TEST-3873","TEST-3874","TEST-3871","TEST-3630","TEST-3872","TEST-3646","TEST-3888","TEST-3889","TEST-3402","TEST-3644","TEST-3403","TEST-3645","TEST-3887","TEST-3409","TEST-3406","TEST-3649","TEST-3880","TEST-3400","TEST-3642","TEST-3401","TEST-3643","TEST-3882","TEST-3641","TEST-3883","TEST-3855","TEST-4702","TEST-3614","TEST-3611","VIC-969","TEST-3612","TEST-3854","TEST-3617","TEST-3859","TEST-4706","TEST-3618","TEST-3615","TEST-4705","TEST-3851","TEST-3610","TEST-3624","TEST-3866","TEST-3625","TEST-3867","TEST-3864","TEST-3623","TEST-3865","TEST-3628","TEST-3626","TEST-3627","TEST-3869","VIC-970","TEST-3620","TEST-3862","TEST-3621","TEST-3863","TEST-3861"]} to https://s08983br.servers.kbc.be:6080/jira/rest/dev-status/1.0/webhooks/update-summary with error java.net.SocketTimeoutException: Read timed out
      

      Workaround

      When triggering action from Bamboo, limit issues which will be updated with the action. This will prevent JIRA from hitting the "2100 parameters" limit.

            Unassigned Unassigned
            vshanmugam Vicknesh Shanmugam (Inactive)
            Votes:
            2 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated: