Questions tagged [errors]

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

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

1
2 3 4 5
8