search

cockroachdb / cockroach

CockroachDB — the cloud native, distributed SQL database designed for high availability, effortless scale, and control over data placement.
https://www.cockroachlabs.com
Other
30.01k stars 3.79k forks source link

temp tables/sequences not cleaned up on session end #51219

Closed donbowman closed 4 years ago

donbowman commented 4 years ago

Describe the problem

I have a single session (the shell I am using to check). Previously other sessions created temp tables and sequences. I find that these temp table/seq still exist in the crdb_internal.* tables, despite their underlying sessions being gone.

I was of the impression that when those sessions end, their temp things ended.

root@localhost:26257/agilicus_lms_env_db> select distinct schema_name from crdb_internal.create_statements;
           schema_name
---------------------------------
  crdb_internal
  information_schema
  pg_catalog
  public
  pg_temp_1592611233840326220_1
  pg_temp_1592697642215586218_1
  pg_temp_1592784054596510773_1
  pg_temp_1592870470458956921_3
  pg_temp_1592956843573546107_2
  pg_temp_1593043256512842084_3
  pg_temp_1593129640759818205_2
  pg_temp_1593216015584196889_1
  pg_temp_1593302440292203329_3
  pg_temp_1593388811719538606_2
  pg_temp_1593475247572500815_3
  pg_temp_1593561662530338930_1
  pg_temp_1593648035713663811_3
  pg_temp_1593734458074702328_3
  pg_temp_1593815355359562860_3
  pg_temp_1593820828026213893_1
  pg_temp_1593907225794068128_3
  pg_temp_1593993642619468573_1
  pg_temp_1594080014880784165_2
  pg_temp_1594166438845978085_1
  pg_temp_1594252865472912789_1
(25 rows)

Time: 4.60102227s
root@localhost:26257/agilicus_lms_env_db> show all sessions;
... 1 row for this cli, a couple for <admin> e.g. $ internal-create-stats,  $ internal-lease-release ... only 1 to this database.

To Reproduce

This is w/ iomad (moodle). It makes use of temp tables and sequences. I have stopped it, so it is no longer connecting, its temp tables appear to remain.

Expected behavior

I expect that if i start a session, create a temp table, create a temp sequence, end the session, that there are no remaining entries in crdb_internal. I believe this is part of why my dump is so slow. #51116

Environment:

Build Tag:    v20.1.3
Build Time:   2020/06/23 08:44:08
Distribution: CCL
Platform:     linux amd64 (x86_64-unknown-linux-gnu)
Go Version:   go1.13.9
C Compiler:   gcc 6.3.0
Build SHA-1:  7fd454f880f386cdd0eda6b21b12f6532c14f0db
Build Type:   release

the client that created the temp tables was php 7.4

Additional context

backup is very slow. Leak?

solongordon commented 4 years ago

Thank you for the report. You're right that these temp objects should be cleaned up on session exit.

I did a quick test and wasn't able to reproduce temporary schemas appearing in crdb_internal.create_statements after the session ends. Is it possible that one of your Cockroach nodes died recently? When a node does not exit gracefully, we rely on a periodic job to clean up the temporary objects associated with whatever sessions were connected to that node, so it can take up to 30 minutes for this cleanup to happen.

Note we also have an issue open for excluding temporary objects from backup: #50902

donbowman commented 4 years ago

at the time I did the test all 3 cockroach nodes were up 46h. i did a rolling restart of them, the problem remains.

the cluster was upgraded from 19.1 -> 20.0 -> 20.1.

is there a way to force trigger that job? or to observe it is running?

donbowman commented 4 years ago

some of these jobs show being running for many hours. The database is not large (494 tables, maybe ~100 rows in the largest table, the backup is about 9MiB).

I'm debugging a few problems:

root@cockroachdb-public:26257/agilicus_lms_env_db> show jobs;
        job_id       |     job_type     |                                          description                                          | statement |      user_name      |  status   | running_status |             created              |             started              |             finished             |             modified             | fraction_completed | error | coordinator_id  
+--------------------+------------------+-----------------------------------------------------------------------------------------------+-----------+---------------------+-----------+----------------+----------------------------------+----------------------------------+----------------------------------+----------------------------------+--------------------+-------+----------------+
  570824260536500227 | SCHEMA CHANGE GC | GC for TRUNCATE TABLE agilicus_lms_env_db.public.mdl_hvp_libraries_hub_cache                  |           | agilicus_lms_env_db | running   | NULL           | 2020-07-09 05:22:19.665631+00:00 | 2020-07-09 05:22:19.679352+00:00 | NULL                             | 2020-07-09 05:22:19.713452+00:00 |                  0 |       |              3  
  570796750130970626 | SCHEMA CHANGE GC | GC for TRUNCATE TABLE agilicus_lms_env_db.public.mdl_tag_correlation                          |           | agilicus_lms_env_db | running   | NULL           | 2020-07-09 03:02:24.15617+00:00  | 2020-07-09 03:02:24.177009+00:00 | NULL                             | 2020-07-09 03:02:24.196994+00:00 |                  0 |       |              2  
  570761166044233729 | SCHEMA CHANGE GC | GC for DROP TABLE agilicus_lms_env_db.pg_temp_1594252865472912789_1.mdl_temp_enroled          |           | agilicus_lms_env_db | running   | NULL           | 2020-07-09 00:01:24.754707+00:00 | 2020-07-09 00:01:24.778299+00:00 | NULL                             | 2020-07-09 00:01:24.825903+00:00 |                  0 |       |              1  
  570761164880150529 | SCHEMA CHANGE GC | GC for DROP TABLE agilicus_lms_env_db.pg_temp_1594252865472912789_1.mdl_temp_stats_user_daily |           | agilicus_lms_env_db | running   | NULL           | 2020-07-09 00:01:24.399451+00:00 | 2020-07-09 00:01:24.416088+00:00 | NULL                             | 2020-07-09 00:01:24.448156+00:00 |                  0 |       |              1  
  570761163605344257 | SCHEMA CHANGE GC | GC for DROP TABLE agilicus_lms_env_db.pg_temp_1594252865472912789_1.mdl_temp_stats_daily      |           | agilicus_lms_env_db | running   | NULL           | 2020-07-09 00:01:24.010407+00:00 | 2020-07-09 00:01:24.033437+00:00 | NULL                             | 2020-07-09 00:01:24.066139+00:00 |                  0 |       |              1  
  570761162159685633 | SCHEMA CHANGE GC | GC for DROP TABLE agilicus_lms_env_db.pg_temp_1594252865472912789_1.mdl_temp_log2             |           | agilicus_lms_env_db | running   | NULL           | 2020-07-09 00:01:23.56923+00:00  | 2020-07-09 00:01:23.595026+00:00 | NULL                             | 2020-07-09 00:01:23.631691+00:00 |                  0 |       |              1  
  570761161091710977 | SCHEMA CHANGE GC | GC for DROP TABLE agilicus_lms_env_db.pg_temp_1594252865472912789_1.mdl_temp_log1             |           | agilicus_lms_env_db | running   | NULL           | 2020-07-09 00:01:23.243311+00:00 | 2020-07-09 00:01:23.258032+00:00 | NULL                             | 2020-07-09 00:01:23.292+00:00    |                  0 |       |              1  
  570541167769190403 | SCHEMA CHANGE GC | GC for TRUNCATE TABLE agilicus_lms_env_db.public.mdl_hvp_libraries_hub_cache                  |           | agilicus_lms_env_db | succeeded | NULL           | 2020-07-08 05:22:26.609186+00:00 | 2020-07-08 05:22:26.627931+00:00 | 2020-07-09 06:22:27.056152+00:00 | 2020-07-09 06:22:27.044708+00:00 |                  1 |       |              3  
  570824259855319043 | SCHEMA CHANGE    | creating new descriptor for truncated table                                                   |           | agilicus_lms_env_db | succeeded | NULL           | 2020-07-09 05:22:19.395867+00:00 | 2020-07-09 05:22:19.693845+00:00 | 2020-07-09 05:22:19.747926+00:00 | 2020-07-09 05:22:19.743868+00:00 |                  1 |       |              3  
  570824259733291011 | SCHEMA CHANGE    | TRUNCATE TABLE agilicus_lms_env_db.public.mdl_hvp_libraries_hub_cache                         |           | agilicus_lms_env_db | succeeded | NULL           | 2020-07-09 05:22:19.395867+00:00 | 2020-07-09 05:22:19.636472+00:00 | 2020-07-09 05:22:19.707404+00:00 | 2020-07-09 05:22:19.701312+00:00 |                  1 |       |              3  
  570824259799875587 | SCHEMA CHANGE    | updating reference for truncated table                                                        |           | agilicus_lms_env_db | succeeded | NULL           | 2020-07-09 05:22:19.395867+00:00 | 2020-07-09 05:22:19.669373+00:00 | 2020-07-09 05:22:19.70411+00:00  | 2020-07-09 05:22:19.69734+00:00  |                  1 |       |              3  
  570513767325630465 | SCHEMA CHANGE GC | GC for TRUNCATE TABLE agilicus_lms_env_db.public.mdl_tag_correlation                          |           | agilicus_lms_env_db | succeeded | NULL           | 2020-07-08 03:03:04.657467+00:00 | 2020-07-08 03:03:04.673274+00:00 | 2020-07-09 04:03:05.1305+00:00   | 2020-07-09 04:03:05.119737+00:00 |                  1 |       |              1  
(12 rows)

I don't see a job for GC for temp schema?

rohany commented 4 years ago

some of these jobs show being running for many hours.

These GC for ... jobs occur are long running jobs that just wait for the gc.ttl of the table elapse before reclaiming the data used by the table. When table is first dropped, you'll see a much shorter job DROP TABLE ... that runs and starts these GC jobs.

The temporary object cleaning job deletes temporary schema entries, but is not hooked into the jobs framework to be visible to the output of SHOW JOBS.

donbowman commented 4 years ago

