Questions tagged [errors]
For questions about specific error codes or messages, including troubleshooting.
463 questions
4
votes
2
answers
406
views
If LATERAL is optional for table-valued functions, then why does this query error without it?
Setup
CREATE TABLE persons
(
person_id int not null,
name TEXT
);
INSERT INTO persons VALUES
(1, 'Adam'),
(2, 'Paul'),
(3, 'Tye'),
(4, 'Sarah');
CREATE TABLE json_to_parse
(
person_id int not ...
- 823
0
votes
0
answers
10
views
I recieve TypeError while getting an array from mongodb
As I declare an array in the model
@Prop({ type: [Types.ObjectId], default: [] })
for_users_ids: Types.ObjectId[];
As I want here to send a socket event to all the users of this notification, but I ...
0
votes
0
answers
96
views
mysql ibd import error: cannot reset LSNs in table: Data structure corruption
I am using mysql (Ver 8.0.26 for Linux on x86_64) on centos 8.
I have copied *.ibd with *.cfg file from one server to another server as follows:
source server (Server1)
mysql> show create Table \...
- 1
0
votes
0
answers
198
views
MySQL redo log error (log files come from different directory)
I've set up a PHP + MySQL project on a client's computer. Now, they're facing a problem. This is the second time I've fixed it. The MySQL80 process stops working. If I manually try to start it from ...
0
votes
1
answer
54
views
How to get detailed error messages. Include table & column names & records. Conversion failed when converting the varchar value 'A' to data type int
I have an old, large (more than 140 lines), and complicated SQL query. It is joining many tables and has detailed WHERE conditions with values and a detailed GROUP BY part.
Query Structure
SELECT
...
- 318
0
votes
1
answer
68
views
ORA-01555 snapshot too old: optimize query?
My users are launching an ugly UPDATE with linked sub-selects, an online query coexisting in a very agressive online environment.
In the trace, I saw an estimation of the UNDO retention needed, which ...
- 123
1
vote
0
answers
68
views
Capturing in-memory OLTP transaction aborted errors in SQL Server
In one of my SQL Server 2016 Enterprise instances, sp_BlitzFirst is reporting hundreds of aborted transactions per second in one of my in-memory OLTP databases.
I've set up error logging with try/...
- 79
-2
votes
1
answer
22
views
Online docs has incorrect JVM flag unsafe_aggressive_sstable_expiration for TimeWindowCompactionStrategy
I was installing the unsafe_aggressive_sstable_expiration and found out that there is a mistake in the documentation. The documentation told us that we needed to enable in the jvm -Dcassandra....
0
votes
1
answer
32
views
Importing mysql file fails printing last line and I find ^@^@^@^@^@^@^@^@^@^ on that line
I am trying to import some relatively large databases, over 100 GB dump file.
When I try to import the dump files with a command like:
mysql -h localhost -u username -p dbname < backup.sql
after ...
- 204
0
votes
1
answer
51
views
Simple SSIS package that is successful, but "fails"
We have an SSIS package that runs at midnight daily. It pulls data from Active Directory using ADSI query and pushes the data to a CRM.
The only time it "fails" is on Sunday night. Here is ...
- 1,385
0
votes
0
answers
92
views
Communication link error when Running a stored procedure that hits a a separate server via linked server
I’ve ran into an issue where we’re trying to execute a stored procedure from server A which fetches data in a variable from server B. The SP calls a linked server that exists on server A.
However, ...
6
votes
1
answer
462
views
What does SQL Server's Error Log actually log?
If you have ever played around with the error_reported Extended Event, then it becomes very obvious that the SQL Server Error Log only logs a tiny fraction of the errors that are thrown by code ...
- 823
2
votes
1
answer
976
views
Could not locate statistics in the system catalogs error in SQL Server
I've been trying to access a table on our reporting server (secondary replica) from our warehouse server via a linked server. Everything was working smoothly until last week, but now it's throwing a &...
- 601
2
votes
1
answer
92
views
Foreign Key Error in SQLite3 CREATE TABLE Command
Looking for fresh eyes on this, I'm running the command in sqlite3 interactive and can't see the problem. Here's the code:
CREATE TABLE Personas(
PersonID INTEGER NOT NULL PRIMARY KEY,
...
- 123
4
votes
1
answer
105
views
What defines a "column" in a GROUP BY statement
A question came up about an error in a Stack Exchange Data Explorer query which I tried to diagnose. The error reads:
Cannot resolve collation conflict between "SQL_Latin1_General_CP1_CI_AS"...
- 190
3
votes
1
answer
794
views
What exact error messages do UMPPC*.DLL and SCRIPTCONTROL*.DLL cause SQL Server Agent when it fires SSIDB packages?
Microsoft's maintains a list of bad DLLS. This is one item on that list (emphasis mine)
UMPPC*.DLL and SCRIPTCONTROL*.DLL
These DLL files are loaded in to the address space of SQL Server related ...
- 823
0
votes
0
answers
11
views
Migrating a web site from shared cPanel to unmanaged Ubuntu 22.04 vps and not able to successfully import an sql file
I got an unmanaged VPS from Hostinger a week ago and am trying to host a few web sites on the server. I have to say here that I am quite new to Ubuntu 22.04 with FASTPANEL.
I have migrated the files ...
- 1
0
votes
0
answers
205
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' ...
- 1
-3
votes
5
answers
289
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?
- 823
0
votes
0
answers
43
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
592
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 ...
- 1
2
votes
3
answers
119
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'),(...
- 2,083
1
vote
1
answer
141
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 ...
- 823
2
votes
0
answers
714
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 ...
- 5,964
0
votes
0
answers
916
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 ...
- 1
0
votes
1
answer
481
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
121
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
...
- 281
0
votes
1
answer
384
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
231
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,063
-1
votes
1
answer
122
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 ...
- 1
0
votes
1
answer
242
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
63
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
1k
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
213
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 ...
- 25.1k
8
votes
2
answers
8k
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 ...
- 227
3
votes
1
answer
2k
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:
===================================
...
- 131
1
vote
1
answer
232
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 ...
- 11
2
votes
2
answers
65
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_' +
...
- 21
3
votes
2
answers
1k
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 ...
- 45
1
vote
1
answer
42
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....
- 123
-2
votes
1
answer
948
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
1k
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
...
- 21
0
votes
0
answers
227
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 "<...
- 2,191
0
votes
1
answer
144
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
531
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 ...
- 11
0
votes
1
answer
342
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
1
vote
1
answer
893
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 ...
- 121
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 = '...
- 449
-2
votes
2
answers
177
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
2k
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&...
- 203