[OP-247] Too long time spent on SQL when Sync request have changes Created: 10/Oct/16  Updated: 02/Nov/17  Resolved: 11/Oct/16

Status: Closed
Project: Opush
Component/s: None
Affects Version/s: None
Fix Version/s: 3.2.1

Type: Bug Priority: Normal
Reporter: Thomas HILAIRE Assignee: Thomas HILAIRE
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Relates
relates to OP-184 Rework the slow isServerIdSynced SQL ... Reopened
Rank: 7067

 Description   

Pre-conditions

  • Having a huge opush_sync_state table (like a real production syncing for a while)
  • Have the BREAKDOWN logger activated

Reproduction steps

  1. As usera with opush, sync

Current behavior

  1. NOK too much time spent on SQL (like 90%)
    16:49:34.163 [INFO ] {BREAKDOWN} [t620059/cSync/r620231/lschurr@linagora.com] REQUEST:23997 (SQL:20245, EMAIL:2266 (CASSANDRA:38, OTHER:6228
    ), CASSANDRA:11, OTHER:1475)

Expected behavior

  1. OK no much time spent

How to solve that

Some indexes are missing:

CREATE INDEX ON opush_sync_state (last_sync);
CREATE INDEX ON opush_sync_state (collection_id);
CREATE INDEX ON opush_sync_state (device_id);


 Comments   
Comment by Jenkins Continuous Integration Server [ 11/Oct/16 ]

UNSTABLE: Integrated in opush-master #268
OP-247 Add explanations in the upgrade doc (thilaire: b7b89dd6d6b90a5361660570e84269caac5782e7)

  • push-server/src/main/asciidoc/upgrades.adoc
  • push-server/src/main/asciidoc/opush.adoc
Comment by Thomas HILAIRE [ 11/Oct/16 ]

QA: reproduction steps
Impacts: none

Comment by Thomas HILAIRE [ 04/Nov/16 ]

Closed: in production since several weeks

Comment by yangping55 [ 04/Jul/17 ]

