[pgpool-general: 5576] Re: Problem after upgrade of postgresql from 9.3 to 9.6

[Armin Nesiren]

Hello,

I was using old version of pgpool (3.4.x) instead of new one.
With new one it works just normal.

Thanks a lot, and sorry for false alarm.


On Mon, Jun 12, 2017 at 2:12 PM, Tatsuo Ishii <ishii at sraoss.co.jp> wrote:

> > With postgresql version 9.6.3 ?
>
> 10.0 beta1.
>
> > Is database dump that creates trouble ok for you?
>
> Probably I don't need data. i.e. schema only dump is enough.
> Also I need pgpool.conf.
>
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
>
> > On Mon, Jun 12, 2017 at 11:38 AM, Tatsuo Ishii <ishii at sraoss.co.jp>
> wrote:
> >
> >> > Hello,
> >> >
> >> > I'm using pgpool for load balancing and failover, now version 3.6.4
> >> >
> >> > I'm experiencing problem after upgrade of postgresql from 9.3 to 9.6.
> >> > I have some not ordinary table names in my database. And that worked
> well
> >> > for many years and now it would be really hard to change everything.
> >> >
> >> > Problem is when I make simple select request:
> >> > postgres=# SELECT * FROM "class_
> >> > http://www.w3.org/1999/02/22-rdf-syntax-ns#Property";
> >> >
> >> > I got error, and pgpool close connection unexpectedly.
> >> >
> >> > postgres=# SELECT * FROM "class_
> >> > http://www.w3.org/1999/02/22-rdf-syntax-ns#Property";
> >> > FATAL:  Backend throw an error message
> >> > DETAIL:  Exiting current session because of an error from backend
> >> > HINT:  BACKEND Error: "cross-database references are not implemented:
> >> > "class_http://www.w3.org/1999/02/22-rdf-syntax-ns#property""
> >> > server closed the connection unexpectedly
> >> >         This probably means the server terminated abnormally
> >> >         before or while processing the request.
> >> > The connection to the server was lost. Attempting reset: Succeeded.
> >> > postgres=#
> >> >
> >> >
> >> > When I execute same query directly on postgresql (not throught
> pgpool),
> >> it
> >> > works normally.
> >> >
> >> > Thansk a lot
> >> > --
> >> > Armin
> >>
> >> Please provide a self contained test case. I was not able to reproduce
> >> your problem here.
> >>
> >> test=# SELECT * FROM "class_
> >> http://www.w3.org/1999/02/22-rdf-syntax-ns#Property";
> >> test"# ERROR:  relation "class_
> >> http://www.w3.org/1999/02/22-rdf-syntax-ns#Property" does not exist
> >> LINE 1: SELECT * FROM "class_
> >>                       ^
> >> test=# CREATE TABLE "class_
> >> http://www.w3.org/1999/02/22-rdf-syntax-ns#Property" (i int);
> >> test"# CREATE TABLE
> >> test=# SELECT * FROM "class_
> >> http://www.w3.org/1999/02/22-rdf-syntax-ns#Property";
> >> test"#  i
> >> ---
> >> (0 rows)
> >>
> >> test=# \dt
> >>                                List of relations
> >>  Schema |                        Name                         | Type  |
> >> Owner
> >> --------+---------------------------------------------------
> >> --+-------+---------
> >>  public | class_                                             +| table |
> >> t-ishii
> >>         | http://www.w3.org/1999/02/22-rdf-syntax-ns#Property |       |
> >>  public | pgbench_accounts                                    | table |
> >> t-ishii
> >>  public | pgbench_branches                                    | table |
> >> t-ishii
> >>  public | pgbench_history                                     | table |
> >> t-ishii
> >>  public | pgbench_tellers                                     | table |
> >> t-ishii
> >>  public | test_tbl                                            | table |
> >> t-ishii
> >> (6 rows)
> >>
> >> Best regards,
> >> --
> >> Tatsuo Ishii
> >> SRA OSS, Inc. Japan
> >> English: http://www.sraoss.co.jp/index_en.php
> >> Japanese:http://www.sraoss.co.jp
> >>
> >
> >
> >
> > --
> > Armin
>



-- 
Armin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20170612/a4d82cd0/attachment.html>