[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

Too long time spent on SQL when Sync request have changes

Details

Description

Pre-conditions

Reproduction steps

Current behavior

Expected behavior

How to solve that

Issue Links

Activity

People

Dates

Agile