Questions tagged [serialization]
The serialization tag has no usage guidance.
7
questions with no upvoted or accepted answers
4
votes
1answer
311 views
What is the meaning of Order preserving Conflict Serializable schedules?
I was going through the concept of order preservation in Conflict Serializable class and I came across Order preserving conflict serializable (OCSR in short). The following is the definition of OCSR ...
1
vote
1answer
27 views
SELECT FOR UPDATE (NOWAIT) on auxilliary table for serializing updates?
Background:
I have an inventory tracking application which needs to avoid the following sort of situation where the same inventory might be used twice due to lack of serialization. The constraint is ...
1
vote
0answers
60 views
View serializable schedule
Any view serializable schedule that is not conflict serializable must contain a blind write.
(Source: Wikipedia)
Why is this statement true? I referred some links like this but am still not able to ...
1
vote
0answers
16 views
Do start and end points change conflict serialisability?
If we have two transactions, and the following schedule:
S1 R1(X) S2 R2(X) R2(Y) E1 W2(X) W2(Y) E2
where Si and Ei indicate the start and end of the ith transaction respectively. Does this change ...
1
vote
0answers
168 views
Turn off serialization failure logging
Is it possible to turn off serialization failure logging? If so, how?
For example, my log is filled with this example:
ERROR: could not serialize access due to read/write dependencies among ...
0
votes
0answers
23 views
How to store very very big Array in MySQL (separator / json_encode / serialize)?
I have project with saving timestamps from SCADA system to localhost MySQL-DB. All works fine but thinking about storing datas (read many threads and array storing isnt most efficiency method). Every ...
0
votes
0answers
282 views
PostgreSQL Race condition and Serializable
Hello I try to debug a tricky race condition in my app (golang, pq, sqlx, postgresql Debian 10.6-1.pgdg90+1).
I have a table
CREATE TABLE j (
id BIGSERIAL PRIMARY KEY NOT NULL,
...
