Questions tagged [errors]
For questions about specific error codes or messages, including troubleshooting.
335
questions
0
votes
2answers
26 views
Why is there “no unique constraint” error for primary keys? [closed]
I have following table:
create table tbl (id_p int, id_c int, primary key (id_p, id_c));
I want to create a new table:
create table tbl_tbl (id_p int references tbl(id_p), id_c int references tbl(...
1
vote
2answers
347 views
`CHANGE_TRACKING = AUTO` fails to populate full-text index
I have created full-text indexes on tables with the following options (simplified):
CREATE FULLTEXT INDEX ON [schema].[table]
(
ColumnA Language 'English',
ColumnB Language 'English'
)
...
0
votes
1answer
399 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
908 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 ...
0
votes
1answer
944 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
48 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
39 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
vote
1answer
439 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," +
...
2
votes
1answer
276 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 ...
11
votes
3answers
3k views
SQL Server on Linux hangs on initial startup, no errors, and no new / updated ErrorLog file
I'm using SQL Server 2017, Release Candidate 2 (RC2) on Linux (Ubuntu 16.04).
When the server starts up, SQL Server usually starts as well. But for some reason, SQL Server won't start anymore. At ...
1
vote
1answer
512 views
SQL Server crash with Reason 0x00000006 after a while on linux
Environment
OS
Ubuntu 16.04 x86_64 (also happening on Windows)
DB
SQL Server 2017 with FullText Search module (mssql-server and mssql-server-fts packages)
Problem
The issue that I'm facing is ...
5
votes
3answers
545 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 ...
4
votes
2answers
19k views
Get ORA-01157 when startup database
I created a datafile /tmp/encrypted_ts.dbf. When the machine started again, the datafile was gone. When I started it I got ORA-01157, the details are:
ORA-01157: cannot identify/lock data file 54 - ...
1
vote
2answers
49 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
1answer
442 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 ...
8
votes
9answers
79k 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
353 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
0answers
38 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 ...
9
votes
2answers
3k views
Getting SQLSTATE in psql error messages
I have the following problem.
SELECT * FROM tgvbn();
ERROR: function tgvbn() does not exist
LINE 1: SELECT * FROM tgvbn();
^
HINT: No function matches the given name and ...
1
vote
2answers
410 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 ...
0
votes
1answer
478 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 ...
1
vote
1answer
771 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
0answers
23 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 ...
1
vote
1answer
207 views
Unable to view SQL Server services
Whenever I enter SQL Server Configuration Manager and choose SQL Server Services I would always get the following error message: "The remote Procedure call failed. [0x800706be]"
everything else works ...
0
votes
1answer
101 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 ...
15
votes
3answers
17k 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 ...
2
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 (...
0
votes
1answer
21 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 ...
3
votes
1answer
816 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 ...
0
votes
2answers
23 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
35 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
58 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 ...
3
votes
2answers
2k views
This installation of MySQL is already upgraded to 5.7.25?
I used sudo apt upgrade and got this:
E: dpkg was interrupted, you must manually run 'sudo dpkg --configure -a' to correct the problem.
So I did it and I see this for more than an hour.
Setting up ...
1
vote
1answer
833 views
XAMPP - Error: MySQL shutdown unexpectedly
Last night MySQL Service on my XAMPP local server was running fine. Today... it starts for 10 seconds and then give me following error:
10:14:28 AM [main] Initializing Modules
10:14:28 AM [main]...
2
votes
2answers
12k views
Strange MySQL replication error 1146 (Table doesn't exist)
I'm getting a very weird MySQL replication error No. 1146 for a REPLACE INTO query on a slave host replicating all tables in all databases from a master, and I'm having a bit of a hard time ...
20
votes
3answers
50k 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
635 views
SSIS OnError propagating when it shouldn't
I have an SSIS package with a data flow task that uses a script component as its data source. The script component retrieves its data from a web service. The call to the web service sometimes fails, ...
2
votes
1answer
3k views
Error Msg 10314, Level 16, State 11 with SAFE assembly after upgrade to SQL Server 2017
I have a pre-SQL Server 2017 database that I restored into / upgraded to SQL Server 2017. In this database I have a SQLCLR Assembly. The Assembly is marked as SAFE since it doesn't do anything ...
1
vote
1answer
91 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
32 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
votes
1answer
114 views
When creating a FOREIGN KEY constraint, get “ERROR: column ”xyz“ referenced in foreign key constraint does not exist” [closed]
I keep getting this error in my psql database;
bikefacility=# ERROR: syntax error at or near "c"
bikefacility-# LINE 1: c
bikefacility-# ^
bikefacility-# bikefacility=# ALTER TABLE bicycle ...
0
votes
1answer
24 views
Everything is ok and x is not disappearing
Since some time ago, I've started with MySQL so I don't know Workbench very well.
That little red x next to the number of the line that indicates an error does not disappear, even though everything ...
0
votes
0answers
319 views
Troubleshoot MS DTC error
I've been getting these two errors on SQL Server log:
Error 1:
DESCRIPTION: Import of Microsoft Distributed Transaction
Coordinator (MS DTC) transaction failed:
0x8004d00e(...
0
votes
1answer
72 views
Why does this query work with a CTE, but not with a derived table? [closed]
I was looking to identify the 'Email' that was duplicated.
The two simplest ways I thought of are shown below, however for some reason the query using the derived table produces the error: Incorrect ...
0
votes
1answer
38 views
ms-access concat a string with control source
Sorry for this likely noob question but I cannot seem to find the solution. I'm trying to modify an existing field on a report, standard in this field the data is being pulled from the control source ...
-1
votes
1answer
1k views
Workbench Error Code 1267 - utf8_unicode and utf8_general
I've recently just swapped all of a databases tables and columns to utf8_unicode_ci from the weird collection of about 3-5 different collations they were previously (don't ask... not my database)
So, ...
4
votes
2answers
30k views
Failure Of Backup Due To Limit Exceeded For Recovery Files Since Cannot Reclaim Disk Space [RMAN-03009,ORA-19809,ORA-19804]
While I try to take incremental backup level 0 by using the command
RMAN> backup incremental level 0 database plus archivelog;
, encountered this error.
RMAN-00571: ==============================...
3
votes
1answer
208 views
Implicit conversion causing error part of the time
I have been scratching my head about this one for the last day or so - I just can't see why a procedure works in one environment, but then fails in another due to a conversion error (same data, same ...
1
vote
0answers
211 views
database mirror - A connection attempt failed because the connected party did not properly respond after a period of time
I have database mirror set up in one of my servers and all seems to be fine, however, from time to time I get this error message in the logs:
--Execute it on Primary/Secondary server
EXEC ...
3
votes
1answer
190 views
UPDATE statement processing records that should be eliminated by WHERE clause
I am getting a very odd error. Consider the table below:
CREATE TABLE #MyTable (
Key1 INT , Key2 INT ,
x SMALLINT , y INT , z INT ,
a FLOAT , b FLOAT , c SMALLINT , s FLOAT
)
-- insert ...
