perl-DBIx-RetryOverDisconnects-0.12-alt1.noarch.rpm


Advertisement

Description

perl-DBIx-RetryOverDisconnects - DBI wrapper that helps to deal with databases connection problems

Property Value
Distribution ALT Linux Sisyphus
Repository Autoimports noarch
Package filename perl-DBIx-RetryOverDisconnects-0.12-alt1.noarch.rpm
Package name perl-DBIx-RetryOverDisconnects
Package version 0.12
Package release alt1
Package architecture noarch
Package type rpm
Category Development/Perl
Homepage -
License -
Maintainer -
Download size 17.79 KB
Installed size 17.79 KB
This wrapper intercepts all requests. If some request fails this module
detects the reason of fail. If the reason was database connection problem
then wrapper would automatically reconnect and restart the query. Otherwise
it would rethrow the exception.
If you are not in transaction then you can just do
$dbh->do('...');
$sth->execute(...);
This might have 2 fatal cases:
=over
=item *
SQL error (a good reason to die).
=item *
Reconnect retries limit reached (database is completely down or network failure).
=back
For example, if the connection to database were lost during 'execute' call, the module
would reconnect to database with a timeout 'ReconnectTimeout'. If reconnect failed it
would reconnect again 'ReconnectRetries' times with 'ReconnectInterval' interval
(in seconds). If reconnect retries limit was reached it would raise an error and
$dbh->is_fatal_disconnect would be true.
If you are in transaction then even DB disconnect will raise an error.
But you can check $dbh->is_trans_disconnect and restart the transaction if it is 'true'.
Other possible errors are the same: sql error and reconnect limit.
The recommended way of using transactions is
$dbh->txn_do($code_ref);
because 'txn_do' would automatically restart the transaction if it was failed because
of database disconnect. The transaction can be restarted at most 'TxnRetries' times.
If 'TxnRetries' limit was reached then error would be raised and
$dbh->is_fatal_trans_disconnect set to true.
Other error cases are the same as above.
'txn_do' would try do to rollback if there was a perl or sql error (no rollback needed
when you loose connection to database: DB server already has done it).
Rollback is successul when $@ =~ /Rollback OK/;
Note: For the perfomance reasons, DBI attribute 'RaiseError' is always set to 'true'.

Alternatives

Package Version Architecture Repository
perl-DBIx-RetryOverDisconnects - - -

Requires

Name Value
/usr/share/perl5 -
perl(DBI.pm) >= 1.440
perl(Exception/Class.pm) >= 1.230
perl(base.pm) -
perl(constant.pm) -
rpmlib(PayloadIsLzma) -

Provides

Name Value
perl(DBIx/RetryOverDisconnects.pm) = 0.120
perl-DBIx-RetryOverDisconnects = 0.12-alt1

Download

Type URL
Mirror ftp.altlinux.org
Binary Package perl-DBIx-RetryOverDisconnects-0.12-alt1.noarch.rpm
Source Package perl-DBIx-RetryOverDisconnects-0.12-alt1.src.rpm

Install Howto

  1. Add the following line to /etc/apt/sources.list:
    
    rpm [Sisyphus] http://ftp.altlinux.org/pub/distributions/ALTLinux/autoimports/Sisyphus noarch autoimports
    rpm [Sisyphus] http://ftp.altlinux.org/pub/distributions/ALTLinux/autoimports/Sisyphus noarch autoimports
    
  2. Update the package index:
    # sudo apt-get update
  3. Install perl-DBIx-RetryOverDisconnects rpm package:
    # sudo apt-get install perl-DBIx-RetryOverDisconnects

Files

Path
/usr/share/doc/perl-DBIx-RetryOverDisconnects-0.12/Changes
/usr/share/perl5/DBIx/RetryOverDisconnects.pm

See Also

Package Description
perl-DBIx-RewriteDSN-0.05-alt1.noarch.rpm dsn rewriter for debug
perl-DBIx-RoboQuery-0.032-alt1.noarch.rpm Very configurable/programmable query object
perl-DBIx-Roles-1.04-alt1.noarch.rpm perl module DBIx-Roles
perl-DBIx-Romani-0.0.16-alt1.noarch.rpm Romani is a SQL and database abstraction layer, inspired by Creole, which aims to help adapt to the
perl-DBIx-RunSQL-0.21-alt1_1.noarch.rpm Run SQL to create a database schema
perl-DBIx-SQL-Abstract-0.07-alt1.noarch.rpm perl module DBIx-SQL-Abstract
perl-DBIx-SQLCrosstab-1.17-alt1.noarch.rpm perl module DBIx-SQLCrosstab
perl-DBIx-SQLite-Deploy-0.011-alt1.noarch.rpm Easy SQLite deployment
perl-DBIx-SQLite-Simple-0.35-alt1_4.noarch.rpm Superclass only used to handle SQL tables
perl-DBIx-Schema-Annotate-0.06-alt1.noarch.rpm Add table schema as comment to your ORM file. This module is inspired by annotate_models
perl-DBIx-Schema-Changelog-0.9.0-alt2.noarch.rpm Continuous Database Migration
perl-DBIx-Schema-Changelog-scripts-0.9.0-alt2.noarch.rpm DBIx-Schema-Changelog scripts
perl-DBIx-Schema-DSL-1.0000-alt1.noarch.rpm DSL for Database schema declaration
perl-DBIx-Schema-DSL-Dumper-0.07-alt1.noarch.rpm DBIx::Schema::DSL generator
perl-DBIx-Schema-UpToDate-1.001-alt1.noarch.rpm Helps keep a database schema up to date
Advertisement
Advertisement