Questions tagged [windows]
Operating system produced by Microsoft. Windows is produced in various desktop and server versions. Please also add a version-specific tag like windows-10 if that is relevant to the question.
658
questions
0
votes
0
answers
26
views
ORA-12541: TNS:no listener error when trying to login through WSL to access OracleXE Database
System Details
WSL2 Ubuntu
Oracle Instant Client (Inside of WSL)
OracleXE (Inside of Windows)
I followed the instructions guide from the Oracle Documentation, added the path to the TNS_ADMIN, ...
0
votes
0
answers
58
views
How can I check the current memory management mode for an oracle database instance?
I have a vendor requesting that Automatic Shared Memory Management (ASMM) is configured to a certain threshold for an existing oracle database (version 19c) hosted on a windows box. As usual Oracle ...
0
votes
0
answers
41
views
copying data from database with the same skeleton
I have a database design with the same tables, procedures and all other details on two different servers. Since one of them ran out of traffic, I forwarded the web software project to the other one.
I ...
0
votes
0
answers
19
views
DB2 SQL1052N createing a database
SQL1052N is path not found when running CREATE DATABASE....
But I get this every time I specify a path in the statement, even when the path is there and is created by the same user. The path exists ...
-1
votes
0
answers
39
views
Installing 5.7 on Windows 11, with previous 8.0 install
I'm pretty new to MySQL and here's the sitrep:
We are running a production 5.7 DB that I have been asked to migrate to another DB flavor, so I would like to install 5.7 locally to test run a migration....
0
votes
1
answer
30
views
Can automatic failover occur to a DR node on a different data center if synchronous commit is enabled and other conditions are right
Can automatic failover occur to a DR node on a different data center if synchronous commit is enabled and other conditions are right. I'm asking because we had a two node scenario where a primary node ...
0
votes
0
answers
101
views
Cannot cannot to database using sql developer: a connection attempt failed because the connected party did not properly respond after a period
I am using a windows laptop and installed sql developer version 23.1.0. When I input the connection details for my database I get the following error:
a connection attempt failed because the ...
1
vote
1
answer
28
views
How can I get PostgreSQL to follow up filtering jobs that my FDW ignored?
I'm making a FDW (Foreign Data Wrapper) in PostgreSQL for myself using C.
It seems to be working rudimentary, but I have one problem.
When I pass it a query like the following via psql:
select * from ...
0
votes
1
answer
129
views
Availability group issues - databases not synchronising
I am hoping someone may be able to offer some assistance with an issue that I do not seem to be able to work around.
We have 2 on-premise SQL Server 2019 machines in an always on availability group. ...
0
votes
1
answer
171
views
Confusion on SQL Server domain\username after Windows changing hostname
We have a SQL Server 2016 running on a virtual machine of Windows 2016. Previously, the virtual machine's hostname was WIN when we installed the SQL Server, so the database engine's server name was ...
0
votes
1
answer
130
views
Got an error when trying to get ER-diagram on SQL Server
We are using Microsoft SQL Server 2016 Management Studio (version 13.0.16106.4) connecting to an instance of SQL Server 2016 running on Windows 2016. The authentication is "SQL Server ...
0
votes
0
answers
35
views
Mongo 3.4 to 3.6
How to upgrade 3.4 mongo to 3.6 mongo. I don't have config file while starting mongodb in 3.4 how to have it in windows locally.
0
votes
0
answers
51
views
My SSMS does't see the directory with db files
I did nothing and my SSMS does not see db directories with files.
When I'm trying attach db ssmms can't find this way. But when I create db the files put there
As I understood there is the problem ...
0
votes
1
answer
127
views
MariaDB Power Outage Issue
We have a desktop application on Windows OS that installs with MariaDB server 10.4.10. Sometimes the client loses power and after restarting of PC MariaDB database becomes corrupted and Windows Server ...
0
votes
1
answer
1k
views
Unable to remote connect to windows 10 Postgresql
Context
I have an old laptop I'd like to host a database on to serve a MEVN stack hosted on AWS. That MEVN stack currently does use Mongo, the goal is to transition to a local (my laptop) Postgresql ...
1
vote
0
answers
217
views
pg_ctl on windows: keep running when closing cmd prompt
Is there a way to start postgresql with pg_ctl in a windows command prompt and keep the server running after closing the command prompt?
Note: installed via conda, limited privs eg. running as a ...
0
votes
0
answers
36
views
Using MySQL 8's "--no-monitor" mode in a Windows service?
Cheers. For (reasons) I want to run MySQL 8.0.30 in the "no-monitor" mode, which keeps the service running as a single process. Docs here.
The documentation makes no reference to windows ...
0
votes
2
answers
371
views
Memory usage for MySQL
I have created the following procedure:
CREATE DATABASE memory
USE memory
DELIMITER $$
DROP PROCEDURE IF EXISTS `my_memory` $$
CREATE PROCEDURE `my_memory` ()
BEGIN
DECLARE var LONGTEXT;
DECLARE ...
1
vote
1
answer
434
views
PostgreSQL uses huge amount of memory
When executing a query containing WITH and more than a thousand UNION ALL, PostgreSQL version 14 or higher uses all server memory until it enters recovery mode. In tests with version 11, this behavior ...
0
votes
1
answer
125
views
Oracle for Windows: how do I create a new user and login with it?
I can connect as sysdba and with the system user, but I am unable to create a new user and connect with it. This is a new Oracle install straight out of the box 19;
enter image description here
...
0
votes
0
answers
49
views
pg_dump significant size difference between dumps
So we've been doing some temporary backups on windows machines and came across something interesting.
Doing plain formatted dumps with no compression and blobs,
we get significant size differences ...
-2
votes
1
answer
285
views
Mysql - Fields in views and tables being cut off at a character limit for varchar?
I have tables where I am running views off of. Anything with over varchar(255) get automatically cut off in a view.
I even created a query to create a table using AS SELECT (that was a view) with ...
1
vote
0
answers
179
views
How to use mongoexport with a dynamic variable for date on windows batch file?
Here is my working script:
mongoexport --db db1 --collection Transaction --out C:\Users\Admin\transactionstats.json --query="{"PaymentDate":{"$gte":{"$date":"...
0
votes
2
answers
262
views
Postgres - how to work out which tablespace is short of space?
I'm trying to add a INTEGER DEFAULT 0 field to a very large (partitioned) table spread across two tablespaces.
Each tablespace is on a different disc (one on C drive, the other on D). I get the ...
1
vote
0
answers
221
views
How to direct psql errors to powershell log file?
I'm running a powershell script on a windows system. The script includes psql commands to run SQL on a postgres database.
Most stuff gets correctly recorded in the powershell log file, EXCEPT for psql ...
0
votes
0
answers
83
views
Linux PostgreSQL 9.4 to Windows PostgreSQL 13
I had to switch from PostgreSQL 9.4 on Linux to PostgreSQL 13 on Windows
Normal restore was not successful.
Can somebody share experience with such case?
EDIT 1:
On linux I use:
pg_dump -c -O -U ...
0
votes
0
answers
187
views
Connection String requires AttachDbFilename property
I'm trying to use SQL Server LocalDb to store the database by connection string. During first connection to the database I have an error about connecting to the database. In SSMS it is opening. To fix ...
0
votes
0
answers
360
views
SQL Server Install/Uninstall Freezes
I'm running Windows Server 2019 Standard. All Windows updates have been installed. Chckdsk, sfc, and dism have been run and found no problems. Server has been restarted.
I'm trying to uninstall some ...
0
votes
0
answers
146
views
Windows server localdb issue
I'm trying to deploy a database to a Windows Server machine.
The database is a SQL Server LocalDB. When I deploy it to a Windows machine, everything works correctly. When I try to deploy the same ...
0
votes
0
answers
74
views
Create logins for all active directories groups named ("Domain Users"), related to current Windows Authenticated user in SQL Server
I need to get all active directories locations, related to current machine, by SQL script to create logins for them. Is there a way to perform that? For now I wrote such procedure:
USE [master]
GO
...
2
votes
1
answer
11k
views
The target principal name is incorrect. Cannot generate SSPI context. (Microsoft SQL Server)
we have an issue connecting remotely to SQL Server via SSMS with Azure AD users. Any attempt to log in to a SQL Server instance in AWS with Windows Authentication throws an SSPI error. We've tried the ...
0
votes
1
answer
416
views
How to get rid of all whitespace in a mysql query?
SELECT
libary.MediaId,
library.Title,
library.`date-downloaded`,
library.Author,
library.`language`,
library.asseturl,
library.`recycle-bin`,
library.`key-asset`,
SUBSTRING_INDEX(SUBSTRING_INDEX(`...
-1
votes
1
answer
129
views
Does IntelliSense feature available in Data Studio?
Does IBM Data Studio have IntelliSense features or Intelligent code completion something
like below?
I would like to write an SQL query with IntelliSense type functionality.
I have IBM Data Studio 4.1....
-2
votes
1
answer
105
views
How much changing MySQL datadir from SSD Drive "C:/.." to HDD Drive "D:/.." will slow down the query processing speed?
I am working on my local device and have created a schema that makes drive "C:/" (SSD) nearly full (it took up nearly 60 GB from the available space), so I think I should move the data to ...
1
vote
1
answer
1k
views
MySQL from backup won't start due to possibly corrupted data folder or permissions
A few days ago I was forced to format my PC due to an issue with a Windows update, I managed to make a backup first and now I'm trying to restore the files.
I have a mysql instance that I'm having ...
3
votes
1
answer
2k
views
Install SQL Server 2016 SP2 on SP3 - Windows Updates says that?
Currently our server is on Microsoft SQL Server 2016 (SP3) (KB5003279) - 13.0.6300.2 (X64) Aug 7 2021 01:20:37 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows Server ...
0
votes
0
answers
450
views
Failed to open file '{dump.sql}', error: 13 Windows 10
I have installed XAMPP with PHP 7.2.23 and MySql v8 and want to import database dump on Windows 10
I used this commands in Command promt running by Administrator:
C:\xampp\mysql\bin\mysql -u root
...
0
votes
1
answer
362
views
Reliable way(s) of finding home directory of Sybase DB (ASE) on Linux and Windows
I need to write a script that finds Sybase installation on a system if there's any.
For testing I've installed ASE 16 on CentOS system, but the installer is apparently based on InstallAnywhere (Java).
...
0
votes
1
answer
568
views
PostgreSQL data corruption tools?
Are there any techniques/tools/methodologies for investigating row level corruption within a PostgreSQL table?
Most proposed solutions on this forum boil down to:
try doing a VACUUM FULL to rebuild ...
1
vote
0
answers
824
views
Root cause of Postgres database corruption
I've been suffering from occasional (but regular) database corruption recently. Errors like this.
compressed lz4 data is corrupt
and
Npgsql.NpgsqlException:
invalid page in block 1787279 of relation ...
0
votes
0
answers
132
views
How do I retain command history for psql running within PowerShell?
I'm running the following version of psql
psql (12.11)
on Windows Powershell running on Windows 10. Within the same shell session, when I log in and out of psql, it doesn't retain the previous ...
0
votes
1
answer
3k
views
In Postgres 12, how do I set a default schema when logging in using psql?
I'm logging in to my Postgres 12 (running on Windows 10) db using an alias, which resolves to
PGPASSWORD=$DB_PASSWORD psql -U${DB_USER} $DB_NAME
I would like to find a way to tell Postgres which ...
0
votes
1
answer
2k
views
postgres: could not access directory "C:/opt/PostgreSql/14/data": Permission denied
Importantly: This is on Windows 10 and Postgres 14 (for newbies, Postgres is also known as PostgreSQL), with Cygwin providing the CLI.
On a fully functional, up and running, and apparently perfectly ...
1
vote
2
answers
5k
views
Servicing Update for SQL Server 2019 RTM GDR (KB4517790) - Install error - 0x80070643
SQL Server is still working smoothly but I noticed that I have an alert on the Windows Update that says:
Servicing Update for SQL Server 2019 RTM GDR (KB4517790)
Install error - 0x80070643
I tried ...
0
votes
1
answer
425
views
How to change initdb own messages localization?
When I initialize a cluster the messages produced by initdb are in French.
I tried the following options :
--locale=en_US
--lc-messages=en_US
--no-locale
--locale=C
initdb messages still stay in ...
0
votes
1
answer
648
views
Most recent version of SQL Server Management Studio that works with Windows 7 pre SP1?
I am trying to do some work with SQL Server 2008 (not 2008 r2, just 2008) that is installed on a Windows 7 Pro 32-bit PC. It's just Windows 7 with no Service Pack 1 applied. I have no option to update ...
0
votes
2
answers
270
views
Failing over to DR site Availability group
I have a 4 node cluster SQL 2012 availability group database with one witness server at the primary site. 3 nodes are in the primary site and one node in the DR site.
Due to maintenance at the Primary ...
1
vote
1
answer
1k
views
Postgresql connection timing-out too quickly
I'm running a powershell script on windows that connects to a postgres database.
Under normal conditions everything works fine, but I'm trying to make the system more robust, and make everything re-...
0
votes
0
answers
708
views
error installing PostgreSQL, Could not find registry key HKEY_LOCAL_MACHINE\
I've been trying install postgres, i try solutions related to WSH,
nothing works to me.
here's the log
Log started 01/19/2022 at 21:06:35
Preferred installation mode : qt
Trying to init installer in ...
0
votes
2
answers
288
views
3 Node WFCS - How to automatically FO to DR?
I am planning to implement a two-node Windows Server Failover Cluster (WSFC) for SQL Server Always On Availability Group in our main site, and the third node in our DR site.
All application clients ...