I have quite a complex setup:
- an Informix (11.5) legacy database which contains some of the business data,
- a Postgres (9.3) database which connects via foreign data wrapper (FDW) to the Informix instance, and
- a Grails application (2.4.4) which should run against Postgres.
We use the searchable-plugin for full text indexing.
The setup of this worked quite well. But when I start the indexing process, the Informix instance dies after some minutes. We are indexing 100.000+ rows, but the crash happens quite randomly: sometimes after 2 minutes, sometimes after 10.
There is no obvious error message in the online.log (log file from Informix). While indexing got this message (dozens of times):
14:53:15 Dynamically allocated new virtual shared memory segment (size 8192KB)
14:53:15 Memory sizes:resident:111492 KB, virtual:1089424 KB, no SHMTOTAL limit
Then the application crashes and Postgres informs the Grails application, that the network connection is broken or (we had different error messages) or the connection is refused.
In the IntelliJ console I can see, that the indexing process fires a lot of SQL-statements to the FDW-tables.
I guess this is quite a rare setup, but I want to ask if anybody has experience with FDW and Grails/Searchable and can point me to what might be the problem.
The FDW-tables are working fine in our application and in SQL Maestro.
Or could be just a basic configuration problem with Informix?