Hello
please take a look at the code and log given below, which I also pasted
here: http://scsys.co.uk:8002/288007.
This is my excersise on making many ->pg() calls in one request. It seems
that on first and second step two different database connections are made,
and for each remaining step these two connections are picked alternatively.
This is not what I want if I, for instance, need AutoCommit = 0 or need to
use temp tables. So I need to make sure the same database connection is
used all the time.
What am I doing wrong?
Thanks,
Irek.
__CODE__
#!/usr/bin/env perl
use Mojolicious::Lite;
use Mojo::IOLoop;
plugin PgAsync => {dbi => ['dbi:Pg:service=vtest']};
get '/steps/:cnt' => sub {
my $self = shift;
$self->render_later;
my $cnt = 0;
my $step =
sub {
my $delay = shift;
$self->pg(
"SELECT pg_sleep(1)",
sub {
my $dbh = shift->dbh;
$self->app->log->debug("step ".++$cnt.": \\$dbh");
$delay->begin->()
}
);
};
my $delay = Mojo::IOLoop->delay;
$delay->steps(
( map { $step } 1..$self->stash('cnt') ),
sub {
my $delay = shift;
$self->render( text => "finished\n" );
}
);
};
app->start;
__END__
$ MOJO_INACTIVITY_TIMEOUT=200 DBI_TRACE=0 ./pg_steps get /steps/33 2>&1
[Sat Dec 28 23:44:56 2013] [debug] Your secret passphrase needs to be changed!!!
[Sat Dec 28 23:44:56 2013] [debug] GET /steps/33 (Mojolicious (Perl)).
[Sat Dec 28 23:44:56 2013] [debug] Routing to a callback.
[Sat Dec 28 23:44:57 2013] [debug] step 1: \DBI::db=HASH(0x804b7ab40)
[Sat Dec 28 23:44:58 2013] [debug] step 2: \DBI::db=HASH(0x804b84720)
[Sat Dec 28 23:44:59 2013] [debug] step 3: \DBI::db=HASH(0x804b7ab40)
[Sat Dec 28 23:45:00 2013] [debug] step 4: \DBI::db=HASH(0x804b84720)
[Sat Dec 28 23:45:01 2013] [debug] step 5: \DBI::db=HASH(0x804b7ab40)
[Sat Dec 28 23:45:02 2013] [debug] step 6: \DBI::db=HASH(0x804b84720)
[Sat Dec 28 23:45:03 2013] [debug] step 7: \DBI::db=HASH(0x804b7ab40)
[Sat Dec 28 23:45:04 2013] [debug] step 8: \DBI::db=HASH(0x804b84720)
[Sat Dec 28 23:45:05 2013] [debug] step 9: \DBI::db=HASH(0x804b7ab40)
[Sat Dec 28 23:45:06 2013] [debug] step 10: \DBI::db=HASH(0x804b84720)
[Sat Dec 28 23:45:07 2013] [debug] step 11: \DBI::db=HASH(0x804b7ab40)
[Sat Dec 28 23:45:08 2013] [debug] step 12: \DBI::db=HASH(0x804b84720)
[Sat Dec 28 23:45:09 2013] [debug] step 13: \DBI::db=HASH(0x804b7ab40)
[Sat Dec 28 23:45:10 2013] [debug] step 14: \DBI::db=HASH(0x804b84720)
[Sat Dec 28 23:45:11 2013] [debug] step 15: \DBI::db=HASH(0x804b7ab40)
[Sat Dec 28 23:45:12 2013] [debug] step 16: \DBI::db=HASH(0x804b84720)
[Sat Dec 28 23:45:13 2013] [debug] step 17: \DBI::db=HASH(0x804b7ab40)
[Sat Dec 28 23:45:14 2013] [debug] step 18: \DBI::db=HASH(0x804b84720)
[Sat Dec 28 23:45:15 2013] [debug] step 19: \DBI::db=HASH(0x804b7ab40)
[Sat Dec 28 23:45:16 2013] [debug] step 20: \DBI::db=HASH(0x804b84720)
[Sat Dec 28 23:45:17 2013] [debug] step 21: \DBI::db=HASH(0x804b7ab40)
[Sat Dec 28 23:45:18 2013] [debug] step 22: \DBI::db=HASH(0x804b84720)
[Sat Dec 28 23:45:19 2013] [debug] step 23: \DBI::db=HASH(0x804b7ab40)
[Sat Dec 28 23:45:20 2013] [debug] step 24: \DBI::db=HASH(0x804b84720)
[Sat Dec 28 23:45:21 2013] [debug] step 25: \DBI::db=HASH(0x804b7ab40)
[Sat Dec 28 23:45:22 2013] [debug] step 26: \DBI::db=HASH(0x804b84720)
[Sat Dec 28 23:45:23 2013] [debug] step 27: \DBI::db=HASH(0x804b7ab40)
[Sat Dec 28 23:45:24 2013] [debug] step 28: \DBI::db=HASH(0x804b84720)
[Sat Dec 28 23:45:25 2013] [debug] step 29: \DBI::db=HASH(0x804b7ab40)
[Sat Dec 28 23:45:26 2013] [debug] step 30: \DBI::db=HASH(0x804b84720)
[Sat Dec 28 23:45:27 2013] [debug] step 31: \DBI::db=HASH(0x804b7ab40)
[Sat Dec 28 23:45:28 2013] [debug] step 32: \DBI::db=HASH(0x804b84720)
[Sat Dec 28 23:45:29 2013] [debug] step 33: \DBI::db=HASH(0x804b7ab40)
[Sat Dec 28 23:45:29 2013] [debug] 200 OK (33.870040s, 0.030/s).
finished
$ MOJO_INACTIVITY_TIMEOUT=200 DBI_TRACE=1 ./pg_steps get /steps/33 2>&1
DBI 1.617-nothread default trace level set to 0x0/1 (pid 69568 pi 0) at
DBI.pm line 277 via DBI.pm line 0
[Sat Dec 28 23:45:38 2013] [debug] Your secret passphrase needs to be changed!!!
[Sat Dec 28 23:45:38 2013] [debug] GET /steps/33 (Mojolicious (Perl)).
[Sat Dec 28 23:45:38 2013] [debug] Routing to a callback.
-> DBI->connect(dbi:Pg:service=vtest, , ****)
-> DBI->install_driver(Pg) for freebsd perl=5.014002 pid=69568 ruid=1001
euid=1001
install_driver: DBD::Pg version 2.18.1 loaded from
/usr/local/perl-5.14.2/lib/site_perl/5.14.2/amd64-freebsd/DBD/Pg.pm
<- install_driver= DBI::dr=HASH(0x804b75138)
!! warn: 0 CLEARED by call to default_user method
<- default_user(undef, undef, ...)= ( undef undef ) [2 items] at DBI.pm
line 647
<- connect('service=vtest', undef, ...)= ( DBI::db=HASH(0x804b7bbe8) ) [1
items] at DBI.pm line 659
<- STORE('PrintError', 1)= ( 1 ) [1 items] at DBI.pm line 711
<- STORE('AutoCommit', 1)= ( 1 ) [1 items] at DBI.pm line 711
<- STORE('Username', undef)= ( 1 ) [1 items] at DBI.pm line 714
<- connected('dbi:Pg:service=vtest')= ( undef ) [1 items] at DBI.pm line 721
<- connect= DBI::db=HASH(0x804b7bbe8)
<- STORE('dbi_connect_closure', CODE(0x804b7b390))= ( 1 ) [1 items] at
DBI.pm line 730
<- FETCH('pg_socket')= ( 6 ) [1 items] at Handle.pm line 363
<- prepare('SELECT pg_sleep(1)', HASH(0x804b74948))= (
DBI::st=HASH(0x804b86270) ) [1 items] at Db.pm line 63
Early return for async query <- execute= ( '0E0' ) [1 items] at Db.pm line 64
<- pg_result= ( 1 ) [1 items] at Db.pm line 41
[Sat Dec 28 23:45:39 2013] [debug] step 1: \DBI::db=HASH(0x804b7bbe8)
-> DBI->connect(dbi:Pg:service=vtest, , ****)
<- default_user(undef, undef, ...)= ( undef undef ) [2 items] at DBI.pm
line 647
<- connect('service=vtest', undef, ...)= ( DBI::db=HASH(0x804b867c8) ) [1
items] at DBI.pm line 659
<- STORE('PrintError', 1)= ( 1 ) [1 items] at DBI.pm line 711
<- STORE('AutoCommit', 1)= ( 1 ) [1 items] at DBI.pm line 711
<- STORE('Username', undef)= ( 1 ) [1 items] at DBI.pm line 714
<- connected('dbi:Pg:service=vtest')= ( undef ) [1 items] at DBI.pm line 721
<- connect= DBI::db=HASH(0x804b867c8)
<- STORE('dbi_connect_closure', CODE(0x804b71cd8))= ( 1 ) [1 items] at
DBI.pm line 730
<- FETCH('pg_socket')= ( 7 ) [1 items] at Handle.pm line 363
<- prepare('SELECT pg_sleep(1)', HASH(0x804b71ca8))= (
DBI::st=HASH(0x804b86f78) ) [1 items] at Db.pm line 63
Early return for async query <- execute= ( '0E0' ) [1 items] at Db.pm line 64
<- pg_result= ( 1 ) [1 items] at Db.pm line 41
[Sat Dec 28 23:45:40 2013] [debug] step 2: \DBI::db=HASH(0x804b867c8)
<- prepare('SELECT pg_sleep(1)', HASH(0x80344c450))= (
DBI::st=HASH(0x804b3f918) ) [1 items] at Db.pm line 63
<- DESTROY(DBI::st=HASH(0x804b86210))= ( undef ) [1 items] at (eval 245)
line 7
Early return for async query <- execute= ( '0E0' ) [1 items] at Db.pm line 64
<- pg_result= ( 1 ) [1 items] at Db.pm line 41
[Sat Dec 28 23:45:41 2013] [debug] step 3: \DBI::db=HASH(0x804b7bbe8)
<- prepare('SELECT pg_sleep(1)', HASH(0x804b3c0f0))= (
DBI::st=HASH(0x804b86f60) ) [1 items] at Db.pm line 63
<- DESTROY(DBI::st=HASH(0x804b86f30))= ( undef ) [1 items] at (eval 245)
line 7
Early return for async query <- execute= ( '0E0' ) [1 items] at Db.pm line 64
<- pg_result= ( 1 ) [1 items] at Db.pm line 41
[Sat Dec 28 23:45:42 2013] [debug] step 4: \DBI::db=HASH(0x804b867c8)
<- prepare('SELECT pg_sleep(1)', HASH(0x804b6ca80))= (
DBI::st=HASH(0x804b89510) ) [1 items] at Db.pm line 63
<- DESTROY(DBI::st=HASH(0x804b71ab0))= ( undef ) [1 items] at (eval 245)
line 7
Early return for async query <- execute= ( '0E0' ) [1 items] at Db.pm line 64
<- pg_result= ( 1 ) [1 items] at Db.pm line 41
[Sat Dec 28 23:45:43 2013] [debug] step 5: \DBI::db=HASH(0x804b7bbe8)
<- prepare('SELECT pg_sleep(1)', HASH(0x804b71930))= (
DBI::st=HASH(0x804b89570) ) [1 items] at Db.pm line 63
<- DESTROY(DBI::st=HASH(0x804b74510))= ( undef ) [1 items] at (eval 245)
line 7
Early return for async query <- execute= ( '0E0' ) [1 items] at Db.pm line 64
<- pg_result= ( 1 ) [1 items] at Db.pm line 41
[Sat Dec 28 23:45:44 2013] [debug] step 6: \DBI::db=HASH(0x804b867c8)
<- prepare('SELECT pg_sleep(1)', HASH(0x804b893a8))= (
DBI::st=HASH(0x804b89198) ) [1 items] at Db.pm line 63
<- DESTROY(DBI::st=HASH(0x804b89588))= ( undef ) [1 items] at (eval 245)
line 7
Early return for async query <- execute= ( '0E0' ) [1 items] at Db.pm line 64
<- pg_result= ( 1 ) [1 items] at Db.pm line 41
[Sat Dec 28 23:45:45 2013] [debug] step 7: \DBI::db=HASH(0x804b7bbe8)
<- prepare('SELECT pg_sleep(1)', HASH(0x804b07ab0))= (
DBI::st=HASH(0x804b86360) ) [1 items] at Db.pm line 63
<- DESTROY(DBI::st=HASH(0x804b892b8))= ( undef ) [1 items] at (eval 245)
line 7
Early return for async query <- execute= ( '0E0' ) [1 items] at Db.pm line 64
<- pg_result= ( 1 ) [1 items] at Db.pm line 41
[Sat Dec 28 23:45:46 2013] [debug] step 8: \DBI::db=HASH(0x804b867c8)
<- prepare('SELECT pg_sleep(1)', HASH(0x804b891f8))= (
DBI::st=HASH(0x804b89048) ) [1 items] at Db.pm line 63
<- DESTROY(DBI::st=HASH(0x804b892e8))= ( undef ) [1 items] at (eval 245)
line 7
Early return for async query <- execute= ( '0E0' ) [1 items] at Db.pm line 64
<- pg_result= ( 1 ) [1 items] at Db.pm line 41
[Sat Dec 28 23:45:47 2013] [debug] step 9: \DBI::db=HASH(0x804b7bbe8)
<- prepare('SELECT pg_sleep(1)', HASH(0x804b86888))= (
DBI::st=HASH(0x804b71c30) ) [1 items] at Db.pm line 63
<- DESTROY(DBI::st=HASH(0x804b744f8))= ( undef ) [1 items] at (eval 245)
line 7
Early return for async query <- execute= ( '0E0' ) [1 items] at Db.pm line 64
<- pg_result= ( 1 ) [1 items] at Db.pm line 41
[Sat Dec 28 23:45:48 2013] [debug] step 10: \DBI::db=HASH(0x804b867c8)
<- prepare('SELECT pg_sleep(1)', HASH(0x804b718d0))= (
DBI::st=HASH(0x804b89540) ) [1 items] at Db.pm line 63
<- DESTROY(DBI::st=HASH(0x804b891b0))= ( undef ) [1 items] at (eval 245)
line 7
Early return for async query <- execute= ( '0E0' ) [1 items] at Db.pm line 64
<- pg_result= ( 1 ) [1 items] at Db.pm line 41
[Sat Dec 28 23:45:49 2013] [debug] step 11: \DBI::db=HASH(0x804b7bbe8)
<- prepare('SELECT pg_sleep(1)', HASH(0x804b74498))= (
DBI::st=HASH(0x804b71918) ) [1 items] at Db.pm line 63
<- DESTROY(DBI::st=HASH(0x8045e3e58))= ( undef ) [1 items] at (eval 245)
line 7
Early return for async query <- execute= ( '0E0' ) [1 items] at Db.pm line 64
<- pg_result= ( 1 ) [1 items] at Db.pm line 41
[Sat Dec 28 23:45:50 2013] [debug] step 12: \DBI::db=HASH(0x804b867c8)
<- prepare('SELECT pg_sleep(1)', HASH(0x804b894f8))= (
DBI::st=HASH(0x804b89390) ) [1 items] at Db.pm line 63
<- DESTROY(DBI::st=HASH(0x804b89060))= ( undef ) [1 items] at (eval 245)
line 7
Early return for async query <- execute= ( '0E0' ) [1 items] at Db.pm line 64
<- pg_result= ( 1 ) [1 items] at Db.pm line 41
[Sat Dec 28 23:45:51 2013] [debug] step 13: \DBI::db=HASH(0x804b7bbe8)
<- prepare('SELECT pg_sleep(1)', HASH(0x804b89558))= (
DBI::st=HASH(0x804b74540) ) [1 items] at Db.pm line 63
<- DESTROY(DBI::st=HASH(0x804b71c00))= ( undef ) [1 items] at (eval 245)
line 7
Early return for async query <- execute= ( '0E0' ) [1 items] at Db.pm line 64
<- pg_result= ( 1 ) [1 items] at Db.pm line 41
[Sat Dec 28 23:45:52 2013] [debug] step 14: \DBI::db=HASH(0x804b867c8)
<- prepare('SELECT pg_sleep(1)', HASH(0x804b71a08))= (
DBI::st=HASH(0x804b3aea0) ) [1 items] at Db.pm line 63
<- DESTROY(DBI::st=HASH(0x804b89168))= ( undef ) [1 items] at (eval 245)
line 7
Early return for async query <- execute= ( '0E0' ) [1 items] at Db.pm line 64
<- pg_result= ( 1 ) [1 items] at Db.pm line 41
[Sat Dec 28 23:45:53 2013] [debug] step 15: \DBI::db=HASH(0x804b7bbe8)
<- prepare('SELECT pg_sleep(1)', HASH(0x804b894b0))= (
DBI::st=HASH(0x804b71cc0) ) [1 items] at Db.pm line 63
<- DESTROY(DBI::st=HASH(0x804b86210))= ( undef ) [1 items] at (eval 245)
line 7
Early return for async query <- execute= ( '0E0' ) [1 items] at Db.pm line 64
<- pg_result= ( 1 ) [1 items] at Db.pm line 41
[Sat Dec 28 23:45:54 2013] [debug] step 16: \DBI::db=HASH(0x804b867c8)
<- prepare('SELECT pg_sleep(1)', HASH(0x8027fbb58))= (
DBI::st=HASH(0x80344c450) ) [1 items] at Db.pm line 63
<- DESTROY(DBI::st=HASH(0x804b863f0))= ( undef ) [1 items] at (eval 245)
line 7
Early return for async query <- execute= ( '0E0' ) [1 items] at Db.pm line 64
<- pg_result= ( 1 ) [1 items] at Db.pm line 41
[Sat Dec 28 23:45:55 2013] [debug] step 17: \DBI::db=HASH(0x804b7bbe8)
<- prepare('SELECT pg_sleep(1)', HASH(0x804b719d8))= (
DBI::st=HASH(0x804b3c0f0) ) [1 items] at Db.pm line 63
<- DESTROY(DBI::st=HASH(0x804b890f0))= ( undef ) [1 items] at (eval 245)
line 7
Early return for async query <- execute= ( '0E0' ) [1 items] at Db.pm line 64
<- pg_result= ( 1 ) [1 items] at Db.pm line 41
[Sat Dec 28 23:45:57 2013] [debug] step 18: \DBI::db=HASH(0x804b867c8)
<- prepare('SELECT pg_sleep(1)', HASH(0x804b89480))= (
DBI::st=HASH(0x804b6ca80) ) [1 items] at Db.pm line 63
<- DESTROY(DBI::st=HASH(0x804b3c030))= ( undef ) [1 items] at (eval 245)
line 7
Early return for async query <- execute= ( '0E0' ) [1 items] at Db.pm line 64
<- pg_result= ( 1 ) [1 items] at Db.pm line 41
[Sat Dec 28 23:45:58 2013] [debug] step 19: \DBI::db=HASH(0x804b7bbe8)
<- prepare('SELECT pg_sleep(1)', HASH(0x804b745e8))= (
DBI::st=HASH(0x804b71930) ) [1 items] at Db.pm line 63
<- DESTROY(DBI::st=HASH(0x804b892a0))= ( undef ) [1 items] at (eval 245)
line 7
Early return for async query <- execute= ( '0E0' ) [1 items] at Db.pm line 64
<- pg_result= ( 1 ) [1 items] at Db.pm line 41
[Sat Dec 28 23:45:59 2013] [debug] step 20: \DBI::db=HASH(0x804b867c8)
<- prepare('SELECT pg_sleep(1)', HASH(0x804b719a8))= (
DBI::st=HASH(0x804b893a8) ) [1 items] at Db.pm line 63
<- DESTROY(DBI::st=HASH(0x804b743f0))= ( undef ) [1 items] at (eval 245)
line 7
Early return for async query <- execute= ( '0E0' ) [1 items] at Db.pm line 64
<- pg_result= ( 1 ) [1 items] at Db.pm line 41
[Sat Dec 28 23:46:00 2013] [debug] step 21: \DBI::db=HASH(0x804b7bbe8)
<- prepare('SELECT pg_sleep(1)', HASH(0x804b89450))= (
DBI::st=HASH(0x804b07ab0) ) [1 items] at Db.pm line 63
<- DESTROY(DBI::st=HASH(0x804b89030))= ( undef ) [1 items] at (eval 245)
line 7
Early return for async query <- execute= ( '0E0' ) [1 items] at Db.pm line 64
<- pg_result= ( 1 ) [1 items] at Db.pm line 41
[Sat Dec 28 23:46:01 2013] [debug] step 22: \DBI::db=HASH(0x804b867c8)
<- prepare('SELECT pg_sleep(1)', HASH(0x804b745b8))= (
DBI::st=HASH(0x804b891f8) ) [1 items] at Db.pm line 63
<- DESTROY(DBI::st=HASH(0x804b71c48))= ( undef ) [1 items] at (eval 245)
line 7
Early return for async query <- execute= ( '0E0' ) [1 items] at Db.pm line 64
<- pg_result= ( 1 ) [1 items] at Db.pm line 41
[Sat Dec 28 23:46:02 2013] [debug] step 23: \DBI::db=HASH(0x804b7bbe8)
<- prepare('SELECT pg_sleep(1)', HASH(0x804b89228))= (
DBI::st=HASH(0x804b86888) ) [1 items] at Db.pm line 63
<- DESTROY(DBI::st=HASH(0x804b71a50))= ( undef ) [1 items] at (eval 245)
line 7
Early return for async query <- execute= ( '0E0' ) [1 items] at Db.pm line 64
<- pg_result= ( 1 ) [1 items] at Db.pm line 41
[Sat Dec 28 23:46:03 2013] [debug] step 24: \DBI::db=HASH(0x804b867c8)
<- prepare('SELECT pg_sleep(1)', HASH(0x804b86318))= (
DBI::st=HASH(0x804b718d0) ) [1 items] at Db.pm line 63
<- DESTROY(DBI::st=HASH(0x804b894e0))= ( undef ) [1 items] at (eval 245)
line 7
Early return for async query <- execute= ( '0E0' ) [1 items] at Db.pm line 64
<- pg_result= ( 1 ) [1 items] at Db.pm line 41
[Sat Dec 28 23:46:04 2013] [debug] step 25: \DBI::db=HASH(0x804b7bbe8)
<- prepare('SELECT pg_sleep(1)', HASH(0x8027fbbb8))= (
DBI::st=HASH(0x804b74498) ) [1 items] at Db.pm line 63
<- DESTROY(DBI::st=HASH(0x804b89330))= ( undef ) [1 items] at (eval 245)
line 7
Early return for async query <- execute= ( '0E0' ) [1 items] at Db.pm line 64
<- pg_result= ( 1 ) [1 items] at Db.pm line 41
[Sat Dec 28 23:46:05 2013] [debug] step 26: \DBI::db=HASH(0x804b867c8)
<- prepare('SELECT pg_sleep(1)', HASH(0x804b86fd8))= (
DBI::st=HASH(0x804b894f8) ) [1 items] at Db.pm line 63
<- DESTROY(DBI::st=HASH(0x804b74618))= ( undef ) [1 items] at (eval 245)
line 7
Early return for async query <- execute= ( '0E0' ) [1 items] at Db.pm line 64
<- pg_result= ( 1 ) [1 items] at Db.pm line 41
[Sat Dec 28 23:46:06 2013] [debug] step 27: \DBI::db=HASH(0x804b7bbe8)
<- prepare('SELECT pg_sleep(1)', HASH(0x804b86f00))= (
DBI::st=HASH(0x804b89558) ) [1 items] at Db.pm line 63
<- DESTROY(DBI::st=HASH(0x804b71900))= ( undef ) [1 items] at (eval 245)
line 7
Early return for async query <- execute= ( '0E0' ) [1 items] at Db.pm line 64
<- pg_result= ( 1 ) [1 items] at Db.pm line 41
[Sat Dec 28 23:46:07 2013] [debug] step 28: \DBI::db=HASH(0x804b867c8)
<- prepare('SELECT pg_sleep(1)', HASH(0x804b71c60))= (
DBI::st=HASH(0x804b71a08) ) [1 items] at Db.pm line 63
<- DESTROY(DBI::st=HASH(0x804b89378))= ( undef ) [1 items] at (eval 245)
line 7
Early return for async query <- execute= ( '0E0' ) [1 items] at Db.pm line 64
<- pg_result= ( 1 ) [1 items] at Db.pm line 41
[Sat Dec 28 23:46:08 2013] [debug] step 29: \DBI::db=HASH(0x804b7bbe8)
<- prepare('SELECT pg_sleep(1)', HASH(0x8045e3dc8))= (
DBI::st=HASH(0x804b894b0) ) [1 items] at Db.pm line 63
<- DESTROY(DBI::st=HASH(0x804b6c018))= ( undef ) [1 items] at (eval 245)
line 7
Early return for async query <- execute= ( '0E0' ) [1 items] at Db.pm line 64
<- pg_result= ( 1 ) [1 items] at Db.pm line 41
[Sat Dec 28 23:46:09 2013] [debug] step 30: \DBI::db=HASH(0x804b867c8)
<- prepare('SELECT pg_sleep(1)', HASH(0x804b86f78))= (
DBI::st=HASH(0x8027fbb58) ) [1 items] at Db.pm line 63
<- DESTROY(DBI::st=HASH(0x804b71a20))= ( undef ) [1 items] at (eval 245)
line 7
Early return for async query <- execute= ( '0E0' ) [1 items] at Db.pm line 64
<- pg_result= ( 1 ) [1 items] at Db.pm line 41
[Sat Dec 28 23:46:10 2013] [debug] step 31: \DBI::db=HASH(0x804b7bbe8)
<- prepare('SELECT pg_sleep(1)', HASH(0x804b3f918))= (
DBI::st=HASH(0x804b719d8) ) [1 items] at Db.pm line 63
<- DESTROY(DBI::st=HASH(0x804b894c8))= ( undef ) [1 items] at (eval 245)
line 7
Early return for async query <- execute= ( '0E0' ) [1 items] at Db.pm line 64
<- pg_result= ( 1 ) [1 items] at Db.pm line 41
[Sat Dec 28 23:46:11 2013] [debug] step 32: \DBI::db=HASH(0x804b867c8)
<- prepare('SELECT pg_sleep(1)', HASH(0x804b86f60))= (
DBI::st=HASH(0x804b89480) ) [1 items] at Db.pm line 63
<- DESTROY(DBI::st=HASH(0x804b358a0))= ( undef ) [1 items] at (eval 245)
line 7
Early return for async query <- execute= ( '0E0' ) [1 items] at Db.pm line 64
<- pg_result= ( 1 ) [1 items] at Db.pm line 41
[Sat Dec 28 23:46:12 2013] [debug] step 33: \DBI::db=HASH(0x804b7bbe8)
[Sat Dec 28 23:46:12 2013] [debug] 200 OK (34.071716s, 0.029/s).
finished
<- disconnect_all= ( '' ) [1 items] at DBI.pm line 738
! <- DESTROY(DBI::st=HASH(0x804b719f0))= ( undef ) [1 items] during global
destruction
! <- DESTROY(DBI::st=HASH(0x804b89498))= ( undef ) [1 items] during global
destruction
! <- DESTROY(DBI::db=HASH(0x804b86708))= ( undef ) [1 items] during global
destruction
! <- DESTROY(DBI::db=HASH(0x804b7bb10))= ( undef ) [1 items] during global
destruction
! <- DESTROY(DBI::dr=HASH(0x804b75138))= ( undef ) [1 items] during global
destruction
--
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/groups/opt_out.
