Questions tagged [errors]
For questions about specific error codes or messages, including troubleshooting.
370
questions
0
votes
1answer
26 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 ...
1
vote
2answers
551 views
java.sql.SQLException: ORA-01410: invalid ROWID
I am getting java.sql.SQLException: ORA-01410: invalid ROWID for some of the rows.
Here is my query.
"select OP.PLU_LONG PROD_ID," +
"OP.NEW_PRICE PRICE," +
...
0
votes
1answer
18 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] ...
0
votes
1answer
1k views
Error: 9245, Severity: 16, State: 1. / “During the last time interval X query notification errors were suppressed”
We are receiving this notification several hundred times a day and while we're regularly checking notifications from Severity 16 errors, this isn't something we're really concerned about.
I've read ...
2
votes
1answer
284 views
Cosmos DB ODBC driver installation problem
We are trying to install Cosmos DB ODBC Driver following the instructions provided in this Microsoft Azure resource and are running into the following error:
The setup routines for Microsoft ...
0
votes
1answer
92 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
1answer
359 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, ...
3
votes
3answers
152 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 ...
1
vote
0answers
16 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?
0
votes
1answer
101 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 ...
-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",&...
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 ...
1
vote
2answers
457 views
RDS Replication Error (Apply Error 1406 / Truncation)
I have a MySQL RDS instance as a master, created a Read Replica from it, and ran some schema change operations on it. To be specific, I changed the charset and collation of all the tables and columns ...
1
vote
1answer
384 views
MongoDB 3.2.10 Index rebuilding did not complete: 11000 E11000 duplicate key error collection
MongoDB 3.2.10
Getting the following error when adding a replica set as WiredTiger. This is sharded cluster ( 3 shards nodes ).
2 Shards replica sets created using wiredTiger storage so only 1 shard ...
0
votes
1answer
474 views
How to configure mongodb replicaset of 3 nodes in authentication mode
I had configured a mongodb replicaSet of 3 nodes. It was running fine But WHen i created a adminUser and dbuser on primary node and enabled the authorization in mongodb.conf file of all nodes then ...
0
votes
0answers
41 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 ...
7
votes
3answers
8k views
PostgreSQL 9.3.13, How do I refresh Materialised Views with different users?
[I think the root cause of this problem is me not understanding permissions and privileges...]
So, to set the stage, the set up I have is a DB, call it MyDb.
I have two users, spu1 and u1, spu1 is a ...
0
votes
1answer
502 views
How To Prevent Replication Failure
If I become a MySQL DBA, will I had to deal all day with those kind of issues or do you have tips to prevent from breaking the whole replication?
I received this message because I removed manually ...
9
votes
11answers
101k views
Error: Cannot Generate SSPI context
When someone tries to connect to a SQL Server instance, the error shows up:
It's not possible do generate SSPI context.
Yesterday we had a blackout (don't know how to say this expression in ...
1
vote
1answer
840 views
MySQL: Skip INSERT / UPDATE statement that triggers error but show them in output
I have a million of rows of customers to be imported via SQL dump. Customer data will be inserted into main table customer and child table customer_address
The dump contains the following SQL ...
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
69 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
109 views
A AFTER INSERT trigger error for security context
A trigger has stopped working since we have changed our SQL Server to a new server. Trigger is now being corrected to point to the new location of the table on the new server. When updating fields on ...
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 ...
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 ...
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 ...
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. ...
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 ...
0
votes
2answers
228 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 ...
3
votes
1answer
1k views
MySQL: error 1118 (42000) row size too large
storage_engine = MyISAM
table_type = MyISAM
version = 5.1.25-rc
database_name.sql dump size is 3.3G:
mysqldump -u user -p database_name > database_name.sql
When I try to restore the database (...
5
votes
1answer
943 views
How do I identify the source of the 17886 errors (“server will drop the connection”) in my SQL errorlog?
I have a SQL 2012 server that is throwing the following error every 5 minutes or so:
Error: 17886, Severity: 20, State: 1.
The server will drop the connection, because the client driver has sent ...
2
votes
3answers
11k views
configure: error: SQLite3 library not found
I'm getting the below configure error while doing the install the Zabbix reporting tool on Linux.
i have tried both Versions(zabbix-2.0.9,zabbix-1.8.17), but getting same issue.
Log:
checking for ...
21
votes
3answers
57k views
The number of row value expressions in the INSERT statement exceeds the maximum allowed number of 1000 row values
One of INSERT INTO script is written as following.
INSERT INTO tableName (Column1, Column2,....) VALUES (value1, Value2,...), (value1, Value2,...),....
Following is the error we are facing on ...
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 = ...
20
votes
3answers
35k views
How do I resolve this error, “ERROR 1298 (HY000): Unknown or incorrect time zone: 'UTC'”?
When I run the following command I get an error, however one of my scripts requires it.
SET time_zone = 'UTC';
ERROR 1298 (HY000): Unknown or incorrect time zone: 'UTC'
3
votes
1answer
951 views
Incorrect key file for table error. How can I change location of MySQL's temp folder to another part of drive with more disk space?
I am using MySQL with Sequel Pro on a Mac Pro OSX Mavericks and am trying to run the code for a stored procedure in order to add two new columns to a table. The procedure does math operations on ...
24
votes
8answers
105k views
Login failed for user - Error 18456 - Severity 14, State 38
Message that SQL Server Log File Viewer shows:
Login failed for user [User]
Error: 18456, Severity: 14, State 38
What it actually means:
Failed to open the explicitly specified database
My ...
0
votes
1answer
75 views
LOAD DATA statement returns a syntax error a fraction of the time
MySQL 5.5.32, MyISAM
A LOAD DATA INFILE statement usually executes and returns normally, succeeding at loading the data. On rare occasion it fails, returning a generic syntax error, always indicating ...
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
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 "...
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
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 ...
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(...
4
votes
3answers
64k views
mysql update query error Code 1054 unknown column in field list
Error: Code 1054. Unknown column 'U2.id_naslov' in 'field list' gets thrown on
this simple query in MySQL Workbench:
UPDATE krneki_1 AS U1, krneki_2 AS U2
SET U1.id_naslov = U2.id_naslov
WHERE (U2....
19
votes
3answers
24k views
Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade
In mysqld.log I have thousands of lines like:
Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade
So, according to virtually every post on the ...
0
votes
1answer
467 views
Mariadb Galera cluster empty set
I am playing around with a MariaDB Galera Master Master Cluster and I have some issues which I do not understand.
[mysqld]
bind-address=0.0.0.0
[galera]
wsrep_on=ON
wsrep_provider=/usr/lib64/galera/...
0
votes
1answer
1k views
Determine cause of “MySQL server has gone away”
I've got a long running process on a headless server. It is a C program that monitors a modem for Caller Id and hangs up on telemarketers. On startup the program opens a connection to a MariaDB 10.3 ...
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
112 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 ...
