[pgpool-general-jp: 695] Re: pgpool2-2.3.1/insufficient data left in message
皿海 太二朗
saragai ＠ mbgx.tis.co.jp
2010年 2月 1日 (月) 10:13:16 JST
$B ＠ PED$5$s(B
$BD4::$"$j$,$H$&$4$6$$$^$7$?!#(B
$B$3$A$i$G$bF0:n8!>Z$r<B;\$7$F$_$^$9!#(B
$B2?$+$"$l$P:FEY$4O"Mm$5$;$F$$$?$@$-$^$9!#(B
$B0J>e!"$h$m$7$/$*4j$$CW$7$^$9!#(B
Tatsuo Ishii $B$5$s$O=q$-$^$7$?(B:
> $B ＠ PED$5$s(B
>
> $BD4::$"$j$,$H$&$4$6$$$^$9!#@P0f$G$9!#%Q%C%A$r(BCVS HEAD$B$K%3%_%C%H$7$F$*$-(B
> $B$^$9!#(B
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
>
>
>> $B ＠ PED$G$9!#$"$j$,$H$&$4$6$$$^$7$?!#(B
>>
>> $B$b$&FsE@!"D4$Y$F$$$kESCf$G5$IU$$$?$N$G$9$,!"(B
>>
>> 1. $B%?%$%`%9%?%s%W$r4^$`(Bprepare$BJ8$N%Q%i%a!<%??t$,4V0c$C$F$$$^$7$?(B
>>
>> 2. connection_cache = false
>> $B$N>l9g!"(Bprepared_list$B$,%j%;%C%H$5$l$^$;$s!#(B
>> 2.2$B0JA0$GLdBj$,H/@8$9$k$+$I$&$+$O$o$+$j$^$;$s$,!"(B
>> 2.3$B$G$O(BPortal$B$K%Q%i%a!<%??t$r$b$C$F$$$k$N$G(B
>> $B ＠ ZCG(B / $B@\B38e$K!"F1$8L>A0$G0[$kDj5A$N%9%F!<%H%a%s%H$r(B
>> $B;H$&$H%(%i!<$H$J$j$^$9!#(B
>>
>> pool_test=# prepare q1 as insert into r1 values(1, '2010-01-01');
>> PREPARE
>> pool_test=# \q
>> $ psql -X -p9999 pool_test
>> psql (8.4.1)
>> Type "help" for help.
>>
>> pool_test=# prepare q1 as insert into r1 values(1, now());
>> PREPARE
>> pool_test=# execute q1;
>> ERROR: wrong number of parameters for prepared statement "q1"
>> DETAIL: Expected 2 parameters but got 1.
>>
>> $B ＠ P0f$5$s$NJ}$K$O(BHEAD$B$KBP$9$k%Q%C%A$rE:IU$7$^$9!#(B
>> 2.$B$NJ}$N%Q%C%A$O$A$g$C$HL>A0$,%$%^%$%A$J46$8$,$7$^$9$,$H$j$$$=$.!#(B
>>
>> 2010$BG/(B1$B7n(B30$BF|(B11:04 Tatsuo Ishii <ishii ＠ sraoss.co.jp>:
>>
>>> $B ＠ P0f$G$9!#(B
>>>
>>> $B0J2<$N7o$G$9$,!"860x$,J,$+$j$^$7$?!#(Bparse()$B$NCf$G!"(Bnow()$BBP1~$N%/%(%j=q(B
>>> $B$-49$($r9T$J$$!"%^%9%?%N!<%I$K%Q%1%C%H$rAw?.$7$?8e%Q%1%C%HMQ$N%a%b%j$r(B
>>> $B2rJ|$7$F$+$i%9%l!<%V$K%Q%1%C%H$rAw?.$7$?$N$,860x$G$7$?!#$9$G$K2rJ|$5$l(B
>>> $B$?%a%b%j$N%G!<%?$rAw?.$7$?$?$a$K!"%4%_$,(BPostgreSQL$B$KAw$i$l$F$7$^$C$F$$(B
>>> $B$?$N$G$9!#(B
>>>
>>> CVS HEAD$B$K$O=$@5$r%3%_%C%H$7$^$7$?!#(B
>>> --
>>> Tatsuo Ishii
>>> SRA OSS, Inc. Japan
>>> English: http://www.sraoss.co.jp/index_en.php
>>> Japanese: http://www.sraoss.co.jp
>>>
>>>
>>>> $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
>>>>>
>>>>>
>>>>
>>> _______________________________________________
>>> pgpool-general-jp mailing list
>>> pgpool-general-jp ＠ sraoss.jp
>>> http://www.sraoss.jp/mailman/listinfo/pgpool-general-jp
>>>
>>>
>>>
>>
>> --
>> ISHIDA Akio <iakio ＠ mono-space.net/ishida ＠ cycleof5th.com>
>>
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> pgpool-general-jp mailing list
>> pgpool-general-jp ＠ sraoss.jp
>> http://www.sraoss.jp/mailman/listinfo/pgpool-general-jp
>>
--
==============================================
TIS$B3t<02q<R(B
$B%5!<%S%9(B&$B%3%_%e%K%1!<%7%g%s;v6HIt(B
$B%5!<%S%9Bh(B3$BIt(B
$B;.3$!!B ＠ FsO/(B
E-mail:saragai ＠ mbgx.tis.co.jp
$B")(B105-8624
$B!!!!!!El5~ET9A6h3$4_(B1-14-5
$B!!!!!!(BTIS$BC]<G%S%k(B3F
TEL$B!'(B03-5402-2173 FAX$B!'(B03-5402-2383
=============================================
pgpool-general-jp メーリングリストの案内