Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [warning]

17 questions
25
votes
2 answers

When does SQL Server warn about an Excessive Memory Grant?

What are the conditions that produce an "Excessive Grant" execution plan warning? The query memory grant detected "ExcessiveGrant", which may impact the reliability. Grant size: Initial 5128 KB, Final 5128 KB, Used 16 KB. SSMS Plan Explorer …
Paul White
  • 94,921
  • 30
  • 437
  • 687
22
votes
1 answer

Should I be alarmed by this NO JOIN PREDICATE warning?

I'm troubleshooting the bits and pieces of a poorly-performing stored procedure. This section of the procedure is throwing a NO JOIN PREDICATE warning select method = case methoddescription when 'blah' then 'Ethylene…
swasheck
  • 10,755
  • 5
  • 48
  • 89
6
votes
4 answers

Implicit conversion warning despite persisted computed column vs. performance hit from UDF in persisted computed column definition

I have a need for a computed column to resolve an implicit conversion problem. I have a column that is declared as a VARCHAR that should only ever store integers, but is occasionally populated in error by a third-party application with strings, so…
Mark Freeman
  • 2,293
  • 5
  • 32
  • 54
5
votes
2 answers

MySQL "Statement may not be safe to log in statement format" warning

What is the meaning of the following MySQL warning: Statement may not be safe to log in statement format. I have some tens of thousands of these statements every day in my mysqld.err file, and I'm not sure where should I begin my investigation.
Adam Matan
  • 12,079
  • 30
  • 82
  • 96
4
votes
2 answers

Execution Plan Warnings cardinality xml data type

I have the following statements: -- 1st DECLARE @AuditParameters XML = ( SELECT 1 AS AccountID, 2 AS CategoryID, 3 AS CategoryAttributeID, '4' AS SyncBatchGUID FOR XML PATH(N'Parameters'), ELEMENTS…
Kevy Granero
  • 143
  • 4
2
votes
0 answers

Unsafe statement written to the binary log using statement format

In MySQL error log I am getting this warning message: [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it invokes a trigger or a stored function that inserts…
Rk Singh
  • 145
  • 1
  • 12
1
vote
1 answer

MySQL: Why am I getting this warning?

I am calling the stored procedure below, and get this warning, is this warning a false positive or is my query unsafe? 1 queries executed, 1 success, 0 errors, 1 warnings Query: call User_Signup('lee3@gmail.com', 'password', 'Lee', 'Brooks', null,…
Lee
  • 171
  • 6
1
vote
0 answers

mysql: make the server fail instead of just giving warnings

I have a mysql 5.7 server. I am trying to import some .csv files. Sometimes it may so happen that these are malformed. Here is a sample case: - 'mysql: [Warning] Using a password on the command line interface can be insecure.' stdout: |- …
pkaramol
  • 213
  • 1
  • 4
  • 9
1
vote
0 answers

Converting an XML field to nvarchar causes warning on main SELECT in explain plan

I'm getting a warning on my main SELECT on one field in the explain/execution plan of my query on the following: SELECT ISNULL(CAST(p.loadDiagnostic as nvarchar(4000)),'''') FROM myTable p This select to convert the loadDiagnostic field which…
shawnyshawny
  • 13
  • 4
1
vote
1 answer

INSERT of 1 wrong value -> Error; INSERT of 2 wrong values -> Warning!

CREATE TABLE `dummy` ( `a` TINYINT(4) NOT NULL ) ENGINE=MyISAM; 1 wrong value INSERT INTO `dummy` (`a`) VALUES (NULL); /* SQL Fehler (1048): Column 'a' cannot be null */ /* Nothing is stored! */ 2 wrong values INSERT INTO `dummy` (`a`) VALUES…
powtac
  • 161
  • 2
  • 11
0
votes
1 answer

MySQL Workbench: "Operation has completed with warnings"

As I synchronize my database, MySQL Workbench reports: "Operation has completed with warning. Please see logs for details." But the Message Log just says: Fetching schema list. OK WARNING: Server configuration check I don't know what this is…
Stefan Falk
  • 165
  • 8
0
votes
1 answer

ODBC Data Source Administrator: Driver name is an empty string

Below you will see a screen shot of a warning in Windows 7. Why would I get this error when opening up "Data Sources (ODBC)"? How can I resolve it? If you can give me some tips on where to start looking, I can make edits to this question to help…
JustBeingHelpful
  • 2,116
  • 18
  • 45
  • 61
0
votes
0 answers

Need help with warning,Error : 1287,Setting user variable within expression is deprecated

I have a simple table named product_images defined as: FieldType Null Key Default Extra image_id int NO PRI product_id int NO PRI image_url varchar(255) NO public_id varchar(225) YES Whenever an image…
VELCR0
  • 1
0
votes
1 answer

Conversion may affect "CardinalityEstimate" CONCAT NVARCHAR and UNIQUEIDENTIFIER

So I have a temporary table with only one column NVARCHAR(400). In this temp table, I Insert values from various sources. One of these is INSERT INTO @permissions SELECT Concat (N'resourcetype_', CONVERT(NVARCHAR(36), resourcetypeid)) FROM …
Cătălin Rădoi
  • 103
  • 2
0
votes
1 answer

Select data at row number in warning

When running show warnings in mysql, sometimes the results give a row number, such as "Warning | 1265 | Data truncated for column 'identifier' at row 12343". I'm interested in doing something like: select identifier from tablename where rownum =…
enharmonic
  • 203
  • 1
  • 2
  • 9
1
2