Thread: FATAL error "could not find function "alt_to_mic" in file cyrillic_and_mic.so

"Jayaraman, Rajaram (STSD)" <rajaram.j@hp.com> writes:
> I have compiled PostgreSQL version 8.4.1 on HPUX 11iV3 (HPUX 11.31) on a ia64 hp server BL870c. When I try to start
thedatabase it creates the data directory and while initializing it gets till creating conversions and then throws a
FATALerror "could not find function "alt_to_mic" in file "/opt/psb/db/pgsql/lib/cyrillic_and_mic.so" ". 

Well, the error is perfectly legitimate, because there is no such function
in that file, nor anywhere else in Postgres 8.4.  It did exist back in
8.0 or so, which makes me think initdb is reading some ancient copy of
conversion_create.sql.  You need to straighten out the apparent mixup
of files from different releases.

            regards, tom lane

Thanks Tom,

I replaced the file conversion_create.sql and the db got created.

In the mean while I got into a different problem, I guess this is also a settings related problem.

When I try to connect to the DB and perform insert/update/delete/select operations from the command line all seems to
beworking fine, but when I try to use my application to connect to the DB I get the following message in the log file
andthe connection aborts. 

LOG:  getsockname() failed: Invalid argument
LOG:  incomplete startup packet

Can you please help me fix the problem.

Thanks once again for your help.

Regards

Rajaram J
We all make mistakes, but it's our responses to said mistakes that separate true leaders from the rest of the pack.

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Thursday, October 22, 2009 8:13 PM
To: Jayaraman, Rajaram (STSD)
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] FATAL error "could not find function "alt_to_mic" in file cyrillic_and_mic.so

"Jayaraman, Rajaram (STSD)" <rajaram.j@hp.com> writes:
> I have compiled PostgreSQL version 8.4.1 on HPUX 11iV3 (HPUX 11.31) on a ia64 hp server BL870c. When I try to start
thedatabase it creates the data directory and while initializing it gets till creating conversions and then throws a
FATALerror "could not find function "alt_to_mic" in file "/opt/psb/db/pgsql/lib/cyrillic_and_mic.so" ". 

Well, the error is perfectly legitimate, because there is no such function
in that file, nor anywhere else in Postgres 8.4.  It did exist back in
8.0 or so, which makes me think initdb is reading some ancient copy of
conversion_create.sql.  You need to straighten out the apparent mixup
of files from different releases.

            regards, tom lane

Hi Just

Wanted to add we are using PQconnectdb to connect to the database.

The contents in pg_hba.conf, just in case it helps.

# TYPE  DATABASE    USER        IP-ADDRESS        IP-MASK           METHOD

local   all         all                                            md5
# IPv4-style local connections:
host    all         all         127.0.0.1         255.255.255.255  md5
# IPv6-style local connections:
host    all         all         ::1               ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff       md5

Regards

Rajaram J
We all make mistakes, but it's our responses to said mistakes that separate true leaders from the rest of the pack.


-----Original Message-----
From: Jayaraman, Rajaram (STSD)
Sent: Friday, October 23, 2009 4:10 PM
To: 'Tom Lane'
Cc: pgsql-general@postgresql.org
Subject: RE: [GENERAL] FATAL error "could not find function "alt_to_mic" in file cyrillic_and_mic.so

Thanks Tom,

I replaced the file conversion_create.sql and the db got created.

In the mean while I got into a different problem, I guess this is also a settings related problem.

When I try to connect to the DB and perform insert/update/delete/select operations from the command line all seems to
beworking fine, but when I try to use my application to connect to the DB I get the following message in the log file
andthe connection aborts. 

LOG:  getsockname() failed: Invalid argument
LOG:  incomplete startup packet

Can you please help me fix the problem.

Thanks once again for your help.

Regards

Rajaram J
We all make mistakes, but it's our responses to said mistakes that separate true leaders from the rest of the pack.

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Thursday, October 22, 2009 8:13 PM
To: Jayaraman, Rajaram (STSD)
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] FATAL error "could not find function "alt_to_mic" in file cyrillic_and_mic.so

"Jayaraman, Rajaram (STSD)" <rajaram.j@hp.com> writes:
> I have compiled PostgreSQL version 8.4.1 on HPUX 11iV3 (HPUX 11.31) on a ia64 hp server BL870c. When I try to start
thedatabase it creates the data directory and while initializing it gets till creating conversions and then throws a
FATALerror "could not find function "alt_to_mic" in file "/opt/psb/db/pgsql/lib/cyrillic_and_mic.so" ". 

Well, the error is perfectly legitimate, because there is no such function
in that file, nor anywhere else in Postgres 8.4.  It did exist back in
8.0 or so, which makes me think initdb is reading some ancient copy of
conversion_create.sql.  You need to straighten out the apparent mixup
of files from different releases.

            regards, tom lane