DBD::Pg not thread safe ?
Fabien COELHO <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.dbdpg |
|---|---|
| Message-ID | <[email protected]> |
Hello bug-report automaton !
Hello maintainer !
I always run into segmentation faults when running two parallel database
connections in distinct threads. It is not new and was always true, it is
just that today I decided to write a bug report:-)
Version: DBI 1.609, DBD:Pg 2.13.1
Perl: v5.10.0 built for i486-linux-gnu-thread-multi
OS: Linux Ubuntu Karmic (9.10)
libpq: 8.4.2
With pg_comparator (http://www.coelho.net/pg_comparator) using the
-T (thread option). The script creates two threads which perform queries
in parallel on two distinct connections. This result in:
...
Can't call do method on handle DBI::db=HASH(0xb6c1a238) after take_imp_data() at ./pg_comparator line 789.
...
Use of uninitialized value in subroutine entry at ./pg_comparator line 789.
Segmentation fault
line 789 is : return $dbh->do($query);
query is (from the debug output, if I'm not mistaken about the thread) :
CREATE TEMPORARY TABLE cmp_2_1 AS
SELECT idc & 0 AS idc, xor(cks) AS cks
FROM cmp_2_0 GROUP BY idc & 0
Sorry, no time for a "minimal" or even "small" example... However you can
find attached a DBI level 10 trace with and without threads. Only the
threaded version does a segmentation fault.
Repeat: with pg_comparator (http://coelho.net/pg_comparator), load
extensions (see INSTALL) and then run on a table in a base by
substitutuing login, password, host, base, table, pkey, other, cols
according to your setting...
sh> DBI_TRACE=10 pg_comparator -v -v -v -T \
login:password@host/base/table?pkey:other,cols \
login:password@host/base/table?pkey:other,cols
...
lots of stuff, see trace...
...
segmentation fault
Note that it works fine when the -T option is removed, so there is a
workaround which is not to use threads. Possibly the issue is in libpq
which may not be thread safe under some conditions, but this is not
expected. I tested:
sh> cat test.c
#include<stdio.h>
#include "libpq-fe.h"
int main(void) {
fprintf(stdout, "thread safety is %d\n", PQisthreadsafe());
return 0;
}
sh> gcc -I/usr/include/postgresql -lpq test.c
sh> ./a.out
thread safety is 1
--
Fabien COELHO.
dbi_trace_thread.log
(text/plain, 39.5 KB)
DBI 1.609-ithread default trace level set to 0x0/10 (pid 27140) at DBI.pm line 273 via pg_comparator line 642
install_method DBI::db::get_info , flags 0x2a00
install_method DBI::db::take_imp_data, flags 0x10000
install_method DBI::db::disconnect , flags 0x10c00
install_method DBI::db::selectrow_array, flags 0x2000
install_method DBI::db::tables , flags 0x2200
install_method DBI::db::quote_identifier, flags 0x0430
install_method DBI::db::clone
install_method DBI::db::quote , flags 0x0430
install_method DBI::db::type_info , flags 0x2200
install_method DBI::db::statistics_info, flags 0xaa00
install_method DBI::db::selectrow_arrayref, flags 0x2000
install_method DBI::db::begin_work , flags 0x0400
install_method DBI::db::last_insert_id, flags 0x2800
install_method DBI::db::foreign_key_info, flags 0xaa00
install_method DBI::db::primary_key , flags 0x2200
install_method DBI::db::commit , flags 0x0c80
install_method DBI::db::ping , flags 0x0404
install_method DBI::db::selectall_arrayref, flags 0x2000
install_method DBI::db::type_info_all, flags 0x2a00
install_method DBI::db::do , flags 0x3200
install_method DBI::db::selectcol_arrayref, flags 0x2000
install_method DBI::db::prepare_cached, flags 0xa200
install_method DBI::db::rows , flags 0x0004
install_method DBI::db::rollback , flags 0x0c80
install_method DBI::db::column_info , flags 0xaa00
install_method DBI::db::table_info , flags 0xaa00
install_method DBI::db::primary_key_info, flags 0xaa00
install_method DBI::db::prepare , flags 0xa200
install_method DBI::db::preparse
install_method DBI::db::connected , flags 0x0004
install_method DBI::db::data_sources, flags 0x0200
install_method DBI::db::selectall_hashref, flags 0x2000
install_method DBI::db::selectrow_hashref, flags 0x2000
install_method DBI::dr::default_user
install_method DBI::dr::data_sources, flags 0x0800
install_method DBI::dr::dbixs_revision, flags 0x0004
install_method DBI::dr::disconnect_all, flags 0x0800
install_method DBI::dr::connect_cached, flags 0x8000, H 3
install_method DBI::dr::connect , flags 0x8000, H 3
install_method DBI::st::more_results
install_method DBI::st::blob_read
install_method DBI::st::fetchall_hashref
install_method DBI::st::bind_param_inout_array
install_method DBI::st::finish
install_method DBI::st::rows , flags 0x0004
install_method DBI::st::execute_for_fetch, flags 0x5040
install_method DBI::st::fetchrow_hashref
install_method DBI::st::_get_fbav
install_method DBI::st::_set_fbav , T 6
install_method DBI::st::fetchrow
install_method DBI::st::fetch
install_method DBI::st::execute_array, flags 0x5040
install_method DBI::st::dump_results
install_method DBI::st::bind_param_array
install_method DBI::st::fetchrow_array
install_method DBI::st::execute , flags 0x1040
install_method DBI::st::bind_col
install_method DBI::st::fetchall_arrayref
install_method DBI::st::fetchrow_arrayref
install_method DBI::st::bind_param_inout
install_method DBI::st::bind_columns
install_method DBI::st::cancel , flags 0x0800
install_method DBI::st::blob_copy_to_file
install_method DBI::st::bind_param
install_method DBI::common::parse_trace_flag, flags 0x0404, T 8
install_method DBI::common::errstr , flags 0x0004
install_method DBI::common::trace_msg, flags 0x0004, T 8
install_method DBI::common::err , flags 0x0004
install_method DBI::common::CLEAR , flags 0x0004
install_method DBI::common::state , flags 0x0004
install_method DBI::common::_not_impl
install_method DBI::common::NEXTKEY , flags 0x0004
install_method DBI::common::trace , flags 0x0004
install_method DBI::common::debug , flags 0x0004
install_method DBI::common::parse_trace_flags, flags 0x0404, T 8
install_method DBI::common::private_attribute_info
install_method DBI::common::swap_inner_handle
install_method DBI::common::EXISTS , flags 0x0004
install_method DBI::common::visit_child_handles, flags 0x0404, T 4
install_method DBI::common::FETCH , flags 0x0404
install_method DBI::common::FIRSTKEY, flags 0x0004
install_method DBI::common::set_err , flags 0x0010
install_method DBI::common::DESTROY , flags 0x10004
install_method DBI::common::dump_handle, flags 0x0004
install_method DBI::common::FETCH_many, flags 0x0404
install_method DBI::common::can , flags 0x0100
install_method DBI::common::STORE , flags 0x041c
install_method DBI::common::private_data, flags 0x0004
install_method DBI::common::func , flags 0x0006
### user=fabien, pass=XXX, host=localhost, port=5432
### base=fabien, tabl=foo1, keys=id, cols=a1,a0
## connection parameters: fabien XXX localhost 5432 fabien foo1 id a1,a0
### user=fabien, pass=XXX, host=localhost, port=5432
### base=fabien, tabl=foo1, keys=id, cols=a1,a0
## connection parameters: fabien XXX localhost 5432 fabien foo1 id a1,a0
# connection and checksum...
SV = IV(0x88d216c) at 0x88d2170
REFCNT = 1
FLAGS = (IOK,pIOK)
IV = 143885192
CLONE DBI for new thread (dbis 874db60 -> 8938388)
## connecting...
### connecting to s=DBI:Pg:dbname=fabien;host=localhost;port=5432; u=fabien
-> DBI->connect(DBI:Pg:dbname=fabien;host=localhost;port=5432;, fabien, ****, HASH(0x89325d8))
-> DBI->install_driver(Pg) for linux perl=5.010000 pid=27140 ruid=1000 euid=1000
install_driver: DBD::Pg version 2.13.1 loaded from /usr/lib/perl5/DBD/Pg.pm
New 'DBI::dr' (for DBD::Pg::dr, parent='', id=undef)
dbih_setup_handle(DBI::dr=HASH(0x894a678)=>DBI::dr=HASH(0x894a618), DBD::Pg::dr, 0, Null!)
dbih_make_com(Null!, 0, DBD::Pg::dr, 84, 0) thr#8821448
dbih_setup_attrib(DBI::dr=HASH(0x894a618), Err, Null!) SCALAR(0x894a118) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x894a618), State, Null!) SCALAR(0x894a158) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x894a618), Errstr, Null!) SCALAR(0x894a138) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x894a618), TraceLevel, Null!) 0 (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x894a618), FetchHashKeyName, Null!) 'NAME' (already defined)
install_method DBI::db::pg_cancel
install_method DBI::db::pg_endcopy
install_method DBI::db::pg_getline
install_method DBI::db::pg_getcopydata
install_method DBI::db::pg_getcopydata_async
install_method DBI::db::pg_notifies
install_method DBI::db::pg_putcopydata
install_method DBI::db::pg_putcopyend
install_method DBI::db::pg_ping
install_method DBI::db::pg_putline
install_method DBI::db::pg_ready
install_method DBI::db::pg_release
install_method DBI::db::pg_result
install_method DBI::db::pg_rollback_to
install_method DBI::db::pg_savepoint
install_method DBI::db::pg_server_trace
install_method DBI::db::pg_server_untrace
install_method DBI::db::pg_type_info
install_method DBI::st::pg_cancel
install_method DBI::st::pg_result
install_method DBI::st::pg_ready
install_method DBI::db::pg_lo_creat
install_method DBI::db::pg_lo_open
install_method DBI::db::pg_lo_write
install_method DBI::db::pg_lo_read
install_method DBI::db::pg_lo_lseek
install_method DBI::db::pg_lo_tell
install_method DBI::db::pg_lo_close
install_method DBI::db::pg_lo_unlink
install_method DBI::db::pg_lo_import
install_method DBI::db::pg_lo_export
<- install_driver= DBI::dr=HASH(0x894a678)
>> connect DISPATCH (DBI::dr=HASH(0x894a678) rc2/3 @5 g0 ima8001 pid#27140) at /usr/lib/perl5/DBI.pm line 653 via at ./pg_comparator line 1049
!! warn: 0 CLEARED by call to connect method
-> connect for DBD::Pg::dr (DBI::dr=HASH(0x894a678)~0x894a618 'dbname=fabien;host=localhost;port=5432;' 'fabien' **** HASH(0x89016d0)) thr#8821448
# waiting for connexions and counts...
SV = IV(0xb6da6114) at 0xb6da6118
REFCNT = 1
FLAGS = (IOK,pIOK)
IV = -1229752344
CLONE DBI for new thread (dbis 874db60 -> b6b377e8)
## connecting...
### connecting to s=DBI:Pg:dbname=fabien;host=localhost;port=5432; u=fabien
-> DBI->connect(DBI:Pg:dbname=fabien;host=localhost;port=5432;, fabien, ****, HASH(0xb6b318f0))
-> DBI->install_driver(Pg) for linux perl=5.010000 pid=27140 ruid=1000 euid=1000
install_driver: DBD::Pg version 2.13.1 loaded from /usr/lib/perl5/DBD/Pg.pm
New 'DBI::dr' (for DBD::Pg::dr, parent='', id=undef)
dbih_setup_handle(DBI::dr=HASH(0xb6b06a20)=>DBI::dr=HASH(0xb6b069c0), DBD::Pg::dr, 0, Null!)
dbih_make_com(Null!, 0, DBD::Pg::dr, 84, 0) thr#8939bb8
dbih_setup_attrib(DBI::dr=HASH(0xb6b069c0), Err, Null!) SCALAR(0xb6b064c0) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0xb6b069c0), State, Null!) SCALAR(0xb6b06500) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0xb6b069c0), Errstr, Null!) SCALAR(0xb6b064e0) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0xb6b069c0), TraceLevel, Null!) 0 (already defined)
dbih_setup_attrib(DBI::dr=HASH(0xb6b069c0), FetchHashKeyName, Null!) 'NAME' (already defined)
install_method DBI::db::pg_cancel
install_method DBI::db::pg_endcopy
install_method DBI::db::pg_getline
install_method DBI::db::pg_getcopydata
install_method DBI::db::pg_getcopydata_async
install_method DBI::db::pg_notifies
install_method DBI::db::pg_putcopydata
install_method DBI::db::pg_putcopyend
install_method DBI::db::pg_ping
install_method DBI::db::pg_putline
install_method DBI::db::pg_ready
install_method DBI::db::pg_release
install_method DBI::db::pg_result
install_method DBI::db::pg_rollback_to
install_method DBI::db::pg_savepoint
install_method DBI::db::pg_server_trace
install_method DBI::db::pg_server_untrace
install_method DBI::db::pg_type_info
install_method DBI::st::pg_cancel
install_method DBI::st::pg_result
install_method DBI::st::pg_ready
install_method DBI::db::pg_lo_creat
install_method DBI::db::pg_lo_open
install_method DBI::db::pg_lo_write
install_method DBI::db::pg_lo_read
install_method DBI::db::pg_lo_lseek
install_method DBI::db::pg_lo_tell
install_method DBI::db::pg_lo_close
install_method DBI::db::pg_lo_unlink
install_method DBI::db::pg_lo_import
install_method DBI::db::pg_lo_export
<- install_driver= DBI::dr=HASH(0xb6b06a20)
>> connect DISPATCH (DBI::dr=HASH(0xb6b06a20) rc2/3 @5 g0 ima8001 pid#27140) at /usr/lib/perl5/DBI.pm line 653 via at ./pg_comparator line 1049
!! warn: 0 CLEARED by call to connect method
-> connect for DBD::Pg::dr (DBI::dr=HASH(0xb6b06a20)~0xb6b069c0 'dbname=fabien;host=localhost;port=5432;' 'fabien' **** HASH(0xb6dd4b60)) thr#8939bb8
New 'DBI::db' (for DBD::Pg::db, parent=DBI::dr=HASH(0xb6b069c0), id=undef)
dbih_setup_handle(DBI::db=HASH(0xb6b9db10)=>DBI::db=HASH(0xb6b9da60), DBD::Pg::db, b6dc8590, Null!)
dbih_make_com(DBI::dr=HASH(0xb6b069c0), b6b8ba68, DBD::Pg::db, 140, 0) thr#8939bb8
dbih_setup_attrib(DBI::db=HASH(0xb6b9da60), Err, DBI::dr=HASH(0xb6b069c0)) SCALAR(0xb6dc86d0) (already defined)
dbih_setup_attrib(DBI::db=HASH(0xb6b9da60), State, DBI::dr=HASH(0xb6b069c0)) SCALAR(0xb6dcaef0) (already defined)
dbih_setup_attrib(DBI::db=HASH(0xb6b9da60), Errstr, DBI::dr=HASH(0xb6b069c0)) SCALAR(0xb6dcaed0) (already defined)
dbih_setup_attrib(DBI::db=HASH(0xb6b9da60), TraceLevel, DBI::dr=HASH(0xb6b069c0)) 0 (already defined)
dbih_setup_attrib(DBI::db=HASH(0xb6b9da60), FetchHashKeyName, DBI::dr=HASH(0xb6b069c0)) 'NAME' (already defined)
dbih_setup_attrib(DBI::db=HASH(0xb6b9da60), HandleSetErr, DBI::dr=HASH(0xb6b069c0)) undef (not defined)
dbih_setup_attrib(DBI::db=HASH(0xb6b9da60), HandleError, DBI::dr=HASH(0xb6b069c0)) undef (not defined)
dbih_setup_attrib(DBI::db=HASH(0xb6b9da60), ReadOnly, DBI::dr=HASH(0xb6b069c0)) undef (not defined)
dbih_setup_attrib(DBI::db=HASH(0xb6b9da60), Profile, DBI::dr=HASH(0xb6b069c0)) undef (not defined)
Begin dbd_db_login
Login connection string: (dbname=fabien host=localhost port=5432 user='fabien' password='XXX')
PQconnectdb
Connection complete
PQstatus
PQsetNoticeProcessor
PQprotocolVersion
PQserverVersion
End dbd_db_login
>> FETCH DISPATCH (DBI::db=HASH(0xb6b9da60) rc2/1 @2 g0 ima404 pid#27140) at /usr/lib/perl5/DBD/Pg.pm line 225 via at ./pg_comparator line 729
-> FETCH for DBD::Pg::db (DBI::db=HASH(0xb6b9da60)~INNER 'pg_server_version') thr#8939bb8
Begin dbd_db_FETCH (key: pg_server_version)
End dbd_db_FETCH_attrib
<- FETCH= 80402 at /usr/lib/perl5/DBD/Pg.pm line 225 via at ./pg_comparator line 729
>> FETCH DISPATCH (DBI::db=HASH(0xb6b9da60) rc2/1 @2 g0 ima404 pid#27140) at /usr/lib/perl5/DBD/Pg.pm line 226 via at ./pg_comparator line 729
-> FETCH for DBD::Pg::db (DBI::db=HASH(0xb6b9da60)~INNER 'private_dbdpg') thr#8939bb8
Begin dbd_db_FETCH (key: private_dbdpg)
End dbd_db_FETCH_attrib
.. FETCH DBI::db=HASH(0xb6b9da60) 'private_dbdpg' = undef
<- FETCH= undef at /usr/lib/perl5/DBD/Pg.pm line 226 via at ./pg_comparator line 729
>> STORE DISPATCH (DBI::db=HASH(0xb6b9da60) rc2/1 @3 g0 ima41c pid#27140) at /usr/lib/perl5/DBD/Pg.pm line 226 via at ./pg_comparator line 729
-> STORE for DBD::Pg::db (DBI::db=HASH(0xb6b9da60)~INNER 'private_dbdpg' HASH(0xb6b9db30)) thr#8939bb8
Begin dbd_db_STORE (key: private_dbdpg newval: 1 kl:1)
End dbd_db_STORE_attrib
STORE DBI::db=HASH(0xb6b9da60) 'private_dbdpg' => HASH(0xb6b9db30)
<- STORE= 1 at /usr/lib/perl5/DBD/Pg.pm line 226 via at ./pg_comparator line 729
<- connect= DBI::db=HASH(0xb6b9db10) at /usr/lib/perl5/DBI.pm line 653 via at ./pg_comparator line 1049
>> STORE DISPATCH (DBI::db=HASH(0xb6b9da60) rc2/1 @3 g0 ima41c pid#27140) at /usr/lib/perl5/DBI.pm line 705 via at ./pg_comparator line 1049
-> STORE for DBD::Pg::db (DBI::db=HASH(0xb6b9da60)~INNER 'RaiseError' 1) thr#8939bb8
Begin dbd_db_STORE (key: RaiseError newval: 1 kl:2702708)
End dbd_db_STORE_attrib
STORE DBI::db=HASH(0xb6b9da60) 'RaiseError' => 1
<- STORE= 1 at /usr/lib/perl5/DBI.pm line 705 via at ./pg_comparator line 1049
>> STORE DISPATCH (DBI::db=HASH(0xb6b9da60) rc2/1 @3 g0 ima41c pid#27140) at /usr/lib/perl5/DBI.pm line 705 via at ./pg_comparator line 1049
-> STORE for DBD::Pg::db (DBI::db=HASH(0xb6b9da60)~INNER 'PrintError' 0) thr#8939bb8
Begin dbd_db_STORE (key: PrintError newval: 0 kl:2702708)
End dbd_db_STORE_attrib
STORE DBI::db=HASH(0xb6b9da60) 'PrintError' => 0
<- STORE= 1 at /usr/lib/perl5/DBI.pm line 705 via at ./pg_comparator line 1049
>> STORE DISPATCH (DBI::db=HASH(0xb6b9da60) rc2/1 @3 g0 ima41c pid#27140) at /usr/lib/perl5/DBI.pm line 705 via at ./pg_comparator line 1049
-> STORE for DBD::Pg::db (DBI::db=HASH(0xb6b9da60)~INNER 'AutoCommit' 1) thr#8939bb8
Begin dbd_db_STORE (key: AutoCommit newval: 1 kl:2702708)
Begin dbd_db_commit
Begin pg_db_rollback_commit (action: commit AutoCommit: 0 BegunWork: 0)
Begin PGTransactionStatusType
PQtransactionStatus
dbd_db_commit txn_status is 0
End pg_db_rollback_commit (result: 1)
Setting AutoCommit to 'on' forced a commit
End dbd_db_STORE_attrib
<- STORE= 1 at /usr/lib/perl5/DBI.pm line 705 via at ./pg_comparator line 1049
>> STORE DISPATCH (DBI::db=HASH(0xb6b9da60) rc2/1 @3 g0 ima41c pid#27140) at /usr/lib/perl5/DBI.pm line 708 via at ./pg_comparator line 729
-> STORE for DBD::Pg::db (DBI::db=HASH(0xb6b9da60)~INNER 'Username' 'fabien') thr#8939bb8
Begin dbd_db_STORE (key: Username newval: 1 kl:2702708)
End dbd_db_STORE_attrib
STORE DBI::db=HASH(0xb6b9da60) 'Username' => 'fabien'
<- STORE= 1 at /usr/lib/perl5/DBI.pm line 708 via at ./pg_comparator line 729
>> FETCH DISPATCH (DBI::db=HASH(0xb6b9da60) rc2/1 @2 g0 ima404 pid#27140) at /usr/lib/perl5/DBI.pm line 708 via at ./pg_comparator line 1049
<> FETCH= 'fabien' ('Username' from cache) at /usr/lib/perl5/DBI.pm line 708 via at ./pg_comparator line 1049
>> connected DISPATCH (DBI::db=HASH(0xb6b9db10) rc1/1 @5 g0 ima5 pid#27140) at /usr/lib/perl5/DBI.pm line 714 via at ./pg_comparator line 1049
-> connected in DBD::_::db for DBD::Pg::db (DBI::db=HASH(0xb6b9db10)~0xb6b9da60 'DBI:Pg:dbname=fabien;host=localhost;port=5432;' 'fabien' 'XXX' HASH(0xb6b318f0)) thr#8939bb8
<- connected= undef at /usr/lib/perl5/DBI.pm line 714 via at ./pg_comparator line 1049
<- connect= DBI::db=HASH(0xb6b9db10)
>> STORE DISPATCH (DBI::db=HASH(0xb6b9da60) rc2/1 @3 g0 ima41c pid#27140) at /usr/lib/perl5/DBI.pm line 723 via at ./pg_comparator line 729
-> STORE for DBD::Pg::db (DBI::db=HASH(0xb6b9da60)~INNER 'dbi_connect_closure' CODE(0xb6b98ac0)) thr#8939bb8
Begin dbd_db_STORE (key: dbi_connect_closure newval: 1 kl:2702708)
End dbd_db_STORE_attrib
STORE DBI::db=HASH(0xb6b9da60) 'dbi_connect_closure' => CODE(0xb6b98ac0)
<- STORE= 1 at /usr/lib/perl5/DBI.pm line 723 via at ./pg_comparator line 729
## checksumming...
## building checksum table cmp_2_0
### 1 CREATE TEMPORARY TABLE cmp_2_0 AS SELECT COALESCE(id::TEXT,'null') AS id, CKSUM8(COALESCE(id::TEXT,'null')) AS idc,CKSUM8(COALESCE(id::TEXT,'null')||':'||COALESCE(a1::TEXT,'null')||':'||COALESCE(a0::TEXT,'null')) AS cks FROM foo1
>> do DISPATCH (DBI::db=HASH(0xb6b9db10) rc1/3 @2 g0 ima3201 pid#27140) at ./pg_comparator line 789 via at ./pg_comparator line 801
-> do for DBD::Pg::db (DBI::db=HASH(0xb6b9db10)~0xb6b9da60 'CREATE TEMPORARY TABLE cmp_2_0 AS SELECT COALESCE(id::TEXT,'null') AS id, CKSUM8(COALESCE(id::TEXT,'null')) AS idc,CKSUM8(COALESCE(id::TEXT,'null')||':'||COALESCE(a1::TEXT,'null')||':'||COALESCE(a0::TEXT,'null')) AS cks FROM foo1 ') thr#8939bb8
Begin pg_quickexec (query: CREATE TEMPORARY TABLE cmp_2_0 AS SELECT COALESCE(id::TEXT,'null') AS id, CKSUM8(COALESCE(id::TEXT,'null')) AS idc,CKSUM8(COALESCE(id::TEXT,'null')||':'||COALESCE(a1::TEXT,'null')||':'||COALESCE(a0::TEXT,'null')) AS cks FROM foo1 async: 0 async_status: 0)
PQexec
Begin _sqlstate
PQresultStatus
PQresultErrorField
End _sqlstate (imp_dbh->sqlstate: 00000)
Begin PGTransactionStatusType
PQtransactionStatus
_sqlstate txn_status is 0
End _sqlstate (status: 1)
Got a status of 1
PQcmdStatus
PQclear
PQtransactionStatus
End pg_quickexec (rows: 0, txn_status: 0)
<- do= '0E0' at ./pg_comparator line 789 via at ./pg_comparator line 801
>> selectrow_array DISPATCH (DBI::db=HASH(0xb6b9db10) rc1/3 @2 g0 ima2001 pid#27140) at ./pg_comparator line 740 via at ./pg_comparator line 811
-> selectrow_array for DBD::Pg::db (DBI::db=HASH(0xb6b9db10)~0xb6b9da60 'SELECT COUNT(*) FROM cmp_2_0') thr#8939bb8
>> prepare DISPATCH (DBI::db=HASH(0xb6b9da60) rc1/1 @3 g0 imaa201 pid#27140) at ./pg_comparator line 740 via at ./pg_comparator line 811
1 -> prepare for DBD::Pg::db (DBI::db=HASH(0xb6b9da60)~INNER 'SELECT COUNT(*) FROM cmp_2_0' undef) thr#8939bb8
New 'DBI::st' (for DBD::Pg::st, parent=DBI::db=HASH(0xb6b9da60), id=undef)
dbih_setup_handle(DBI::st=HASH(0xb6b9dcf0)=>DBI::st=HASH(0xb6b9dc80), DBD::Pg::st, b6dac168, Null!)
dbih_make_com(DBI::db=HASH(0xb6b9da60), b6b9ebc0, DBD::Pg::st, 200, 0) thr#8939bb8
dbih_setup_attrib(DBI::st=HASH(0xb6b9dc80), Err, DBI::db=HASH(0xb6b9da60)) SCALAR(0xb6dc86d0) (already defined)
dbih_setup_attrib(DBI::st=HASH(0xb6b9dc80), State, DBI::db=HASH(0xb6b9da60)) SCALAR(0xb6dcaef0) (already defined)
dbih_setup_attrib(DBI::st=HASH(0xb6b9dc80), Errstr, DBI::db=HASH(0xb6b9da60)) SCALAR(0xb6dcaed0) (already defined)
dbih_setup_attrib(DBI::st=HASH(0xb6b9dc80), TraceLevel, DBI::db=HASH(0xb6b9da60)) 0 (already defined)
dbih_setup_attrib(DBI::st=HASH(0xb6b9dc80), FetchHashKeyName, DBI::db=HASH(0xb6b9da60)) 'NAME' (already defined)
dbih_setup_attrib(DBI::st=HASH(0xb6b9dc80), HandleSetErr, DBI::db=HASH(0xb6b9da60)) undef (not defined)
dbih_setup_attrib(DBI::st=HASH(0xb6b9dc80), HandleError, DBI::db=HASH(0xb6b9da60)) undef (not defined)
dbih_setup_attrib(DBI::st=HASH(0xb6b9dc80), ReadOnly, DBI::db=HASH(0xb6b9da60)) undef (not defined)
dbih_setup_attrib(DBI::st=HASH(0xb6b9dc80), Profile, DBI::db=HASH(0xb6b9da60)) undef (not defined)
Begin dbd_st_prepare (statement: SELECT COUNT(*) FROM cmp_2_0)
Begin pg_st_split_statement
pg_st_split_statement: (SELECT COUNT(*) FROM cmp_2_0)
Created segment (SELECT COUNT(*) FROM cmp_2_0)
Placeholder type: 0 numsegs: 1 numphs: 0
Placeholder numbers, ph id, and segments:
PH: (0) SEG: (SELECT COUNT(*) FROM cmp_2_0)
Placeholder number, fooname, id:
End pg_st_split_statement
Immediate prepare decision: dml=1 direct=0 server_prepare=1 prepare_now=0 PGLIBVERSION=80307
End dbd_st_prepare
1 <- prepare= DBI::st=HASH(0xb6b9dcf0) at ./pg_comparator line 740 via at ./pg_comparator line 811
Begin dbd_st_execute
PQexec* decision: dml=1 direct=0 server_prepare=1 numbound=0 numphs=0 default=0
PQexec
Running PQexec with (SELECT COUNT(*) FROM cmp_2_0)
PQexec
Begin _sqlstate
PQresultStatus
PQresultErrorField
End _sqlstate (imp_dbh->sqlstate: 00000)
Begin PGTransactionStatusType
PQtransactionStatus
_sqlstate txn_status is 0
End _sqlstate (status: 2)
PQnfields
PQntuples
Status was PGRES_TUPLES_OK, fields=1, tuples=1
End dbd_st_execute (rows: 1)
Begin dbd_st_fetch
PQntuples
dbih_setup_fbav alloc for 1 fields
dbih_setup_fbav now 1 fields
PQftype
Fetching field #0
PQgetisnull
PQgetvalue
End dbd_st_fetch
Begin dbdpg_finish (async: 0)
PQclear
End dbd_st_finish
<- selectrow_array= '98' at ./pg_comparator line 740 via at ./pg_comparator line 811
>> DESTROY DISPATCH (DBI::st=HASH(0xb6b9dcf0) rc1/1 @1 g0 ima10004 pid#27140) at ./pg_comparator line 1052 via at ./pg_comparator line 1052
<> DESTROY(DBI::st=HASH(0xb6b9dcf0)) ignored for outer handle (inner DBI::st=HASH(0xb6b9dc80) has ref cnt 1)
>> DESTROY DISPATCH (DBI::st=HASH(0xb6b9dc80) rc1/1 @1 g0 ima10004 pid#27140) at ./pg_comparator line 1052 via at ./pg_comparator line 1052
-> DESTROY for DBD::Pg::st (DBI::st=HASH(0xb6b9dc80)~INNER) thr#8939bb8
Begin dbd_st_destroy
End dbd_st_destroy
<- DESTROY= undef at ./pg_comparator line 1052 via at ./pg_comparator line 1052
DESTROY (dbih_clearcom) (sth 0xb6b9dc80, com 0xb6bc2d38, imp DBD::Pg::st):
FLAGS 0x100091: COMSET Warn RaiseError PrintWarn
PARENT DBI::db=HASH(0xb6b9da60)
KIDS 0 (0 Active)
NUM_OF_FIELDS 1
NUM_OF_PARAMS 0
dbih_clearcom 0xb6b9dc80 (com 0xb6bc2d38, type 3) done.
New 'DBI::db' (for DBD::Pg::db, parent=DBI::dr=HASH(0x894a618), id=undef)
dbih_setup_handle(DBI::db=HASH(0x89cce20)=>DBI::db=HASH(0x89ccd70), DBD::Pg::db, 88f8f08, Null!)
dbih_make_com(DBI::dr=HASH(0x894a618), 89474b0, DBD::Pg::db, 140, 0) thr#8821448
dbih_setup_attrib(DBI::db=HASH(0x89ccd70), Err, DBI::dr=HASH(0x894a618)) SCALAR(0x88f9048) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x89ccd70), State, DBI::dr=HASH(0x894a618)) SCALAR(0x88f9088) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x89ccd70), Errstr, DBI::dr=HASH(0x894a618)) SCALAR(0x88f9068) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x89ccd70), TraceLevel, DBI::dr=HASH(0x894a618)) 0 (already defined)
dbih_setup_attrib(DBI::db=HASH(0x89ccd70), FetchHashKeyName, DBI::dr=HASH(0x894a618)) 'NAME' (already defined)
dbih_setup_attrib(DBI::db=HASH(0x89ccd70), HandleSetErr, DBI::dr=HASH(0x894a618)) undef (not defined)
dbih_setup_attrib(DBI::db=HASH(0x89ccd70), HandleError, DBI::dr=HASH(0x894a618)) undef (not defined)
dbih_setup_attrib(DBI::db=HASH(0x89ccd70), ReadOnly, DBI::dr=HASH(0x894a618)) undef (not defined)
dbih_setup_attrib(DBI::db=HASH(0x89ccd70), Profile, DBI::dr=HASH(0x894a618)) undef (not defined)
Begin dbd_db_login
Login connection string: (dbname=fabien host=localhost port=5432 user='fabien' password='XXX')
PQconnectdb
Connection complete
PQstatus
PQsetNoticeProcessor
PQprotocolVersion
PQserverVersion
End dbd_db_login
>> FETCH DISPATCH (DBI::db=HASH(0x89ccd70) rc2/1 @2 g0 ima404 pid#27140) at /usr/lib/perl5/DBD/Pg.pm line 225 via at ./pg_comparator line 729
-> FETCH for DBD::Pg::db (DBI::db=HASH(0x89ccd70)~INNER 'pg_server_version') thr#8821448
Begin dbd_db_FETCH (key: pg_server_version)
End dbd_db_FETCH_attrib
<- FETCH= 80402 at /usr/lib/perl5/DBD/Pg.pm line 225 via at ./pg_comparator line 729
>> FETCH DISPATCH (DBI::db=HASH(0x89ccd70) rc2/1 @2 g0 ima404 pid#27140) at /usr/lib/perl5/DBD/Pg.pm line 226 via at ./pg_comparator line 729
-> FETCH for DBD::Pg::db (DBI::db=HASH(0x89ccd70)~INNER 'private_dbdpg') thr#8821448
Begin dbd_db_FETCH (key: private_dbdpg)
End dbd_db_FETCH_attrib
.. FETCH DBI::db=HASH(0x89ccd70) 'private_dbdpg' = undef
<- FETCH= undef at /usr/lib/perl5/DBD/Pg.pm line 226 via at ./pg_comparator line 729
>> STORE DISPATCH (DBI::db=HASH(0x89ccd70) rc2/1 @3 g0 ima41c pid#27140) at /usr/lib/perl5/DBD/Pg.pm line 226 via at ./pg_comparator line 729
-> STORE for DBD::Pg::db (DBI::db=HASH(0x89ccd70)~INNER 'private_dbdpg' HASH(0x89cce40)) thr#8821448
Begin dbd_db_STORE (key: private_dbdpg newval: 1 kl:2702708)
End dbd_db_STORE_attrib
STORE DBI::db=HASH(0x89ccd70) 'private_dbdpg' => HASH(0x89cce40)
<- STORE= 1 at /usr/lib/perl5/DBD/Pg.pm line 226 via at ./pg_comparator line 729
<- connect= DBI::db=HASH(0x89cce20) at /usr/lib/perl5/DBI.pm line 653 via at ./pg_comparator line 1049
>> STORE DISPATCH (DBI::db=HASH(0x89ccd70) rc2/1 @3 g0 ima41c pid#27140) at /usr/lib/perl5/DBI.pm line 705 via at ./pg_comparator line 1049
-> STORE for DBD::Pg::db (DBI::db=HASH(0x89ccd70)~INNER 'RaiseError' 1) thr#8821448
Begin dbd_db_STORE (key: RaiseError newval: 1 kl:2702708)
End dbd_db_STORE_attrib
STORE DBI::db=HASH(0x89ccd70) 'RaiseError' => 1
<- STORE= 1 at /usr/lib/perl5/DBI.pm line 705 via at ./pg_comparator line 1049
>> STORE DISPATCH (DBI::db=HASH(0x89ccd70) rc2/1 @3 g0 ima41c pid#27140) at /usr/lib/perl5/DBI.pm line 705 via at ./pg_comparator line 1049
-> STORE for DBD::Pg::db (DBI::db=HASH(0x89ccd70)~INNER 'PrintError' 0) thr#8821448
Begin dbd_db_STORE (key: PrintError newval: 0 kl:2702708)
End dbd_db_STORE_attrib
STORE DBI::db=HASH(0x89ccd70) 'PrintError' => 0
<- STORE= 1 at /usr/lib/perl5/DBI.pm line 705 via at ./pg_comparator line 1049
>> STORE DISPATCH (DBI::db=HASH(0x89ccd70) rc2/1 @3 g0 ima41c pid#27140) at /usr/lib/perl5/DBI.pm line 705 via at ./pg_comparator line 1049
-> STORE for DBD::Pg::db (DBI::db=HASH(0x89ccd70)~INNER 'AutoCommit' 1) thr#8821448
Begin dbd_db_STORE (key: AutoCommit newval: 1 kl:2702708)
Begin dbd_db_commit
Begin pg_db_rollback_commit (action: commit AutoCommit: 0 BegunWork: 0)
Begin PGTransactionStatusType
PQtransactionStatus
dbd_db_commit txn_status is 0
End pg_db_rollback_commit (result: 1)
Setting AutoCommit to 'on' forced a commit
End dbd_db_STORE_attrib
<- STORE= 1 at /usr/lib/perl5/DBI.pm line 705 via at ./pg_comparator line 1049
>> STORE DISPATCH (DBI::db=HASH(0x89ccd70) rc2/1 @3 g0 ima41c pid#27140) at /usr/lib/perl5/DBI.pm line 708 via at ./pg_comparator line 729
-> STORE for DBD::Pg::db (DBI::db=HASH(0x89ccd70)~INNER 'Username' 'fabien') thr#8821448
Begin dbd_db_STORE (key: Username newval: 1 kl:2702708)
End dbd_db_STORE_attrib
STORE DBI::db=HASH(0x89ccd70) 'Username' => 'fabien'
<- STORE= 1 at /usr/lib/perl5/DBI.pm line 708 via at ./pg_comparator line 729
>> FETCH DISPATCH (DBI::db=HASH(0x89ccd70) rc2/1 @2 g0 ima404 pid#27140) at /usr/lib/perl5/DBI.pm line 708 via at ./pg_comparator line 1049
<> FETCH= 'fabien' ('Username' from cache) at /usr/lib/perl5/DBI.pm line 708 via at ./pg_comparator line 1049
>> connected DISPATCH (DBI::db=HASH(0x89cce20) rc1/1 @5 g0 ima5 pid#27140) at /usr/lib/perl5/DBI.pm line 714 via at ./pg_comparator line 1049
-> connected in DBD::_::db for DBD::Pg::db (DBI::db=HASH(0x89cce20)~0x89ccd70 'DBI:Pg:dbname=fabien;host=localhost;port=5432;' 'fabien' 'XXX' HASH(0x89325d8)) thr#8821448
<- connected= undef at /usr/lib/perl5/DBI.pm line 714 via at ./pg_comparator line 1049
<- connect= DBI::db=HASH(0x89cce20)
>> STORE DISPATCH (DBI::db=HASH(0x89ccd70) rc2/1 @3 g0 ima41c pid#27140) at /usr/lib/perl5/DBI.pm line 723 via at ./pg_comparator line 729
-> STORE for DBD::Pg::db (DBI::db=HASH(0x89ccd70)~INNER 'dbi_connect_closure' CODE(0x89c7dd0)) thr#8821448
Begin dbd_db_STORE (key: dbi_connect_closure newval: 1 kl:2702708)
End dbd_db_STORE_attrib
STORE DBI::db=HASH(0x89ccd70) 'dbi_connect_closure' => CODE(0x89c7dd0)
<- STORE= 1 at /usr/lib/perl5/DBI.pm line 723 via at ./pg_comparator line 729
## checksumming...
## building checksum table cmp_1_0
### 1 CREATE TEMPORARY TABLE cmp_1_0 AS SELECT COALESCE(id::TEXT,'null') AS id, CKSUM8(COALESCE(id::TEXT,'null')) AS idc,CKSUM8(COALESCE(id::TEXT,'null')||':'||COALESCE(a1::TEXT,'null')||':'||COALESCE(a0::TEXT,'null')) AS cks FROM foo1
>> do DISPATCH (DBI::db=HASH(0x89cce20) rc1/3 @2 g0 ima3201 pid#27140) at ./pg_comparator line 789 via at ./pg_comparator line 801
-> do for DBD::Pg::db (DBI::db=HASH(0x89cce20)~0x89ccd70 'CREATE TEMPORARY TABLE cmp_1_0 AS SELECT COALESCE(id::TEXT,'null') AS id, CKSUM8(COALESCE(id::TEXT,'null')) AS idc,CKSUM8(COALESCE(id::TEXT,'null')||':'||COALESCE(a1::TEXT,'null')||':'||COALESCE(a0::TEXT,'null')) AS cks FROM foo1 ') thr#8821448
Begin pg_quickexec (query: CREATE TEMPORARY TABLE cmp_1_0 AS SELECT COALESCE(id::TEXT,'null') AS id, CKSUM8(COALESCE(id::TEXT,'null')) AS idc,CKSUM8(COALESCE(id::TEXT,'null')||':'||COALESCE(a1::TEXT,'null')||':'||COALESCE(a0::TEXT,'null')) AS cks FROM foo1 async: 0 async_status: 0)
PQexec
Begin _sqlstate
PQresultStatus
PQresultErrorField
End _sqlstate (imp_dbh->sqlstate: 00000)
Begin PGTransactionStatusType
PQtransactionStatus
_sqlstate txn_status is 0
End _sqlstate (status: 1)
Got a status of 1
PQcmdStatus
PQclear
PQtransactionStatus
End pg_quickexec (rows: 0, txn_status: 0)
<- do= '0E0' at ./pg_comparator line 789 via at ./pg_comparator line 801
>> selectrow_array DISPATCH (DBI::db=HASH(0x89cce20) rc1/3 @2 g0 ima2001 pid#27140) at ./pg_comparator line 740 via at ./pg_comparator line 811
-> selectrow_array for DBD::Pg::db (DBI::db=HASH(0x89cce20)~0x89ccd70 'SELECT COUNT(*) FROM cmp_1_0') thr#8821448
>> prepare DISPATCH (DBI::db=HASH(0x89ccd70) rc1/1 @3 g0 imaa201 pid#27140) at ./pg_comparator line 740 via at ./pg_comparator line 811
1 -> prepare for DBD::Pg::db (DBI::db=HASH(0x89ccd70)~INNER 'SELECT COUNT(*) FROM cmp_1_0' undef) thr#8821448
New 'DBI::st' (for DBD::Pg::st, parent=DBI::db=HASH(0x89ccd70), id=undef)
dbih_setup_handle(DBI::st=HASH(0x89cd000)=>DBI::st=HASH(0x89ccf90), DBD::Pg::st, 88d71f0, Null!)
dbih_make_com(DBI::db=HASH(0x89ccd70), 89cdef0, DBD::Pg::st, 200, 0) thr#8821448
dbih_setup_attrib(DBI::st=HASH(0x89ccf90), Err, DBI::db=HASH(0x89ccd70)) SCALAR(0x88f9048) (already defined)
dbih_setup_attrib(DBI::st=HASH(0x89ccf90), State, DBI::db=HASH(0x89ccd70)) SCALAR(0x88f9088) (already defined)
dbih_setup_attrib(DBI::st=HASH(0x89ccf90), Errstr, DBI::db=HASH(0x89ccd70)) SCALAR(0x88f9068) (already defined)
dbih_setup_attrib(DBI::st=HASH(0x89ccf90), TraceLevel, DBI::db=HASH(0x89ccd70)) 0 (already defined)
dbih_setup_attrib(DBI::st=HASH(0x89ccf90), FetchHashKeyName, DBI::db=HASH(0x89ccd70)) 'NAME' (already defined)
dbih_setup_attrib(DBI::st=HASH(0x89ccf90), HandleSetErr, DBI::db=HASH(0x89ccd70)) undef (not defined)
dbih_setup_attrib(DBI::st=HASH(0x89ccf90), HandleError, DBI::db=HASH(0x89ccd70)) undef (not defined)
dbih_setup_attrib(DBI::st=HASH(0x89ccf90), ReadOnly, DBI::db=HASH(0x89ccd70)) undef (not defined)
dbih_setup_attrib(DBI::st=HASH(0x89ccf90), Profile, DBI::db=HASH(0x89ccd70)) undef (not defined)
Begin dbd_st_prepare (statement: SELECT COUNT(*) FROM cmp_1_0)
Begin pg_st_split_statement
pg_st_split_statement: (SELECT COUNT(*) FROM cmp_1_0)
Created segment (SELECT COUNT(*) FROM cmp_1_0)
Placeholder type: 0 numsegs: 1 numphs: 0
Placeholder numbers, ph id, and segments:
PH: (0) SEG: (SELECT COUNT(*) FROM cmp_1_0)
Placeholder number, fooname, id:
End pg_st_split_statement
Immediate prepare decision: dml=1 direct=0 server_prepare=1 prepare_now=0 PGLIBVERSION=80307
End dbd_st_prepare
1 <- prepare= DBI::st=HASH(0x89cd000) at ./pg_comparator line 740 via at ./pg_comparator line 811
Begin dbd_st_execute
PQexec* decision: dml=1 direct=0 server_prepare=1 numbound=0 numphs=0 default=0
PQexec
Running PQexec with (SELECT COUNT(*) FROM cmp_1_0)
PQexec
Begin _sqlstate
PQresultStatus
PQresultErrorField
End _sqlstate (imp_dbh->sqlstate: 00000)
Begin PGTransactionStatusType
PQtransactionStatus
_sqlstate txn_status is 0
End _sqlstate (status: 2)
PQnfields
PQntuples
Status was PGRES_TUPLES_OK, fields=1, tuples=1
End dbd_st_execute (rows: 1)
Begin dbd_st_fetch
PQntuples
dbih_setup_fbav alloc for 1 fields
dbih_setup_fbav now 1 fields
PQftype
Fetching field #0
PQgetisnull
PQgetvalue
End dbd_st_fetch
Begin dbdpg_finish (async: 0)
PQclear
End dbd_st_finish
<- selectrow_array= '98' at ./pg_comparator line 740 via at ./pg_comparator line 811
>> DESTROY DISPATCH (DBI::st=HASH(0x89cd000) rc1/1 @1 g0 ima10004 pid#27140) at ./pg_comparator line 1052 via at ./pg_comparator line 1052
<> DESTROY(DBI::st=HASH(0x89cd000)) ignored for outer handle (inner DBI::st=HASH(0x89ccf90) has ref cnt 1)
>> DESTROY DISPATCH (DBI::st=HASH(0x89ccf90) rc1/1 @1 g0 ima10004 pid#27140) at ./pg_comparator line 1052 via at ./pg_comparator line 1052
-> DESTROY for DBD::Pg::st (DBI::st=HASH(0x89ccf90)~INNER) thr#8821448
Begin dbd_st_destroy
End dbd_st_destroy
<- DESTROY= undef at ./pg_comparator line 1052 via at ./pg_comparator line 1052
DESTROY (dbih_clearcom) (sth 0x89ccf90, com 0x89e7240, imp DBD::Pg::st):
FLAGS 0x100091: COMSET Warn RaiseError PrintWarn
PARENT DBI::db=HASH(0x89ccd70)
KIDS 0 (0 Active)
NUM_OF_FIELDS 1
NUM_OF_PARAMS 0
dbih_clearcom 0x89ccf90 (com 0x89e7240, type 3) done.
>> DESTROY DISPATCH (DBI::db=HASH(0x89cce20) rc1/1 @1 g0 ima10004 pid#27140) at ./pg_comparator line 1064 via at ./pg_comparator line 1064
<> DESTROY(DBI::db=HASH(0x89cce20)) ignored for outer handle (inner DBI::db=HASH(0x89ccd70) has ref cnt 1)
>> DESTROY DISPATCH (DBI::db=HASH(0x89ccd70) rc1/1 @1 g0 ima10004 pid#27140) at ./pg_comparator line 1064 via at ./pg_comparator line 1064
-> DESTROY for DBD::Pg::db (DBI::db=HASH(0x89ccd70)~INNER) thr#8821448
Begin dbd_db_disconnect
Begin dbd_db_rollback
Begin pg_db_rollback_commit (action: rollback AutoCommit: 1 BegunWork: 0)
End pg_db_rollback_commit (result: 0)
PQfinish
Disconnection complete
End dbd_db_disconnect
Begin dbd_db_destroy
End dbd_db_destroy
<- DESTROY= undef at ./pg_comparator line 1064 via at ./pg_comparator line 1064
DESTROY (dbih_clearcom) (dbh 0x89ccd70, com 0x89cdef0, imp DBD::Pg::db):
FLAGS 0x180291: COMSET Warn RaiseError PrintWarn AutoCommit
PARENT DBI::dr=HASH(0x894a618)
KIDS 0 (0 Active)
dbih_clearcom 0x89ccd70 (com 0x89cdef0, type 2) done.
! >> DESTROY DISPATCH (DBI::dr=HASH(0x894a678) rc1/1 @1 g0 ima10004 pid#27140) during global destruction
! <> DESTROY(DBI::dr=HASH(0x894a678)) ignored for outer handle (inner DBI::dr=HASH(0x894a618) has ref cnt 1)
! >> DESTROY DISPATCH (DBI::dr=HASH(0x894a618) rc1/1 @1 g0 ima10004 pid#27140) during global destruction
! -> DESTROY in DBD::_::common for DBD::Pg::dr (DBI::dr=HASH(0x894a618)~INNER) thr#8821448
! <- DESTROY= undef during global destruction
DESTROY (dbih_clearcom) (drh 0x894a618, com 0x89474b0, imp global destruction):
FLAGS 0x180215: COMSET Active Warn PrintWarn AutoCommit
PARENT undef
KIDS 0 (0 Active)
dbih_clearcom 0x894a618 (com 0x89474b0, type 1) done.
>> DESTROY DISPATCH (DBI::db=HASH(0xb6b9db10) rc1/1 @1 g0 ima10004 pid#27140) at ./pg_comparator line 1068 via at ./pg_comparator line 1068
<> DESTROY(DBI::db=HASH(0xb6b9db10)) ignored for outer handle (inner DBI::db=HASH(0xb6b9da60) has ref cnt 1)
>> DESTROY DISPATCH (DBI::db=HASH(0xb6b9da60) rc1/1 @1 g0 ima10004 pid#27140) at ./pg_comparator line 1068 via at ./pg_comparator line 1068
-> DESTROY for DBD::Pg::db (DBI::db=HASH(0xb6b9da60)~INNER) thr#8939bb8
Begin dbd_db_disconnect
Begin dbd_db_rollback
Begin pg_db_rollback_commit (action: rollback AutoCommit: 1 BegunWork: 0)
End pg_db_rollback_commit (result: 0)
PQfinish
Disconnection complete
End dbd_db_disconnect
Begin dbd_db_destroy
End dbd_db_destroy
<- DESTROY= undef at ./pg_comparator line 1068 via at ./pg_comparator line 1068
DESTROY (dbih_clearcom) (dbh 0xb6b9da60, com 0xb6b9ebc0, imp DBD::Pg::db):
FLAGS 0x180291: COMSET Warn RaiseError PrintWarn AutoCommit
PARENT DBI::dr=HASH(0xb6b069c0)
KIDS 0 (0 Active)
dbih_clearcom 0xb6b9da60 (com 0xb6b9ebc0, type 2) done.
! >> DESTROY DISPATCH (DBI::dr=HASH(0xb6b06a20) rc1/1 @1 g0 ima10004 pid#27140) during global destruction
! <> DESTROY(DBI::dr=HASH(0xb6b06a20)) ignored for outer handle (inner DBI::dr=HASH(0xb6b069c0) has ref cnt 1)
! >> DESTROY DISPATCH (DBI::dr=HASH(0xb6b069c0) rc1/1 @1 g0 ima10004 pid#27140) during global destruction
! -> DESTROY in DBD::_::common for DBD::Pg::dr (DBI::dr=HASH(0xb6b069c0)~INNER) thr#8939bb8
! <- DESTROY= undef during global destruction
DESTROY (dbih_clearcom) (drh 0xb6b069c0, com 0xb6b8ba68, imp global destruction):
FLAGS 0x180215: COMSET Active Warn PrintWarn AutoCommit
PARENT undef
KIDS 0 (0 Active)
dbih_clearcom 0xb6b069c0 (com 0xb6b8ba68, type 1) done.
# computing size and masks after folding factor...
### masks=127 0
# building summary tables...
SV = IV(0xb6da1804) at 0xb6da1808
REFCNT = 1
FLAGS = (IOK,pIOK)
IV = -1227542520
CLONE DBI for new thread (dbis 874db60 -> b6d53008)
## building summary table cmp_1_1 (0)
### 1 CREATE TEMPORARY TABLE cmp_1_1 AS SELECT idc & 0 AS idc, xor(cks) AS cks FROM cmp_1_0 GROUP BY idc & 0
>> do DISPATCH (DBI::db=HASH(0xb6d3f600) rc1/3 @2 g0 ima3201 pid#27140) at ./pg_comparator line 789 via at ./pg_comparator line 823
<> do for DBI::db=HASH(0xb6d3f620) ignored (no imp_data)
Can't call do method on handle DBI::db=HASH(0xb6d3f620) after take_imp_data() at ./pg_comparator line 789.
SV = IV(0x89002d4) at 0x89002d8
REFCNT = 1
FLAGS = (IOK,pIOK)
IV = 143035536
CLONE DBI for new thread (dbis 874db60 -> 8868c90)
## building summary table cmp_2_1 (0)
### 1 CREATE TEMPORARY TABLE cmp_2_1 AS SELECT idc & 0 AS idc, xor(cks) AS cks FROM cmp_2_0 GROUP BY idc & 0
>> do DISPATCH (DBI::db=HASH(0x8970ee0) rc1/3 @2 g0 ima3201 pid#27140) at ./pg_comparator line 789 via at ./pg_comparator line 823
! >> DESTROY DISPATCH (DBI::db=HASH(0xb6bd12f8) rc1/1 @1 g0 ima10004 pid#27140) during global destruction
Use of uninitialized value in subroutine entry at ./pg_comparator line 789.
! <> DESTROY(DBI::db=HASH(0xb6bd12f8)) ignored for outer handle (inner DBI::db=HASH(0xb6bd1318) has ref cnt 1)
! >> DESTROY DISPATCH (DBI::db=HASH(0xb6bd1318) rc1/1 @1 g0 ima10004 pid#27140) during global destruction
Thread 4 terminated abnormally: (null) do failed: handle 15124 is owned by thread b6db3b14 not current thread b6db3620 (handles can't be shared between threads and your driver may need a CLONE method added) at ./pg_comparator line 789.
! <> DESTROY for DBI::db=HASH(0xb6bd1318) ignored (no imp_data)
! >> DESTROY DISPATCH (DBI::dr=HASH(0xb6bd1828) rc1/1 @1 g0 ima10004 pid#27140) during global destruction
! <> DESTROY(DBI::dr=HASH(0xb6bd1828)) ignored for outer handle (inner DBI::dr=HASH(0xb6bd1408) has ref cnt 2)
! >> DESTROY DISPATCH (DBI::dr=HASH(0xb6bd1408) rc1/1 @1 g0 ima10004 pid#27140) during global destruction
! <> DESTROY for DBI::dr=HASH(0xb6bd1408) ignored (no imp_data)
! >> DESTROY DISPATCH (DBI::dr=HASH(0xb6d28688) rc1/1 @1 g0 ima10004 pid#27140) during global destruction
dbi_trace_no_thread.log
(text/plain, 48.7 KB)
DBI 1.609-ithread default trace level set to 0x0/10 (pid 27206) at DBI.pm line 273 via pg_comparator line 642
install_method DBI::db::get_info , flags 0x2a00
install_method DBI::db::take_imp_data, flags 0x10000
install_method DBI::db::disconnect , flags 0x10c00
install_method DBI::db::selectrow_array, flags 0x2000
install_method DBI::db::tables , flags 0x2200
install_method DBI::db::quote_identifier, flags 0x0430
install_method DBI::db::clone
install_method DBI::db::quote , flags 0x0430
install_method DBI::db::type_info , flags 0x2200
install_method DBI::db::statistics_info, flags 0xaa00
install_method DBI::db::selectrow_arrayref, flags 0x2000
install_method DBI::db::begin_work , flags 0x0400
install_method DBI::db::last_insert_id, flags 0x2800
install_method DBI::db::foreign_key_info, flags 0xaa00
install_method DBI::db::primary_key , flags 0x2200
install_method DBI::db::commit , flags 0x0c80
install_method DBI::db::ping , flags 0x0404
install_method DBI::db::selectall_arrayref, flags 0x2000
install_method DBI::db::type_info_all, flags 0x2a00
install_method DBI::db::do , flags 0x3200
install_method DBI::db::selectcol_arrayref, flags 0x2000
install_method DBI::db::prepare_cached, flags 0xa200
install_method DBI::db::rows , flags 0x0004
install_method DBI::db::rollback , flags 0x0c80
install_method DBI::db::column_info , flags 0xaa00
install_method DBI::db::table_info , flags 0xaa00
install_method DBI::db::primary_key_info, flags 0xaa00
install_method DBI::db::prepare , flags 0xa200
install_method DBI::db::preparse
install_method DBI::db::connected , flags 0x0004
install_method DBI::db::data_sources, flags 0x0200
install_method DBI::db::selectall_hashref, flags 0x2000
install_method DBI::db::selectrow_hashref, flags 0x2000
install_method DBI::dr::default_user
install_method DBI::dr::data_sources, flags 0x0800
install_method DBI::dr::dbixs_revision, flags 0x0004
install_method DBI::dr::disconnect_all, flags 0x0800
install_method DBI::dr::connect_cached, flags 0x8000, H 3
install_method DBI::dr::connect , flags 0x8000, H 3
install_method DBI::st::more_results
install_method DBI::st::blob_read
install_method DBI::st::fetchall_hashref
install_method DBI::st::bind_param_inout_array
install_method DBI::st::finish
install_method DBI::st::rows , flags 0x0004
install_method DBI::st::execute_for_fetch, flags 0x5040
install_method DBI::st::fetchrow_hashref
install_method DBI::st::_get_fbav
install_method DBI::st::_set_fbav , T 6
install_method DBI::st::fetchrow
install_method DBI::st::fetch
install_method DBI::st::execute_array, flags 0x5040
install_method DBI::st::dump_results
install_method DBI::st::bind_param_array
install_method DBI::st::fetchrow_array
install_method DBI::st::execute , flags 0x1040
install_method DBI::st::bind_col
install_method DBI::st::fetchall_arrayref
install_method DBI::st::fetchrow_arrayref
install_method DBI::st::bind_param_inout
install_method DBI::st::bind_columns
install_method DBI::st::cancel , flags 0x0800
install_method DBI::st::blob_copy_to_file
install_method DBI::st::bind_param
install_method DBI::common::parse_trace_flag, flags 0x0404, T 8
install_method DBI::common::errstr , flags 0x0004
install_method DBI::common::trace_msg, flags 0x0004, T 8
install_method DBI::common::err , flags 0x0004
install_method DBI::common::CLEAR , flags 0x0004
install_method DBI::common::state , flags 0x0004
install_method DBI::common::_not_impl
install_method DBI::common::NEXTKEY , flags 0x0004
install_method DBI::common::trace , flags 0x0004
install_method DBI::common::debug , flags 0x0004
install_method DBI::common::parse_trace_flags, flags 0x0404, T 8
install_method DBI::common::private_attribute_info
install_method DBI::common::swap_inner_handle
install_method DBI::common::EXISTS , flags 0x0004
install_method DBI::common::visit_child_handles, flags 0x0404, T 4
install_method DBI::common::FETCH , flags 0x0404
install_method DBI::common::FIRSTKEY, flags 0x0004
install_method DBI::common::set_err , flags 0x0010
install_method DBI::common::DESTROY , flags 0x10004
install_method DBI::common::dump_handle, flags 0x0004
install_method DBI::common::FETCH_many, flags 0x0404
install_method DBI::common::can , flags 0x0100
install_method DBI::common::STORE , flags 0x041c
install_method DBI::common::private_data, flags 0x0004
install_method DBI::common::func , flags 0x0006
### user=fabien, pass=XXX, host=localhost, port=5432
### base=fabien, tabl=foo1, keys=id, cols=a1,a0
## connection parameters: fabien XXX localhost 5432 fabien foo1 id a1,a0
### user=fabien, pass=XXX, host=localhost, port=5432
### base=fabien, tabl=foo1, keys=id, cols=a1,a0
## connection parameters: fabien XXX localhost 5432 fabien foo1 id a1,a0
# connection and checksum...
## connecting...
### connecting to s=DBI:Pg:dbname=fabien;host=localhost;port=5432; u=fabien
-> DBI->connect(DBI:Pg:dbname=fabien;host=localhost;port=5432;, fabien, ****, HASH(0x88849d0))
-> DBI->install_driver(Pg) for linux perl=5.010000 pid=27206 ruid=1000 euid=1000
install_driver: DBD::Pg version 2.13.1 loaded from /usr/lib/perl5/DBD/Pg.pm
New 'DBI::dr' (for DBD::Pg::dr, parent='', id=undef)
dbih_setup_handle(DBI::dr=HASH(0x8987608)=>DBI::dr=HASH(0x8a4f630), DBD::Pg::dr, 0, Null!)
dbih_make_com(Null!, 0, DBD::Pg::dr, 84, 0) thr#8880008
dbih_setup_attrib(DBI::dr=HASH(0x8a4f630), Err, Null!) SCALAR(0x8986ad8) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x8a4f630), State, Null!) SCALAR(0x8a4f590) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x8a4f630), Errstr, Null!) SCALAR(0x8986af8) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x8a4f630), TraceLevel, Null!) 0 (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x8a4f630), FetchHashKeyName, Null!) 'NAME' (already defined)
install_method DBI::db::pg_cancel
install_method DBI::db::pg_endcopy
install_method DBI::db::pg_getline
install_method DBI::db::pg_getcopydata
install_method DBI::db::pg_getcopydata_async
install_method DBI::db::pg_notifies
install_method DBI::db::pg_putcopydata
install_method DBI::db::pg_putcopyend
install_method DBI::db::pg_ping
install_method DBI::db::pg_putline
install_method DBI::db::pg_ready
install_method DBI::db::pg_release
install_method DBI::db::pg_result
install_method DBI::db::pg_rollback_to
install_method DBI::db::pg_savepoint
install_method DBI::db::pg_server_trace
install_method DBI::db::pg_server_untrace
install_method DBI::db::pg_type_info
install_method DBI::st::pg_cancel
install_method DBI::st::pg_result
install_method DBI::st::pg_ready
install_method DBI::db::pg_lo_creat
install_method DBI::db::pg_lo_open
install_method DBI::db::pg_lo_write
install_method DBI::db::pg_lo_read
install_method DBI::db::pg_lo_lseek
install_method DBI::db::pg_lo_tell
install_method DBI::db::pg_lo_close
install_method DBI::db::pg_lo_unlink
install_method DBI::db::pg_lo_import
install_method DBI::db::pg_lo_export
<- install_driver= DBI::dr=HASH(0x8987608)
>> connect DISPATCH (DBI::dr=HASH(0x8987608) rc2/3 @5 g0 ima8001 pid#27206) at /usr/lib/perl5/DBI.pm line 653 via at ./pg_comparator line 1049
!! warn: 0 CLEARED by call to connect method
-> connect for DBD::Pg::dr (DBI::dr=HASH(0x8987608)~0x8a4f630 'dbname=fabien;host=localhost;port=5432;' 'fabien' **** HASH(0x8998180)) thr#8880008
New 'DBI::db' (for DBD::Pg::db, parent=DBI::dr=HASH(0x8a4f630), id=undef)
dbih_setup_handle(DBI::db=HASH(0x8a54908)=>DBI::db=HASH(0x8a54858), DBD::Pg::db, 89ca888, Null!)
dbih_make_com(DBI::dr=HASH(0x8a4f630), 8ab09e0, DBD::Pg::db, 140, 0) thr#8880008
dbih_setup_attrib(DBI::db=HASH(0x8a54858), Err, DBI::dr=HASH(0x8a4f630)) SCALAR(0x89caa98) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x8a54858), State, DBI::dr=HASH(0x8a4f630)) SCALAR(0x89cab18) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x8a54858), Errstr, DBI::dr=HASH(0x8a4f630)) SCALAR(0x89caad8) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x8a54858), TraceLevel, DBI::dr=HASH(0x8a4f630)) 0 (already defined)
dbih_setup_attrib(DBI::db=HASH(0x8a54858), FetchHashKeyName, DBI::dr=HASH(0x8a4f630)) 'NAME' (already defined)
dbih_setup_attrib(DBI::db=HASH(0x8a54858), HandleSetErr, DBI::dr=HASH(0x8a4f630)) undef (not defined)
dbih_setup_attrib(DBI::db=HASH(0x8a54858), HandleError, DBI::dr=HASH(0x8a4f630)) undef (not defined)
dbih_setup_attrib(DBI::db=HASH(0x8a54858), ReadOnly, DBI::dr=HASH(0x8a4f630)) undef (not defined)
dbih_setup_attrib(DBI::db=HASH(0x8a54858), Profile, DBI::dr=HASH(0x8a4f630)) undef (not defined)
Begin dbd_db_login
Login connection string: (dbname=fabien host=localhost port=5432 user='fabien' password='XXX')
PQconnectdb
Connection complete
PQstatus
PQsetNoticeProcessor
PQprotocolVersion
PQserverVersion
End dbd_db_login
>> FETCH DISPATCH (DBI::db=HASH(0x8a54858) rc2/1 @2 g0 ima404 pid#27206) at /usr/lib/perl5/DBD/Pg.pm line 225 via at ./pg_comparator line 729
-> FETCH for DBD::Pg::db (DBI::db=HASH(0x8a54858)~INNER 'pg_server_version') thr#8880008
Begin dbd_db_FETCH (key: pg_server_version)
End dbd_db_FETCH_attrib
<- FETCH= 80402 at /usr/lib/perl5/DBD/Pg.pm line 225 via at ./pg_comparator line 729
>> FETCH DISPATCH (DBI::db=HASH(0x8a54858) rc2/1 @2 g0 ima404 pid#27206) at /usr/lib/perl5/DBD/Pg.pm line 226 via at ./pg_comparator line 729
-> FETCH for DBD::Pg::db (DBI::db=HASH(0x8a54858)~INNER 'private_dbdpg') thr#8880008
Begin dbd_db_FETCH (key: private_dbdpg)
End dbd_db_FETCH_attrib
.. FETCH DBI::db=HASH(0x8a54858) 'private_dbdpg' = undef
<- FETCH= undef at /usr/lib/perl5/DBD/Pg.pm line 226 via at ./pg_comparator line 729
>> STORE DISPATCH (DBI::db=HASH(0x8a54858) rc2/1 @3 g0 ima41c pid#27206) at /usr/lib/perl5/DBD/Pg.pm line 226 via at ./pg_comparator line 729
-> STORE for DBD::Pg::db (DBI::db=HASH(0x8a54858)~INNER 'private_dbdpg' HASH(0x8a54928)) thr#8880008
Begin dbd_db_STORE (key: private_dbdpg newval: 1 kl:1)
End dbd_db_STORE_attrib
STORE DBI::db=HASH(0x8a54858) 'private_dbdpg' => HASH(0x8a54928)
<- STORE= 1 at /usr/lib/perl5/DBD/Pg.pm line 226 via at ./pg_comparator line 729
<- connect= DBI::db=HASH(0x8a54908) at /usr/lib/perl5/DBI.pm line 653 via at ./pg_comparator line 1049
>> STORE DISPATCH (DBI::db=HASH(0x8a54858) rc2/1 @3 g0 ima41c pid#27206) at /usr/lib/perl5/DBI.pm line 705 via at ./pg_comparator line 1049
-> STORE for DBD::Pg::db (DBI::db=HASH(0x8a54858)~INNER 'RaiseError' 1) thr#8880008
Begin dbd_db_STORE (key: RaiseError newval: 1 kl:13307252)
End dbd_db_STORE_attrib
STORE DBI::db=HASH(0x8a54858) 'RaiseError' => 1
<- STORE= 1 at /usr/lib/perl5/DBI.pm line 705 via at ./pg_comparator line 1049
>> STORE DISPATCH (DBI::db=HASH(0x8a54858) rc2/1 @3 g0 ima41c pid#27206) at /usr/lib/perl5/DBI.pm line 705 via at ./pg_comparator line 1049
-> STORE for DBD::Pg::db (DBI::db=HASH(0x8a54858)~INNER 'PrintError' 0) thr#8880008
Begin dbd_db_STORE (key: PrintError newval: 0 kl:13307252)
End dbd_db_STORE_attrib
STORE DBI::db=HASH(0x8a54858) 'PrintError' => 0
<- STORE= 1 at /usr/lib/perl5/DBI.pm line 705 via at ./pg_comparator line 1049
>> STORE DISPATCH (DBI::db=HASH(0x8a54858) rc2/1 @3 g0 ima41c pid#27206) at /usr/lib/perl5/DBI.pm line 705 via at ./pg_comparator line 1049
-> STORE for DBD::Pg::db (DBI::db=HASH(0x8a54858)~INNER 'AutoCommit' 1) thr#8880008
Begin dbd_db_STORE (key: AutoCommit newval: 1 kl:13307252)
Begin dbd_db_commit
Begin pg_db_rollback_commit (action: commit AutoCommit: 0 BegunWork: 0)
Begin PGTransactionStatusType
PQtransactionStatus
dbd_db_commit txn_status is 0
End pg_db_rollback_commit (result: 1)
Setting AutoCommit to 'on' forced a commit
End dbd_db_STORE_attrib
<- STORE= 1 at /usr/lib/perl5/DBI.pm line 705 via at ./pg_comparator line 1049
>> STORE DISPATCH (DBI::db=HASH(0x8a54858) rc2/1 @3 g0 ima41c pid#27206) at /usr/lib/perl5/DBI.pm line 708 via at ./pg_comparator line 729
-> STORE for DBD::Pg::db (DBI::db=HASH(0x8a54858)~INNER 'Username' 'fabien') thr#8880008
Begin dbd_db_STORE (key: Username newval: 1 kl:13307252)
End dbd_db_STORE_attrib
STORE DBI::db=HASH(0x8a54858) 'Username' => 'fabien'
<- STORE= 1 at /usr/lib/perl5/DBI.pm line 708 via at ./pg_comparator line 729
>> FETCH DISPATCH (DBI::db=HASH(0x8a54858) rc2/1 @2 g0 ima404 pid#27206) at /usr/lib/perl5/DBI.pm line 708 via at ./pg_comparator line 1049
<> FETCH= 'fabien' ('Username' from cache) at /usr/lib/perl5/DBI.pm line 708 via at ./pg_comparator line 1049
>> connected DISPATCH (DBI::db=HASH(0x8a54908) rc1/1 @5 g0 ima5 pid#27206) at /usr/lib/perl5/DBI.pm line 714 via at ./pg_comparator line 1049
-> connected in DBD::_::db for DBD::Pg::db (DBI::db=HASH(0x8a54908)~0x8a54858 'DBI:Pg:dbname=fabien;host=localhost;port=5432;' 'fabien' 'XXX' HASH(0x88849d0)) thr#8880008
<- connected= undef at /usr/lib/perl5/DBI.pm line 714 via at ./pg_comparator line 1049
<- connect= DBI::db=HASH(0x8a54908)
>> STORE DISPATCH (DBI::db=HASH(0x8a54858) rc2/1 @3 g0 ima41c pid#27206) at /usr/lib/perl5/DBI.pm line 723 via at ./pg_comparator line 729
-> STORE for DBD::Pg::db (DBI::db=HASH(0x8a54858)~INNER 'dbi_connect_closure' CODE(0x893de50)) thr#8880008
Begin dbd_db_STORE (key: dbi_connect_closure newval: 1 kl:13307252)
End dbd_db_STORE_attrib
STORE DBI::db=HASH(0x8a54858) 'dbi_connect_closure' => CODE(0x893de50)
<- STORE= 1 at /usr/lib/perl5/DBI.pm line 723 via at ./pg_comparator line 729
## checksumming...
## building checksum table cmp_1_0
### 1 CREATE TEMPORARY TABLE cmp_1_0 AS SELECT COALESCE(id::TEXT,'null') AS id, CKSUM8(COALESCE(id::TEXT,'null')) AS idc,CKSUM8(COALESCE(id::TEXT,'null')||':'||COALESCE(a1::TEXT,'null')||':'||COALESCE(a0::TEXT,'null')) AS cks FROM foo1
>> do DISPATCH (DBI::db=HASH(0x8a54908) rc1/3 @2 g0 ima3201 pid#27206) at ./pg_comparator line 789 via at ./pg_comparator line 801
-> do for DBD::Pg::db (DBI::db=HASH(0x8a54908)~0x8a54858 'CREATE TEMPORARY TABLE cmp_1_0 AS SELECT COALESCE(id::TEXT,'null') AS id, CKSUM8(COALESCE(id::TEXT,'null')) AS idc,CKSUM8(COALESCE(id::TEXT,'null')||':'||COALESCE(a1::TEXT,'null')||':'||COALESCE(a0::TEXT,'null')) AS cks FROM foo1 ') thr#8880008
Begin pg_quickexec (query: CREATE TEMPORARY TABLE cmp_1_0 AS SELECT COALESCE(id::TEXT,'null') AS id, CKSUM8(COALESCE(id::TEXT,'null')) AS idc,CKSUM8(COALESCE(id::TEXT,'null')||':'||COALESCE(a1::TEXT,'null')||':'||COALESCE(a0::TEXT,'null')) AS cks FROM foo1 async: 0 async_status: 0)
PQexec
Begin _sqlstate
PQresultStatus
PQresultErrorField
End _sqlstate (imp_dbh->sqlstate: 00000)
Begin PGTransactionStatusType
PQtransactionStatus
_sqlstate txn_status is 0
End _sqlstate (status: 1)
Got a status of 1
PQcmdStatus
PQclear
PQtransactionStatus
End pg_quickexec (rows: 0, txn_status: 0)
<- do= '0E0' at ./pg_comparator line 789 via at ./pg_comparator line 801
>> selectrow_array DISPATCH (DBI::db=HASH(0x8a54908) rc1/3 @2 g0 ima2001 pid#27206) at ./pg_comparator line 740 via at ./pg_comparator line 811
-> selectrow_array for DBD::Pg::db (DBI::db=HASH(0x8a54908)~0x8a54858 'SELECT COUNT(*) FROM cmp_1_0') thr#8880008
>> prepare DISPATCH (DBI::db=HASH(0x8a54858) rc1/1 @3 g0 imaa201 pid#27206) at ./pg_comparator line 740 via at ./pg_comparator line 811
1 -> prepare for DBD::Pg::db (DBI::db=HASH(0x8a54858)~INNER 'SELECT COUNT(*) FROM cmp_1_0' undef) thr#8880008
New 'DBI::st' (for DBD::Pg::st, parent=DBI::db=HASH(0x8a54858), id=undef)
dbih_setup_handle(DBI::st=HASH(0x8a54ae8)=>DBI::st=HASH(0x8a54a78), DBD::Pg::st, 89cab78, Null!)
dbih_make_com(DBI::db=HASH(0x8a54858), 8a59b38, DBD::Pg::st, 200, 0) thr#8880008
dbih_setup_attrib(DBI::st=HASH(0x8a54a78), Err, DBI::db=HASH(0x8a54858)) SCALAR(0x89caa98) (already defined)
dbih_setup_attrib(DBI::st=HASH(0x8a54a78), State, DBI::db=HASH(0x8a54858)) SCALAR(0x89cab18) (already defined)
dbih_setup_attrib(DBI::st=HASH(0x8a54a78), Errstr, DBI::db=HASH(0x8a54858)) SCALAR(0x89caad8) (already defined)
dbih_setup_attrib(DBI::st=HASH(0x8a54a78), TraceLevel, DBI::db=HASH(0x8a54858)) 0 (already defined)
dbih_setup_attrib(DBI::st=HASH(0x8a54a78), FetchHashKeyName, DBI::db=HASH(0x8a54858)) 'NAME' (already defined)
dbih_setup_attrib(DBI::st=HASH(0x8a54a78), HandleSetErr, DBI::db=HASH(0x8a54858)) undef (not defined)
dbih_setup_attrib(DBI::st=HASH(0x8a54a78), HandleError, DBI::db=HASH(0x8a54858)) undef (not defined)
dbih_setup_attrib(DBI::st=HASH(0x8a54a78), ReadOnly, DBI::db=HASH(0x8a54858)) undef (not defined)
dbih_setup_attrib(DBI::st=HASH(0x8a54a78), Profile, DBI::db=HASH(0x8a54858)) undef (not defined)
Begin dbd_st_prepare (statement: SELECT COUNT(*) FROM cmp_1_0)
Begin pg_st_split_statement
pg_st_split_statement: (SELECT COUNT(*) FROM cmp_1_0)
Created segment (SELECT COUNT(*) FROM cmp_1_0)
Placeholder type: 0 numsegs: 1 numphs: 0
Placeholder numbers, ph id, and segments:
PH: (0) SEG: (SELECT COUNT(*) FROM cmp_1_0)
Placeholder number, fooname, id:
End pg_st_split_statement
Immediate prepare decision: dml=1 direct=0 server_prepare=1 prepare_now=0 PGLIBVERSION=80307
End dbd_st_prepare
1 <- prepare= DBI::st=HASH(0x8a54ae8) at ./pg_comparator line 740 via at ./pg_comparator line 811
Begin dbd_st_execute
PQexec* decision: dml=1 direct=0 server_prepare=1 numbound=0 numphs=0 default=0
PQexec
Running PQexec with (SELECT COUNT(*) FROM cmp_1_0)
PQexec
Begin _sqlstate
PQresultStatus
PQresultErrorField
End _sqlstate (imp_dbh->sqlstate: 00000)
Begin PGTransactionStatusType
PQtransactionStatus
_sqlstate txn_status is 0
End _sqlstate (status: 2)
PQnfields
PQntuples
Status was PGRES_TUPLES_OK, fields=1, tuples=1
End dbd_st_execute (rows: 1)
Begin dbd_st_fetch
PQntuples
dbih_setup_fbav alloc for 1 fields
dbih_setup_fbav now 1 fields
PQftype
Fetching field #0
PQgetisnull
PQgetvalue
End dbd_st_fetch
Begin dbdpg_finish (async: 0)
PQclear
End dbd_st_finish
<- selectrow_array= '98' at ./pg_comparator line 740 via at ./pg_comparator line 811
>> DESTROY DISPATCH (DBI::st=HASH(0x8a54ae8) rc1/1 @1 g0 ima10004 pid#27206) at ./pg_comparator line 1052 via at ./pg_comparator line 1052
<> DESTROY(DBI::st=HASH(0x8a54ae8)) ignored for outer handle (inner DBI::st=HASH(0x8a54a78) has ref cnt 1)
>> DESTROY DISPATCH (DBI::st=HASH(0x8a54a78) rc1/1 @1 g0 ima10004 pid#27206) at ./pg_comparator line 1052 via at ./pg_comparator line 1052
-> DESTROY for DBD::Pg::st (DBI::st=HASH(0x8a54a78)~INNER) thr#8880008
Begin dbd_st_destroy
End dbd_st_destroy
<- DESTROY= undef at ./pg_comparator line 1052 via at ./pg_comparator line 1052
DESTROY (dbih_clearcom) (sth 0x8a54a78, com 0x8af8a38, imp DBD::Pg::st):
FLAGS 0x100091: COMSET Warn RaiseError PrintWarn
PARENT DBI::db=HASH(0x8a54858)
KIDS 0 (0 Active)
NUM_OF_FIELDS 1
NUM_OF_PARAMS 0
dbih_clearcom 0x8a54a78 (com 0x8af8a38, type 3) done.
## connecting...
### connecting to s=DBI:Pg:dbname=fabien;host=localhost;port=5432; u=fabien
-> DBI->connect(DBI:Pg:dbname=fabien;host=localhost;port=5432;, fabien, ****, HASH(0x8a54828))
>> connect DISPATCH (DBI::dr=HASH(0x8987608) rc2/4 @5 g0 ima8001 pid#27206) at /usr/lib/perl5/DBI.pm line 653 via at ./pg_comparator line 1049
-> connect for DBD::Pg::dr (DBI::dr=HASH(0x8987608)~0x8a4f630 'dbname=fabien;host=localhost;port=5432;' 'fabien' **** HASH(0x8a54838)) thr#8880008
New 'DBI::db' (for DBD::Pg::db, parent=DBI::dr=HASH(0x8a4f630), id=undef)
dbih_setup_handle(DBI::db=HASH(0x8a55108)=>DBI::db=HASH(0x8a55078), DBD::Pg::db, 8a54be8, Null!)
dbih_make_com(DBI::dr=HASH(0x8a4f630), 8ab09e0, DBD::Pg::db, 140, 0) thr#8880008
dbih_setup_attrib(DBI::db=HASH(0x8a55078), Err, DBI::dr=HASH(0x8a4f630)) SCALAR(0x8a54ba8) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x8a55078), State, DBI::dr=HASH(0x8a4f630)) SCALAR(0x8a54b88) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x8a55078), Errstr, DBI::dr=HASH(0x8a4f630)) SCALAR(0x8a54b98) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x8a55078), TraceLevel, DBI::dr=HASH(0x8a4f630)) 0 (already defined)
dbih_setup_attrib(DBI::db=HASH(0x8a55078), FetchHashKeyName, DBI::dr=HASH(0x8a4f630)) 'NAME' (already defined)
dbih_setup_attrib(DBI::db=HASH(0x8a55078), HandleSetErr, DBI::dr=HASH(0x8a4f630)) undef (not defined)
dbih_setup_attrib(DBI::db=HASH(0x8a55078), HandleError, DBI::dr=HASH(0x8a4f630)) undef (not defined)
dbih_setup_attrib(DBI::db=HASH(0x8a55078), ReadOnly, DBI::dr=HASH(0x8a4f630)) undef (not defined)
dbih_setup_attrib(DBI::db=HASH(0x8a55078), Profile, DBI::dr=HASH(0x8a4f630)) undef (not defined)
Begin dbd_db_login
Login connection string: (dbname=fabien host=localhost port=5432 user='fabien' password='XXX')
PQconnectdb
Connection complete
PQstatus
PQsetNoticeProcessor
PQprotocolVersion
PQserverVersion
End dbd_db_login
>> FETCH DISPATCH (DBI::db=HASH(0x8a55078) rc2/1 @2 g0 ima404 pid#27206) at /usr/lib/perl5/DBD/Pg.pm line 225 via at ./pg_comparator line 729
-> FETCH for DBD::Pg::db (DBI::db=HASH(0x8a55078)~INNER 'pg_server_version') thr#8880008
Begin dbd_db_FETCH (key: pg_server_version)
End dbd_db_FETCH_attrib
<- FETCH= 80402 at /usr/lib/perl5/DBD/Pg.pm line 225 via at ./pg_comparator line 729
>> FETCH DISPATCH (DBI::db=HASH(0x8a55078) rc2/1 @2 g0 ima404 pid#27206) at /usr/lib/perl5/DBD/Pg.pm line 226 via at ./pg_comparator line 729
-> FETCH for DBD::Pg::db (DBI::db=HASH(0x8a55078)~INNER 'private_dbdpg') thr#8880008
Begin dbd_db_FETCH (key: private_dbdpg)
End dbd_db_FETCH_attrib
.. FETCH DBI::db=HASH(0x8a55078) 'private_dbdpg' = undef
<- FETCH= undef at /usr/lib/perl5/DBD/Pg.pm line 226 via at ./pg_comparator line 729
>> STORE DISPATCH (DBI::db=HASH(0x8a55078) rc2/1 @3 g0 ima41c pid#27206) at /usr/lib/perl5/DBD/Pg.pm line 226 via at ./pg_comparator line 729
-> STORE for DBD::Pg::db (DBI::db=HASH(0x8a55078)~INNER 'private_dbdpg' HASH(0x8a55128)) thr#8880008
Begin dbd_db_STORE (key: private_dbdpg newval: 1 kl:13307252)
End dbd_db_STORE_attrib
STORE DBI::db=HASH(0x8a55078) 'private_dbdpg' => HASH(0x8a55128)
<- STORE= 1 at /usr/lib/perl5/DBD/Pg.pm line 226 via at ./pg_comparator line 729
<- connect= DBI::db=HASH(0x8a55108) at /usr/lib/perl5/DBI.pm line 653 via at ./pg_comparator line 1049
>> STORE DISPATCH (DBI::db=HASH(0x8a55078) rc2/1 @3 g0 ima41c pid#27206) at /usr/lib/perl5/DBI.pm line 705 via at ./pg_comparator line 1049
-> STORE for DBD::Pg::db (DBI::db=HASH(0x8a55078)~INNER 'RaiseError' 1) thr#8880008
Begin dbd_db_STORE (key: RaiseError newval: 1 kl:13307252)
End dbd_db_STORE_attrib
STORE DBI::db=HASH(0x8a55078) 'RaiseError' => 1
<- STORE= 1 at /usr/lib/perl5/DBI.pm line 705 via at ./pg_comparator line 1049
>> STORE DISPATCH (DBI::db=HASH(0x8a55078) rc2/1 @3 g0 ima41c pid#27206) at /usr/lib/perl5/DBI.pm line 705 via at ./pg_comparator line 1049
-> STORE for DBD::Pg::db (DBI::db=HASH(0x8a55078)~INNER 'PrintError' 0) thr#8880008
Begin dbd_db_STORE (key: PrintError newval: 0 kl:13307252)
End dbd_db_STORE_attrib
STORE DBI::db=HASH(0x8a55078) 'PrintError' => 0
<- STORE= 1 at /usr/lib/perl5/DBI.pm line 705 via at ./pg_comparator line 1049
>> STORE DISPATCH (DBI::db=HASH(0x8a55078) rc2/1 @3 g0 ima41c pid#27206) at /usr/lib/perl5/DBI.pm line 705 via at ./pg_comparator line 1049
-> STORE for DBD::Pg::db (DBI::db=HASH(0x8a55078)~INNER 'AutoCommit' 1) thr#8880008
Begin dbd_db_STORE (key: AutoCommit newval: 1 kl:13307252)
Begin dbd_db_commit
Begin pg_db_rollback_commit (action: commit AutoCommit: 0 BegunWork: 0)
Begin PGTransactionStatusType
PQtransactionStatus
dbd_db_commit txn_status is 0
End pg_db_rollback_commit (result: 1)
Setting AutoCommit to 'on' forced a commit
End dbd_db_STORE_attrib
<- STORE= 1 at /usr/lib/perl5/DBI.pm line 705 via at ./pg_comparator line 1049
>> STORE DISPATCH (DBI::db=HASH(0x8a55078) rc2/1 @3 g0 ima41c pid#27206) at /usr/lib/perl5/DBI.pm line 708 via at ./pg_comparator line 729
-> STORE for DBD::Pg::db (DBI::db=HASH(0x8a55078)~INNER 'Username' 'fabien') thr#8880008
Begin dbd_db_STORE (key: Username newval: 1 kl:13307252)
End dbd_db_STORE_attrib
STORE DBI::db=HASH(0x8a55078) 'Username' => 'fabien'
<- STORE= 1 at /usr/lib/perl5/DBI.pm line 708 via at ./pg_comparator line 729
>> FETCH DISPATCH (DBI::db=HASH(0x8a55078) rc2/1 @2 g0 ima404 pid#27206) at /usr/lib/perl5/DBI.pm line 708 via at ./pg_comparator line 1049
<> FETCH= 'fabien' ('Username' from cache) at /usr/lib/perl5/DBI.pm line 708 via at ./pg_comparator line 1049
>> connected DISPATCH (DBI::db=HASH(0x8a55108) rc1/1 @5 g0 ima5 pid#27206) at /usr/lib/perl5/DBI.pm line 714 via at ./pg_comparator line 1049
-> connected for DBD::Pg::db (DBI::db=HASH(0x8a55108)~0x8a55078 'DBI:Pg:dbname=fabien;host=localhost;port=5432;' 'fabien' 'XXX' HASH(0x8a54828)) thr#8880008
<- connected= undef at /usr/lib/perl5/DBI.pm line 714 via at ./pg_comparator line 1049
<- connect= DBI::db=HASH(0x8a55108)
>> STORE DISPATCH (DBI::db=HASH(0x8a55078) rc2/1 @3 g0 ima41c pid#27206) at /usr/lib/perl5/DBI.pm line 723 via at ./pg_comparator line 729
-> STORE for DBD::Pg::db (DBI::db=HASH(0x8a55078)~INNER 'dbi_connect_closure' CODE(0x8a54cd8)) thr#8880008
Begin dbd_db_STORE (key: dbi_connect_closure newval: 1 kl:13307252)
End dbd_db_STORE_attrib
STORE DBI::db=HASH(0x8a55078) 'dbi_connect_closure' => CODE(0x8a54cd8)
<- STORE= 1 at /usr/lib/perl5/DBI.pm line 723 via at ./pg_comparator line 729
## checksumming...
## building checksum table cmp_2_0
### 2 CREATE TEMPORARY TABLE cmp_2_0 AS SELECT COALESCE(id::TEXT,'null') AS id, CKSUM8(COALESCE(id::TEXT,'null')) AS idc,CKSUM8(COALESCE(id::TEXT,'null')||':'||COALESCE(a1::TEXT,'null')||':'||COALESCE(a0::TEXT,'null')) AS cks FROM foo1
>> do DISPATCH (DBI::db=HASH(0x8a55108) rc1/3 @2 g0 ima3201 pid#27206) at ./pg_comparator line 789 via at ./pg_comparator line 801
-> do for DBD::Pg::db (DBI::db=HASH(0x8a55108)~0x8a55078 'CREATE TEMPORARY TABLE cmp_2_0 AS SELECT COALESCE(id::TEXT,'null') AS id, CKSUM8(COALESCE(id::TEXT,'null')) AS idc,CKSUM8(COALESCE(id::TEXT,'null')||':'||COALESCE(a1::TEXT,'null')||':'||COALESCE(a0::TEXT,'null')) AS cks FROM foo1 ') thr#8880008
Begin pg_quickexec (query: CREATE TEMPORARY TABLE cmp_2_0 AS SELECT COALESCE(id::TEXT,'null') AS id, CKSUM8(COALESCE(id::TEXT,'null')) AS idc,CKSUM8(COALESCE(id::TEXT,'null')||':'||COALESCE(a1::TEXT,'null')||':'||COALESCE(a0::TEXT,'null')) AS cks FROM foo1 async: 0 async_status: 0)
PQexec
Begin _sqlstate
PQresultStatus
PQresultErrorField
End _sqlstate (imp_dbh->sqlstate: 00000)
Begin PGTransactionStatusType
PQtransactionStatus
_sqlstate txn_status is 0
End _sqlstate (status: 1)
Got a status of 1
PQcmdStatus
PQclear
PQtransactionStatus
End pg_quickexec (rows: 0, txn_status: 0)
<- do= '0E0' at ./pg_comparator line 789 via at ./pg_comparator line 801
>> selectrow_array DISPATCH (DBI::db=HASH(0x8a55108) rc1/3 @2 g0 ima2001 pid#27206) at ./pg_comparator line 740 via at ./pg_comparator line 811
-> selectrow_array for DBD::Pg::db (DBI::db=HASH(0x8a55108)~0x8a55078 'SELECT COUNT(*) FROM cmp_2_0') thr#8880008
>> prepare DISPATCH (DBI::db=HASH(0x8a55078) rc1/1 @3 g0 imaa201 pid#27206) at ./pg_comparator line 740 via at ./pg_comparator line 811
1 -> prepare for DBD::Pg::db (DBI::db=HASH(0x8a55078)~INNER 'SELECT COUNT(*) FROM cmp_2_0' undef) thr#8880008
New 'DBI::st' (for DBD::Pg::st, parent=DBI::db=HASH(0x8a55078), id=undef)
dbih_setup_handle(DBI::st=HASH(0x8a55268)=>DBI::st=HASH(0x8a55218), DBD::Pg::st, 8a54e58, Null!)
dbih_make_com(DBI::db=HASH(0x8a55078), 8af87a0, DBD::Pg::st, 200, 0) thr#8880008
dbih_setup_attrib(DBI::st=HASH(0x8a55218), Err, DBI::db=HASH(0x8a55078)) SCALAR(0x8a54ba8) (already defined)
dbih_setup_attrib(DBI::st=HASH(0x8a55218), State, DBI::db=HASH(0x8a55078)) SCALAR(0x8a54b88) (already defined)
dbih_setup_attrib(DBI::st=HASH(0x8a55218), Errstr, DBI::db=HASH(0x8a55078)) SCALAR(0x8a54b98) (already defined)
dbih_setup_attrib(DBI::st=HASH(0x8a55218), TraceLevel, DBI::db=HASH(0x8a55078)) 0 (already defined)
dbih_setup_attrib(DBI::st=HASH(0x8a55218), FetchHashKeyName, DBI::db=HASH(0x8a55078)) 'NAME' (already defined)
dbih_setup_attrib(DBI::st=HASH(0x8a55218), HandleSetErr, DBI::db=HASH(0x8a55078)) undef (not defined)
dbih_setup_attrib(DBI::st=HASH(0x8a55218), HandleError, DBI::db=HASH(0x8a55078)) undef (not defined)
dbih_setup_attrib(DBI::st=HASH(0x8a55218), ReadOnly, DBI::db=HASH(0x8a55078)) undef (not defined)
dbih_setup_attrib(DBI::st=HASH(0x8a55218), Profile, DBI::db=HASH(0x8a55078)) undef (not defined)
Begin dbd_st_prepare (statement: SELECT COUNT(*) FROM cmp_2_0)
Begin pg_st_split_statement
pg_st_split_statement: (SELECT COUNT(*) FROM cmp_2_0)
Created segment (SELECT COUNT(*) FROM cmp_2_0)
Placeholder type: 0 numsegs: 1 numphs: 0
Placeholder numbers, ph id, and segments:
PH: (0) SEG: (SELECT COUNT(*) FROM cmp_2_0)
Placeholder number, fooname, id:
End pg_st_split_statement
Immediate prepare decision: dml=1 direct=0 server_prepare=1 prepare_now=0 PGLIBVERSION=80307
End dbd_st_prepare
1 <- prepare= DBI::st=HASH(0x8a55268) at ./pg_comparator line 740 via at ./pg_comparator line 811
Begin dbd_st_execute
PQexec* decision: dml=1 direct=0 server_prepare=1 numbound=0 numphs=0 default=0
PQexec
Running PQexec with (SELECT COUNT(*) FROM cmp_2_0)
PQexec
Begin _sqlstate
PQresultStatus
PQresultErrorField
End _sqlstate (imp_dbh->sqlstate: 00000)
Begin PGTransactionStatusType
PQtransactionStatus
_sqlstate txn_status is 0
End _sqlstate (status: 2)
PQnfields
PQntuples
Status was PGRES_TUPLES_OK, fields=1, tuples=1
End dbd_st_execute (rows: 1)
Begin dbd_st_fetch
PQntuples
dbih_setup_fbav alloc for 1 fields
dbih_setup_fbav now 1 fields
PQftype
Fetching field #0
PQgetisnull
PQgetvalue
End dbd_st_fetch
Begin dbdpg_finish (async: 0)
PQclear
End dbd_st_finish
<- selectrow_array= '98' at ./pg_comparator line 740 via at ./pg_comparator line 811
>> DESTROY DISPATCH (DBI::st=HASH(0x8a55268) rc1/1 @1 g0 ima10004 pid#27206) at ./pg_comparator line 1052 via at ./pg_comparator line 1052
<> DESTROY(DBI::st=HASH(0x8a55268)) ignored for outer handle (inner DBI::st=HASH(0x8a55218) has ref cnt 1)
>> DESTROY DISPATCH (DBI::st=HASH(0x8a55218) rc1/1 @1 g0 ima10004 pid#27206) at ./pg_comparator line 1052 via at ./pg_comparator line 1052
-> DESTROY for DBD::Pg::st (DBI::st=HASH(0x8a55218)~INNER) thr#8880008
Begin dbd_st_destroy
End dbd_st_destroy
<- DESTROY= undef at ./pg_comparator line 1052 via at ./pg_comparator line 1052
DESTROY (dbih_clearcom) (sth 0x8a55218, com 0x8ba2068, imp DBD::Pg::st):
FLAGS 0x100091: COMSET Warn RaiseError PrintWarn
PARENT DBI::db=HASH(0x8a55078)
KIDS 0 (0 Active)
NUM_OF_FIELDS 1
NUM_OF_PARAMS 0
dbih_clearcom 0x8a55218 (com 0x8ba2068, type 3) done.
# computing size and masks after folding factor...
### masks=127 0
# building summary tables...
## building summary table cmp_1_1 (0)
### 3 CREATE TEMPORARY TABLE cmp_1_1 AS SELECT idc & 0 AS idc, xor(cks) AS cks FROM cmp_1_0 GROUP BY idc & 0
>> do DISPATCH (DBI::db=HASH(0x8a54908) rc1/3 @2 g0 ima3201 pid#27206) at ./pg_comparator line 789 via at ./pg_comparator line 823
-> do for DBD::Pg::db (DBI::db=HASH(0x8a54908)~0x8a54858 'CREATE TEMPORARY TABLE cmp_1_1 AS SELECT idc & 0 AS idc, xor(cks) AS cks FROM cmp_1_0 GROUP BY idc & 0') thr#8880008
Begin pg_quickexec (query: CREATE TEMPORARY TABLE cmp_1_1 AS SELECT idc & 0 AS idc, xor(cks) AS cks FROM cmp_1_0 GROUP BY idc & 0 async: 0 async_status: 0)
PQexec
Begin _sqlstate
PQresultStatus
PQresultErrorField
End _sqlstate (imp_dbh->sqlstate: 00000)
Begin PGTransactionStatusType
PQtransactionStatus
_sqlstate txn_status is 0
End _sqlstate (status: 1)
Got a status of 1
PQcmdStatus
PQclear
PQtransactionStatus
End pg_quickexec (rows: 0, txn_status: 0)
<- do= '0E0' at ./pg_comparator line 789 via at ./pg_comparator line 823
## building summary table cmp_2_1 (0)
### 4 CREATE TEMPORARY TABLE cmp_2_1 AS SELECT idc & 0 AS idc, xor(cks) AS cks FROM cmp_2_0 GROUP BY idc & 0
>> do DISPATCH (DBI::db=HASH(0x8a55108) rc1/3 @2 g0 ima3201 pid#27206) at ./pg_comparator line 789 via at ./pg_comparator line 823
-> do for DBD::Pg::db (DBI::db=HASH(0x8a55108)~0x8a55078 'CREATE TEMPORARY TABLE cmp_2_1 AS SELECT idc & 0 AS idc, xor(cks) AS cks FROM cmp_2_0 GROUP BY idc & 0') thr#8880008
Begin pg_quickexec (query: CREATE TEMPORARY TABLE cmp_2_1 AS SELECT idc & 0 AS idc, xor(cks) AS cks FROM cmp_2_0 GROUP BY idc & 0 async: 0 async_status: 0)
PQexec
Begin _sqlstate
PQresultStatus
PQresultErrorField
End _sqlstate (imp_dbh->sqlstate: 00000)
Begin PGTransactionStatusType
PQtransactionStatus
_sqlstate txn_status is 0
End _sqlstate (status: 1)
Got a status of 1
PQcmdStatus
PQclear
PQtransactionStatus
End pg_quickexec (rows: 0, txn_status: 0)
<- do= '0E0' at ./pg_comparator line 789 via at ./pg_comparator line 823
# looking for differences...
### investigating level=1 ()
>> prepare DISPATCH (DBI::db=HASH(0x8a54908) rc1/3 @2 g0 imaa201 pid#27206) at ./pg_comparator line 841 via at ./pg_comparator line 903
-> prepare for DBD::Pg::db (DBI::db=HASH(0x8a54908)~0x8a54858 'SELECT idc, cks FROM cmp_1_1 ORDER BY idc, cks') thr#8880008
New 'DBI::st' (for DBD::Pg::st, parent=DBI::db=HASH(0x8a54858), id=undef)
dbih_setup_handle(DBI::st=HASH(0x8a55238)=>DBI::st=HASH(0x8a551b8), DBD::Pg::st, 8ba2658, Null!)
dbih_make_com(DBI::db=HASH(0x8a54858), 8a59b38, DBD::Pg::st, 200, 0) thr#8880008
dbih_setup_attrib(DBI::st=HASH(0x8a551b8), Err, DBI::db=HASH(0x8a54858)) SCALAR(0x89caa98) (already defined)
dbih_setup_attrib(DBI::st=HASH(0x8a551b8), State, DBI::db=HASH(0x8a54858)) SCALAR(0x89cab18) (already defined)
dbih_setup_attrib(DBI::st=HASH(0x8a551b8), Errstr, DBI::db=HASH(0x8a54858)) SCALAR(0x89caad8) (already defined)
dbih_setup_attrib(DBI::st=HASH(0x8a551b8), TraceLevel, DBI::db=HASH(0x8a54858)) 0 (already defined)
dbih_setup_attrib(DBI::st=HASH(0x8a551b8), FetchHashKeyName, DBI::db=HASH(0x8a54858)) 'NAME' (already defined)
dbih_setup_attrib(DBI::st=HASH(0x8a551b8), HandleSetErr, DBI::db=HASH(0x8a54858)) undef (not defined)
dbih_setup_attrib(DBI::st=HASH(0x8a551b8), HandleError, DBI::db=HASH(0x8a54858)) undef (not defined)
dbih_setup_attrib(DBI::st=HASH(0x8a551b8), ReadOnly, DBI::db=HASH(0x8a54858)) undef (not defined)
dbih_setup_attrib(DBI::st=HASH(0x8a551b8), Profile, DBI::db=HASH(0x8a54858)) undef (not defined)
Begin dbd_st_prepare (statement: SELECT idc, cks FROM cmp_1_1 ORDER BY idc, cks)
Begin pg_st_split_statement
pg_st_split_statement: (SELECT idc, cks FROM cmp_1_1 ORDER BY idc, cks)
Created segment (SELECT idc, cks FROM cmp_1_1 ORDER BY idc, cks)
Placeholder type: 0 numsegs: 1 numphs: 0
Placeholder numbers, ph id, and segments:
PH: (0) SEG: (SELECT idc, cks FROM cmp_1_1 ORDER BY idc, cks)
Placeholder number, fooname, id:
End pg_st_split_statement
Immediate prepare decision: dml=1 direct=0 server_prepare=1 prepare_now=0 PGLIBVERSION=80307
End dbd_st_prepare
<- prepare= DBI::st=HASH(0x8a55238) at ./pg_comparator line 841 via at ./pg_comparator line 903
### 5 SELECT idc, cks FROM cmp_1_1 ORDER BY idc, cks
>> execute DISPATCH (DBI::st=HASH(0x8a55238) rc1/1 @1 g0 ima1041 pid#27206) at ./pg_comparator line 845 via at ./pg_comparator line 903
-> execute for DBD::Pg::st (DBI::st=HASH(0x8a55238)~0x8a551b8) thr#8880008
Begin dbd_st_execute
PQexec* decision: dml=1 direct=0 server_prepare=1 numbound=0 numphs=0 default=0
PQexec
Running PQexec with (SELECT idc, cks FROM cmp_1_1 ORDER BY idc, cks)
PQexec
Begin _sqlstate
PQresultStatus
PQresultErrorField
End _sqlstate (imp_dbh->sqlstate: 00000)
Begin PGTransactionStatusType
PQtransactionStatus
_sqlstate txn_status is 0
End _sqlstate (status: 2)
PQnfields
PQntuples
Status was PGRES_TUPLES_OK, fields=2, tuples=1
End dbd_st_execute (rows: 1)
<- execute= 1 at ./pg_comparator line 845 via at ./pg_comparator line 903
>> prepare DISPATCH (DBI::db=HASH(0x8a55108) rc1/3 @2 g0 imaa201 pid#27206) at ./pg_comparator line 841 via at ./pg_comparator line 904
-> prepare for DBD::Pg::db (DBI::db=HASH(0x8a55108)~0x8a55078 'SELECT idc, cks FROM cmp_2_1 ORDER BY idc, cks') thr#8880008
New 'DBI::st' (for DBD::Pg::st, parent=DBI::db=HASH(0x8a55078), id=undef)
dbih_setup_handle(DBI::st=HASH(0x8a54e48)=>DBI::st=HASH(0x8a54a88), DBD::Pg::st, 8ba25b8, Null!)
dbih_make_com(DBI::db=HASH(0x8a55078), 8af87a0, DBD::Pg::st, 200, 0) thr#8880008
dbih_setup_attrib(DBI::st=HASH(0x8a54a88), Err, DBI::db=HASH(0x8a55078)) SCALAR(0x8a54ba8) (already defined)
dbih_setup_attrib(DBI::st=HASH(0x8a54a88), State, DBI::db=HASH(0x8a55078)) SCALAR(0x8a54b88) (already defined)
dbih_setup_attrib(DBI::st=HASH(0x8a54a88), Errstr, DBI::db=HASH(0x8a55078)) SCALAR(0x8a54b98) (already defined)
dbih_setup_attrib(DBI::st=HASH(0x8a54a88), TraceLevel, DBI::db=HASH(0x8a55078)) 0 (already defined)
dbih_setup_attrib(DBI::st=HASH(0x8a54a88), FetchHashKeyName, DBI::db=HASH(0x8a55078)) 'NAME' (already defined)
dbih_setup_attrib(DBI::st=HASH(0x8a54a88), HandleSetErr, DBI::db=HASH(0x8a55078)) undef (not defined)
dbih_setup_attrib(DBI::st=HASH(0x8a54a88), HandleError, DBI::db=HASH(0x8a55078)) undef (not defined)
dbih_setup_attrib(DBI::st=HASH(0x8a54a88), ReadOnly, DBI::db=HASH(0x8a55078)) undef (not defined)
dbih_setup_attrib(DBI::st=HASH(0x8a54a88), Profile, DBI::db=HASH(0x8a55078)) undef (not defined)
Begin dbd_st_prepare (statement: SELECT idc, cks FROM cmp_2_1 ORDER BY idc, cks)
Begin pg_st_split_statement
pg_st_split_statement: (SELECT idc, cks FROM cmp_2_1 ORDER BY idc, cks)
Created segment (SELECT idc, cks FROM cmp_2_1 ORDER BY idc, cks)
Placeholder type: 0 numsegs: 1 numphs: 0
Placeholder numbers, ph id, and segments:
PH: (0) SEG: (SELECT idc, cks FROM cmp_2_1 ORDER BY idc, cks)
Placeholder number, fooname, id:
End pg_st_split_statement
Immediate prepare decision: dml=1 direct=0 server_prepare=1 prepare_now=0 PGLIBVERSION=80307
End dbd_st_prepare
<- prepare= DBI::st=HASH(0x8a54e48) at ./pg_comparator line 841 via at ./pg_comparator line 904
### 6 SELECT idc, cks FROM cmp_2_1 ORDER BY idc, cks
>> execute DISPATCH (DBI::st=HASH(0x8a54e48) rc1/1 @1 g0 ima1041 pid#27206) at ./pg_comparator line 845 via at ./pg_comparator line 904
-> execute for DBD::Pg::st (DBI::st=HASH(0x8a54e48)~0x8a54a88) thr#8880008
Begin dbd_st_execute
PQexec* decision: dml=1 direct=0 server_prepare=1 numbound=0 numphs=0 default=0
PQexec
Running PQexec with (SELECT idc, cks FROM cmp_2_1 ORDER BY idc, cks)
PQexec
Begin _sqlstate
PQresultStatus
PQresultErrorField
End _sqlstate (imp_dbh->sqlstate: 00000)
Begin PGTransactionStatusType
PQtransactionStatus
_sqlstate txn_status is 0
End _sqlstate (status: 2)
PQnfields
PQntuples
Status was PGRES_TUPLES_OK, fields=2, tuples=1
End dbd_st_execute (rows: 1)
<- execute= 1 at ./pg_comparator line 845 via at ./pg_comparator line 904
>> FETCH DISPATCH (DBI::st=HASH(0x8a551b8) rc2/1 @2 g0 ima404 pid#27206) at ./pg_comparator line 912 via at ./pg_comparator line 1121
-> FETCH for DBD::Pg::st (DBI::st=HASH(0x8a551b8)~INNER 'Active') thr#8880008
Begin dbd_st_FETCH (key: Active)
End dbd_st_FETCH_attrib
.. FETCH DBI::st=HASH(0x8a551b8) 'Active' = 1
<- FETCH= 1 at ./pg_comparator line 912 via at ./pg_comparator line 1121
>> fetchrow_array DISPATCH (DBI::st=HASH(0x8a55238) rc1/1 @1 g1 ima0 pid#27206) at ./pg_comparator line 912 via at ./pg_comparator line 1121
-> fetchrow_array for DBD::Pg::st (DBI::st=HASH(0x8a55238)~0x8a551b8) thr#8880008
Begin dbd_st_fetch
PQntuples
dbih_setup_fbav alloc for 2 fields
dbih_setup_fbav now 2 fields
PQftype
PQftype
Fetching field #0
PQgetisnull
PQgetvalue
Fetching field #1
PQgetisnull
PQgetvalue
End dbd_st_fetch
<- fetchrow_array= ( '0' '-3840200448025967345' ) [2 items] row1 at ./pg_comparator line 912 via at ./pg_comparator line 1121
>> FETCH DISPATCH (DBI::st=HASH(0x8a54a88) rc2/1 @2 g0 ima404 pid#27206) at ./pg_comparator line 914 via at ./pg_comparator line 1121
-> FETCH for DBD::Pg::st (DBI::st=HASH(0x8a54a88)~INNER 'Active') thr#8880008
Begin dbd_st_FETCH (key: Active)
End dbd_st_FETCH_attrib
.. FETCH DBI::st=HASH(0x8a54a88) 'Active' = 1
<- FETCH= 1 at ./pg_comparator line 914 via at ./pg_comparator line 1121
>> fetchrow_array DISPATCH (DBI::st=HASH(0x8a54e48) rc1/1 @1 g1 ima0 pid#27206) at ./pg_comparator line 914 via at ./pg_comparator line 1121
-> fetchrow_array for DBD::Pg::st (DBI::st=HASH(0x8a54e48)~0x8a54a88) thr#8880008
Begin dbd_st_fetch
PQntuples
dbih_setup_fbav alloc for 2 fields
dbih_setup_fbav now 2 fields
PQftype
PQftype
Fetching field #0
PQgetisnull
PQgetvalue
Fetching field #1
PQgetisnull
PQgetvalue
End dbd_st_fetch
<- fetchrow_array= ( '0' '-3840200448025967345' ) [2 items] row1 at ./pg_comparator line 914 via at ./pg_comparator line 1121
>> FETCH DISPATCH (DBI::st=HASH(0x8a551b8) rc2/1 @2 g0 ima404 pid#27206) at ./pg_comparator line 912 via at ./pg_comparator line 1121
-> FETCH for DBD::Pg::st (DBI::st=HASH(0x8a551b8)~INNER 'Active') thr#8880008
Begin dbd_st_FETCH (key: Active)
End dbd_st_FETCH_attrib
.. FETCH DBI::st=HASH(0x8a551b8) 'Active' = 1
<- FETCH= 1 at ./pg_comparator line 912 via at ./pg_comparator line 1121
>> fetchrow_array DISPATCH (DBI::st=HASH(0x8a55238) rc1/1 @1 g1 ima0 pid#27206) at ./pg_comparator line 912 via at ./pg_comparator line 1121
-> fetchrow_array for DBD::Pg::st (DBI::st=HASH(0x8a55238)~0x8a551b8) thr#8880008
Begin dbd_st_fetch
PQntuples
Fetched the last tuple (1)
End dbd_st_fetch (last tuple)
<- fetchrow_array= ( ) [0 items] row1 at ./pg_comparator line 912 via at ./pg_comparator line 1121
>> FETCH DISPATCH (DBI::st=HASH(0x8a54a88) rc2/1 @2 g0 ima404 pid#27206) at ./pg_comparator line 914 via at ./pg_comparator line 1121
-> FETCH for DBD::Pg::st (DBI::st=HASH(0x8a54a88)~INNER 'Active') thr#8880008
Begin dbd_st_FETCH (key: Active)
End dbd_st_FETCH_attrib
.. FETCH DBI::st=HASH(0x8a54a88) 'Active' = 1
<- FETCH= 1 at ./pg_comparator line 914 via at ./pg_comparator line 1121
>> fetchrow_array DISPATCH (DBI::st=HASH(0x8a54e48) rc1/1 @1 g1 ima0 pid#27206) at ./pg_comparator line 914 via at ./pg_comparator line 1121
-> fetchrow_array for DBD::Pg::st (DBI::st=HASH(0x8a54e48)~0x8a54a88) thr#8880008
Begin dbd_st_fetch
PQntuples
Fetched the last tuple (1)
End dbd_st_fetch (last tuple)
<- fetchrow_array= ( ) [0 items] row1 at ./pg_comparator line 914 via at ./pg_comparator line 1121
>> finish DISPATCH (DBI::st=HASH(0x8a55238) rc1/1 @1 g0 ima1 pid#27206) at ./pg_comparator line 961 via at ./pg_comparator line 1121
-> finish for DBD::Pg::st (DBI::st=HASH(0x8a55238)~0x8a551b8) thr#8880008
<- finish= 1 at ./pg_comparator line 961 via at ./pg_comparator line 1121
>> finish DISPATCH (DBI::st=HASH(0x8a54e48) rc1/1 @1 g0 ima1 pid#27206) at ./pg_comparator line 962 via at ./pg_comparator line 1121
-> finish for DBD::Pg::st (DBI::st=HASH(0x8a54e48)~0x8a54a88) thr#8880008
<- finish= 1 at ./pg_comparator line 962 via at ./pg_comparator line 1121
>> DESTROY DISPATCH (DBI::st=HASH(0x8a54e48) rc1/1 @1 g0 ima10004 pid#27206) at ./pg_comparator line 966 via at ./pg_comparator line 966
<> DESTROY(DBI::st=HASH(0x8a54e48)) ignored for outer handle (inner DBI::st=HASH(0x8a54a88) has ref cnt 1)
>> DESTROY DISPATCH (DBI::st=HASH(0x8a54a88) rc1/1 @1 g0 ima10004 pid#27206) at ./pg_comparator line 966 via at ./pg_comparator line 966
-> DESTROY for DBD::Pg::st (DBI::st=HASH(0x8a54a88)~INNER) thr#8880008
Begin dbd_st_destroy
PQclear
End dbd_st_destroy
<- DESTROY= undef at ./pg_comparator line 966 via at ./pg_comparator line 966
DESTROY (dbih_clearcom) (sth 0x8a54a88, com 0x8ba2430, imp DBD::Pg::st):
FLAGS 0x180091: COMSET Warn RaiseError PrintWarn
PARENT DBI::db=HASH(0x8a55078)
KIDS 0 (0 Active)
NUM_OF_FIELDS 2
NUM_OF_PARAMS 0
dbih_clearcom 0x8a54a88 (com 0x8ba2430, type 3) done.
>> DESTROY DISPATCH (DBI::st=HASH(0x8a55238) rc1/1 @1 g0 ima10004 pid#27206) at ./pg_comparator line 966 via at ./pg_comparator line 966
<> DESTROY(DBI::st=HASH(0x8a55238)) ignored for outer handle (inner DBI::st=HASH(0x8a551b8) has ref cnt 1)
>> DESTROY DISPATCH (DBI::st=HASH(0x8a551b8) rc1/1 @1 g0 ima10004 pid#27206) at ./pg_comparator line 966 via at ./pg_comparator line 966
-> DESTROY for DBD::Pg::st (DBI::st=HASH(0x8a551b8)~INNER) thr#8880008
Begin dbd_st_destroy
PQclear
End dbd_st_destroy
<- DESTROY= undef at ./pg_comparator line 966 via at ./pg_comparator line 966
DESTROY (dbih_clearcom) (sth 0x8a551b8, com 0x8ba3678, imp DBD::Pg::st):
FLAGS 0x180091: COMSET Warn RaiseError PrintWarn
PARENT DBI::db=HASH(0x8a54858)
KIDS 0 (0 Active)
NUM_OF_FIELDS 2
NUM_OF_PARAMS 0
dbih_clearcom 0x8a551b8 (com 0x8ba3678, type 3) done.
# done, 0 differences found...
>> disconnect DISPATCH (DBI::db=HASH(0x8a54908) rc2/1 @1 g0 ima10c01 pid#27206) at ./pg_comparator line 1265
-> disconnect for DBD::Pg::db (DBI::db=HASH(0x8a54908)~0x8a54858) thr#8880008
Begin dbd_db_disconnect
Begin dbd_db_rollback
Begin pg_db_rollback_commit (action: rollback AutoCommit: 1 BegunWork: 0)
End pg_db_rollback_commit (result: 0)
PQfinish
Disconnection complete
End dbd_db_disconnect
<- disconnect= 1 at ./pg_comparator line 1265
>> disconnect DISPATCH (DBI::db=HASH(0x8a55108) rc1/1 @1 g0 ima10c01 pid#27206) at ./pg_comparator line 1265
-> disconnect for DBD::Pg::db (DBI::db=HASH(0x8a55108)~0x8a55078) thr#8880008
Begin dbd_db_disconnect
Begin dbd_db_rollback
Begin pg_db_rollback_commit (action: rollback AutoCommit: 1 BegunWork: 0)
End pg_db_rollback_commit (result: 0)
PQfinish
Disconnection complete
End dbd_db_disconnect
<- disconnect= 1 at ./pg_comparator line 1265
>> DESTROY DISPATCH (DBI::db=HASH(0x8a55108) rc1/1 @1 g0 ima10004 pid#27206)
<> DESTROY(DBI::db=HASH(0x8a55108)) ignored for outer handle (inner DBI::db=HASH(0x8a55078) has ref cnt 1)
>> DESTROY DISPATCH (DBI::db=HASH(0x8a55078) rc1/1 @1 g0 ima10004 pid#27206)
-> DESTROY for DBD::Pg::db (DBI::db=HASH(0x8a55078)~INNER) thr#8880008
Begin dbd_db_destroy
End dbd_db_destroy
<- DESTROY= undef
DESTROY (dbih_clearcom) (dbh 0x8a55078, com 0x8af87a0, imp DBD::Pg::db):
FLAGS 0x180291: COMSET Warn RaiseError PrintWarn AutoCommit
PARENT DBI::dr=HASH(0x8a4f630)
KIDS 0 (0 Active)
dbih_clearcom 0x8a55078 (com 0x8af87a0, type 2) done.
-- DBI::END ($@: , $!: )
>> disconnect_all DISPATCH (DBI::dr=HASH(0x8987608) rc1/4 @1 g0 ima801 pid#27206) at /usr/lib/perl5/DBI.pm line 731 via at ./pg_comparator line 0
-> disconnect_all for DBD::Pg::dr (DBI::dr=HASH(0x8987608)~0x8a4f630) thr#8880008
Begin dbd_discon_all
End dbd_discon_all
<- disconnect_all= '' at /usr/lib/perl5/DBI.pm line 731 via at ./pg_comparator line 0
! >> DESTROY DISPATCH (DBI::db=HASH(0x8a54908) rc1/1 @1 g0 ima10004 pid#27206) during global destruction
! <> DESTROY(DBI::db=HASH(0x8a54908)) ignored for outer handle (inner DBI::db=HASH(0x8a54858) has ref cnt 1)
! >> DESTROY DISPATCH (DBI::db=HASH(0x8a54858) rc1/1 @1 g0 ima10004 pid#27206) during global destruction
! -> DESTROY for DBD::Pg::db (DBI::db=HASH(0x8a54858)~INNER) thr#8880008
Begin dbd_db_destroy
End dbd_db_destroy
! <- DESTROY= undef during global destruction
DESTROY (dbih_clearcom) (dbh 0x8a54858, com 0x8a59b38, imp global destruction):
FLAGS 0x180291: COMSET Warn RaiseError PrintWarn AutoCommit
PARENT DBI::dr=HASH(0x8a4f630)
KIDS 0 (0 Active)
dbih_clearcom 0x8a54858 (com 0x8a59b38, type 2) done.
! >> DESTROY DISPATCH (DBI::dr=HASH(0x8987608) rc1/1 @1 g0 ima10004 pid#27206) during global destruction
! <> DESTROY(DBI::dr=HASH(0x8987608)) ignored for outer handle (inner DBI::dr=HASH(0x8a4f630) has ref cnt 1)
! >> DESTROY DISPATCH (DBI::dr=HASH(0x8a4f630) rc1/1 @1 g0 ima10004 pid#27206) during global destruction
! -> DESTROY in DBD::_::common for DBD::Pg::dr (DBI::dr=HASH(0x8a4f630)~INNER) thr#8880008
! <- DESTROY= undef during global destruction
DESTROY (dbih_clearcom) (drh 0x8a4f630, com 0x8ab09e0, imp global destruction):
FLAGS 0x180215: COMSET Active Warn PrintWarn AutoCommit
PARENT undef
KIDS 1 (0 Active)
dbih_clearcom 0x8a4f630 (com 0x8ab09e0, type 1) done.