http://www.slony.info/bugzilla/show_bug.cgi?id=188

           Summary: ERROR:  more than one row returned by a subquery used
                    as an expression
           Product: Slony-I
           Version: devel
          Platform: All
        OS/Version: All
            Status: ASSIGNED
          Severity: major
          Priority: medium
         Component: other scripts
        AssignedTo: cbbrowne at ca.afilias.info
        ReportedBy: cbbrowne at ca.afilias.info
                CC: slony1-bugs at lists.slony.info
   Estimated Hours: 0.0


Tests occasionally get hung up for a while when a slon process complains for a
while with the following error:

Dec 31 11:47:25 cbbrowne postgres[13812]: [2-1] ERROR:  more than one row
returned by a subquery used as an expression
Dec 31 11:47:25 cbbrowne postgres[13812]: [2-2] STATEMENT:  select count(*)
from "_slony_regress1".sl_log_1 l
Dec 31 11:47:25 cbbrowne postgres[13812]: [2-3] #011where
not(txid_visible_in_snapshot(l.log_txid, (select ev_snapshot from
"_slony_regress1".sl_event where ev_timestamp = (select max(ev_timestamp) from
"_slony_regress1".sl_event))));

The trouble here is that there may be multiple snapshots with the same
timestamp.

Problem is in tests/poll_cluster.sh

-- 
Configure bugmail: http://www.slony.info/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.