Questions tagged [errors]
For questions about specific error codes or messages, including troubleshooting.
439
questions
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 ...