Newest Questions
105,298 questions
0
votes
1
answer
26
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
61
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
133
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
45
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
51
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
72
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
87
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
72
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 ...
