Backup and restore

Table "backup_ids_temp" already exists error

Picture of Leonid Rabinovich
Table "backup_ids_temp" already exists error

Does anyone have a fix for the error below? We run Moodle 2.3.1 on Windows 2008 R2, MS-SQL 2008 R2, and IIS 7.5.

Table "backup_ids_temp" already exists

More information about this error

Debug info:
Error code: ddltablealreadyexists

Stack trace:

  • line 440 of \lib\ddl\database_manager.php: ddl_exception thrown
  • line 159 of \backup\util\dbops\backup_controller_dbops.class.php: call to database_manager->create_temp_table()
  • line 106 of \backup\util\dbops\backup_controller_dbops.class.php: call to backup_controller_dbops::create_temptable_from_real_table()
  • line 40 of \backup\moodle2\backup_stepslib.php: call to backup_controller_dbops::create_backup_ids_temp_table()
  • line 34 of \backup\util\plan\backup_execution_step.class.php: call to create_and_clean_temp_stuff->define_execution()
  • line 153 of \backup\util\plan\base_task.class.php: call to backup_execution_step->execute()
  • line 163 of \backup\util\plan\base_plan.class.php: call to base_task->execute()
  • line 110 of \backup\util\plan\backup_plan.class.php: call to base_plan->execute()
  • line 309 of \backup\controller\backup_controller.class.php: call to backup_plan->execute()
  • line 111 of \backup\util\ui\backup_ui.class.php: call to backup_controller->execute_plan()
  • line 89 of \backup\backup.php: call to backup_ui->execute()
Average of ratings: -
Picture of Ken Task
Re: Table "backup_ids_temp" already exists error
Particularly helpful Moodlers

Qualification for this response: don't run Windows, but have seen something similar on Linux platform.

The 'create_temp_table' is probably the cause of all that follows.

Does the DBuser in your config have capability to create temp table as well as remove temp tables?  Can't tell ya how to do that with MSSQL specifically, but can Google:

might help.

'spirit of sharing', Ken

Average of ratings: Useful (1)
Picture of Leonid Rabinovich
Re: Table "backup_ids_temp" already exists error

An update to the "backup_ids_temp" already exists error:

Following Ken’s suggestions, I checked permissions for the DBUser. The permission were assigned correctly. DBUser is the owner of the database.

The fix for this effort was going into the database and deleting backup_ids_temp table.

 Hope that will help other people that will come across this error.

 Thanks to Ken for his effort in trying to solve this problem.


Average of ratings: -
Picture of Darren Dickson
Re: Table "backup_ids_temp" already exists error

Thankyou so much for this. I've had this problem sitting there for months, now all is well. 

For anyone else with this problem, in cpanel, go to phpAdmin. I just renamed the backup_ids_temp file. 

Average of ratings: -