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

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

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

apt.postgresql.org Repository Update
The following bug has been logged on the website:

Bug reference:      16813
Logged by:          Michal C
Email address:      [hidden email]
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@...
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

Reply | Threaded
Open this post in threaded view
|

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

Michael Paquier-2
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

signature.asc (849 bytes) Download Attachment