Questions tagged [errors]
For questions about specific error codes or messages, including troubleshooting.
450
questions
0
votes
0
answers
30
views
Getting MySql Error 'aio read' returned OS error 0
MySql server goes down after running for couple of months. I can see below error in the MySQL error logs.
2024-02-12T14:15:58.414920Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' ...
-3
votes
4
answers
127
views
When should I inspect the Error Log?
I've had a varied career, but I have never found relevant information in the SQL Server Error Log. Under what circumstances should I consider inspecting it?
0
votes
0
answers
27
views
A table insert fails during replication with "Incorrect datetime value" but same statement will insert fine manually
I have a two server master-master arrangement running under High Availability on RHEL7. One server is the active server and the other is passive. Only the active server is doing any writing, the ...
0
votes
0
answers
125
views
SQL 2019: Getting a Error: 14151, Severity: 18, State: 1
I created new replication servers for a Cisco Publisher/Subscriber Attendant Console. However, the replication is not working correctly. When I look at the logs on the Publisher side, I get error ...
2
votes
3
answers
102
views
Why is Varchar a lower data type precedence than INT?
Given the following tables:
CREATE TABLE #a
(
MyInt INT
)
INSERT INTO #a VALUES(1),(2),(3),(4),(5),(6),(7),(8),(9),(10)
CREATE TABLE #b
(
MyVarchar VARCHAR(10)
)
INSERT INTO #b VALUES('1'),(...
1
vote
1
answer
136
views
How can run-time errors be distinguished from others?
Consider the following error message.
Msg 207 Level 16 State 1 Line 7
Invalid column name 'FOO'.
Because of how I trigged it, I happen to know that is was a parse/compile time error.
Suppose that I ...
0
votes
0
answers
19
views
SSMS Syntax Error Highlight
In SSMS, a syntax error is highlighted with a red squiggly line. So is the Invalid Object Name error. In my mind, they’re two different things — the second can sometimes be rectified with Refresh ...
0
votes
0
answers
53
views
MySQL 8: show deprecated error only as warning
I'm migrating MySQL from 5.7 to 8.0.32.
I know character set utf8mb3 and its collations are deprecated. But we have lots of functionality and data with utf8mb3,
and we don't have more time to change ...
0
votes
0
answers
145
views
Unable to install the Application file in MacOS
I'm getting this error while installing PostgreSQL "The application cannot be opened for an unexpected reason, error=Error Domain=NSOSStatusErrorDomain Code=-10669 "(null)" UserInfo={...
0
votes
0
answers
63
views
How to get Email Alerts for Errors severity 17-25 on SQL Managed Instance?
Discovered that In Azure SQL Managed Instance, there's no Alerts feature under SQL Server Agent.
According to documentation, Alerts feature for SQL Agent is not yet ready for MI. Hopefully it will be ...
0
votes
0
answers
392
views
Report Server WMI Provider Error: Invalid namespace when connecting to Report Server Instance on Reporting Services Config Manager
I have two SQL Server 2016 instances (Instance A and Instance B) on the same server. Both instances have SSRS. At one point I upgraded Instance A to SQL Server 2019 but then due to the changes made to ...
0
votes
0
answers
275
views
Error in Login securables - SQL Server
I am using SQL Server 2017 and the latest SSMS version. When I click securables of login in SSMS, I see this error:
Object reference not set to an instance of an object. (SqlMgmt)
Program Location:
...
0
votes
1
answer
61
views
Why cannot I create a generated column with a CASE expression? [duplicate]
I'm trying to add a generated column to a table in V7R3 of IBM DB2:
ALTER TABLE MYLIB.MYTABLE
ADD COLUMN NEW_COL VARCHAR(255) GENERATED ALWAYS AS (
COALESCE(
CASE
...
0
votes
2
answers
152
views
mysql table tables_priv index is corrupted and the best possible way to repair it
I am using MySQL with XAMPP.
For sometime now I keep getting a server unavailable error and upon digging deeper I noticed that my mysql.tables_priv table index is corrupted (ARIA Database Type). I ...
0
votes
0
answers
117
views
SQL Default trace not deleting files above the max no of trace files
We have a Sql server 2016 Sp2. Noticed the trace file path D:\Data\MSSQL13.MSSQLSERVER\MSSQL\Log\log_298.trc is getting filled with trace files and the files are more than 2 months old. To my ...
-1
votes
1
answer
80
views
When did they stop showing the Error Code 18486 on SQL Server 2016+ for locked out users
I have noticed that in SQL Server 2016 and later versions, I cannot seem to get the error code 18486 to show up for locked logins i.e.
Login failed for user '%.*ls' because the account is currently ...
0
votes
0
answers
86
views
Aborted connection to db: user: host: 'localhost' (Got an error reading communication packets)
For some time now I'm getting said error from a WooCommerce installation of mine. Since the answers I found to this problem are not applicable or very old I opened my own topic. The WooCommerce ...
0
votes
1
answer
137
views
IF EXISTS doesn't stop errors on RDS Postgres 11.19 instance
Recently one of our RDS Postgres databases was upgraded to version 11.19. Since then, we're receiving errors when running a database migration.
I can't replicate this issue locally, it appears to be ...
0
votes
0
answers
60
views
Not able to install SQL Server 2019
I am installing SQL Server however I'm getting following errors.
Has anyone else encountered similar errors before? If so what's the fix?
1
vote
0
answers
426
views
SOLVED - Mariadb replication Master Slave fail with error code 1595
I've a strange problem.
A Mariadb replication start failing since this morning.
Until today everything works fine from month.
This is my scenario:
I've a server in a DC which is the master, and a ...
3
votes
1
answer
172
views
How is a statistics collection different to normal table stats?
I have a small table with few rows
create table dbo.p(i int);
insert dbo.p(i)
values (1), (2), (3), (4), (4);
I created statistics; no index, just the stats.
create statistics p_c on dbo.p(i) with ...
8
votes
2
answers
5k
views
Getting an "Incorrect syntax near '(' " error message when using the standard create table using a select in SQL Server
Why am I getting the error in the Title of this post when I run the following query using SQL Server via Microsoft SQL Server Management Studio?
-- create the dash_airports table
CREATE TABLE ...
3
votes
1
answer
1k
views
SSMS cannot connect to SQL Server 2022 - Internal Error
I'm trying to connect (on the same host) from SSMS 19.0.2 to a newly installed SQL Server 2022 developer edition instance. I am getting a weird internal error:
===================================
...
1
vote
1
answer
175
views
MySQL 1054 Error After Creating Trigger to Update on Insert
I am learning basic SQL and have gotten stuck with triggers. I have a database with two tables, customer and invoice. The table characteristics follow:
CREATE TABLE customer (
CUST_NUM ...
2
votes
2
answers
52
views
Backup syntax error with constructed string
This is doing my head in. What am I missing? Syntax errors with '+' and ;
-- Step 1: Perform a database backup
BACKUP DATABASE iMIS_Prod TO DISK =
'G:\SP_Backup_Daily\iMIS_Prod_' +
...
3
votes
2
answers
780
views
psql can't connect to existing db
i have problem with connecting to database via psql. I get this error:
postgres@server:/var/lib/pgsql # psql -d aisgdmp2
psql: error: FATAL: database "aisgdmp2" does not exist
DETAIL: The ...
1
vote
1
answer
38
views
This query gives error. right syntax to use near 'on vehicles.school_id = schools.id left join drivers on drivers.school_id = ...' at line 8
select drc_users.name,
vehicles.total_vehicles,
COUNT(distinct drivers.id) as total_drivers
from drc_users
LEFT join brc_users on drc_users.id = brc_users.district_id
left join crc_users on crc_users....
-2
votes
1
answer
526
views
Msg 2732, Level 16, State 1, Line 376039 Error number 515 is invalid. The number must be from 13000 through 2147483647 and it cannot be 50000 [closed]
Please help me how to solve it. why is it throwing this error as my script is inserting data into various tables extracted from an environment.
#376039 is the catch block where rollback and other ...
1
vote
1
answer
882
views
Error 1109: unknown table ‘account’ in filed list
When I inserted the values in new table, I had met a problem in there. The trigger will be shown below:
delimiter $$
create trigger validation_check before insert on exercise.account for each row
...
0
votes
0
answers
158
views
How to get session information for Azure SQL Database errors via Kusto?
I have a kusto query that finds errors in some of my Azure SQL Databases:
AzureDiagnostics
| where TimeGenerated > ago(1d)
| where Category == "Errors"
and DatabaseName_s has "<...
0
votes
1
answer
104
views
unable to add data to a table in mysql, Error Code: 1054
##Created table using the following line:
create table sales (
product_id int,
sell_price float,
quantity int,
state varchar(20) );
##Tried to input values using the following line
insert ...
1
vote
0
answers
418
views
Azure SQL Error "Invalid object name '##{myTempTableName}'
I am getting an error in my stored procedure: "Invalid object name '##{myTempTableName}' for 3 global temporary tables. There are several temp tables used in the procedure, but I am getting this ...
0
votes
1
answer
204
views
Migration MySQL to Oracle 19C error ORA-00942
I'm trying to migrate a simple MySQL test database to Oracle 19c using the migration wizard available in Oracle SQL Developer, the result is that the procedure create the user and the tables but the ...
1
vote
1
answer
653
views
How to use multiple arguments in ANY query when is bind message supplies parameters trhowing error?
I have the following query that is using one parameter that contains a lot of valid values to validate with ANY, right now I need to cast the id from bigint to int and validate with integers (This is ...
1
vote
1
answer
2k
views
MySQL procedure exists, but doesn't
I am attempting to add a stored procedure to a database that does not show that any exist in tree (Workbench):
As this screenshot of tree shows.
Also, executing:
SHOW PROCEDURE STATUS where Db = '...
-2
votes
2
answers
154
views
Making SQL give age brackets on command
I'm trying to make SQL return how many users are inside each age bracket grabbing the date of birth from the user from the table GUEST and converting it into years, at the moment I'm trying to make it ...
3
votes
2
answers
957
views
How do I find the line that causes SSMS "Msg 8115, Level 16, State 2, Line 1"
I've got a 400 line query in MS SSMS. When I run it I get:
Msg 8115, Level 16, State 2, Line 1
Arithmetic overflow error converting expression to data type int.
Line 1 is just the "Select&...
0
votes
1
answer
549
views
Infinite running loop while executing procedure
I have this table with 3 records. 3 records are create scripts. I need to execute the create scripts and if there is a 208 error occurred then I need to keep the record and set status as 1. Then ...
2
votes
2
answers
638
views
Invalid object name error while creating function
I have this function get_department. Inside the function there is a function call for get_po_amount.
The get_po_amount function doesn't exist anymore, so when I try to create the Main function ...
2
votes
2
answers
296
views
DROP ALIAS unable to drop existing alias?
We're unable to drop aliases.
So, I found an alias by running:
SELECT
TABLE_NAME
FROM
QSYS2.SYSTABLES
WHERE
BASE_TABLE_NAME IN ('OE0711P','OE0712P')
AND TABLE_TYPE = 'A'
AND ...
3
votes
1
answer
477
views
in trouble -SQL database corruption
Recently we have been unable to do much of anything, as it seems our SQL database has some corruption. They advised us that corruption has been present for over a year, so there are no clean backups ...
1
vote
1
answer
29
views
Syntax issues when uploading backup from mysql5.7 to percona xtradb 5.7
Greetings to those readying the thread and thank you for devoting your time to answering the question.
I have encountered a problem when uploading a MySQL 5.7 backup database to a Percona xtradb 5.7 ...
4
votes
2
answers
778
views
How can I get a Postgresql error number in psql?
How can I access the numeric code of an error in psql?
For example, in this case I would like to get the value 23503 ("foreign_key_violation") as documented here:
https://www.postgresql.org/...
0
votes
0
answers
277
views
Transactional Replication Errors - Missing and Duplicate Data at Subscriber
We recently experienced errors with SQL Server Transactional Replication on a client's system. Replication is running from a SQL 2017 server to an Azure DB.
Initially some replicated update commands ...
1
vote
1
answer
1k
views
MySQL from backup won't start due to possibly corrupted data folder or permissions
A few days ago I was forced to format my PC due to an issue with a Windows update, I managed to make a backup first and now I'm trying to restore the files.
I have a mysql instance that I'm having ...
7
votes
3
answers
744
views
How does this piece of TSQL work?
Why the following batch doesn't work as expected?
DROP TABLE IF EXISTS #test1;
IF 1 = 1
SELECT *
INTO #test1
FROM sys.databases
WHERE database_id <= 5;
ELSE
SELECT *
INTO #...
7
votes
4
answers
4k
views
Microsoft SQL Server 2019 Developer Edition suddenly throwing Internal Connection Fatal Errors
I have Microsoft SQL Server 2019 Developer edition installed on my computer for local development work with .NET. Everything was working well as of two months ago, when I was last working on a ...
5
votes
2
answers
381
views
Random Error 824 - All Environments
We have been experiencing seemingly random error 824 on our DEV/QA/PROD SQL 2017 Enterprise servers. The servers run nearly identical code ingesting identical daily files via an ETL process into our ...
0
votes
0
answers
118
views
How to find statement causing "The user does not have permission to perform this action." in Azure SQL Database?
I ran a Kusto query:
AzureDiagnostics
| where TimeGenerated > ago(1d)
| where Category == "Errors" and error_number_d == 297
| summarize count(), min(TimeGenerated), max(TimeGenerated) ...
1
vote
0
answers
168
views
MySQL not throwing some errors in prepared statement
If I run the following query:
DELETE FROM `table` where `id` = '123%7D';
Notice the gibberish at the end of the where clause
I get the following error
ERROR 1292 (22007): Truncated incorrect DOUBLE ...