Questions tagged [errors]

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

Filter by
Sorted by
Tagged with
1
vote
0answers
12 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, ...
0
votes
0answers
12 views

WAMPSERVER: it doesn't recognize mysql [closed]

I'm having trouble with Wampserver. I installed it and it came with MariaDB as standard and not with MySQL. The problem is that when I go to Options and "Allow MySql" it shows a window that there ...
1
vote
2answers
41 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
54 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
31 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
48 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
156 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
37 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
121 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
677 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
37 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
51 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
35 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
139 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
37 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
347 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
24 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
245 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
129 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
683 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
826 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
56 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
45 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
45 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
67 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
197 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
668 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....
2
votes
2answers
268 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
1k 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
2k 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
135 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
366 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
617 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
1k 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
62 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
41 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
1k 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
66 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
24 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
1k 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
1k 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
24 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
412 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
140 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
176 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
1answer
3k 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 ...

1
2 3 4 5
7