Questions tagged [errors]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
22 views

Is my office's firewall preventing MSSQL server login?

As far as I'm aware, I have the correct server name (format of machine\instance), but I am incapable of connecting to the server when opening SSMS. I have read varying troubleshooting threads, and one ...
0
votes
0answers
5 views

click any database get error :- #1932 - Table 'ass_test.reg' doesn't exist in engine

HELLO, In phpmyadmin click any database show error :- #1932 - Table 'ass_test.reg' doesn't exist in engine how to solve this error. Please help me. THANKS.
0
votes
2answers
30 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(...
0
votes
0answers
68 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
2answers
55 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
0answers
41 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 ...
5
votes
3answers
547 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 ...
0
votes
0answers
24 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 ...
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 ...
0
votes
2answers
24 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
36 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
60 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
94 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
33 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
120 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
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
0answers
334 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
39 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
213 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
838 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
41 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
70 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] SAGRPPF in ...
0
votes
0answers
61 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
218 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
39 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
516 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
26 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
362 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
259 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
1k 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
1k 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
83 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
44 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
57 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
50 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
77 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
253 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
1k 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
360 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
3k 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
182 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
385 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
911 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
67 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
43 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; ******...

1
2 3 4 5
7