Questions tagged [errors]
For questions about specific error codes or messages, including troubleshooting.
0
votes
0answers
7 views
Corrupted system health extended event file with error message “Not a valid Win32 FileTime”
We collect data for monitoring from system health extended events and few of the SQL Server installations started failing with error below error message:
Conversion failed when converting date and/...
2
votes
1answer
21 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
18 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
25 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
0answers
27 views
IP address ** could not be resolved: Name or service not known [closed]
I am trying to understand what is going on with my MySQL server.
I am seeing errors frequently like the following:
IP address '104.239.141.16' could not be resolved: Name or service not known
or
...
0
votes
1answer
35 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
16 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
7 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
37 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
136 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
11 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
21 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
48 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
45 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
27 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
109 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
361 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
90 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
325 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
227 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
177 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
274 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
37 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
739 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
193 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
466 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 ...
2
votes
2answers
4k 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
54 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
221 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
691 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
40 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
439 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
117 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
405 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
62 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
360 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
1k 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
1k 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
454 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
86 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 ...
1
vote
1answer
192 views
What will happen with MySQL transaction if one of the queries fails?
I have 500 independent insert queries. I put them in a transaction to run faster. I am runing queries with PHP.
What will happen if one of queries fails? Will the transaction be rolled back ...
2
votes
1answer
183 views
SQL Server logs “blob data”, viewable with journalctl
What does it mean when I run journalctl -u mssql-server.service and it says B blob data,
Sep 06 17:34:44 x230 systemd[1]: Stopping Microsoft SQL Server Database Engine...
Sep 06 17:34:44 x230 ...
1
vote
1answer
54 views
SQL Batches and the GO command: which parts of my script failed?
I executed a script that had multiple sections, separated by the GO command, something like this:
Use DB1
GO
ALTER TABLE foo ADD bar VARCHAR(10) NULL
UPDATE foo SET bar = 'nananana'
ALTER TABLE foo ...
-3
votes
2answers
3k views
Conversion failed when converting the varchar value to data type int [closed]
declare @targetnumber int
declare @numberfield varchar(20) = 'stepnum'
declare @sourcetable varchar(20) = 'tblsteps'
declare @idfield varchar(20) = 'stepid'
declare @recid int = 3
set @...
0
votes
2answers
709 views
raise an error in sql server severity higher than 18
I can easily raise user defined errors where severity is not higher than 18. When is higher, I get this error
Error severity levels greater than 18 can only be specified by members of the
...
0
votes
1answer
215 views
With PostgreSQL getting ERROR: COPY format “CSV” not recognized
Whever I try to copy from
test=# \COPY table FROM 'file.csv' WITH ( FORMAT 'CSV', HEADER true );
ERROR: COPY format "CSV" not recognized
What's the reason for this? I know I've used this before.
2
votes
0answers
669 views
Very Sporadic Cannot initialize the data source object of OLE DB provider “SQLNCLI11” for linked server
OLE DB provider "SQLNCLI11" for linked server "001" returned message "Unable to complete login process due to delay in opening server connection".
Msg 7303, Level 16, State 1, Line 19
Cannot ...
0
votes
1answer
230 views
SSMS 17.8.1 Error: Accessing SQL Server logs
I am experiencing an error when I am trying to access the SQL Server Logs through SSMS 17.8.1 for SQL 2017.
I click to expand the SQL Server Log folder in SSMS and I get the following error.
How can ...
0
votes
1answer
104 views
Oracle 9i import error IMP-00017: following statement failed with ORACLE error 3113
I try to import a schema in my database 9i of copy which is a clone of the original from where I made the export 9i also and when trying to import the schema after many hours gives the following error:...
