Articles tagged with oracle

1. MySQL: Query caused different errors on master and slave

   Posted on August 14, 2010 in System Administration

   We ran across the following error on a MySQL slave server recent:

   mysql> SHOW SLAVE STATUS \G
   <snip>
   Last_Error: Query caused different errors on master and slave. Error on master: 'Deadlock found when trying to get lock; try restarting transaction' (1213), Error on slave: 'no error' (0). Default database: '<database_name …

2. Two Random Asterisk-Related SQL Queries

   Posted on July 15, 2010 in voice

   I hate losing useful SQL queries, so I tend to save them. Ever so often, I stumble across a file of queries from some work I was doing months ago. The following two queries are just such a case. I was analyzing some call data for a call center that …