[OP-247] Too long time spent on SQL when Sync request have changes - OBM

Details

Type: Bug
Status: Closed
Priority: Normal
Resolution: Fixed
Affects Version/s: None
Fix Version/s: 3.2.1
Labels:
None

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

As usera with opush, sync

Current behavior

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

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);

Issue Links

relates to

OP-184 Rework the slow isServerIdSynced SQL request

Activity

Ascending order - Click to sort in descending order

Hide

Permalink

Jenkins Continuous Integration Server added a comment - 11/Oct/16 9:17 AM

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

Show

Jenkins Continuous Integration Server added a comment - 11/Oct/16 9:17 AM 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

Hide

Permalink

Thomas HILAIRE added a comment - 11/Oct/16 4:08 PM

QA: reproduction steps
Impacts: none

Show

Thomas HILAIRE added a comment - 11/Oct/16 4:08 PM QA : reproduction steps Impacts : none

Hide

Permalink

Thomas HILAIRE added a comment - 04/Nov/16 9:59 AM

Closed: in production since several weeks

Show

Thomas HILAIRE added a comment - 04/Nov/16 9:59 AM Closed : in production since several weeks

Hide

Permalink

yangping55 added a comment - 04/Jul/17 10:46 AM

Show

yangping55 added a comment - 04/Jul/17 10:46 AM 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

Hide

Permalink

karin added a comment - 02/Nov/17 6:29 PM

Show

karin added a comment - 02/Nov/17 6:29 PM 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

People

Assignee:

Thomas HILAIRE

Reporter:

Thomas HILAIRE

Votes:

0 Vote for this issue

Watchers:

4 Start watching this issue

Dates

Created:

10/Oct/16 2:35 PM

Updated:

02/Nov/17 6:29 PM

Resolved:

11/Oct/16 4:07 PM

Agile

View on Board