Questions tagged [errors]
For questions about specific error codes or messages, including troubleshooting.
318
questions
0
votes
2answers
217 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 ...
1
vote
0answers
25 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
48 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 ...
0
votes
1answer
757 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
305 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/...
1
vote
1answer
18 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 ...
0
votes
1answer
223 views
ORA-1110, ORA-1114, OSD-4002, O/S-Error: (OS 33) The Process Cannot Access The File
Hi All,
We have a problem today wherein in Oracle we are trying to execute a package (every morning) and this is the only time we encountered the error (ORA-0114).
Any ideas how to fix this? We have ...
2
votes
1answer
246 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 ...
1
vote
1answer
320 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," +
...
1
vote
2answers
93 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
36 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
vote
1answer
307 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 ...
-1
votes
1answer
90 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 ...
1
vote
1answer
412 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 ...
0
votes
1answer
369 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 ...
0
votes
0answers
49 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
2answers
371 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 ...
1
vote
2answers
43 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
1answer
496 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, ...
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
229 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 ...
0
votes
1answer
21 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
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 ...
1
vote
1answer
625 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 ...
11
votes
4answers
34k views
Can't remote access MySQL server running on Mac OS X
I have a MySQL server running on my work computer, which runs Mac OS X Maverick. I want to access it from home computer, which also has Mac OS Maverick.
From terminal, if in 1 tab, I ssh into my ...
0
votes
0answers
26 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 ...
23
votes
8answers
90k views
Login failed for user - Error 18456 - Severity 14, State 38
Message that SQL Server Log File Viewer shows:
Login failed for user [User]
Error: 18456, Severity: 14, State 38
What it actually means:
Failed to open the explicitly specified database
My ...
0
votes
1answer
445 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
2answers
50 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. ...
4
votes
0answers
2k views
“Server local connection provider has stopped listening” errors in SQL Server error log
We have started seeing the following errors appearing intermittently (between 1 and 5 a day on average) in the error logs on one of our SQL 2016 servers:
Error: 26050, Severity: 17, State: 1. Server ...
0
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, ...
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 (...
4
votes
2answers
29k 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
644 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 ...
1
vote
2answers
2k views
Should I turn off GTID to fix this error?
Recently, a query has started failing. It is a query in the Magento software core (not a module) that Reindexes Catalog Search. I have receive the following error.
Catalog Search Index index ...
0
votes
0answers
91 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
103 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
115 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
335 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 ...
2
votes
1answer
110 views
Database Engine not getting connected
I installed, SQL server 2016 on my local machine with SSIS feature.
I am able to connect Analysis instance but when I am trying to connect to Database Engine it is giving below error.
Services start ...
2
votes
1answer
826 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 ...
0
votes
1answer
418 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 ...
0
votes
1answer
151 views
RMAN restore error;. expected sequence# 211287 doesn't match 211311 during recover
Oracle version = Oracle 8i (817_312) //Yes I know this is old.
Database id = LED
OS = Solaris 8
Oracle USERID = oraled
Oracle DBA group = dba
I an mot a DBA, but a UNIX/Linux System Administrator ...
0
votes
1answer
138 views
Anonymous + Unknown User attempt to my DB
I was checking my MySQL log and I found this error:
Connect UNKNOWN_MYSQL_US@localhost as anonymous on
Is it normal? Should I worry about a possible attack?
9
votes
6answers
23k views
The operating system returned error 21 (The device is not ready.)
Every time I reboot Windows, for some databases I get this error:
The operating system returned error 21(The device is not ready.)
I checked the disk with chkdsk /r - no bad sectors.
I executed ...
1
vote
2answers
54 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
62 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
153 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 ...
2
votes
3answers
2k views
MySQL 5.7 No Longer Returns Meaningful Error Messages
When I select from a table that doesn't exist:
When I select a nonexistent column from an existing table:
I used to receive meaningful error messages (ie 'Error Code: 1054. Unknown column 'column' ...
0
votes
0answers
471 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 - ...
