Questions tagged [errors]
For questions about specific error codes or messages, including troubleshooting.
410
questions
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 ...
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 ...
-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,
...
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
...
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 ...
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 ...
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 ...
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 --...
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,
@...
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 ...
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,
...
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 ...
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 ...
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 ...
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 ...
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 ...
-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 ...
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)...
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.
...
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 ...
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
...
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
;
...
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 ...
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 ...
-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
...
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 ...
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 ...
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 ...
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
...
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 ...
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 ...
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 ...
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,...
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>/...
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 ...
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 ...
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(...
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 ...
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 ...
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 ...
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 ...
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 ...
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 (...
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 ...
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.
...
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
...
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 ...
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 ...
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] ...
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 ...