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

Mon Jul 23 12:17:35 JST 2012

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.conf
Type: application/octet-stream
Size: 25415 bytes
Desc: pgpool.conf
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20120722/7f2cd768/attachment-0002.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.log
Type: application/octet-stream
Size: 21526 bytes
Desc: pgpool.log
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20120722/7f2cd768/attachment-0003.obj>