Questions tagged [debugging]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
1answer
15 views

Is it ok for MySQL to always use 18-25% of Memory (I have 2 GB Ram)?

I have MySQL 8 in my Server with Ram of 2GB. And MySQL is always using 18-25% of Ram even when everything is off. Is it normal? If not then plz let me know how to debug it.
1
vote
1answer
91 views

Duplicate rows with primary key constraint in PostgreSQL 10.6

I have a table that's had CONSTRAINT table_pkey PRIMARY KEY (id) since setup. However, I recently found that I have around 100 duplicate rows (I ran select count(*) from (select count(*) from table ...
1
vote
3answers
976 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:\backup\ ...
1
vote
1answer
343 views

Include stored procedure text output in the maintenance plan log

I have a maintenance plan subtask in SQL Server 2012 Enterprise that executes a stored procedure (or a SQL Server agent job). In the log file for this maintenance plan, there are a few lines for this ...
3
votes
1answer
277 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 associated ...
1
vote
2answers
220 views

IN clause not working on mysql 8.0.17

I was on mysql:8.0.15 and I updated to mysql:8.0.17 On 8.0.15 ... and (col1, col2) in (('a', 'b')) the query return results, this is what I expect On 8.0.17 the same query with same data return 0 ...
0
votes
2answers
37 views

How use raise notice in nested and sub-function?

I'm using PgAdmin to create multiple pgsql functions. I'm beginner on this environment. I'm using 'raise notice' to help me for debugging phase. I have two functions with 'raise notice' statement. ...
2
votes
0answers
111 views

Why is an Oracle Package Variable Intermittently Incorrect after Multiple Updates

I am supporting an application that runs on Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production. We have a table that stores hourly data that uses triggers call a package to ...
1
vote
4answers
71 views

Investigating an Oracle 12c outage after the fact, while limited to SQL*Plus

Warning up front: unfortunately I'm limited to using SQL*Plus on remote site, with no other tools available. This is Oracle 12c (12.2.0.1.0) Standard Edition running on Windows Server 2012R2. Over ...
1
vote
0answers
11 views

How to get the name of a variable instead of its value in plpgsql?

I write a lot of debugging code in plpgsql along the lines: RAISE NOTICE 'var1 = %', var1; (there can be more than one variable to print out). Is it possible to avoid having to repeat the variable ...
1
vote
1answer
84 views

How to profile the PostgreSQL query planner diagnose what is causing it to take up large amounts of memory and time

I'm fighting with a specific "generated" query (the SQL is generated from a proprietary system, and I won't be able to share it or the execution plan here), and running into simply massive memory ...
0
votes
1answer
30 views

Query stuck in mattermost postgresql communication

Ubuntu 18.04 PostgreSQL 10.10 Mattermost 5.15 On mattermost startup process stay forever on {"level":"info","ts":1570609055.2422519,"caller":"sqlstore/supplier.go:223","msg":"Pinging SQL master ...
0
votes
1answer
570 views

Finding the cause of a stuck “Sending Data” query in MySQL

I'm running MySQL on a 1gb DigitalOcean droplet, and I have a number of scheduled tasks through the Laravel framework that run. One task in particular (seemingly) randomly causes MySQL to sit at 100% ...
1
vote
1answer
625 views

Identify mysqldump activity in MySQL log file?

I have a database that is being regularly backed up by mysqldump by... something. It's not a script that I wrote, not sure whose it is. I'm trying to find out more about these dumps, such as what ...
0
votes
0answers
39 views

How to debug INSERT statements

I have issues importing "not-so-small" dumps to MariaDB 10.4.6 in CentOS, but the error log and stderr is empty. I dumped many databases with mysqldump sized around 50MB / 500.000 rows each, and ...
0
votes
1answer
939 views

SQL Server Management Studio - Debugger buttons greyed

I have for mission to enable Transact SQL from a remote computer. My database is on a server and i'm trying to use the debug from a computer on the same network. My firewalls are all open on both side....
7
votes
1answer
6k 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
2answers
5k 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
1answer
3k views

Mysterious postgres process pegging CPU at 100%; no running queries

I have a recurring issue where a postgres process is pegging my cpu at > 100%. It's a strange one, you can see below the command is ./Ac2p20853 (surrounded by asterisks, added by me). Running SELECT ...
15
votes
2answers
11k views

How do I determine why a MongoDB document is failing validation?

How do I determine why a MongoDB document insert is failing validation? All I get back is a writeError that says "Document failed validation", which isn't very helpful. (This happens often, and I'd ...
1
vote
2answers
138 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 ...
2
votes
1answer
432 views

mariadb (mysql) innodb not optimizing SELECT for partitions?

I have a table partitioned by on column "level" -- I have logs where level 7 is the verbose info, which is like 20x as many entries as all the other levels. When purging old logs in level 7, it was ...
2
votes
1answer
186 views

PostgreSQL: Log statements which do sequential scans

I use this snippet to detect missing indexes: https://stackoverflow.com/a/12818168/633961 Example: SELECT relname AS TableName, to_char(seq_scan, ...
5
votes
4answers
7k views

SQL Server Debugger Permissions without Granting sysadmin to Devs

BOL documentation says sysadmin permission is required to run debugger. I'm 90% certain there is no workaround to this requirement, but thought I would ask just in case someone found a way to grant ...
5
votes
1answer
2k views

Failed to start TSQL debugger

I want to debug in TSQL.When I start the debug the following message box popup. In SSMS v17.2 Then I see this message: In Microsoft Visual Studio 2015 Server Explorer same Error: Then I see this ...
0
votes
1answer
659 views

MySQL 5.7 GetDiagnostics is always returning null for SQLSTATE What am I doing wrong?

I have the following Handler and the sqlexception is being caught, but GET DIAGNOSTICS is not returning any information - they are all NULL. I have the following code: DECLARE CONTINUE HANDLER FOR ...
1
vote
1answer
305 views

MongoDB Implicit And

I'm trying to understand mongodb queries, but one of my queries is returning a record that it shouldn't. I am trying to call db.user.find({'referral.money':{'$ne':0, '$ne':null}}) to get all users ...
11
votes
1answer
2k 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 of ...
1
vote
0answers
1k views

Dynamic SQL Stored Procedure called by a Function

I want to be able to dynamically call a function that contains a select statement whose table changes depending on the function parameters. I know this is not possible to do within a function, but I ...
6
votes
2answers
15k 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 ...
1
vote
2answers
1k views

How to set default schema for PostgreSQL debugger?

I have 3 schemas: public, meta, data. While debugging large function from "data" schema in PgAdmin III or SQL Manager for PostgreSQL, debuggers doesn't see any tables or functions from the same ...
0
votes
0answers
403 views

How to know why my query times out sometimes, but gets executed other times (random behavior)?

I look at my code's logs, and see that a query to delete something which occurs like 200 times a day, sometimes times-out. I have no clue to how to debug this. Because it's a very random behavior. ...
1
vote
1answer
164 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 - ...
1
vote
2answers
91 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 ...
5
votes
2answers
8k 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 ...
2
votes
2answers
3k 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
230 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
64 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' ...
2
votes
1answer
760 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
0answers
530 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
3k 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
161 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
3k 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 ...
1
vote
1answer
419 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
47 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 ...
2
votes
1answer
106 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. ...
4
votes
1answer
3k 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-...
3
votes
2answers
11k 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 ...
1
vote
0answers
2k 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 ...
4
votes
1answer
3k 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 ...