Here I am again,
I have made all my interactions with the server to be auto-committed.
Still I get a "current transaction abort (please rollback)" error
message without understanding the reason. I have looked into the jdbc
logs very carefully, I have also serialized all 6 connections, but
nothing seem to be wrong. The interaction with the server is attached
in sql.log (contains only the sql commands as if there was a single
connection executing them). The serialized logs are attached in
serial.log (there are comments about the time a connection
starts/continues/ends or giving execution to another connection, and
all timestamps generated from jdbc have been replaced by 1, 2, 3, and
so on for readability purposes. All lines starting with % or [ have
been omitted; the complete logs for each connection are also attached
in monet_*.log files.
All files are attached in a .zip archive.
If you can see something that I can't please report it.
Thanks a lot,
Babis
On Sat, Apr 9, 2011 at 9:59 PM, Fabian Groffen
On 09-04-2011 17:54:10 +0300, Charalampos Nikolaou wrote:
I have gained a great experience by looking into the jdbc logs, but unfortunately I haven't come to a conclusion yet. I need information about the state of the mserver5 as well. For example, by looking only the jdbc logs it is not clear when a transaction is commited.
When a "statement" or "batch" is executed.
Concerning the different monet_*.log files created by jdbc, should I suppose that belong to a different jdbc thread, different transaction, or something else?
A different connection to the server.
And one last question: what are the debug options for mserver5? I found this link (http://monetdb.cwi.nl/MonetDB4-compiled/etc/MonetDB.conf) which states a bunch of gdk_debug options some of them still valid in monetdb5, but the one that I am interested in does not produce any output (transaction management). Is there any alternative value/property for transaction management? I am also aware of the sql_debug (valid values 0/1). Other?
There are no debug options in the server that would give you any insight you're looking for on transaction validity.
------------------------------------------------------------------------------ Xperia(TM) PLAY It's a major breakthrough. An authentic gaming smartphone on the nation's most reliable network. And it wants your games. http://p.sf.net/sfu/verizon-sfdev _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users