2017.7.5yangping
http://www.louisvuittonoutletus.us.com
http://www.edhardy-outlet.name
http://www.ralphlaurenoutlet.us.org
http://www.fitflopssaleclearanceofficial.us.com
http://www.nikefreerun.name
http://www.air-jordans.us.com
http://www.yeezyboost-350.us.com
http://www.longchamphandbags.us
http://www.louis-vuitton-handbags.us.org
http://www.airmax-95.us
http://www.saclongchamppas-cher.fr
http://www.coachoutletonlineinc.us.com
http://www.pandoracharms.us.com
http://www.coachoutletstore-online.us.com
http://www.adidassuperstar.me.uk
http://www.hermes-handbags.us
http://www.coachoutlets.in.net
http://www.christianlouboutinshoes.us.org
http://www.christianlouboutinsale.us.org
http://www.hollisterclothingstore.us
http://www.2017nikeairmax.us
http://www.nikefreeflyknit.name
http://www.fredperrypoloshirts.us
http://www.mulberry-bags.me.uk
http://www.kate-spadehandbags.us
http://www.coachfactoryoutletsonlines.us.com
http://www.nike-store.us.com
http://www.houstontexansjerseys.us.com
http://www.fitflops.org.uk
http://www.mont-blanc.in.net
http://www.louisvuitton-outlet-online.us.com
http://www.toms.in.net
http://www.denverbroncosjerseys.us
http://www.ralphlaurenuk.me.uk
http://www.pradaoutlets.us
http://www.cheapraybans.com.co
http://www.dallas-cowboysjerseys.us
http://www.tomsshoesoutlet.in.net
http://www.cheapraybansunglassesofficial.us.com
http://www.nikeairmax-pascher.fr
http://www.red-bottoms.us.com
http://www.airmaxoutletsaleus.com
http://www.supra-shoes.us
http://www.pandora-outlet.us.com
http://www.adidas-nmd.me.uk
http://www.adidas-shoes.us.com
http://www.katespadehandbags.us.com
http://www.adidasoutlet.us.com
http://www.michaelkorsoutletofficial.us
http://www.longchamp-handbags.us
http://www.birkenstocks.us
http://www.adidasnmd.us.org
http://www.coach-factoryoutlet-online.us.com
http://www.adidasshoes.me.uk
http://www.dolceandgabbanaoutlet.com
http://www.rolex-replicawatches.com.co
http://www.nike-airmax90.me.uk
http://www.adidas-shoes.me.uk
http://www.yeezyboost.org.uk
http://www.yeezyboost350.me.uk
http://www.ralphlaurensaleclearance.me.uk
http://www.todsoutlet.name
http://www.hermesbag.us.com
http://www.birkenstockpascher.fr
http://www.wwwlouisvuittonoutlet.us.com
http://www.yeezyboost-350.co.uk
http://www.coachoutletcoachfactoryoutletonline.us.com
http://www.true-religionjeansoutlet.in.net
http://www.fredperry.us.com
http://www.fitflopssaleclearancewholesale.us.com
http://www.outletlouisvuitton.us.com
http://www.michaelkorsoutletclearance.in.net
http://www.airjordanretro.us
http://www.michaelkorsofficial.us
http://www.coachoutletstoreonlineclearances.in.net
http://www.poloralphlaurencanada.ca
http://www.redbottomshoes.in.net
http://www.todsoutlet.us
http://www.nikeoutlet.us.com
http://www.coachfactory-outletstore.us.com
http://www.chiflatiron.in.net
http://www.ralphlaurensaleclearance.org.uk
http://www.pandora-bracelet.us
http://www.airmax90.org
http://www.officialmichaelkors.us.com
http://www.birkenstockshoes.us.com
http://www.timberlandbootsoutlet.us
http://www.cheapjordan-shoes.in.net
http://www.celineoutlet.us
http://www.coachfactory-outletonlines.us.com
http://www.airjordan-uk.org.uk
http://www.jameshardenshoes.us.com
http://www.seattleseahawksjerseys.us
http://www.adadassuperstar.com
http://www.newenglandpatriots-jerseys.us
http://www.coachoutlets.us.org
http://www.officialcoachoutlet.us.com
http://www.longchampoutletstore.com
http://www.storenike.fr
http://www.oakley.nom.co
http://www.pandora-bijoux.fr
http://www.nikeoutletonline.us.com
http://www.nikeshoes.us.com
http://www.nfljerseyscheap.in.net
http://www.onlinecoachfactoryoutlet.us.com
http://www.ralphlaurensaleclearance.co.uk
http://www.levisjeans.name
http://www.coach-outlets.us.com
http://www.adidaspascher.fr
http://www.christian-louboutin.us.com
http://www.yeezy-boost350v2.us.com
http://www.michael-korsoutlet.ca
http://www.versaceshoes.in.net
http://www.edhardyukclothing.me.uk
http://www.adidasshoes.name
http://www.coachfactoryoutlet-onlines.us.com
http://www.poloralphlauren-outlet.us.org
http://www.valentino.in.net
http://www.true-religionjeansoutlet.us.com
http://www.coachfactoryonlineoutlet.com.co
http://www.cheapmontblancpens.org
http://www.birkenstocksandals.name
http://www.oakleysunglassesonlinesale.us.com
http://www.michael-korshandbags.me.uk
http://www.coachoutletstoreinc.us.com
http://www.hermesbirkin.in.net
http://www.burberryoutlets.name
http://www.goldenstatewarriorsjerseys.us
http://www.coach-outletonline.us.org
http://www.officialcoachfactoryoutlet.eu.com
http://www.kate-spadeoutlets.us.com
http://www.coachoutletcanada.ca
http://www.clarks-shoes.us
http://www.coach-outletonlines.us.com
http://www.adidasyeezyboost-350.us
http://www.cheapmlbjerseyswholesale.us.com
http://www.hermesoutletonline.us
http://www.polo-ralphlauren.us.com
http://www.katespadeoutletonline.us.com
http://www.350yeezyboost.us.com
http://www.nikeoutletshoes.us
http://www.ralphlauren.net.co
http://www.pandorajewelryoutlet.in.net
http://www.pandora-uk.me.uk
http://www.outletmichaelkors.us.com
http://www.adidas-nmd.us.com
http://www.raybans.org.uk
http://www.marcjacobshandbag.us.com
http://www.michaelkorsoutletvip.in.net
http://www.yeezy-boost350v2.us
http://www.cheapmlbjerseys.us
http://www.cheaprolexreplicawatches.us
http://www.michaelkorshandbagsuk.org.uk
http://www.poloralph-lauren.in.net
http://www.true-religion.us.com
http://www.michaelkorsoutlet.co.uk
http://www.fitflopssalesclearance.us.com
http://www.birkenstocksandals.org.uk
http://www.mbtshoes.org.uk
http://www.pandora-jewelry.org.uk
http://www.mulberryoutlet.org.uk
http://www.raybansunglasses.net.co
http://www.discountoakleysunglassessale.us.com
http://www.cheap-jordans.us
http://www.michaelkorshandbags-outlet.us.org
http://www.pandoracharmssaleclearance.com
http://www.coachfactoryoutletstore.in.net
http://www.giuseppezanottioutlet.us
http://www.dansko-outlet.us
http://www.oakleysunglassessonlines.com
http://www.oakleyvaultsunglassesoutlet.us.com
http://www.nikestoreuk.me.uk
http://www.poloralph-lauren.fr
http://www.cheapoakleysunglassesofficial.us.com
http://www.adidas-outlet.us.com
http://www.cheapjordans.us.com
http://www.rolexreplica-watches.us.com
http://www.michaelkorshandbagsuk.co.uk
http://www.danskoshoes.us.com
http://www.pandoracharms.com.co
http://www.adidastrainersuk.org.uk
http://www.mbtshoes.in.net
http://www.birkenstockoutletstore.us.com
http://www.michaelkors-outlet.co.uk
http://www.burberry-outlet-canada.ca
http://www.stephcurry-shoes.us
http://www.adidasnmd-shoes.us
http://www.pandoracharmssaleclearance.me.uk
http://www.ralph-laurenoutlet.me.uk
http://www.coachoutletsstore.us.com
http://www.louboutin-paschers.fr
http://www.ultraboost.us
http://www.monclerjackets-uk.co.uk
http://www.oakley--sunglasses.us.org
http://www.longchampbags.uk
http://www.toryburchoutletonline.com.co
http://www.longchampbagsuk.me.uk
http://www.yeezyboost.us.com
http://www.cheapjordans.com.co
http://www.adidas-superstar.fr
http://www.coachoutletonlinecoachfactoryoutlet.us.com
http://www.kate-spadeoutlet.us.com
http://www.katespadehandbags.org.uk
http://www.vansshoes.in.net
http://www.sac-longchamp-pliage.fr
http://www.adidasnmd.org.uk
http://www.ralph-laurenuk.co.uk
http://www.cheapjordans-shoes.us.com
http://www.christianlouboutinoutlet.us
http://www.pandorajewelryoutlet.name
http://www.swarovski-crystal.uk
http://www.coachoutletstoreonline.com.co
http://www.michaelkors-outlet.ca
http://www.mlbjerseys-cheap.us.com
http://www.nike-airmax90.me.uk
http://www.ralph-laurenuk.org.uk
http://www.cheaprayban-sunglasses.com.co
http://www.salomonshoesoutlet.us
http://www.coachoutlet.in.net
http://www.michaelkorsoutletonlineclearance.in.net
http://www.clarksshoes.us.com
http://www.louboutin-shoes.us.com
http://www.cheapjordanshoes.us.com
http://www.catshoes.us.com
http://www.miamiheatjerseys.us
http://www.kevindurantshoes.us
http://www.monclerjacketsuk.org.uk
http://www.cheapoakleysunglassesonsale.us.com
http://www.ralphlaurenoutletonlines.us.com
http://www.adidas-superstar.us.com
http://www.longchamphandbags.me.uk
http://www.louboutin.org.uk
http://www.cheapnfl-jerseyswholesale.us.com
http://www.michaelkors-bags.me.uk
http://www.nikeair-max.org.uk
http://www.cheapjerseys.eu.com
http://www.toryburchoutlets.us
http://www.fendihandbags.us
http://www.parker-pens.us.com
http://www.discountnikeshoessc.org
http://www.nikeroshe.us
http://www.ralph-lauren-pas-cher.fr
http://www.polooutletstoreonline.us.com
http://www.michaelkors-handbags.us.org
http://www.gucci--borse.it
http://www.airmax90nike.us
http://www.mulberryhandbags.me.uk
http://www.fake-rolex.us
http://www.salomon-shoes.name
http://www.fitflopssandals.us.com
http://www.outletnike.us
http://www.moncleroutletjackets.us
http://www.outletlongchamp.us
http://www.coachhandbagsoutlet.us.com
http://www.christianlouboutinshoesoutlets.us.com
http://www.adidasshoes.us
http://www.ysl-handbags.us
http://www.jimmychoo.in.net
http://www.coachoutletsonlines.us.com
http://www.clevelandcavaliersjerseys.us
http://www.columbiashoes.name
http://www.coach-outlet.in.net
http://www.pandorasoldes.fr
http://www.pandoracharmsuk.uk
http://www.guccioutlets.us.org
http://www.underarmourshoes.us
http://www.pandoracharms.name
http://www.moncler-outlet.us.com
http://www.montblanc-pens.net.co
http://www.tomsoutletstore.in.net
http://www.fit-flopssaleclearance.us.com
http://www.michael-korsoutlet.us.com
http://www.ralphlauren-outletonline.us.com
http://www.adidasyeezyshoes.us.com
http://www.michaelkorsoutlets.us.com
http://www.sac-michaelkors.fr
http://www.true-religionjeans.in.net
http://www.moncleroutlet.in.net
http://www.saclongchampsolde.fr
http://www.rayban-sunglassesdiscount.us.com
http://www.mbtshoes.name
http://www.swarovskicrystal.name
http://www.pandora.us.com
http://www.ecco-shoes.us
http://www.valentinoshoesoutlets.us.com
http://www.doudounemonclerpascher.fr
http://www.christianlouboutinshoes.in.net

