Skip to main content
Share Your Experience: Take the 2024 Developer Survey

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.

119 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
5 votes
0 answers
5k views

PgBouncer cannot connect to server

I have configured PgBouncer with PostgreSQL 9.6 on windows 7 machine. Here are the pgbouncer configuration settings; [databases] test = host=127.0.0.1 port=5432 dbname=master_db user=postgres ...
Shahzad Bacha's user avatar
4 votes
0 answers
257 views

Identifying table causing runaway rollback in MySQL 5.5 (InnoDB / Windows)

I have a large database (180 GB), running under Windows, with a runaway rollback that starts running as soon as the database is started up. I have started the database with innodb_force_recovery=3 ...
Joe Paul's user avatar
4 votes
0 answers
2k views

"could not write to log file, Bad file descriptor" error when working with huge table

I'm having a big problem with a PostreSQL database. Whenever I do something with a huge table (over 9 million rows) the whole postgres process crashes with the following entries in the log file: ...
cremor's user avatar
  • 85
3 votes
0 answers
2k views

Cannot access MYSQL safe mode using skip-grant-tables on Windows

I am running a MySQL server 8.0.21 on a Windows Server system. Recently I ran into an issue where my root user lost all its privileges. I am trying to gain access to the MySQL server using: mysqld ...
Augustus Buckman's user avatar
3 votes
1 answer
1k views

Reset mongo cache memory for test perfomance - windows

recently i'm working on mongo db and I'm trying to check the performance of mongodb with 2 million record. I need to clear cache every time I start the test. I don't want to restart the computer/...
John Sans's user avatar
3 votes
0 answers
228 views

SQL Server 2012 Installation Has No Option To Uninstall

I've recently inherited a laptop for testing from a client, unfortunately it wasn't a fresh image so it has some software already installed that's causing me some grief. The short version is their IT ...
Neil's user avatar
  • 31
3 votes
0 answers
5k views

Unable to install postgresql 9.3 on windows 8.1

I have been trying, without success, to get posgresql 9.3 up and running on Windows 8.1 on and off over the last ten days. Here is what I have done so far: I got the windows installer from ...
Malik A. Rumi's user avatar
2 votes
1 answer
4k views

How am I supposed to update PostgreSQL on Windows, once installed, without manually installing new installers?

I have PostgreSQL 11.5 installed on Windows 10. It was installed with the EnterpriseDB installer, which is the only one which exists these days. If I go to https://www.postgresql.org/download/windows/...
Gregorg's user avatar
  • 37
2 votes
1 answer
7k views

SQL Server - allocation unit size in Windows 2019

I'm about to install a SQL Server 2019 instance on a Windows 2019 machine and found out that there are new NTFS allocation unit sizes available - up to 2M. I used to format partitions using 64k unit ...
Timbalero's user avatar
  • 111
2 votes
0 answers
3k views

MySql Workbench Couldn't find section mysqld in the remote config file /etc/mysql/my.cnf

if you get this trying to connect to your remote server using MySql Workbench, then try to (on your remote server) navigate to /etc/mysql/my.cnf and add [mysqld] then it should look like: !...
Nils Riga's user avatar
2 votes
0 answers
1k views

SQL Server stored procedure not throwing certain kind of error

I noticed an issue in my app recently where an database insert that occurred in a stored procedure was failing, but no exception was getting thrown. The insert failed because a column that doesn't ...
Gary Reckard's user avatar
2 votes
1 answer
2k views

Access denied error when archiving WAL during postgresql 9.5 replication setup

I want to setup Postgres replication on Windows. I followed the given youtube url step by step: youtube video. For archive_command I use this: archive_command = 'copy "%p" "\\\\ip-address of ...
S Deshmukh's user avatar
2 votes
0 answers
3k views

How to get records from corrupted ibd file

Ok, in the last two days I thoroughly searched through the internet, and found multiple propositions on how to handle this, but nothing worked so far. Here is what the problem is and what I tried so ...
Tschebbischeff's user avatar
2 votes
0 answers
729 views

Intermittent IOExceptions when connection with MySQL Connector/Net. Why?

I have a web application which uses a MySQL 5.7.13 server for storing its data. MySQL is running on Windows Server 2008 R2. A couple of month ago I started seeing exceptions like the following being ...
David Nordvall's user avatar
2 votes
0 answers
5k views

Can't delete Oracle Datafiles after DROP TABLESPACE INCLUDING CONTENT AND DATAFILES

Just sharing this as a lesson learned... On Windows, when using DROP TABLESPACE INCLUDING CONTENT AND DATAFILES, the actual files on the harddrive don't get removed. Sometimes (not always) after a ...
Wouter's user avatar
  • 821
