All Questions

Filter by
Sorted by
Tagged with
1
vote
0answers
17 views

UPGRADE PROBLEM: The data files need to be fully upgraded to version 3.4 before attempting an upgrade to 3.6;

Kindly assist me on following upgrade issue. My Arbiter upgrade (thru yum update -y ) has been failed with following error. 2019-10-19T07:19:25.944-0400 I CONTROL [initandlisten] 2019-10-19T07:19:...
4
votes
1answer
164 views

Why the job's next_run_time is wrong?

I got an issue regarding job stats. So I have a job with the following schedule: Occurs every day every 5 minute(s) between 12:00:00 AM and 11:59:59 PM. Schedule will be used starting on 12/13/2017. ...
-3
votes
0answers
19 views

Migrate VIEWs from Oracle to SQL Server [on hold]

Is there any tool to migrate views from Oracle to SQL Server?
0
votes
1answer
26 views

How to model multiple types of contacts?

I'm not sure if this can be called a polymorphic association - what is needed is to for each Message to have a Sender Contact and a Recipient Contact. Both Sender Contact and Recipient Contact could ...
0
votes
1answer
23 views

Using mysqldump with WHERE clause but WHERE clause only applying to specific table? [on hold]

This question is related to a question I posted on another StackExchange site. Question: How to apply the --where argument only to a specific table when mysqldump-ing a whole database? So I have a ...
0
votes
0answers
7 views

MySQL Server 8.0.18 has failed Windows 10

I am new to MySQL Server. I am trying to install MySQL Server 8.0.18 on Windows 10 laptop. I am new to MySQL, so I have not tried anything other than to install. This is the log file: Beginning ...
0
votes
1answer
19 views

Computed Column Operand type clash on Date Column When Checking For Null

