All Questions

0
votes
0answers
2 views

mysq: trigger not firing after LOAD DATA command

I have this very simple trigger on mysql 5.7 delimiter $$ create trigger update_bugs_stats after insert on bugs for each row begin insert into `jira_statistics`.`new_table` VALUES (UNIX_TIMESTAMP())...
0
votes
0answers
16 views

Can we find who killed a SQL Server process?

I am using SQL Server 2012 Enterprise Edition. We are running SSIS package which usually take more than 5 hours to complete execution. Some time we find that the transaction is being killed by someone ...
0
votes
0answers
5 views

It's possible to avoid overload on a Mysql slave by slowing down replication?

I have a slave on a machine less powerful than the the master (8CPU/8GB on the master, 2CPU/4GB on the slave, MySQL 5.7). Replication is binlog ROW based As the db is increasing on the master, the ...
0
votes
1answer
12 views

Is there any function like checksum in Oracle

I need to calculate the checksum of some columns. The built-in function checksum is used to calculate the checksum in Microsoft SQL Server. Is there any built-in function checksum in Oracle?
0
votes
0answers
2 views

Mariadb check tables on startup

Is there a way to have mariadb check tables in the background and not lock the tables after a crash? We have a number of fairly large databases and suffered a hardware failure that resulted in most of ...
0
votes
0answers
9 views

Postgresql: Select a table from different database and different host

I know this is not new, but I have not found a solution, even though I have followed several posts in this forum. I'am trying to show table from different database using dblink extension. Installing ...
0
votes
0answers
6 views

How to perform Code migration from production to development/ testing in Sql server

How to perform Code migration from production to development/ testing in Sql server. can anyone explain the steps
0
votes
0answers
12 views

Oracle uses a lot of memory

OS: Windows Server 2012 DB: Oracle11g-r2 When you restart or turn on the server, everything works perfectly, the memory is normal, the number of sessions, too. But after 2-3 days of continuous ...
0
votes
1answer
21 views

SQL Server mistaken update rows without backup

I did a mistake UPDATE query yesterday. Database engine is MSSQL and the version is 2017. I have not any backups. All I have is the database itself. Do you know any ways to redo my modifications to ...
0
votes
0answers
8 views

MongoDB count() query returns outdated result in mongo shell / python script

Documents in my MongoDB collection are changing status field very frequently. I can observe it using a mongoDB client (Robo 3T). Now I'd like to monitor this process using mongo shell (or python ...
0
votes
1answer
21 views

TSQL SELECT statement to list a column calculated based on the value of a field

I have a table named Table1, with three fields Project ID, EmployeeID, Starting Date. Need a select statement to list all columns of the table, and an additional column to show the number of project ...
0
votes
0answers
4 views

what are Oracle applications examples? Is Peoplesoft or JDE applications of Oracle?

Kindly wrote some names of Oracle application? what are Oracle applications examples? Is Peoplesoft or JDE applications of Oracle?
0
votes
0answers
10 views

“Resource deadlock avoided during COMMIT” when a node leaves the group

I believe it's a bug in MariaDB Galera (10.3) but wanted to confirm. I have 3 nodes in the cluster (A, B, C) and a sysbench running the OLTP write-only test connecting only to node "A". When the node "...
0
votes
0answers
8 views

How to remotely manage (with PhpMyAdmin) a MySQL RDS on a load-balanced AWS Elastic Beanstalk setup?

Although there are similar questions and topics, I can't find a solution that currently works. I specifically wrote remotely manage because I'd like to use my home computer's PhpMyAdmin to directly ...
0
votes
1answer
10 views

Possible to update rows with data only accessible via API call?

I'm not good at what I'm working on so apologies if some of my terminology is off. Also not sure if this belongs here, or in a more programming oriented area. I am looking for options to update ...
0
votes
0answers
10 views

Postgres Backup fails with: pg_dump: could not fsync file: Bad file descriptor

I am running Postgres 11 on Windows 10 and this should be my last backup before moving to Linux: "C:\PostgreSQL\pg11\bin\pg_dump.exe" -U postgres -h localhost -p 5432 --verbose --jobs=4 --format=d --...
0
votes
0answers
6 views

