<link href='https://www.blogger.com/dyn-css/authorization.css?targetBlogID=7975199447131874550&zx=760534d9-1ce4-4510-a7d7-6a882e368569' media='none' onload='if(media!='all')media='all'' rel='stylesheet'/><noscript><link href='https://www.blogger.com/dyn-css/authorization.css?targetBlogID=7975199447131874550&zx=760534d9-1ce4-4510-a7d7-6a882e368569' rel='stylesheet'/></noscript>
<meta name='google-adsense-platform-account' content='ca-host-pub-1556223355139109'/>
<meta name='google-adsense-platform-domain' content='blogspot.com'/>

<!-- data-ad-client=ca-pub-8669036782105267 -->

</head><body>

More

AWS RDS 오라클 사용 중 Got minus one from a read call, connect lapse 10 ms

12월 20, 2022 - (Updated: 3월 15, 2024)

콜드카드

Got minus one from a read call, connect lapse 10 ms

에러메시지 : org.apache.naming.NamingContext.lookup Unexpected exception resolving reference java.sql.SQLRecoverableException: IO Error: Got minus one from a read call, connect lapse 10 ms., Authentication lapse 0 ms.

Got-minus-one-from-a-read-call

Got minus one from a read call, connect lapse 10 ms 에러 모습

처음 이 에러메시지를 확인했을 땐 톰캣 커넥션풀 초과로 인해 발생했다고 생각했는데 AWS의 cloudwatch DatabaseConnections을 살펴보니 그게 아니었단걸 깨닫고 일단 긴급조치 했습니다.

DatabaseConnections-확인

DatabaseConnections 이 엄청나게 차있다 긴급 조치 후 급격히 빠지는 모습

긴급 조치 후 select * from v$resource_limit; 쿼리를 통해 확인해보니 processes, sessions 값은 다시 정상으로 돌아왔고 제 경우는 사용한 커넥션을 반환해야 하는데 어딘가에 누수가 있어 계속 쌓이고 있다가 아침시간 로그인이 몰리면서 발생한 것 같습니다.

이 에러메시지의 주된 원인은 오라클에 설정되어 있는 processes, sessions 최대값 이상으로 접속이 몰릴 경우 생긴다고 합니다.

processes-sessions-확인

긴급 조치 후 CURRENT_UTILIZATION 값이 다시 내려온 모습, LIMIT_VALUE 에 근접한 값으로 변하면 조치해줘야 합니다.

processes, sessions 최대 값을 늘릴 수 도 있지만 이 설정을 늘리면 데이터베이스 연결에 메모리를 사용하기 때문에 이러한 파라미터 중 하나를 너무 높게 설정하면 메모리 부족 상태가 발생하여 DB 인스턴스가 파라미터 호환 장애(incompatible-parameters) 상태가 될 수 있습니다.

Read Also

공유:

공유

관심 있을 만한 글:

