You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
mvc_commit: send SQLSTATE 40000 for transaction aborts
Because I don't know any specifics, send generic "transaction rollback"
SQLSTATE on commit failures for bug #3052.
Date: 2012-03-07 12:02:46 +0100
From: Simon Brodt <<simon.brodt>>
To: clients devs <>
Version: -- development
Last updated: 2012-03-16 14:56:55 +0100
Comment 17053
Date: 2012-03-07 12:02:46 +0100
From: Simon Brodt <<simon.brodt>>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:10.0.2) Gecko/20100101 Firefox/10.0.2
Build Identifier: MonetDB 5 server v11.7.7 "Dec2011-SP1" Compiled for x86_64-pc-winnt/64bit with 64bit OIDs dynamically linked -- JDBC Driver 2.1
SQLException on rollback returns SQLSTATE "22000" insted of "40000".
Reproducible: Always
Steps to Reproduce:
Try reading and writing to a table at the same time with a sufficently high frequency (not very high).
Actual Results:
SQLSTATE "22000"
Expected Results:
SQLSTATE "40000"
Probably the relevant section of the monetdb jdbc log:
RD 1331116498816: inserting prompt
TD 1331116498816: write final block: 60 bytes
TX 1331116498816: sSELECT get_value_for('hello_d_world_meta','tuple_id_seq');;
RD 1331116498817: read final block: 101 bytes
RX 1331116498817: &1 0 1 1 1
% . table_name
% get_value_for_single_value name
% bigint type
% 3 length
[ 816 ]
RD 1331116498817: inserting prompt
TD 1331116498817: write final block: 289 bytes
TX 1331116498817: sUPDATE "hello_d_world_meta"."queries"
SET "last_round" = '43',
"output_min_time_value_1" = '786',
"output_min_time_value_2" = '784',
"output_min_time_value_3" = '1331116498673',
"input_min_time_value_1" = '815',
"input_min_time_value_2" = '1331116498786'
WHERE "id" = '4'
;;
RD 1331116498861: read final block: 95 bytes
RX 1331116498861: &2 1 -1
!COMMIT: transaction is aborted because of concurency conflicts, will ROLLBACK instead
RD 1331116498861: inserting prompt
TD 1331116499657: write final block: 83 bytes
TX 1331116499657: sUPDATE
"meta"."program_insts"
SET "state" = 'LOCKED'
WHERE
"id" = '4'
;;
RD 1331116499661: read final block: 8 bytes
RX 1331116499661: &2 1 -1
Comment 17054
Date: 2012-03-07 12:30:25 +0100
From: @grobian
Indeed. Server doesn't provide an error code, so the driver falls back to some default one.
Comment 17055
Date: 2012-03-07 13:34:52 +0100
From: @grobian
Changeset cba537e56f14 made by Fabian Groffen fabian@cwi.nl in the MonetDB repo, refers to this bug.
For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=cba537e56f14
Changeset description:
Comment 17102
Date: 2012-03-16 14:56:55 +0100
From: @grobian
Released in Dec2011-SP2
The text was updated successfully, but these errors were encountered: