Questions tagged [transaction]

Question 1

Example code below populates a PhoneNumber table and associates those PhoneNumberId's with an OrderNumber. As written I am getting the error message: The current transaction cannot be committed and ...

Question 2

I used SSMS to add a composite primary key to a table with 64 million rows. Because the table was so large, I used the change script generated by SSMS. One of the PK fields (REVENUE_CODE) originally ...

Question 3

Repro steps: Create the table: create table t (col TEXT primary key); Open two database consoles and use the following queries in them: 1 begin; 2 select txid_current(); 3 insert into t (col) ...

Question 4

I have a reporting database that is kept in sync with the transactional database using transaction log files. The seed file is provided every 3 months and we get 15 min log files. This database needs ...

Question 5

I saw some log entries that indicated transaction time outliers of up to 10s at times, where transaction times are typically below 1s. To get a view of how often this happens, is there a way to get ...

Question 6

I am currently working with SQL Server and exploring transaction management, specifically the dm_tran_commit_table view. I have a couple of questions regarding the commit_time and change tracking. ...

Question 7

I am wondering whether any really bad things can result from terminating (pg_terminate_backend()). Or would this at worst result into current transactions not being roled back. or is current ...

Question 8

Suppose that: I already have Snapshot isolation enabled I do not have Read Committed Snapshot Isolation enabled I have been strict with my READCOMMITTEDLOCK hints wherever I truly need them then is ...

Question 9

Is there any way to log or find last executed statement from a session that terminated because of idle in transaction timeout? We only have slow statement logging and that did not capture it and we ...

Question 10

If I have done functional partitioning in my database and have for example a database Transactions and a database Products and these are different database servers and there are references from tables ...

Question 11

Does Postgres abort current transactions on error? In any case, can you provide a reference? Googling "site:postgres.org transaction abort rollback error" produced no results, and GPT ...

Question 12

I have a SQL Server process that runs annually, creating around 400 million records in several tables. The process operates in a loop, committing every 20,000 records for each of the tables. I ...

Question 13

If I do an UPDATE to a row within a transaction, each time xmin increments. I thought that xmin always represents the current tx id. But it seems to be storing current xid + cmin instead. But when ...

Question 14

When I run this query SELECT transaction_id, name, transaction_begin_time, transaction_state FROM sys.dm_tran_active_transactions I always have these 6 rows in the result set transaction_id name ...

Question 15

I know this is probably a silly question, It is my first, It seems so fundamental that I can't find the answer anywhere, because it must be so straight forward no one explained it. I want to ...

Stack Exchange Network

Questions tagged [transaction]

Temp Table Management in Explicit Transactions and CATCH blocks

Why didn't the transaction fail?

Saw some strange behavior when using `INSERT ON CONFLICT` inside a transaction

Advice on transaction log based Reporting Server

Is there a way to get transaction time statistics on specific tables

Understanding commit_time in dm_tran_commit_table: Insert Time, Timezone, and Latency Concerns

postgres - ok to terminate active connections?

Why not use Snapshot isolation for everything read-only?

PostgreSQL: Finding last executed statement from an "idle in transaction timeout"

Does MySQL perform 2PC automatically for internal (mysql only) transactions?

Does Postgres abort transaction on error (need reference)?

Stop rolling back transaction by committing them

Postgres updates xmin on every UPDATE within a transaction

Are these transactions normal?

How can a transaction view uncommitted changes made by another transaction in UNCOMMITTED READ

Hot Network Questions