All Questions

Filter by
Sorted by
Tagged with
0
votes
0answers
2 views

Postgresql -- does casting to type text slow a query down?

For example, the query I am looking at has a WHERE clause with: WHERE table.col1::text = 'ABCD'::text Would these casts to text cause the query to be significantly slower? The version of PostgreSQL ...
0
votes
0answers
22 views

How to capture warning message into a variable in SQL Server

I would like to capture a warning message and log it to a table as with regular ERROR_MESSAGE(). So I would like to put the text Duplicate key was ignored. in my variable @Warning. But it does not ...
0
votes
0answers
10 views

Find what queries are reports using on SSRS

EDIT: It seems they're using "semanticQuery" and this is why I cant see usefull information? We will be decommissioning one of our functions, and we noticed that some reports are still ...
0
votes
0answers
8 views

Mysql 5.6 Memory usage keeps increasing till it is killed by OOM killer

we have a production mysql 5.6.46, which is under heavy load (2000 Queries per second). The memory allocation to Mysql keeps on increasing over a period of time (sometimes in 1 day, sometime in 1 week)...
1
vote
1answer
23 views

Environment variables in Postgres C extension

I cannot get environment variable in my PostgreSQL C extension code. For example, this function always returns 111: #include "postgres.h" #include "fmgr.h" #include <stdlib.h>...
0
votes
1answer
7 views

Mysql Server high CPU load and high memory usage

Greeting everyone, I have a Cpanel VPS server with below details : 8Core CPU | 32GB RAM | 450GB SSDNVME Cpanel V100.0.5 on CentOS v7.9.2009 Mysql V8.0 Litespeed server Web Host Professional (2-Worker) ...
0
votes
0answers
8 views

Update data type from integer to decimal128 for all document having nest array in mongo db

