notifications cronjob error

Next topic

Author	Message
Luis Micunco	Wednesday 29 July 2009 2:57:16 am Hi. Im having problems running the notifications cronjob: php runcronjobs.php frequent i know by cronjob.ini this executes: [CronjobPart-frequent] Scripts[]=notification.php #Scripts[]=workflow.php notice that i put # in workflow.php just to run notications.php. This is message i get: Running cronjob part 'frequent' Running cronjobs/notification.php Starting notification event processing Fatal error: A database transaction in eZ Publish failed. The current execution was stopped to prevent further problems. You should contact the System Administrator (test@test.com) of this site. The current transaction ID is TRANSID-ac62fce69b251ecf339af449981537a0 and has been logged. Please include the transaction ID and the name of the current script when contacting the system administrator. Then i cant find the TRANSID anywhere. In error.log is not there. Even with "grep" to find "ac62fce69b251ecf339af449981537a0". I tried some solutions like truncate ezurlalias_ml table and then run "updateniceurls.php" but the problem persists. eZ Publish version is 4.1.2 . Thanks to all .
Luis Micunco	Wednesday 29 July 2009 3:40:18 am I forgot to mention that everything works fine running the notifications from the module "notification/runfilter": using the "Run notification filter" button as described here: http://ez.no/doc/ez_publish/technical_manual/4_0/features/notifications The problem above persists when running the cronjob.

Author

Message

Wednesday 29 July 2009 2:57:16 am

Hi.
Im having problems running the notifications cronjob:

php runcronjobs.php frequent

i know by cronjob.ini this executes:

[CronjobPart-frequent]
Scripts[]=notification.php
#Scripts[]=workflow.php

notice that i put # in workflow.php just to run notications.php. This is message i get:

Running cronjob part 'frequent'
Running cronjobs/notification.php
Starting notification event processing
Fatal error: A database transaction in eZ Publish failed.

The current execution was stopped to prevent further problems.
You should contact the System Administrator (test@test.com) of this site.
The current transaction ID is TRANSID-ac62fce69b251ecf339af449981537a0 and has been logged.
Please include the transaction ID and the name of the current script when contacting the system administrator.

Then i cant find the TRANSID anywhere. In error.log is not there. Even with "grep" to find "ac62fce69b251ecf339af449981537a0".

I tried some solutions like truncate ezurlalias_ml table and then run "updateniceurls.php" but the problem persists.

eZ Publish version is 4.1.2 .

Thanks to all .

Luis Micunco

Wednesday 29 July 2009 3:40:18 am

I forgot to mention that everything works fine running the notifications from the module "notification/runfilter":
using the "Run notification filter" button as described here:

http://ez.no/doc/ez_publish/technical_manual/4_0/features/notifications

The problem above persists when running the cronjob.

eZ debug

Timing:	Jan 31 2025 01:29:37
Script start
Timing:	Jan 31 2025 01:29:37
Module start 'layout'
Timing:	Jan 31 2025 01:29:37
Module start 'content'
Timing:	Jan 31 2025 01:29:37
Module end 'content'
Timing:	Jan 31 2025 01:29:37
Script end

Main resources:

Total runtime	0.0256 sec
Peak memory usage	6,144.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0057	588.1328	151.2109
Module start 'layout'	0.0057	0.0046	739.3438	220.6875
Module start 'content'	0.0103	0.0137	960.0313	997.8047
Module end 'content'	0.0240	0.0016	1,957.8359	29.9922
Script end	0.0256		1,987.8281

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0032	12.3347	14	0.0002
Check MTime	0.0011	4.2774	14	0.0001
Mysql Total
Database connection	0.0009	3.4405	1	0.0009
Mysqli_queries	0.0026	10.0277	3	0.0009
Looping result	0.0000	0.0660	1	0.0000
Template Total	0.0012	4.6	1	0.0012
Template load	0.0009	3.4675	1	0.0009
Template processing	0.0003	1.0991	1	0.0003
Override
Cache load	0.0006	2.3944	1	0.0006
General
dbfile	0.0012	4.8074	8	0.0002
String conversion	0.0000	0.0363	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs