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