Newest Questions
105,295 questions
0
votes
0
answers
5
views
How to upgrade cluster from Postgres 17 Windows to Postgres 18 Debian
Postgres 17 cluster is in Windows server in Estonian locale. Databases are defined like
CREATE DATABASE mydb
WITH
OWNER = mydb_owner
ENCODING = 'UTF8'
LC_COLLATE = 'et-EE'
LC_CTYPE ...
- 123
0
votes
0
answers
6
views
After recovering from session timeout expiry, at what point does the primary start waiting on synchronous replicas to harden?
The documentation tells us what happens when session timeout for a synchronous Availability Group replica expires
"Even if a disconnected replica is configured for synchronous-commit mode, ...
- 1,360
0
votes
0
answers
30
views
MySQL comparing a string to int returns a wrong result when string is numbers seperated by -
Apologies if this is a duplicate question but I was unable to find the correct result but that could be down to the phrasing of my question but here goes.
I have a table with BIGINT primary keys. I ...
0
votes
0
answers
26
views
Are constraints(foreign key)errors being logged on the server side (MySQL 8.0.39)?
Are constraints (specifically: foreign key) errors being logged on the server side (MySQL 8.0.39)?
The question arose because there was a migration problem and the number of errors exploded on the ...
0
votes
1
answer
44
views
What is the name/abbreviation of the PostgreSQL dialect and how to highlight it in Markdown?
Question
I know TSQL is the SQL dialect of Microsoft dialect. However, I failed to find an equivalent for PostgresSQL. Thus I ask, what is the name/abbreviation of the PostgreSQL dialect?
My initial ...
- 103
0
votes
0
answers
12
views
Massive import of blob files in SQLDeveloper
I'd like to know if there's some way to do a massive import of blob files in SQLDeveloper, indicating such blob files in the file system and how it would have to do the import
Right now, it looks that ...
- 145
0
votes
0
answers
17
views
How to build dynamic configuration for maxscale to upload it to Galera DB cluster
I need to configure for 1 maxscale, then upload the configuration to Galera DB Cluster of 3 nodes.
Maxscale nodes added later will pull the configuration from the Database cluster, not synchronize ...
Sơn Nguyễn
0
votes
1
answer
24
views
Why does loading plugins fail with "cannot open shared object file" on an ARM-based Linux VM?
I am running DolphinDB Server (version 2.00.16.4) on a Linux virtual machine on my MacBook (Apple Silicon / ARM architecture).
When I try to load the MySQL plugin, I encounter the following error:
...
1
vote
1
answer
45
views
SQL Server Profiler 22 won't open on ARM
After installing SQL Server Profiler 22, I get the following error when opening the application?
---------------------------
PROFILER.exe - System Error
---------------------------
The code execution ...
- 2,708
3
votes
0
answers
45
views
Does partitioning allow filegroups with LOB data to be shrunk?
It is extensively documented that shrinking any data files that have LOB pages is awful:
Microsoft says you need to read the whole partition once for every page you want to move.
The well-known ...
- 1,360
0
votes
0
answers
5
views
How do I convert RoleIds list from Secodary_role_stats in the query_history view to role_names?
I am trying to confirm a particular role is not in use before I delete it. The query_history view supplies the name of the primary role; however there's a chance it might also be in use as a secondary ...
- 101
0
votes
0
answers
38
views
SQL Server Express programmatic installation gets stuck at "Installing..."
I'm trying to do an automated installation of SQL Server Express via powershell, aided by chocolatey.
First, I install chocolatey using the following PowerShell snippet:
Set-ExecutionPolicy Bypass -...
- 101
3
votes
1
answer
145
views
Does SQL Server have a mechanism to recover from torn page writes like PostgreSQL's full_page_writes?
I am comparing how PostgreSQL and SQL Server protect data pages from torn writes.
PostgreSQL has a feature called full_page_writes.
On the first modification to a page after a checkpoint, PostgreSQL ...
- 1,563
0
votes
0
answers
15
views
Oracle Database 11g refresh group
--EN
Hello. Oracle Database 11gR2.
There are two Refresh Groups: RG01 and RG02. Both refresh groups use the same database link. RG01 contains non-updatable materialized views, while RG02 contains ...
- 1
1
vote
1
answer
38
views
Is it possible to use scientific notation to display large numbers in psql?
I have tables with very large numbers, which are entered using scientific notation (e.g. 1e100). But when in the PostgreSQL's psql client (as of 18.x), they get expanded into the full length:
# SELECT ...
- 3,850
0
votes
0
answers
34
views
SQL AG with Windows Server 2025 Fail-over cluster
I wonder if anyone is up-to-date with the workings of Fail-over cluster in Windows Server 2025.
Since each version has their changes.
We are doing a test setup of 3 nodes on 1 location, 3 nodes on the ...
- 1
0
votes
0
answers
14
views
Problem when importing a dmp file in SQLDeveloper
I'm trying to import a dmp file in my database, so far this is the steps I've followed in a guide about how to import a dmp file in SQLDeveloper:
Open SQL Developer and connect to your database.
Go to ...
- 145
0
votes
0
answers
18
views
Configure Postgres to listen to VRF interface
I'm looking into Linux VRFs i.e. support for virtual routing and forwarding.
The documentation mentions:
Applications that are to work within a VRF need to bind their socket to the VRF device:
...
- 101
0
votes
1
answer
44
views
Datanode startup failure: Failed to unmarshall scheduled job (Invalid message format)
I encounter a startup failure when initializing my DolphinDB node. The error message points to a scheduled job deserialization issue:
:Failed to unmarshall the job [schedulejob1]. Failed to
...
- 3
0
votes
0
answers
30
views
Problems connecting with oracle through the mongodb-relational-migrator
First time asking a question here.
I'm making an assignment for my database class where I need to migrate a few tables from an OracleDB relational database to a MongoDB database using the mongodb-...
- 1
3
votes
1
answer
155
views
Querying sys.databases in a peculiar way results in "transport-level error has occurred when receiving results from the server" error
On three different production servers, the following query against sys.databases:
USE master;
GO
SELECT name
FROM sys.databases
WHERE name NOT IN ('master','tempdb','model','msdb');
Results in this ...
- 33.3k
1
vote
0
answers
23
views
How does GridDB ensure read consistency when a TimeSeries container expands its partition during high-frequency writes?
I'm evaluating GridDB Cloud for a high-throughput IoT workload and encountered behavior that I can’t fully explain using the available documentation.
I have a TimeSeries container using default ...
- 51
1
vote
2
answers
100
views
MSSQL Performance gain when clearing out (large size) filestore-table records?
On MSSQL (our DB size is 520g), there is one filestore table that holds tons of files. 65-70% of this 520g is sitting in there. So essentially, it's a 200g database with 320g worth of files in this ...
0
votes
1
answer
29
views
Oracle: Insufficent privileges when compiling a stored procedure as DBA role
I'm complining a stored procedure as user with DBA role. The stored procedure contains several "DELETE" statements. For each of them I'm getting:
PL/SQL: SQL Statement ignored
PL/SQL: ORA-...
- 221
5
votes
0
answers
139
views
Could BEGIN/END really be used inside CASE in SQL Server 2005?
The (still online) documentation for MS SQL Server 2005 states that BEGIN...END blocks can be used within CASE when it needs to execute a sequence of statements:
The BEGIN and END statements are used ...
- 692
0
votes
0
answers
19
views
The flow table exceeded its length and was not automatically deleted
The flow table exceeded its length and was not automatically deleted. The speed of writing quotes to DolphinDB is about 10,000 lines per second.
dolphindb code:
colNames = `securityid`date`time`...
-2
votes
0
answers
26
views
流表超出长度没有自动删除The flow table exceeded its length and was not automatically deleted [closed]
建表代码
// pub_shl2_rapid
colNames = securityiddatetimelocal_timequote_typemarketprecloseopenhighlowlasthighlimitlowlimitiopvtotal_volume_tradetotal_value_tradeask_pricesbid_pricesask_volumesbid_volumes
...
0
votes
1
answer
25
views
Is there a "shutdown script" equivalent to startup? Need to export stream table data before container stops
I'm running DolphinDB in a Docker container and restarting the container daily (creating a new container each time). My core requirement is:
Export data from regular stream tables (non-persistent ...
- 3
1
vote
2
answers
59
views
Safe process to update production data?
We have multiple webshops with 500.000+ customers, it sometimes occur data becomes faulty due to a bug or a failed import. We currently fix this by executing queries correcting the data directly on ...
- 73
3
votes
1
answer
132
views
MERGE causes unique constraint violation when source contains key multiple times
Given two tables counter and cnt_source defined like this:
create temporary table counter (key bigint, count bigint);
create unique index counter_key_uniq on counter (key);
create temporary table ...
- 31
0
votes
2
answers
42
views
Monitoring long-running queries in Aurora PostgreSQL
I'm supporting a new system that's going live next month. I'm trying to have PostgreSQL log any long-running (over 1 second) queries to the error log. I've set the following parameters:
log_duration: ...
- 183
0
votes
0
answers
34
views
PostgreSQL 15: pg_largeobject occupies ~90% of storage due to TEXT columns holding OIDs
On a PostgreSQL 15 server we are facing an issue with storage occupied by pg_largeobject table.
During development, the team migrated an application from Oracle but did not handle PostgreSQL large ...
- 3
0
votes
1
answer
31
views
How to properly migrate a single-node DolphinDB instance to a new disk path without metadata corruption?
version: v3.00.3 2025.05.15 LINUX x86_64
I'm running a single-node DolphinDB (Community Edition) instance, and I recently needed to migrate the entire data directory from /mnt/data2/DolphinDB to /mnt/...
- 1
0
votes
1
answer
50
views
MSSQL RESTORE WITH STOPAT doesn't stop
I'm restoring a database for an investigation at a point in time and trying to use STOPAT but it seems ineffective.
The database has a mix of read-write and read-only FileGroups.
I restore the full D, ...
- 129
0
votes
0
answers
32
views
Service Broker Messages Sent Directly To Target Queue
I am trying to set up queues within the same database (on the same server instance). I would like a ProcessStart queue and a ProcessEnd queue. The ProcessStart queue will receive messages with a set ...
- 1,227
-1
votes
1
answer
23
views
Using copying the program directory and data directory of DolphinDB to another machine, any query is empty
After completely copying the program directory and data directory of DolphinDB to another machine, the startup proceeds without errors, and the databases and tables are visible on the web interface. ...
- 1
0
votes
1
answer
71
views
Adding Indexes with type "VECTOR" to Table takes a LOOOONG time
I have a table with around 30Mio entries using around 50GB of space on disk. It is defined as:
CREATE TABLE `embeddings_value_def_default-small` (
`embeddings_def` INT(11) UNSIGNED NOT NULL,
`...
0
votes
0
answers
20
views
Mysql-Documentation mentions "null" alteration to rebuild an innodb-table. Is this feasible and effective for MariaDB as well?
I have a MariaDB of version 10.6.22-18 (Enterprise) and the disk partition bearing the DB has 98% disk utilization.
Hence, I checked whether we have tables with lots of DATA_FREE, and, fortunately, I ...
- 13
2
votes
1
answer
86
views
Stale View Metadata on AlwaysOn Secondary Replica After Table Re-creatio
We encountered an issue with view metadata becoming stale on a readable secondary replica in an AlwaysOn Availability Group. The views on the primary replica worked fine after a fix, but the secondary ...
- 487
-1
votes
0
answers
70
views
Creating a linked Server in SQL 2022
I am trying to create a SQL linked server between two SQL servers.
Logged into SSMS as my domain account, created the linked server with another domain service account on both source and target ...
- 447
2
votes
1
answer
230
views
BULK INSERT from a CSV file not working
I am a newcomer to Stack Exchange who is a beginner self-studying SQL. I need help troubleshooting an issue related to bulk inserting data from CSV files into SQL tables.
Environment:
SQL Express
SQL ...
- 21
0
votes
1
answer
42
views
Modeling Addresses in SQL in Multitenancy Enterprise app
I have a multitenant app where I'm having some trouble modeling the Address tables. It's an Enterprise App so the database is quite big.
Since tenants, users and persons can have N addresses I've ...
0
votes
1
answer
28
views
Difference in SSIS command line
I run a nightly job that compares SQL Agent jobs between AG nodes. On some of the jobs that run SSIS packages, there is a slight difference in the command line tab. The jobs run ok on both nodes but ...
- 53
1
vote
0
answers
85
views
SQL Server Express Master database corrupted tables
I'm helping out someone where it looks like their previous developer stored some data tables in the Master database in SQL Server Express 2014. I don't know if it was to see if one could get around ...
ulysses1904
0
votes
1
answer
51
views
Unable to Delete Database - Chunks Stuck in "Recovering" State
I'm encountering an issue where I cannot properly delete a database because some chunks are in "recovering" state.
Environment:
DolphinDB Version: 3.00.2.4, Single mode
OS: Centos 7.7
What ...
- 3
0
votes
1
answer
58
views
Why does READ COMMITTED allow Phantom Reads in PostgreSQL?
When writing SQL queries against a large PostgreSQL database, I am seeing phantom reads despite setting the transaction isolation level to READ COMMITTED. Can you provide a concrete example of a multi-...
- 13
2
votes
1
answer
377
views
Do canary tables make sense for Availability Groups?
For all HA or DR solutions in SQL Server, I have heard that it is smart to have a table with a timestamp column in each database and to have an Agent Job run every minute to update that timestamp with ...
- 1,360
0
votes
1
answer
25
views
change ownership of output file when run as postgres user or redirect?
I am making a query as user postgres via my current user, xyz. I am returning the results of this query as JSON. I want to save this (huge) JSON into a file owned by my current user xyz. And I do not ...
- 103
0
votes
2
answers
58
views
PLSQL query to return the trackingcodes only if all its cashout_trackingcodes belong exclusively to that trackingcode
I have a table with below structure:
create table TEST_REFUND_CASHOUT
(
f_gdate DATE,
trackingcode VARCHAR2(4000),
cashout_trackingcode VARCHAR2(4000),
cashout_date ...
- 1,502
0
votes
0
answers
20
views
How to draw labeled precedence graph to test for view serializability?
Time | T11 | T12 | T13
--------------------------------------------
t1 | r(x) | |
t2 | | w(x) |
t3 | w(x) | |
t4 | | ...
- 101