All Questions

0
votes
0answers
15 views

replication slot: FAILED (slot 'barman_the_backupper' not initialised: is 'receive-wal' running?)

I am running a postgres cluster with point in time restore using barman. It stopped streaming WAL. it says slot "barman_the_backupper" not initialized. how can I initilize this slot? I am getting ...
1
vote
1answer
35 views

Time addition based on the previous row

I appreciate if someone could give me some help. I would like to deal with time addition based on the previous column using mysql. Here is what I have. create temporary table test(id integer, ...
0
votes
2answers
44 views

Select Column Values from all the tables of database ORACLE

I am trying to fetch column value from all the tables of database where column value matches. Table A CAMPUS_ID 1 Table B CAMPUS_ID 1 Expected Result TABLE VALUE A 1 TABLE VALUE B ...
0
votes
1answer
10 views

Oracle12c: Objects attempting to import to original tablespace (despite wanting to remap them)

I've exported a schema from a DB server (Oracle 12.2.0.1.0) using exp with the following command. exp USERID=FOO/FOO2019 FILE="D:\app\ORACLE\admin\orcl\dpdump\FOO.dmp" LOG=FOO.log I now want to ...
-1
votes
1answer
58 views

What does the error “Ambiguous column name 'id'” mean? [closed]

I have an error in my database when I am using right join in my query. my table has a column name 'id'. SELECT TOP 6 id FROM dbo.tbldata RIGHT JOIN tblimg ON tbldata.id = ...
1
vote
1answer
28 views

MySQL 8 Geospatial Queries, MakeEnvelope Workaround?

I'm trying to work with some data from Google Maps and have a few locations along with their bounding boxs (northeast, southwest) data stored. Using that data, I have the following query... SELECT ...
3
votes
1answer
29 views

Delete rule on view does not execute every statement

When I have more than one statements in a rule on a view, the second one is not executed in case the first one deletes the original entry. Even when the second statement does not have anything to do ...
1
vote
1answer
20 views

Network Partitioning

My current understanding of the network-partitioning scenario, also mentioned in the CAP theorem, is that it's a scenario where the clients are not able to connect to some DB nodes even though they ...
1
vote
0answers
11 views

mysql 8 is failure to start after upgrade from 5.7

I've upgraded one of the slave server from mysql 5.6 to 5.7 and now 5.7 to 8. But after up-gradation steps done when i use systemctl start mysqld.service or systemctl restart mysqld facing error and ...
0
votes
1answer
27 views

Optimize very simple Postgresql query (and understand Query Plan)

I have a DB with many tables created using the following structure : CREATE TABLE table1 (id serial primary key, col1 real, col2 real, ..., coln real) with about 50 columns and 400k rows. The tables ...
0
votes
0answers
3 views

Submit values to mysql data base form a form in side another form together

I have some questions on php. imagine this form <form> <input type="text" name="name"> <form id="second" onsubmit="return false;"> <input type="text" name="name1"> </form&...
-1
votes
0answers
19 views

what is the overhead of Mysql database users [on hold]

i have one application where we wish to create new connection for all users so everything is new for all means , new database, new mysql users everything new but is it a good practice. we are doing ...
1
vote
1answer
115 views

Find the OverLapped (Common) Date Range from Group of Date Ranges

How can I find the Overlapped (common date range) from a group of Date Ranges given? The following table contains events and programmes (EID and PID respectively) CREATE TABLE #EventsTBL ( PID ...
0
votes
1answer
29 views

Combination Identifier

I want to identify in one column those who are present in the data but there is limit to only 10 nests. Is there easier or some other way for me to get the result that I want? I hope you could help ...
0
votes
1answer
35 views

Employee Shift Check - Nested Cursor

I have a query that returns the availability of an employee (only days they are available): SELECT emp_id, emp_number, area, day_date, shift_type, start_time, ...
0
votes
1answer
34 views

Using SQL Server Reporting Services for monitoring database performance

I'd like to know whether it is a good idea to use SSRS for db monitoring or not? I want to check different parameters of a db such as Deadlock, page splits, and page reads/sec to improve db ...
-1
votes
0answers
28 views

Database is getting too big [closed]

We're currently running into some performance problems since our database is getting too big. Due to db size is increasing application cannot handle load and getting hang sometimes. Database size: ...
-3
votes
0answers
15 views

Object Model Question [closed]

-3 Fluffy and Bushy (F&B) is a US based veterinary clinic that treats animals in the US. There are several clinics throughout the country. They assign each clinic a clinic ID, and they need to ...
0
votes
0answers
14 views

Can't connect to SSAS server — “Element 'return' was not found. Line 5, position 2.”

I'm trying to access an SSAS server from SSMS v17.4 (2017). I'm using Windows Authentication. I know the credentials are correct and can actually connect successfully from Visual Studio 2015. ...
0
votes
1answer
34 views

Not able to execute xp_cmdshell from a proc using invokeSQL command

I have a powershell script that execute a SQL script remotely on a SQL server using invoke-SQL command but the problem is it is not able to execute a SQL script contains a stored proc that has a task ...
1
vote
0answers
18 views

Excessive log throttling on Azure SQL on business critical tier

We moved from the Biz Critical vCore Gen4_8 tier to Gen5_8 over the holidays. We had to move because our log growth is constantly pushing us into the 1 TB limit of Gen4. Not only are our queries ...
-3
votes
0answers
19 views

How to get rolling 12 months data in Athena

I have a database like sno product date sale 1 - 2019-01-16 10 2 - 2019-01-15 20 3 - 2019-01-01 23 4 - 2018-12-29 12 and ...
-1
votes
0answers
39 views

Database stuck in recovery [closed]

One of our database is stuck in recovery for a very long time. The database got corrupted and after a failover, its unable to recover. I tried a few things and its now in single user mode and wont ...
1
vote
1answer
27 views

Converting (a) an entity-relationship diagram about an airline booking scenario to (b) a relational schema

I am currently following notes on a certain "7 step strategy" to transform an ERD to a relational schema and was wondering some points about step 4, converting one-to-many (1:N) relationships. The ...
-3
votes
0answers
20 views

Creating views and stored procedures on my sql server [duplicate]

I have two questions: Please can you help me write thos query on my sql server 1.) Create a view that is named latest release that contains CD title, artist and price for all CDS that were released ...
1
vote
1answer
33 views

