This could be connection timeout. If this is case, use Reconnect plugin.
-- HtH, Sergey (from mobile)
12 марта 2014 г. 4:32 пользователь "Neil Watson" <[email protected]>
написал:
> Howdy,
>
> I'm learning and prototyping with mojo lite. I'm getting a db connection
> error but I don't know why.
>
> Error:
> DBD::Pg::st execute failed: Cannot call execute on a disconnected
> database handle at DReport.pl line 24.
> Line 24 is at the end of the excerpt below. There was no die from
> DBI->connect yet the error indicates no connection. I have another,
> unrelated, script that uses the same connect code and credentials and it
> works just fine. What have I done wrong?
>
> use Mojolicious::Lite;
> use DBI;
>
> my $db_name = "postgres";
> my $db_user = "postgres";
> my $db_pass = "";
> my $db_host = "127.0.0.1";
> my $table = "cf_status_log";
>
> my $dbh = DBI->connect(
> "DBI:Pg:dbname=$db_name; host=$db_host",
> "$db_user", "$db_pass",
> { RaiseError => 1 }
> ) or die "Could not connec to database";
>
> helper db => sub { $dbh };
>
> helper inventory => sub
> {
> my $self = shift;
> my $result = eval { $self->db->prepare( "SELECT * FROM
> dr_inventory_classes" ) };
> my $number_of_records = $result->execute(); # <<<< Line 24
>
> --
> Neil Watson
> Linux/UNIX Consultant
> http://watson-wilson.ca
>
> --
> You received this message because you are subscribed to the Google Groups
> "Mojolicious" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To post to this group, send email to [email protected].
> Visit this group at http://groups.google.com/group/mojolicious.
> For more options, visit https://groups.google.com/d/optout.
>
--
You received this message because you are subscribed to the Google Groups
"Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.