2 votes
2 answers
475 views

MySQL Upgrade on Windows

I am having MySQL 5.1 installed on windows box. Now I would like to upgrade to latest MySQL 5.6 version. I am planning to install MySQL 5.6 in the same server with same port 3306. After installation, ...
Phanindra's user avatar
  • 1,007
2 votes
0 answers
6k views

High availability PostgreSQL 9.3 server on Windows

I'm trying to set up PostgreSQL 9.3 server in HA mode on 2 Windows servers. Final solution should be deployed to Microsoft azure network, so there are few limitations. Since Microsoft is doing ...
Ivan Cagalj's user avatar
2 votes
0 answers
2k views

Oracle: How to find non-local (background) processes in Windows Machine

Following link advises to find non-local background processes and kill them using following bash script. Solution 1) : without shutdown anything just kill that database processes which are not ...
Atilla Ozgur's user avatar
  • 1,456
2 votes
0 answers
329 views

Performance of large queries on low bandwidth connections

I've been running some measurements on bandwidth needs and the effects of latency on query performance against Postgres 8.3 (waiting for management to approve upgrade) on Windows. SELECTs of various ...
Thomas's user avatar
  • 123
2 votes
0 answers
4k views

SQL Server connection with multiSubnetFailover fails, claims mirroring is enabled

I have two SQL Server instances in an availability group. They are not mirrored. I'm trying to connect to the AG using the MS JDBC drivers (4.0) with a connection string including multiSubnetFailover=...
Joe Kearney's user avatar
2 votes
2 answers
5k views

Postgres Windows post-install "The database cluster initialization failed"

I've seen many solutions and have been working on this issue for hours now. After installation the post-installation script fails with the message above. This is a development installation of ...
Silberling's user avatar
1 vote
0 answers
269 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 ...
beginner_'s user avatar
  • 213
1 vote
0 answers
188 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":"...
JRA's user avatar
  • 149
1 vote
0 answers
246 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 ...
ConanTheGerbil's user avatar
1 vote
0 answers
960 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 ...
ConanTheGerbil's user avatar
1 vote
1 answer
670 views

Any idea what Virtual Machine Cluster WMI is for?

We have a Windows Failover Cluster to host our SQL Server Availability Group. We have a resource that popped up that no one recalls creating named "Virtual Machine Cluster WMI". We have ...
Bill Ennis's user avatar
1 vote
1 answer
643 views

Kerberos Issue - Anonymous Login

I have a linked server that connects one SQL Server to another SQL Server. For two weeks now there has been an error when testing the connection; Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. ...
sqllover2020's user avatar
1 vote
0 answers
175 views

What's the problem with my password while installing Apex 20.1?

I am installing Apex 20.1 on my windows 10 with oracle 19c. After running the command : @apxchpwd.sql I get this error even after respecting all the password regulation and trying different ...
Chadi Hani's user avatar
1 vote
0 answers
412 views

WSL2 Docker Oracle volume mapping: how to switch from Windows to Linux file system

I am running Oracle (V19, V18, and V12) instances under WSL2 (Windows 10 version 2004). For persistence, my Oracle data files are mapped to a folder on my Windows host. I can run the containers from ...
MonteChristo's user avatar
1 vote
0 answers
875 views

pg_repack binaries under windows

