Обсуждение: BUG #16813: error to solve the problem "Windows could not stat file - over 4GB"

Поиск
Список
Период
Сортировка

BUG #16813: error to solve the problem "Windows could not stat file - over 4GB"

От
PG Bug reporting form
Дата:
The following bug has been logged on the website:

Bug reference:      16813
Logged by:          Michal C
Email address:      c_michal@poczta.onet.pl
PostgreSQL version: 13.1
Operating system:   Windows 10 64 bit
Description:

Sorry my english is terrible

I tested part of the solution https://commitfest.postgresql.org/30/2189/ 
for error
https://www.postgresql.org/message-id/15942-58fbac022aa82a2f@postgresql.org
the above solution should solve this problem as well

my PG version: PostgreSQL 13.1, compiled by Visual C++ build 1914, 64-bit
testing method
step 1: 
show data_directory;
step 2:
copy (select

to_char(number,'0.0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000')
from generate_series(1,1024*1024*2,1) d(number)) to 'C:\Program
Files\PostgreSQL\13\data\my_data_01.txt';
step 3:
with files as (select * from pg_ls_dir('.') f(file) where file ilike
'my_data_01.txt')
, files_info as (select file, (pg_stat_file(file)).* from files)
select * from files_info;
Result is: could not stat file "my_data_01.txt": Unknown error


Re: BUG #16813: error to solve the problem "Windows could not stat file - over 4GB"

От
Michael Paquier
Дата:
On Thu, Jan 07, 2021 at 02:02:06PM +0000, PG Bug reporting form wrote:
> my PG version: PostgreSQL 13.1, compiled by Visual C++ build 1914, 64-bit
> testing method
> select * from files_info;
> Result is: could not stat file "my_data_01.txt": Unknown error

bed9075 will be available in PG14.  We may consider a backpatch but
I'd rather have more dust settle on what has been committed on HEAD
before doing such a move (as known as wait for 14 to be released at
least in beta to get this code tested more extensively in the field).
Or are you saying that you tested the patch on top of some 13 code and
it did not work?
--
Michael

Вложения