From: Adrian Klaver <adrian.klaver@aklaver.com>
To: Michael Nolan <htfoot@gmail.com>
To: pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: field error on refreshed materialized view
Date: Thu, 25 Jan 2024 13:32:11 -0800
Message-ID: <7b40b352-b8bb-439f-8b29-a93d5efe51bf@aklaver.com> (raw)
In-Reply-To: <CAOzAqu+U6h201hE9PNe6jfBFc7G-LmWS973fUTsM+eRzwx3Fvg@mail.gmail.com>
References: <CAOzAqu+U6h201hE9PNe6jfBFc7G-LmWS973fUTsM+eRzwx3Fvg@mail.gmail.com>
On 1/25/24 1:29 PM, Michael Nolan wrote:
> I'm in the process of updating a server from postgresql 10.4 on Centos
> 7 to 16.1 on AlmaLInux 9, and am reminded of the old line about when
> you're up to your necks in alligators, it is difficult to remember
> that your goal was to drain the swamp.
>
> We have several materialized views that are refreshed from an external
> mysql/mariadb server.
Define "... refreshed from an external mysql/mariadb server"?
>
> On the 10.4 server this materialized view works, but on the 16.1
> server it fails:
>
> uscf=# refresh materialized view uscf_vip;
> refresh materialized view uscf_vip;
> ERROR: value too long for type character varying(255)
Is there more to the error, that shows the actual value?
Or have you looked in server log to see if there is more information?
>
> Both materialized view tables appear to be identical. (We did a
> restore from a recent database dump to populate the new server.)
>
> I don't see anything in the log files to help me determine which field
> or row is causing the error. As far as I can tell, encoding is the
> same on both versions, but there could be issues in how the mysql
> server is coding non-ASCII characters.
>
> Is this something that has to be tracked down on the mysql/mariadb
> server or is there anything I can do to help narrow down the problem
> on my 16.1 server?
> --
> Mike Nolan
> htfoot@gmail.com
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: adrian.klaver@aklaver.com, htfoot@gmail.com
Subject: Re: field error on refreshed materialized view
In-Reply-To: <7b40b352-b8bb-439f-8b29-a93d5efe51bf@aklaver.com>
References: <CAOzAqu+U6h201hE9PNe6jfBFc7G-LmWS973fUTsM+eRzwx3Fvg@mail.gmail.com> <7b40b352-b8bb-439f-8b29-a93d5efe51bf@aklaver.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox