-
Bug
-
Resolution: Fixed
-
Low (View bug fix roadmap)
-
7.7.2, 9.13.1
-
7.07
-
9
-
Severity 3 - Minor
-
1
-
Issue Summary
When user triggers certain action with the following conditions:
- Bambo connected to a JIRA instance
- 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
- JIRA 7.7.2
- MS SQL database
Steps to Reproduce
- Connect JIRA to Bamboo.
- 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.
- is related to
-
JSWSERVER-21091 DVCS can generate queries with more than 2100 parameters that result in SQL Server errors
-
- Closed
-
- relates to
-
JSWSERVER-20834 DVCS plugin builds SQL query on AO_E8B6CC_CHANGESET_MAPPING that generates a large number of parameters to be passed to the JDBC driver
-
- Gathering Impact
-
Form Name |
---|
Hi!
Because I have met twice on production, during log investigation.
It is not only for the MS SQL, as I see, it is related to MySQL as well.
btw, I hope it can be workarounded by specified parameter for jira-config.properties