Best practice forum (Archived)

Totara Sync Error "active database transaction detected when disposing database"

 
??
Totara Sync Error "active database transaction detected when disposing database"
由 ?? 发表于 2013年07月30日 Tuesday 07:03
 

Running Totara Sync imports 30 user records, then errors out with this message:

"active database transaction detected when disposing database"

I am importing these fields:

"idnumber","timemodified","username","delete","firstname","lastname","email","city",
"country","timezone","description","institution","department","phone1","phone2","address",
"orgidnumber","postitle","manageridnumber","auth","password","customfield_location","customfield_region","customfield_ismanager"

Version 2.4.6

New Installation

Not seeing anything in database error log at this point.

Web/php logs:

[Tue Jul 30 09:39:57 2013] [error] [client 10.10.0.131] FastCGI: server "/mnt/data/environment_cache/10075/http/php5-10075.fcgi" stderr: PHP message: Potential coding error - active database transaction detected when disposing database:, referer: https://md.expertlearning.net/admin/tool/totara_sync/admin/syncexecute.php
[Tue Jul 30 09:39:57 2013] [error] [client 10.10.0.131] FastCGI: server "/mnt/data/environment_cache/10075/http/php5-10075.fcgi" stderr: * line 240 of /admin/tool/totara_sync/elements/user.php: call to moodle_database->start_delegated_transaction(), referer: https://md.expertlearning.net/admin/tool/totara_sync/admin/syncexecute.php
[Tue Jul 30 09:39:57 2013] [error] [client 10.10.0.131] FastCGI: server "/mnt/data/environment_cache/10075/http/php5-10075.fcgi" stderr: * line 135 of /admin/tool/totara_sync/elements/user.php: call to totara_sync_element_user->create_user(), referer: https://md.expertlearning.net/admin/tool/totara_sync/admin/syncexecute.php
[Tue Jul 30 09:39:57 2013] [error] [client 10.10.0.131] FastCGI: server "/mnt/data/environment_cache/10075/http/php5-10075.fcgi" stderr: * line 105 of /admin/tool/totara_sync/lib.php: call to totara_sync_element_user->sync(), referer: https://md.expertlearning.net/admin/tool/totara_sync/admin/syncexecute.php
[Tue Jul 30 09:39:57 2013] [error] [client 10.10.0.131] FastCGI: server "/mnt/data/environment_cache/10075/http/php5-10075.fcgi" stderr: * line 51 of /admin/tool/totara_sync/admin/syncexecute.php: call to tool_totara_sync_cron(), referer: https://md.expertlearning.net/admin/tool/totara_sync/admin/syncexecute.php

 

One each subsequent run more users are imported. Now I am having a hunch that this is due to manager dependencies causing problems. I could have sworn that Totara sync used to sort out the Manager relationships correctly, regardless of order in the input file.

I am going to attempt import of all users and leave the manager id field blank for first run, though I don't think this should be necessary.

 
永久链接 | 回复
??
Re: Totara Sync Error "active database transaction detected when disposing database"
由 ?? 发表于 2013年07月30日 Tuesday 09:33
 

I imported all the users with out manager assignments first, and then imported again with manager assignments and it worked. Can anyone confirm whether or not Totara sync is supposed to figure out the import order of the user.csv file based upon manager assignment dependencies? ie manager record must be created before the user record that is assigned to the manager.

 

Thanks

 
永久链接 | 显示父帖子 | 回复
me
Re: Totara Sync Error "active database transaction detected when disposing database"
由 AngusGeorge 发表于 2013年07月30日 Tuesday 17:01
小组 Totara

Hi Jamie,

There is a patch being worked on now, and subject to testing, it should be available in the near future.

regards,

George.

 
永久链接 | 显示父帖子 | 回复
??
Re: Totara Sync Error "active database transaction detected when disposing database"
由 ?? 发表于 2013年08月1日 Thursday 09:07
 

Thank you George, much appreciated.

 
永久链接 | 显示父帖子 | 回复
ZaccaroUmberto
Re: Totara Sync Error "active database transaction detected when disposing database"
由 ZaccaroUmberto 发表于 2013年08月2日 Friday 08:54
小组 Partners

Hi Everybody,

I encountered the same error about managers importing . In my case I have three levels of manager also. I hope that the patch will be available soon.

But I have another question, let me know if I have to open another discussion for this.

My issue is related to work flow of Totara sync. When Totara sync finds an error then highlights this and stops to import next data.

I don't know if there is any setting that I have to enable but in this manner we have a lot of problems because if there is an error on top of file, all other data are not imported.

Let me know any workaround about this.

Thank you very much indeed.

Kind Regards

Umberto

 
永久链接 | 显示父帖子 | 回复
me
Re: Totara Sync Error "active database transaction detected when disposing database"
由 AngusGeorge 发表于 2013年08月5日 Monday 20:38
小组 Totara

Hi,

The patching being tested will only exlude the bad record, the import will continue with the other records. Should be avaiable for the next release - 2 weeks 2.4 (20/08/13) 3 weeks 2.2 (27/08/13).

regards,

George.

 
永久链接 | 显示父帖子 | 回复
ZaccaroUmberto
Re: Totara Sync Error "active database transaction detected when disposing database"
由 ZaccaroUmberto 发表于 2013年08月26日 Monday 01:29
小组 Partners

Hi George,

Great, .

Thank you very much.

Kind Regards

Umberto

 
永久链接 | 显示父帖子 | 回复