Re: Serializable transactions

From: Petr Vasil'ev <monstr_at_peterlink.ru>
Date: 2000/06/06
Message-ID: <8hjhbr$q9$1_at_dragon.infopro.spb.su>#1/1

Thomas DAVID <tdavid_at_icway.com> ïèøåò â ñîîáùåíèè:393B81FC.CEE5F2C6_at_icway.com...
> The transation are executed in seperate clients, and the first one uses
> the default oracle setting "read committed".
> transaction 1:
> SQL> select * from ref_table_1;
>
> ID TOTO TITI PARAM_CREA PARAM_STAR PARAM_ENDA
> ---------- ----- ---------- ---------- ---------- ----------
> 1 eheh 15 05/03/2000 01/01/2000 04/30/2000
> 2 eheh 15 05/03/2000 05/01/2000 09/30/2000
> 3 eheh 15 05/03/2000 10/01/2000
> transaction 2:
> SQL> set transaction isolation level serializable;
> Transaction set.
>
> transaction 2:
> SQL> delete from ref_table_1 where ID=3;
>
> 1 row deleted.
>
> SQL> commit;
>
> Commit complete.
>
> transaction 1:
> SQL> delete from ref_table_1 where ID=2;
> delete from ref_table_1 where ID=2
> *
> ERROR at line 1:
> ORA-08177: can't serialize access for this transaction
>
> Does someone has something to make all this clearer?
> Thoms

08175-08190: Discrete Transaction Messages ORA-08175: discrete transaction restriction violated name Cause: An attempt was made to perform an action that is not currently supported in a discrete transaction.

Action: Rollback the transaction and retry it as a normal transaction.

ORA-08176: cannot continue consistent read for the table/index - no undo records
Cause: Oracle encountered an operation that does not generate undo records. For example, the operation might have been an attempt to create an index by performing a direct load or executing a discrete mode transaction.

Action: Retry the operation with a different snapshot time. If using an index, retry the operation without using the index.

ORA-08177: cannot serialize access for this transaction Cause: Oracle encountered data changed by an operation that occurred after the start of this serializable transaction.

Action: In read/write transactions, retry the intended operation or transaction.

_________________________retry__________________________________

ORA-08178: illegal SERIALIZABLE clause specified for user INTERNAL Cause: An attempt was made to specify the SERIALIZABLE mode for user INTERNAL. Serializable mode is not supported for user INTERNAL.

Action: Reconnect as another user and retry the SET TRANSACTION command. Received on Tue Jun 06 2000 - 00:00:00 CEST