Questions tagged [errors]

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

Filter by
Sorted by
Tagged with
1 vote
1 answer
59 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 ...
-2 votes
0 answers
18 views

Error: cannot execute REVOKE in a read-only transaction

Is there any way to fix it? Disturbing people who know a bit.
0 votes
0 answers
22 views

Not able to install SQL Server 2019

I am installing SQL Server however I'm getting following errors. Has anyone else encountered similar errors before? If so what's the fix?
30 votes
5 answers
87k views

The number of row value expressions in the INSERT statement exceeds the maximum allowed number of 1000 row values

One of INSERT INTO script is written as following. INSERT INTO tableName (Column1, Column2,....) VALUES (value1, Value2,...), (value1, Value2,...),.... Following is the error we are facing on ...
10 votes
1 answer
6k views

How to conditionally raise an error in MySQL without stored procedure

I need to conditionally raise an error, but I can only use a simple statement and no stored procedure. I'd like to do something like this: select case when foo = "bar" then 1 else SIGNAL SQLSTATE '...
3 votes
1 answer
2k 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 (...
0 votes
1 answer
463 views

What could be the reason for this invalid objects after trying to upgrade?

We recently wanted to upgrade our Database but didnt get to do it as we got a lot of Audit specific invalid objects, after looking online for ressources we couldnt find anything specific reason for ...
1 vote
0 answers
48 views

Mariadb replication Master Slave fail with error code 1595

I've a strange problem. A Mariadb replication start failing since this morning. Until today everything works fine from month. This is my scenario: I've a server in a DC which is the master, and a ...
3 votes
1 answer
132 views

How is a statistics collection different to normal table stats?

I have a small table with few rows create table dbo.p(i int); insert dbo.p(i) values (1), (2), (3), (4), (4); I created statistics; no index, just the stats. create statistics p_c on dbo.p(i) with ...
3 votes
2 answers
836 views

DBCC consistency error in SQL Server

I ran DBCC CheckDB in our Production SQL Server 2014. It reported back with one consistency error: Failed:(-1073548784) Executing the query "DBCC CHECKDB(N'MYDB') WITH NO_INF..." failed ...
0 votes
0 answers
144 views

SSMS cannot connect to SQL Server 2022 - Internal Error

I'm trying to connect (on the same host) from SSMS 19.0.2 to a newly installed SQL Server 2022 developer edition instance. I am getting a weird internal error: =================================== ...
8 votes
2 answers
1k views

Getting an "Incorrect syntax near '(' " error message when using the standard create table using a select in SQL Server

Why am I getting the error in the Title of this post when I run the following query using SQL Server via Microsoft SQL Server Management Studio? -- create the dash_airports table CREATE TABLE ...
3 votes
2 answers
3k views

42702 'column reference "id" is ambiguous' for RETURNING of table-returning PL/pgSQL function

This works: CREATE OR REPLACE FUNCTION sql_fun() RETURNS TABLE (id UUID) AS $$ INSERT INTO foo DEFAULT VALUES RETURNING id $$ LANGUAGE SQL; SELECT * FROM sql_fun(); This doesn't: CREATE OR ...
2 votes
2 answers
44 views

Backup syntax error with constructed string

This is doing my head in. What am I missing? Syntax errors with '+' and ; -- Step 1: Perform a database backup BACKUP DATABASE iMIS_Prod TO DISK = 'G:\SP_Backup_Daily\iMIS_Prod_' + ...
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," + ...
1 vote
1 answer
59 views

MySQL 1054 Error After Creating Trigger to Update on Insert

I am learning basic SQL and have gotten stuck with triggers. I have a database with two tables, customer and invoice. The table characteristics follow: CREATE TABLE customer ( CUST_NUM ...
3 votes
2 answers
212 views

psql can't connect to existing db

i have problem with connecting to database via psql. I get this error: postgres@server:/var/lib/pgsql # psql -d aisgdmp2 psql: error: FATAL: database "aisgdmp2" does not exist DETAIL: The ...
2 votes
1 answer
4k views

The operating system returned error 665(The requested operation could not be completed due to a file system limitation) on SQL Server 2014

Have a SQL Server 2014 instance running on Windows 2012 R2 that was running Ola Hallengren's DB integrity script. This is the error that resulted: The operating system returned error 665(The ...
1 vote
1 answer
2k views

SQL Server is terminating this session. c0000005 EXCEPTION_ACCESS_VIOLATION

I Got Error: A user request from the session with SPID 183 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log ...
0 votes
1 answer
2k views

MariaDB why do I get error "Unknown table x in field list" when it does exist (yes, another one!)

Using mariadb 10.4.13-MariaDB but I get the same error in a copy of the database running under 10.3. The important part of the schema shows /*Database: mamlocal*/ ---------------------- /*Table ...
2 votes
1 answer
2k 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 ...
3 votes
4 answers
4k 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
1 answer
34 views

This query gives error. right syntax to use near 'on vehicles.school_id = schools.id left join drivers on drivers.school_id = ...' at line 8

select drc_users.name, vehicles.total_vehicles, COUNT(distinct drivers.id) as total_drivers from drc_users LEFT join brc_users on drc_users.id = brc_users.district_id left join crc_users on crc_users....
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/...
-2 votes
1 answer
35 views

Msg 2732, Level 16, State 1, Line 376039 Error number 515 is invalid. The number must be from 13000 through 2147483647 and it cannot be 50000 [closed]

Please help me how to solve it. why is it throwing this error as my script is inserting data into various tables extracted from an environment. #376039 is the catch block where rollback and other ...
0 votes
1 answer
3k views

Error using SQL Server 2019 Import and Export Data (64-bit)

I'm getting an error immediately upon starting the SQL Server 2019 Import and Export (64-bit) wizard, and I'm looking for ideas. The error is: The SSIS Data Flow Task could not be created. Verify ...
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
1 answer
983 views

problem installing mariadb using mysql_secure_installation

I started secure install of MySQL with sudo mysql_secure_installation command, and I got that message: Securing the MySQL server deployment. Enter password for user root: Error: Can't connect to ...
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 ...
0 votes
0 answers
55 views

How to get session information for Azure SQL Database errors via Kusto?

I have a kusto query that finds errors in some of my Azure SQL Databases: AzureDiagnostics | where TimeGenerated > ago(1d) | where Category == "Errors" and DatabaseName_s has "<...
1 vote
1 answer
216 views

Error 1109: unknown table ‘account’ in filed list

When I inserted the values in new table, I had met a problem in there. The trigger will be shown below: delimiter $$ create trigger validation_check before insert on exercise.account for each row ...
1 vote
2 answers
593 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
1 answer
504 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 ...
0 votes
1 answer
526 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
1 answer
49 views

unable to add data to a table in mysql, Error Code: 1054

##Created table using the following line: create table sales ( product_id int, sell_price float, quantity int, state varchar(20) ); ##Tried to input values using the following line insert ...
0 votes
0 answers
20 views

Ignore wrongly typed fields and update all possible fields in postgresql?

Is it possible to do a single query/insert statement that inserts a number of values - however the type of values might be wrong. If a type would be wrong it should just be "ignored". IE say ...
1 vote
1 answer
719 views

pg_restore: error: could not execute query: ERROR: materialized view "ws1_all_formate" has not been populated

I had this error after the execution of pg_restore: pg_restore: finished item 19181 MATERIALIZED VIEW DATA avenant_f pg_restore: from TOC entry 19171; 0 2565914 MATERIALIZED VIEW DATA ...
1 vote
1 answer
268 views

How to use multiple arguments in ANY query when is bind message supplies parameters trhowing error?

I have the following query that is using one parameter that contains a lot of valid values to validate with ANY, right now I need to cast the id from bigint to int and validate with integers (This is ...
1 vote
0 answers
143 views

Azure SQL Error "Invalid object name '##{myTempTableName}'

I am getting an error in my stored procedure: "Invalid object name '##{myTempTableName}' for 3 global temporary tables. There are several temp tables used in the procedure, but I am getting this ...
0 votes
1 answer
67 views

Migration MySQL to Oracle 19C error ORA-00942

I'm trying to migrate a simple MySQL test database to Oracle 19c using the migration wizard available in Oracle SQL Developer, the result is that the procedure create the user and the tables but the ...
3 votes
1 answer
1k 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 ...
1 vote
1 answer
311 views

MySQL procedure exists, but doesn't

I am attempting to add a stored procedure to a database that does not show that any exist in tree (Workbench): As this screenshot of tree shows. Also, executing: SHOW PROCEDURE STATUS where Db = '...
-2 votes
2 answers
102 views

Making SQL give age brackets on command

I'm trying to make SQL return how many users are inside each age bracket grabbing the date of birth from the user from the table GUEST and converting it into years, at the moment I'm trying to make it ...
3 votes
2 answers
325 views

How do I find the line that causes SSMS "Msg 8115, Level 16, State 2, Line 1"

I've got a 400 line query in MS SSMS. When I run it I get: Msg 8115, Level 16, State 2, Line 1 Arithmetic overflow error converting expression to data type int. Line 1 is just the "Select&...
0 votes
0 answers
111 views

CDC Primary Key error

We are using CDC to feed our application. However sometimes, out of the blue, the following error occurs: Violation of PRIMARY KEY constraint 'lsn_time_mapping_clustered_idx'. Cannot insert duplicate ...
0 votes
1 answer
292 views

Infinite running loop while executing procedure

I have this table with 3 records. 3 records are create scripts. I need to execute the create scripts and if there is a 208 error occurred then I need to keep the record and set status as 1. Then ...
2 votes
2 answers
510 views

Invalid object name error while creating function

I have this function get_department. Inside the function there is a function call for get_po_amount. The get_po_amount function doesn't exist anymore, so when I try to create the Main function ...
2 votes
2 answers
111 views

DROP ALIAS unable to drop existing alias?

We're unable to drop aliases. So, I found an alias by running: SELECT TABLE_NAME FROM QSYS2.SYSTABLES WHERE BASE_TABLE_NAME IN ('OE0711P','OE0712P') AND TABLE_TYPE = 'A' AND ...
2 votes
1 answer
1k views

Can't do simple query or drop table due to out of memory error, but pg_locks return no lock

I received this out of memory error when trying to drop a large table (70GB including index) but couldn't identify the root cause from pg_locks view DROP TABLE big_table; ERROR: out of shared memory ...
25 votes
5 answers
42k 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 ...

1
2 3 4 5
9