Questions tagged [errors]

For questions about specific error codes or messages, including troubleshooting.

Filter by
Sorted by
Tagged with
1
vote
1answer
330 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," + ...
3
votes
1answer
164 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 ...
1
vote
1answer
429 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 ...
2
votes
1answer
493 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 ...
0
votes
1answer
791 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
2answers
64 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 ...
1
vote
1answer
45 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 ...
1
vote
1answer
2k 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 ...
1
vote
1answer
3k 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 ...
2
votes
1answer
251 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
0answers
679 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 ...
0
votes
1answer
478 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 (...
3
votes
0answers
1k 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 ...
1
vote
0answers
389 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 ...
1
vote
1answer
2k 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: ...
0
votes
1answer
741 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 ...
0
votes
1answer
456 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....
1
vote
0answers
1k 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
vote
1answer
3k 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 ...
0
votes
1answer
144 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 ...
1
vote
2answers
3k 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 ...
1
vote
1answer
2k 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 ...
4
votes
1answer
737 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 ...
3
votes
0answers
1k 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 ...
2
votes
1answer
2k views

Error Msg 10314, Level 16, State 11 with SAFE assembly after upgrade to SQL Server 2017

I have a pre-SQL Server 2017 database that I restored into / upgraded to SQL Server 2017. In this database I have a SQLCLR Assembly. The Assembly is marked as SAFE since it doesn't do anything ...
0
votes
2answers
5k views

Unable to connect to MySQL on Windows 10: Access denied for user

I have MySQL server (only the server) installed and running on my Windows 10 computer. I tried to connect to the server with the following commands: mysql -u root -pSql2017 mysql -u root mysql --...
2
votes
2answers
337 views

SSMS 2016 forced connection

Some developers use SSMS 2016 with db_owner permissions to database(s) on a shared SQL Server, but error logs show an attempted login to the first user database on the instance, which they don't have ...
11
votes
2answers
2k views

SQL Server on Linux hangs on initial startup, no errors, and no new / updated ErrorLog file

I'm using SQL Server 2017, Release Candidate 2 (RC2) on Linux (Ubuntu 16.04). When the server starts up, SQL Server usually starts as well. But for some reason, SQL Server won't start anymore. At ...
3
votes
0answers
295 views

Cannot add standby database to the data broker configuration in oracle 11g

I have duplicated the primary database to standby database and then I added the primary database in data broker configuration. But when I'm trying to add standby database I'm getting following error: ...
1
vote
1answer
971 views

MySQL fails to start after editing my.cnf

I am trying to optimize memory usage (eating up more than 500MB by default) of MySQL using my.cnf, but I am having some trouble. The service is not starting after placing my custom my.cnf. It goes ...
2
votes
1answer
177 views

Would this INSERT statement work? Errata in textbook?

I was taking a practice test for Microsoft Certification 70-461 and wanted to confirm if what I saw was an error (this is from the official Microsoft Press book, Ninth printing. I did not see this on ...
1
vote
2answers
3k views

Duplicate key error for composite primary key when running update query without having duplicate

I have a table with the below schema CREATE TABLE `my_field_table` ( `entity_type` varchar(128) NOT NULL DEFAULT '' , `bundle` varchar(128) NOT NULL DEFAULT '', `deleted` tinyint(4) NOT ...
0
votes
1answer
376 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 ...
-1
votes
1answer
146 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?
3
votes
0answers
157 views

How do I change a processor count on a stopped SQL Server instance?

I have restored an image of a production SQL Server 2008 R2 to a Virtual Machine to test out some changes. When I try to start SQL Server to recreate tempdb (in partition that was not restored), it ...
0
votes
1answer
565 views

Permission issue on restore of the db from primary to secondary [duplicate]

while restoring the User DB from primary to secondary replica through query in cmd prompt and got following error message Msg 262, Level 14, State 1, CREATE DATABASE permission denied in database '...
0
votes
1answer
227 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 ...
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
113 views

SQL Statement with barely 100 columns causes ERROR 1118 (42000)?

During the development of a big project I have run into some troubles with a table being way too big due to over 90+ columns I have hit the problem of a syntax error: ERROR 1118 (42000) at line 9: ...
3
votes
2answers
4k views

PostgreSQL 9.3.13, How do I refresh Materialised Views with different users?

[I think the root cause of this problem is me not understanding permissions and privileges...] So, to set the stage, the set up I have is a DB, call it MyDb. I have two users, spu1 and u1, spu1 is a ...
1
vote
1answer
652 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 ...
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 (...
1
vote
2answers
781 views

Delete records from single Azure DB table that has no linking - reference to database and/or server name .. not supported

Environment Azure SQL database (migrated from SQL Server) Old database originally (15 years+) Dealing with a single table (trying to delete records) Using an admin user Using SSMS 2014 There are ...
2
votes
2answers
12k views

Cannot get geometry object from data you send to the GEOMETRY field

The following simple test returns an error CREATE TABLE track ( position point NOT NULL ); INSERT INTO track VALUES ( position=ST_PointFromText('POINT(-45.62390335574153 -3.9551761173743847)') ); ...
0
votes
1answer
506 views

Upgrade Oracle APEX 4.0.2 to 5.1.1 error

I installed Oracle 11g XE on CentOS 7 and everything went fine. I wanted to upgrade APEX to the latest version and followed instructions in Upgrading Oracle Application Express within Oracle Database ...
1
vote
0answers
24 views

Selective error logging (based on error code) in PostgreSQL

I want to log all PostgreSQL errors except unique_violation (error code 23505), which I would like suppressed. How do I achieve that?
0
votes
0answers
1k views

Error: 9602, Severity: 16, State: 1.The error is printed in terse mode because there was error during formatting

From today onward i am getting the below error in SQL Server 2012 Error: 9602, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. ...
2
votes
1answer
1k views

Duplicate key value error message on a database for a writing groups scenario

I am trying to create a database as portrayed in the following diagram: This is the SQL-DDL code I have written: CREATE TABLE Publishers ( PublisherName VARCHAR(50) NOT NULL, ...
1
vote
1answer
732 views

Increasing max server memory to deal with System.OutOfMemoryException on SQL Server

I am not very experienced so please bear with me. I have been attempting to import a 2500 MB and 3800 MB CSV into SQL Server 2016. Unfortunately I keep getting the System.OutOfMemoryException error. ...
1
vote
1answer
4k views

How can I get the row causing a conversion failure in SQL Server?

I have an update statement that is failing with this, Msg 242, Level 16, State 3, Line 63 The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. The ...