Hello all, For the last day or so, I have been trying to get Multi Processing to work on a Sun Solaris box. It just doesn't work, so I made 2 small 'proof of concept' programs. testMP1.pl does work, testMP2.pl and testMP3.pl don't. The only difference is that I don't do any database action in the parent during forking. testMP3.pl is the same as testMP2.pl but has no database action in the children but still either stops after 159 records or hangs at 159 records (testMP2.pl does the same) I could have programmed a bug. (Always assume that it's your problem!).
Or is it Oracle? It seems that when you use Oracle, you have to close all database connections before forking? Can anybody confirm this and maybe explain why? And how to circumvent it? Is there a special API in Oracle for multiple connections from children + parent? Just to explain: In the example program the database action are trivial. zaa is a database table with 1 field called aa. It has 500 rows in my test setting. yaa is basically the same, I just copy records from zaa to yaa. Thanks for any answer, Jeroen Lodewijks
testMP1.pl
Description: Binary data
testMP2.pl
Description: Binary data
testMP3.pl
Description: Binary data
