Questions tagged [database-administration]
The database-administration tag has no summary.
300 questions
Score of 1
0 answers
161 views
Oracle 19c throwing error combination ORA-31011 ORA-19213 LPX-00007
Our 19c Oracle installation throws errors in several situations:
Trying to connect with DBeaver
Querying e.g. SELECT * FROM ALL_OBJECTS
Running SQL> @?/rdbms/admin/utlrp.sql
other 3rd party ...
- reputation score 111
Score of 0
0 answers
121 views
User of phpBB service looking for remedy to bot attacks
Im an end user of a philatelic site that uses phpBB for its discussion board service. I believe ots the site in general that is under bit attack though - according to President of membership. Always ...
- reputation score 101
Score of 2
1 answer
76 views
ut swapping two disks between RAID 1 servers via hot-swap: How to avoid RAID failure?
π
I have two servers with identical configurations, each with 8 disks set up as RAID 1 pairs (disk #1 is mirrored with disk #2, disk #3 with disk #4, and so on). Both servers support hot-swap, ...
- reputation score 21
Score of 1
1 answer
3948 views
How to retrieve text of sql queries that were executed in specific transaction
In my production environment, rare undisposed transactions occur that hold lock on one tables. I want to fix it in my application code.
I can get the TransactionId and SessionId ad hoc, but
how do I ...
- reputation score 115
Score of 0
2 answers
275 views
MySQL Client taking more than 14 sec to be connected
IN our on-prem server we have installed mysql 4 node cluster 2 for mgmt and 2 for datanode. All are physical server with 1TB ram and 64 core processor. When a user trying to connect to mysql server ...
- reputation score 21
Score of 0
1 answer
797 views
restarting Oracle 23c within the docker container causes blocked listener
I am using the Free Oracle 23c Docker container (see here) to help provision a development environment.
As part of the configuration of the environment, I am putting scripts and SQL into /docker-...
- reputation score 123
Score of 1
2 answers
355 views
How should databases be configured for different environments to not lose data
How to configure databases for development, staging and production environments so that there will be no any data loss. Many Applications such as Wordpress, Django, etc... use some database to store ...
- reputation score 11
Score of 0
0 answers
27 views
How to handle scaling upto 3k concurrent connections [duplicate]
So here's our use case:
We have firmware that connects to server (simple php file - that takes post request) and add the data (350-500 bytes per request) to database.
Now here's a issue we have 3k ...
- reputation score 1
Score of 0
0 answers
237 views
How to expose multiple databases in local network for other applications to connect with them
I am following up this question here, in which I made the incorrect assumption of being able to access a database using HTTP.
Because I seem to lack conceptual knowledge, I would like to ask a more ...
- reputation score 101
Score of 0
1 answer
633 views
mysql, relocating individual databases vs entire data directory
I need to relocate mysql customer databases to another disk, for the purposes of:
1. Separation of user data from system files
2. Ease of backing up system and user data separately
3. Ease of ...
- reputation score 273
Score of 1
1 answer
8565 views
MySql 8 crashing on loop without specific errors and with enough memory
I'm running Ubuntu 20.04.03 with Mysql 8.0.27.
I have reinstalled LAMP from scratch several times and at the moment I only have 3 WordPress sites but I have tested only 1 and only 2 sites as well. ...
- reputation score 21
Score of 1
1 answer
3848 views
Why grant all privileges doesn't work in Phpmyadmin?
After command
GRANT ALL PRIVILEGES ON `dbname`.* TO 'userA'@'localhost' IDENTIFIED BY 'password';
MySql says ok. Then i log in user A, but when I try to grant some privileges to user B it gives error ...
- reputation score 11
Score of 0
1 answer
15161 views
Postgres Role required to grant CONNECT on a specific database
I am trying to GRANT CONNECT on a DATABASE to a user as a schema owner in that database.
The schema owner is not a superuser.
Do I need to be the owner of a database to execute
GRANT CONNECT ON ...
- reputation score 103
Score of 0
1 answer
97 views
Is there split brain possibility [closed]
If there are 10 cameras recognizing number plates, and sending the data to the server with a backup server synchronized, is there a possibility to have split-brain problems when some things go wrong? ...
- reputation score 9
Score of 2
1 answer
468 views
Everyday the DBs are in Recovery pending state
I have an Azure Virtual Machine hosting a SQL Server 2016 named instance. On this instance I have several DBs. Now, everyday we shutdown the virtual machine at 11.59PM and restart it at 8.00AM. The ...
- reputation score 121