Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

MySQL "Table doesn't exist" Errors On Startup with db_debug_log set to true

Description

Starting up a totally new and empty 2.5.1 site with `AppConfig[:db_debug_log] = true` logs a bunch of errors. Maybe left over from the old days when these things were tables? I don't think they're causing actual trouble.

E, [2018-11-21T12:08:51.372620 #26360] ERROR – : Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Table 'archivesspace.agent_relationship_associative' doesn't exist: DESCRIBE `agent_relationship_associative`
E, [2018-11-21T12:08:51.376530 #26360] ERROR – : Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Table 'archivesspace.agent_relationship_associative' doesn't exist: SELECT * FROM `agent_relationship_associative` LIMIT 1
E, [2018-11-21T12:08:51.380045 #26360] ERROR – : Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Table 'archivesspace.agent_relationship_associative' doesn't exist: SELECT * FROM `agent_relationship_associative` LIMIT 1
E, [2018-11-21T12:08:51.386238 #26360] ERROR – : Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Table 'archivesspace.agent_relationship_earlierlater' doesn't exist: DESCRIBE `agent_relationship_earlierlater`
E, [2018-11-21T12:08:51.388654 #26360] ERROR – : Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Table 'archivesspace.agent_relationship_earlierlater' doesn't exist: SELECT * FROM `agent_relationship_earlierlater` LIMIT 1
E, [2018-11-21T12:08:51.391111 #26360] ERROR – : Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Table 'archivesspace.agent_relationship_earlierlater' doesn't exist: SELECT * FROM `agent_relationship_earlierlater` LIMIT 1
E, [2018-11-21T12:08:51.398528 #26360] ERROR – : Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Table 'archivesspace.agent_relationship_parentchild' doesn't exist: DESCRIBE `agent_relationship_parentchild`
E, [2018-11-21T12:08:51.402202 #26360] ERROR – : Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Table 'archivesspace.agent_relationship_parentchild' doesn't exist: SELECT * FROM `agent_relationship_parentchild` LIMIT 1
E, [2018-11-21T12:08:51.406236 #26360] ERROR – : Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Table 'archivesspace.agent_relationship_parentchild' doesn't exist: SELECT * FROM `agent_relationship_parentchild` LIMIT 1
E, [2018-11-21T12:08:51.412069 #26360] ERROR – : Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Table 'archivesspace.agent_relationship_subordinatesuperior' doesn't exist: DESCRIBE `agent_relationship_subordinatesuperior`
E, [2018-11-21T12:08:51.415682 #26360] ERROR – : Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Table 'archivesspace.agent_relationship_subordinatesuperior' doesn't exist: SELECT * FROM `agent_relationship_subordinatesuperior` LIMIT 1
E, [2018-11-21T12:08:51.419157 #26360] ERROR – : Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Table 'archivesspace.agent_relationship_subordinatesuperior' doesn't exist: SELECT * FROM `agent_relationship_subordinatesuperior` LIMIT 1
E, [2018-11-21T12:08:51.507814 #26360] ERROR – : Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Table 'archivesspace.container_location' doesn't exist: DESCRIBE `container_location`
E, [2018-11-21T12:08:51.510572 #26360] ERROR – : Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Table 'archivesspace.container_location' doesn't exist: SELECT * FROM `container_location` LIMIT 1
E, [2018-11-21T12:08:51.517585 #26360] ERROR – : Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Table 'archivesspace.container_location' doesn't exist: SELECT * FROM `container_location` LIMIT 1
E, [2018-11-21T12:08:51.719182 #26360] ERROR – : Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Table 'archivesspace.note_bibliography' doesn't exist: DESCRIBE `note_bibliography`
E, [2018-11-21T12:08:51.723187 #26360] ERROR – : Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Table 'archivesspace.note_bibliography' doesn't exist: SELECT * FROM `note_bibliography` LIMIT 1
E, [2018-11-21T12:08:51.725849 #26360] ERROR – : Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Table 'archivesspace.note_bibliography' doesn't exist: SELECT * FROM `note_bibliography` LIMIT 1
E, [2018-11-21T12:08:51.730178 #26360] ERROR – : Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Table 'archivesspace.note_digital_object' doesn't exist: DESCRIBE `note_digital_object`
E, [2018-11-21T12:08:51.732469 #26360] ERROR – : Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Table 'archivesspace.note_digital_object' doesn't exist: SELECT * FROM `note_digital_object` LIMIT 1
E, [2018-11-21T12:08:51.734890 #26360] ERROR – : Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Table 'archivesspace.note_digital_object' doesn't exist: SELECT * FROM `note_digital_object` LIMIT 1
E, [2018-11-21T12:08:51.739115 #26360] ERROR – : Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Table 'archivesspace.note_index' doesn't exist: DESCRIBE `note_index`
E, [2018-11-21T12:08:51.742166 #26360] ERROR – : Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Table 'archivesspace.note_index' doesn't exist: SELECT * FROM `note_index` LIMIT 1
E, [2018-11-21T12:08:51.745319 #26360] ERROR – : Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Table 'archivesspace.note_index' doesn't exist: SELECT * FROM `note_index` LIMIT 1
E, [2018-11-21T12:08:51.753642 #26360] ERROR – : Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Table 'archivesspace.note_index_item' doesn't exist: DESCRIBE `note_index_item`
E, [2018-11-21T12:08:51.757368 #26360] ERROR – : Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Table 'archivesspace.note_index_item' doesn't exist: SELECT * FROM `note_index_item` LIMIT 1
E, [2018-11-21T12:08:51.761608 #26360] ERROR – : Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Table 'archivesspace.note_index_item' doesn't exist: SELECT * FROM `note_index_item` LIMIT 1
E, [2018-11-21T12:08:51.771793 #26360] ERROR – : Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Table 'archivesspace.note_multipart' doesn't exist: DESCRIBE `note_multipart`
E, [2018-11-21T12:08:51.774169 #26360] ERROR – : Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Table 'archivesspace.note_multipart' doesn't exist: SELECT * FROM `note_multipart` LIMIT 1
E, [2018-11-21T12:08:51.776943 #26360] ERROR – : Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Table 'archivesspace.note_multipart' doesn't exist: SELECT * FROM `note_multipart` LIMIT 1
E, [2018-11-21T12:08:51.782146 #26360] ERROR – : Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Table 'archivesspace.note_orderedlist' doesn't exist: DESCRIBE `note_orderedlist`
E, [2018-11-21T12:08:51.785089 #26360] ERROR – : Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Table 'archivesspace.note_orderedlist' doesn't exist: SELECT * FROM `note_orderedlist` LIMIT 1
E, [2018-11-21T12:08:51.788441 #26360] ERROR – : Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Table 'archivesspace.note_orderedlist' doesn't exist: SELECT * FROM `note_orderedlist` LIMIT 1
E, [2018-11-21T12:08:51.794417 #26360] ERROR – : Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Table 'archivesspace.note_singlepart' doesn't exist: DESCRIBE `note_singlepart`
E, [2018-11-21T12:08:51.796759 #26360] ERROR – : Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Table 'archivesspace.note_singlepart' doesn't exist: SELECT * FROM `note_singlepart` LIMIT 1
E, [2018-11-21T12:08:51.799732 #26360] ERROR – : Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Table 'archivesspace.note_singlepart' doesn't exist: SELECT * FROM `note_singlepart` LIMIT 1

Environment

None

Activity

Show:

Christine Di BellaApril 12, 2021 at 6:50 PM

is there something in the HM pull request that fixes this? Kind of rings a bell.

Blake CarverApril 11, 2019 at 1:20 PM

Happens on everything, I think it's just left over code looking for stuff that doesn't matter. Would be good to clean up though, it's in the core code and happens on every site, but if DB logging isn't enabled it wouldn't be seen. My guess would be there's random old code looking for random old tables

Christine Di BellaApril 11, 2019 at 12:35 PM

- have you seen this in other sites? How were you able to resolve this problem for the user? Not really sure what to do with this as a development ticket.

Details

Assignee

Reporter

Labels

Priority

Harvest Time Tracking

Open Harvest Time Tracking

Created November 21, 2018 at 5:13 PM
Updated February 20, 2024 at 12:36 AM
Harvest Time Tracking

Flag notifications