Questions tagged [errors]

For questions about specific error codes or messages, including troubleshooting.

Filter by
Sorted by
Tagged with
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 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 #...
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 ...
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 ...
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 ...
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 ...
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 --...
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, ...
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 ...
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 ...
-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 ...
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 ...
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 ...
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>/...
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 ...
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 ...

1
2 3 4 5
9