Questions tagged [errors]
For questions about specific error codes or messages, including troubleshooting.
439
questions
0
votes
1
answer
671
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:...
- 125
0
votes
2
answers
726
views
mySQL - Cannot add Foreign Key Constraint [closed]
I'm trying to add a foreign key constraint but, mySQL is not taking it. No detailed error, just Cannot add foreign key constraint
Here is my code from an export dump...
thanks for any assistance
-- ...
-2
votes
1
answer
6k
views
Varchar Overflowed an Int Column [closed]
I am having an error with the following query:
SELECT scp.phone, scp.extension, scf.fax, sce.email
FROM supplier_contacts AS sc
LEFT OUTER JOIN supplier_contact_phone AS scp
ON sc....
- 381
2
votes
2
answers
16k
views
Error 1242: Sub query returns more than 1 row and problem with repeating an if statement for all rows
So I've just started learning MySQL with a few exercises and I'm currently stuck at these 2 problems. Since this is technically an exercise I'd really appreciate hints instead of full solutions. Here ...
- 23
2
votes
1
answer
692
views
Mysql 5.7 cannot start again
For the first time in my life, I have Ubuntu, so I do not know much how to manage and what should I be looking for; I'm using version 18.04.
I installed MySQL 5.7, it worked great for a couple of days ...
- 81
2
votes
1
answer
184
views
SQL Server: Failed to monitor external signals
This program has encountered a fatal error and cannot continue running.
The following diagnostic information is available:
Reason: 0x00000007
Message: Failed to monitor external signals
...
- 60.4k
1
vote
1
answer
5k
views
Getting generate_series(date, date) does not exist
When I run commands like this,
SELECT * FROM generate_series('YESTERDAY'::date, 'TODAY'::date);
SELECT * FROM generate_series('YESTERDAY'::timestamp without time zone, 'TODAY'::timestamp without time ...
- 60.4k
-1
votes
1
answer
599
views
'INTERVAL' is not a recognized ODBC date/time extension option
According to this docs on Interval Literals, this should be a valid INTERVAL,
SELECT {INTERVAL '326' YEAR(4)};
But when I try that on dbfiddle, I get,
Msg 155 Level 15 State 1 Line 1
'INTERVAL' is ...
- 60.4k
3
votes
1
answer
3k
views
How can I track down what's filling my 'tempdb' transaction log?
We have a large and fairly well tuned SQL Server 2016 Enterprise Edition. Given the number of cores we have, our tempdb is currently comprised of 16 2,950 MB files running on a ram disk with a 16 GB ...
- 201
0
votes
1
answer
883
views
Error code is 0x80131500 when applying SP4 to SQL Server 2012
This is an open request for any thoughts, advice or guidance about an issue I have while attempting to apply SP4 to a SQL Server 2012 installation.
The server is currently the secondary node of a two-...
2
votes
0
answers
426
views
understanding mysqlslap concurrency
I have a RDS instance running in AWS. By default
max_connections=45
so I used mysqlslap to see how it works. I ran:
mysqlslap --concurrency=20 --host=deleteme.ckn5fsf3nwqp.ca-central-1.rds....
6
votes
1
answer
19k
views
What is the HY number (HY000) in MySQL Error messages?
When I get an error some of them have an HY code,
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
What is HY000 ...
- 60.4k
1
vote
1
answer
5k
views
What does [298] SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'WIN-443PT0LULQU\Administrator', error code 0x534
I'm going slightly nuts. I'm a programmer by trade - and I only dabble in NT security and DB setup issues.
However, we had a server fail to reboot after a MS Update. I've restored the entire ...
- 123
0
votes
1
answer
5k
views
postgres ERROR: target lists can have at most 1664 entries SQL state: 54000
In my query, I want to have more than 1700 columns but I got this error:
"ERROR: target lists can have at most 1664 entries SQL state: 54000"
I'm using postgres10 on Windows.
Has anyone come ...
- 11
0
votes
1
answer
717
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/...
- 11
0
votes
0
answers
19
views
Conversion Failed From nvarchar to int even when all values in result set are int [duplicate]
Take the following SQL sample:
Declare @Table Table (Value int)
Insert Into @Table
Select intValueAsVarcharType
From OtherTable
Where Category = 'Type1'
The OtherTable.intValueAsVarcharType ...
- 55
2
votes
1
answer
7k
views
Timeout expired error. Is it because of a query or server settings?
I am getting SQL Server timeout error in my production server, every hour
(~ for 5 minutes or more) during night time. This SQL server database is supporting a .NET application. I have scheduled an ...
- 157
1
vote
2
answers
263
views
Cleanup Error Messages in SQL Server ERRORLOG
The SQL Server's ERRORLOG file has a lot of messages like the following in AG in publisher (primary) as you know that distributor is out of AG Server. Subscriber is in another AG setup.
Logon ...
- 71
7
votes
1
answer
96k
views
No such column when column exists
I have a table (trackedinfo) inside my database that has the following columns (columns obtained by running PRAGMA table_info(trackedinfo);)
The problem is that even though the column sendok exists, ...
-1
votes
1
answer
5k
views
Cause of ORA-00902: invalid datatype in my code is?
Here is the code that is throwing the ORA-00902 error:
CREATE OR REPLACE PACKAGE collegeManagement IS
TYPE ScholarshipHistoryVarray IS VARRAY(10) OF NUMBER;
PROCEDURE advancedStudentsTable;
END ...
- 115
1
vote
1
answer
1k
views
wrong number or types of arguments in call to X?
Here is the code for which I am getting the error mentioned in the question:
CREATE OR REPLACE PACKAGE collegeManagement IS
TYPE studId_scholarshipModification IS RECORD(studentID studenti.id%TYPE, ...
- 115
-1
votes
1
answer
5k
views
Error Code: 1109. Unknown table 'revers' in field list
hello everyone this is a program to reverse a string the program works fine when values are given, but can't fetch the details from the table.If the method is wrong then please tell.thanking everyone ...
- 105
-1
votes
2
answers
11k
views
Error Code: 1241. Operand should contain 1 column(s) [closed]
this is a program to compare three numbers to find greatest
INSERT INTO compare(a,b,c)
values(43,56,2);
SELECT a,b,c,
IF (a>b AND a>c,'a is greatest',
(SELECT a,b,c,
IF (b>c,'...
- 105
1
vote
1
answer
2k
views
"The attribute cannot be found when processing" error
I'm facing following error while processing SSAS MDX cube:
Errors in the OLAP storage engine: The attribute key cannot be found when
processing: Table: 'FACT_TABLE_NAME', Column: 'COLUMN_NAME',
...
- 111
7
votes
1
answer
85k
views
"Invalid object name" error when executing query
I connect database with Visual Studio 2017. When I am trying to execute a query then it shows the following error:
The connection string I am using is:
SqlConnection con = new SqlConnection("Data ...
0
votes
1
answer
2k
views
Trying to run query and getting error: Error 1064 (42000)
I am trying to get a list of users from 2 different tables. I am using a sub query and the 2 separate queries run fine.
I am getting this error:
ERROR 1064 (42000): You have an error in your SQL ...
- 1
1
vote
2
answers
982
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," +
...
- 11
4
votes
1
answer
364
views
Implicit conversion causing error part of the time
I have been scratching my head about this one for the last day or so - I just can't see why a procedure works in one environment, but then fails in another due to a conversion error (same data, same ...
- 5,529
1
vote
1
answer
834
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 ...
- 121
2
votes
1
answer
1k
views
How do I find the error at a line number in a Oracle Live SQL script?
When someone runs an Oracle Live SQL script, each statement is executed and the final result (or errors) are displayed below each statement. However, line number errors create a bit of an issue:
The ...
- 217
1
vote
1
answer
1k
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
2
answers
76
views
all of the databases recovery models changed
i logged into a client's server today(which had log shipping for all of its db's), and found that someone changed all the databases recovery models to simple. so now i need to reconfigure the log ...
- 345
1
vote
1
answer
108
views
PostgreSQL/PostGIS ERROR: Third argument must be a POINT
I have a table mytable structured as follows:
id nv_bez parent_rv lfd_nr hierarch_bez snr geom
1 NV064764 None 1 NV064764_1 1 ...
- 297
2
votes
1
answer
8k
views
How do I query INFORMATION_SCHEMA.COLUMNS on Amazon RDS?
I received a list of column names from another team. To ensure all field column names are valid inside a specific schema, I put them into a temporary table. I'm now wanting to see if they exist. When ...
- 195
1
vote
1
answer
4k
views
Issue installing SQL Server 2012 SP4 in a cluster - missing ‘vc_red.msi’
Installed SQL Sever 2012 SP4 (from SP3) on one node of a two-node SQL Server cluster without issue. On the other node it is exiting out of the install with the following message:
The required MSI ...
- 1,774
2
votes
1
answer
373
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 ...
- 21
1
vote
0
answers
2k
views
Incorrect syntax near 'BULK' for bulk INSERT in Azure Data Studio
I am trying to bulk insert a large CSV file delimited by tabs. I am on a Mac, and executing queries on Azure Data Studio (formerly SQL Operations Studio), since SSMS is not available for Macs. Here is ...
- 111
0
votes
1
answer
2k
views
SQL Server - "The connection must be in an opened state."
I run various queries against a SQL Server 2012 instance, and occasionally, the following error message will pop up:
The connection must be in an opened state.
Parameter name: connection (...
4
votes
0
answers
3k
views
Getting: Possible index corruption detected. Run DBCC CHECKDB
When I connect to the database and run a command on some catalogs, I get Msg 9100, Level 23
1> SELECT * FROM sys.databases;
2> GO
Msg 9100, Level 23, State 2, Server x230, Line 1
Possible index ...
- 60.4k
1
vote
0
answers
706
views
MySQL shutting down automatically
I have a LEMP server in a Ubuntu instance and my MySQL are shutting down automatically... I have no idea what's happening.
I had to manually restart it to keep the site online
Here is my mysql log
...
4
votes
1
answer
3k
views
Postgres 10 shutting down on installation in Ubuntu 14
On trying to install postgres on Ubuntu 14 I am seeing postgres is shutting down. I am seeing the below errors in logs
[19043] LOG: listening on IPv4 address "127.0.0.1", port 5432
[19043] LOG: ...
- 1,103
0
votes
1
answer
1k
views
Circular Dependency Issue Error 1451
I am having an issue with a circular dependency. Inside my "Team Engineers" table, there is the name of the Engineer and also a Boss. A boss is also an Engineer as well. Whenever I want to update a ...
- 3
0
votes
1
answer
724
views
`make install` on a module, I get `pgxs.mk:114: recipe for target 'install' failed`
I'm trying to install a PostgreSQL module (pg-bignum). When I try make install, I get the following at the bottom of the log
/usr/bin/install: will not overwrite just-created '/usr/share/postgresql/9....
- 60.4k
2
votes
0
answers
3k
views
SQLServerAgent Error: The process cannot access the file because it is being used by another process
I have created the following as an automated job to run at midnight on every database server I manage:
This job fails intermittently on some servers, but not others and I get the following error:
...
- 1,365
1
vote
1
answer
5k
views
ERROR 1114 (HY000): The table is full [duplicate]
I am trying create a table using a cross join or Cartesian Product subquery that creates a table with a large number of rows, like at least 148 million rows. I get this
ERROR 1114 (HY000): The ...
- 11
0
votes
1
answer
200
views
Installing Oracle 12C Server on Windows 8
I'm currently trying to install Oracle 12C on a Windows 8 machine.
When I am executing the Data Base Configuration Assistant, I get to the Progress Page step where the the Installation Steps are ...
2
votes
2
answers
8k
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 ...
- 299
2
votes
1
answer
3k
views
Identifying why query is sleeping with open transactions
We have a 3rd-party application which is sporadically leaving connections in a sleeping state with an open transaction. This is causing many other queries to be blocked. I've been logging ...
- 1,973
5
votes
1
answer
2k
views
How to get only the first error with psql --single-transaction
I'm typing something like:
psql --single-transaction --quiet my_db < my_file.sql
When the script fails I get many lines saying: current transaction is aborted, commands ignored until end of ...
- 425
5
votes
0
answers
5k
views
PgBouncer cannot connect to server
I have configured PgBouncer with PostgreSQL 9.6 on windows 7 machine. Here are the pgbouncer configuration settings;
[databases]
test = host=127.0.0.1 port=5432 dbname=master_db user=postgres ...
- 171