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

Details

    Description

      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.

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated: