Newest Questions
105,288 questions
3
votes
0
answers
39
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.2k
1
vote
0
answers
13
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
0
answers
33
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
24
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
63
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
16
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
22
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
17
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
40
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
105
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
1
answer
13
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: ...
- 173
-1
votes
0
answers
33
views
Database normalization confusion: Which table should I normalize first?
I’m designing a database for an online clothing store, and I’d like feedback on my schema. Which tables require further normalization, which ones are already well-normalized, and are there any design ...
0
votes
0
answers
20
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
22
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
46
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
27
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
0
votes
1
answer
17
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
0
answers
41
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
19
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
77
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
62
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
220
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
41
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
27
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
77
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
49
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
50
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
369
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,322
0
votes
1
answer
22
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
55
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
-2
votes
0
answers
48
views
FOR XML PATH, subqueries, sequential ids [closed]
I'm trying to plug a new vendor into an existing workflow process. The old workflow weaves between external programs and Sql Server, and the output of one of the phases is an xml document. I'm trying ...
- 377
0
votes
0
answers
18
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
0
votes
0
answers
38
views
Kitchen Sink Pagination - How to avoid recompiles or bad estimates when materializing intermediate result sets (temp table vs table variable vs CTE)?
I have a high-traffic SQL Server stored procedure that runs thousands of times per hour. The procedure loads a filtered set of “projects” for a user, identifies the “active task” for each project, ...
- 821
-1
votes
1
answer
43
views
Access denied for user to a database?
A user I'm supporting is getting the error. The user has grants to various tables in mydb, but when he tries to access them, he gets the error:
Access denied for user 'myuser'@'myhost' to database '...
- 147
0
votes
0
answers
23
views
Designing scalable sensor data storage: wide table vs single table per sensor in DolphinDB
I'm designing a system to store large volumes of sensor data (10,000+ sensors) and evaluating different schema approaches in DolphinDB.
Current Context:
Data Volume: 10,000+ sensors, continuous time-...
- 1
-2
votes
1
answer
30
views
Why am I getting a syntax error running the same code via openrecordset vs. direct connection to remote server
I've got two queries i need to run via remote server connection. They run fine if I run them by connect to the remote server FIRST, but if i use the openrecordset to run it from the command line, and ...
0
votes
0
answers
29
views
SQL Server replication is in "Performance critical" status persistently
I have multiple publication in the sql server with
SQL Server version: 2017
Transactional REplication
Distributor and Publisher are in the same server
Subscriber is on the different server
Also:
9 ...
- 111
1
vote
1
answer
32
views
Granting Monitoring privileges to a user in PostgreSQL
I am creating a new user and granting them the pg_read_all_stats privilege so they can monitor all pg_stat_* views. However, when I monitor pg_stat_activity through this user, other users' operations ...
0
votes
0
answers
12
views
Setting up Cassandra with PEMBasedSslContextFactory results in configuration error
I followed the guide for setting up client to server encryption with the PEMBasedSslContextFactory for Cassandra at https://cassandra.apache.org/doc/stable/cassandra/managing/operating/security.html#...
- 101
0
votes
1
answer
45
views
Unable to restart PostgreSQL after automatic shutdown
My PostgreSQL server has unexpectedly shut down.
In the log file (postgresql-Wed.log), I can see the following:
2025-11-12 18:18:54 LOG: received fast shutdown request
2025-11-12 18:18:54 LOG: ...
- 1,843
0
votes
0
answers
33
views
PostgreSQL logical replication failing with "permission denied for schema" despite operating as the superuser
On a PostgreSQL 14 database, I've got a logical replication publication of 108 tables across 10 schemas. For some unknown reason, the subscriber fails to replicate tables in one of the schemas (call ...
- 175
-1
votes
1
answer
52
views
Couldn't import excel file in my SQL(SSMS) but the "IMPORT" and "EXPORT" are greyed or faint that it can't be clicked on
I have created my Database,then highlighted the database and right-clicked ,then TASK and to IMPORT but both IMPORT and EXPORT are faint.
- 1
0
votes
1
answer
37
views
Monitoring PostgreSQL Copy Operations
To monitor Copy operations in PostgreSQL in real-time, I use the “pg_stat_progress_copy” view tool:
Here, I specifically want to analyze the number of tuples processed by the command, which is “...
0
votes
0
answers
13
views
How commitlog_sync works with direct I/O?
If I set commitlog_disk_access_mode: direct - what's happening to commitlog_sync? It sounds like now I get something close to batch option?
- 1
0
votes
1
answer
38
views
SQL Server encrypting backup with a certificate failed with "Cannot find server certificate with thumbprint..."
Here is my demo code:
USE master;
GO
IF NOT EXISTS (SELECT * FROM sys.symmetric_keys WHERE name = '##MS_DatabaseMasterKey##')
BEGIN
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'StrongPassword123!';...
- 2,126
0
votes
1
answer
69
views
How can I find the source (hostname, etc.) of one Azure SQL Database query using Extended Events without having to capture every statement?
I want to do this, but there doesn't seem to be a supported way to do it. What is a version that would work?
CREATE EVENT SESSION [MySession] ON DATABASE
ADD EVENT sqlserver.sql_statement_completed(
...
- 2,295
0
votes
1
answer
30
views
PostgreSQL:Why promoting standby while primary is online causing WAL fork?
I have been testing PostgreSQL 17 AYSNC replication and failover on Ubuntu VMs. Suppose I have two VMs: A as the primary and B as the standby. If I promote B while A is offline, and later configure A ...
- 700
4
votes
1
answer
131
views
How can I tell which tables, indexes, or pages do not have checksums?
This time last year, I set the page_verify database option to checksum on a very old and very large database. We do weekly index maintenance, so I hope that most of the database's pages have been ...
- 1,322
1
vote
1
answer
14
views
decommissioned node still stuck in metrics
Need some help with our Cassandra 4.1.3 operation.
We successfully decommissioned a node in remote datacenter by first “ALTER KEYSPACE” with remaining datacenter, then “nodetool decommission”
nodetool ...
- 11
0
votes
0
answers
26
views
Transaction applied partially after failover in postgres
We noticed a data inconsistency in a 3-node asynchronous replication Postgres setup.
A single JDBC transaction inserted/updated rows in two tables but we are noticing that one table did not have a few ...
- 1