Questions tagged [errors]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
15 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
15 views

Mysql on Ubuntu crashing periodically

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
14 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?
-1
votes
0answers
14 views

ERROR: missing data for column when using COPY FROM PROGRAM in psql

i'm trying to import the data from a cURL with the next command in psql: COPY testtable FROM PROGRAM 'curl https://.....' This is the data in the URL: [{"date":"20201006T120000Z",&...
3
votes
3answers
151 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
29 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
39 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
12 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
67 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
23 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
43 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
21 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
23 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
33 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
26 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
49 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
91 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
34 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
48 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
100 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
17 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
111 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
42 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
31 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
52 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
33 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
226 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
56 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
42 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
19 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
41 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
356 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
38 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
10 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
48 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 ...
2
votes
2answers
374 views

42702 'column reference “id” is ambiguous' for RETURNING of table-returning PL/pgSQL function

This works: CREATE OR REPLACE FUNCTION sql_fun() RETURNS TABLE (id UUID) AS $$ INSERT INTO foo DEFAULT VALUES RETURNING id $$ LANGUAGE SQL; SELECT * FROM sql_fun(); This doesn't: CREATE OR ...
0
votes
0answers
304 views

ORA-12560: TNS:protocol adapter error in Windows 10

Listener and service are up and running. In SQL Plus, if I connect with no login, and execute 'conn sys/pwd@host:port/sid as sysdba', connection is established successfully. But if I connect / as ...
5
votes
3answers
556 views

how to solve this warning in select

I have a problem with this query: SELECT * FROM Sales.SalesOrderDetail sod JOIN Sales.SalesOrderHeader soh ON sod.SalesOrderID = soh.SalesOrderID--- adventureworks db Warnings Type conversion ...
0
votes
0answers
56 views

WAL Archival not working in PostgreSQL V9.4.9 DB server

Our DB servers are on VM, during planned server restart for system patch deployment our Master DB server crashed. We have taken the clone of Primary Slave VM and restore the Master DB using last ...
0
votes
1answer
51 views

Trying to Count Multiple Columns SQL

I'm trying to count multiple columns in a select statement for a class I'm in. Everything is coming from the same table. I want to know how many times that person paid something and how many times ...
0
votes
2answers
96 views

need help understanding the error-message: Error Connecting to database FATAL : no pg_hba.conf entry

We're trying to connect to a postgres/postgis installation on a remote server, using QGIS-Application. When accessing from another pc or from the same pc via pgadmin4v4 with the same credential/...
1
vote
0answers
70 views

Error 17807, Severity: 020 - error source identification

I have setup an alert to notify me on high severity errors. Irregularly, from time to time an error occurs: "Error 17807, Severity: 020, Description: Event '31', which was received from the client, ...
1
vote
2answers
177 views

mysql error code 1292

We are running kea DHCP server with MySQL DB and today we encounter following error and after googling everyone saying it could be MySQL bug so wanted to see if it's really a bug or implementation ...
1
vote
1answer
264 views

54001 stack depth limit exceeded in recursive stable function [closed]

I have a function which calls itself to resolve a hierarchy. Without any volatility declaration, it gives me the desired result (that means the recursion ends). As a performance optimization, I ...
-2
votes
2answers
36 views

Inner Join on 3 tables SQL server 2017 [duplicate]

I have three tables 1. Ordertable 2. Bill 3. Customers In Ordertable I have following columns (*) represents Primary key here | Customer ID*c| Customer Name | Address | Contact Number | ...

1
2 3 4 5
8