Questions tagged [errors]
For questions about specific error codes or messages, including troubleshooting.
420
questions
0
votes
0
answers
14
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
1
vote
0
answers
18
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 ...
- 111
6
votes
3
answers
711
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 #...
- 600
2
votes
1
answer
61
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 ...
- 23
5
votes
2
answers
214
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 ...
- 153
0
votes
0
answers
17
views
Executing SSIS in Powershell
I am trying to execute an SSIS package from Powershell where th,e package has several configured environment references.
$null = [Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer....
- 101
0
votes
0
answers
38
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) ...
- 2,078
0
votes
0
answers
44
views
MySQL syntax error
CREATE DEFINER=`rpt`@`%` PROCEDURE `update_week_s`()
BEGIN
DECLARE col_name varchar(100);
DECLARE finished INTEGER DEFAULT 0;
DECLARE col_names CURSOR FOR
SELECT column_name
FROM ...
1
vote
0
answers
50
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 ...
0
votes
1
answer
535
views
SQL Server is terminating this session. c0000005 EXCEPTION_ACCESS_VIOLATION
I Got Error:
A user request from the session with SPID 183 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log ...
- 21
0
votes
1
answer
70
views
Distinguish errors I raise from other SQL Server errors
In my stored procedures, when a business rule is broken I raise an error that bubbles up to the C# client app and gets displayed to the user. e.g.
RAISERROR('Hey, you cannot do that because blah blah ...
- 501
0
votes
0
answers
70
views
Oracle 19c-ee CTX_REPORT.INDEX_SIZE and CTX_REPORT.INDEX_STATS cannot be executed
We created a simple search index, based on a 19c-ee instance of the official Oracle Docker images, with the following script:
CREATE TABLE EVT (
ID VARCHAR2(36) NOT NULL,
EVENT BLOB NOT ...
- 11
-4
votes
1
answer
59
views
Finding the errors in SQL and interpreting what the SQL codes mean
Find all 5 errors in the SQL script below and explain what the script is trying to do
select
A.BIZ_DT,
A.ACTL_PARENT_SVC_NUM,
A.DIRCTN_IND,
A.BUS_STOP_CD,
A.BUS_STOP_ARRVL_TM,
A.OPR_ID_NUM,
A.REG_NUM,
...
4
votes
2
answers
522
views
Why does this query fail when I run it from a SQL Server job?
I know how to solve the issue, but I don't understand the technicality of why the below query would work when I run it from SSMS, but the same query fails when I add it as a job in the SQL Server ...
- 88
0
votes
1
answer
30
views
How to run merge statement based on logic of joined table?
When I try to run a query like the following:
MERGE INTO
MYTABLE_A
AS MERGE_TARGET
USING
(
SELECT
MYTABLE_A.A, MYTABLE_B.B, MYTABLE_A.C, MYTABLE_D, MYTABLE_E
FROM
MYTABLE_A
...
- 255
0
votes
1
answer
180
views
What could be the reason for this invalid objects after trying to upgrade?
We recently wanted to upgrade our Database but didnt get to do it as we got a lot of Audit specific invalid objects, after looking online for ressources we couldnt find anything specific reason for ...
- 1
0
votes
0
answers
281
views
Linked Server Error Msg 7321, Level 16, State 2, Line 1
I am getting the following error when I execute a simple linked server query.
OLE DB provider "MSDASQL" for linked server "name" returned message "HTTP request returned status ...
- 63
0
votes
1
answer
91
views
How to debug "General error: 1030 Got error 0 "Internal error/check (Not system error)" from storage engine Aria
(In other similar questions, the error number has been 168, in my case it's zero.)
This occurs on attempting to load a massive view (which itself is a select query on another view). Many JOINS are ...
- 101
0
votes
0
answers
52
views
Which option should I use to avoid error #2006 on MySQL (Docker Compose)
I am getting error #2006 - MySQL server has gone away while trying to restore a 11.9 mb database using PhpMyAdmin. It worked with a 4.70 mb database, but not with this one
I thought that if I put --...
- 101
1
vote
1
answer
291
views
Error Severity 16 Alert being raised for events where is_event_logged = 0
I have an error level 16 alert set up as follows:
USE [msdb]
GO
EXEC msdb.dbo.sp_add_alert @name=N'Error - Severity 16',
@message_id=0,
@severity=16,
@enabled=1,
@...
- 1,600
0
votes
0
answers
36
views
Can't log in phpmyadmin, also can't acces the database
My website seems to have been "played" with, I was not able to log in wordpress. I entered my phpMyadmin and I edited the administrator password directly in the wp_users table and I managed ...
- 1
0
votes
1
answer
35
views
How do I record an application session duration in SQLite?
Objective: Log the session duration of the user on the application.
I have a session_log table:
CREATE TABLE IF NOT EXISTS "session_log"
(
"id" INTEGER PRIMARY KEY,
...
- 25
0
votes
1
answer
531
views
problem installing mariadb using mysql_secure_installation
I started secure install of MySQL with sudo mysql_secure_installation command, and I got that message:
Securing the MySQL server deployment.
Enter password for user root:
Error: Can't connect to ...
0
votes
1
answer
336
views
Trigger created with compilation errors
SQL> create table master(pno number(5) primary key,pname varchar2(20),price number(10,2),stock
number(5));
Table created.
SQL> create table trans(p_no number(5),no_pro_sold number(5));
Table ...
0
votes
1
answer
467
views
Division By 0 error when running an update query MySQL
I am trying to run an update in a table and I get an "Error Code: 1365. Division by 0". The sql commands I use are these:
SET @@autocommit = 0;
start transaction;
update XE_General
join ...
0
votes
1
answer
1k
views
Strange Error ... Conversion failed when converting the varchar value 'www.com' to data type int
The issue that I am running into is happening on Microsoft SQL Server.
I have a view that is unioning together 2 tables. It is returning a little over 7 million records.
When I attempt to JOIN ...
- 33
0
votes
1
answer
610
views
oracle stored procedure errors: ORA-00904 invalid identifier, dynamic SQL
I am trying to find all tables that contain column called arg_column_name, look up value arg_column_value in that column of those tables, and return names of the tables and counts of found rows to the ...
-3
votes
1
answer
523
views
ORA-00907 error missing right parenthesis in CREATE TABLE
I am getting an error as ORA-00907 (missing right parenthesis) but I think it's a generic error and not related to parentheses.
CREATE TABLE reservation
(
PNRno int(9) primary key,
journey_date ...
2
votes
1
answer
259
views
Why does adding a WHERE clause break my working query, with error "Query processor could not produce a query plan because of the hints defined..."?
I have the following (stupidly-simplified) query that leverages two CTEs that refer to the same table and joins them to each other:
WITH CTE1 AS
(
SELECT dbo.RemoveNonNumericCharacters(PhoneNumber)...
- 26.7k
0
votes
0
answers
69
views
SQL 2008r2 : The database is not accessible
Is there something that I am missing?
Newly created database with 2 users. Both have the same permissions. SQL01 gets error "The database DB01 is not accessible" on browsing through SSMS.
...
1
vote
1
answer
336
views
Using the array result of a select statement returns ERROR: pq: operator does not exist: integer = integer[]
The query in question is the following:
SELECT * FROM options WHERE id = any(SELECT option_ids FROM workshops WHERE id=3)
ERROR: pq: operator does not exist: integer = integer[]
Basically the ...
0
votes
1
answer
785
views
oracle pl/sql block throwing ORA-00922: missing or invalid option
I have the following segment of oracle pl/sql block
DECLARE
rec all_tab_columns%ROWTYPE;
v_tableName VARCHAR2(100);
v_columnName VARCHAR2(100);
v_schemaName VARCHAR2(100);
BEGIN
...
- 13
1
vote
1
answer
140
views
WITH statement, invalid identifier error
Using the below as an example:
WITH
V_TBL1 (ID,NAME) AS (SELECT ID,NAME FROM TABLE1),
V_TBL2 (TIME) AS (SELECT TIME FROM TABLE2 WHERE TABLE2.ID IN (V_TBL1.ID))
SELECT * FROM V_TBL2
;
...
- 171
1
vote
0
answers
182
views
Sql Server Agent Job - Unable to start execution of step 1 (reason: Error authenticating proxy "user", system error: The user's account has expired.)
My predecessor created several "Intergration Services Catalogs" dtsx packages which are scheduled / run via SQL Server Agent -> Jobs using an SSISFileProxy which is using ...
- 11
0
votes
0
answers
38
views
Detail about communication packets error log
On MySQL error log /var/log/mysql/error.log I'm getting this error couple of times during the day:
2021-08-23T07:30:17.660730Z 455148 [Note] Got an error reading
communication packets
My question is ...
- 139
-1
votes
2
answers
125
views
Column or globale Variable not found [closed]
Error msg:
DataSource.Error: ODBC: ERROR [42S22] [IBM][System i Access
ODBC-stuurprogramma][DB2 for i5/OS]SQL0206 - Kolom of globale
variabele AADETX niet gevonden. Details:
DataSourceKind=Odbc
...
2
votes
2
answers
410
views
DBCC consistency error in SQL Server
I ran DBCC CheckDB in our Production SQL Server 2014. It reported back with one consistency error:
Failed:(-1073548784) Executing the query "DBCC CHECKDB(N'MYDB') WITH NO_INF..." failed ...
- 63
3
votes
2
answers
402
views
Getting "ORA-04030: out of process memory" on medium insert with large pga and sga
Running on Oracle 12.1.0.2 AIX Power9 (yes, I know it's 2021, but that's the customer I've got)
Executing a plsql block that includes 1000 inserts as plain text and commit in the end.
begin
insert ...
- 141
0
votes
1
answer
326
views
pg_restore: error: could not execute query: ERROR: materialized view "ws1_all_formate" has not been populated
I had this error after the execution of pg_restore:
pg_restore: finished item 19181 MATERIALIZED VIEW DATA avenant_f
pg_restore: from TOC entry 19171; 0 2565914 MATERIALIZED VIEW DATA ...
1
vote
1
answer
805
views
Can't do simple query or drop table due to out of memory error, but pg_locks return no lock
I received this out of memory error when trying to drop a large table (70GB including index) but couldn't identify the root cause from pg_locks view
DROP TABLE big_table;
ERROR: out of shared memory
...
- 11
0
votes
1
answer
1k
views
Why can't I use command \i on psql? It says no such file or directory [closed]
I am trying to use command \i 'C:\Users\Public\person.sql'; on windows on psql.
And it says C:UsersPublicperson.sql: No such file or directory
Although file does exist. I tried to relocate file on ...
- 1
0
votes
2
answers
1k
views
An error occurred while updating the entries. See the inner exception for details.; [INNER] Execution Timeout Expired
One of our production SQL Servers the database is performing poorly. On the application side, they are experiencing this error:
An error occurred while updating the entries. See the inner exception ...
- 63
3
votes
1
answer
1k
views
Constraint in ON CONFLICT clause has no associated index
I have this simple setup using PostgreSQL 13, latest dockerized:
CREATE TABLE stop (
id INT UNIQUE,
name TEXT,
PRIMARY KEY(id)
);
CREATE TABLE line (
id INT UNIQUE,...
- 131
0
votes
1
answer
657
views
Why do I get #2006 MySQL server has gone away and how can I fix this?
What I'm doing is I'm trying to restore MySQL tables from frm and ibd files. Most of the tables have been restored successfully.
I do it like this:
mysqlfrm --diagnostic "C:/<path_to_frm>/...
- 131
1
vote
2
answers
245
views
Error Code: 1215. Cannot add foreign key constraint
I'm creating a DBSM on Mysql Workbench, but when Itry creating the last table i get an error because it can't add the foreign key, but i can't understand why since the child key has the same data type ...
- 13
1
vote
1
answer
1k
views
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation
Need urgent help on this. We have applied latest sql patches on one of the server (SQL 2014, SP3, CU4) and somehow we were not able to start the SQL due to following error.
Cannot resolve the ...
- 17
5
votes
2
answers
125
views
Does SQL Server 2008 R2 always fail with a severity level 20 error with certain large text manipulation?
When we run this on our SQL Server 2008 R2 instances, it causes a severity 20 error every time. It does not have that issue on our SQL Server 2016 instances.
Query:
DECLARE @v varchar(MAX) = REPLICATE(...
- 1,821
0
votes
0
answers
49
views
MySQL Error 1251 on 5.7.33 - Can't log in
ERROR 1251 (08004): Client does not support authentication protocol requested by server; consider upgrading MySQL client
I have recently imported a backup into a test environment so I can review some ...
- 37
0
votes
1
answer
59
views
Trouble with a query subselect
I am trying to merge 2 large queries together and can't get it to work. I have an almost working query, except I can't get the server to accept the p.products_id in the nested query. Can anyone help ...
- 1
0
votes
1
answer
1k
views
MariaDB why do I get error "Unknown table x in field list" when it does exist (yes, another one!)
Using mariadb 10.4.13-MariaDB but I get the same error in a copy of the database running under 10.3.
The important part of the schema shows
/*Database: mamlocal*/
----------------------
/*Table ...
- 209