Conversation

Notices

  1. > drop table feedsub
    Table 'feedsub' doesn't exist
    > create table feedsub
    Table 'feedsub' already exists
    grape php
    grape mysql
    mangokk

    Friday, 22-Jul-16 04:42:12 UTC from quitter.se
    1. at least this zombie state of not existing is better than before, where even thinking about feedsub would instantly cause an assert crash

      Friday, 22-Jul-16 04:48:11 UTC from quitter.se
    2. This happens when the table file doesn't exist but it's still in the schema.

      Friday, 22-Jul-16 04:52:09 UTC from community.highlandarrow.com
      1. @maiyannah well i'm not sure how to fix that since i had it set on innodb ¯\_(ツ)_/¯

        Friday, 22-Jul-16 04:56:20 UTC from quitter.se
        1. @x53 You sacrifice an old server to the sysadmin god

          Friday, 22-Jul-16 04:56:50 UTC from community.highlandarrow.com
        2. @x53 More seriously, was it always innodb?  Because I had the same problem when I changed it over from myISAM or whatever the acronym is.  I basically had to create dummy files, drop the tables, and restore from backup.

          Friday, 22-Jul-16 05:03:06 UTC from community.highlandarrow.com