Questions tagged [errors]
For questions about specific error codes or messages, including troubleshooting.
380
questions
0
votes
0answers
6 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
0answers
24 views
Trouble with a query subselect
I am basically 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. Using ...
0
votes
1answer
12 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
0answers
19 views
how to get precise locations of syntax errors in a .sql script?
I'm trying to execute a .sql script which inserts values into a database.
Problem is, there's some issues in the syntax of the script.
Error Code: 1064. You have an error in your SQL syntax; check the ...
0
votes
1answer
50 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 ...
6
votes
5answers
286 views
Linked Server connection started failing with “Cannot generate SSPI context … SQL Server Network Interfaces: The logon attempt failed” error?
UPDATE 10: The original question and previous updates follow this update below (and will soon be cleaned up into one current update).
Last week be broke the clusters, and now everything is truly a ...
0
votes
1answer
21 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
0answers
40 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
0answers
22 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
0answers
31 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
0answers
56 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
1answer
192 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
1answer
37 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] ...
1
vote
0answers
288 views
Error run pgAdmin4 Fatal Error: The pgAdmin 4 server could not be contacted
I had installed PostgreSQL 10 and everythings perfect after i install but now i have this issue.
Fatal Error:
The pgAdmin 4 server could not be contacted
anyone know what could be the problem?
3
votes
3answers
157 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 ...
0
votes
0answers
34 views
Linked server anonymous login error
I am trying to access a database in my UAT server through a windows login credential. When I try to access the database, I get the error Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' This ...
0
votes
0answers
81 views
Failed (exit code: 1) when trying to restore DB from a .tar file in pgAdmin4
I'm been trying to restore my database and I'm getting an Exit error code 1. The database I'm trying to restore is SuperMart_DB.tar, but every time I get the same error message.
I have seen previous ...
0
votes
1answer
24 views
MySQL - cannot examine view definition - Error getting DDL for object - No database selected
I have a view that I can run, it returns a dataset, but whenever I try to alter the view or look at its definition, I get
Error getting DDL for object
No database selected
But I do have a database ...
0
votes
1answer
279 views
ora-03114 not connected to oracle
Since the upgrade to the 19C Oracle DB (before 12C) I receive randomly those ORA-03114 error message's.
Before the upgrade I never received it. Any idea's what exactly why those error messages pops up ...
0
votes
1answer
29 views
How to find description of error in error log? [closed]
We have errors like these in our MySQL error log:
[ERROR] [MY-010211] [Server] Got error 203 when reading table 'xxx'
But I can't find anything about either MY-010211 nor error 203 in the ...
4
votes
1answer
61 views
Meaning of precision 1, scale 0 in error message?
What datatype does this error message refer to?
ERROR: numeric field overflow
DETAIL: A field with precision 1, scale 0 must round to an absolute value less than 10^1.
I'm getting the error listed ...
0
votes
0answers
35 views
Full Text Index STOP POPULATION doesn't work, depending on Track Changes setting
I had a Full Text Index population going on for too much time and storage, so I decided to stop it, but the population didn't stop.
Notes:
Both index and catalog are created using the Full Text ...
1
vote
1answer
26 views
Mysql same DB, same query, different users - different error messages
On my AWS RDS Mysql 8.0.16 server I have one DB (my-db) and 2 users: the master user (created automatically by RDS) and an app user created by me:
create user if not exists `appuser`@`%` identified by ...
1
vote
0answers
39 views
Flags Cloud SQL for Postgresql
Context:
I have a process that runs daily, with different amounts of data, if the process is on the weekday (process last 30 days), for weekends (process last year). The input is of 10 tables of ...
0
votes
1answer
30 views
How do you call an external C function from a SQL stored procedure?
In Teradata 17, I am trying to call their own hash_md5 external function from my own SQL stored procedure:
replace procedure p()
sql security creator
begin
declare l_hash varchar(32);
set l_hash = ...
1
vote
3answers
50 views
Not able to install any DB2 LUW 10.5 fixpacks
I am currently on Fixpack 1 and am trying to install ANY more recent fixpack. All of them refuse to apply themselves with similar errors. The one below is from Fixpack 2 file v10.5fp2_ntx64_server. ...
1
vote
1answer
25 views
Why can't I insert an email on a table that has one more dot than an existing one? [closed]
I'm using the official Heroku add-on for PostgreSQL and I have a database running on version 12.4 of PostgreSQL.
I'm facing an issue where on my users table I have an email like this fakeemail@domain....
0
votes
1answer
149 views
The connection is no longer usable because the server response for a previously executed statement was incorrectly formatted
One of our application AX2013 is connecting to our DB's in an Availability group spanning three SQL2016 nodes.
End users are getting some error in the application that always point to the same error ...
0
votes
2answers
45 views
How to add generated column to db2 table?
I've got a table with the following:
Columns:
---
URL [nullable, e.g. "https://dba.stackexchange.com/"]
APPFK [nullable, e.g. 654654]
LINKTYPE ["Page", "Link", or "...
0
votes
1answer
31 views
SQL Server 2019: Rasing errors between 1 and 13000
I've been struggling with a task which requires me to raise a number of errors for testing purposes. Of course the time consuming errors are between 1 and 13000. I've managed to do them, but I need to ...
7
votes
4answers
2k views
What could cause SQL Server to deny execution of a SP at first, but allow it later with no privileges change?
A user (Windows login) just complained he was denied the execution of a procedure. I went to check and verified he had the privileges to execute it. I didn't change anything (and right now I'm the ...
0
votes
1answer
55 views
Learning COMPUTED BY - what right parenthesis does it need? [closed]
I am reading this document on Automatic columns.
The first snippet in it creates a COMPUTED BY column:
create table PERSON (
(employee_id integer,
employee_id_disp computed by
SUBSTRING (CAST(...
0
votes
1answer
157 views
Error using SQL Server 2019 Import and Export Data (64-bit)
I'm getting an error immediately upon starting the SQL Server 2019 Import and Export (64-bit) wizard, and I'm looking for ideas. The error is:
The SSIS Data Flow Task could not be created. Verify ...
0
votes
0answers
22 views
Not able to create a stored procedure for a table insert in DB2 UDB 10.5 [duplicate]
I want to create a very simple stored procedure that will only take several IN parameters and insert them into a table. To learn how to do it, I went to CREATE PROCEDURE (SQL) statement
From that I ...
3
votes
1answer
160 views
SQL Server restarts, unable to find the reason
One of our SQL Server instances restarts itself in a clustered environment, but it is not fail-overed. When I checked the error logs, event viewer and cluster log I'm unable to find any particular ...
2
votes
1answer
70 views
DBCC CheckDB : Operating System Error 27(The drive cannot find the sector requested)
So my regular DBCC check had this lovely message waiting for me in the error logs this morning. I've been trying to find out more about this issue and what can be done about it. Manually running DBCC ...
1
vote
0answers
32 views
Oracle error 43914 in CASE WHEN expression: arguments have undefined collation
I want to know which is the difference between this query:
SELECT *
FROM TEST_TABLE
WHERE CHAR_FIELD = CASE WHEN KEY_FIELD = 'Q' THEN 'M'
ELSE CASE WHEN KEY_FIELD = 'T' THEN 'K' ...
1
vote
1answer
84 views
SQL Server Agent Alerts and Severity Errors
I've setup alerts in SQL Agent for errors of severity level 15-16 for testing, and found out that these are not always triggered
To be more exact, these seem to trigger only when given error number ...
-1
votes
2answers
37 views
How do I make PostgreSQL not log specific errors?
ERROR: deadlock detected at character 13
My PG log is full of this, but the thing is, I already handle it (after years of frustrations) in my application. I detect them and repeat until they go ...
0
votes
2answers
393 views
Error 0xc000007b with Oracle 19c
As our (32-bit) application uses the Oracle client for communication with the Oracle server I have set up a test environment on a Microsoft Windows Server 2019 Datacenter. I have installed the Oracle ...
-2
votes
1answer
81 views
What should I do about PostgreSQL logging so much “weird noise” in its own log?
PostgreSQL 12.4 on Windows 10 Pro 2004.
With the default configuration file, I start PostgreSQL with pg_ctl and the "-l PostgreSQL.txt" option.
It logs to that file. Looking in it, I'm ...
-3
votes
1answer
44 views
Why am I getting errors which cannot logically happen? [duplicate]
I'm ready for the nuthouse at this point. This error makes me want to stab my eyes out after staring at the screen and testing stuff for literally MONTHS now!
The offending code, which looks to me ...
0
votes
0answers
21 views
Mysql falls every day
My database Mysql fallas every day:
Looking at the tail -100 /var/log/mysqld.log
Shows:
2020-08-16 20:56:03 7f787c7fb700 InnoDB: Error (Duplicate key) writing word node to FTS auxiliary index table.
...
0
votes
1answer
45 views
Why am i getting “missing right parenthesis” error when i try to LOG ERRORS when loading from an external table?
I've successfully created an error logging table
BEGIN
DBMS_ERRLOG.create_error_log(
dml_table_name => 'enzyme',
skip_unsupported => TRUE);
END;
/
desc ERR$_ENZYME;
Name ...
10
votes
5answers
1k views
string or binary data would be truncated in table '******', column '******'. Truncated value: '******'
One of our applications report on error message 2628:
string or binary data would be truncated in table '******', column '******'. Truncated value: '******'
instead of
String or binary data would be ...
0
votes
1answer
503 views
Greenplum ERROR: Canceling query because of high VMEM usage
We have a GreenPlum Cluster which we have set up recently and getting this error on a single query run:
current group id is 140611, group memory usage 40720 MB, group shared memory quota is 31320 MB, ...
0
votes
0answers
49 views
Unable to grant privileges with admin account
I'm running MariaDB version 10.4.8 on Amazon RDS. Once the server is up and running, I need to create some databases, users and grant privileges to those users.
Creating the databases and users works ...
0
votes
0answers
14 views
click any database get error :- #1932 - Table 'ass_test.reg' doesn't exist in engine
HELLO,
In phpmyadmin click any database show error :- #1932 - Table 'ass_test.reg' doesn't exist in engine
how to solve this error.
Please help me.
THANKS.
1
vote
0answers
2k views
Persistent problems importing CSV files via pgAdmin 4 to PostgreSQL 12 on Mac OS - Failing with Exit Code -6
I've been trying for several days to import CSV files into a PostgreSQL 12 database hosted on Mac OS 10.15.5, using the Import/Export tool in pgAdmin 4. I am consistently getting an error message ...
1
vote
2answers
57 views
Column name on NOT NULL constaint violation not shown
I'm using an Oracle 19 DB that is structured into multiple layers by using DB users. Here is a simplified overview of the structure:
User DATA: Has the table XTEST and the view TEST. The view is ...
