Groups | Search | Server Info | Login | Register
Groups > perl.dbi.users > #3415
| Newsgroups | perl.dbi.users |
|---|---|
| Path | csiph.com!fu-berlin.de!bofh.it!nntp.perl.org |
| Xref | csiph.com perl.dbi.users:3415 |
| Return-Path | <mark@rekudos.net> |
| Mailing-List | contact dbi-users-help@perl.org; run by ezmlm |
| Delivered-To | mailing list dbi-users@perl.org |
| DKIM-Signature | v=1; a=rsa-sha256; c=relaxed/relaxed; d=perl.org; h=date :from:to:cc:subject:message-id:references:mime-version :content-type:content-transfer-encoding:in-reply-to:reply-to; s= dr1; bh=az6DegdiUmT4IZvZtOI6hMPGxlzVaKNiQdVhgc23FCg=; b=S05Loov4 NiGhEguKUz7I3HP0eSjpw9bvaJUr3Yr6e6bV3ILZEV2gdgWcmVqGvoKsChYaZNRe vl6VUwUYqtz/qA9mfbAs4J/fDccuFzNaOz6qNAq/M5nlDvh9GhtBl/t8EUD9IPkd X9Dta+3fUJ9pI3650eAT0m7CR+Pgfyn35hwYW/RdUNwc8Y9SO+p/euvynP/MS6j2 +Z2QZrH2pE2i1+kccV6rn7AOP6yFvIQI4dakk/z9PJ0OYCtynn2NaNybJQ9zOICw 3pPp5+3EGB/6tskaQoWsCTwSgl6SjTxyf9YRAed3M/6MrN4I3RLhmV3Gddet6vFh Zkdo4JXw1VuSXg== |
| Received | (qmail 32110 invoked from network); 1 Apr 2025 10:53:37 -0000 |
| Received | from xx1.develooper.com (147.75.38.233) by x6.develooper.com with SMTP; 1 Apr 2025 10:53:37 -0000 |
| Received | from inbound-egress-11.mailchannels.net (inbound-egress-11.mailchannels.net [23.83.208.2]) by xx1.develooper.com (Postfix) with ESMTP id 327277C1A2 for <dbi-users@perl.org>; Tue, 1 Apr 2025 03:53:36 -0700 (PDT) |
| ARC-Seal | i=1; s=arc-2022; d=mailchannels.net; t=1743504810; a=rsa-sha256; cv=none; b=jncw92guAGp2rVLZo2Zp2zC0q0D1lThxpDBiKUgZDNEKLmRHZ9xfHikyO2TIX4CKa5tXfP N8CP3Y6rlRGstbwaCHrwbi35qXFOV2v/WBNtkQu/72WHVGNhUYk6TZjn3FXxSlveEekzDm s/8KfXczUebtQpI3K9N6L1ftDD2/DVoD+cuAOubk/2q/nWLlxOD5hICH6/4hkCTgPT1oi1 02IDizi9Pu5L6JyUbQdPE3nzHwpptnyXR5HBw7AJh+i0cvRoSXe5wWKaH6gcnuJaoi9TZd kD7mhKWEWhqqsoUFFXagT/vumdxgWroY2CmNzveeQ9NvOd/xxKaOaGUbutAHBA== |
| ARC-Message-Signature | i=1; a=rsa-sha256; c=relaxed/relaxed; d=mailchannels.net; s=arc-2022; t=1743504810; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references:dkim-signature; bh=az6DegdiUmT4IZvZtOI6hMPGxlzVaKNiQdVhgc23FCg=; b=F16k2ezAkz+vaonX9rFLlbj7lqZ3umky8P2Gb33sj0ijpEVr9MzCJ0w4RxwObq4a6sCKBk vQp5im4wpmaxnRNwOdzhB+RnjpcenhPoBM2z0cNkMerGo9skqO+Q7GyLau+B5vNcEiX2Ln LsHMWW8rGiJSw4aXenTqeI3PttzH+OeYmP7rv2UrJ3pK8Zgjfs+51qIfFA/tHkOYb8GGmJ VewI7kubeIm8S+2OutZ+XNKweRZnGjwYl9ajXZLyR4VN8b7seEnajHANnoS0bGuDHNmFOE tzVblJLvCpaGZ6UpXiGxU/0UB5eLwCvp04evsMvvVFECgqP0eZ8D1EO6Sw+jyg== |
| ARC-Authentication-Results | i=1; inbound-rspamd-54cd77c794-wv7rt; none |
| X-Message-ID | ovNVLxfLrT5VxbjHnninTY0F |
| Received | from mail.rekudos.net (mail.rekudos.net [212.227.211.217]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384) by 100.97.42.204 (trex/7.0.3); Tue, 01 Apr 2025 10:53:36 +0000 |
| Authentication-Results | inbound.mailchannels.net; spf=pass smtp.mailfrom=mark@rekudos.net; dkim=pass header.d=rekudos.net; dmarc=pass (policy=reject; pct=100; status=pass); arc=none |
| Received-SPF | pass (dmarc-service-6f67f497c4-762kd: domain of rekudos.net designates 212.227.211.217 as permitted sender) client-ip=212.227.211.217; envelope-from=mark@rekudos.net; helo=mail.rekudos.net; |
| Date | Tue, 1 Apr 2025 10:53:25 +0000 |
| To | "Johnson, Bruce E - (bjohnson)" <bjohnson@arizona.edu> |
| Cc | "dbi-users@perl.org" <dbi-users@perl.org> |
| Subject | Re: [EXT] Issues connecting to an Amazon RDS instance: creating the database handle is taking a VERY long time |
| Message-ID | <Z-vFpXwkHorVul9_@mail.rekudos.net> (permalink) |
| References | <F7CE225B-0EA8-4AF1-BCCA-7651577FE4A8@arizona.edu> <Z-pTFsyRHAbtGnKp@mail.rekudos.net> <129F32DF-A804-4D6A-AE98-2F85963F527D@arizona.edu> |
| MIME-Version | 1.0 |
| Content-Type | text/plain; charset=utf-8; format=flowed |
| Content-Disposition | inline |
| Content-Transfer-Encoding | 8bit |
| In-Reply-To | <129F32DF-A804-4D6A-AE98-2F85963F527D@arizona.edu> |
| Original-From | Mark Lawrence <mark@rekudos.net> |
| Reply-To | Mark Lawrence <mark@rekudos.net>, |
| Approved | news@nntp.perl.org |
| From | dbi-users@perl.org (Mark Lawrence via dbi-users) |
Show key headers only | View raw
On Mon Mar 31, 2025 at 11:20:11PM +0000, Johnson, Bruce E - (bjohnson) wrote: >Sadly no. It’s still instantaneous on-prem but takes 61 seconds to get >the database handle with the ip address. (and DNS resolves just fine ) Second idea: you aren't explicitly specifying the connection port. There is evidence[1] of someone else observing a timeout related to 1521, which I guess is the DBI default. [1] https://dba.stackexchange.com/questions/60688/perl-dbi-takes-60-seconds-to-connect-to-an-oracle-database-every-single-time What is your cloud database listening on? As the post suggests, setting DBI_TRACE will provide more food for investigation. -- Mark Lawrence
Back to perl.dbi.users | Previous | Next — Previous in thread | Next in thread | Find similar
Re: Issues connecting to an Amazon RDS instance: creating the database handle is taking a VERY long time dbi-users@perl.org (Mark Lawrence via dbi-users) - 2025-03-31 08:32 +0000
Re: [EXT] Issues connecting to an Amazon RDS instance: creating the database handle is taking a VERY long time dbi-users@perl.org (Mark Lawrence via dbi-users) - 2025-04-01 10:53 +0000
Re: [EXT] Issues connecting to an Amazon RDS instance: creating the database handle is taking a VERY long time dbi-users@perl.org (Mark Lawrence via dbi-users) - 2025-04-01 11:03 +0000
csiph-web