org.openanzo.common.exceptions.AnzoException: ErrorCode[256:262181]

[teddius]

Hi OpenAnzo Group,

What does this exception mean? Is there a Database error or a
configuration error?

I am using the standalone server of openanzo nightly-build 20080727
with a postgresql database. This exception shows up arbitrarily.

org.openanzo.common.exceptions.AnzoException: ErrorCode[256:262181]
CorrelationId[db50e05d-2e6a-476a-a507-50a45f3fc53b] [RDB_ERROR] Failed
to execute an sql operation:[decrementUncommittedReferences] SQL:
[UPDATE {1} SET {1}.REF={1}.REF-1 WHERE {1}.REF>1 AND ID IN (SELECT
{0}.ID FROM {0})] Params:[] Templates:
[lockedIdsTable=USED_IDS_TMP,nodeTableName=ANZO_U]
at
org.openanzo.servicecontainer.backends.JMSConnectionBackend.requestResponse(JMSConnectionBackend.java:
760)
at
org.openanzo.servicecontainer.services.proxy.jms.JMSUpdateServiceProxy.update(JMSUpdateServiceProxy.java:
155)
at
org.openanzo.servicecontainer.services.proxy.jms.JMSUpdateServiceProxy.update(JMSUpdateServiceProxy.java:
126)
at org.openanzo.client.Replicator.update(Replicator.java:140)
at org.openanzo.client.AnzoClient.updateRepository(AnzoClient.java:
635)


Thanks for your help,
Andreas

[Matthew Roy]

It looks like a database error. Is there any more exception trace in
the log? Also, what sort of load/number of clients/threads are accessing
the server when you see the exceptions?

Thanks.
Matt

[Andreas S. Rath]

Hi Matt,

There was only one client connecting to the server and I am sorry that
I cannot provide more log information.

An other issue with the client to server communication I experienced
is that if I do a complete "graph.clear()" on a replicaGraph it takes
a long time and the "postgresql" database needs a lot of cpu
performance (99%) on a 2 Ghz 2GB RAM machine. There is only one client
connecting, one graph with about 150-200 MB of statements to be
cleaned. Is it normal that it is that slow?

Thanks for your help!

Sincerely,
Andreas

--
Dipl.-Ing. Andreas S. Rath
Email: arath (at) gmx (dot) at http://www.htu.tugraz.at/teddius
Student of Software Dev. & Knowledge Manag. @ Graz Univ. of Technology

[Matthew Roy]

Hi Andreas,
The problem is that the Anzo graph.clear() call doesn't check if it
within a transaction, so the system is creating separate transactions
for each statement being removed. We'll look into fixing this, but you
can solve it now by calling the clear() method within a transaction.

Matt