Questions tagged [errors]
For questions about specific error codes or messages, including troubleshooting.
329
questions
1
vote
1answer
32 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
29 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
24 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
1answer
70 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
0answers
63 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
35 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
vote
0answers
67 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 ...
1
vote
1answer
257 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]...
0
votes
1answer
31 views
Alter on huge table consumes all disk space
I'm running MySQL 8 on Ubuntu 19. I have a table that is 543G and I have to add a new column and index. I've started with the new column:
alter table hugeTable add column newCol tinyint(1) after ...
0
votes
1answer
41 views
Unable to alter table - reason code is 10
I'm trying to run this:
ALTER TABLE AMMLIBT.SAGRPPF ADD UNIQUE (ID) ADD CHECK ( IS_BUDGETABLE IN ( 0 , 1 )) ;
Which gives me this:
SQL State: 55019
Vendor Code: -7008
Message: [SQL7008] ...
0
votes
0answers
27 views
Exit code 500 when importing a csv file in a table in pgAdmin4
I tried to import a CSV file with the method described here after creating my database with the method described there. However, it returned me a 500 Error.
The command is:
"C:\\Program Files (x86)\...
-1
votes
1answer
54 views
#1005 - Can't create table `fasflixdbp5`.`employee` (errno: 150 “Foreign key constraint is incorrectly formed”) error with employee table
DROP TABLE IF EXISTS Trans;
DROP TABLE IF EXISTS Location;
DROP TABLE IF EXISTS Employee;
DROP TABLE IF EXISTS Movie;
DROP TABLE IF EXISTS VideoGame;
DROP TABLE IF EXISTS Customer;
DROP TABLE IF ...
1
vote
0answers
33 views
SSMS Connect to remote SQL instance with Windows Authentication
I have a remote SQL instance
(Microsoft SQL Server 2016 (SP2-CU3) (KB4458871) - 13.0.5216.0 (X64)
I can connect to the instance fine locally on the box through SSMS using both Windows and SQL ...
0
votes
1answer
177 views
MariaDB 'You do not have privileges to manipulate with the users!' [duplicate]
Apache/2.4.41
PHP 7.3.9
Windows 10 64bit
I have been using XAMPP without issue for months now, and this morning when I turned on my PC adn tried to accedd my databases via HeidiSQL I received some ...
1
vote
1answer
23 views
Microsoft SQL 2016 database for Malwarebytes Endpoint Protection
I don't know if this is the correct forum, but hopefully someone can help.
I am a newly promoted entry level Systems Administrator and the first project I was tasked with was to spin up a new server ...
1
vote
2answers
155 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'
)
...
-1
votes
1answer
60 views
snapshot too old : roll back segment number with name too small error doubt
recently, i have been facing snapshot too old error. So, i tried to understand the why this is happening.
Link to the snapshot too old article
Still, i have some doubts regarding the error.
If i ...
-1
votes
1answer
391 views
errno: 150 “Foreign key constraint is incorrectly formed” [closed]
CREATE TABLE IF NOT EXISTS `Register_Per` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`Name` varchar(50) NOT NULL,
`DOB` varchar(20) NOT NULL,
`Gender` CHARACTER(8) NOT NULL,
`ConNo` int(11) NOT NULL ...
0
votes
0answers
358 views
SSRS 2016 : HTTP Error 503. The service is unavailable
We have SSRS 2016 on Windows Server 2016.
Reporting Server configured with virtual directories
http://ServerName:80/Reports
http://ServerName:80/ReportServer
While I'm trying to connect to reports ...
1
vote
1answer
46 views
Trying to trace error in Stored Procedure using XEvents
Here is the situation:
I have a SQL server ETL application with a stored procedure that is inserting/updating some data into a table. The table has 1 INT column (it is an identity column and there ...
0
votes
0answers
43 views
Failing on queries with length of multiples of 32
tl;dr: Every SQL query of length 64 or higher that is a multiple of 32 results in the connection closing with a 2013 error when interacting with our remote MySQL server.
I am having the strangest ...
0
votes
1answer
32 views
Create View giving SQL7029
If relevant, I'm using IBM i V7R1M0.
I have some code in C#:
var generateSqlSql = $@"
CALL QSYS2.GENERATE_SQL(
'{obj.Name}',
'{obj.Library}',
'VIEW',
CREATE_OR_REPLACE_OPTION => '...
0
votes
0answers
38 views
How to recover from a segmentation fault
Postgresql 11 running on a Centros RHEL 7.
Suddenly BD crashed and service went down.
service postgresql-11.service status
Redirecting to /bin/systemctl status postgresql-11.service
Segmentation ...
1
vote
2answers
59 views
MS SQL Server Error 18456 after database move [duplicate]
I have a windows service connecting to a SQL database. Recently, I was told to change the DB name in the connection string, all else was the same. When I attempted to connect, it threw Error 18456. ...
0
votes
0answers
154 views
One database on my MS SQL Server wont start OS error: 5(Access is denied.)
I am running MS-SQL server for Linux. There are several databases on this machine, but one of them refuses to start up. The error log shows:
2019-07-30 16:29:36.76 spid19s SQL Server is now ready ...
1
vote
1answer
345 views
max_stack_depth error in postgresql
I am fairly new to PostgreSQL and would appreciate any help and recommendations.
I'm running the following function to update a table:
$BODY$
DECLARE
commercial_period date := (SELECT periods....
1
vote
2answers
182 views
Db2 REORGCHK returns the SQL2310N (Error “-668”) message
I have a Db2 database on my Linux laptop. The database is not heavily loaded. I access it from time to time for the development purposes.
I removed a column:
db2 "alter table SCHEMA.TABLE drop ...
0
votes
0answers
658 views
Unable to open BCP host data-file
Having an issue with exporting files to a network drive via the BCP host data file.
There is no problem in exporting a file to the C drive of the machine that the SQL Server is installed on, however ...
1
vote
1answer
1k views
Msg 8114, Level 16, State 5, Line 1 Error converting data type nvarchar to float
I created some select statements which run without any problem in SQL Server. Then I joined them together with UNION and got this error message>
Msg 8114, Level 16, State 5, Line 1 Error ...
1
vote
2answers
107 views
Error 1005 when Forward Engineering EER diagram
I have created an EER diagram (as shown in the image bellow) in MySQL Workbench and wanted to Forward Engineer to build the DB.
After configuring the model options to the Target MySQL Version and ...
0
votes
1answer
325 views
What does HY stand for in error code?
I've seen those error codes with prefix HY like HYT00 in MS-SQL or HY000 in MySQL, but, what do they stand for? why are they similar?
1
vote
0answers
401 views
Slave I/O for channel error connecting to master Error_code: 2003
i am trying a master master replication mysql with phpmyadmin using wamp server.
everything seems to be fine, the configuration was well done, so the server is slave and master at the same time ,
but ...
0
votes
0answers
807 views
ERROR 3680 (HY000): Failed to create schema directory 'wwww' (errno: 2 - No such file or directory)
I'm trying to create a database using MySQL but getting an error message as follows:
mysql> create database XXX
-> ;
ERROR 3680 (HY000): failed to create schema directory 'XXX' (errno: 2 - ...
2
votes
0answers
25 views
DAC silently swallows tokenization errors in sp_msforeachdb
This morning I hopped on the DAC to check something out. Oops, I made a typo!
1> exec sp_msforeachdb N'
2~ use [?]
3~ select N'?', count(*) from sys.sysrscols;
4~ '
5> go
1>
Can you spot ...
0
votes
0answers
50 views
error while restoring database from mysql: ERROR 1006 (HY000)
I made a mysqldump from all my databases prior to fully deinstall and reinstall MariaDB. while restoring the databases with the following command, logged in as root:
MySQL -u root -p < /mnt/...
0
votes
1answer
37 views
change master to cause 1364
ip addr|grep inet
inet 192.168.8.47/24 brd 192.168.8.255 scope global ec1
inet 192.168.8.45/24 brd 192.168.8.255 scope global secondary ec1:1
I got like this
mysql> show slave status\G;
******...
0
votes
1answer
996 views
“Cannot drop index 'unique_token_data': needed in a foreign key constraint” in MySQL without a foreign key
When I try to remove a unique index, MySQL Ver 5.7.26-0ubuntu0.19.04.1 says that it is needed in a foreign key constraint:
mysql> ALTER TABLE project_erc20token DROP INDEX unique_token_data;
ERROR ...
1
vote
0answers
46 views
Mongodb throwing an error when I run the query to record last position from oplog
I am getting an error when I run the query in the secondary member to record the last position from the oplog.
below is the query.
db.oplog.rs.find().sort({$natural:-1}).limit(1).next().ts
and the ...
0
votes
0answers
22 views
HANA Catalog Import Issue
I'm trying to import a data dump from HANA Enterprise to HANA Express (VM). I use the web-based DB browser.
Having created the a tenant with the same name as my source DB, I'm trying to 'Import ...
0
votes
0answers
843 views
How to resolve an SQL Server “Target principal name is incorrect” error invoked after upgrading from SQL Server 2016 to 2017?
I am experiencing a "Target principal name is incorrect" error after upgrading SQL Server 2016 to 2017. The SQL Server 2016 instance has been uninstalled. The certificate which is registered in SQL ...
3
votes
4answers
861 views
I don't know how to fix ORA-04091 mutating trigger error
I'm learning Oracle SQL, but when dealing with triggers I'm finding an error, that prevents me from updating values in that table.
The error is:
error ORA-04091: table USUARIO.LINEAS is mutating, ...
1
vote
1answer
21 views
What is the permission necessary to drop a service in service-broker?
When I want to drop a service which is already created, this error happens:
Msg 15151, Level 16, State 1, Line 316
Cannot drop the service '//Audit/Contract', because it does not exist or you do not ...
0
votes
2answers
337 views
SSAS Tabular model table load from query with #temp table fails
We have several situations where complex queries are being used for creating/populating tables in our SSAS tabular model.
The actual use cases cannot be presented here, due to both proprietary ...
0
votes
1answer
102 views
ON CONFLICT ON CONSTRAINT fail postgresql
INSERT INTO O_USER (ID, NAME, LASTNAME, EMAIL, USERNAME, PASSWD, DATE_REG, DATE_UPD, DATE_DEL, IS_DELETE, TIPO, FTP)
VALUES (%s,%s,%s,%s,%s,%s,DEFAULT,NULL,NULL,%s,%s,%s)
ON CONFLICT ON CONSTRAINT ...
0
votes
1answer
144 views
CONCAT_WS causes “Data too long” which works partially?
I've got a simple table with several columns and I'm trying to merge two of them into one. I'm working with MySQL 5.5 and I can reproduce the error one a specific data set by running the following (...
0
votes
0answers
40 views
cannot have more than 2^32-1 subtransactions in a transaction
I'm trying to run this but after 10 hours I get the error "cannot have more than 2^32-1 subtransactions in a transaction". What is your advice for getting around this issue? I'm hesitant to split up ...
0
votes
0answers
307 views
MySQL Error 1032 “Can't find record in table”
I'm getting MySQL 1032 "Can't find record in 'person'" errors for some queries in my database, and I cannot resolve them.
Here's the table:
CREATE TABLE `person` (
`id` int(11) NOT NULL ...
0
votes
1answer
2k views
Unable to install SQL Server Management Studio (SSMS) on server
We are experiencing persistent errors when attempting to install SSMS on one of our development database servers. We have tried the installers for versions 17.4 and 17.9.1, but the error messages are ...
5
votes
0answers
352 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 ...
