Can a COMMIT statement (in SQL) ever fail? How?

by

COMMIT may fail. You might have had sufficent resources to log all the changes you wished to make, but lack resources to actually implement the changes.

And that’s not considering other reasons it might fail:

  1. The change itself might not fit the constraints of the database.

  2. Power loss stops things from completing.

  3. The level of requested selection concurrency might disallow an update (cursors updating a modified table, for example).

  4. The commit might time out or be on a connection which times out due to starvation issues.

  5. The network connection between the client and the database may be lost.

And all the other “simple” reasons that aren’t on the top of my head.

More Related Contents:

  1. SQL Server – transactions roll back on error?
  2. Is it possible to roll back CREATE TABLE and ALTER TABLE statements in major SQL databases?
  3. What happens to an uncommitted transaction when the connection is closed?
  4. Correct use of transactions in SQL Server
  5. MySQL: Transactions vs Locking Tables
  6. What does a transaction around a single statement do?
  7. Do database transactions prevent race conditions?
  8. Is it possible to run multiple DDL statements inside a transaction (within SQL Server)?
  9. Continuing a transaction after primary key violation error
  10. Does Postgres support nested or autonomous transactions?
  11. ‘Lost update’ vs ‘Write skew’
  12. Should I commit or rollback a read transaction?
  13. Only inserting a row if it’s not already there
  14. PostgreSQL DISTINCT ON with different ORDER BY
  15. Can I protect against SQL injection by escaping single-quote and surrounding user input with single-quotes?
  16. Are database triggers evil? [closed]
  17. Most efficient way in SQL Server to get date from date+time?
  18. Using Excel VBA to export data to MS Access table
  19. subquery in FROM must have an alias
  20. How to search multiple columns in MySQL?
  21. Selecting the second row of a table using rownum
  22. Does Oracle store trailing zeroes for Number data type?
  23. SQL: getting the max value of one column and the corresponding other columns [duplicate]
  24. Does an empty SQL table have a superkey? Does every SQL table have one?
  25. Postgres window function and group by exception
  26. How to delete in MS Access when using JOIN’s?
  27. SQLite3 UNIQUE constraint failed error
  28. How to count in SQL all fields with null values in one record?
  29. Repeat Rows N Times According to Column Value
  30. SQL Server 2005 – Export table programmatically (run a .sql file to rebuild it)

Leave a Comment