<script type="text/javascript" src="https://www.blogger.com/static/v1/widgets/984859869-widgets.js"></script>
<script type='text/javascript'>
window['__wavt'] = 'AOuZoY7dCrjPKM-5HRNpoLroMUZlk7vWjQ:1732434657558';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d7975199447131874550','//cold-card.blogspot.com/2022/12/blog-post_20.html','7975199447131874550');
_WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '7975199447131874550', 'title': '\ucf5c\ub4dc\uce74\ub4dc', 'url': 'https://cold-card.blogspot.com/2022/12/blog-post_20.html', 'canonicalUrl': 'https://cold-card.blogspot.com/2022/12/blog-post_20.html', 'homepageUrl': 'https://cold-card.blogspot.com/', 'searchUrl': 'https://cold-card.blogspot.com/search', 'canonicalHomepageUrl': 'https://cold-card.blogspot.com/', 'blogspotFaviconUrl': 'https://cold-card.blogspot.com/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': false, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': '', 'encoding': 'UTF-8', 'locale': 'ko', 'localeUnderscoreDelimited': 'ko', 'languageDirection': 'ltr', 'isPrivate': false, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'isDynamicViewsAvailable': true, 'feedLinks': '\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22\ucf5c\ub4dc\uce74\ub4dc - Atom\x22 href\x3d\x22https://cold-card.blogspot.com/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22\ucf5c\ub4dc\uce74\ub4dc - RSS\x22 href\x3d\x22https://cold-card.blogspot.com/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22\ucf5c\ub4dc\uce74\ub4dc - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/7975199447131874550/posts/default\x22 /\x3e\n\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22\ucf5c\ub4dc\uce74\ub4dc - Atom\x22 href\x3d\x22https://cold-card.blogspot.com/feeds/8020776248555615448/comments/default\x22 /\x3e\n', 'meTag': '', 'adsenseClientId': 'ca-pub-8669036782105267', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': true, 'adsenseAutoAds': false, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/d78375fb222d99b3', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': '\uacf5\uc720 \ub9c1\ud06c \ub9cc\ub4e4\uae30', 'key': 'link', 'shareMessage': '\uacf5\uc720 \ub9c1\ud06c \ub9cc\ub4e4\uae30', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Facebook\uc5d0 \uacf5\uc720', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': 'X', 'key': 'twitter', 'shareMessage': 'X\uc5d0 \uacf5\uc720', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Pinterest\uc5d0 \uacf5\uc720', 'target': 'pinterest'}, {'name': '\uc774\uba54\uc77c', 'key': 'email', 'shareMessage': '\uc774\uba54\uc77c', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27ko\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': true, 'jumpLinkMessage': 'Read more \xbb', 'pageType': 'item', 'postId': '8020776248555615448', 'postImageThumbnailUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOorBWJnNystsNr8IcnkOL2R_WiimIUlGewex-wcfLuBB_ZgXIeHmjkTU4W4nT_npG-YBvKKFC4F3huRvQvnI6LaM_54osEUV5l6F5MX1CuGkC0bWWPw8KOxxc5NcCeMaJ7t1TUg2l38dHuqw7POj_k5PQuIFPulC7yjmRDZbg-IfeL-lPiILL3A/s72-w640-c-h154/%EC%97%90%EB%9F%AC%EB%A1%9C%EA%B7%B8.png', 'postImageUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOorBWJnNystsNr8IcnkOL2R_WiimIUlGewex-wcfLuBB_ZgXIeHmjkTU4W4nT_npG-YBvKKFC4F3huRvQvnI6LaM_54osEUV5l6F5MX1CuGkC0bWWPw8KOxxc5NcCeMaJ7t1TUg2l38dHuqw7POj_k5PQuIFPulC7yjmRDZbg-IfeL-lPiILL3A/w640-h154/%EC%97%90%EB%9F%AC%EB%A1%9C%EA%B7%B8.png', 'pageName': 'AWS RDS \uc624\ub77c\ud074 \uc0ac\uc6a9 \uc911 Got minus one from a read call, connect lapse 10 ms', 'pageTitle': '\ucf5c\ub4dc\uce74\ub4dc: AWS RDS \uc624\ub77c\ud074 \uc0ac\uc6a9 \uc911 Got minus one from a read call, connect lapse 10 ms', 'metaDescription': '\uc624\ub77c\ud074 \uc0ac\uc6a9 \uc911 Got minus one from a read call, connect lapse 10 ms., Authentication lapse 0 ms \uc5d0\ub7ec \uba54\uc2dc\uc9c0\uc758 \ud655\uc778'}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': '\uc218\uc815', 'linkCopiedToClipboard': '\ub9c1\ud06c\ub97c \ud074\ub9bd\ubcf4\ub4dc\uc5d0 \ubcf5\uc0ac\ud588\uc2b5\ub2c8\ub2e4.', 'ok': '\ud655\uc778', 'postLink': '\uae00 \ub9c1\ud06c'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': '\uc0ac\uc6a9\uc790 \uc9c0\uc815', 'isResponsive': true, 'isAlternateRendering': false, 'isCustom': true}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\x3dclassic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\x3dflipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\x3dmagazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\x3dmosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\x3dsidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\x3dsnapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\x3dtimeslide'}, 'isMobile': false, 'title': 'AWS RDS \uc624\ub77c\ud074 \uc0ac\uc6a9 \uc911 Got minus one from a read call, connect lapse 10 ms', 'description': '\uc624\ub77c\ud074 \uc0ac\uc6a9 \uc911 Got minus one from a read call, connect lapse 10 ms., Authentication lapse 0 ms \uc5d0\ub7ec \uba54\uc2dc\uc9c0\uc758 \ud655\uc778', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOorBWJnNystsNr8IcnkOL2R_WiimIUlGewex-wcfLuBB_ZgXIeHmjkTU4W4nT_npG-YBvKKFC4F3huRvQvnI6LaM_54osEUV5l6F5MX1CuGkC0bWWPw8KOxxc5NcCeMaJ7t1TUg2l38dHuqw7POj_k5PQuIFPulC7yjmRDZbg-IfeL-lPiILL3A/w640-h154/%EC%97%90%EB%9F%AC%EB%A1%9C%EA%B7%B8.png', 'url': 'https://cold-card.blogspot.com/2022/12/blog-post_20.html', 'type': 'item', 'isSingleItem': true, 'isMultipleItems': false, 'isError': false, 'isPage': false, 'isPost': true, 'isHomepage': false, 'isArchive': false, 'isLabelSearch': false, 'postId': 8020776248555615448}}, {'name': 'widgets', 'data': [{'title': 'Template Code (Do not disable)', 'type': 'HTML', 'sectionId': 'settings', 'id': 'HTML3'}, {'title': '\ucf5c\ub4dc\uce74\ub4dc(\ud5e4\ub354)', 'type': 'Header', 'sectionId': 'header', 'id': 'Header1'}, {'title': 'category', 'type': 'LinkList', 'sectionId': 'section', 'id': 'LinkList1'}, {'title': '\ube14\ub85c\uadf8 \uac8c\uc2dc\ubb3c', 'type': 'Blog', 'sectionId': 'main', 'id': 'Blog1', 'posts': [{'id': '8020776248555615448', 'title': 'AWS RDS \uc624\ub77c\ud074 \uc0ac\uc6a9 \uc911 Got minus one from a read call, connect lapse 10 ms', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOorBWJnNystsNr8IcnkOL2R_WiimIUlGewex-wcfLuBB_ZgXIeHmjkTU4W4nT_npG-YBvKKFC4F3huRvQvnI6LaM_54osEUV5l6F5MX1CuGkC0bWWPw8KOxxc5NcCeMaJ7t1TUg2l38dHuqw7POj_k5PQuIFPulC7yjmRDZbg-IfeL-lPiILL3A/w640-h154/%EC%97%90%EB%9F%AC%EB%A1%9C%EA%B7%B8.png', 'showInlineAds': false}], 'headerByline': {'regionName': 'header1', 'items': [{'name': 'share', 'label': ''}, {'name': 'author', 'label': 'Oleh'}, {'name': 'timestamp', 'label': 'pada tanggal'}, {'name': 'labels', 'label': ''}]}, 'footerBylines': [{'regionName': 'footer1', 'items': [{'name': 'comments', 'label': 'Post a Comment'}]}], 'allBylineItems': [{'name': 'share', 'label': ''}, {'name': 'author', 'label': 'Oleh'}, {'name': 'timestamp', 'label': 'pada tanggal'}, {'name': 'labels', 'label': ''}, {'name': 'comments', 'label': 'Post a Comment'}]}, {'title': 'Advertisement', 'type': 'HTML', 'sectionId': 'top_ads', 'id': 'HTML90'}, {'title': 'Advertisement', 'type': 'HTML', 'sectionId': 'bottom_ads', 'id': 'HTML94'}, {'type': 'AdSense', 'sectionId': 'sidebar', 'id': 'AdSense1'}, {'title': '\ud0dc\uadf8', 'type': 'Label', 'sectionId': 'sidebar', 'id': 'Label1'}, {'title': 'Table of Contents', 'type': 'HTML', 'sectionId': 'toc_auto', 'id': 'HTML8'}]}]);
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML3', 'settings', document.getElementById('HTML3'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HeaderView', new _WidgetInfo('Header1', 'header', document.getElementById('Header1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList1', 'section', document.getElementById('LinkList1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog1', 'main', document.getElementById('Blog1'), {'cmtInteractionsEnabled': false, 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/610513206-lbx__ko.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/1964470060-lightbox_bundle.css'}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML90', 'top_ads', document.getElementById('HTML90'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML94', 'bottom_ads', document.getElementById('HTML94'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_AdSenseView', new _WidgetInfo('AdSense1', 'sidebar', document.getElementById('AdSense1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label1', 'sidebar', document.getElementById('Label1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML8', 'toc_auto', document.getElementById('HTML8'), {}, 'displayModeFull'));
</script>
</body>