This error is generated when trying to create a table with a computed column from a Date field. Operand type clash: int is incompatible with date If I comment out the computed column it works. [...
-4
votes
0answers
21 views

Database for Shipping Company [on hold]

To do database in SQL server for Shipping company .. So I need employee page to insert the shipment information then press ok and auto generate track number .. I will give to customer and he can press ...
-3
votes
0answers
43 views

How can I merge multiple rows from a table into one row with certain relations?

When creating a WordPress opensource plugin the following question arises. In Wordpress, different data types are stored in a table, wp_posts. These data types (CPT => CustomPostType) are ...
-2
votes
0answers
20 views

Combine two tables with 2 PK - Table 1 has the column (id12) that holds data for Table 2 column (sub_obje_id) [on hold]

SELECT COUNT(id12) AS PROG_AREA FROM [dbo].[header_record] INNER JOIN dbo.header_record.id12 = dbo.object.sub_obje_id ON (SELECT pool_id AS 'Pool', CASE WHEN sub_obje_id = 4104 THEN 'TV Script' WHEN ...
0
votes
0answers
15 views

Mongo primary failover causes rollback

I have a replicaset that processes largish batches of inserts (a few million) every night. Last night, the primary failed over and went into a rollback state. All clients which access this replicaset ...
-2
votes
0answers
25 views

Nested select statement work procedure [on hold]

I was wondering how nested select statement works. Let me be clear with an example(with an academic example). According to Database system concept of Silberschatz I am using an university database. ...
1
vote
2answers
49 views

Is it possible to write a function in postgresql which directly writes its parameters to a text file?

I have a text file which contains some rows of data,say 10 rows. Each row has 5 columns, each of the type varchar. Is it possible to write a function in postgresql, which takes its parameters as 5 ...
0
votes
1answer
21 views

How to connect two attributes without a PK (MySQL)

I'm a new programmer and I'm doing a database on MySQL with phpmyadmin. I have this doubt - I know that if you want to link two different tables you need an attribute that is a Primary Key, and ...
-4
votes
0answers
30 views

SQL TEST ASSISTANCE [on hold]

Disregard, i will come back with additional info
0
votes
1answer
25 views

GROUP BY with date ranges when values change but then change back

Consider a historical table where a value was changed and then changed back: value | date 3 | 1/1/2019 3 | 1/2/2019 3 | 1/3/2019 4 | 1/4/2019 4 | 1/5/2019 3 | 1/6/2019 3 | ...
-4
votes
1answer
21 views

MySQL returns more than one row with AND operator match

I have two tables 1:n relationship, customer to orders the schema is in the http://sqlfiddle.com/#!9/a6842e/1 I have created. The key in customer is composite id and type. I am trying to get the ...
0
votes
0answers
27 views

Storing 450,000,000,000 data points in a bitemporal datastore [on hold]

I'm really looking for guidance on an appropriate way to tackle persisting and retrieving 450 billion data points. The details: 15,000 equities 15,000 days of history (approximately 40 years) 2,000 ...
1
vote
1answer
21 views
+50

Does postgres single-user mode use postgresql.conf settings?

Does running postgres in single-user mode (--single argument) cause postgres to start and use the settings present in the postgresql.conf file in the data directory defined by the -D option? I am ...
0
votes
1answer
66 views

Without rewriting this query, is there a way to force the query optimizer to better estimate the amount of resources required, e.g. with query hints?

I know there's a couple of alternate ways to write this query, but I'm more curious if there's another approach that I could use to improve the performance by helping guide the optimizer in the right ...
1
vote
1answer
38 views

Restore plan cache and buffer pool after database restore? [duplicate]

When restoring a database, is there a way to restore the plan cache so it doesn't have to be re-created during production use? Similar question: is there a way to pro-actively restore the buffer ...
0
votes
2answers
34 views

How to add time from a Date value to another without a varchar conversion?

Let's say I have 2 variables in a Stored Procedure, both are Dates Foo contains '13/10/2019 00:00:00' Bar contains '01/10/1914 16:33:11' I want to add Bar's time to Foo's date, so that I get a ...
-1
votes
2answers
59 views

Is there a way to increase the speed of the following insert without having to create an unclusterd index being suggested by sql server? [on hold]

Below is a query that we are running that takes a while to run. Table 1 has about 400+ million records with 80 columns (this is a db warehouse table). The index being suggested is on the columnx with ...
0
votes
0answers
35 views

How can I import the fga_log$ table with impdp Oracle 12 R1

I am trying to import with impdp a save made as follows: expdp '"sys/mmm as sysdba"' full=y COMPRESSION=ALL DIRECTORY=LOGICS_EXPORTS COMPRESSION_ALGORITHM=BASIC LOGTIME=ALL CONTENT=ALL DUMPFILE=FULL-...
0
votes
0answers
10 views

Analyze Table running constantly on a few tables

I am seeing a few of my tables constantly having analyze table running on them. How would I determine what would be causing or triggering this and is there a way for me to stop that from running? It ...
0
votes
0answers
25 views

Postgresql v10.1 - How to fix ERROR: duplicate key value violates unique constraint

I'm not sure how this happened to this table but have an issue with ERROR: duplicate key value violates unique constraint trying to use AWS's DMS service to move a postgres v10.1 DB to RDS v10 The ...
2
votes
2answers
52 views

Permissions using a TYPE as a Table Valued Parameter

I'm developing a .Net App that calls an stored procedure that have a table valued parameter declared as a TYPE READONLY. First time I tried to call the SP I received the next error: Msg 229, Level ...
0
votes
1answer
26 views

Insert set value into DB

I'm pulling values from RESTORE FILELISTONLY FROM DISK for multiple backup files into a temp table. I am trying to insert a set value (@dbSet) to a column (@dbSetC) but when running my insert it's ...
0
votes
2answers
20 views

Select data from table join or UDPATE?

I have a question regarding PostgreSQL DB performance. I am given a CSV file with a lot of rows (let's say around 1 million rows) that represents updates to a database table (let's call it MY_TABLE). ...
1
vote
1answer
32 views

Session ID in SQLCMD running multi-batch script

My script contains multiple GO keywords. I know that SQLCMD interprets GO as a batch delimiter, so the code is not run as a single block but instead each part between the delimiters (a batch) is run ...
-1
votes
0answers
14 views

Can you edit DB content, if you can't access phpmyadmin? [on hold]

I've crashed my domain's DNS trying to enter a DKIM entry to my control panel, now I can't access my domain, my control panel or PHPMyAdmin because they all reside on my domain. Is there a way I can ...
0
votes
0answers
35 views

Recommended ways to export large query result to JSON or other text format [on hold]

I am tasked with exporting a settings query result to a text file so it can be imported on other machines. I have a working solution in a WPF project however the problem is that the results are 28K+. ...
2
votes
1answer
39 views

UPDATE column to MIN of a SELECT result set - what went wrong?

I've got the following scenario: I've got a table of assets with standard columns a table of hardware assets with extension columns a history table where all changes to an asset are stored with ...
0
votes
1answer
34 views

Can we copy data from 1 text file to 2 postgresql tables?

I have a text file with some data and I have two similar tables in my postgresql database. Is it possible to copy a part of the data present in the file, say first 10 lines, to the first table and the ...
4
votes
3answers
292 views

SQL log file 2TB is not enough, now what?

This is a hypothetical question, that flows from the answer by sepupic where they explain that 2TB is the physical limit for SQL log file. if you need it more than 2Tb you add the second log file. ...
0
votes
0answers
12 views

what to pass as a key instead of username and password for anonymous users @login?

i am trying to make a mongodb schema in which i am allowing the person to publish projects anonymously, i already have the authenticated user schema and i am thinking of using that only to allow ...
2
votes
1answer
38 views

what could be preventing my transaction log autogrowth to be set to UNLIMITED?

I have been trying to set the autogrowth of one of my databases to unlimited but despite whatever I do it remains the same. First thing I have checked if something is holding any locks to my database:...
-1
votes
1answer
21 views

How to sync data between two databases on two different ms sql server instances - one 2008 and the other 2016

What is the easiest way to sync data between two databases on two different instances. I am not thinking replication. Just sync e.g. production database to test database from time to time.
0
votes
0answers
14 views

Is it possible to join on column placeholders?

I have a query below in which i was wondering whether it is possible to join on my placeholders and if so are my joins in my CTE's correct? WITH DCM AS (SELECT date, placement as creative, SUM(...
1
vote
1answer
18 views

Postgresql Master/Slave Using Patroni

Can i promote a slave node to be a master for insert/update/delete using postgresql-patroni once the original master become down?
1
vote
1answer
24 views

Oracle Database 11g Failing to mount on windows server 2012

I have an Oracle 11g database installed on Windows Server 2012. It's failing to mount after shutdown. The reason why i want to mount it is that i want to enable Archive log mode, and i have been able ...
0
votes
1answer
13 views

Use plpgsql to count records selected for output AND output those records

My query SELECTs 1 row from table1, which has a number of fields plus one very long text field. It JOINs with a second table2, that may have many matching corresponding rows. I would like to be able ...
0
votes
1answer
50 views

Restructuring table - start with PK or not?

I am restructuring a bunch of tables in my database (in this case using a smaller data type for some columns - in most cases cutting those by ~50%, and they tend to be large columns). I've gone ...
1
vote
2answers
25 views

How can I have an aggregate function in the WHERE clause?

Using PostgreSQL 9.3.24 Issue Just simple operation, but I don't know how to do that best simplest way. How can I display results only when sum of available_counts for same product_id is 0 and ...
0
votes
0answers
18 views

Can copy command in postgresql append data to a file? [duplicate]

I want to add some data from a postgresql table to a text file. But already some data is present in the file. I do not want to delete that data. Is it possible? The questions asked earlier were the ...
0
votes
0answers
10 views

MongoDB - Setting up the MMS Automation Agent

I am currently trying to set up a testing environment that includes 3 MongoDB database deployments and one server with an installation of the MongoDB Ops Manager. I succesfully installed the MongoDB ...
0
votes
0answers
44 views

AG lag / high Redo queue issue [on hold]

I am having issue with Availability Groups, the Redo Queue Size on secondary server increases for some reason and after restart of secondary the queue syncs. The AG stays healthy for week or two and ...
-1
votes
0answers
47 views

Incorrect syntax near the keyword 'CASE' [on hold]

When I ran my procedure, it got created successfully without any error. But when I try to execute it, I am getting an error. Error in executing bspCDRExtract in bspDynamicCDRExtract. Details: ...
0
votes
1answer
19 views

Serialize a column based on sorting order?

I have a column number_order and products_name I'm struggling to build a command that will sort by A-Z so that respectively: A = 1 B = 2 C = 3 I'm using MariaDB. To be clear I want to run a command ...
0
votes
0answers
14 views

Environment variables for Oracle OPAM 11g

Is there a way to set environment variables when logging through Oracle OPAM 11g to #OPAMSH console? Prior to OPAM integration, environment variables are set through a logging script where a question ...

15 30 50 per page