Comment by karin [ 02/Nov/17 ]

http://fitbizlegal.us
http://quietlegal.us
http://legaldatabases.us
http://inboxlegal.us
http://legalprolink.us
http://legalcleaners.us
http://legalecare.us
http://masterlegalusa.us
http://expressolegal.us
http://gricelegal.us
http://saferlegal.us
http://reducelegalfees.us
http://fileslegal.us
http://uponlegal.us
http://legal-accidents.us
http://heavylegal.us
http://starstarlegal.us
http://alexalegal.us
http://legalformadvice.us
http://legaltoplist.us
http://sportmyday.us
http://sportandmarket.us
http://sportszingers.us
http://ks-motorsports.us
http://uclasportsfans.us
http://tryoutsport.us
http://ledsportswear.us
http://intsportnews.us
http://sportsingsports.us
http://sportlinecars.us
http://us24sports.us
http://eday-sports.us
http://esportereplay.us
http://gjsportsadvice.us
http://free-sports-now.us
http://hotdealsport.us
http://gotsportment.us
http://oriental-sport.us
http://esportsfunds.us
http://bcfsporthorses.us
http://realwoodhomes.us
http://ahousehome.us
http://ownlocalhomes.us
http://ibuyhomes4you.us
http://softhome100.us
http://ilovehomeroom.us
http://sprinterhomes.us
http://homelandstyle.us
http://homeadvisotr.us
http://purewater4home.us
http://flahomecare.us
http://mydailyhomedeco.us
http://homedesign88.us
http://homhomeaway.us
http://sweet-homes.us
http://dreamhome365.us
http://bonathome.us
http://nicehomedecore.us
http://hunthomeforsale.us
http://7dayhomesellers.us
http://www.healthreign.us
http://www.ripahealth.us
http://www.health-4-u.us
http://www.greathealth2u.us
http://www.healthykeem.us
http://www.mhealthinsiders.us
http://www.goodhealthwitch.us
http://www.healthyfitlines.us
http://www.healthychirp.us
http://www.healthmina.us
http://www.healthascend.us
http://www.health-chirp.us
http://www.lifefithealthy.us
http://www.bighealthtimes.us
http://www.arogalifehealth.us
http://www.wonhealthy.us
http://www.hairhealthguide.us
http://www.healthypurebody.us
http://www.healthnewsbot.us
http://www.healthnutbeauty.us
http://www.soulbusinessiq.us
http://www.1andonebusiness.us
http://www.businessacount.us
http://www.concisebusiness.us
http://www.businessairman.us
http://www.zmultibusiness.us
http://www.exporbusiness.us
http://www.9thbusiness.us
http://www.business-matrix.us
http://www.facing-business.us
http://www.excelbusiness.us
http://www.1idea2business.us
http://www.ebusinessz.us
http://www.buddymebusiness.us
http://www.businesshumans.us
http://www.business24hours.us
http://www.upstartbusiness.us
http://www.mybusinessocial.us
http://www.hrbusinessboost.us
http://www.mybusinesscamp.us

Generated at Sun Aug 18 02:56:26 CEST 2019 using JIRA 6.1.1#6155-sha1:7188aeec9a6b57d61ea04c52f235f15f55c105e2.