I'm having an issue with Bulk Mail on both our Prod (V3.12.3) and Test (V3.14.0) systems. I have a Bulk Mail setup which works fine with one recipient but when I add a second recipient and run it it will send to whichever recipient has the lowest assetid but won't send to the remaining one(s). In the backend it will just sit there with a status of running (1/2 (50%) emails sent).
This happens regardless of who the recipients are and does the same thing on both systems. I'm not sure where the problem lies, if bulkmail/run.php is failing to loop or if it (or something) is dropping the connection to oracle after the first one. Or if Bulk Mail is just not installed correctly??
Here's a dump of the log with the errors that occured when trying to run with more than one recipient:
15:43:21 - 25 May
User: Root User (12)
Level: PHP Warning (/usr/local/squiz/php/lib/php/DB/oci8.php:298) - disconnect(): failed to rollback outstanding transactions!: ORA-03135: connection lost contact
15:46:53 - 25 May
User: Root User (12)
Level: PHP Warning (/usr/local/squiz/php/lib/php/DB/oci8.php:298) - disconnect(): failed to rollback outstanding transactions!: ORA-03113: end-of-file on communication channel
15:46:55 - 25 May
User: Root User (12)
Level: MySource Error (/core/include/assertions.inc:509) - [ASSERT EXCEPTION] DB Error: unknown error
Raw Entry: SELECT type_code FROM sq_ast WHERE assetid = '75570' [nativecode=ORA-03113: end-of-file on communication channel] (LINE 944 IN /core/include/asset_manager.inc) [SYS0270]
15:46:55 - 25 May
User: Root User (12)
Level: MySource Error (/core/include/assertions.inc:509) - [ASSERT EXCEPTION] DB Error: unknown error
Raw Entry: SELECT type_code FROM sq_ast WHERE assetid = '75603' [nativecode=ORA-03135: connection lost contact] (LINE 944 IN /core/include/asset_manager.inc) [SYS0270]
15:46:55 - 25 May
User: Root User (12)
Level: PHP Warning (Unknown:0) - Unknown(): _oci_close_session: OCISessionEnd: ORA-03135: connection lost contact
15:46:55 - 25 May
User: Root User (12)
Level: PHP Warning (/usr/local/squiz/php/lib/php/DB/oci8.php:298) - disconnect(): failed to rollback outstanding transactions!: ORA-03135: connection lost contact
15:58:50 - 25 May
User: Root User (12)
Level: PHP Warning (/usr/local/squiz/php/lib/php/DB/oci8.php:298) - disconnect(): failed to rollback outstanding transactions!: ORA-03113: end-of-file on communication channel
15:58:52 - 25 May
User: Root User (12)
Level: MySource Error (/core/include/assertions.inc:509) - [ASSERT EXCEPTION] DB Error: unknown error
Raw Entry: SELECT type_code FROM sq_ast WHERE assetid = '75603' [nativecode=ORA-03113: end-of-file on communication channel] (LINE 944 IN /core/include/asset_manager.inc) [SYS0270]
15:58:52 - 25 May
User: Root User (12)
Level: PHP Warning (Unknown:0) - Unknown(): _oci_close_session: OCISessionEnd: ORA-03135: connection lost contact
15:58:52 - 25 May
User: Root User (12)
Level: PHP Warning (/usr/local/squiz/php/lib/php/DB/oci8.php:298) - disconnect(): failed to rollback outstanding transactions!: ORA-03135: connection lost contact
16:01:07 - 25 May
User: Root User (12)
Level: PHP Warning (/usr/local/squiz/php/lib/php/DB/oci8.php:298) - disconnect(): failed to rollback outstanding transactions!: ORA-03113: end-of-file on communication channel
16:01:09 - 25 May
User: Root User (12)
Level: PHP Warning (Unknown:0) - Unknown(): _oci_close_session: OCISessionEnd: ORA-03113: end-of-file on communication channel
16:01:09 - 25 May
User: Root User (12)
Level: PHP Warning (/usr/local/squiz/php/lib/php/DB/oci8.php:298) - disconnect(): failed to rollback outstanding transactions!: ORA-03135: connection lost contact
cheers
steve
Hi Steve,
I've forwarded this onto our support team to action. Personally, I haven't seen this before, but perhaps one of our sys admins, or developers could advise further
I have identified this as a problem with PHP oci8 extension on Oracle DB. Bulkmail uses process control and PHP oci8 extension does not work correctly on a multithread environment.
Here’s some information:
http://au3.php.net/manual/en/ref.oci8.php#66426
http://au3.php.net/manual/en/ref.oci8.php#66426
[quote]If you use PHP's oci8 extension, I strongly recommend upgrading to the re-factored version. Although first shipped with PHP 5.1.2, the new code was designed to work with PHP 4 onwards and is available as source code in PECL for use with existing PHP installations.[/quote]
We are currently working on a solution to this problem.