replication type of dynamodb

What is the replication type of the DynamoDB system? Like is it master slave, peer to peer, multi master, or something else. I know that that for global tables, DynamoDB has cross replication with ...
0
votes
0answers
15 views

Creating a relationship for a database model based on that model's date range

I have a database of Schedule objects in PSQL (schedule_id, user_id, date_range ( [date, date) ), and a few other fields not necessary for this discussion). Each of these Schedule objects is ...
0
votes
1answer
14 views

How to get useful error information from mysql command?

I'm trying to script the creation of a database with tables. I'm encountering errors but the error messages are not helpful to me because I'm a novice. I'm finding the mysql tool is providing mostly ...
2
votes
0answers
43 views

Can't import flat file into SqlServer

I've got this tab-delimited flat file with fifty columns and two million rows. I am trying to import it into Sql Server 2017 Express. (I first tried working with it in Excel... hopeless.) I see two ...
3
votes
2answers
271 views

Difference Between a Staging and the Production DWH

I have a general question on a Data Warehouse Architecture. I have heard a lot of a Staging and a Production, so that data should be loaded via SSIS first into a staging dwh and then via SSIS to the ...
0
votes
1answer
8 views

Changing location of binlog prevents starting up

I've copied data/binlog files between MariaDB (10.3) instances and wanted to change the location of data/log files on the new machine. I adjusted the paths in the my.cnf file. On start on the new ...
0
votes
0answers
17 views

Static Data Masking does not appear in SSMS 18 preview 6

I installed SSMS version 18 preview 6 and am using it with SQL Server 2017. I want to test the Static Data Masking feature, but the option does not appear.
0
votes
0answers
6 views

DB Structure and Search with weighted ratings

Let's assume the following structure. For each pair of item and category we have a rating (between 0 and 10) item_id | category_id | rating --------+-------------+------- 1 | 1 | ...
1
vote
1answer
46 views

Privileges on SQL Server

I come from Oracle Database and now I am trying learn SQL Server and I don't undestand why may I viewer others databases, like the master for example, with a common user without privileges in this ...
0
votes
0answers
4 views

How to display duplicate records or data in my database using PHP code

How to display duplicate names in a record using PHP Sample Table DB table NAME MID NAME ADDRESS David Kidfu y.com David Kidfoe you1@yahoo.com Mike Kidfu ...
0
votes
0answers
2 views

Any correct procedure for couchbase backup and restore?

I have just started using couchbase server and trying to configure backup and restore method. We require to take backup for each couchbase node or cluster backup also available ?
0
votes
2answers
23 views

DB2 multiple rows with the same value

This is my first time posting in stackexchange, and I hope I did my due diligence for this question. I'm working on a problem that I just can't seem to wrap my head around. Consider this scenario of a ...
-3
votes
0answers
24 views

How to write a query for ATM transactions

Mr. Ali and Mr. Adnan singed a deal and by which Mr. Ali has to pay 50,000 to Mr. Adnan and he wanted to transfer by ATM machine, you are required to write a procedure for ATM machine which make a ...
0
votes
0answers
9 views

os kernel parameter semmni failed: expected 128 found 0

I am trying to install Oracle 11gR2 on oracle linux 7. As per the documentation given in https://oracle-base.com/articles/11g/oracle-db-11gr2-installation-on-oracle-linux-7 there i think i have ...
0
votes
1answer
32 views

How To get value of column when it exist in content value of column by sql server 2016

I want To get value of column when it exist in content value of column by sql server 2016 For Example: Table1: Title1 ---- Jack Benz Volvoo Table2: Description Names ---- ...
0
votes
1answer
14 views

Migrate complete postgres database cluster to another machine using pg_dump

I am referring to How to get a working and complete PostgreSQL DB backup and test In this example/solution, which part of the restore process does actually the "CREATE DATABASE sandbox"? I have been ...
0
votes
0answers
25 views

A transport-level error has occurred when receiving results from the server. Error 10054

