Questions tagged [errors]
For questions about specific error codes or messages, including troubleshooting.
309
questions
1
vote
2answers
39 views
MS SQL Server Error 18456 after database move
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
56 views
SQL stored procedure returning 0x000000000
I have a stored procedure that executes a number of selects for variable setting ,update and delete queries etc.
The stored procedure executes manually without error but in the messages shows
...
0
votes
0answers
70 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
34 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
42 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
66 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 ...
0
votes
1answer
54 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
27 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
37 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
38 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
137 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
24 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
24 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
30 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
87 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
27 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
11 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
140 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
247 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
14 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
1answer
72 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
58 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
73 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
30 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
149 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
954 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
143 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
1k views
Error when creating a stored procedure in postgreSQL-10 [closed]
I couldn't get my first stored procedure to work, so I copied this example from the manual:
CREATE PROCEDURE insert_data(a integer, b integer)
LANGUAGE SQL
AS $$
INSERT INTO tbl VALUES (a);
INSERT ...
0
votes
0answers
383 views
Determine cause of “MySQL server has gone away”
I've got a long running process on a headless server. It is a C program that monitors a modem for Caller Id and hangs up on telemarketers. On startup the program opens a connection to a MariaDB 10.3 ...
1
vote
1answer
309 views
Bulk insert statement fails in SSMS with Operating system error code 5 (Access is denied.)
This issue was discussed in several places and it seems that general consensus is that if Windows Authentication is used then SSMS will access source file using Windows Domain user credentials.
...
0
votes
1answer
469 views
Postgres is returning the “column reference '<column_name>' is ambiguous” message inside a function even with aliases
I have a function like this:
CREATE OR REPLACE FUNCTION test() RETURNS
TABLE(my_date date, gates smallint, area_type character(1),
area_sizes float[], area_canvases float[]) AS $$
BEGIN
...
0
votes
1answer
51 views
How to get useful error information from mysql command?
I'm trying to script the creation of a database with tables. I'm encountering errors but the error messages are not helpful to me because I'm a novice.
I'm finding the mysql tool is providing mostly ...
1
vote
2answers
1k views
A transport-level error has occurred when receiving results from the server. Error 10054
I have been using SQL Server & Azure for almost two years with Zero problems. Now for some reason I am getting the following error when I try to connect to my Azure database from SSMS. I have ...
0
votes
1answer
228 views
Why do I receive the error message “'<column name>' must appear in the GROUP BY clause or be used in an aggregate function”?
Where am I going wrong? Why am I getting that message when I add the MAX function?
The query involved:
WITH
references_cve AS (
SELECT vulnerability_id, reference
FROM ...
0
votes
0answers
12 views
do tmpdir is cleaned up automatically
While testing a 3 node percona cluster we often get:
Errcode: 28 - No space left on device
After login to the servers and checking the defined tmpdir I notice that is empty and clients can connect ...
2
votes
1answer
649 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 ...
4
votes
2answers
7k views
Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade
In mysqld.log I have thousands of lines like:
Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade
So, according to virtually every post on the ...
0
votes
1answer
61 views
A AFTER INSERT trigger error for security context
A trigger has stopped working since we have changed our SQL Server to a new server. Trigger is now being corrected to point to the new location of the table on the new server. When updating fields on ...
0
votes
0answers
284 views
ERROR InnoDB: Trying to access page number .. in space .., space name…, which is outside the tablespace bounds
I am running a mysql database server (5.7) on a virtual ubuntu 16.04 host.
This host collects syslog messages from my other network hosts, adds the values to a pipe and creates mysql records for each ...
1
vote
1answer
1k views
Oracle - Can't login with “/ as sysdba”, but can with “sys as sysdba”
I've been working on setting up a docker container running Oracle DB XE 18.4.0. I have the container built from Oracle's dockerfiles and it is working fine, except that I cannot login using
connect / ...
0
votes
1answer
59 views
Getting error on a particular query on a table in Postgres
I am getting the following error on one query in Postgres:
select * from sampletable where sample_id = 1234;
Error is :
ERROR: could not access status of transaction <some-id>
Detail: CLOG ...
1
vote
1answer
850 views
Syntax error when trying to add columns to table in DBeaver (postgresql)
I've tried this a few different ways but every time I get a syntax error when trying to add columns to a table.
I'm new to databases so it's probably something basic that I'm doing wrong, but I just ...
0
votes
1answer
152 views
Oracle 12c EM error on login
I'm trying to access an Oracle 12c EM and when I try to login it shows me a load error box with the errors that I expose below, which could be happening? Is there a possibility to reconfigure EM ...
0
votes
0answers
664 views
SQL Server Error 14013 - This database is not enabled for publication
I am trying to configure a database publication with T-SQL.
use master
exec sp_replicationdboption
@dbname='anun',
@optname=N'publish',
@value = N'true';
It runs successfully and I see ...
0
votes
1answer
70 views
Oracle Internal Error [closed]
Getting oracle Internal error in oracle database 11gr2:
ORA 600 [kkpogppi1]
It shows everyday in incidents but whenever i check oracle logs it shows nothing and when i open problem details it ...
2
votes
0answers
507 views
The prelogin packet used to open the connection is structurally invalid
I'm getting the below error across multiple servers (SQL Server 2005, 2008, 2008r2, 2012). The SQL Servers are up to date with service packs as is the OS. These are all SQL Server Standard edition.
...
1
vote
2answers
2k views
Can't change authentication mode from Windows to both SQL Server and Windows
As the title suggests I'm having problems changing the authentication mode from Windows to both SQL Server and Windows mode in version 12.0.2. I have tried right right-clicking the server, go to ...
0
votes
1answer
2k views
sudo service mongod start returns error 100
I'm encountering the following error upon executing sudo service mongod start in terminal.
mongod.service - MongoDB Database Server
Loaded: loaded (/lib/systemd/system/mongod.service; disabled;...
2
votes
2answers
600 views
Cannot connect to <instance>. A severe error occurred on the current command
Recently, and on more than one occasion now, we have attempted to connect from one of our SQL Server instances to another using SSMS only to be greeted with the following error:
A severe error ...
0
votes
2answers
112 views
GROUP BY clause / Aggregate function error [closed]
I am having a problem creating a Table View:
DROP VIEW IF EXISTS product_variation_stock_view;
CREATE VIEW product_variation_stock_view AS
SELECT
product_variations.product_id AS ...