Changing the owner of a read-only database which is configured with Log Shipping

Is there a way to change the owner of a read-only database which is configured with Log Shipping without actually re setting up LS? Per this link it's not, but I'm checking if anything has changed ...
0
votes
1answer
42 views

Merge jsonb objects and sum their values over multiple rows

I save visits to my database. In my database I have a table with aggregations of visits called visits_agg. This table has one row per hour per hostname. Both are fields in the table which will be used ...
0
votes
0answers
10 views

Sum(JSON_EXTRACT) MariaDB 10.3.11

I'm looking so long, and cannot find anything right concerning - ho to sum the values from JSON column. My values in the column looks like this: [{"file":"FILE.doc", "POSITION":"3245", "NUMBER":"...
-3
votes
1answer
26 views

Hi all, I am not getting the proper result set as shown below [closed]

There are two tables tbl_sales_hdr and tbl_sales_ftr. I am struggling to get the results as shown below. Please help me to arrive at this kind of result set. tbl_sales_hdr date inv_no ...
1
vote
2answers
64 views

Insert missing dates within table

I have a table with a column for ID, Date and Frequency of occurrence for that particular date and ID. ID date Frequency 1 2014-05-18 5 1 2014-05-19 4 1 2014-05-20 ...
-2
votes
0answers
22 views

MongoDB Model for Logging Microservices [closed]

What is the recommendation for create a mongodb schema for full micro services logging trace, i should have high capacity for recreate a trace between services.
5
votes
0answers
56 views

Do I need a “downtime” to update a stored procedure? (Due to “definition changed” error)

I always thought that updating a stored procedure was something I could do while users were actively using the system. But I am currently testing out an update to a stored procedure and while a long ...
1
vote
1answer
31 views

Update rows in table with id from row before in PostgreSQL

Say I have a table like this: | id | grp | time_added | previous_id | |----|-------|------------|-------------| | 1 | 1 | 5 | null | | 2 | 1 | 8 | null | | ...
0
votes
1answer
15 views

how to remove Mariadb temp files

I have a /mariadb_tmp directory (as specified in my mariadb-server.cnf) which is filled with files dating back to last November. -rw-rw---- 1 mysql mysql 1032192 Nov 19 07:47 #sql899_5d5_0.ibd -rw-...
1
vote
1answer
21 views

