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

Tatsuo Ishii ishii at postgresql.org
Fri Jul 27 12:12:00 JST 2012


> Hello everyone in the list.
> 
> Tatsuo, as the documentation says, only the INMUTABLE functions are cached. Is there reason whereby the STABLE functions are not be cached?.

STABLE functions could return different results even if their parameters are identical.
BTW, current_timestamp is a stable function.

> Is there any news for caching data when the query are into the explicit transaction?

Nozomi has completed the patch. I'm going to review now.

> The patch related with SSL was commited into de pgpool-II 3.2 RC1 code?
> http://www.pgpool.net/pipermail/pgpool-general/2012-July/000807.html

No.

> Regards.
> 
> ________________________________________
> From: pgpool-general-bounces at pgpool.net [pgpool-general-bounces at pgpool.net] On Behalf Of Lazáro Rubén García Martínez [lgarciam at vnz.uci.cu]
> Sent: Sunday, July 22, 2012 10:47 PM
> To: Tatsuo Ishii
> Cc: pgpool-general at pgpool.net
> Subject: [pgpool-general: 791] Re: Possible bug in memory query cache pgpool-II3.2 RC1
> 
> Tatsuo thank you very much for your answer, I have configured white_memqcache_table_list  property like this '.*tbl_direccion_pais'. In the pgpool.conf file there is the complete configuration of this parameter. Now its works, however there is other problem.
> 
> When in from of the query there is a comment, there query are not cached, and if there is not a comment the query is cached.
> 
> For instance:
> 
> /* criteria query */ select this_.pk_naturaleza_solicitud as pk1_84_0_, this_.naturaleza_solicitud as naturaleza2_84_0_ from public.tbl_nnaturaleza_solicitud this_
> 
> No query cached.
> 
> select this_.pk_naturaleza_solicitud as pk1_84_0_, this_.naturaleza_solicitud as naturaleza2_84_0_ from public.tbl_nnaturaleza_solicitud this_
> 
> Query cached.
> 
> Attached are the pgpool.log and pgpool.conf files.
> 
> Thank you very much for your time.
> Regards.
> 
> ________________________________________
> From: Tatsuo Ishii [ishii at postgresql.org]
> Sent: Sunday, July 22, 2012 12:55 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
> 
> You need to add something like "public.tbl_nnaturaleza_.*" to
> white_memqcache_table_list if your query uses schema qualified table
> names. That should have been noted in the docs. Sorry.
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
> 
>> Tatsuo, after install pgpool-II am noticed that the query cache is not working. I am executing this query and it is never cached.
>>
>> /* criteria query */ select this_.pk_naturaleza_solicitud as pk1_84_0_, this_.naturaleza_solicitud as naturaleza2_84_0_ from public.tbl_nnaturaleza_solicitud this_
>>
>> Attached are the pgpool.log and pgpool.conf file.
>>
>> Regards.
>>
>>
>> ________________________________________
>> From: Tatsuo Ishii [ishii at postgresql.org]
>> Sent: Saturday, July 21, 2012 7:07 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
>>
>> Yes, I have committed the patch to the git already. So if you are
>> going to grab from the git repository, you just download the latest
>> snapshot.
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese: http://www.sraoss.co.jp
>>
>>> 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
>>
>> 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
> 
> 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