Hi,
I am not able to use pgadmin3 to connect to a DB. It complains about
ERROR: org.continuent.sequoia.controller.requests.StoredProcedure
As I found out the statement that is executed reads as follows:
SELECT oid, pg_encoding_to_char(encoding) AS encoding, datlastsysoid
FROM pg_database WHERE datname='vDBxyz';
This statement does not return a row as on the PG-DB there is no
database named vDBxyz.
Is there a way around this? When I make a db with this name in PG then
it has an oid-value that is not the right one. Does this leads to
problems?
>From the LOGS:
Myosotis
========
[10:50:35] ERROR
[org.continuent.myosotis.protocol.postgresql.PostgreSQLProtocolHandler] -
Error processing query: SET DateSt
yle=ISO;SELECT oid, pg_encoding_to_char(encoding) AS encoding,
datlastsysoid
FROM pg_database WHERE datname='vDBxyz'
org.continuent.sequoia.common.exceptions.driver.DriverSQLException:
Message of cause: Failed to execute request SET DateStyle
=ISO;SELECT oid, pg_encodin... because of
(org.continuent.sequoia.controller.requests.StoredProcedure)
at
org.continuent.sequoia.driver.Connection.statementExecute(Connection.java:3004)
[...]
Caused by:
org.continuent.sequoia.common.exceptions.driver.protocol.BackendDriverException:
Failed to execute request SET Dat
eStyle=ISO;SELECT oid, pg_encodin... because of
(org.continuent.sequoia.controller.requests.StoredProcedure)
Caused by:
org.continuent.sequoia.common.exceptions.driver.protocol.SerializableException:
org.continuent.sequoia.controller.
requests.StoredProcedure
SerializableStackTrace of each cause:
org.continuent.sequoia.common.exceptions.driver.protocol.BackendDriverException:
Failed to execute request SET DateStyle=ISO;SELECT oid, pg_encodin...
because of
(org.continuent.sequoia.controller.requests.StoredProcedure)
at
org.continuent.sequoia.controller.requestmanager.RequestManager.loadBalanceStatementExecute(RequestManager.java:10
[...]
Caused-by
org.continuent.sequoia.common.exceptions.driver.protocol.SerializableException:
org.continuent.sequoia.controller.requests.StoredProcedure
at
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.callStoredProcedure(RAIDb1.java:852)
Sequoia
========
10:50:29,222 WARN controller.RequestManager.vDBxyz Failed to execute
request SET DateStyle=ISO;SELECT oid, pg_encodin... because of
(org.continuent.sequoia.controller.requests.StoredProcedure)
java.lang.ClassCastException:
org.continuent.sequoia.controller.requests.StoredProcedure
at
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.callStoredProcedure(RAIDb1.java:852)
[...]
10:50:29,224 WARN controller.virtualdatabase.vDBxyz Stored procedure
26 failed (Failed to execute request SET DateStyle=ISO;SELECT oid,
pg_encodin... because of
(org.continuent.sequoia.controller.requests.StoredProcedure))
10:50:29,225 DEBUG controller.monitoring.vDBxyz ERROR SET
DateStyle=ISO;SELECT oid, pg_encoding_to_char(encoding) AS encoding,
datlastsysoid
FROM pg_database WHERE datname='vDBxyz'
10:50:29,225 WARN virtualdatabase.VirtualDatabaseWorkerThread.vDBxyz
Error during command execution (Failed to execute request SET
DateStyle=ISO;SELECT oid, pg_encodin... because of
(org.continuent.sequoia.controller.requests.StoredProcedure))
Regards
Joachim von Thadden
--
Joachim von Thadden
Manager Projekte
Linux Information Systems AG
Ehrenbergstr. 19, 10245 Berlin
Fon: +49 30 726238-19, Fax: +49 30 726238-99
[EMAIL PROTECTED], http://www.linux-ag.com
_______________________________________________________________
Sitz der Gesellschaft: Stefan-George-Ring 8, 81929 München
Amtsgericht München: HRB 128 019
Vorstand: Rudolf Strobl, Sebastian Hetze
Aufsichtsrat: Michael Tarabochia (Vorsitzender)
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