i was looking @ the delta between started and finished: 2020-07-08 05:22:26.627931+00:00 | 2020-07-09 06:22:27.056152+00:00

it seems its an hour.

how would i see why my temp tables & sequences don't get cleanup then?

rohany commented 4 years ago

If you look at your logs, are there messages present like temporary object cleaner next scheduled to run at or failed to clean temp objects:? These might give some insight into what the temporary object cleaner is doing.

donbowman commented 4 years ago 
W200709 20:02:02.843692 282 sql/temporary_schema.go:438  [n2] error during schema cleanup, retrying: relation "mdl_analytics_indicator_calc" does not exist
W200709 20:02:04.011554 282 sql/temporary_schema.go:438  [n2] error during schema cleanup, retrying: relation "mdl_analytics_indicator_calc" does not exist
W200709 20:02:06.165591 282 sql/temporary_schema.go:438  [n2] error during schema cleanup, retrying: relation "mdl_analytics_indicator_calc" does not exist
W200709 20:02:09.971491 282 sql/temporary_schema.go:438  [n2] error during schema cleanup, retrying: relation "mdl_analytics_indicator_calc" does not exist
W200709 20:02:18.918489 282 sql/temporary_schema.go:438  [n2] error during schema cleanup, retrying: relation "mdl_analytics_indicator_calc" does not exist
W200709 20:02:18.918547 282 sql/temporary_schema.go:537  [n2] failed to clean temp objects under session "161dc671e9b643430000000000000003": relation "mdl_analytics_indicator_calc" does not exist
donbowman commented 4 years ago

the above message occurs over and over again. how can i rescue it?

rohany commented 4 years ago

This might be caused by some dangling namespace entries. I would look at system.namespace and system.descriptor. In particular, see if there is a namespace entry for this table mdl_analytics_indicator_calc by doing SELECT * FROM system.namespace WHERE name='mdl_analytics_indicator_calc'. The ID here should correspond to an entry in the system.descriptor table (i.e. SELECT * FROM system.descriptor WHERE id = <id from the first query>) should exist. If that's not the case, we can move on from there.

donbowman commented 4 years ago 
root@cockroachdb-public:26257/agilicus_lms_env_db> SELECT * FROM system.namespace WHERE name='mdl_analytics_indicator_calc';
  parentID | parentSchemaID |             name             | id   
+----------+----------------+------------------------------+-----+
       127 |             29 | mdl_analytics_indicator_calc | 533  
(1 row)
SELECT * FROM system.descriptor WHERE id = 127;
  id  |                                                                    descriptor                                                                      
+-----+---------------------------------------------------------------------------------------------------------------------------------------------------+
  127 | \022G\012\023agilicus_lms_env_db\020\177\032.\012\011\012\005admin\020\002\012\027\012\023agilicus_lms_env_db\020\002\012\010\012\004root\020\002  
(1 row)

Time: 1.50305ms
SELECT * FROM system.descriptor WHERE id = 533;
  id  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   descriptor                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
