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

Tue Jul 24 19:30:23 JST 2012

Hi,

> 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.

It was a bug, and I've fixed it now. Could you try this?
http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=5c94b50c427826e6443a412968750c2005e7dd70

Pgpool couldn't recognize that a query with a /* ... */ comment at its
head was a SELECT statement.

> Thank you very much for your time.
> Regards.
> 
> ________________________________________
> From: Tatsuo Ishii [ishii �� postgresql.org]
> Sent: Sunday, July 22, 2012 12:55 AM
> To: Lazáro Rubén García Martínez
> Cc: pgpool-general �� 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 �� postgresql.org]
> > Sent: Saturday, July 21, 2012 7:07 PM
> > To: Lazáro Rubén García Martínez
> > Cc: pgpool-general �� 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 �� postgresql.org]
> >> Sent: Saturday, July 21, 2012 6:00 PM
> >> To: Lazáro Rubén García Martínez
> >> Cc: pgpool-general �� 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 �� postgresql.org]
> >>> Sent: Saturday, July 21, 2012 7:34 AM
> >>> To: Lazáro Rubén García Martínez
> >>> Cc: pgpool-general �� 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

-- 
Nozomi Anzai
SRA OSS, Inc. Japan