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
QA: reproduction steps
Impacts: none
Closed: in production since several weeks
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
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
UNSTABLE: Integrated in
opush-master #268
OP-247Add explanations in the upgrade doc (thilaire: b7b89dd6d6b90a5361660570e84269caac5782e7)