Skip to content

Instantly share code, notes, and snippets.

# 390ms user time, 60ms system time, 25.43M rss, 96.08M vsz
# Current date: Mon Mar 5 17:06:00 2018
# Hostname: fk-sp-slm-spcms-db-none-6033051
# Files: /home/vasanthkumar.b/slowLog
# Overall: 157 total, 2 unique, 1.65 QPS, 65.77x concurrency _____________
# Time range: 2018-03-05 17:00:19 to 17:01:54
# Attribute total min max avg 95% stddev median
# ============ ======= ======= ======= ======= ======= ======= =======
# Exec time 6248s 1s 84s 40s 76s 33s 35s
# Lock time 25ms 6us 4ms 162us 260us 320us 167us
[2018-02-08 01:50:19,947] {VerticalEntityDefnFetcher} [INFO] [~localhost-startStop-1] - For vertical water_purifier additional searchable attributes [purifying_technology, brand_id, total_capacity]
[2018-02-08 01:50:19,947] {CatalogCoreInitializer} [ERROR] [~localhost-startStop-1] - Error while initializing catalog core
java.lang.IllegalArgumentException: Category water_purifier has no attribute called [brand_id]
at flipkart.cms.catalogmanager.types.Category.getAttributeByName(Category.java:1112)
at flipkart.apps.clp.dal.entity.defn.VerticalEntityMapper.getEntityDefn(VerticalEntityMapper.java:84)
at flipkart.apps.clp.dal.entity.defn.VerticalEntityMapper.getEntityDefn(VerticalEntityMapper.java:45)
at flipkart.apps.clp.dal.entity.defn.VerticalEntityDefnFetcher.getEntityStructure(VerticalEntityDefnFetcher.java:98)
at flipkart.apps.clp.dal.entity.defn.VerticalEntityDefnFetcher.getEntityStructureForEntity(VerticalEntityDefnFetcher.java:59)
➜ ~ curl -v http://10.32.213.199:36300/external/feed/streaming\?category_id\=220\&date\=2017-11-16T22:00:00 -H 'X-EBAY-C-MARKETPLACE-ID: EBAY-US' -H 'streamBytesRange: 0-88888' -H 'action: ITEM_SNAPSHOT' -H 'Accept: application/octet-stream' | gunzip
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0* Trying 10.32.213.199...
* TCP_NODELAY set
* Connected to 10.32.213.199 (10.32.213.199) port 36300 (#0)
> GET /external/feed/streaming?category_id=220&date=2017-11-16T22:00:00 HTTP/1.1
> Host: 10.32.213.199:36300
> User-Agent: curl/7.54.0
> X-EBAY-C-MARKETPLACE-ID: EBAY-US
Last login: Thu Nov 16 01:37:47 on ttys005
^R
➜ ~ curl -v http://10.47.5.58:80/external/feed/streaming\?category_id\=220\&date\=2017-11-16T00:00:00 -H 'X-EBAY-C-MARKETPLACE-ID: EBAY-US' -H 'streamBytesRange: 0-293133' -H 'action: ITEM_SNAPSHOT' -H 'Accept: application/octet-stream' | gunzip
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0* Trying 10.47.5.58...
* TCP_NODELAY set
* Connected to 10.47.5.58 (10.47.5.58) port 80 (#0)
> GET /external/feed/streaming?category_id=220&date=2017-11-16T00:00:00 HTTP/1.1
> Host: 10.47.5.58
@vasanthkumarb26
vasanthkumarb26 / gist:91c53209c10025b03272619a0862f36e
Created November 15, 2017 20:14
Curl request for item snapshot api.
➜ ~ curl -v http://10.47.5.58:80/external/feed/streaming\?category_id\=26395\&date\=2017-11-15T10:00:00 -H 'X-EBAY-C-MARKETPLACE-ID: EBAY-US' -H 'streamBytesRange: 0-293133' -H 'action: ITEM_SNAPSHOT' -H 'Accept: application/octet-stream' | gunzip
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0* Trying 10.47.5.58...
* TCP_NODELAY set
* Connected to 10.47.5.58 (10.47.5.58) port 80 (#0)
> GET /external/feed/streaming?category_id=26395&date=2017-11-15T10:00:00 HTTP/1.1
> Host: 10.47.5.58
> User-Agent: curl/7.54.0
> X-EBAY-C-MARKETPLACE-ID: EBAY-US
javax.servlet.ServletException: java.lang.ExceptionInInitializerError
at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:420)
at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538)
at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
[2017-05-03 23:58:10,105] {SellerListingDaoImpl} [ERROR] [~http-bio-26600-exec-3] - Error in persisting listing for FSN:MOBEQF37DB9GC4XT
java.lang.NullPointerException
at flipkart.cms.catalogmanager.modification.SingleAttributeValueDataCompare.getData(SingleAttributeValueDataCompare.java:46)
at flipkart.cms.catalogmanager.modification.SingleAttributeValueDataCompare.compare(SingleAttributeValueDataCompare.java:92)
at flipkart.cms.catalogmanager.modification.SingleAttributeValueDataCompare.compare(SingleAttributeValueDataCompare.java:15)
at flipkart.cms.catalogmanager.modification.ProductDataCompare.getAttrLevelChange(ProductDataCompare.java:66)
at flipkart.cms.catalogmanager.modification.ListingPDataCompare.getCompareInfo(ListingPDataCompare.java:38)
at flipkart.cms.catalogmanager.types.ListingPData.compare(ListingPData.java:25)
at flipkart.sp.dal.listing.listingversion.ListingVersionManager.getStageDiff(ListingVersionManager.java:39)
at flipkart.sp.dal.listing.dao.helper.SellerListingDaoHelper.getCha