Home Explore Help
Sign In
someonewithpc
/
gnusocial-issues
Watch 1
Star 0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Branch: master
Branches Tags
gnusocial-is...
/
issues
/
notabug.org
/
116

116 6.8 KB
Permalink History Raw

12345678910111213141516171819202122232425 
  1. ---
    2. 

  2. title: Submirror plugin: several errors
    3. 

  3. author: notabug.org/aab
    4. 

  4. time: Sun, 29 Mar 2020 12:04:14 UTC
    5. 

  5. status: closed
    6. 

  6. ---
    7. 

  7. 

  8. author: notabug.org
    9. 

  9. time: Sun, 29 Mar 2020 12:04:14 UTC
    10. 

  10. content: -----
    11. 

  11. This appears on logs as soon as I enable submirror plugin. Besides, the submirror table on db grows *really* quick; after 1 day of operation it is bigger than "notice", with +4GB. <code>2020-03-29 11:42:14 LOG_ERR: [gnusocial.net:856.4a1bc3d3 GET /avatar/22325-48-20180305214937.jpeg] PEAR Error: DB Error: already exists (CREATE INDEX submirror_subscribed_subscriber_idx ON `submirror` (`subscribed`,`subscriber`) [nativecode=1061 ** Duplicate key name 'submirror_subscribed_subscriber_idx']) 2020-03-29 11:42:14 LOG_ERR: [gnusocial.net:856.4a1bc3d3 GET /avatar/22325-48-20180305214937.jpeg] SubMirror::fixIndexes: DB Error: already exists 2020-03-29 11:42:14 LOG_ERR: [gnusocial.net:844.9646ef7e GET /attachment/2543056/thumbnail?w=128&h=38] PEAR Error: DB Error: not found (DROP INDEX submirror_subscribed_subscriber_idx ON `submirror` [nativecode=1091 ** Can't DROP INDEX `submirror_subscribed_subscriber_idx`; check that it exists]) 2020-03-29 11:42:14 LOG_ERR: [gnusocial.net:844.9646ef7e GET /attachment/2543056/thumbnail?w=128&h=38] Exception thrown: 'DB Error: not found' 2020-03-29 11:42:14 LOG_ERR: [gnusocial.net:844.9646ef7e GET /attachment/2543056/thumbnail?w=128&h=38] ServerErrorAction: 500 DB Error: not found #0 /var/www/gnusocial/lib/database/schema.php(543): PEAR_ErrorToPEAR_Exception(Object(DB_Error)) #1 /var/www/gnusocial/lib/database/schema.php(518): Schema->runSqlSet(Array) #2 /var/www/gnusocial/plugins/SubMirror/SubMirrorPlugin.php(101): Schema->ensureTable('submirror', Array) #3 /var/www/gnusocial/lib/util/event.php(89): SubMirrorPlugin->onCheckSchema() #4 /var/www/gnusocial/lib/util/gnusocial.php(300): Event::handle('CheckSchema') #5 /var/www/gnusocial/lib/util/gnusocial.php(208): GNUsocial::initModules() #6 /var/www/gnusocial/lib/util/common.php(30): GNUsocial::init(NULL, NULL, NULL) #7 /var/www/gnusocial/public/index.php(171): require_once('/var/www/gnusoc...') #8 {main} 2020-03-29 11:42:14 LOG_ERR: [gnusocial.net:902.27026001 GET /notice/7519795] PEAR Error: DB Error: not found (DROP INDEX submirror_subscribed_subscriber_idx ON `submirror` [nativecode=1091 ** Can't DROP INDEX `submirror_subscribed_subscriber_idx`; check that it exists]) 2020-03-29 11:42:14 LOG_ERR: [gnusocial.net:902.27026001 GET /notice/7519795] Exception thrown: 'DB Error: not found' 2020-03-29 11:42:14 LOG_ERR: [gnusocial.net:902.27026001 GET /notice/7519795] ServerErrorAction: 500 DB Error: not found #0 /var/www/gnusocial/lib/database/schema.php(543): PEAR_ErrorToPEAR_Exception(Object(DB_Error)) #1 /var/www/gnusocial/lib/database/schema.php(518): Schema->runSqlSet(Array) #2 /var/www/gnusocial/plugins/SubMirror/SubMirrorPlugin.php(101): Schema->ensureTable('submirror', Array) #3 /var/www/gnusocial/lib/util/event.php(89): SubMirrorPlugin->onCheckSchema() #4 /var/www/gnusocial/lib/util/gnusocial.php(300): Event::handle('CheckSchema') #5 /var/www/gnusocial/lib/util/gnusocial.php(208): GNUsocial::initModules() #6 /var/www/gnusocial/lib/util/common.php(30): GNUsocial::init(NULL, NULL, NULL) #7 /var/www/gnusocial/public/index.php(171): require_once('/var/www/gnusoc...') #8 {main} 2020-03-29 11:42:14 LOG_ERR: [gnusocial.net:844.7a87d783 GET /attachment/2527398/thumbnail?w=128&h=72] PEAR Error: DB Error: not found (DROP INDEX submirror_subscribed_subscriber_idx ON `submirror` [nativecode=1091 ** Can't DROP INDEX `submirror_subscribed_subscriber_idx`; check that it exists]) 2020-03-29 11:42:14 LOG_ERR: [gnusocial.net:844.7a87d783 GET /attachment/2527398/thumbnail?w=128&h=72] Exception thrown: 'DB Error: not found' 2020-03-29 11:42:14 LOG_ERR: [gnusocial.net:844.7a87d783 GET /attachment/2527398/thumbnail?w=128&h=72] ServerErrorAction: 500 DB Error: not found #0 /var/www/gnusocial/lib/database/schema.php(543): PEAR_ErrorToPEAR_Exception(Object(DB_Error)) #1 /var/www/gnusocial/lib/database/schema.php(518): Schema->runSqlSet(Array) #2 /var/www/gnusocial/plugins/SubMirror/SubMirrorPlugin.php(101): Schema->ensureTable('submirror', Array) #3 /var/www/gnusocial/lib/util/event.php(89): SubMirrorPlugin->onCheckSchema() #4 /var/www/gnusocial/lib/util/gnusocial.php(300): Event::handle('CheckSchema') #5 /var/www/gnusocial/lib/util/gnusocial.php(208): GNUsocial::initModules() #6 /var/www/gnusocial/lib/util/common.php(30): GNUsocial::init(NULL, NULL, NULL) #7 /var/www/gnusocial/public/index.php(171): require_once('/var/www/gnusoc...') #8 {main} 2020-03-29 11:42:17 LOG_ERR: [gnusocial.net:889.e84fac2e GET /index.php/user/17097] PEAR Error: DB Error: already exists (CREATE INDEX submirror_subscribed_subscriber_idx ON `submirror` (`subscribed`,`subscriber`) [nativecode=1061 ** Duplicate key name 'submirror_subscribed_subscriber_idx']) 2020-03-29 11:42:17 LOG_ERR: [gnusocial.net:889.e84fac2e GET /index.php/user/17097] SubMirror::fixIndexes: DB Error: already exists 2020-03-29 11:42:18 LOG_ERR: [gnusocial.net:852.c08fee85 GET /menoslobos] PEAR Error: DB Error: not found (DROP INDEX submirror_subscribed_subscriber_idx ON `submirror` [nativecode=1091 ** Can't DROP INDEX `submirror_subscribed_subscriber_idx`; check that it exists]) 2020-03-29 11:42:18 LOG_ERR: [gnusocial.net:852.c08fee85 GET /menoslobos] Exception thrown: 'DB Error: not found' 2020-03-29 11:42:18 LOG_ERR: [gnusocial.net:852.c08fee85 GET /menoslobos] ServerErrorAction: 500 DB Error: not found #0 /var/www/gnusocial/lib/database/schema.php(543): PEAR_ErrorToPEAR_Exception(Object(DB_Error)) #1 /var/www/gnusocial/lib/database/schema.php(518): Schema->runSqlSet(Array) #2 /var/www/gnusocial/plugins/SubMirror/SubMirrorPlugin.php(101): Schema->ensureTable('submirror', Array) #3 /var/www/gnusocial/lib/util/event.php(89): SubMirrorPlugin->onCheckSchema() #4 /var/www/gnusocial/lib/util/gnusocial.php(300): Event::handle('CheckSchema') #5 /var/www/gnusocial/lib/util/gnusocial.php(208): GNUsocial::initModules() #6 /var/www/gnusocial/lib/util/common.php(30): GNUsocial::init(NULL, NULL, NULL) #7 /var/www/gnusocial/public/index.php(171): require_once('/var/www/gnusoc...') #8 {main}</code>
    12. 

  12. -----
    13. 

  13. 

  14. author: notabug.org
    15. 

  15. time: Thu, 16 Jul 2020 20:47:01 UTC
    16. 

  16. content: -----
    17. 

  17. After these three months, i've enabled SubMirror again, and i'm not seeing any of those lines in the logs, and the size of the table in db is stable. Nevertheless, the plugin doesn't seem to work... If you want to try, here's a websub enabled feed, that i've setup, but it posts nothing: https://radioalmaina.org/feed/
    18. 

  18. -----
    19. 

  19. 

  20. author: notabug.org
    21. 

  21. time: Fri, 17 Jul 2020 09:34:06 UTC
    22. 

  22. content: -----
    23. 

  23. And today, the plugin is working. Don't know how, but it is :) I'm not really sure what i did in that web (i've tried lots of things); i'm thinking it's maybe because ActivityPub plugin for wordpress. Anyway, i think this bug can be closed :)
    24. 

  24. -----
    25. 

  25.