[pgpool-general: 784] Re: Possible bug in memory query cache pgpool-II3.2 RC1

Lazáro Rubén García Martínez lgarciam at vnz.uci.cu
Sun Jul 22 08:00:06 JST 2012


Has the pgpool-II snapshot in the git repository this patch, for downloading and installing pgpool-II from it?

Regards.
________________________________________
From: Tatsuo Ishii [ishii at postgresql.org]
Sent: Saturday, July 21, 2012 6:00 PM
To: Lazáro Rubén García Martínez
Cc: pgpool-general at pgpool.net
Subject: Re: [pgpool-general: 780] Possible bug in memory query cache pgpool-II3.2 RC1

Oops. There was a bug with schema qualified table name case.  Please
try included patch. The patch should be applied after pevious patch
applied.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> Tatsuo, thank you very much for the patch. I have installed pgpool again, however the problem persists now with this query:
>
> 2012-07-21 14:53:09 LOG:   pid 17467: query result fetched from cache. statement: SELECT * FROM public.users WHERE public.users.name = 'solicitantep'
>
> Attached are the pgpool.log and pgpool.conf file.
>
> Regards.
> ________________________________________
> From: Tatsuo Ishii [ishii at postgresql.org]
> Sent: Saturday, July 21, 2012 7:34 AM
> To: Lazáro Rubén García Martínez
> Cc: pgpool-general at pgpool.net
> Subject: Re: [pgpool-general: 780] Possible bug in memory query cache pgpool-II3.2 RC1
>
> Thanks for the report. It seems the functionality has problem when
> table alias is used.  Such an example query in your log is "SELECT
> n.nid FROM node n WHERE n.status = 1 AND n.nid IN (130);".
> Attached patch should fix the problem.
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
>
>> Hello everyone in the list, testing pgpool-II 3.2 RC1 I am noticed a problem.
>>
>> I am configured pgpool-II for using the new functionality on memory query cache with shmen. I need that some tables will be cached however there are other tables that are cached too.
>>
>> In the log file there are many lines like this:
>>
>> 2012-07-20 22:24:06 LOG:   pid 13580: query result fetched from cache. statement: SELECT n.nid FROM node n WHERE n.status = 1 AND n.nid IN (130)
>>
>> Attached is the pgpool.log and pgpool.conf file.
>>
>> Thank you very much for your time.
>> Regards.
>>
>>
>> Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!
>> http://www.antiterroristas.cu
>> http://justiciaparaloscinco.wordpress.com
>
> Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!
> http://www.antiterroristas.cu
> http://justiciaparaloscinco.wordpress.com
>
> Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!
> http://www.antiterroristas.cu
> http://justiciaparaloscinco.wordpress.com

Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!
http://www.antiterroristas.cu
http://justiciaparaloscinco.wordpress.com

Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!
http://www.antiterroristas.cu
http://justiciaparaloscinco.wordpress.com


More information about the pgpool-general mailing list