We has something happen twice now. The first time I chalked up to me being crazy, but this one seems real. We have a regular folder with about 4 lists. The data are not especially active, although this shouldnt matter. One time a couple weeks ago, and more recently this morning, the lists and their DB tables are just gone. When I go through the UI, that container also doesnt report having any lists (as opposed to showing the list, but not finding the physical table).

The only reason I even noticed this is because I have a custom piece of java code that creates an admin summary for me each day, SiteSummaryNotication.getListSummary(). This code calls DbSchema.get("list"), and then iterates each table to get the row count. The odd thing is that getTableNames() still contains the names of these deleted tables (caching?). When it hits c13d367_grants (a deleted table), it blows up when it tries to run SQL because that physical table is no longer there. If this didnt happen I probably would never have known they were gone. Therefore whatever happened occurred between 5AM yesterday and 5AM today.

The odd thing is that this happened to the same container both times. The users with access to this container are not all that saavy, but I am going to talk to them. This part makes no sense to me.

My question is: what steps can I do to troubleshoot? What audit entries and/or system logs will help figure out who/why those lists were deleted? I am looking through the audit tables, but do not see any mention of list deletes, or any real activity around them.

Second, are there other DB queries I can run to see whether pieces of the lists exist somewhere in the DB (ontology manager, for example)? Because the delete of the lists seems so clean and complete, this suggests it happened via LabKey, rather than something dropping the physical table only.

The server is onprc14.2 / sqlserver / RHEL. Thanks for any help.