Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: error-handling

Is “deadlock detected” really an error? Should I be suppressing them after handling them?

By adminPosted on January 28, 2023

Question : A while ago, I spent a nightmarish number of weeks dealing with “deadlock detected” and trying to figure […]

Can I let PostgreSQL report the offending rows when a multi-row INSERT fails?

By adminPosted on December 14, 2022

Question : When inserting multiple rows into a table by a single INSERT INTO invocation, and the INSERT statement fails […]

Long time, sporadic ‘String or Binary data would be truncated.’ Wisdom would be appreciated

By adminPosted on December 2, 2022

Question : TL;DR How can I diagnose the source of a very inconsistent, un-reproducable ‘String or Binary data would be […]

Does the “don’t use errors for flow control” axiom apply to postgres?

By adminPosted on October 8, 2022

Question : In traditional programming there is an axiom that states, “do not use errors for flow control”. A general […]

How can I handle unwanted, non-erroneous situations better?

By adminPosted on September 26, 2022

Question : When writing procedures, I occasionally encounter situations in which I want to abort the procedure, even if the […]

Need to Check if a Table Exists Before Deleting a Record

By adminPosted on September 17, 2022

Question : I have the following SQL query in my Ruby app: sql = “DELETE FROM `#{database}`.`table1` WHERE `same_id` = […]

BULK INSERT continue on PRIMARY KEY error

By adminPosted on September 2, 2022

Question : I get a CSV file with a several million records every few days. I need to insert them […]

Is there a way to query all error messages in Postgres?

By adminPosted on August 5, 2022

Question : Postgres has a catalogue of possible error messages here: http://www.postgresql.org/docs/8.2/static/errcodes-appendix.html#ERRCODES-TABLE However, I would like to query this information […]

Impossible to log errors after dooming a transaction within an INSERT-EXEC statement

By adminPosted on July 24, 2022

Question : We have a stored procedure that does some work within a transaction, wrapped within a stored procedure that […]

Pros and Cons of Checking if value exist for unique column or let db raise unique error on inserting

By adminPosted on July 20, 2022

Question : While writing a query other day a thought came to me and have stuck in my mind. What […]

  • 1
  • 2
  • 3
  • …
  • 8

Recent Posts

  • Postgres to Postgres DBLink with AWS/RDS
  • What are the pros and cons of having more data-bearing members in a MongoDB replica set? [closed]
  • Transaction log backup after full backup is too big
  • Strange behavior with Quotename and substring [closed]
  • MySQL slow select from a view
  • CREATE INDEX vs ALTER TABLE ADD INDEX – MySQLism, or SQL Standard?
  • How to run my query on a one-to-many relation to run efficiently
  • Can I get SSMS to show me the Actual query costs in the Execution plan pane?
  • What are the best Database Analytics Companies for analyzing several 1000s or Mio. of products,sum them together and analyze them for statistics?
  • How to list the permissions on User-Defined Table Types?
  • Do I need an auto-generated ID in addition to a unique field?
  • Why should foreign keys be implemented in my relational database? [duplicate]
  • Difference between changed compatibility level database and new database
  • Does a query with a primary key and foreign keys run faster than a query with just primary keys?
  • What is the limit on the number of INSERT statements you can paste into SSMS and run?
  • String or separate Table
  • Database layout to keep track of the “freshness” of a column value in a specific row
  • MySQL Computed Column counting other rows with attributes relative to this one
  • How to design tables for airbnb style booking system [closed]
  • mysql restart won’t kill child processes on CentOS

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding