Tue May 3 08:54:49 PDT 2005
- Previous message: [Slony1-general] MOVE SET problem
- Next message: [Slony1-general] MOVE SET problem
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
> 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
- Previous message: [Slony1-general] MOVE SET problem
- Next message: [Slony1-general] MOVE SET problem
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list