All Questions

Filter by
Sorted by
Tagged with
0 votes
1 answer
17 views

Login via SQLServer AlwaysOn "Listener" Failed (Error: 18456, Severity: 14, State: 5)

I have setup an AlwaysOn Availability Group on SQLServer 2022. I have created a login on both replicas with same SID. But I could not login via listener IP or DomainName via SSMS. I could login ...
MShNajar's user avatar
0 votes
1 answer
30 views

mysql - show all users/hosts with privileges to access a certain database

Is there a way to list all users/hosts that have been granted access to a database? I know I can do this: > show grants for someuser; +---------------------------------------------------------------...
eftshift0's user avatar
  • 115
0 votes
1 answer
26 views

WSREP_SST: [ERROR] Possible timeout in receiving first data from donor in gtid stage

I have deployed Alma Linux 9 and MariaDB 10.11.7 with Galera 4 on two AWS instances and all the ports and firewall rules are open between 2 instances, I set the proper wsrep options and I am still ...
Sandeep's user avatar
  • 101
1 vote
1 answer
29 views

Trouble with only read user in Postgresql 14

I have a cluster where running around 20 postgres databases. I need to create read only user for every db. On this server i have service user e.g. service_user that do automaticly all operations in ...
Slam's user avatar
  • 11
1 vote
2 answers
97 views

Understanding Recovery Forks in SQL Server: Meaning and Significance

I'm trying to understand the concept of recovery forks in SQL Server, particularly in relation to the sys.database_recovery_status view. The documentation mentions several columns related to recovery ...
Just a learner's user avatar
0 votes
1 answer
27 views

Mysql problem not valid syntax

reason:Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'почта VARCHAR(50), тип травмы ENUM('...
Godelisk's user avatar
0 votes
0 answers
15 views

Crunchydata - PGO - Postgres(v 14.x) restore not working as expected

We have set up PostgreSQL, including its backup and recovery processes based on crunchy data Postgres Operator, as per the documentation. The backups are occurring as expected. However, when we ...
Neeraj Bhatewara's user avatar
0 votes
0 answers
8 views

Summing the derivatives of multiple series from InfluxDB 1.8 with InfluxQL?

Our monitoring solution is based on Telegraf + InfluxDB + Grafana, and we're having trouble visualizing the I/O statistics of our ZFS pool. Our data is collected with the inputs.zfs plugin of Telegraf,...
iBug's user avatar
  • 103
2 votes
1 answer
17 views

Does updating a frozen column generate a tombstone?

I was planning to change my column from nonfrozen to frozen. I would like to know if there are any guidelines for updating the frozen column with respect to tombstone generation. In some blogs it is ...
Prateek Sharma's user avatar
1 vote
1 answer
86 views

What is the impact on an index when I am widening a key varchar column

One of the central tables in my database has a varchar(25) column named EmployeeID. This column is used within a compound index and is likely the most used index in our system. We got an enhancement ...
Aheho's user avatar
  • 163
0 votes
1 answer
34 views

Finding id of last child in table structure

I have DB structure like this one: structure. message_id from_user_id to_user_id subject body date_add parent_message_id 1 1 2 message 1 body 1 2024-...
Robert's user avatar
  • 141
-2 votes
0 answers
30 views

Full text search with localization variants

I'm trying to update an old search function that used a lot of LIKE and REPLACE functions to get results with a lot of CPU time required, which is pretty much blocking most of the server it's running ...
El_Macho84's user avatar
0 votes
0 answers
18 views

Unsafe_aggressive_sstable_expiration - Procedure to enable unsafe_aggressive_sstable_expiration

I am planning to enable this tag to solve an issue related to some SSTables that are fully expired and are blocking some other expired SSTables from being expired. I have looked for information on ...
Jon Corral's user avatar
0 votes
0 answers
47 views

SSRS - Microsoft.ReportingServices.Diagnostics.Utilities

I am troubleshooting an error in SSRS we want to alter a subscription and set it to the next 5 min from now, but when it gets there it does not run. other than that, I see these error messages in the ...
Marcello Miorelli's user avatar
0 votes
2 answers
155 views

How do I upgrade MySQL from 8.0 to 8.4?

I'm on Windows. I installed MySQL 8.4, stopped all services and copied the Data folder and my.ini files into the 8.4 folder but now the 8.4 services does not start and does not produce any logs. I can'...
user avatar
0 votes
1 answer
22 views

PostgreSQL16 concurrency upsert rows with subquery in trugger funtion got maybe bad read

