#116 Submirror plugin: several errors

Closed
opened 4 years ago by aab · 2 comments
aab commented 4 years ago

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.

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}

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>
aab commented 3 years ago
Poster

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/

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/
aab commented 3 years ago
Poster

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 :)

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 :)
Sign in to join this conversation.
No Milestone
No assignee
1 Participants
Loading...
Cancel
Save
There is no content yet.