+-----+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  533 | \012\365\006\012\034mdl_analytics_indicator_calc\030\225\004 \177(\007:\012\010\201\256\212\361\232\314\215\202\026BR\012\002id\020\001\032\012\010\001\020@\030\0000\000P\024 \000*7nextval('mdl_analytics_indicator_calc_id_seq':::STRING)0\000P\226\004B\035\012\011starttime\020\002\032\012\010\001\020@\030\0000\000P\024 \0000\000B\033\012\007endtime\020\003\032\012\010\001\020@\030\0000\000P\024 \0000\000B\035\012\011contextid\020\004\032\012\010\001\020@\030\0000\000P\024 \0000\000B/\012\014sampleorigin\020\005\032\014\010\007\020\377\001\030\0000\007P\223\010 \000*\013'':::STRING0\000B\034\012\010sampleid\020\006\032\012\010\001\020@\030\0000\000P\024 \0000\000B,\012\011indicator\020\007\032\014\010\007\020\377\001\030\0000\007P\223\010 \000*\013'':::STRING0\000B\032\012\005value\020\010\032\013\010\003\020\002\030\0120\000P\244\015 \0010\000B\037\012\013timecreated\020\011\032\012\010\001\020@\030\0000\000P\024 \0000\000H\012R?\012\026mdl_analindicalc_id_pk\020\001\030\001"\002id0\001@\000J\020\010\000\020\000\032\000 \000(\0000\0008\000@\000Z\000z\002\010\000\200\001\000Zk\012\035mdl_analindicalc_staendcon_ix\020\002\030\000"\011starttime"\007endtime"\011contextid0\0020\0030\0048\001@\000@\000@\000J\020\010\000\020\000\032\000 \000(\0000\0008\000@\000Z\000z\002\010\000\200\001\000ZI\012\027mdl_analindicalc_con_ix\020\003\030\000"\011contextid0\0048\001@\000J\020\010\000\020\000\032\000 \000(\0000\0008\000@\000Z\000z\002\010\000\200\001\000`\004j.\012\011\012\005admin\020\002\012\027\012\023agilicus_lms_env_db\020\002\012\010\012\004root\020\002\200\001\003\210\001\003\230\001\000\262\001y\012\007primary\020\000\032\002id\032\011starttime\032\007endtime\032\011contextid\032\014sampleorigin\032\010sampleid\032\011indicator\032\005value\032\013timecreated \001 \002 \003 \004 \005 \006 \007 \010 \011(\000\270\001\001\302\001\000\350\001\000\362\001\004\010\000\022\000\370\001\000\200\002\000\222\002\000\232\002\012\010\336\265\257\246\230\314\215\202\026\262\002\000  
(1 row)

Time: 3.810422ms
root@cockroachdb-public:26257/agilicus_lms_env_db> SELECT * FROM system.descriptor WHERE id = 29;
  id | descriptor  
+----+------------+
(0 rows)
rohany commented 4 years ago

I see, so that's not the issue. Do you think you could provide us a with debug.zip collected from your cluster? It would make it easier for us to look into the logs and other state.

otan commented 4 years ago

Also, did you ever RENAME this temporary table, or do any sort of ALTER table on it?

arulajmani commented 4 years ago

I'm thinking that the relation mdl_analytics_indicator_calc is erroneously being read when we scan for temporary objects during cleanup. This could happen if the relation was created before the cluster was upgraded. Would it be possible to validate my hypothesis by running SELECT * FROM [2 AS namespace] WHERE name='mdl_analytics_indicator_calc';? Thanks!

donbowman commented 4 years ago 
root@cockroachdb-public:26257/agilicus_lms_env_db> SELECT * FROM [2 AS namespace];
  parentID |                  name                   |  id   
+----------+-----------------------------------------+------+
         0 | agilicus_lms_env_db                     |  127  
         0 | auth_agilicus                           |  115  
         0 | auth_agilicus_dev                       |   82  
         0 | auth_city_of_waterloo                   |  103  
         0 | auth_egov                               |   92  
         0 | auth_watstaging                         |   72  
         0 | defaultdb                               |   50  
         0 | dex                                     |   52  
         0 | moodle                                  |  116  
         0 | postgres                                |   51  
         0 | system                                  |    1  
         1 | comments                                |   24  
         1 | descriptor                              |    3  
         1 | eventlog                                |   12  
         1 | jobs                                    |   15  
         1 | lease                                   |   11  
         1 | locations                               |   21  
         1 | namespace                               |    2  
         1 | protected_ts_meta                       |   31  
         1 | protected_ts_records                    |   32  
         1 | rangelog                                |   13  
         1 | replication_constraint_stats            |   25  
         1 | replication_critical_localities         |   26  
         1 | replication_stats                       |   27  
         1 | reports_meta                            |   28  
         1 | role_members                            |   23  
         1 | role_options                            |   33  
         1 | settings                                |    6  
         1 | statement_bundle_chunks                 |   34  
         1 | statement_diagnostics                   |   36  
         1 | statement_diagnostics_requests          |   35  
         1 | table_statistics                        |   20  
         1 | ui                                      |   14  
         1 | users                                   |    4  
         1 | web_sessions                            |   19  
         1 | zones                                   |    5  
        52 | auth_code                               |   56  
        52 | auth_request                            |   55  
        52 | client                                  |   54  
        52 | connector                               |   61  
        52 | keys                                    |   59  
        52 | migrations                              |   53  
        52 | offline_session                         |   60  
        52 | password                                |   58  
        52 | refresh_token                           |   57  
        72 | auth_code                               |   76  
        72 | auth_request                            |   75  
        72 | client                                  |   74  
        72 | connector                               |   81  
        72 | keys                                    |   79  
        72 | migrations                              |   73  
        72 | offline_session                         |   80  
        72 | password                                |   78  
        72 | refresh_token                           |   77  
        82 | auth_code                               |   86  
        82 | auth_request                            |   85  
        82 | client                                  |   84  
        82 | connector                               |   91  
        82 | keys                                    |   89  
        82 | migrations                              |   83  
        82 | offline_session                         |   90  
        82 | offline_session_v2                      |  102  
        82 | password                                |   88  
        82 | refresh_token                           |   87  
        82 | session_info                            | 1744  
        82 | session_redirect                        | 1854  
        92 | auth_code                               |   96  
        92 | auth_request                            |   95  
        92 | client                                  |   94  
        92 | connector                               |  101  
        92 | keys                                    |   99  
        92 | migrations                              |   93  
        92 | offline_session                         |  100  
        92 | offline_session_v2                      |  114  
        92 | password                                |   98  
        92 | refresh_token                           |   97  
        92 | session_info                            | 1766  
        92 | session_redirect                        | 1853  
       103 | auth_code                               |  107  
       103 | auth_request                            |  106  
       103 | client                                  |  105  
       103 | connector                               |  112  
       103 | keys                                    |  110  
       103 | migrations                              |  104  
       103 | offline_session                         |  111  
       103 | offline_session_v2                      |  113  
       103 | password                                |  109  
       103 | refresh_token                           |  108  
       103 | session_info                            | 1745  
       103 | session_redirect                        | 1839  
       115 | auth_code                               |  120  
       115 | auth_request                            |  119  
       115 | client                                  |  118  
       115 | connector                               |  125  
       115 | keys                                    |  123  
       115 | migrations                              |  117  
       115 | offline_session                         |  124  
       115 | offline_session_v2                      |  126  
       115 | password                                |  122  
       115 | refresh_token                           |  121  
       115 | session_info                            | 1767  
       115 | session_redirect                        | 1855  
       127 | mdl_analytics_indicator_calc            |  533  
       127 | mdl_analytics_indicator_calc_id_seq     |  534  
       127 | mdl_analytics_models                    |  521  
       127 | mdl_analytics_models_id_seq             |  522  
       127 | mdl_analytics_models_log                |  523  
       127 | mdl_analytics_models_log_id_seq         |  524  
       127 | mdl_analytics_predict_samples           |  529  
       127 | mdl_analytics_predict_samples_id_seq    |  530  
       127 | mdl_analytics_prediction_actions        |  535  
       127 | mdl_analytics_prediction_actions_id_seq |  536  
       127 | mdl_analytics_predictions               |  525  
       127 | mdl_analytics_predictions_id_seq        |  526  
       127 | mdl_analytics_train_samples             |  527  
       127 | mdl_analytics_train_samples_id_seq      |  528  
       127 | mdl_analytics_used_analysables          |  539  
       127 | mdl_analytics_used_analysables_id_seq   |  540  
       127 | mdl_analytics_used_files                |  531  
       127 | mdl_analytics_used_files_id_seq         |  532  
       127 | mdl_assign                              |  609  
       127 | mdl_assign_grades                       |  613  
       127 | mdl_assign_grades_id_seq                |  614  
       127 | mdl_assign_id_seq                       |  610  
       127 | mdl_assign_overrides                    |  621  
       127 | mdl_assign_overrides_id_seq             |  622  
       127 | mdl_assign_plugin_config                |  615  
       127 | mdl_assign_plugin_config_id_seq         |  616  
       127 | mdl_assign_submission                   |  611  
       127 | mdl_assign_submission_id_seq            |  612  
       127 | mdl_assign_user_flags                   |  619  
       127 | mdl_assign_user_flags_id_seq            |  620  
       127 | mdl_assign_user_mapping                 |  617  
       127 | mdl_assign_user_mapping_id_seq          |  618  
       127 | mdl_assignfeedback_comments             | 1049  
       127 | mdl_assignfeedback_comments_id_seq      | 1050  
       127 | mdl_assignfeedback_editpdf_annot        | 1053  
       127 | mdl_assignfeedback_editpdf_annot_id_seq | 1054  
       127 | mdl_assignfeedback_editpdf_cmnt         | 1051  
       127 | mdl_assignfeedback_editpdf_cmnt_id_seq  | 1052  
       127 | mdl_assignfeedback_editpdf_queue        | 1057  
       127 | mdl_assignfeedback_editpdf_queue_id_seq | 1058  
       127 | mdl_assignfeedback_editpdf_quick        | 1055  
       127 | mdl_assignfeedback_editpdf_quick_id_seq | 1056  
       127 | mdl_assignfeedback_editpdf_rot          | 1059  
       127 | mdl_assignfeedback_editpdf_rot_id_seq   | 1060  
       127 | mdl_assignfeedback_file                 | 1061  
       127 | mdl_assignfeedback_file_id_seq          | 1062  
       127 | mdl_assignment                          |  623  
       127 | mdl_assignment_id_seq                   |  624  
       127 | mdl_assignment_submissions              |  625  
       127 | mdl_assignment_submissions_id_seq       |  626  
       127 | mdl_assignment_upgrade                  |  627  
       127 | mdl_assignment_upgrade_id_seq           |  628  
       127 | mdl_assignsubmission_file               | 1045  
       127 | mdl_assignsubmission_file_id_seq        | 1046  
       127 | mdl_assignsubmission_onlinetext         | 1047  
       127 | mdl_assignsubmission_onlinetext_id_seq  | 1048  
       127 | mdl_auth_iomadoidc_prevlogin            |  827  
       127 | mdl_auth_iomadoidc_prevlogin_id_seq     |  828  
       127 | mdl_auth_iomadoidc_state                |  829  
       127 | mdl_auth_iomadoidc_state_id_seq         |  830  
       127 | mdl_auth_iomadoidc_token                |  831  
       127 | mdl_auth_iomadoidc_token_id_seq         |  832  
       127 | mdl_auth_oauth2_linked_login            |  833  
       127 | mdl_auth_oauth2_linked_login_id_seq     |  834  
       127 | mdl_backup_controllers                  |  417  
       127 | mdl_backup_controllers_id_seq           |  418  
       127 | mdl_backup_courses                      |  387  
       127 | mdl_backup_courses_id_seq               |  388  
       127 | mdl_backup_logs                         |  419  
       127 | mdl_backup_logs_id_seq                  |  420  
       127 | mdl_badge                               |  433  
       127 | mdl_badge_alignment                     |  453  
       127 | mdl_badge_alignment_id_seq              |  454  
       127 | mdl_badge_backpack                      |  447  
       127 | mdl_badge_backpack_id_seq               |  448  
       127 | mdl_badge_criteria                      |  435  
       127 | mdl_badge_criteria_id_seq               |  436  
       127 | mdl_badge_criteria_met                  |  441  
       127 | mdl_badge_criteria_met_id_seq           |  442  
       127 | mdl_badge_criteria_param                |  437  
       127 | mdl_badge_criteria_param_id_seq         |  438  
       127 | mdl_badge_endorsement                   |  443  
       127 | mdl_badge_endorsement_id_seq            |  444  
       127 | mdl_badge_external                      |  449  
       127 | mdl_badge_external_backpack             |  457  
       127 | mdl_badge_external_backpack_id_seq      |  458  
       127 | mdl_badge_external_id_seq               |  450  
       127 | mdl_badge_external_identifier           |  451  
       127 | mdl_badge_external_identifier_id_seq    |  452  
       127 | mdl_badge_id_seq                        |  434  
       127 | mdl_badge_issued                        |  439  
       127 | mdl_badge_issued_id_seq                 |  440  
       127 | mdl_badge_manual_award                  |  445  
       127 | mdl_badge_manual_award_id_seq           |  446  
       127 | mdl_badge_related                       |  455  
       127 | mdl_badge_related_id_seq                |  456  
       127 | mdl_block                               |  389  
       127 | mdl_block_id_seq                        |  390  
       127 | mdl_block_instances                     |  391  
       127 | mdl_block_instances_id_seq              |  392  
       127 | mdl_block_iomad_approve_access          |  867  
       127 | mdl_block_iomad_approve_access_id_seq   |  868  
       127 | mdl_block_iomad_microlearning           |  881  
       127 | mdl_block_iomad_microlearning_id_seq    |  882  
       127 | mdl_block_positions                     |  393  
       127 | mdl_block_positions_id_seq              |  394  
       127 | mdl_block_recent_activity               |  891  
       127 | mdl_block_recent_activity_id_seq        |  892  
       127 | mdl_block_recentlyaccesseditems         |  893  
       127 | mdl_block_recentlyaccesseditems_id_seq  |  894  
       127 | mdl_block_rss_client                    |  895  
       127 | mdl_block_rss_client_id_seq             |  896  
       127 | mdl_blog_association                    |  407  
       127 | mdl_blog_association_id_seq             |  408  
       127 | mdl_blog_external                       |  409  
       127 | mdl_blog_external_id_seq                |  410  
       127 | mdl_book                                |  629  
       127 | mdl_book_chapters                       |  631  
       127 | mdl_book_chapters_id_seq                |  632  
       127 | mdl_book_id_seq                         |  630  
       127 | mdl_cache_filters                       |  168  
       127 | mdl_cache_filters_id_seq                |  169  
       127 | mdl_cache_flags                         |  357  
       127 | mdl_cache_flags_id_seq                  |  358  
       127 | mdl_capabilities                        |  235  
       127 | mdl_capabilities_id_seq                 |  236  
       127 | mdl_certificate_serialnumber            | 1035  
       127 | mdl_certificate_serialnumber_id_seq     | 1036  
       127 | mdl_chat                                |  633  
       127 | mdl_chat_id_seq                         |  634  
       127 | mdl_chat_messages                       |  635  
       127 | mdl_chat_messages_current               |  637  
       127 | mdl_chat_messages_current_id_seq        |  638  
       127 | mdl_chat_messages_id_seq                |  636  
       127 | mdl_chat_users                          |  639  
       127 | mdl_chat_users_id_seq                   |  640  
       127 | mdl_choice                              |  641  
       127 | mdl_choice_answers                      |  645  
       127 | mdl_choice_answers_id_seq               |  646  
       127 | mdl_choice_id_seq                       |  642  
       127 | mdl_choice_options                      |  643  
       127 | mdl_choice_options_id_seq               |  644  
       127 | mdl_classroom                           |  993  
       127 | mdl_classroom_id_seq                    |  994  
       127 | mdl_cohort                              |  349  
       127 | mdl_cohort_id_seq                       |  350  
       127 | mdl_cohort_members                      |  351  
       127 | mdl_cohort_members_id_seq               |  352  
       127 | mdl_comments                            |  395  
       127 | mdl_comments_id_seq                     |  396  
       127 | mdl_company                             |  977  
       127 | mdl_company_comp_frameworks             | 1005  
       127 | mdl_company_comp_frameworks_id_seq      | 1006  
       127 | mdl_company_comp_templates              | 1007  
       127 | mdl_company_comp_templates_id_seq       | 1008  
       127 | mdl_company_course                      |  979  
       127 | mdl_company_course_groups               |  989  
       127 | mdl_company_course_groups_id_seq        |  990  
       127 | mdl_company_course_id_seq               |  980  
       127 | mdl_company_created_courses             |  997  
       127 | mdl_company_created_courses_id_seq      |  998  
       127 | mdl_company_domains                     | 1003  
       127 | mdl_company_domains_id_seq              | 1004  
       127 | mdl_company_id_seq                      |  978  
       127 | mdl_company_role_restriction            | 1001  
       127 | mdl_company_role_restriction_id_seq     | 1002  
       127 | mdl_company_role_templates              | 1017  
       127 | mdl_company_role_templates_ass          | 1021  
       127 | mdl_company_role_templates_ass_id_seq   | 1022  
       127 | mdl_company_role_templates_caps         | 1019  
       127 | mdl_company_role_templates_caps_id_seq  | 1020  
       127 | mdl_company_role_templates_id_seq       | 1018  
       127 | mdl_company_shared_courses              |  995  
       127 | mdl_company_shared_courses_id_seq       |  996  
       127 | mdl_company_shared_frameworks           | 1015  
       127 | mdl_company_shared_frameworks_id_seq    | 1016  
       127 | mdl_company_shared_templates            | 1013  
       127 | mdl_company_shared_templates_id_seq     | 1014  
       127 | mdl_company_transient_tokens            | 1025  
       127 | mdl_company_transient_tokens_id_seq     | 1026  
       127 | mdl_company_users                       |  999  
       127 | mdl_company_users_id_seq                | 1000  
       127 | mdl_companycertificate                  | 1023  
       127 | mdl_companycertificate_id_seq           | 1024  
       127 | mdl_companylicense                      |  983  
       127 | mdl_companylicense_courses              |  987  
       127 | mdl_companylicense_courses_id_seq       |  988  
       127 | mdl_companylicense_id_seq               |  984  
       127 | mdl_companylicense_users                |  985  
       127 | mdl_companylicense_users_id_seq         |  986  
       127 | mdl_competency                          |  477  
       127 | mdl_competency_coursecomp               |  483  
       127 | mdl_competency_coursecomp_id_seq        |  484  
       127 | mdl_competency_coursecompsetting        |  479  
       127 | mdl_competency_coursecompsetting_id_seq |  480  
       127 | mdl_competency_evidence                 |  503  
       127 | mdl_competency_evidence_id_seq          |  504  
       127 | mdl_competency_framework                |  481  
       127 | mdl_competency_framework_id_seq         |  482  
       127 | mdl_competency_id_seq                   |  478  
       127 | mdl_competency_modulecomp               |  509  
       127 | mdl_competency_modulecomp_id_seq        |  510  
       127 | mdl_competency_plan                     |  485  
       127 | mdl_competency_plan_id_seq              |  486  
       127 | mdl_competency_plancomp                 |  501  
       127 | mdl_competency_plancomp_id_seq          |  502  
       127 | mdl_competency_relatedcomp              |  493  
       127 | mdl_competency_relatedcomp_id_seq       |  494  
       127 | mdl_competency_template                 |  487  
       127 | mdl_competency_template_id_seq          |  488  
       127 | mdl_competency_templatecohort           |  491  
       127 | mdl_competency_templatecohort_id_seq    |  492  
       127 | mdl_competency_templatecomp             |  489  
       127 | mdl_competency_templatecomp_id_seq      |  490  
       127 | mdl_competency_usercomp                 |  495  
       127 | mdl_competency_usercomp_id_seq          |  496  
       127 | mdl_competency_usercompcourse           |  497  
       127 | mdl_competency_usercompcourse_id_seq    |  498  
       127 | mdl_competency_usercompplan             |  499  
       127 | mdl_competency_usercompplan_id_seq      |  500  
       127 | mdl_competency_userevidence             |  505  
       127 | mdl_competency_userevidence_id_seq      |  506  
       127 | mdl_competency_userevidencecomp         |  507  
       127 | mdl_competency_userevidencecomp_id_seq  |  508  
       127 | mdl_config                              |  128  
       127 | mdl_config_id_seq                       |  129  
       127 | mdl_config_log                          |  132  
       127 | mdl_config_log_id_seq                   |  133  
       127 | mdl_config_plugins                      |  130  
       127 | mdl_config_plugins_id_seq               |  131  
       127 | mdl_context                             |  232  
       127 | mdl_context_id_seq                      |  233  
       127 | mdl_context_temp                        |  234  
       127 | mdl_course                              |  136  
       127 | mdl_course_categories                   |  138  
       127 | mdl_course_categories_id_seq            |  139  
       127 | mdl_course_completion_aggr_methd        |  140  
       127 | mdl_course_completion_aggr_methd_id_seq |  141  
       127 | mdl_course_completion_crit_compl        |  144  
       127 | mdl_course_completion_crit_compl_id_seq |  145  
       127 | mdl_course_completion_criteria          |  142  
       127 | mdl_course_completion_criteria_id_seq   |  143  
       127 | mdl_course_completion_defaults          |  519  
       127 | mdl_course_completion_defaults_id_seq   |  520  
       127 | mdl_course_completions                  |  146  
       127 | mdl_course_completions_id_seq           |  147  
       127 | mdl_course_format_options               |  160  
       127 | mdl_course_format_options_id_seq        |  161  
       127 | mdl_course_id_seq                       |  137  
       127 | mdl_course_modules                      |  152  
       127 | mdl_course_modules_completion           |  154  
       127 | mdl_course_modules_completion_id_seq    |  155  
       127 | mdl_course_modules_id_seq               |  153  
       127 | mdl_course_published                    |  423  
       127 | mdl_course_published_id_seq             |  424  
       127 | mdl_course_request                      |  158  
       127 | mdl_course_request_id_seq               |  159  
       127 | mdl_course_sections                     |  156  
       127 | mdl_course_sections_id_seq              |  157  
       127 | mdl_course_shopblockprice               |  873  
       127 | mdl_course_shopblockprice_id_seq        |  874  
       127 | mdl_course_shopsettings                 |  875  
       127 | mdl_course_shopsettings_id_seq          |  876  
       127 | mdl_course_shoptag                      |  879  
       127 | mdl_course_shoptag_id_seq               |  880  
       127 | mdl_customfield_category                |  545  
       127 | mdl_customfield_category_id_seq         |  546  
       127 | mdl_customfield_data                    |  549  
       127 | mdl_customfield_data_id_seq             |  550  
       127 | mdl_customfield_field                   |  547  
       127 | mdl_customfield_field_id_seq            |  548  
       127 | mdl_data                                |  647  
       127 | mdl_data_content                        |  653  
       127 | mdl_data_content_id_seq                 |  654  
       127 | mdl_data_fields                         |  649  
       127 | mdl_data_fields_id_seq                  |  650  
       127 | mdl_data_id_seq                         |  648  
       127 | mdl_data_records                        |  651  
       127 | mdl_data_records_id_seq                 |  652  
       127 | mdl_department                          |  981  
       127 | mdl_department_id_seq                   |  982  
       127 | mdl_editor_atto_autosave                |  897  
       127 | mdl_editor_atto_autosave_id_seq         |  898  
       127 | mdl_email                               |  971  
       127 | mdl_email_id_seq                        |  972  
       127 | mdl_email_template                      |  969  
       127 | mdl_email_template_id_seq               |  970  
       127 | mdl_email_templateset                   |  973  
       127 | mdl_email_templateset_id_seq            |  974  
       127 | mdl_email_templateset_templates         |  975  
       127 | mdl_email_templateset_templates_id_seq  |  976  
       127 | mdl_enrol                               |  148  
       127 | mdl_enrol_flatfile                      |  835  
       127 | mdl_enrol_flatfile_id_seq               |  836  
       127 | mdl_enrol_id_seq                        |  149  
       127 | mdl_enrol_lti_lti2_consumer             |  841  
       127 | mdl_enrol_lti_lti2_consumer_id_seq      |  842  
       127 | mdl_enrol_lti_lti2_context              |  845  
       127 | mdl_enrol_lti_lti2_context_id_seq       |  846  
       127 | mdl_enrol_lti_lti2_nonce                |  847  
       127 | mdl_enrol_lti_lti2_nonce_id_seq         |  848  
       127 | mdl_enrol_lti_lti2_resource_link        |  849  
       127 | mdl_enrol_lti_lti2_resource_link_id_seq |  850  
       127 | mdl_enrol_lti_lti2_share_key            |  851  
       127 | mdl_enrol_lti_lti2_share_key_id_seq     |  852  
       127 | mdl_enrol_lti_lti2_tool_proxy           |  843  
       127 | mdl_enrol_lti_lti2_tool_proxy_id_seq    |  844  
       127 | mdl_enrol_lti_lti2_user_result          |  853  
       127 | mdl_enrol_lti_lti2_user_result_id_seq   |  854  
       127 | mdl_enrol_lti_tool_consumer_map         |  855  
       127 | mdl_enrol_lti_tool_consumer_map_id_seq  |  856  
       127 | mdl_enrol_lti_tools                     |  837  
       127 | mdl_enrol_lti_tools_id_seq              |  838  
       127 | mdl_enrol_lti_users                     |  839  
       127 | mdl_enrol_lti_users_id_seq              |  840  
       127 | mdl_enrol_paypal                        |  857  
       127 | mdl_enrol_paypal_id_seq                 |  858  
       127 | mdl_event                               |  166  
       127 | mdl_event_id_seq                        |  167  
       127 | mdl_event_subscriptions                 |  431  
       127 | mdl_event_subscriptions_id_seq          |  432  
       127 | mdl_events_handlers                     |  305  
       127 | mdl_events_handlers_id_seq              |  306  
       127 | mdl_events_queue                        |  303  
       127 | mdl_events_queue_handlers               |  307  
       127 | mdl_events_queue_handlers_id_seq        |  308  
       127 | mdl_events_queue_id_seq                 |  304  
       127 | mdl_external_functions                  |  399  
       127 | mdl_external_functions_id_seq           |  400  
       127 | mdl_external_services                   |  397  
       127 | mdl_external_services_functions         |  401  
       127 | mdl_external_services_functions_id_seq  |  402  
       127 | mdl_external_services_id_seq            |  398  
       127 | mdl_external_services_users             |  403  
       127 | mdl_external_services_users_id_seq      |  404  
       127 | mdl_external_tokens                     |  405  
       127 | mdl_external_tokens_id_seq              |  406  
       127 | mdl_favourite                           |  543  
       127 | mdl_favourite_id_seq                    |  544  
       127 | mdl_feedback                            |  655  
       127 | mdl_feedback_completed                  |  661  
       127 | mdl_feedback_completed_id_seq           |  662  
       127 | mdl_feedback_completedtmp               |  663  
       127 | mdl_feedback_completedtmp_id_seq        |  664  
       127 | mdl_feedback_id_seq                     |  656  
       127 | mdl_feedback_item                       |  659  
       127 | mdl_feedback_item_id_seq                |  660  
       127 | mdl_feedback_sitecourse_map             |  669  
       127 | mdl_feedback_sitecourse_map_id_seq      |  670  
       127 | mdl_feedback_template                   |  657  
       127 | mdl_feedback_template_id_seq            |  658  
       127 | mdl_feedback_value                      |  665  
       127 | mdl_feedback_value_id_seq               |  666  
       127 | mdl_feedback_valuetmp                   |  667  
       127 | mdl_feedback_valuetmp_id_seq            |  668  
       127 | mdl_file_conversion                     |  379  
       127 | mdl_file_conversion_id_seq              |  380  
       127 | mdl_files                               |  375  
       127 | mdl_files_id_seq                        |  376  
       127 | mdl_files_reference                     |  377  
       127 | mdl_files_reference_id_seq              |  378  
       127 | mdl_filter_active                       |  162  
       127 | mdl_filter_active_id_seq                |  163  
       127 | mdl_filter_config                       |  164  
       127 | mdl_filter_config_id_seq                |  165  
       127 | mdl_folder                              |  671  
       127 | mdl_folder_id_seq                       |  672  
       127 | mdl_forum                               |  673  
       127 | mdl_forum_digests                       |  683  
       127 | mdl_forum_digests_id_seq                |  684  
       127 | mdl_forum_discussion_subs               |  689  
       127 | mdl_forum_discussion_subs_id_seq        |  690  
       127 | mdl_forum_discussions                   |  675  
       127 | mdl_forum_discussions_id_seq            |  676  
       127 | mdl_forum_grades                        |  691  
       127 | mdl_forum_grades_id_seq                 |  692  
       127 | mdl_forum_id_seq                        |  674  
       127 | mdl_forum_posts                         |  677  
       127 | mdl_forum_posts_id_seq                  |  678  
       127 | mdl_forum_queue                         |  679  
       127 | mdl_forum_queue_id_seq                  |  680  
       127 | mdl_forum_read                          |  685  
       127 | mdl_forum_read_id_seq                   |  686  
       127 | mdl_forum_subscriptions                 |  681  
       127 | mdl_forum_subscriptions_id_seq          |  682  
       127 | mdl_forum_track_prefs                   |  687  
       127 | mdl_forum_track_prefs_id_seq            |  688  
       127 | mdl_glossary                            |  693  
       127 | mdl_glossary_alias                      |  697  
       127 | mdl_glossary_alias_id_seq               |  698  
       127 | mdl_glossary_categories                 |  699  
       127 | mdl_glossary_categories_id_seq          |  700  
       127 | mdl_glossary_entries                    |  695  
       127 | mdl_glossary_entries_categories         |  701  
       127 | mdl_glossary_entries_categories_id_seq  |  702  
       127 | mdl_glossary_entries_id_seq             |  696  
       127 | mdl_glossary_formats                    |  703  
       127 | mdl_glossary_formats_id_seq             |  704  
       127 | mdl_glossary_id_seq                     |  694  
       127 | mdl_grade_categories                    |  313  
       127 | mdl_grade_categories_history            |  321  
       127 | mdl_grade_categories_history_id_seq     |  322  
       127 | mdl_grade_categories_id_seq             |  314  
       127 | mdl_grade_grades                        |  317  
       127 | mdl_grade_grades_history                |  325  
       127 | mdl_grade_grades_history_id_seq         |  326  
       127 | mdl_grade_grades_id_seq                 |  318  
       127 | mdl_grade_import_newitem                |  327  
       127 | mdl_grade_import_newitem_id_seq         |  328  
       127 | mdl_grade_import_values                 |  329  
       127 | mdl_grade_import_values_id_seq          |  330  
       127 | mdl_grade_items                         |  315  
       127 | mdl_grade_items_history                 |  323  
       127 | mdl_grade_items_history_id_seq          |  324  
       127 | mdl_grade_items_id_seq                  |  316  
       127 | mdl_grade_letters                       |  355  
       127 | mdl_grade_letters_id_seq                |  356  
       127 | mdl_grade_outcomes                      |  309  
       127 | mdl_grade_outcomes_courses              |  311  
       127 | mdl_grade_outcomes_courses_id_seq       |  312  
       127 | mdl_grade_outcomes_history              |  319  
       127 | mdl_grade_outcomes_history_id_seq       |  320  
       127 | mdl_grade_outcomes_id_seq               |  310  
       127 | mdl_grade_settings                      |  359  
       127 | mdl_grade_settings_id_seq               |  360  
       127 | mdl_grading_areas                       |  425  
       127 | mdl_grading_areas_id_seq                |  426  
       127 | mdl_grading_definitions                 |  427  
       127 | mdl_grading_definitions_id_seq          |  428  
       127 | mdl_grading_instances                   |  429  
       127 | mdl_grading_instances_id_seq            |  430  
       127 | mdl_gradingform_guide_comments          |  903  
       127 | mdl_gradingform_guide_comments_id_seq   |  904  
       127 | mdl_gradingform_guide_criteria          |  899  
       127 | mdl_gradingform_guide_criteria_id_seq   |  900  
       127 | mdl_gradingform_guide_fillings          |  901  
       127 | mdl_gradingform_guide_fillings_id_seq   |  902  
       127 | mdl_gradingform_rubric_criteria         |  905  
       127 | mdl_gradingform_rubric_criteria_id_seq  |  906  
       127 | mdl_gradingform_rubric_fillings         |  909  
       127 | mdl_gradingform_rubric_fillings_id_seq  |  910  
       127 | mdl_gradingform_rubric_levels           |  907  
       127 | mdl_gradingform_rubric_levels_id_seq    |  908  
       127 | mdl_groupings                           |  343  
       127 | mdl_groupings_groups                    |  347  
       127 | mdl_groupings_groups_id_seq             |  348  
       127 | mdl_groupings_id_seq                    |  344  
       127 | mdl_groups                              |  341  
       127 | mdl_groups_id_seq                       |  342  
       127 | mdl_groups_members                      |  345  
       127 | mdl_groups_members_id_seq               |  346  
       127 | mdl_h5p                                 |  555  
       127 | mdl_h5p_contents_libraries              |  557  
       127 | mdl_h5p_contents_libraries_id_seq       |  558  
       127 | mdl_h5p_id_seq                          |  556  
       127 | mdl_h5p_libraries                       |  551  
       127 | mdl_h5p_libraries_cachedassets          |  559  
       127 | mdl_h5p_libraries_cachedassets_id_seq   |  560  
       127 | mdl_h5p_libraries_id_seq                |  552  
       127 | mdl_h5p_library_dependencies            |  553  
       127 | mdl_h5p_library_dependencies_id_seq     |  554  
       127 | mdl_hvp                                 | 1210  
       127 | mdl_hvp_auth                            | 1233  
       127 | mdl_hvp_auth_id_seq                     | 1234  
       127 | mdl_hvp_content_user_data               | 1214  
       127 | mdl_hvp_content_user_data_id_seq        | 1215  
       127 | mdl_hvp_contents_libraries              | 1226  
       127 | mdl_hvp_contents_libraries_id_seq       | 1227  
       127 | mdl_hvp_counters                        | 1231  
       127 | mdl_hvp_counters_id_seq                 | 1232  
       127 | mdl_hvp_events                          | 1228  
       127 | mdl_hvp_events_id_seq                   | 1229  
       127 | mdl_hvp_id_seq                          | 1211  
       127 | mdl_hvp_libraries                       | 1216  
       127 | mdl_hvp_libraries_cachedassets          | 1224  
       127 | mdl_hvp_libraries_cachedassets_id_seq   | 1225  
       127 | mdl_hvp_libraries_hub_cache_id_seq      | 1219  
       127 | mdl_hvp_libraries_id_seq                | 1217  
       127 | mdl_hvp_libraries_languages             | 1222  
       127 | mdl_hvp_libraries_languages_id_seq      | 1223  
       127 | mdl_hvp_libraries_libraries             | 1220  
       127 | mdl_hvp_libraries_libraries_id_seq      | 1221  
       127 | mdl_hvp_tmpfiles                        | 1230  
       127 | mdl_hvp_xapi_results                    | 1212  
       127 | mdl_hvp_xapi_results_id_seq             | 1213  
       127 | mdl_imscp                               |  705  
       127 | mdl_imscp_id_seq                        |  706  
       127 | mdl_invoice                             |  869  
       127 | mdl_invoice_id_seq                      |  870  
       127 | mdl_invoiceitem                         |  871  
       127 | mdl_invoiceitem_id_seq                  |  872  
       127 | mdl_iomad_courses                       |  991  
       127 | mdl_iomad_courses_id_seq                |  992  
       127 | mdl_iomad_frameworks                    | 1011  
       127 | mdl_iomad_frameworks_id_seq             | 1012  
       127 | mdl_iomad_learningpath                  | 1027  
       127 | mdl_iomad_learningpath_id_seq           | 1028  
       127 | mdl_iomad_learningpathcourse            | 1029  
       127 | mdl_iomad_learningpathcourse_id_seq     | 1030  
       127 | mdl_iomad_learningpathgroup             | 1031  
       127 | mdl_iomad_learningpathgroup_id_seq      | 1032  
       127 | mdl_iomad_learningpathuser              | 1033  
       127 | mdl_iomad_learningpathuser_id_seq       | 1034  
       127 | mdl_iomad_templates                     | 1009  
       127 | mdl_iomad_templates_id_seq              | 1010  
       127 | mdl_iomadcertificate                    |  707  
       127 | mdl_iomadcertificate_id_seq             |  708  
       127 | mdl_iomadcertificate_issues             |  709  
       127 | mdl_iomadcertificate_issues_id_seq      |  710  
       127 | mdl_label                               |  711  
       127 | mdl_label_id_seq                        |  712  
       127 | mdl_lesson                              |  713  
       127 | mdl_lesson_answers                      |  717  
       127 | mdl_lesson_answers_id_seq               |  718  
       127 | mdl_lesson_attempts                     |  719  
       127 | mdl_lesson_attempts_id_seq              |  720  
       127 | mdl_lesson_branch                       |  725  
       127 | mdl_lesson_branch_id_seq                |  726  
       127 | mdl_lesson_grades                       |  721  
       127 | mdl_lesson_grades_id_seq                |  722  
       127 | mdl_lesson_id_seq                       |  714  
       127 | mdl_lesson_overrides                    |  727  
       127 | mdl_lesson_overrides_id_seq             |  728  
       127 | mdl_lesson_pages                        |  715  
       127 | mdl_lesson_pages_id_seq                 |  716  
       127 | mdl_lesson_timer                        |  723  
       127 | mdl_lesson_timer_id_seq                 |  724  
       127 | mdl_license                             |  413  
       127 | mdl_license_id_seq                      |  414  
       127 | mdl_local_csp                           | 1559  
       127 | mdl_local_csp_id_seq                    | 1560  
       127 | mdl_local_iomad_track                   | 1037  
       127 | mdl_local_iomad_track_certs             | 1039  
       127 | mdl_local_iomad_track_certs_id_seq      | 1040  
       127 | mdl_local_iomad_track_id_seq            | 1038  
       127 | mdl_local_report_user_lic_allocs        | 1041  
       127 | mdl_local_report_user_lic_allocs_id_seq | 1042  
       127 | mdl_local_report_user_logins            | 1043  
       127 | mdl_local_report_user_logins_id_seq     | 1044  
       127 | mdl_lock_db                             |  463  
       127 | mdl_lock_db_id_seq                      |  464  
       127 | mdl_log                                 |  170  
       127 | mdl_log_display                         |  174  
       127 | mdl_log_display_id_seq                  |  175  
       127 | mdl_log_id_seq                          |  171  
       127 | mdl_log_queries                         |  172  
       127 | mdl_log_queries_id_seq                  |  173  
       127 | mdl_logstore_standard_log               | 1087  
       127 | mdl_logstore_standard_log_id_seq        | 1088  
       127 | mdl_lti                                 |  729  
       127 | mdl_lti_access_tokens                   |  741  
       127 | mdl_lti_access_tokens_id_seq            |  742  
       127 | mdl_lti_id_seq                          |  730  
       127 | mdl_lti_submission                      |  739  
       127 | mdl_lti_submission_id_seq               |  740  
       127 | mdl_lti_tool_proxies                    |  731  
       127 | mdl_lti_tool_proxies_id_seq             |  732  
       127 | mdl_lti_tool_settings                   |  737  
       127 | mdl_lti_tool_settings_id_seq            |  738  
       127 | mdl_lti_types                           |  733  
       127 | mdl_lti_types_config                    |  735  
       127 | mdl_lti_types_config_id_seq             |  736  
       127 | mdl_lti_types_id_seq                    |  734  
       127 | mdl_ltiservice_gradebookservices        | 1063  
       127 | mdl_ltiservice_gradebookservices_id_seq | 1064  
       127 | mdl_message                             |  176  
       127 | mdl_message_airnotifier_devices         |  859  
       127 | mdl_message_airnotifier_devices_id_seq  |  860  
       127 | mdl_message_contact_requests            |  194  
       127 | mdl_message_contact_requests_id_seq     |  195  
       127 | mdl_message_contacts                    |  192  
       127 | mdl_message_contacts_id_seq             |  193  
       127 | mdl_message_conversation_actions        |  186  
       127 | mdl_message_conversation_actions_id_seq |  187  
       127 | mdl_message_conversation_members        |  184  
       127 | mdl_message_conversation_members_id_seq |  185  
       127 | mdl_message_conversations               |  182  
       127 | mdl_message_conversations_id_seq        |  183  
       127 | mdl_message_email_messages              |  861  
       127 | mdl_message_email_messages_id_seq       |  862  
       127 | mdl_message_id_seq                      |  177  
       127 | mdl_message_popup                       |  863  
       127 | mdl_message_popup_id_seq                |  864  
       127 | mdl_message_popup_notifications         |  865  
       127 | mdl_message_popup_notifications_id_seq  |  866  
       127 | mdl_message_processors                  |  373  
       127 | mdl_message_processors_id_seq           |  374  
       127 | mdl_message_providers                   |  371  
       127 | mdl_message_providers_id_seq            |  372  
       127 | mdl_message_read                        |  178  
       127 | mdl_message_read_id_seq                 |  179  
       127 | mdl_message_user_actions                |  188  
       127 | mdl_message_user_actions_id_seq         |  189  
       127 | mdl_message_users_blocked               |  196  
       127 | mdl_message_users_blocked_id_seq        |  197  
       127 | mdl_messageinbound_datakeys             |  473  
       127 | mdl_messageinbound_datakeys_id_seq      |  474  
       127 | mdl_messageinbound_handlers             |  471  
       127 | mdl_messageinbound_handlers_id_seq      |  472  
       127 | mdl_messageinbound_messagelist          |  475  
       127 | mdl_messageinbound_messagelist_id_seq   |  476  
       127 | mdl_messages                            |  180  
       127 | mdl_messages_id_seq                     |  181  
       127 | mdl_microlearning_nugget                |  885  
       127 | mdl_microlearning_nugget_id_seq         |  886  
       127 | mdl_microlearning_nugget_sched          |  887  
       127 | mdl_microlearning_nugget_sched_id_seq   |  888  
       127 | mdl_microlearning_thread                |  883  
       127 | mdl_microlearning_thread_id_seq         |  884  
       127 | mdl_microlearning_thread_user           |  889  
       127 | mdl_microlearning_thread_user_id_seq    |  890  
       127 | mdl_mnet_application                    |  281  
       127 | mdl_mnet_application_id_seq             |  282  
       127 | mdl_mnet_host                           |  283  
       127 | mdl_mnet_host2service                   |  285  
       127 | mdl_mnet_host2service_id_seq            |  286  
       127 | mdl_mnet_host_id_seq                    |  284  
       127 | mdl_mnet_log                            |  287  
       127 | mdl_mnet_log_id_seq                     |  288  
       127 | mdl_mnet_remote_rpc                     |  291  
       127 | mdl_mnet_remote_rpc_id_seq              |  292  
       127 | mdl_mnet_remote_service2rpc             |  297  
       127 | mdl_mnet_remote_service2rpc_id_seq      |  298  
       127 | mdl_mnet_rpc                            |  289  
       127 | mdl_mnet_rpc_id_seq                     |  290  
       127 | mdl_mnet_service                        |  293  
       127 | mdl_mnet_service2rpc                    |  295  
       127 | mdl_mnet_service2rpc_id_seq             |  296  
       127 | mdl_mnet_service_id_seq                 |  294  
       127 | mdl_mnet_session                        |  299  
       127 | mdl_mnet_session_id_seq                 |  300  
       127 | mdl_mnet_sso_access_control             |  301  
       127 | mdl_mnet_sso_access_control_id_seq      |  302  
       127 | mdl_mnetservice_enrol_courses           |  911  
       127 | mdl_mnetservice_enrol_courses_id_seq    |  912  
       127 | mdl_mnetservice_enrol_enrolments        |  913  
       127 | mdl_mnetservice_enrol_enrolments_id_seq |  914  
       127 | mdl_modules                             |  198  
       127 | mdl_modules_id_seq                      |  199  
       127 | mdl_my_pages                            |  200  
       127 | mdl_my_pages_id_seq                     |  201  
       127 | mdl_notifications                       |  190  
       127 | mdl_notifications_id_seq                |  191  
       127 | mdl_oauth2_access_token                 |  537  
       127 | mdl_oauth2_access_token_id_seq          |  538  
       127 | mdl_oauth2_endpoint                     |  511  
       127 | mdl_oauth2_endpoint_id_seq              |  512  
       127 | mdl_oauth2_issuer                       |  513  
       127 | mdl_oauth2_issuer_id_seq                |  514  
       127 | mdl_oauth2_system_account               |  515  
       127 | mdl_oauth2_system_account_id_seq        |  516  
       127 | mdl_oauth2_user_field_mapping           |  517  
       127 | mdl_oauth2_user_field_mapping_id_seq    |  518  
       127 | mdl_page                                |  743  
       127 | mdl_page_id_seq                         |  744  
       127 | mdl_portfolio_instance                  |  361  
       127 | mdl_portfolio_instance_config           |  363  
       127 | mdl_portfolio_instance_config_id_seq    |  364  
       127 | mdl_portfolio_instance_id_seq           |  362  
       127 | mdl_portfolio_instance_user             |  365  
       127 | mdl_portfolio_instance_user_id_seq      |  366  
       127 | mdl_portfolio_log                       |  367  
       127 | mdl_portfolio_log_id_seq                |  368  
       127 | mdl_portfolio_mahara_queue              |  917  
       127 | mdl_portfolio_mahara_queue_id_seq       |  918  
       127 | mdl_portfolio_tempdata                  |  369  
       127 | mdl_portfolio_tempdata_id_seq           |  370  
       127 | mdl_post                                |  228  
       127 | mdl_post_id_seq                         |  229  
       127 | mdl_profiling                           |  421  
       127 | mdl_profiling_id_seq                    |  422  
       127 | mdl_qtype_ddimageortext                 |  571  
       127 | mdl_qtype_ddimageortext_drags           |  575  
       127 | mdl_qtype_ddimageortext_drags_id_seq    |  576  
       127 | mdl_qtype_ddimageortext_drops           |  573  
       127 | mdl_qtype_ddimageortext_drops_id_seq    |  574  
       127 | mdl_qtype_ddimageortext_id_seq          |  572  
       127 | mdl_qtype_ddmarker                      |  577  
       127 | mdl_qtype_ddmarker_drags                |  581  
       127 | mdl_qtype_ddmarker_drags_id_seq         |  582  
       127 | mdl_qtype_ddmarker_drops                |  579  
       127 | mdl_qtype_ddmarker_drops_id_seq         |  580  
       127 | mdl_qtype_ddmarker_id_seq               |  578  
       127 | mdl_qtype_essay_options                 |  585  
       127 | mdl_qtype_essay_options_id_seq          |  586  
       127 | mdl_qtype_match_options                 |  589  
       127 | mdl_qtype_match_options_id_seq          |  590  
       127 | mdl_qtype_match_subquestions            |  591  
       127 | mdl_qtype_match_subquestions_id_seq     |  592  
       127 | mdl_qtype_multichoice_options           |  595  
       127 | mdl_qtype_multichoice_options_id_seq    |  596  
       127 | mdl_qtype_randomsamatch_options         |  603  
       127 | mdl_qtype_randomsamatch_options_id_seq  |  604  
       127 | mdl_qtype_shortanswer_options           |  605  
       127 | mdl_qtype_shortanswer_options_id_seq    |  606  
       127 | mdl_question                            |  261  
       127 | mdl_question_answers                    |  263  
       127 | mdl_question_answers_id_seq             |  264  
       127 | mdl_question_attempt_step_data          |  273  
       127 | mdl_question_attempt_step_data_id_seq   |  274  
       127 | mdl_question_attempt_steps              |  271  
       127 | mdl_question_attempt_steps_id_seq       |  272  
       127 | mdl_question_attempts                   |  269  
       127 | mdl_question_attempts_id_seq            |  270  
       127 | mdl_question_calculated                 |  561  
       127 | mdl_question_calculated_id_seq          |  562  
       127 | mdl_question_calculated_options         |  563  
       127 | mdl_question_calculated_options_id_seq  |  564  
       127 | mdl_question_categories                 |  259  
       127 | mdl_question_categories_id_seq          |  260  
       127 | mdl_question_dataset_definitions        |  565  
       127 | mdl_question_dataset_definitions_id_seq |  566  
       127 | mdl_question_dataset_items              |  567  
       127 | mdl_question_dataset_items_id_seq       |  568  
       127 | mdl_question_datasets                   |  569  
       127 | mdl_question_datasets_id_seq            |  570  
       127 | mdl_question_ddwtos                     |  583  
       127 | mdl_question_ddwtos_id_seq              |  584  
       127 | mdl_question_gapselect                  |  587  
       127 | mdl_question_gapselect_id_seq           |  588  
       127 | mdl_question_hints                      |  265  
       127 | mdl_question_hints_id_seq               |  266  
       127 | mdl_question_id_seq                     |  262  
       127 | mdl_question_multianswer                |  593  
       127 | mdl_question_multianswer_id_seq         |  594  
       127 | mdl_question_numerical                  |  597  
       127 | mdl_question_numerical_id_seq           |  598  
       127 | mdl_question_numerical_options          |  599  
       127 | mdl_question_numerical_options_id_seq   |  600  
       127 | mdl_question_numerical_units            |  601  
       127 | mdl_question_numerical_units_id_seq     |  602  
       127 | mdl_question_response_analysis          |  277  
       127 | mdl_question_response_analysis_id_seq   |  278  
       127 | mdl_question_response_count             |  279  
       127 | mdl_question_response_count_id_seq      |  280  
       127 | mdl_question_statistics                 |  275  
       127 | mdl_question_statistics_id_seq          |  276  
       127 | mdl_question_truefalse                  |  607  
       127 | mdl_question_truefalse_id_seq           |  608  
       127 | mdl_question_usages                     |  267  
       127 | mdl_question_usages_id_seq              |  268  
       127 | mdl_quiz                                |  745  
       127 | mdl_quiz_attempts                       |  755  
       127 | mdl_quiz_attempts_id_seq                |  756  
       127 | mdl_quiz_feedback                       |  751  
       127 | mdl_quiz_feedback_id_seq                |  752  
       127 | mdl_quiz_grades                         |  757  
       127 | mdl_quiz_grades_id_seq                  |  758  
       127 | mdl_quiz_id_seq                         |  746  
       127 | mdl_quiz_overrides                      |  753  
       127 | mdl_quiz_overrides_id_seq               |  754  
       127 | mdl_quiz_overview_regrades              | 1065  
       127 | mdl_quiz_overview_regrades_id_seq       | 1066  
       127 | mdl_quiz_reports                        |  759  
       127 | mdl_quiz_reports_id_seq                 |  760  
       127 | mdl_quiz_sections                       |  749  
       127 | mdl_quiz_sections_id_seq                |  750  
       127 | mdl_quiz_slot_tags                      |  761  
       127 | mdl_quiz_slot_tags_id_seq               |  762  
       127 | mdl_quiz_slots                          |  747  
       127 | mdl_quiz_slots_id_seq                   |  748  
       127 | mdl_quiz_statistics                     | 1067  
       127 | mdl_quiz_statistics_id_seq              | 1068  
       127 | mdl_rating                              |  411  
       127 | mdl_rating_id_seq                       |  412  
       127 | mdl_registration_hubs                   |  415  
       127 | mdl_registration_hubs_id_seq            |  416  
       127 | mdl_repository                          |  381  
       127 | mdl_repository_id_seq                   |  382  
       127 | mdl_repository_instance_config          |  385  
       127 | mdl_repository_instance_config_id_seq   |  386  
       127 | mdl_repository_instances                |  383  
       127 | mdl_repository_instances_id_seq         |  384  
       127 | mdl_repository_onedrive_access          |  915  
       127 | mdl_repository_onedrive_access_id_seq   |  916  
       127 | mdl_resource                            |  763  
       127 | mdl_resource_id_seq                     |  764  
       127 | mdl_resource_old                        |  765  
       127 | mdl_resource_old_id_seq                 |  766  
       127 | mdl_role                                |  230  
       127 | mdl_role_allow_assign                   |  237  
       127 | mdl_role_allow_assign_id_seq            |  238  
       127 | mdl_role_allow_override                 |  239  
       127 | mdl_role_allow_override_id_seq          |  240  
       127 | mdl_role_allow_switch                   |  241  
       127 | mdl_role_allow_switch_id_seq            |  242  
       127 | mdl_role_allow_view                     |  243  
       127 | mdl_role_allow_view_id_seq              |  244  
       127 | mdl_role_assignments                    |  245  
       127 | mdl_role_assignments_id_seq             |  246  
       127 | mdl_role_capabilities                   |  247  
       127 | mdl_role_capabilities_id_seq            |  248  
       127 | mdl_role_context_levels                 |  251  
       127 | mdl_role_context_levels_id_seq          |  252  
       127 | mdl_role_id_seq                         |  231  
       127 | mdl_role_names                          |  249  
       127 | mdl_role_names_id_seq                   |  250  
       127 | mdl_scale                               |  212  
       127 | mdl_scale_history                       |  214  
       127 | mdl_scale_history_id_seq                |  215  
       127 | mdl_scale_id_seq                        |  213  
       127 | mdl_scorm                               |  767  
       127 | mdl_scorm_aicc_session                  |  787  
       127 | mdl_scorm_aicc_session_id_seq           |  788  
       127 | mdl_scorm_id_seq                        |  768  
       127 | mdl_scorm_scoes                         |  769  
       127 | mdl_scorm_scoes_data                    |  771  
       127 | mdl_scorm_scoes_data_id_seq             |  772  
       127 | mdl_scorm_scoes_id_seq                  |  770  
       127 | mdl_scorm_scoes_track                   |  773  
       127 | mdl_scorm_scoes_track_id_seq            |  774  
       127 | mdl_scorm_seq_mapinfo                   |  777  
       127 | mdl_scorm_seq_mapinfo_id_seq            |  778  
       127 | mdl_scorm_seq_objective                 |  775  
       127 | mdl_scorm_seq_objective_id_seq          |  776  
       127 | mdl_scorm_seq_rolluprule                |  783  
       127 | mdl_scorm_seq_rolluprule_id_seq         |  784  
       127 | mdl_scorm_seq_rolluprulecond            |  785  
       127 | mdl_scorm_seq_rolluprulecond_id_seq     |  786  
       127 | mdl_scorm_seq_rulecond                  |  781  
       127 | mdl_scorm_seq_rulecond_id_seq           |  782  
       127 | mdl_scorm_seq_ruleconds                 |  779  
       127 | mdl_scorm_seq_ruleconds_id_seq          |  780  
       127 | mdl_search_index_requests               |  541  
       127 | mdl_search_index_requests_id_seq        |  542  
       127 | mdl_search_simpledb_index               |  919  
       127 | mdl_search_simpledb_index_id_seq        |  920  
       127 | mdl_sessions                            | 1335  
       127 | mdl_sessions_id_seq                     |  203  
       127 | mdl_shoptag                             |  877  
       127 | mdl_shoptag_id_seq                      |  878  
       127 | mdl_stats_daily                         |  216  
       127 | mdl_stats_daily_id_seq                  |  217  
       127 | mdl_stats_monthly                       |  220  
       127 | mdl_stats_monthly_id_seq                |  221  
       127 | mdl_stats_user_daily                    |  222  
       127 | mdl_stats_user_daily_id_seq             |  223  
       127 | mdl_stats_user_monthly                  |  226  
       127 | mdl_stats_user_monthly_id_seq           |  227  
       127 | mdl_stats_user_weekly                   |  224  
       127 | mdl_stats_user_weekly_id_seq            |  225  
       127 | mdl_stats_weekly                        |  218  
       127 | mdl_stats_weekly_id_seq                 |  219  
       127 | mdl_survey                              |  789  
       127 | mdl_survey_analysis                     |  795  
       127 | mdl_survey_analysis_id_seq              |  796  
       127 | mdl_survey_answers                      |  793  
       127 | mdl_survey_answers_id_seq               |  794  
       127 | mdl_survey_id_seq                       |  790  
       127 | mdl_survey_questions                    |  791  
       127 | mdl_survey_questions_id_seq             |  792  
       127 | mdl_tag                                 |  335  
       127 | mdl_tag_area                            |  333  
       127 | mdl_tag_area_id_seq                     |  334  
       127 | mdl_tag_coll                            |  331  
       127 | mdl_tag_coll_id_seq                     |  332  
       127 | mdl_tag_correlation_id_seq              |  338  
       127 | mdl_tag_id_seq                          |  336  
       127 | mdl_tag_instance                        |  339  
       127 | mdl_tag_instance_id_seq                 |  340  
       127 | mdl_task_adhoc                          |  467  
       127 | mdl_task_adhoc_id_seq                   |  468  
       127 | mdl_task_log                            |  469  
       127 | mdl_task_log_id_seq                     |  470  
       127 | mdl_task_scheduled                      |  465  
       127 | mdl_task_scheduled_id_seq               |  466  
       127 | mdl_tool_cohortroles                    |  921  
       127 | mdl_tool_cohortroles_id_seq             |  922  
       127 | mdl_tool_customlang                     |  923  
       127 | mdl_tool_customlang_components          |  925  
       127 | mdl_tool_customlang_components_id_seq   |  926  
       127 | mdl_tool_customlang_id_seq              |  924  
       127 | mdl_tool_dataprivacy_category           |  931  
       127 | mdl_tool_dataprivacy_category_id_seq    |  932  
       127 | mdl_tool_dataprivacy_ctxexpired         |  937  
       127 | mdl_tool_dataprivacy_ctxexpired_id_seq  |  938  
       127 | mdl_tool_dataprivacy_ctxinstance        |  933  
       127 | mdl_tool_dataprivacy_ctxinstance_id_seq |  934  
       127 | mdl_tool_dataprivacy_ctxlevel           |  935  
       127 | mdl_tool_dataprivacy_ctxlevel_id_seq    |  936  
       127 | mdl_tool_dataprivacy_purpose            |  929  
       127 | mdl_tool_dataprivacy_purpose_id_seq     |  930  
       127 | mdl_tool_dataprivacy_purposerole        |  939  
       127 | mdl_tool_dataprivacy_purposerole_id_seq |  940  
       127 | mdl_tool_dataprivacy_request            |  927  
       127 | mdl_tool_dataprivacy_request_id_seq     |  928  
       127 | mdl_tool_iomadmerge                     |  941  
       127 | mdl_tool_iomadmerge_id_seq              |  942  
       127 | mdl_tool_monitor_events                 |  949  
       127 | mdl_tool_monitor_events_id_seq          |  950  
       127 | mdl_tool_monitor_history                |  947  
       127 | mdl_tool_monitor_history_id_seq         |  948  
       127 | mdl_tool_monitor_rules                  |  943  
       127 | mdl_tool_monitor_rules_id_seq           |  944  
       127 | mdl_tool_monitor_subscriptions          |  945  
       127 | mdl_tool_monitor_subscriptions_id_seq   |  946  
       127 | mdl_tool_objectfs_objects               |  951  
       127 | mdl_tool_objectfs_objects_id_seq        |  952  
       127 | mdl_tool_objectfs_reports               |  953  
       127 | mdl_tool_objectfs_reports_id_seq        |  954  
       127 | mdl_tool_policy                         |  955  
       127 | mdl_tool_policy_acceptances             |  959  
       127 | mdl_tool_policy_acceptances_id_seq      |  960  
       127 | mdl_tool_policy_id_seq                  |  956  
       127 | mdl_tool_policy_versions                |  957  
       127 | mdl_tool_policy_versions_id_seq         |  958  
       127 | mdl_tool_recyclebin_category            |  963  
       127 | mdl_tool_recyclebin_category_id_seq     |  964  
       127 | mdl_tool_recyclebin_course              |  961  
       127 | mdl_tool_recyclebin_course_id_seq       |  962  
       127 | mdl_tool_usertours_steps                |  967  
       127 | mdl_tool_usertours_steps_id_seq         |  968  
       127 | mdl_tool_usertours_tours                |  965  
       127 | mdl_tool_usertours_tours_id_seq         |  966  
       127 | mdl_tool_webanalytics                   | 1664  
       127 | mdl_tool_webanalytics_id_seq            | 1665  
       127 | mdl_trainingevent                       |  797  
       127 | mdl_trainingevent_id_seq                |  798  
       127 | mdl_trainingevent_users                 |  799  
       127 | mdl_trainingevent_users_id_seq          |  800  
       127 | mdl_upgrade_log                         |  134  
       127 | mdl_upgrade_log_id_seq                  |  135  
       127 | mdl_url                                 |  801  
       127 | mdl_url_id_seq                          |  802  
       127 | mdl_user                                |  204  
       127 | mdl_user_devices                        |  459  
       127 | mdl_user_devices_id_seq                 |  460  
       127 | mdl_user_enrolments                     |  150  
       127 | mdl_user_enrolments_id_seq              |  151  
       127 | mdl_user_id_seq                         |  205  
       127 | mdl_user_info_category                  |  255  
       127 | mdl_user_info_category_id_seq           |  256  
       127 | mdl_user_info_data                      |  257  
       127 | mdl_user_info_data_id_seq               |  258  
       127 | mdl_user_info_field                     |  253  
       127 | mdl_user_info_field_id_seq              |  254  
       127 | mdl_user_lastaccess                     |  208  
       127 | mdl_user_lastaccess_id_seq              |  209  
       127 | mdl_user_password_history               |  210  
       127 | mdl_user_password_history_id_seq        |  211  
       127 | mdl_user_password_resets                |  461  
       127 | mdl_user_password_resets_id_seq         |  462  
       127 | mdl_user_preferences                    |  206  
       127 | mdl_user_preferences_id_seq             |  207  
       127 | mdl_user_private_key                    |  353  
       127 | mdl_user_private_key_id_seq             |  354  
       127 | mdl_wiki                                |  803  
       127 | mdl_wiki_id_seq                         |  804  
       127 | mdl_wiki_links                          |  813  
       127 | mdl_wiki_links_id_seq                   |  814  
       127 | mdl_wiki_locks                          |  815  
       127 | mdl_wiki_locks_id_seq                   |  816  
       127 | mdl_wiki_pages                          |  807  
       127 | mdl_wiki_pages_id_seq                   |  808  
       127 | mdl_wiki_subwikis                       |  805  
       127 | mdl_wiki_subwikis_id_seq                |  806  
       127 | mdl_wiki_synonyms                       |  811  
       127 | mdl_wiki_synonyms_id_seq                |  812  
       127 | mdl_wiki_versions                       |  809  
       127 | mdl_wiki_versions_id_seq                |  810  
       127 | mdl_workshop                            |  817  
       127 | mdl_workshop_aggregations               |  825  
       127 | mdl_workshop_aggregations_id_seq        |  826  
       127 | mdl_workshop_assessments                |  821  
       127 | mdl_workshop_assessments_id_seq         |  822  
       127 | mdl_workshop_grades                     |  823  
       127 | mdl_workshop_grades_id_seq              |  824  
       127 | mdl_workshop_id_seq                     |  818  
       127 | mdl_workshop_submissions                |  819  
       127 | mdl_workshop_submissions_id_seq         |  820  
       127 | mdl_workshopallocation_scheduled        | 1083  
       127 | mdl_workshopallocation_scheduled_id_seq | 1084  
       127 | mdl_workshopeval_best_settings          | 1085  
       127 | mdl_workshopeval_best_settings_id_seq   | 1086  
       127 | mdl_workshopform_accumulative           | 1069  
       127 | mdl_workshopform_accumulative_id_seq    | 1070  
       127 | mdl_workshopform_comments               | 1071  
       127 | mdl_workshopform_comments_id_seq        | 1072  
       127 | mdl_workshopform_numerrors              | 1073  
       127 | mdl_workshopform_numerrors_id_seq       | 1074  
       127 | mdl_workshopform_numerrors_map          | 1075  
       127 | mdl_workshopform_numerrors_map_id_seq   | 1076  
       127 | mdl_workshopform_rubric                 | 1077  
       127 | mdl_workshopform_rubric_config          | 1081  
       127 | mdl_workshopform_rubric_config_id_seq   | 1082  
       127 | mdl_workshopform_rubric_id_seq          | 1078  
       127 | mdl_workshopform_rubric_levels          | 1079  
       127 | mdl_workshopform_rubric_levels_id_seq   | 1080  
(1090 rows)

Time: 11.893223ms
donbowman commented 4 years ago

as to the alter temp or rename. i don't think so.

I'm reluctant to provide a dump since it has sensitive and authentication information in it.

arulajmani commented 4 years ago

I think I have an idea what is going on here, so we might not need a dump after all :) Let me spend some time validating my hypothesis and I'll update this issue. Thanks for the bug report.

arulajmani commented 4 years ago

Thanks for the bug report, this problem should be fixed by a patch in our next 20.1 point release. Please note that temporary tables is an experimental feature, so there may be unexpected performance costs if a large number of temp tables are created. Feel free to file any bugs you encounter while using this feature out as they help us improve the feature's stability.