{ Community }
  • Academy
  • Docs
  • Developers
  • Resources
    • Community Articles
    • Apigee on GitHub
    • Code Samples
    • Videos & eBooks
    • Accelerator Methodology
  • Support
  • Ask a Question
  • Spaces
    • Product Announcements
    • General
    • Edge/API Management
    • Developer Portal (Drupal-based)
    • Developer Portal (Integrated)
    • API Design
    • APIM on Istio
    • Extensions
    • Business of APIs
    • Academy/Certification
    • Adapter for Envoy
    • Analytics
    • Events
    • Hybrid
    • Integration (AWS, PCF, Etc.)
    • Microgateway
    • Monetization
    • Private Cloud Deployment
    • 日本語コミュニティ
    • Insights
    • IoT Apigee Link
    • BaaS/Usergrid
    • BaaS Transition/Migration
    • Apigee-127
    • New Customers
    • Topics
    • Questions
    • Articles
    • Ideas
    • Leaderboard
    • Badges
  • Log in
  • Sign up

Get answers, ideas, and support from the Apigee Community

  • Home /
  • Edge/API Management /
avatar image
0
Question by Chris Covney · Apr 29, 2015 at 04:49 PM · 276 Views edgeoauthpostgrestestingperformance

postgress errors during oauth 2.0 performance testing

Hi everyone,

We encountered a recurring postgres error during a basic performance test of our oauth 2.0 authorization code grant_type flow. The below errors repeatedly occur while testing the oauth login page, the generation of the auth code, generation of access_token, the refresh token functionality, and the revoke access token functionality. The calls are made in succession (mimicking a typical use case flow order).

The test is run with only 1 concurrent user, at 1-5 TPS, and the test duration is 5 minutes.

2015-04-28 02:05:50,886 org: env: main WARN  i.a.a.s.a.ServerBootstrapService - ServerBootstrapServiceImpl$1$4.execute() : Exception occured while making a query:  select pg_last_xlog_receive_location() Exception: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.)

These errors do not occur for our QC functional testing (very low volume).

Has anyone seen these errors before, and/or does anyone know if we should be worried about our infrastructure or applications?

Best, Chris

Comment
Add comment Show 2
10 |5000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by Apigeeks only
  • Viewable by the original poster
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users
avatar image pbhogill ♦ · Apr 30, 2015 at 04:20 AM 0
Link

Hi @Chris Covney is it happening on any other proxy or just the OAuth proxy? This is interesting as postgres is not really used besides for capturing analytics or if a StatisticsCollector policy is used. The OAuth tokens are persisted in the underlying cassandra tier. @Vinit Mehta

avatar image Chris Covney pbhogill ♦ · May 01, 2015 at 09:09 PM 0
Link

Hi Prithpal,

This error occurs for all our proxies. We do have the statistics collector policy in each of our proxies, but we are only collecting 3-4 metrics per proxy, not much data

Close

1 Answer

  • Sort: 
avatar image
2
Best Answer

Answer by pbhogill · May 03, 2015 at 04:34 AM

Hi @Chris Covney could point to an issue potentially associated with replication. Is the postgres db installed in a master / slave topology? Would recommend to log a ticket with Apigee Support and have your configuration reviewed.

Comment
Add comment Show 1 · Link
10 |5000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by Apigeeks only
  • Viewable by the original poster
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users
avatar image Chris Covney · May 12, 2015 at 08:24 PM 0
Link

Hi Prithpal,

That is a very good point. Our postgres DB is installed in a master/slave topology, but we've never had to fail over to the slave instance. I will log a ticket to look into the config. Thanks for the help!

Follow this Question

Answers Answers and Comments

19 People are following this question.

avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image

Related Questions

Is it possible to migrate the existing client ID and client secret after it is provisioned? 5 Answers

getting scopes from accessEntity policy 1 Answer

How to specify the IP addresses of specific NIC of Postgres Master/Standby servers 1 Answer

types of authentication I can use from Ariba to Apigee Edge? 1 Answer

zookeeper errors during oauth 2.0 performance testing 1 Answer

  • Products
    • Edge - APIs
    • Insights - Big Data
    • Plans
  • Developers
    • Overview
    • Documentation
  • Resources
    • Overview
    • Blog
    • Apigee Institute
    • Academy
    • Documentation
  • Company
    • Overview
    • Press
    • Customers
    • Partners
    • Team
    • Events
    • Careers
    • Contact Us
  • Support
    • Support Overview
    • Documentation
    • Status
    • Edge Support Portal
    • Privacy Policy
    • Terms & Conditions
© 2021 Apigee Corp. All rights reserved. - Apigee Community Terms of Use - Powered by AnswerHub
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Create an article
  • Post an idea
  • Spaces
  • Product Announcements
  • General
  • Edge/API Management
  • Developer Portal (Drupal-based)
  • Developer Portal (Integrated)
  • API Design
  • APIM on Istio
  • Extensions
  • Business of APIs
  • Academy/Certification
  • Adapter for Envoy
  • Analytics
  • Events
  • Hybrid
  • Integration (AWS, PCF, Etc.)
  • Microgateway
  • Monetization
  • Private Cloud Deployment
  • 日本語コミュニティ
  • Insights
  • IoT Apigee Link
  • BaaS/Usergrid
  • BaaS Transition/Migration
  • Apigee-127
  • New Customers
  • Explore
  • Topics
  • Questions
  • Articles
  • Ideas
  • Badges