Questions tagged [errors]

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

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

1
2 3 4 5
8