Memory problem (Firebird 4).

[Dany40]

Hello;

Maybe somebody can suggest me some change in the firebird.conf to avoid this problem.

Now I have 40 databases on the same FB4 embedded engine running in SuperClasic mode.

I see on task manager that memory usage is going bigger for 2 o 3 days; when it is at 25% (1.600 MB aprox) I get this errors in the firebird.log:

SVP-10027        Wed Feb 23 15:55:34 2022
        Database: E:\DATOS\08282048.FDB
        Allocated 1607 page buffers of 2048 requested


SVP-10027        Wed Feb 23 15:55:34 2022
        Operating system call MapViewOfFile failed. Error code 8


SVP-10027        Wed Feb 23 15:55:34 2022
        MonitoringData: Cannot initialize the shared memory region
        operating system directive MapViewOfFile failed
        Not enough storage is available to process this command.


SVP-10027        Wed Feb 23 15:55:45 2022
        Database: E:\DATOS\08282048.FDB
        Allocated 1543 page buffers of 2048 requested


SVP-10027        Wed Feb 23 15:55:45 2022
        Operating system call MapViewOfFile failed. Error code 8


SVP-10027        Wed Feb 23 15:55:45 2022
        MonitoringData: Cannot initialize the shared memory region
        operating system directive MapViewOfFile failed
        Not enough storage is available to process this command.

What can I customize to avoid this?.

Thank you a lot!!

[Dimitry Sibiryakov]

Dany40 wrote 24.02.2022 15:55:
> I see on task manager that memory usage is going bigger for 2 o 3 days; when it is at 25% (1.600 MB aprox)

Quite expected limit for 32 bits applications.
Growing memory usage imply memory leak in the application.

> What can I customize to avoid this?.

Stop using Embedded mode. Use a full-grade 64 bit server in superserver mode.

--
WBR, SD.

[Dany40]

In superserver mode I can't backup databases when they are in use.

[Dimitry Sibiryakov]

Dany40 wrote 24.02.2022 17:35:
> In superserver mode I can't backup databases when they are in use.

It is not true. You can backup databases just fine using explicit remote
connection string and services API.

--
WBR, SD.

[Dany40]

Sorry I can't udserstand. I am doing what you said (no more embeded, just standard FB4 with all the defaults). When I try to backup I get:

gbak.exe -user lex -password lex -b -v -ig c:\DATOS\XX.FDB C:\Backup\XX.FBK

gbak: ERROR:I/O error during "CreateFile (open)" operation for file "C:\DATOS\XX.FDB"
gbak: ERROR:    Error while trying to open file
gbak: ERROR:    El proceso no tiene acceso al archivo porque está siendo utilizado por otro proceso.
gbak:Exiting before completion due to errors

It means there is another process using the file.

[Carlos H. Cantu]

You are telling gbak to connect as embedded, so you get the error because embedded wants exclusive access and the database file is already open by another instance.

 

I suggest you to make all of your connections to the database by TCP/IP, specifying the IP number of the server, or localhost if it is the case, ex:

 

localhost:c:\DATOS\XX.FDB

192.168.1.1:c:\DATOS\XX.FDB

etc...

 

[]s

Carlos

Migration Guide to Firebird 4

http://www.firebirdnews.org/migration-guide-to-firebird-4/ 

  

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/239c3823-7983-4820-8f38-dcc25c81376dn%40googlegroups.com.

[Dany40]

Hi carlos; I already tried that, but same results. Now I am trying by service manager (this is new for me, so please let me check that with you):

gbak -b -se localhost:service_mgr c:\datos\XX.fdb c:\a\XXX.fbk -user dany -password 1234

It seems it is working.

[Dimitry Sibiryakov]

Dany40 wrote 24.02.2022 19:05:
> Sorry I can't udserstand.

You should carefully study
http://firebirdsql.org/file/documentation/html/en/firebirddocs/qsg3/firebird-3-quickstartguide.html#qsg3-databases

--
WBR, SD.

[Dany40]

Thank you. I noted that in the document you sent me there is no mention about the service manager way I found and testet with success. Is that ok?

[Dimitry Sibiryakov]

Dany40 wrote 24.02.2022 21:23:
> I noted that in the document you sent me there is no mention about the service
> manager way I found and testet with success. Is that ok?

The document is just a quick start guide. It has a number of references and
links to other documentation including
https://www.firebirdsql.org/file/documentation/html/en/firebirddocs/gbak/firebird-gbak.html

--
WBR, SD.