Thread

1. ERROR: datumGetSize: Invalid typLen 0

   Thomas T. Thai <tom@minnesota.com> — 2003-03-21T02:44:49Z

   NetBSD 1.6 / Alpha 64-bit
   PostgreSQL 7.3.2
   PHP-4.3.2
   
   I did a vacuum analyze on a live database. Then after queries to a db from
   the web page returned 0 results when it should have lots of results. Then
   the console showed the postgresql error:
   
     ERROR:  datumGetSize: Invalid typLen 0
   
   There have been a similar bug reported:
   
     http://archives.postgresql.org/pgsql-bugs/2002-12/msg00216.php
   
   The odd thing is that ps showed this stale postmaster running which is the
   only one accessing the db:
   
   pgsql   18458 11935 11926 7e13c0    0 SWN  p1    0:00.00 postmaster: pgsql
   yellowpages [local] idle (postgres)
   
   That was the DB that was vacuum analyze.
   
   If I query the same query from psql session, I get results. Apparently,
   PHP is trying to access postgresql using that stale process above and
   isn't able to connect to the DB.
   
   I restarted PostgreSQL but still had the same problems.
   
   --
   Thomas T. Thai
   
   
   
   
   

2. Re: TSearch Related? - ERROR: datumGetSize: Invalid typLen

   Thomas T. Thai <tom@minnesota.com> — 2003-03-21T02:54:28Z

   On Thu, 20 Mar 2003, Thomas T. Thai wrote:
   
   > NetBSD 1.6 / Alpha 64-bit
   > PostgreSQL 7.3.2
   > PHP-4.3.2
   >
   > I did a vacuum analyze on a live database. Then after queries to a db from
   > the web page returned 0 results when it should have lots of results. Then
   > the console showed the postgresql error:
   >
   >   ERROR:  datumGetSize: Invalid typLen 0
   >
   > There have been a similar bug reported:
   >
   >   http://archives.postgresql.org/pgsql-bugs/2002-12/msg00216.php
   >
   > The odd thing is that ps showed this stale postmaster running which is the
   > only one accessing the db:
   >
   > pgsql   18458 11935 11926 7e13c0    0 SWN  p1    0:00.00 postmaster: pgsql
   > yellowpages [local] idle (postgres)
   >
   > That was the DB that was vacuum analyze.
   >
   > If I query the same query from psql session, I get results. Apparently,
   > PHP is trying to access postgresql using that stale process above and
   > isn't able to connect to the DB.
   >
   > I restarted PostgreSQL but still had the same problems.
   
   Once I restarted postgresql, I no longer am able to perform the same query
   that succeeded before in pgsql but failed in the web page via PHP.
   
   The only thing that was different was I updated to the newer version of
   tsearch v2 that allowed empty strings in txtidx fields.
   
   yellowpages=# SELECT COUNT(*) AS count FROM phone_address AS p WHERE
   p.name_fts @@ txt2query('acme')
   yellowpages-# ;
   ERROR:  datumGetSize: Invalid typLen 0
   ERROR:  datumGetSize: Invalid typLen 0
   yellowpages=# ERROR:  datumGetSize: Invalid typLen 0
   
   --
   Thomas T. Thai