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
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: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: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'
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>
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/
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 :)
XRevan86
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 ONsubmirror(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 INDEXsubmirror_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 INDEXsubmirror_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 INDEXsubmirror_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 INDEXsubmirror_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}
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/
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 :)