Table "backup_ids_temp" already exists error

Table "backup_ids_temp" already exists error

by Leonid Rabinovich -
Number of replies: 3

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: -
In reply to Leonid Rabinovich

Re: Table "backup_ids_temp" already exists error

by Ken Task -
Picture of 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:

http://manage.resellerclub.com/kb/servlet/KBServlet/faq1467.html

might help.

'spirit of sharing', Ken

Average of ratings: Useful (1)
In reply to Ken Task

Re: Table "backup_ids_temp" already exists error

by Leonid Rabinovich -

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: -
In reply to Leonid Rabinovich

Re: Table "backup_ids_temp" already exists error

by Darren Dickson -

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: -