Julian Scarfe julian
Tue May 3 08:54:49 PDT 2005
> Could you perchance do the query:
>
> select * from "_T1".sl_event where ev_type in ('ACCEPT_SET', 'MOVE_SET');
>
> And do that on both nodes?  That would be helpful...
>

On the old master (host k)

avbrief=# select * from "_T1".sl_event where ev_type in ('ACCEPT_SET', 
'MOVE_SET');
-[ RECORD 1 ]+---------------------------
ev_origin    | 1
ev_seqno     | 15301
ev_timestamp | 2005-05-03 07:50:37.854374
ev_minxid    | 54193596
ev_maxxid    | 54193599
ev_xip       | '54193596'
ev_type      | MOVE_SET
ev_data1     | 1
ev_data2     | 1
ev_data3     | 2
ev_data4     |
ev_data5     |
ev_data6     |
ev_data7     |
ev_data8     |

On the prospective new master (host j)

avbrief=# select * from "_T1".sl_event where ev_type in ('ACCEPT_SET', 
'MOVE_SET');
-[ RECORD 1 ]+---------------------------
ev_origin    | 2
ev_seqno     | 14015
ev_timestamp | 2005-05-03 07:50:35.336735
ev_minxid    | 4163922
ev_maxxid    | 4163925
ev_xip       | '4163923','4163922'
ev_type      | ACCEPT_SET
ev_data1     | 1
ev_data2     | 1
ev_data3     | 2
ev_data4     |
ev_data5     |
ev_data6     |
ev_data7     |
ev_data8     |
-[ RECORD 2 ]+---------------------------
ev_origin    | 1
ev_seqno     | 15301
ev_timestamp | 2005-05-03 07:50:37.854374
ev_minxid    | 54193596
ev_maxxid    | 54193599
ev_xip       | '54193596'
ev_type      | MOVE_SET
ev_data1     | 1
ev_data2     | 1
ev_data3     | 2
ev_data4     |
ev_data5     |
ev_data6     |
ev_data7     |
ev_data8     |


> I'm seeing the situation where there is a NULL sequence number in the
> 4th data field for the ACCEPT_SET event, and that is causing the
> ACCEPT_SET event to fall over relatively silently when the
> remote_worker.c code tries to translate NULL into a sequence number.

Looks like it.

Julian 




More information about the Slony1-general mailing list