We use postgres to manage our data in windows. Most of our installations run 9.x branch of postgres, although all versions of the database software is used (however pretty much all installations run ...
arthur's user avatar
  • 888
1 vote
1 answer
566 views

MySQL stops in windows VM and shows innodb os error in logs(error no. 5)

2020-08-23 17:22:36 5688 [Note] Plugin 'FEDERATED' is disabled. 2020-08-23 17:22:36 5688 [Note] InnoDB: Using atomics to ref count buffer pool pages 2020-08-23 17:22:36 5688 [Note] InnoDB: The InnoDB ...
Anushree's user avatar
1 vote
0 answers
1k views

PSQL console encoding

How can I have a working PSQL console using UTF8 encoding under Windows? I have a Windows server and client. The Postgres 12 database contains tables with content in multiple languages (ex: English, ...
JGH's user avatar
  • 111
1 vote
1 answer
2k views

Getting "unknown variable postgresqlini" when updating PostgreSQL

I am getting an error when attempting to upgrade a PostgreSQL installation. The full error is: A data directory is registered in ***unknown variable postgresqlini*** but is neither empty or a ...
ChrisMM's user avatar
  • 121
1 vote
0 answers
615 views

PostgreSQL 9.6 on linux server gives a different collation than windows installation

I am running into an issue with a script that makes a backup towards the SQL. What happens is that with our script we make a dump of SQL we can read out to restore the PostgreSQL database. Our client ...
Dorvalla's user avatar
  • 111
1 vote
0 answers
324 views

MySQL 5.7 issue with 16TB disk

(Repost from StackOverflow) I have a MySQL 5.7 running on a Windows Server 2016 VM with two disks from a NAS: C:\ for system and D:\ for data (empty at start). I try to create a partitioned table: ...
B. Bram's user avatar
  • 11
1 vote
0 answers
712 views

PostgreSQL service stops immediately after installing Windows Fall Creators Update 1709

The server itself runs fine with pg_ctl -D <datadir> start But the service stops immediately ("...Some services stop automatically if they are not in use by other services or programs") ...
Gunnar's user avatar
  • 121
1 vote
0 answers
96 views

Never stop growing of MariaDB service memory on Windows

I have this strange problem in a Win7-4GB machine with MariaDB v. 10.1.18 using only InnoDB tables. mysqld.exe service memory grows until the OS error out of memory, it take some hours but at the end ...
Tobia's user avatar
  • 199
1 vote
0 answers
1k views

Why MS SQL Express cannot find my local Windows user?

First of all: My Images use german as a language, sorry for that but maybe you find the problem though. So I am setting up a SQL Database on a MS SQL Server 2016 Express. While doing so I am using ...
user avatar
1 vote
0 answers
60 views

SQL-Server for Linux WORKGROUP authentication handling

I installed SQL-Server for Linux on a linux Centos 7 distro, it works fine, but I need a workgroup authentication. It's required by the client (SAGE Ligne 100) which runs on a Windows workstation. ...
Zebu1er's user avatar
  • 11
1 vote
0 answers
272 views

Can Oracle Database run on Microsoft Nano Server?

Microsoft Nano Server is attractive alternative to a heavier installation of Microsoft Windows Server 2016. Can Oracle Database be prepared to run this way?
durette's user avatar
  • 625
1 vote
0 answers
38 views

Switch Between Windows Authenticated Users On Single Windows Account

We have a CRM that has been developed in house in Microsoft Access 2003. We are also in the process of moving from an MS Access backend to a SQL Server backend. I have been researching different ...
Elias's user avatar
  • 169
1 vote
0 answers
2k views

transaction isolation in MySQL workbench

MySQL Workbench has a bug where every new created session receives default session parameter values regardless of the server's definition for that parameter. For example, when the server's "...
lioran's user avatar
  • 41
1 vote
0 answers
69 views

Computer runs out of space when indexing database on external disk

I have an SQLite database of about 80 GB on an external harddrive. I want to index some of the columns there, but when I do the operation fails after some time, with this error: sqlite3....
bjornasm's user avatar
  • 177
1 vote
0 answers
97 views

sql script execution time differences between host and virtual machine

In my organization developers are using "docker" technology to develop & test their applications. developer's machines are mostly linux-mint with different specs on each machine. Every ...
lioran's user avatar
  • 41
1 vote
1 answer
10k views

NT SERVICE\MSSQL$SQLEXPRESS user cannot be found when added to network drive

For SQL Server 2016 Express, I would like to backup/restore directly to/from network storage I have mapped to drive S:. SQL Server Express runs under the (virtual?) account NT SERVICE\MSSQL$SQLEXPRESS ...
AndreasS's user avatar
  • 229
1 vote
0 answers
1k views

Windows Domain User with Admin privileges cannot access a drive with full permissions in psql

I have installed the standard PostgreSQL 9.5 from Enterprise DB with a domain-level postgres user who has domain-level admin group membership. I have explicitly added full permissions for this user to ...
metro-mark's user avatar
1 vote
0 answers
459 views

connection closes unexpectedly with different kind of errors

When I execute a query which returns more than 300 rows I’m getting random errors and the connection closes for example An error occurred while executing batch. Error message is: SqlDateTime ...
Joe B's user avatar
  • 111
1 vote
0 answers
985 views

Connecting to MS SQL server from a Linux box

I am trying to connect to MS SQLServer from an application that I have written (using Qt) which runs on Linux. Here are some details of the setup: The SQLServer box (SQLBox) is part of my domain (...
Michael Vincent's user avatar
1 vote
0 answers
54 views

Effect of upgrading windows server 2012 data center

I have a production windows server 2012 data center server where IIS and SQL server was installed and replication was configured in SQL Server. It is infected with a malware. After cleaning it with an ...
mox-du's user avatar
  • 43
1 vote
0 answers
182 views

MongoDB fsyncUnlock won't unlock occasionally on Windows

We have a MongoDB replica set installed on Windows servers, with a scheduled backup job. MongoDB is configured to use journaling. The job runs db.fsyncLock() via script on MongoDB (primary server), ...
Danny Varod's user avatar