Re: [Firebird-devel] ODP: ODP: Internal Firebird consistency after 10minutesof OLTP test

2018-10-28 Thread Dmitry Yemanov

28.10.2018 10:45, Karol Bieniaszewski wrote:


I have analysed previous log and i found interesting entry

DESKTOP-6BKOVL9 Sat Oct 27 13:29:19 2018

     I/O error during "ReadFile" operation for file 
"C:\WINDOWS\TEMP\FB_TABLE_5FBVM1"


     Error while trying to read from file

     Nieprawidłowe dojście.

but in Firebird.conf i have this configuration

TempDirectories = O:\temp

Why Firebird have used C:\WINDOWS\TEMP which is my old SSD, still 
working but it is not so good.


TempDirectories setting is not used for global temporary tables.

Only when i create FIREBIRD_TMP it did not create any file in 
C:\WINDOWS\TEMP directory.


Correct.


Dmitry


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


[Firebird-devel] ODP: ODP: Internal Firebird consistency after 10minutesof OLTP test

2018-10-28 Thread Karol Bieniaszewski
Still no luck but..

I have analysed previous log and i found interesting entry

DESKTOP-6BKOVL9 Sat Oct 27 13:29:19 2018
I/O error during "ReadFile" operation for file 
"C:\WINDOWS\TEMP\FB_TABLE_5FBVM1"
Error while trying to read from file
Nieprawidłowe dojście.

but in Firebird.conf i have this configuration

  TempDirectories = O:\temp

Why Firebird have used C:\WINDOWS\TEMP which is my old SSD, still working but 
it is not so good.
Only when i create FIREBIRD_TMP it did not create any file in C:\WINDOWS\TEMP 
directory.
I can’t figure out why it prefere Windows temp instead.. Maybe in some point FB 
eat whole space (20GB) of O:\temp and go there. DB size was 7GB.
But in all current tests FB never go to C:\WINDOWS\TEMP.
Maybe the reason of bugcheck was releated to my SSD use…

Regards,
Karol Bieniaszewski
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel