Questions tagged [errors]
For questions about specific error codes or messages, including troubleshooting.
464 questions
1
vote
1
answer
138
views
DBA but cannot connect to SQL Instance - "User does not have permission to perform this action (Error 15427)" [closed]
I am a DBA with local sysadmin rights, and sysadmin rights on the SQL instance. Up until recently, i have been able to connect to a SQL Instance without issue.
All i am trying to do is connect to a ...
- 55
1
vote
2
answers
426
views
Could not open shared memory segment - Too many open files in system
I need some help of expert in Postgres.
I'm getting a problem in my application.
Problem: PG::InsufficientResources:
ERROR: could not open shared memory segment "/PostgreSQL.1477116630": ...
0
votes
0
answers
55
views
system lock on mysql replication
I have migrated a mysql instance to a new VM so that it can be managed by our team. I have setup replication between the primary and secondary. Primary has no issues. But replication keep failing.
It ...
- 1
1
vote
1
answer
102
views
Do I need to CREATE LANGUAGE plpgsql in PostgreSQL 9+
I have a PHP web application using a PostgreSQL database.
Ideally, to install this web application should be easy and only require a database name and user.
Then, the web application loads an SQL file ...
- 21
0
votes
1
answer
136
views
Mysql "ERROR 1045 (28000): Access denied" only when host is specified
I'm scratching my head with this issue.
I have an Azure flexible for MySQL server with MySQL 5.7.
I've created and give grants for a new user with the "%" wildcard, following the syntax (don'...
- 668
0
votes
2
answers
277
views
How to debug: "Trigger returned a resultset and/or was running with SET NOCOUNT OFF"?
I have a problem with trigger which produces the following error message
Trigger returned a resultset and/or was running with SET NOCOUNT OF
The trigger is structured like this:
CREATE TRIGGER ...
- 103
0
votes
0
answers
75
views
dbcc checkdb - how to work out the resources needed?
Integrity checks are important on a regular basis to find out errors.
Even on servers involved in availability groups.
we can normally find out how long it took to run?
It is a known fact that dbcc ...
- 17.3k
0
votes
2
answers
123
views
MariaDB (MySQL) : Cannot create view as already existing after database duplication
For some project, I duplicated an existing MariaDB (MySQL) database and altered its records to make it a demo dataset. The database duplication was done through phpMyAdmin.
The original database and ...
- 141
1
vote
0
answers
502
views
Execution Timeout Expired Error while executing an SQL query
Following error comes while executing an SQL query.
Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
This happens after 30 ...
- 35
0
votes
0
answers
87
views
My PGA getting filled up quickly in oracle 21 XE
I'm using Oracle 21c XE for an application with a database size of less than 0.5 GB. However, I’m encountering the error:
** ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT.
I’...
2
votes
1
answer
302
views
RAISERROR / THROW and sp_start_job Termination Behaviour
Given the following SQL Server Agent job
USE [msdb]
GO
BEGIN TRANSACTION
DECLARE @ReturnCode INT
SELECT @ReturnCode = 0
IF NOT EXISTS (SELECT name FROM msdb.dbo.syscategories WHERE name=N'[...
- 2,256
4
votes
2
answers
460
views
If LATERAL is optional for table-valued functions, then why does this query error without it?
Setup
CREATE TABLE persons
(
person_id int not null,
name TEXT
);
INSERT INTO persons VALUES
(1, 'Adam'),
(2, 'Paul'),
(3, 'Tye'),
(4, 'Sarah');
CREATE TABLE json_to_parse
(
person_id int not ...
- 1,362
0
votes
1
answer
32
views
I recieve TypeError while getting an array from mongodb
As I declare an array in the model
@Prop({ type: [Types.ObjectId], default: [] })
for_users_ids: Types.ObjectId[];
As I want here to send a socket event to all the users of this notification, but I ...
0
votes
0
answers
323
views
mysql ibd import error: cannot reset LSNs in table: Data structure corruption
I am using mysql (Ver 8.0.26 for Linux on x86_64) on centos 8.
I have copied *.ibd with *.cfg file from one server to another server as follows:
source server (Server1)
mysql> show create Table \...
- 1
0
votes
0
answers
877
views
MySQL redo log error (log files come from different directory)
I've set up a PHP + MySQL project on a client's computer. Now, they're facing a problem. This is the second time I've fixed it. The MySQL80 process stops working. If I manually try to start it from ...
