[pgpool-general-jp: 681] Re: pgpool2-2.3.1/insufficient data left in message

2010年 1月 22日 (金) 16:58:56 JST

$B;.3$$G$9!#(B

$B ＠ PED$5$s!"$4O"Mm$"$j$,$H$&$4$6$$$^$9!#(B

pgpool.conf$B$H%(%i!<$,=P$?%F!<%V%k$N%+%i%`Dj5A>pJs$r$*EA$($7$^$9!#(B
PHP$BB&$N%3!<%I$O%Q%C%1!<%8$N$?$a!"AwIU$,Fq$7$$>uBV$G$9!#(B
$B?=$7Lu$4$"$j$^$;$s!#(B

$B!Z(Bpgpool.conf$B![(B
listen_addresses = '*'
port = 5432
pcp_port = 9898
socket_dir = '/tmp'
pcp_socket_dir = '/tmp'
backend_socket_dir = '/tmp'
pcp_timeout = 10
num_init_children = 100
max_pool = 10
child_life_time = 300
connection_life_time = 900
child_max_connections = 100
client_idle_limit = 60
authentication_timeout = 10
logdir = '/var/log/pgpool'
pid_file_name = '/var/run/pgpool/pgpool.pid'
replication_mode = true
replicate_select = false
load_balance_mode = false
replication_stop_on_mismatch = true
reset_query_list = 'ABORT; DISCARD ALL'
print_timestamp = true
master_slave_mode = false
connection_cache = false
health_check_timeout = 20
health_check_period = 0
health_check_user = 'postgres'
failover_command='sudo /home/ifrbat/pgsql/sh/PgReplicationProtector.sh
%h %p'
failback_command=''
insert_lock = true
ignore_leading_white_space = true
log_statement = false
log_connections = true
log_hostname = true
parallel_mode = false
enable_query_cache = false
pgpool2_hostname = 'test04'

backend_hostname0 = '172.16.48.188'
backend_port0 = 5433
backend_weight0 = 1
backend_data_directory0 = '/home/postgres/data'

backend_hostname1 = '172.16.48.185'
backend_port1 = 5432
backend_weight1 = 1
backend_data_directory1 = '/home/postgres/data'

recovery_timeout = 90
client_idle_limit_in_recovery = 0

$B!Z%F!<%V%k$N%+%i%`Dj5A![(B
# \d tmp_control_area_table
         Table "public.tmp_control_area_table"
     Column      |           Type           | Modifiers
-----------------+--------------------------+-----------
 session_id      | character varying(1000)  |
 page_id         | integer                  |
 revision        | smallint                 |
 parent_page_id  | integer                  |
 level           | smallint                 |
 tmp_update_date | timestamp with time zone |

$B0J>e!"$*<j?t$G$9$,$h$m$7$/$*4j$$CW$7$^$9!#(B


ISHIDA Akio $B$5$s$O=q$-$^$7$?(B:
> $B$3$s$K$A$O!#@PED$G$9!#(B
>
> $B$A$g$C$H$^$@8!F$$,$D$$$F$$$J$$$N$G$9$,!"%m%0$r8+$?46$8$G$O(B
> Parse$B$, ＠ .8y$7$?%N!<%I$H<:GT$7$?%N!<%I$,$$$k$h$&$G$9!#(B
>
> pgpool.conf$B$r$_$;$F$$$?$@$/$3$H$O$G$-$^$9$+!)(B
> $B$^$?!"(BPHP$BB&$N%3!<%I$r$_$;$F$$$?$@$1$k$H=u$+$j$^$9!#(B
>
> 2010$BG/(B1$B7n(B20$BF|(B20:06 $B;.3$!!B ＠ FsO/(B <saragai ＠ mbgx.tis.co.jp>:
>   
>> $B;.3$$G$9!#(B
>>
>> $BD9J8$H$J$j$^$9$,!"$*5v$7$/$@$5$$!#(B
>>
>> pgpool$B-6(B-2.2.6$B$+$i(B2.3.1$B$X%P!<%8%g%s%"%C%W$7$?$H$3$m!"(B
>> $B2<5-(Bpgpool$B$N%m%0$K$"$j$^$9(BSQL$B$K$F%(%i!<$,H/@8$7!"(B
>> $B=LB`2TF0$5$l$k$H$$$&;v>]$,H/@8$7$F$*$j$^$9!#(B
>>
>> $B!Z(Bpgpool$B%m%0![(B
>> 2010-01-19 19:36:07 ERROR: pid 19213: read_kind_from_backend:
>> 1 th kind E does not match with master or majority connection kind 1
>> 2010-01-19 19:36:07 ERROR: pid 19213: kind mismatch among backends.
>> Possible last query was: "Parse: INSERT INTO tmp_control_area_table
>> SELECT 'fcslck9if50hqa4dv73s3lnad6', p.page_id, pr.revision,
>> p.parent_page_id, 1, NOW()
>> FROM page p, page_revision pr
>> WHERE p.parent_page_id IN
>> (SELECT page_id FROM tmp_control_area_table
>> WHERE "level" = 0
>> AND session_id = 'fcslck9if50hqa4dv73s3lnad6'
>> )
>> AND p.page_id = pr.page_id
>> AND p.link_flag = 1" kind details are: 0[1] 1[E: insufficient data left
>> in message]
>> 2010-01-19 19:36:07 LOG: pid 19213: notice_backend_error: 1 fail over
>> request from pid 19213
>> 2010-01-19 19:36:07 LOG: pid 19115: starting degeneration. shutdown host
>> 172.16.48.185(5432)
>> 2010-01-19 19:36:07 LOG: pid 19115: failover_handler: set new master node: 0
>> 2010-01-19 19:36:07 LOG: pid 19115: failover done. shutdown host
>> 172.16.48.185(5432)
>>
>> $B;v>]$NH/@8860x$O(Bpgpool$B$N%P!<%8%g%s%"%C%W$K$h$k$b$N$H9M$($F$*$j!"(B
>> $B%P%0$N5?$$$b$"$k$?$a!"860x$rD4::$$$?$@$/$3$H$O2DG=$G$7$g$&$+!#(B
>>
>> $BB>$N>pJs$K$D$$$F$O0J2<$NDL$j$G$9!#(B
>> $B!Z(Bpostgres$B%m%0(B($B ＠ Z$jN%$5$l$?%5!<%P$N$_=PNO(B)$B![(B
>> 2010-01-19 19:36:07 JST:10514 ERROR:  insufficient data left in message
>>
>> $B!Z(Bphp PDO$B$G<hF@$7$?%(%i!<7k2L![(B
>> SQLSTATE[XX000]: Internal error: 7 ERROR: kind mismatch among backends.
>> Possible last que
>> ry was: "Parse: INSERT INTO tmp_control_area_table
>> SELECT 'fcslck9if50hqa4dv73s3lnad6', p.page_id, pr.revision,
>> p.parent_page_id, 1,NOW()
>> FROM page p, page_revision pr
>> WHERE p.parent_page_id IN
>> (SEL
>> server closed the connection unexpectedly
>> This probably means the server terminated abnormally
>> before or while processing the request.
>>
>> $B!Z(Bpostgresql$B$N%P!<%8%g%s![(B
>> 8.3.7
>>
>>
>> $B0J>e!"$h$m$7$/$*4j$$$7$^$9!#(B
>>
>>
>> _______________________________________________
>> pgpool-general-jp mailing list
>> pgpool-general-jp ＠ sraoss.jp
>> http://www.sraoss.jp/mailman/listinfo/pgpool-general-jp
>>
>>
>>     
>
>
>
>   
> ------------------------------------------------------------------------
>
> _______________________________________________
> pgpool-general-jp mailing list
> pgpool-general-jp ＠ sraoss.jp
> http://www.sraoss.jp/mailman/listinfo/pgpool-general-jp
>