Streaming replication archive folder taking all space- Postgresql- 9.4

We had recently setup postgres streaming replication between master (physical, CentOS release 6.6) and slave(virtual, CentOS 7.6). We did the test and streaming replication is working fine. We ...
1
vote
0answers
20 views

ODBC from Win10 32bit client only connects using IP address, but not using hostname

I'm experiencing a pretty strange problem. We're using a MS SQL based quality assurance software. The database is hosted on a MS SQL 2016 Std. server running on a Windows Server 2012 R2 VM. Our ...
9
votes
3answers
421 views

Sort spills to tempdb due to varchar(max)

On a server with 32GB we are running SQL Server 2014 SP2 with a max memory of 25GB we have two tables, here you find a simplified structure of both tables: CREATE TABLE [dbo].[Settings]( [id] [...
2
votes
1answer
68 views

Availability Group cluster memory issue after network issues. How to dump HADR Log Block Msg Pool?

We have a four node Availability Group, two nodes in one site, two nodes off site in another data center. I have noticed after every WAN issue where the WAN connection is flapping, and the off site ...
0
votes
1answer
35 views

Common practices to determine what database technology to use [closed]

Supposing I've started a new project that needs a database for persistence purposes. What are common practices to determine which database technology (MSSQL, MySQL, MongoDB, etc...) would best fit ...
0
votes
1answer
37 views

move a database on sql server 2017 with memory OLTP feature [duplicate]

I have a database on sql server 2017 standard edition with in memory OLTP feature enabled, I have to move it on another disk, which is the best way to do it? are there any possible problems? Can I ...
0
votes
0answers
8 views

Change Encryption Wallet type from PASSWORD to AUTOLOGIN

I am currently working on an Oracle 18.3 DB and I have a script which allows me to create an encrypted seed PDB. As part of this script, we encrypt the system tablespaces (like SYSTEM, SYSAUX, and ...
1
vote
0answers
15 views

Cardinality with specialization in enhanced entity-relationship diagrams

I'm currently taking an introduction course to databases and I've come across a problem not described in the textbook. I'm wondering about the use of cardinality with the use of specialization in ...
0
votes
1answer
24 views

How to generate Entity Relationship (ER) Diagram of a on-premises database using Azure Data Studio (macOS)?

I found a similar question for SQL Server Management Studio. But I use latest Azure Data Studio on macOS. We use on-premises SQL Server (not Azure cloud). How can I use Azure Data Studio to generate ...
0
votes
0answers
48 views

Stored procedure or Table Function doesn't return value when parsing XML

Script to create table and function at the bottom of the post: We have lately ran into problem that sometimes our stored procedures or Multi-statement table value that include sql statement parsing ...
0
votes
1answer
31 views

MongoDB 3.6, adding replica set always fails as on production setup with cannot open /dev/urandom Too many open files

I am trying on add a 3.6 mongoDB node to a 3 member replica set running 3.4. Doing this as a part of DB upgrade from 3.4 to 3.6. When I add the new member to replica set, it goes to STARTUP2, data ...
1
vote
0answers
19 views

MS SQL Server 2008 R2 duplicate key row in object 'sys.syscommittab'

I have a server that is failing to backup due to an error with the syscommittab and have gone through everything in this question: SQL Server 2008 unable to backup due to Failed to flush the commit ...
1
vote
1answer
31 views

How can I make SQL Server Agent job history available after failing over an AG?

I am implementing a new HA/DR architecture using Always On AGs for use in both a HA a DR scenario. I have mastered a mechanism to ensure that jobs are disabled on the secondary replica and enabled ...
1
vote
0answers
31 views

Restrict postgresql's public schema's tables visibility in tableua

My requirement is to display only one particular table or materialised view when user give db_host, db_port, db_name, db_username, and db_password to tableau. Currently tableau is showing all the ...
1
vote
1answer
32 views

What will happen to SQL Service Account when SQL Server is uninstalled?

We are planning to downgrade from Enterprise/Standard version of SQL Server to Developer Edition. We will move the existing system and user database to the Dev Edition. Are we going to need to ...
6
votes
2answers
218 views

How to get the ignored row while IGNORE_DUP_KEY is ON on SQL Server?

I have a tmp table shown below. In the above table IGNORE_DUP_KEY is set to ON and the id column is the primary key. Said table has only one key. After inserting lots of data I will get the ...

15 30 50 per page