Questions tagged [errors]

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

Filter by
Sorted by
Tagged with
0 votes
1 answer
59 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 ...
user avatar
  • 501
0 votes
0 answers
29 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 ...
user avatar
  • 11
-4 votes
1 answer
51 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, ...
user avatar
0 votes
1 answer
22 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 ...
user avatar
  • 255
0 votes
1 answer
65 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 ...
user avatar
0 votes
0 answers
93 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 ...
user avatar
0 votes
1 answer
28 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 ...
user avatar
0 votes
0 answers
19 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 --...
user avatar
1 vote
1 answer
102 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, @...
user avatar
  • 1,450
0 votes
0 answers
28 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 ...
user avatar
  • 1
0 votes
1 answer
21 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, ...
user avatar
0 votes
1 answer
262 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 ...
user avatar
0 votes
1 answer
191 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 ...
user avatar
0 votes
1 answer
248 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 ...
user avatar
0 votes
1 answer
634 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 ...
user avatar
  • 33
0 votes
1 answer
392 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 ...
user avatar
-3 votes
1 answer
298 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 ...
user avatar
2 votes
1 answer
175 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)...
user avatar
  • 24.2k
0 votes
0 answers
55 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. ...
user avatar
1 vote
1 answer
92 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 ...
user avatar
0 votes
1 answer
394 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 ...
user avatar
  • 13
1 vote
1 answer
61 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 ; ...
user avatar
  • 169
1 vote
0 answers
103 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 ...
user avatar
0 votes
0 answers
30 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 ...
user avatar
-1 votes
2 answers
39 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 ...
user avatar
2 votes
2 answers
203 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 ...
user avatar
3 votes
2 answers
217 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 ...
user avatar
  • 141
0 votes
1 answer
191 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 ...
user avatar
1 vote
1 answer
452 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 ...
user avatar
  • 11
0 votes
0 answers
117 views

Invalid Urn filter on server level SQL Server error

I am trying to alter permissions to some of my users using GUI. When I press Script Out or OK, I am receiving this error attached. Has anyone experienced this error and what did you to resolve this ...
user avatar
0 votes
1 answer
382 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 ...
user avatar
0 votes
2 answers
617 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 ...
user avatar
1 vote
1 answer
724 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,...
user avatar
  • 111
0 votes
1 answer
540 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>/...
user avatar
1 vote
2 answers
189 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 ...
user avatar
  • 13
1 vote
1 answer
902 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 ...
user avatar
  • 17
5 votes
2 answers
122 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(...
user avatar
  • 1,791
0 votes
0 answers
23 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 ...
user avatar
  • 37
0 votes
1 answer
52 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 ...
user avatar
0 votes
1 answer
692 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 ...
user avatar
0 votes
1 answer
53 views

Repairing buggy query server-side – without changes in the app

More external apps are accessing our ERP SW database. As we were adding some columns into our structure, some queries from the external app become buggy because they are not specifying the targeted ...
user avatar
  • 935
9 votes
5 answers
3k views

Linked Server connection started failing with "Cannot generate SSPI context ... SQL Server Network Interfaces: The logon attempt failed" error?

The Issue I have two SQL Server 2016 Standard Edition servers on the same domain. ServerA has two linked server connections setup to ServerB. The first linked server connection is using a dedicated ...
user avatar
  • 24.2k
0 votes
1 answer
30 views

Understand responsibilities of database and backend

Still learning, but there is something I can't understand. Some features of MySQL seem (to me) to flow on the responsibilities of the backend. In particular, I'm talking about data validation (...
user avatar
  • 115
0 votes
0 answers
65 views

Oracle 17410(connection reset) when using count(*) on cross join cte with json_table

Met strange behavior using query with json_table in cte at oracle - connection reset from server, without details. Illustrating artificial query is: with data as ( select 5 as some_value from ...
user avatar
0 votes
0 answers
195 views

ORA-7445 kills PMON instance

I restored an Oracle 12.1.0.2 database using RMAN full backup from a RAC+ASM enviroment to single instance enviroment with less memory and cpu (for test purposes) using this document Doc ID 1338193.1. ...
user avatar
  • 3
0 votes
0 answers
34 views

SQL Server 2019 unable to install error [duplicate]

When installing SQL server 2019 receiving installation error. Error log Overall summary: Final result: Failed: see details below Exit code (Decimal): -2068052377 ...
user avatar
0 votes
0 answers
284 views

Got timeout reading communication packets

I am trying to create a ssh tunnel to my production database /usr/sbin/mysqld Ver 8.0.23-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu)). When using my ssh-tunnel I get in my mysql error log file ...
user avatar
  • 135
0 votes
1 answer
8k views

The pgAdmin 4 server could not be contacted

Whenever I install PostgreSQL, it stops working after about 6 months. This is the second time this happened! Last time this happened, I uninstalled and then installed version 4.29. How can I debug ...
user avatar
  • 1,995
0 votes
1 answer
193 views

Mysql on Ubuntu crashing periodically [duplicate]

I have a problem with Mysql on my ubuntu server. it is restarting periodically about 4-5 times a day . Here is the logs that I found in /var/log/mysql/error.log: 2021-02-23T08:35:08.249856Z 18 [Note] ...
user avatar
3 votes
3 answers
194 views

Error 297, Severity 19 trying to create new table as sysadmin

I am completely scratching my head right now. I have two database instances that I am trying to add a table to, and both give me the same error: The user does not have permission to perform this ...
user avatar
  • 93

1
2 3 4 5
9