[Pgpool-general] different tables by restarting pgpool multiple times

[Martin Fandel]

Hi,

i'm having problems to hold all nodes up to date. Here is the re-adjust:

1. starting pgpool

        /usr/local/bin/pgpool -c -n

2. created a testtable
        
        psql -U postgres -d pgpool -h 127.0.0.1 -p 9999 -c "drop table
        test; create table test (id serial primary key, name
        varchar(10), vname varchar(10))";

3. count at table before insert

        Every 2.0s: ./e_test_table_count.sh
        Tue Oct 31 18:17:30 2006
        
         count
        -------
             0
        (1 row)
        
         count
        -------
             0
        (1 row)
        
         count
        -------
             0
        (1 row)

4. random insert into test-table

        while true; do psql -U postgres -d pgpool -h 192.168.131.12 -p
        9999 -c "insert into test (name, vname) values('test',
        'test');"; done
        
5. while insert, stopping and starting pgpool a lot of times (every 1
second)

        postgres-n3:/usr/local/pgcluster/scripts # ./c_pgpool_start.sh 
        2006-10-31 18:20:46 LOG:   pid 6279: pgpool successfully started
        2006-10-31 18:20:46 LOG:   pid 6279: starting health checking
        2006-10-31 18:20:46 LOG:   pid 6310: statement: insert into test
        (name, vname) values('test', 'test');
        2006-10-31 18:20:46 LOG:   pid 6310: statement:  RESET ALL
        2006-10-31 18:20:46 LOG:   pid 6310: statement:  SET SESSION
        AUTHORIZATION DEFAULT
        2006-10-31 18:20:46 LOG:   pid 6309: statement: insert into test
        (name, vname) values('test', 'test');
        2006-10-31 18:20:46 LOG:   pid 6309: statement:  RESET ALL
        2006-10-31 18:20:46 LOG:   pid 6309: statement:  SET SESSION
        AUTHORIZATION DEFAULT
        2006-10-31 18:20:46 LOG:   pid 6279: received fast shutdown
        request
        postgres-n3:/usr/local/pgcluster/scripts # ./c_pgpool_start.sh 
        2006-10-31 18:20:47 LOG:   pid 6323: pgpool successfully started
        2006-10-31 18:20:47 LOG:   pid 6323: starting health checking
        2006-10-31 18:20:47 LOG:   pid 6324: statement: insert into test
        (name, vname) values('test', 'test');
        2006-10-31 18:20:47 LOG:   pid 6324: statement:  RESET ALL
        2006-10-31 18:20:47 LOG:   pid 6324: statement:  SET SESSION
        AUTHORIZATION DEFAULT
        2006-10-31 18:20:47 LOG:   pid 6355: statement: insert into test
        (name, vname) values('test', 'test');
        2006-10-31 18:20:47 LOG:   pid 6323: received fast shutdown
        request
        postgres-n3:/usr/local/pgcluster/scripts # ./c_pgpool_start.sh 
        2006-10-31 18:20:47 LOG:   pid 6367: pgpool successfully started
        2006-10-31 18:20:47 LOG:   pid 6367: starting health checking
        2006-10-31 18:20:47 LOG:   pid 6399: statement: insert into test
        (name, vname) values('test', 'test');
        2006-10-31 18:20:47 LOG:   pid 6399: statement:  RESET ALL
        2006-10-31 18:20:47 LOG:   pid 6399: statement:  SET SESSION
        AUTHORIZATION DEFAULT
        2006-10-31 18:20:47 LOG:   pid 6398: statement: insert into test
        (name, vname) values('test', 'test');
        2006-10-31 18:20:47 LOG:   pid 6367: received fast shutdown
        request
        postgres-n3:/usr/local/pgcluster/scripts # ./c_pgpool_start.sh 
        2006-10-31 18:20:48 LOG:   pid 6411: pgpool successfully started
        2006-10-31 18:20:48 LOG:   pid 6411: starting health checking
        2006-10-31 18:20:48 LOG:   pid 6426: statement: insert into test
        (name, vname) values('test', 'test');
        2006-10-31 18:20:48 LOG:   pid 6426: statement:  RESET ALL
        2006-10-31 18:20:48 LOG:   pid 6426: statement:  SET SESSION
        AUTHORIZATION DEFAULT
        2006-10-31 18:20:48 LOG:   pid 6443: statement: insert into test
        (name, vname) values('test', 'test');
        2006-10-31 18:20:48 LOG:   pid 6411: received fast shutdown
        request


6. comparing tables (tables are different?!?!)

        count
        -------
            47
        (1 row)
        
         count
        -------
            45
        (1 row)
        
         count
        -------
            45
        (1 row)
        
Maybe someone can help me? 

Thanks!

Regards,

Martin