Had a JSON structure which is having nested array and need to update all data type for that json structure { "phone" : [ test:{ testid:1, testname:&...
0
votes
1answer
8 views

Potential pitfalls for upgrading PostgreSQL from 9.x/10.x to 13.x?

I have inherited from a predecessor a large number of Debian 9 systems that we are now looking at upgrading to Debian 11. Most of these run PostgreSQL 9 or 10, installed from Postgres's own ...
0
votes
0answers
12 views

Help recovering Oracle Datafile :selecting from or loading data into an oracle 11g r2 ED Datatabase: ORA-00376 & ORA-01110

A user created a datafile with size 200M and when the datafile was created it appeared in the OS as a Zero Kilobytes file. And then the user tried to drop the datafile but after that using query: ...
0
votes
2answers
41 views

Why is the result of DATABASEPROPERTYEX not consistent for AdventureWorks?

I'm using the function DATABASEPROPERTYEX to check the Recovery property of databases, but the result is wrong for the database AdventureWorks (later I noticed the same strange behavior for ...
0
votes
0answers
12 views

what is the possibility to create a SQL user to connect through JDBC only not with SSMS and other tools?

Maybe my understanding was not clear about user authentication in MSSQL. I am very new to DataBase subjects. Thought of checking with the experts here. I am planning to provide access to SQL users to ...
1
vote
1answer
13 views

Reclaim space after a failed VACUUM FULL

I made small miscalculation and my VACUUM FULL ended up filling the disks of the instance. I managed to free enough space to restart postgres but I am afraid it won't be enough to run VACUUM FULL to ...
0
votes
0answers
5 views

Best approach to extract 1000 Gbs of Data from Teradata

What should be the best approach to download data from Teradata using python ? I have more than 3000 GBs of data to be migrated from teradata to another code service. Any approach or advise would be ...
-2
votes
0answers
13 views

Oracle XE 21c startup not working linux

SQL> startup ORA-01506: missing or illegal database name
3
votes
1answer
271 views

Identify all queries that target a given table?

Is there a good way to identify all queries that target a given table (extended events, procedure cache, etc)?
0
votes
0answers
19 views

Are there any special considerations for a log-shipping role change when the database has memory optimzed files?

We're noticing a problem with our log-shipping setups when the database contains a memory-optimized file. Specifically, after changing the primary/secondary roles, restoring log backups taken after ...
1
vote
1answer
23 views

Postgresql 12 - ddluser and dmluser for same schema dml permission denied on tables [duplicate]

I have created a postgres 12 instance and executed the below command sequence: psql --host localhost -U postgres -c "CREATE DATABASE mydb" psql --host localhost -U postgres -d mydb -f /tmp/...
0
votes
0answers
13 views

Horizontal scaling with database schema

I am designing a database schema for our customers on-premise, which will be moved to Azure PaaS later. Regarding the "scale out" strategies I lean towards to create "one database",...
0
votes
1answer
42 views

Data corruption-Errors found in off-row data- am I loosing data?

I need your help with understanding what is going on in my database. Check DB job detected some issues in one of the tables. There are two types of error messages. A lot of errors like below: Table ...
2
votes
2answers
33 views

Why is my database name truncated?

I'm using MariaDB v5.x and want to return a long database's name with the query. I can successfully do this with a simple query, but with a more involved query the database name comes back truncated [...
2
votes
3answers
89 views

Constant rebuilding indexes to fix performance - why?

We have a database server (2016 SQL Server), that we have added a step of 'rebuilding indexes' to the deployment process. In decades of working with MS SQL Server at a many companies, I've never ONCE ...
0
votes
1answer
9 views

Cannot connect to MongoDB router in sharded cluster

I followed this guide on how to setup a sharded MongoDB cluster with Docker containers. It all seemed to work as it should because there were no error messages in the logs and the sh.status() command ...
0
votes
0answers
8 views

Process for upgrading MySQL Master-Slave to a new release series version

I have several MySQL servers that I want to upgrade from 5.7.31 to the most recent release series (5.7.36 I believe), but in one test I found that replication on one server set failed, and it required ...
0
votes
1answer
11 views

RMAN Duplicate with new SID / Path

We are running Oracle 12c SE. I need to duplicate an instance from the RMAN backups. However, this instance will be on a different server, with a different SID. And, the pathnames have the SID in ...
0
votes
1answer
19 views

MariaDB Maxscale caching not working

I have setup Maxscale (v6.2) and have connected to the Galera Cluster (3 nodes - MariaDB 10.5). I am trying to use the cache filter but it seems to not work. I have enabled general log for all the ...
0
votes
1answer
7 views

mysql --login-path connecting to the wrong database

I have a strange problem with mysql and the --login-path option. I have configurated multiple users and databases, some local and some remote using mysql_config_editor. But since I had my last ...
3
votes
2answers
37 views

Command to validate a postgresql configuration file?

I am generating postgresql configuration files via ansible, and putting them in /etc/postgresql/XX/main/conf.d/whatever.conf. I accidentally made a syntax error and broke my postgresql, requiring ...
0
votes
1answer
18 views

Importing CSV Flat File - how can we change defaults of all columns to n characters

I have to import a CSV file into a table that has 75 columns. The Flat File connection defaults all the columns to 50 character strings. Some of the fields are much smaller and some are 255. The only ...
0
votes
2answers
42 views

Best practice for a database used by multiple versions of an application

I'm working on a new product which will run on-premise at our customers. The configuration and usage of this application will be stored in a database. One of the requirements is that a newer version ...
0
votes
1answer
19 views

Can I convert a local user to a common user in Oracle?

I have a local user in a pluggable database and it has data, objects etc. under its schema. Can I easily convert this user to a common user without losing its objects etc.? (Oracle Database 19c)
1
vote
1answer
14 views

MariaDB/MySQL backup replication

I have currently two DB instanced with two-way replication. Each replicates other database. So both are master and slave. So every change in any of these databases is automatically replicated to the ...
-2
votes
1answer
40 views

LEFT JOIN Performance Issue

I have a view, which has a column that comes from query Without this query my count(*) against that view executes in less than 2 seconds, whereas it takes 2 days for the view with above extra column ...
-2
votes
0answers
18 views

writing a conditional sql select query based on checkbox value

I'm getting a syntax error at or near if. Any help would be appreciated
0
votes
1answer
5 views

Using nested json_arrayagg with two table which have many to many relationship

Consider following two tables in mysql database role(role_id); task(task_id); and a pivot table role(role_id,task_id) I can extract a single role in JSON format using the following query select ...
0
votes
1answer
21 views

Adding new datafile to tablespace but no datafile being created

I recently faced the following error: ORA-01688: unable to extend table RATEL.MV_IN_GPRS_SPLIT partition SYS_P54817 by 128 in tablespace RATEL" while loading data into the database. To resolve ...
-1
votes
0answers
14 views

Database structure for ticket states and types

We would like to store regular snapshots of our task tracking software in a database and I would like to ask about the best database structure for relationships between issues, types and states. Our ...
0
votes
1answer
21 views

Best practise making users in Maria db database

Iam creating a basic banking database to practise MariaDB, so I wanted to know what the general guidance on what kind of users you should be making and what type of privileges? Currently I have a read ...
0
votes
0answers
9 views

MariaDB run a new cluster while keeping an old cluster running

I currently have a 5-cluster mariadb galera set up. Two of the servers are in the cloud while three of them are locally hosted. I kinda want to start the three on premise servers to act as a separate ...
1
vote
0answers
24 views

How to prove Unique index could be better than non Unique index by the execution plan

I know Unique index will be faster than non Unique index theoretically if data is unique. Because Unique index be able to provide more information let query optimizer choose more effective execution ...
1
vote
0answers
15 views

limit user's SELECT query to a fixed number of rows

i have read the following questions: Limit Postgres results for a user and also noted the recommendation of limiting a user's statement_timeout, however i would like something a little more consistent....
-2
votes
0answers
41 views

Tempdb filling up on secondary always on server

Please advise . The tempdb disk fills up unexpectedly on secondary always on server . Is there a way to check what is causing or a way to prevent it ?
0
votes
0answers
10 views

Debugging connection leak in postgres instance in RDS

Trying to debug a connection leak in postgres database instance in RDS SELECT * FROM pg_stat_activity; Running the above query shows around 500 sessions, but all of them have wait_event_type Client ...
0
votes
0answers
13 views

Problems with pg_upgradecluster

Friday I did an upgrade from PostgreSQL 13 to 14 with pg_upgradecluster (on Debian Buster). This worked so today I wanted to upgrade another server (Linux Mint 20.3 Cinnamon). This time it does not ...
0
votes
0answers
19 views

How to organize common columns to a single table?

I'm very new to database designing and I'm creating a small project to understand it better, I'm trying to come up with a new school crm. I started with the below schema: create table student( id ...
0
votes
0answers
11 views

Error re-initializing device during mount

I am unmounting a database into a manifest file, and then mounting it back. I have two users, for both the users, the device list for the database before unmounting is the same. But on mounting, for ...
0
votes
1answer
15 views

What do these weird errors logged mean?

Today, I got these errors logged for the first time: stats_timestamp 2022-01-16 10:58:25.625142+01 is later than collector's time 2022-01-16 10:58:23.356175+01 for database 0 statistics collector's ...
-3
votes
0answers
40 views

LIGHTEST weight relational database for node [closed]

I know that SQLite is lightweight but I wonder how much of the ram it takes up. I am trying to set up a personal POC in a aws micro (.5GB ram) and I am trying to max the efficiency at the knitty ...
0
votes
0answers
14 views

UPDATE columns using JSON data

I have found two solutions that update columns based on JSON data. The first solution is based on CTE: WITH list AS ( SELECT * FROM json_populate_record (null::tsk,'{"tsk_id":"2",&...
0
votes
0answers
13 views

column "tum_first_name" of relation "tbl_users" does not exist, even when it does [duplicate]

I have a tbl_users, where there are a few columns like TUM_First_Name,TUM_Last_Name and so on. However, when I try an insert query, an error says :- column "tum_first_name" of relation "...

15 30 50 per page
1
2 3 4 5
1880