I have been using SQL Server & Azure for almost two years with Zero problems. Now for some reason I am getting the following error when I try to connect to my Azure database from SSMS. I have ...
1
vote
2answers
11 views

pg_resetxlog command not found

I can't find pg_resetxlog under /usr/bin. postgres (PostgreSQL) 10.7 (Ubuntu 10.7-1.pgdg16.04+1) cd /usr/bin postgres@node-1:/usr/bin$ ./pg_resetxlog -su: ./pg_resetxlog: No such file or directory
0
votes
0answers
17 views

steps for write ahead log protocol

What are the steps for write ahead log protocol? I know these are the steps, but I don't know the order they occur in. a. Updated data is persisted on disk. b. Data is updated in memory. c. The ...
0
votes
0answers
15 views

RDS MySQL read replica larger than master

We have a Multi AZ AWS MySQL 5.6.40 server with a matching single AZ read replica. Both have 200GB of storage available. However, the read replica is rapidly running out of free storage space, while ...
0
votes
0answers
16 views

mariabackup --prepare after copying to slave

Hi dear community of smart people, I'm setting up MariaDB master/slave replication and for the first time I have decided to try mariabackup utility for transferring the full database backup from ...
0
votes
0answers
10 views

Using CONVERT TO CHARACTER SET for changing only collation?

I think the answer to this is an obvious yes, but I'm having trouble finding confirmation on it. All the questions related to charsets seems to be about changing the charset and not only collations. ...
-1
votes
0answers
8 views

How can I get user rank using sequelize? [on hold]

I've a basic table called users which have these columns id xp and I want to have to get user rank.
0
votes
0answers
11 views

Pass parameter to trigger dynamically

I have a table on a mysql 5.7 db, containing say athletes with their mean, max, avg times in a specific sport. I have another table that lists some calculated statistics based on those values. I ...
1
vote
1answer
25 views

SQL Outer Join while conditioning on an extra column

I am trying to pull up an outer join between two tables, on a specifc column "Identifier", however, I would only like to carry out the outer joins on the rows where additional column "Date" matches ...
1
vote
1answer
16 views

calculate days spent of all visitors from encounters

I have an encounters table CREATE TABLE visitors( id serial PRIMARY KEY, start_date TIMESTAMP NOT NULL, -- visitor_id bigint NOT NULL -- skip for now, end_date TIMESTAMP ); (end_date can be ...
0
votes
1answer
22 views

Recalculate and replace large table without interrupting table reads

There's a large table in the database containing statistical information. This table must be read frequently. This table must be completely recalculated every so often. There's a procedure which does ...
0
votes
1answer
34 views

Query with HAVING clause is taking too long

I have query like this: SELECT msg.id, CONTENTS, UNIX_TIMESTAMP(msg.created_at) 'created_at', category, msg.`uid`,name, user_name, profile_pic, STATUS, isNotificationOn, ...
0
votes
2answers
52 views

Restoring more than one .bak files in a TSQL query

Can any one share a script that will allow me to restore all the .bak files in my one folder into SQL Server using a TSQL script?
0
votes
1answer
11 views

How to denormalize many-to-many relation without nested select?

I have the following schema: house has many students, student has one house gender has many students, student has one gender game has many students. student has many games For instance, consider ...
1
vote
0answers
21 views

Database Design for tracking user flow

I want to design a user tracking system between different tables/models. I want to track the user's progress. There is a Module table which is related to sections and sections are related to sub-...
1
vote
1answer
27 views

Relation does not exist while scanning schema

My Postgres database is getting slow while executing some function. But another database of identical design and with more data is much faster than the first one. I have recently migrated data from MS ...
1
vote
1answer
14 views

get average of number of likes in mysql from two tables

let's say I have a posts table: post_id user_id text 1 2 abcd 2 1 wert 3 3 yhj and I have a ranks table: post_id liker_user_id ...
2
votes
1answer
32 views

START WITH and CONNECT BY condition in Oracle SQL

I have a question on the START WITH and CONNECT BY condition (in Oracle 12c): This is my Oracle SQL: SELECT employee_id, lpad(' ', level*2-1,' ') || last_name, manager_id, level, ...

15 30 50 per page