The tag has no usage guidance.

learn more… | top users | synonyms

1
vote
2answers
62 views

Get the Text of the currently running SQL?

This is something I am just interested in knowing if it is possible. Could I write an SQL query that could return the text of itself as a variable? Where I might use this would be on things like ...
0
votes
0answers
22 views

Can not install debuginfo for MySQL

I am trying to use perf and Flame Graphs to debug a MySQL CPU bottleneck. The problem is that I do not have the debug symbols. Trying to install them is failing: # rpm -q mysql-community-server ...
0
votes
0answers
76 views

database Deadlock again

Once again I have a deadlock problem with the following log: [17/03/16 16:42:20.020 -0300] FATAL OPERACIONES: SQLException: CreateEquipo: ERROR: deadlock detected Detail: Process 2923 waits for ...
1
vote
1answer
297 views

SQL Server: Failed to start debugger - Data is Null

I'm a developer working on a web application using an instance of SQL Server 2014. I use Visual Studio 2010 sp1 for development. For a task I'm currently working on, I'd like to use the SQL Server ...
1
vote
1answer
22 views

HSQL DB grows large and is full of zeroes

I have an application whose HSQL database grows awfully large for some users, but not others. When I received one example where this problem happenned, I discovered that the database is nearly empty - ...
2
votes
2answers
121 views

Where to look for possible deadlock causes?

We've been having several problems the past days in our production environment, and some of them seem to boil down to database issues. Just realized we are having deadlocks (68 actually), on database ...
5
votes
1answer
52 views

How to change default port for T-SQL Debugger

The default port for T-SQL Debugger is 135, it is possible to change this port ? In my company this port is on special list of banned ports, therefore we need to open that service on another port ...
2
votes
0answers
32 views

SQL Server - Debugging - How to show parametervalues as HEX

I am writing a script which sets Parameters in the Registry for SQL Server. The following works on some of my servers but not all. DECLARE @Parameters AS VARCHAR(MAX) SET @Parameters = '-T1118' ...
7
votes
1answer
262 views

Surprising results for data types with type modifier

While discussing a recursive CTE solution for this question: Get the last 5 distinct values for each ID @ypercube stumbled across a surprising exception, which lead us to investigate the handling ...
0
votes
0answers
244 views

SSIS detect & manipulate all user variables ( set all empty )