I have two tables: create table name ( id bigserial primary key, name text not null ); create table name_score ( id bigserial ...
zxx's user avatar
  • 3
0 votes
0 answers
29 views

Error Delete Distributor on sql Server 2019

I can't delete Distributor. The system shoew message error "Could not drop the Distributor 'Dis_name'. This Distributor has associated distribution database"
WP JLK's user avatar
  • 1
0 votes
0 answers
26 views

DB2 on CIS Amazon Linux 2023 Benchmark - Level 1

By following an tutorial blog of installing DB2 on Amazon Linux, after solving many dependencies error, in the end I'm facing an issue where I can't start the DB2. Some troubleshooting steps I did on ...
Yitasha's user avatar
0 votes
0 answers
22 views

Intermittent AWS RDS Connection Spikes Causing Production DB Outages

I'm new to AWS, and we're using a db.r7g.2xlarge instance running MySQL with default configurations. Typically, CPU usage and database connections are normal until "something" causes the DB ...
Mohamed Akram's user avatar
0 votes
0 answers
15 views

DB2 backup from Data Studio throws sqlcode=-22212

When I try to back up a database, the process fails with the error: Attempt to connect to DAS failed with the following error: sqlcode=SQL22212N db2dasrrm.exe runs under the PID from the netstat ...
Betty Liv's user avatar
0 votes
0 answers
19 views

How to replace users passwords with yaml variables?

I am writing a MySQL script defining users and roles, but I don't want to upload the password to the repository. So I was guessing if I can replace those passwords with yaml variables. USE test; DROP ...
Eduardo Jiménez's user avatar
-1 votes
1 answer
90 views

What is choice between node drain versus role switching in WSFC FCI patching?

I'm learning about patching OS and SQL FCI. I have a 2 node SQL FCI (active/passive). The SQL service exists on both nodes, but is running only on the active node. This is managed by the WSFC. I also ...
variable's user avatar
  • 3,476
0 votes
1 answer
36 views

Create table that has a sequence column counting from 1 for every different foreign key

Is there a way to define a table that has a sequence column counting from 1 for every different corresponding foreign key column? I want a "local" serial for every foreign key - sorry for ...
Greenhill's user avatar
  • 101
0 votes
2 answers
39 views

Making mysql write more to ram and less to SSD

What are some tunning options that could make MySQL (8.0.36) write more to ram memory and less to SSD ? To have less SSD wear not to optimize performance. Do these two affect amount of bytes written ...
adrianTNT's user avatar
  • 194
0 votes
1 answer
41 views

Why does moving a postgres table from one tablespace to another take so long

Why does moving a postgres table from one tablespace to another take so long (and how can I speed it up) I have a postgres database with two main tablespaces, one on a SDD, the other on magnetic HDD. ...
ConanTheGerbil's user avatar
0 votes
1 answer
29 views

Importing mysql file fails printing last line and I find ^@^@^@^@^@^@^@^@^@^ on that line

I am trying to import some relatively large databases, over 100 GB dump file. When I try to import the dump files with a command like: mysql -h localhost -u username -p dbname < backup.sql after ...
adrianTNT's user avatar
  • 194
0 votes
1 answer
38 views

Postgres - Improving multi-column GIN text search performance

I've got a schema for customer records a bit like: account_id - UUID name - text I currently have a GIN index that looks like: ... USING GIN (account_id, name gin_trgm_ops) We have a mix of accounts....
ColinHowe's user avatar
  • 101
-1 votes
1 answer
31 views

Return data in the same order that I have inserted it with Sqlite3

I'm working with, I think, the lastest version of Sqlite and C++. I have a table with data, and I need to return this data in the order I inserted it. Do I have any guarantee that the columns will ...
VansFannel's user avatar
  • 1,863
0 votes
0 answers
10 views

How to best set value of identity sequence for GENERATE BY DEFAULT column when supplying identity value when inserting?

I have a table with an identity column that generates by default. I need to be able to write specific values to the identity column due to logically replicating the table, so hence why using GENERATE ...
Applez00800's user avatar
-2 votes
3 answers
96 views

Why does killing a SQL Connection allow a reconnect with SSMS

I would like to kill connections for individuals using certain sql auth logins in SSMS that are reserved for our apps. They should have to go out of their way to reauthenticate into sql and at least ...
Laura Pilon's user avatar
-1 votes
0 answers
38 views

SSMS doesn't list freshly installed instance of SQL Server, only previous deleted/uninstalled version

I uninstalled both SQL Server and SSMS on a Windows Server 2019 machine. I reinstalled SQL Server 2019 and created the default database MSSQL and installed SSMS 20. When I open SSMS, it only lists ...
Mr. Geologist's user avatar
-1 votes
1 answer
27 views

How to find out what is adding a login trigger to my MSSQLLocalDB?

I keep having trouble with logging into (localdb)\MSSQLLocalDB. It gives the error: Logon failed for login 'Domain\user' due to trigger execution. Changed database context to 'master'. Changed ...
Martin Brown's user avatar
5 votes
1 answer
173 views

How does sp_executesql interact with temporary tables?

I'm at a loss as to why some SQL leveraging sp_executesql is working the way it is when temporary tables are involved, along with INSERT and SELECT - INTO. I'm using SQL Server. Here is the code in ...
Wipqozn's user avatar
  • 161
0 votes
0 answers
29 views

Should one stick to 1NF (and higher NF) rules for SQL even while using ORMs?

I am currently making a database in MySQL using the SQLAlchemy ORM. I followed the principles of 1NF until this point (atomised Data, no redundancy) but now I am tempted to add a few useful (though ...
Arya Vishe's user avatar
0 votes
1 answer
43 views

Error "No catalog entry found for partition ID ..."

When trying to delete disabled index or enable the same disabled index on one heavily utilised table, I am getting an error: No catalog entry found for partition ID 72057594967228416 in database 6. ...
Sranda's user avatar
  • 360
2 votes
2 answers
52 views

PostgreSQL: Long running auto vacuum and high wal rate

Recently a vacuum process triggered by auto vacuum daemon(PostgreSQL13) on one of our table took long 1.5hr to complete. During this period there was high WAL rate up to 7MB/sec and high Disk I/O. ...
goodfella's user avatar
  • 168
1 vote
2 answers
990 views

"Long asynchronous API Call" After Sql Server Update

After the latest SQL Server 2019 CU, KB5037331, I receive the following message repeatedly in a couple of my SqlServer Server logs: "Long asynchronous API Call: The scheduling fairness of ...
Jeff Bauersfeld's user avatar
0 votes
0 answers
143 views

Postgres ERROR: cannot execute DELETE/UPDATE/INSERT in a read-only transaction

Environment: Java + Hibernate + Postgres 10 + on-premise + Pgbouncer The usage scenario is that created a role with the following settings for the development team to test the application: pg_roles: ...
Caio Monsores's user avatar
0 votes
1 answer
24 views

Oracle 19 recover table with remap and constraints issue

I have a Oracle 19 DB that I am testing table restores from RMAN backups. I am using this code. recover table "HR".REGIONS OF PLUGGABLE DATABASE 'pdb' until ...
cptkirkh's user avatar
1 vote
1 answer
63 views

Query Optimizer Auto-updating stats before executing stored proc?

All of the evidence is stating that this is correct, but I need someone check my math on this... I have a stored procedure that does the following: Insert a status record into a table Table trigger ...
Marc S's user avatar
  • 45
2 votes
1 answer
86 views

SQL Express CPU limitation ignored

I have a SQL Express 2014 running on a VM with 12 cores SQL Express limitations state that it should be limited to either 4 cores or 1 socket, but when I run this query: select count(1) "Nb ...
Dominique Boucher's user avatar
0 votes
0 answers
26 views

SQL Server replication latency issue

SQL Server 2019 patched a couple months ago. As of this morning my transactional replication is very far behind in latency. The distributor is on the replication box. What I've ruled out: resource ...
user avatar
2 votes
1 answer
77 views

how to set in-transit encryption sql server?

today I had to check if in-transit Encryption was up and running in a particular server (sql server) and if not then set it up. the way it is done is: In SQL Server Configuration Manager, expand SQL ...
Marcello Miorelli's user avatar
0 votes
1 answer
22 views

MariaDB: Writing even 25MB of data into a LONGBLOB is very slow

We recently added MariaDB as a storage option for our tool. Before that we only allowed sqlite. Among other tables I have a very simple temporary file storage table: create table tmp_file_storage ( ...
Tekay37's user avatar
  • 101
0 votes
1 answer
18 views

Merge two queries to avoid looping over each lines one by one?

I have the following two tables Agents - id - name - email - organization_id Messages - id - message - agent_id - organization_id (And the "organizations" table with some fields, ...
Cyril N.'s user avatar
0 votes
1 answer
30 views

How to enable streaming replication if we clone database disks to new virtual machine?

On PostgreSQL v15 on RedHat 9 we would like to establish asynchronous read-only standby streaming replication. Primary server has 10 TB of data and pretty much a lot of new transactions, because it is ...
folow's user avatar
  • 357
-2 votes
0 answers
28 views

What is the meaning of distributed server in wsfc cluster manager (Azure VM FCI)?

On a SQL server FCI on Azure VM, when I open the wsfc failover cluster manager, then under cluster properties, I cannot see the IP address of the cluster. Also, when I click on the cluster, below the ...
variable's user avatar
  • 3,476
0 votes
0 answers
48 views

ORA-65139: Mismatch Between XML Metadata File And Data File

I have two systems - SYS1, SYS2(stand alone). On both is running an oracle 19c database. I want to create a plugable database from SYS1 and want to plug in the SYS2 database. I created the pluggable ...
ca2510fl's user avatar
-1 votes
1 answer
27 views

I keep getting NULL results

I have 2 tables i am working on. dbo_Returns1 - which has customer-id, return_date, returns, irder_id and dbo_Sales1 which has customer_id, sales, sales_date, order_id Question 1: What % of sales ...
kemi fawole's user avatar
1 vote
1 answer
64 views

Creating indexes before bulk-loading data is weirdly much faster than vice versa

EDIT: An important thing that I missed is the fact that I parallelize COPY operations by N number of cores, by splitting the data file into N equal parts, and issuing N requests through separate ...
Rafael Sofi-zada's user avatar

15 30 50 per page
1
3 4
5
6 7
2080