Skip Menu |
 

This queue is for tickets about the DBIx-HA CPAN distribution.

Report information
The Basics
Id: 122897
Status: open
Priority: 0/
Queue: DBIx-HA

People
Owner: Nobody in particular
Requestors: filip [...] brandify.com
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



Subject: Bug in DBIx::HA
Date: Fri, 25 Aug 2017 17:03:55 +0200
To: bug-DBIx-HA [...] rt.cpan.org
From: Filip Rembiałkowski <filip [...] brandify.com>
Download (untitled) / with headers
text/plain 2.8k
We are using DBIx-HA-1.1.tar.gz which has $DBIx::HA::VERSION = 1.10; DBIx/HA.pm has this L83 # create an easy reverse-lookup table for finding the db server name from the dsn L84 $DBIx::HA::finddbserver{$dsn} = $dbname; The hash %DBIx::HA::finddbserver is indexed by DSN, while $DATABASE::conf is indexed by name. This effects in overwriting reverse lookup table, for the DSN which was already seen, with a different (random) name from keys %DATABASE::conf. The attached script will fail randomly, depending on internal hash order (which is randomized in all recent versions of Perl) We have no patch, but the whole reverse lookup logic has to be changed. Example results: filip@szary:~$ while true; do perl dbixhabug.pl ; done TEST SQL: SELECT current_database(), version(), pg_sleep(2) [8458] DBIx::HA:st: *** EXECUTION TIMED OUT in dbi:Pg: ; SQL: SELECT current_database(), version(), pg_sleep(2) at /usr/local/share/perl/5.22.1/DBIx/HA.pm line 549. DBD::Pg::st fetchrow_array failed: no statement executing at dbixhabug.pl line 40. DBD::Pg::st fetchrow_array failed: no statement executing at dbixhabug.pl line 40. TEST SQL: SELECT current_database(), version(), pg_sleep(2) [8460] DBIx::HA:st: *** EXECUTION TIMED OUT in dbi:Pg: ; SQL: SELECT current_database(), version(), pg_sleep(2) at /usr/local/share/perl/5.22.1/DBIx/HA.pm line 549. DBD::Pg::st fetchrow_array failed: no statement executing at dbixhabug.pl line 40. DBD::Pg::st fetchrow_array failed: no statement executing at dbixhabug.pl line 40. TEST SQL: SELECT current_database(), version(), pg_sleep(2) ROW: filip PostgreSQL 9.6.4 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.4) 5.4.0 20160609, 64-bit TEST SQL: SELECT current_database(), version(), pg_sleep(2) ROW: filip PostgreSQL 9.6.4 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.4) 5.4.0 20160609, 64-bit TEST SQL: SELECT current_database(), version(), pg_sleep(2) ROW: filip PostgreSQL 9.6.4 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.4) 5.4.0 20160609, 64-bit TEST SQL: SELECT current_database(), version(), pg_sleep(2) ROW: filip PostgreSQL 9.6.4 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.4) 5.4.0 20160609, 64-bit TEST SQL: SELECT current_database(), version(), pg_sleep(2) Tested on 2 Linux platforms, they had also different DBI & DBD::Pg versions: 1) This is perl 5, version 18, subversion 2 (v5.18.2) built for x86_64-linux-thread-multi openSUSE Leap 42.1 (x86_64) Linux 4.1.39-56-default #1 SMP PREEMPT 2) This is perl 5, version 22, subversion 1 (v5.22.1) built for x86_64-linux-gnu-thread-multi Ubuntu 16.04.3 LTS Linux 4.4.0-92-generic #115-Ubuntu SMP Thu Aug 10 09:04:33 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux -- Filip Rembiałkowski PostgreSQL DBA [image: Where 2 Get It Logo]
Download dbixhabug.pl
text/x-perl 752b

Message body is not shown because sender requested not to inline it.

CC: hasseily [...] cpan.org
Subject: Re: [rt.cpan.org #122897] Bug in DBIx::HA
Date: Fri, 25 Aug 2017 12:22:49 -0400
To: Filip Rembiałkowski via RT <bug-DBIx-HA [...] rt.cpan.org>
From: Mark Stosberg <mark [...] stosberg.com>
Download (untitled) / with headers
text/plain 321b
I got a new job that doesn't use Perl and am no longer maintaining this module. Henri Asseily (HASSEILY) is also listed as a maintainer, but I'm not if he's maintaining it either. If he doesn't respond after a few days, I'll see if I can give you co-maintainer status if I'm able and if you are interested. Mark


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.