I am developing a rather large ETL ( 39 distinct Flat File or Excel Connection Managers in current build & about as many to go ) through SSIS ( Visual Studio and MSSQL Server versions both 2008-R2 ...
1
vote
2answers
84 views

Object Reference Not Set … Debugging Stored Procedure in Visual Studio

I'm working on updating a stored procedure that is called to update a user. This stored procedure needs to also create a description of what was updated for auditing purposes. However when debugging ...
1
vote
0answers
108 views

SQL server actual execution plan: finding bottlenecks

I have a batch (7 queries) which executes in a couple of seconds locally by takes more than an hour in production. I've have a .sqlplan XML file from that long running query on production and trying ...
1
vote
0answers
2k views

SQL Error 1452 : Cannot add or update a child row: a foreign key constraint fails

I am trying to install Zabbix by following this guide. I ran into the following problems when trying to run data.sql after running scheme.sql successfully mysql -D zabbix -uzabbix -pPassword < /...
0
votes
0answers
62 views

Debugging value of varchar set to empty string crashes SSMS?

DECLARE @test varchar(1) = ''; SELECT @test When debugging, hovering over @test displays a little {...} token, and clicking the magnifying glass to open the text visualizer causes an application ...
0
votes
0answers
684 views

mysql eating RAM without queries?

Somehow MySQL eats up 50% of my RAM on the server being used. I checked and there are no queries, show full processlist is empty. I restarted the mysqld and within a couple of minutes the RAM usage ...
3
votes
1answer
102 views

A workaround for restoring HierarchyId in SQL server 2014

After installing VS 2015 CTP 4, HierarchyID stopped working in SQL Server 2014. This is the bug listed here. I am looking for a workaround. To that end, I have tried reinstalling everything ...
1
vote
1answer
150 views

Get the Messages stream in an SSRS RDL Report

So I'm trying to troubleshoot a particular SSRS RDL Report that literally takes forever to run (mostly because it has a mile of SQL to run). My question is: Is there any way to retrieve the execution ...
0
votes
1answer
46 views

getting null result from table with data [closed]

So i have those two tables: DROP TABLE Ticket CASCADE CONSTRAINTS PURGE; DROP TABLE Store CASCADE CONSTRAINTS PURGE; DROP TABLE Employee CASCADE CONSTRAINTS PURGE; CREATE TABLE Employee ( emp_ID ...
1
vote
0answers
758 views

Debugging Postgres 9.3 Triggers

Right now I have a trigger in my database that is giving me some issues. I've set up this line so I can check what is being fetched from a query RAISE NOTICE 'hstore_key = %',hstore_key; as well I ...
1
vote
1answer
184 views

Tracing the origin of noTimeout cursors

I'm currently managing a Mongo DB instance that has several applications using it. It's been accumulating noTimeout cursors, and, while it's easy enough to cull them if they start getting overwhelming,...
1
vote
2answers
57 views

Can I find errors without using testing data for all the branches of each function?

In PostgreSQL, syntax errors (except for trivial syntax errors) are reported while running the code in question; unlike Oracle, PostgreSQL can't find errors without running the part of the code. This ...
4
votes
2answers
4k views

How to Log Debug Information About a Stored Procedure

We have a group of fairly complex stored procedures that process a transaction queue on a round the clock schedule. These scripts use a number of print statements to document what is being done to aid ...
3
votes
1answer
2k views

What PL/pgSQL debugger can I use?

I'm building a lot of PL/pgSQL functions and a debugger would really come in handy because RAISE NOTICE is not enough. I read about a pgAdmin plugin you can install but it was only on Windows and I'm ...
2
votes
1answer
97 views

False positive error message in MS Access (concurrent users)

I have discovered a strange apparent bug in MS Access and would like to know if others know it already and hopefully how to get around it. Trying to count records based on known column categories. ...
2
votes
2answers
1k views

How to configure data collection in SQL Server 2012?

In SSMS of SQL Server 2012 Enterprise on Windows Server R2 Standard, each time I am trying to set sub-option "On demand" of option "Non-cached - Collect and upload data on the same schedule" of Data ...
3
votes
1answer
1k views

Why is the “The package can not be saved to the file system since its protection level is server storage” error?

When I execute dtutil /sourceserver localhost /SQL "\Maintenance Plans\MaintenancePlan_daily" /copy file;.\MaintenancePlan_daily.dtsx from the answer to my question "Any way to import-export-...
1
vote
3answers
537 views

How to make SQL Server Agent job history less verbose?

So, I've created a SQL Server Agent job, according to the answer to my prev question: running nightly (at 2:11) according to the schedule: There are 9 .bak files in 3 subdirectory of d:\...
0
votes
1answer
229 views

Error wile debugging (signature buffer too small)

I'm trying to debug a package in SQL Developer, but I keep getting error: ORA-00600: internal error code, arguments: [15419], [severe error during PL/SQL execution], [], [], [], [], [], [] ORA-06544: ...
0
votes
1answer
530 views

MySQL MyISAM index causes query to match no rows; indexes disabled, rows match

I created a table and index as described in this SE post, but when I query the table for a particular ID, no matches are found. When I disable the index, matches are found. Commands ran: CREATE ...
3
votes
1answer
337 views

Is there an effective way to create extended event data that includes stacktraces in SQL Server on a local db instance?

I read Paul Randal's article on getting the symbols for SQL Server. I have a theory that I could get the extended events to read the symbols from the symbol server catch directory by setting the ...
1
vote
1answer
3k views

Is it possible in Oracle to trace SQL statements that result in errors?

We have Oracle 11g in production. Application system is still under active development. It will be very handy to get SQL statements which cause any error. Does Oracle provide a standard function to ...
1
vote
0answers
1k views

MySQL: Writing log entries from stored procedure

Is there a standard way to write log messages in MySQL stored procedures? I can write log messages to a designated log table, but I prefer the standard log mechanism where each message is coupled ...
1
vote
1answer
298 views

debugging an ssis package which is invoked from a .net application?

can we attach a debugger to an SSIS package which is invoked to execute from a .net assembly?
6
votes
2answers
11k views

How to debug deadlocks in SQL Server 2008 R2?

I'm using SQL Server 2008 R2 that automatically lock database items based on my queries. Sometimes this deadlocks - two threads with different queries never ends. Is there any way to debug how SQL ...
2
votes
1answer
1k views

Getting conversion error, for value that doesnt exist in database [closed]

I am running this query: SELECT thirdpid , ea.Empid , ea.Empname , em.RsCode , em.CustomerName AS 'RS Name' , SUM(CASE WHEN ea.Present=1 THEN 1 ELSE 0 END) AS 'Present days' ...
1
vote
1answer
1k views

High MySQL CPU usage, queries seem fine, not running ntp

I've had about 48 hours of extremely high CPU usage on my main MySQL database for no apparent reason. I realize this question is quite similar to the one posed here: High CPU usage from MySQL with no ...
1
vote
1answer
3k views

Why I cannot let EXPLAIN update statements?

I can imagine that it's actually more important to explain SELECT statements, but I wonder why there's no possibility to use EXPLAIN on UPDATEs/INSERTs. I may use a WHERE-statement in an UPDATE where ...
9
votes
1answer
3k views

How do I find out *why* a user has certain effective permissions?

I know that I can query effective permissions by using sys.fn_my_permissions: USE myDatabase; SELECT * FROM fn_my_permissions('dbo.myTable', 'OBJECT') entity_name | subentity_name | ...
1
vote
1answer
3k views

strategy for enabling a general query log on MySQL 5.0.95 with no restart?

I would like to configure a general query log for a busy MySQL 5.0.95 production server without effecting the availability. Obviously I can set the "log" option in the my.cnf file and restart the ...
1
vote
2answers
6k views

Why are breakpoints not being hit in SQL Server Management Studio?

SQL Server Management Studio allows debugging of SQL (breakpoints and stepping through the SQL). It is possible to step in to a stored proc being called and to see a call stack. However I cannot ...
2
votes
1answer
338 views

Has anyone ran into this replication breaking bug before?

I've been having this issue where replication was breaking on colliding primary keys. The annoying thing was these were auto increment generated. I think my issues been tracked down to http://bugs....
5
votes
1answer
6k views

Remote Debugging

I'm having an issue with remote debugging. I have a non-domain server and a non-domain client PC. The client PC can successfully connect to the server and the instance, and it even runs SSMS as the ...