Forum: help

RE: Error with dbi_link [ reply ]
By: Cristiano Duarte on 2009-09-11 14:12

Hi Alain,

Sorry for the late response, I'm currently on a business travel in the middle of the Amazon rain forest and answering this post through a private satellite connection.
You don't need to setup dbi-link in order to have pgsnapshot working.
I can't help you much with dbi-link, since i'm not following its changes anymore.
i think, due to the spi implementation, that dbi-link doesn't have persistent connections and so doesn't pgsnapshots.

Regards,

Cristiano

Error with dbi_link [ reply ]
By: Alain PERSONNAT on 2009-09-08 14:53

[forum:1005321]

Hello,

I 've installed the dbi-link-2.0.0 package with success and I also could performed a request on my Oracle database with the following query :

select * from test_dblink."SALES";

After bounced the both databases I wanted to re-test the dblink before begining the intall of the snapshot package and I had this message (sorry I didn't find the 'attach file' button) :

testdb=# select * from test1_dblink."SALES";
NOTICE: Setting bail in %_SHARED hash. at line 25.

CONTEXT: SQL statement "SELECT dbi_link.dbi_link_init()"
NOTICE: Setting quote_literal in %_SHARED hash. at line 25.

CONTEXT: SQL statement "SELECT dbi_link.dbi_link_init()"
NOTICE: Setting get_connection_info in %_SHARED hash. at line 25.

CONTEXT: SQL statement "SELECT dbi_link.dbi_link_init()"
NOTICE: Setting quote_ident in %_SHARED hash. at line 25.

CONTEXT: SQL statement "SELECT dbi_link.dbi_link_init()"
NOTICE: Setting get_dbh in %_SHARED hash. at line 25.

CONTEXT: SQL statement "SELECT dbi_link.dbi_link_init()"
NOTICE: Setting remote_exec_dbh in %_SHARED hash. at line 25.

CONTEXT: SQL statement "SELECT dbi_link.dbi_link_init()"
NOTICE: SELECT dbi_link.cache_connection( 1 ) at line 12.

NOTICE: In cache_connection, there's no shared dbh 1 at line 7.

CONTEXT: SQL statement "SELECT dbi_link.cache_connection( 1 )"
NOTICE: Entering get_connection_info at line 44.

CONTEXT: SQL statement "SELECT dbi_link.cache_connection( 1 )"
NOTICE: ref($args) is HASH
---
data_source_id: 1

CONTEXT: SQL statement "SELECT dbi_link.cache_connection( 1 )"
NOTICE: Leaving get_connection_info at line 75.

CONTEXT: SQL statement "SELECT dbi_link.cache_connection( 1 )"
NOTICE: ---
auth: SH
data_source: dbi:Oracle:host=localhost;sid=BT2P;port=1521
dbh_attributes: |
---
AutoCommit: 1
RaiseError: 1
local_schema: test1_dblink
remote_catalog: ~
remote_schema: ~
user_name: SH

CONTEXT: SQL statement "SELECT dbi_link.cache_connection( 1 )"
NOTICE: In get_dbh, input connection info is
---
auth: SH
data_source: dbi:Oracle:host=localhost;sid=BT2P;port=1521
dbh_attributes: |
---
AutoCommit: 1
RaiseError: 1
local_schema: test1_dblink
remote_catalog: ~
remote_schema: ~
user_name: SH

CONTEXT: SQL statement "SELECT dbi_link.cache_connection( 1 )"
ERROR: error from Perl function "remote_select": error from Perl function "cache_connection": DBI connect('host=localhost;sid=BT2P;port=1521','SH',...) failed: (UNKNOWN OCI STATUS 1804) OCIInitialize. Check Check ORACLE_HOME (Linux) env var or PATH (Windows) and or NLS settings, permissions, etc at line 137 at line 13.

After checking the PATH, the ORACLE_HOME, the LD_LIBRARY_PATH I tested an ODBC cnx with success.

So I re-installed the package and the test was OK.

This morning I have the same issue, does it mean that the dblink is not persistent ?

Thanks for your answer ;-)

Regards,
Alain