Questions tagged [errors]
For questions about specific error codes or messages, including troubleshooting.
339
questions
0
votes
1answer
30 views
Why am i getting “missing right parenthesis” error when i try to LOG ERRORS when loading from an external table?
I've successfully created an error logging table
BEGIN
DBMS_ERRLOG.create_error_log(
dml_table_name => 'enzyme',
skip_unsupported => TRUE);
END;
/
desc ERR$_ENZYME;
Name ...
8
votes
4answers
497 views
string or binary data would be truncated in table '******', column '******'. Truncated value: '******'
One of our applications report on error message 2628:
string or binary data would be truncated in table '******', column '******'. Truncated value: '******'
instead of
String or binary data would be ...
-5
votes
0answers
47 views
How to determine what is the potential max worker thread count on a server where the server property is set to 0? [duplicate]
I have a SQL Server instance where the Max Worker Threads server property is set to the default of 0.
Periodically I'm receiving the the following errors (in the SQL Error Log):
Error: 17189, ...
0
votes
0answers
30 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, ...
0
votes
0answers
14 views
Unable to grant privileges with admin account
I'm running MariaDB version 10.4.8 on Amazon RDS. Once the server is up and running, I need to create some databases, users and grant privileges to those users.
Creating the databases and users works ...
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
0answers
85 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
40 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
70 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
51 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
552 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
26 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
22 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
28 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
37 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
80 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
109 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
34 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
149 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
395 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
41 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
239 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
855 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
44 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
77 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
65 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
234 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
537 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
383 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
305 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
89 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
63 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
52 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. ...
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
383 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
4k 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
191 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
388 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
1k 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 ...
