New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Problems updating to 2018.08 RC #5687

Closed
Alkarex opened this Issue Aug 28, 2018 · 13 comments

Comments

4 participants
@Alkarex

Alkarex commented Aug 28, 2018

Hello,
I am upgrading from 2018.05 to 2018.08 RC. Ubuntu 18.04.1 LTS, default PHP 7.2.7, default MySQL 5.7.23.

  1. Auto-update via the Web interface did not work. It stopped on the maintenance page. (See some logs further down)

2 ) The manual command to update the DB given on https://friendi.ca/2018/08/28/friendica-2018-08-rc-available/ does not exist anymore (scripts/dbstructure.php update). I guess it should be something like ./bin/console dbstructure update

  1. The manual DB update failed for different reasons (some logs further down), but completed after a few attempts. In particular, the error Creating index 'PRIMARY' required more than 'innodb_online_alter_log_max_size' bytes of modification log. Please try again. which I solved by increasing MySQL log max size.

  2. Now the text of all my entries and comments seems to be gone :-(

image

--

image

Any idea?

@Alkarex

This comment has been minimized.

Alkarex commented Aug 28, 2018

MySQL logs during the automatic Web update (which were coming again and again in loop):

2018-08-28T11:28:07.472415Z     31583 Close stmt
2018-08-28T11:28:07.472988Z     31583 Prepare   SELECT `v` FROM `config` WHERE (`cat` = ? AND `k` = ?) LIMIT 1
2018-08-28T11:28:07.473702Z     31583 Close stmt
2018-08-28T11:28:07.474514Z     31583 Prepare   SELECT `v` FROM `config` WHERE (`cat` = ? AND `k` = ?) LIMIT 1
2018-08-28T11:28:07.475158Z     31583 Close stmt
2018-08-28T11:28:07.486739Z     31583 Prepare   SELECT `v` FROM `config` WHERE (`cat` = ? AND `k` = ?) LIMIT 1
2018-08-28T11:28:07.489780Z     31583 Close stmt
2018-08-28T11:28:07.489972Z     31583 Quit
2018-08-28T11:28:07.669398Z     31584 Connect   friendica@localhost on friendica using Socket
2018-08-28T11:28:07.670477Z     31584 Prepare   SELECT 1
2018-08-28T11:28:07.670903Z     31584 Execute   SELECT 1
2018-08-28T11:28:07.671566Z     31584 Close stmt
2018-08-28T11:28:07.672216Z     31584 Prepare   SHOW TABLES LIKE 'config'
2018-08-28T11:28:07.672727Z     31584 Execute   SHOW TABLES LIKE 'config'
2018-08-28T11:28:07.674257Z     31584 Close stmt
2018-08-28T11:28:07.679240Z     31584 Prepare   SELECT `v` FROM `config` WHERE (`cat` = ? AND `k` = ?) LIMIT 1
2018-08-28T11:28:07.680192Z     31584 Close stmt
2018-08-28T11:28:07.681253Z     31584 Prepare   SELECT `v`, `k` FROM `config` WHERE (`cat` = ?)
2018-08-28T11:28:07.682312Z     31584 Close stmt
2018-08-28T11:28:07.686571Z     31584 Prepare   SELECT `hook`, `file`, `function` FROM `hook` ORDER BY `priority` DESC, `file`
2018-08-28T11:28:07.687838Z     31584 Close stmt
2018-08-28T11:28:07.739054Z     31584 Prepare   SELECT `v`, `k` FROM `config` WHERE (`cat` = ?)
2018-08-28T11:28:07.742227Z     31584 Close stmt
2018-08-28T11:28:07.744486Z     31584 Prepare   SELECT `v` FROM `config` WHERE (`cat` = ? AND `k` = ?) LIMIT 1
2018-08-28T11:28:07.745474Z     31584 Close stmt
2018-08-28T11:28:07.746559Z     31584 Prepare   SELECT `name` FROM `addon` WHERE (`installed` = ?)
2018-08-28T11:28:07.747455Z     31584 Close stmt
2018-08-28T11:28:07.748449Z     31584 Prepare   SELECT `v` FROM `config` WHERE (`cat` = ? AND `k` = ?) LIMIT 1
2018-08-28T11:28:07.749419Z     31584 Close stmt
2018-08-28T11:28:07.756501Z     31584 Prepare   SELECT `v` FROM `config` WHERE (`cat` = ? AND `k` = ?) LIMIT 1
2018-08-28T11:28:07.757069Z     31584 Close stmt
2018-08-28T11:28:07.758751Z     31584 Prepare   SELECT `parameter` FROM `workerqueue` WHERE (`parameter` = ? AND `done` = ?) LIMIT 1
2018-08-28T11:28:07.759307Z     31584 Close stmt
2018-08-28T11:28:07.760706Z     31584 Prepare   SELECT `v` FROM `config` WHERE (`cat` = ? AND `k` = ?) LIMIT 1
2018-08-28T11:28:07.761246Z     31584 Close stmt
2018-08-28T11:28:07.763426Z     31584 Prepare   SELECT `v` FROM `config` WHERE (`cat` = ? AND `k` = ?) LIMIT 1
2018-08-28T11:28:07.764057Z     31584 Close stmt
2018-08-28T11:28:07.764852Z     31584 Prepare   SELECT `v` FROM `config` WHERE (`cat` = ? AND `k` = ?) LIMIT 1
2018-08-28T11:28:07.765413Z     31584 Close stmt
2018-08-28T11:28:07.765979Z     31584 Prepare   SELECT COUNT(*) AS `count` FROM `process` WHERE (`command` = ?)
2018-08-28T11:28:07.766471Z     31584 Close stmt
2018-08-28T11:28:07.767211Z     31584 Prepare   SELECT `v` FROM `config` WHERE (`cat` = ? AND `k` = ?) LIMIT 1
2018-08-28T11:28:07.767781Z     31584 Close stmt
2018-08-28T11:28:07.768448Z     31584 Prepare   SELECT `v` FROM `config` WHERE (`cat` = ? AND `k` = ?) LIMIT 1
2018-08-28T11:28:07.769002Z     31584 Close stmt
2018-08-28T11:28:07.769702Z     31584 Prepare   SELECT `v` FROM `config` WHERE (`cat` = ? AND `k` = ?) LIMIT 1
2018-08-28T11:28:07.770294Z     31584 Close stmt
2018-08-28T11:28:07.770882Z     31584 Prepare   SELECT COUNT(*) AS `count` FROM `workerqueue` WHERE (`executed` <= ? AND NOT `done`)
2018-08-28T11:28:07.771435Z     31584 Close stmt
2018-08-28T11:28:07.772051Z     31584 Prepare   SELECT `v` FROM `config` WHERE (`cat` = ? AND `k` = ?) LIMIT 1
2018-08-28T11:28:07.772710Z     31584 Close stmt
2018-08-28T11:28:07.773404Z     31584 Prepare   SELECT `v` FROM `config` WHERE (`cat` = ? AND `k` = ?) LIMIT 1
2018-08-28T11:28:07.774023Z     31584 Close stmt
2018-08-28T11:28:07.774705Z     31584 Prepare   SELECT `v` FROM `config` WHERE (`cat` = ? AND `k` = ?) LIMIT 1
2018-08-28T11:28:07.775360Z     31584 Close stmt
2018-08-28T11:28:07.775964Z     31584 Prepare   SELECT `v` FROM `config` WHERE (`cat` = ? AND `k` = ?) LIMIT 1
2018-08-28T11:28:07.776552Z     31584 Close stmt
2018-08-28T11:28:07.777196Z     31584 Prepare   SELECT `v` FROM `config` WHERE (`cat` = ? AND `k` = ?) LIMIT 1
2018-08-28T11:28:07.777978Z     31584 Close stmt
2018-08-28T11:28:07.778689Z     31584 Prepare   SELECT `v` FROM `config` WHERE (`cat` = ? AND `k` = ?) LIMIT 1
2018-08-28T11:28:07.779281Z     31584 Close stmt
2018-08-28T11:28:07.799136Z     31584 Prepare   SELECT `v` FROM `config` WHERE (`cat` = ? AND `k` = ?) LIMIT 1
2018-08-28T11:28:07.806447Z     31584 Close stmt
2018-08-28T11:28:07.806568Z     31584 Quit
2018-08-28T11:28:07.994795Z     31585 Connect   friendica@localhost on friendica using Socket
2018-08-28T11:28:07.995589Z     31585 Prepare   SELECT 1
2018-08-28T11:28:07.995811Z     31585 Execute   SELECT 1
2018-08-28T11:28:07.996284Z     31585 Close stmt
2018-08-28T11:28:07.996711Z     31585 Prepare   SHOW TABLES LIKE 'config'
2018-08-28T11:28:07.996869Z     31585 Execute   SHOW TABLES LIKE 'config'
2018-08-28T11:28:07.998128Z     31585 Close stmt
2018-08-28T11:28:08.001935Z     31585 Prepare   SELECT `v` FROM `config` WHERE (`cat` = ? AND `k` = ?) LIMIT 1
2018-08-28T11:28:08.002587Z     31585 Close stmt
2018-08-28T11:28:08.003221Z     31585 Prepare   SELECT `v`, `k` FROM `config` WHERE (`cat` = ?)
2018-08-28T11:28:08.003931Z     31585 Close stmt
2018-08-28T11:28:08.006904Z     31585 Prepare   SELECT `hook`, `file`, `function` FROM `hook` ORDER BY `priority` DESC, `file`
2018-08-28T11:28:08.007582Z     31585 Close stmt
2018-08-28T11:28:08.060673Z     31585 Prepare   SELECT `v`, `k` FROM `config` WHERE (`cat` = ?)
2018-08-28T11:28:08.061267Z     31585 Close stmt
2018-08-28T11:28:08.063392Z     31585 Prepare   SELECT `v` FROM `config` WHERE (`cat` = ? AND `k` = ?) LIMIT 1
2018-08-28T11:28:08.064066Z     31585 Close stmt
2018-08-28T11:28:08.064591Z     31585 Prepare   SELECT `name` FROM `addon` WHERE (`installed` = ?)
2018-08-28T11:28:08.065162Z     31585 Close stmt
2018-08-28T11:28:08.065855Z     31585 Prepare   SELECT `v` FROM `config` WHERE (`cat` = ? AND `k` = ?) LIMIT 1
2018-08-28T11:28:08.066541Z     31585 Close
@Alkarex

This comment has been minimized.

Alkarex commented Aug 28, 2018

Commands and logs of the manual DB update:

sudo -u 'www-data' ./bin/console.php dbstructure update
ALTER TABLE `conversation` MODIFY `item-uri` varbinary(255) NOT NULL COMMENT 'Original URI of the item - unrelated to the table with the same name', MODIFY `reply-to-uri` varbinary(255) NOT NULL DEFAULT '' COMMENT 'URI to which this item is a reply', MODIFY `conversation-uri` varbinary(255) NOT NULL DEFAULT '' COMMENT 'GNU Social conversation URI', MODIFY `conversation-href` varbinary(255) NOT NULL DEFAULT '' COMMENT 'GNU Social conversation link', MODIFY `protocol` tinyint unsigned NOT NULL DEFAULT 0 COMMENT 'The protocol of the item', MODIFY `source` mediumtext COMMENT 'Original source', MODIFY `received` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Receiving date';
ALTER TABLE `event` MODIFY `id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID', MODIFY `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Owner User id', MODIFY `cid` int unsigned NOT NULL DEFAULT 0 COMMENT 'contact_id (ID of the contact in contact table)', MODIFY `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'creation time', MODIFY `edited` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'last edit time', MODIFY `start` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'event start time', MODIFY `finish` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'event end time', MODIFY `summary` text COMMENT 'short description or title of the event', MODIFY `desc` text COMMENT 'event description', MODIFY `location` text COMMENT 'event location', MODIFY `type` varchar(20) NOT NULL DEFAULT '' COMMENT 'event or birthday', MODIFY `nofinish` boolean NOT NULL DEFAULT '0' COMMENT 'if event does have no end this is 1', MODIFY `adjust` boolean NOT NULL DEFAULT '1' COMMENT 'adjust to timezone of the recipient (0 or 1)', MODIFY `ignore` boolean NOT NULL DEFAULT '0' COMMENT '0 or 1', MODIFY `allow_cid` mediumtext COMMENT 'Access Control - list of allowed contact.id \'<19><78>\'', MODIFY `allow_gid` mediumtext COMMENT 'Access Control - list of allowed groups', MODIFY `deny_cid` mediumtext COMMENT 'Access Control - list of denied contact.id', MODIFY `deny_gid` mediumtext COMMENT 'Access Control - list of denied groups';
ALTER TABLE `fcontact` MODIFY `id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID', MODIFY `guid` varchar(255) NOT NULL DEFAULT '' COMMENT 'unique id';
ALTER TABLE `gcign` MODIFY `id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID', MODIFY `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Local User id', MODIFY `gcid` int unsigned NOT NULL DEFAULT 0 COMMENT 'gcontact.id of ignored contact';
ALTER TABLE `gcontact` MODIFY `id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID', MODIFY `name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name that this contact is known by', MODIFY `nick` varchar(255) NOT NULL DEFAULT '' COMMENT 'Nick- and user name of the contact', MODIFY `url` varchar(255) NOT NULL DEFAULT '' COMMENT 'Link to the contacts profile page', MODIFY `photo` varchar(255) NOT NULL DEFAULT '' COMMENT 'Link to the profile photo', MODIFY `keywords` text COMMENT 'puplic keywords (interests)', MODIFY `community` boolean NOT NULL DEFAULT '0' COMMENT '1 if contact is forum account', MODIFY `hide` boolean NOT NULL DEFAULT '0' COMMENT '1 = should be hidden from search', MODIFY `nsfw` boolean NOT NULL DEFAULT '0' COMMENT '1 = contact posts nsfw content', MODIFY `network` char(4) NOT NULL DEFAULT '' COMMENT 'social network protocol', MODIFY `server_url` varchar(255) NOT NULL DEFAULT '' COMMENT 'baseurl of the contacts server';
ALTER TABLE `glink` MODIFY `id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID';
ALTER TABLE `group` MODIFY `id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID', MODIFY `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Owner User id', MODIFY `visible` boolean NOT NULL DEFAULT '0' COMMENT '1 indicates the member list is not private', MODIFY `deleted` boolean NOT NULL DEFAULT '0' COMMENT '1 indicates the group has been deleted', MODIFY `name` varchar(255) NOT NULL DEFAULT '' COMMENT 'human readable name of group';
ALTER TABLE `group_member` MODIFY `id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID', MODIFY `gid` int unsigned NOT NULL DEFAULT 0 COMMENT 'groups.id of the associated group', MODIFY `contact-id` int unsigned NOT NULL DEFAULT 0 COMMENT 'contact.id of the member assigned to the associated group';
ALTER TABLE `gserver` MODIFY `id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID', MODIFY `registered-users` int unsigned NOT NULL DEFAULT 0 COMMENT 'Number of registered users';
ALTER TABLE `hook` MODIFY `id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID', MODIFY `hook` varbinary(100) NOT NULL DEFAULT '' COMMENT 'name of hook', MODIFY `file` varbinary(200) NOT NULL DEFAULT '' COMMENT 'relative filename of hook handler', MODIFY `function` varbinary(200) NOT NULL DEFAULT '' COMMENT 'function name of hook handler', MODIFY `priority` smallint unsigned NOT NULL DEFAULT 0 COMMENT 'not yet implemented - can be used to sort conflicts in hook handling by calling handlers in priority order';
ALTER TABLE `intro` MODIFY `id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID';
ALTER TABLE `item` DROP INDEX `contactid_allowcid_allowpid_denycid_denygid`, DROP INDEX `uid_authorlink`, DROP INDEX `uid_ownerlink`, DROP INDEX `uid_type_changed`, DROP INDEX `contactid_verb`, MODIFY `guid` varchar(255) NOT NULL DEFAULT '' COMMENT 'A unique identifier for this item', ADD `uri-id` int unsigned COMMENT 'Id of the item-uri table entry that contains the item uri', ADD `uri-hash` varchar(80) NOT NULL DEFAULT '' COMMENT 'RIPEMD-128 hash from uri', MODIFY `parent` int unsigned NOT NULL DEFAULT 0 COMMENT 'item.id of the parent to this item if it is a reply of some form; otherwise this must be set to the id of this item', MODIFY `parent-uri` varchar(255) NOT NULL DEFAULT '' COMMENT 'uri of the parent to this item', ADD `parent-uri-id` int unsigned COMMENT 'Id of the item-uri table that contains the parent uri', MODIFY `thr-parent` varchar(255) NOT NULL DEFAULT '' COMMENT 'If the parent of this item is not the top-level item in the conversation, the uri of the immediate parent; otherwise set to parent-uri', ADD `thr-parent-id` int unsigned COMMENT 'Id of the item-uri table that contains the thread parent uri', MODIFY `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Creation timestamp.', MODIFY `edited` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Date of last edit (default is created)', MODIFY `commented` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Date of last comment/reply to this item', MODIFY `received` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'datetime', MODIFY `changed` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Date that something in the conversation changed, indicating clients should fetch the conversation again', MODIFY `network` char(4) NOT NULL DEFAULT '' COMMENT 'Network from where the item comes from', MODIFY `owner-id` int unsigned NOT NULL DEFAULT 0 COMMENT 'Link to the contact table with uid=0 of the owner of this item', MODIFY `author-id` int unsigned NOT NULL DEFAULT 0 COMMENT 'Link to the contact table with uid=0 of the author of this item', ADD `icid` int unsigned COMMENT 'Id of the item-content table entry that contains the whole item content', ADD `iaid` int unsigned COMMENT 'Id of the item-activity table entry that contains the activity data', ADD `post-type` tinyint unsigned NOT NULL DEFAULT 0 COMMENT 'Post type (personal note, bookmark, ...)', MODIFY `private` boolean NOT NULL DEFAULT '0' COMMENT 'distribution is restricted', MODIFY `deleted` boolean NOT NULL DEFAULT '0' COMMENT 'item has been deleted', MODIFY `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Owner id which owns this copy of the item', MODIFY `contact-id` int unsigned NOT NULL DEFAULT 0 COMMENT 'contact.id', MODIFY `wall` boolean NOT NULL DEFAULT '0' COMMENT 'This item was posted to the wall of uid', MODIFY `origin` boolean NOT NULL DEFAULT '0' COMMENT 'item originated at this site', MODIFY `starred` boolean NOT NULL DEFAULT '0' COMMENT 'item has been favourited', MODIFY `unseen` boolean NOT NULL DEFAULT '1' COMMENT 'item has not been seen', MODIFY `mention` boolean NOT NULL DEFAULT '0' COMMENT 'The owner of this item was mentioned in it', ADD `psid` int unsigned COMMENT 'ID of the permission set of this post', MODIFY `resource-id` varchar(32) NOT NULL DEFAULT '' COMMENT 'Used to link other tables to items, it identifies the linked resource (e.g. photo) and if set must also set resource_type', MODIFY `event-id` int unsigned NOT NULL DEFAULT 0 COMMENT 'Used to link to the event.id', MODIFY `attach` mediumtext COMMENT 'JSON structure representing attachments to this item', MODIFY `allow_cid` mediumtext COMMENT 'Deprecated', MODIFY `allow_gid` mediumtext COMMENT 'Deprecated', MODIFY `deny_cid` mediumtext COMMENT 'Deprecated', MODIFY `deny_gid` mediumtext COMMENT 'Deprecated', MODIFY `postopts` text COMMENT 'Deprecated', MODIFY `inform` mediumtext COMMENT 'Deprecated', MODIFY `type` varchar(20) COMMENT 'Deprecated', MODIFY `bookmark` boolean COMMENT 'Deprecated', MODIFY `file` mediumtext COMMENT 'Deprecated', MODIFY `location` varchar(255) COMMENT 'Deprecated', MODIFY `coord` varchar(255) COMMENT 'Deprecated', MODIFY `tag` mediumtext COMMENT 'Deprecated', MODIFY `plink` varchar(255) COMMENT 'Deprecated', MODIFY `title` varchar(255) COMMENT 'Deprecated', MODIFY `content-warning` varchar(255) COMMENT 'Deprecated', MODIFY `body` mediumtext COMMENT 'Deprecated', MODIFY `app` varchar(255) COMMENT 'Deprecated', MODIFY `verb` varchar(100) COMMENT 'Deprecated', MODIFY `object-type` varchar(100) COMMENT 'Deprecated', MODIFY `object` text COMMENT 'Deprecated', MODIFY `target-type` varchar(100) COMMENT 'Deprecated', MODIFY `target` text COMMENT 'Deprecated', MODIFY `author-name` varchar(255) COMMENT 'Deprecated', MODIFY `author-link` varchar(255) COMMENT 'Deprecated', MODIFY `author-avatar` varchar(255) COMMENT 'Deprecated', MODIFY `owner-name` varchar(255) COMMENT 'Deprecated', MODIFY `owner-link` varchar(255) COMMENT 'Deprecated', MODIFY `owner-avatar` varchar(255) COMMENT 'Deprecated', MODIFY `rendered-hash` varchar(32) COMMENT 'Deprecated', MODIFY `rendered-html` mediumtext COMMENT 'Deprecated', ADD INDEX `icid` (`icid`), ADD INDEX `iaid` (`iaid`), ADD INDEX `psid_wall` (`psid`,`wall`), COMMENT = 'Structure for all posts';

Error 1799 occurred during database update:
Creating index 'PRIMARY' required more than 'innodb_online_alter_log_max_size' bytes of modification log. Please try again.
CREATE TABLE IF NOT EXISTS `item-activity` (
        `id` int unsigned NOT NULL auto_increment,
        `uri` varchar(255) COMMENT '',
        `uri-id` int unsigned COMMENT 'Id of the item-uri table entry that contains the item uri',
        `uri-hash` varchar(80) NOT NULL DEFAULT '' COMMENT 'RIPEMD-128 hash from uri',
        `activity` smallint unsigned NOT NULL DEFAULT 0 COMMENT '',
         PRIMARY KEY(`id`),
         UNIQUE INDEX `uri-hash` (`uri-hash`),
         INDEX `uri` (`uri`(191))
) DEFAULT COLLATE utf8mb4_general_ci COMMENT='Activities for items';
CREATE TABLE IF NOT EXISTS `item-content` (
        `id` int unsigned NOT NULL auto_increment,
        `uri` varchar(255) COMMENT '',
        `uri-id` int unsigned COMMENT 'Id of the item-uri table entry that contains the item uri',
        `uri-plink-hash` varchar(80) NOT NULL DEFAULT '' COMMENT 'RIPEMD-128 hash from uri',
        `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'item title',
        `content-warning` varchar(255) NOT NULL DEFAULT '' COMMENT '',
        `body` mediumtext COMMENT 'item body content',
        `location` varchar(255) NOT NULL DEFAULT '' COMMENT 'text location where this item originated',
        `coord` varchar(255) NOT NULL DEFAULT '' COMMENT 'longitude/latitude pair representing location where this item originated',
        `language` text COMMENT 'Language information about this post',
        `app` varchar(255) NOT NULL DEFAULT '' COMMENT 'application which generated this item',
        `rendered-hash` varchar(32) NOT NULL DEFAULT '' COMMENT '',
        `rendered-html` mediumtext COMMENT 'item.body converted to html',
        `object-type` varchar(100) NOT NULL DEFAULT '' COMMENT 'ActivityStreams object type',
        `object` text COMMENT 'JSON encoded object structure unless it is an implied object (normal post)',
        `target-type` varchar(100) NOT NULL DEFAULT '' COMMENT 'ActivityStreams target type if applicable (URI)',
        `target` text COMMENT 'JSON encoded target structure if used',
        `plink` varchar(255) NOT NULL DEFAULT '' COMMENT 'permalink or URL to a displayable copy of the message at its source',
        `verb` varchar(100) NOT NULL DEFAULT '' COMMENT 'ActivityStreams verb',
         PRIMARY KEY(`id`),
         UNIQUE INDEX `uri-plink-hash` (`uri-plink-hash`),
         INDEX `uri` (`uri`(191))
) DEFAULT COLLATE utf8mb4_general_ci COMMENT='Content for all posts';
CREATE TABLE IF NOT EXISTS `item-delivery-data` (
        `iid` int unsigned NOT NULL COMMENT 'Item id',
        `postopts` text COMMENT 'External post connectors add their network name to this comma-separated string to identify that they should be delivered to these networks during delivery',
        `inform` mediumtext COMMENT 'Additional receivers of the linked item',
         PRIMARY KEY(`iid`)
) DEFAULT COLLATE utf8mb4_general_ci COMMENT='Delivery data for items';
CREATE TABLE IF NOT EXISTS `item-uri` (
        `id` int unsigned NOT NULL auto_increment,
        `uri` varbinary(255) NOT NULL COMMENT 'URI of an item',
        `guid` varbinary(255) COMMENT 'A unique identifier for an item',
         PRIMARY KEY(`id`),
         UNIQUE INDEX `uri` (`uri`),
         INDEX `guid` (`guid`)
) DEFAULT COLLATE utf8mb4_general_ci COMMENT='URI and GUID for items';
ALTER TABLE `locks` MODIFY `id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID', MODIFY `pid` int unsigned NOT NULL DEFAULT 0 COMMENT 'Process ID', ADD `expires` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'datetime of cache expiration', ADD INDEX `name_expires` (`name`,`expires`);

Error 1060 occurred during database update:
Duplicate column name 'expires'
ALTER TABLE `mail` MODIFY `id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID', MODIFY `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Owner User id', MODIFY `guid` varchar(255) NOT NULL DEFAULT '' COMMENT 'A unique identifier for this private message', MODIFY `from-name` varchar(255) NOT NULL DEFAULT '' COMMENT 'name of the sender', MODIFY `from-photo` varchar(255) NOT NULL DEFAULT '' COMMENT 'contact photo link of the sender', MODIFY `from-url` varchar(255) NOT NULL DEFAULT '' COMMENT 'profile linke of the sender', MODIFY `contact-id` varchar(255) NOT NULL DEFAULT '' COMMENT 'contact.id', MODIFY `convid` int unsigned NOT NULL DEFAULT 0 COMMENT 'conv.id', MODIFY `seen` boolean NOT NULL DEFAULT '0' COMMENT 'if message visited it is 1', MODIFY `unknown` boolean NOT NULL DEFAULT '0' COMMENT 'if sender not in the contact table this is 1', MODIFY `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'creation time of the private message';
ALTER TABLE `mailacct` MODIFY `id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID';
ALTER TABLE `manage` MODIFY `id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID';
ALTER TABLE `notify` MODIFY `id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID', MODIFY `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Owner User id', MODIFY `iid` int unsigned NOT NULL DEFAULT 0 COMMENT 'item.id', MODIFY `name_cache` tinytext COMMENT 'Cached bbcode parsing of name', MODIFY `msg_cache` mediumtext COMMENT 'Cached bbcode parsing of msg';
ALTER TABLE `notify-threads` MODIFY `id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID';
ALTER TABLE `oembed` MODIFY `url` varbinary(255) NOT NULL COMMENT 'page url', MODIFY `maxwidth` mediumint unsigned NOT NULL COMMENT 'Maximum width passed to Oembed', MODIFY `content` mediumtext COMMENT 'OEmbed data of the page', MODIFY `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'datetime of creation';
CREATE TABLE IF NOT EXISTS `openwebauth-token` (
        `id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID',
        `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id',
        `type` varchar(32) NOT NULL DEFAULT '' COMMENT 'Verify type',
        `token` varchar(255) NOT NULL DEFAULT '' COMMENT 'A generated token',
        `meta` varchar(255) NOT NULL DEFAULT '' COMMENT '',
        `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'datetime of creation',
         PRIMARY KEY(`id`)
) DEFAULT COLLATE utf8mb4_general_ci COMMENT='Store OpenWebAuth token to verify contacts';
ALTER TABLE `parsed_url` MODIFY `url` varbinary(255) NOT NULL COMMENT 'page url', MODIFY `guessing` boolean NOT NULL DEFAULT '0' COMMENT 'is the \'guessing\' mode active?', MODIFY `oembed` boolean NOT NULL DEFAULT '0' COMMENT 'is the data the result of oembed?', MODIFY `content` mediumtext COMMENT 'page data', MODIFY `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'datetime of creation';
CREATE TABLE IF NOT EXISTS `permissionset` (
        `id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID',
        `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Owner id of this permission set',
        `allow_cid` mediumtext COMMENT 'Access Control - list of allowed contact.id \'<19><78>\'',
        `allow_gid` mediumtext COMMENT 'Access Control - list of allowed groups',
        `deny_cid` mediumtext COMMENT 'Access Control - list of denied contact.id',
        `deny_gid` mediumtext COMMENT 'Access Control - list of denied groups',
         PRIMARY KEY(`id`),
         INDEX `uid_allow_cid_allow_gid_deny_cid_deny_gid` (`allow_cid`(50),`allow_gid`(30),`deny_cid`(50),`deny_gid`(30))
) DEFAULT COLLATE utf8mb4_general_ci COMMENT='';
ALTER TABLE `photo` MODIFY `id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID', MODIFY `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Owner User id', MODIFY `contact-id` int unsigned NOT NULL DEFAULT 0 COMMENT 'contact.id', MODIFY `guid` char(16) NOT NULL DEFAULT '' COMMENT 'A unique identifier for this photo', MODIFY `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'creation date', MODIFY `edited` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'last edited date', MODIFY `album` varchar(255) NOT NULL DEFAULT '' COMMENT 'The name of the album to which the photo belongs', MODIFY `allow_cid` mediumtext COMMENT 'Access Control - list of allowed contact.id \'<19><78>\'', MODIFY `allow_gid` mediumtext COMMENT 'Access Control - list of allowed groups', MODIFY `deny_cid` mediumtext COMMENT 'Access Control - list of denied contact.id', MODIFY `deny_gid` mediumtext COMMENT 'Access Control - list of denied groups';
ALTER TABLE `poll_result` MODIFY `id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID';
ALTER TABLE `profile` MODIFY `id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID', MODIFY `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Owner User id', MODIFY `profile-name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name of the profile', MODIFY `is-default` boolean NOT NULL DEFAULT '0' COMMENT 'Mark this profile as default profile', MODIFY `hide-friends` boolean NOT NULL DEFAULT '0' COMMENT 'Hide friend list from viewers of this profile', MODIFY `pdesc` varchar(255) NOT NULL DEFAULT '' COMMENT 'Title or description', MODIFY `dob` varchar(32) NOT NULL DEFAULT '0000-00-00' COMMENT 'Day of birth', MODIFY `publish` boolean NOT NULL DEFAULT '0' COMMENT 'publish default profile in local directory', MODIFY `net-publish` boolean NOT NULL DEFAULT '0' COMMENT 'publish profile in global directory';
ALTER TABLE `profile_check` MODIFY `id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID', MODIFY `cid` int unsigned NOT NULL DEFAULT 0 COMMENT 'contact.id';
ALTER TABLE `push_subscriber` MODIFY `id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID';
ALTER TABLE `queue` MODIFY `id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID';
ALTER TABLE `register` MODIFY `id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID';
ALTER TABLE `search` MODIFY `id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID';
ALTER TABLE `session` MODIFY `id` bigint unsigned NOT NULL auto_increment COMMENT 'sequential ID';
ALTER TABLE `sign` MODIFY `id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID', MODIFY `iid` int unsigned NOT NULL DEFAULT 0 COMMENT 'item.id';
ALTER TABLE `thread` MODIFY `iid` int unsigned NOT NULL DEFAULT 0 COMMENT 'sequential ID', MODIFY `owner-id` int unsigned NOT NULL DEFAULT 0 COMMENT 'Item owner', MODIFY `author-id` int unsigned NOT NULL DEFAULT 0 COMMENT 'Item author', ADD `post-type` tinyint unsigned NOT NULL DEFAULT 0 COMMENT 'Post type (personal note, bookmark, ...)', MODIFY `bookmark` boolean COMMENT '';

Error 1060 occurred during database update:
Duplicate column name 'post-type'
ALTER TABLE `user` MODIFY `uid` mediumint unsigned NOT NULL auto_increment COMMENT 'sequential ID', MODIFY `guid` varchar(64) NOT NULL DEFAULT '' COMMENT 'A unique identifier for this user', MODIFY `username` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name that this user is known by', MODIFY `password` varchar(255) NOT NULL DEFAULT '' COMMENT 'encrypted password', MODIFY `nickname` varchar(255) NOT NULL DEFAULT '' COMMENT 'nick- and user name', MODIFY `email` varchar(255) NOT NULL DEFAULT '' COMMENT 'the users email address', MODIFY `timezone` varchar(128) NOT NULL DEFAULT '' COMMENT 'PHP-legal timezone', MODIFY `language` varchar(32) NOT NULL DEFAULT 'en' COMMENT 'default language', MODIFY `register_date` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'timestamp of registration', MODIFY `login_date` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'timestamp of last login', MODIFY `default-location` varchar(255) NOT NULL DEFAULT '' COMMENT 'Default for item.location', MODIFY `allow_location` boolean NOT NULL DEFAULT '0' COMMENT '1 allows to display the location', MODIFY `theme` varchar(255) NOT NULL DEFAULT '' COMMENT 'user theme preference', MODIFY `pubkey` text COMMENT 'RSA public key 4096 bit', MODIFY `prvkey` text COMMENT 'RSA private key 4096 bit', MODIFY `verified` boolean NOT NULL DEFAULT '0' COMMENT 'user is verified through email', MODIFY `blocked` boolean NOT NULL DEFAULT '0' COMMENT '1 for user is blocked', MODIFY `blockwall` boolean NOT NULL DEFAULT '0' COMMENT 'Prohibit contacts to post to the profile page of the user', MODIFY `hidewall` boolean NOT NULL DEFAULT '0' COMMENT 'Hide profile details from unkown viewers', MODIFY `blocktags` boolean NOT NULL DEFAULT '0' COMMENT 'Prohibit contacts to tag the post of this user', MODIFY `unkmail` boolean NOT NULL DEFAULT '0' COMMENT 'Permit unknown people to send private mails to this user', MODIFY `notify-flags` smallint unsigned NOT NULL DEFAULT 65535 COMMENT 'email notification options', MODIFY `page-flags` tinyint unsigned NOT NULL DEFAULT 0 COMMENT 'page/profile type', MODIFY `account_removed` boolean NOT NULL DEFAULT '0' COMMENT 'if 1 the account is removed', MODIFY `account_expires_on` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'timestamp when account expires and will be deleted', MODIFY `expire_notification_sent` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'timestamp of last warning of account expiration', MODIFY `allow_cid` mediumtext COMMENT 'default permission for this user', MODIFY `allow_gid` mediumtext COMMENT 'default permission for this user', MODIFY `deny_cid` mediumtext COMMENT 'default permission for this user', MODIFY `deny_gid` mediumtext COMMENT 'default permission for this user';
ALTER TABLE `userd` MODIFY `id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID';
CREATE TABLE IF NOT EXISTS `user-contact` (
        `cid` int unsigned NOT NULL DEFAULT 0 COMMENT 'Contact id of the linked public contact',
        `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id',
        `blocked` boolean COMMENT 'Contact is completely blocked for this user',
        `ignored` boolean COMMENT 'Posts from this contact are ignored',
        `collapsed` boolean COMMENT 'Posts from this contact are collapsed',
         PRIMARY KEY(`uid`,`cid`)
) DEFAULT COLLATE utf8mb4_general_ci COMMENT='User specific public contact data';
ALTER TABLE `user-item` ADD `ignored` boolean COMMENT 'Ignore this thread if set', COMMENT = 'User specific item data';

Error 1060 occurred during database update:
Duplicate column name 'ignored'
CREATE TABLE IF NOT EXISTS `worker-ipc` (
        `key` int NOT NULL COMMENT '',
        `jobs` boolean COMMENT 'Flag for outstanding jobs',
         PRIMARY KEY(`key`)
) ENGINE=MEMORY DEFAULT COLLATE utf8mb4_general_ci COMMENT='Inter process communication between the frontend and the worker';
ALTER TABLE `workerqueue` MODIFY `done` boolean NOT NULL DEFAULT '0' COMMENT 'Marked 1 when the task was done - will be deleted later';
Errors encountered performing database changes: ALTER TABLE `item` DROP INDEX `contactid_allowcid_allowpid_denycid_denygid`, DROP INDEX `uid_authorlink`, DROP INDEX `uid_ownerlink`, DROP INDEX `uid_type_changed`, DROP INDEX `contactid_verb`, MODIFY `guid` varchar(255) NOT NULL DEFAULT '' COMMENT 'A unique identifier for this item', ADD `uri-id` int unsigned COMMENT 'Id of the item-uri table entry that contains the item uri', ADD `uri-hash` varchar(80) NOT NULL DEFAULT '' COMMENT 'RIPEMD-128 hash from uri', MODIFY `parent` int unsigned NOT NULL DEFAULT 0 COMMENT 'item.id of the parent to this item if it is a reply of some form; otherwise this must be set to the id of this item', MODIFY `parent-uri` varchar(255) NOT NULL DEFAULT '' COMMENT 'uri of the parent to this item', ADD `parent-uri-id` int unsigned COMMENT 'Id of the item-uri table that contains the parent uri', MODIFY `thr-parent` varchar(255) NOT NULL DEFAULT '' COMMENT 'If the parent of this item is not the top-level item in the conversation, the uri of the immediate parent; otherwise set to parent-uri', ADD `thr-parent-id` int unsigned COMMENT 'Id of the item-uri table that contains the thread parent uri', MODIFY `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Creation timestamp.', MODIFY `edited` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Date of last edit (default is created)', MODIFY `commented` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Date of last comment/reply to this item', MODIFY `received` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'datetime', MODIFY `changed` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Date that something in the conversation changed, indicating clients should fetch the conversation again', MODIFY `network` char(4) NOT NULL DEFAULT '' COMMENT 'Network from where the item comes from', MODIFY `owner-id` int unsigned NOT NULL DEFAULT 0 COMMENT 'Link to the contact table with uid=0 of the owner of this item', MODIFY `author-id` int unsigned NOT NULL DEFAULT 0 COMMENT 'Link to the contact table with uid=0 of the author of this item', ADD `icid` int unsigned COMMENT 'Id of the item-content table entry that contains the whole item content', ADD `iaid` int unsigned COMMENT 'Id of the item-activity table entry that contains the activity data', ADD `post-type` tinyint unsigned NOT NULL DEFAULT 0 COMMENT 'Post type (personal note, bookmark, ...)', MODIFY `private` boolean NOT NULL DEFAULT '0' COMMENT 'distribution is restricted', MODIFY `deleted` boolean NOT NULL DEFAULT '0' COMMENT 'item has been deleted', MODIFY `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Owner id which owns this copy of the item', MODIFY `contact-id` int unsigned NOT NULL DEFAULT 0 COMMENT 'contact.id', MODIFY `wall` boolean NOT NULL DEFAULT '0' COMMENT 'This item was posted to the wall of uid', MODIFY `origin` boolean NOT NULL DEFAULT '0' COMMENT 'item originated at this site', MODIFY `starred` boolean NOT NULL DEFAULT '0' COMMENT 'item has been favourited', MODIFY `unseen` boolean NOT NULL DEFAULT '1' COMMENT 'item has not been seen', MODIFY `mention` boolean NOT NULL DEFAULT '0' COMMENT 'The owner of this item was mentioned in it', ADD `psid` int unsigned COMMENT 'ID of the permission set of this post', MODIFY `resource-id` varchar(32) NOT NULL DEFAULT '' COMMENT 'Used to link other tables to items, it identifies the linked resource (e.g. photo) and if set must also set resource_type', MODIFY `event-id` int unsigned NOT NULL DEFAULT 0 COMMENT 'Used to link to the event.id', MODIFY `attach` mediumtext COMMENT 'JSON structure representing attachments to this item', MODIFY `allow_cid` mediumtext COMMENT 'Deprecated', MODIFY `allow_gid` mediumtext COMMENT 'Deprecated', MODIFY `deny_cid` mediumtext COMMENT 'Deprecated', MODIFY `deny_gid` mediumtext COMMENT 'Deprecated', MODIFY `postopts` text COMMENT 'Deprecated', MODIFY `inform` mediumtext COMMENT 'Deprecated', MODIFY `type` varchar(20) COMMENT 'Deprecated', MODIFY `bookmark` boolean COMMENT 'Deprecated', MODIFY `file` mediumtext COMMENT 'Deprecated', MODIFY `location` varchar(255) COMMENT 'Deprecated', MODIFY `coord` varchar(255) COMMENT 'Deprecated', MODIFY `tag` mediumtext COMMENT 'Deprecated', MODIFY `plink` varchar(255) COMMENT 'Deprecated', MODIFY `title` varchar(255) COMMENT 'Deprecated', MODIFY `content-warning` varchar(255) COMMENT 'Deprecated', MODIFY `body` mediumtext COMMENT 'Deprecated', MODIFY `app` varchar(255) COMMENT 'Deprecated', MODIFY `verb` varchar(100) COMMENT 'Deprecated', MODIFY `object-type` varchar(100) COMMENT 'Deprecated', MODIFY `object` text COMMENT 'Deprecated', MODIFY `target-type` varchar(100) COMMENT 'Deprecated', MODIFY `target` text COMMENT 'Deprecated', MODIFY `author-name` varchar(255) COMMENT 'Deprecated', MODIFY `author-link` varchar(255) COMMENT 'Deprecated', MODIFY `author-avatar` varchar(255) COMMENT 'Deprecated', MODIFY `owner-name` varchar(255) COMMENT 'Deprecated', MODIFY `owner-link` varchar(255) COMMENT 'Deprecated', MODIFY `owner-avatar` varchar(255) COMMENT 'Deprecated', MODIFY `rendered-hash` varchar(32) COMMENT 'Deprecated', MODIFY `rendered-html` mediumtext COMMENT 'Deprecated', ADD INDEX `icid` (`icid`), ADD INDEX `iaid` (`iaid`), ADD INDEX `psid_wall` (`psid`,`wall`), COMMENT = 'Structure for all posts'; <br />
Errors encountered performing database changes: ALTER TABLE `locks` MODIFY `id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID', MODIFY `pid` int unsigned NOT NULL DEFAULT 0 COMMENT 'Process ID', ADD `expires` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'datetime of cache expiration', ADD INDEX `name_expires` (`name`,`expires`); <br />
Errors encountered performing database changes: ALTER TABLE `thread` MODIFY `iid` int unsigned NOT NULL DEFAULT 0 COMMENT 'sequential ID', MODIFY `owner-id` int unsigned NOT NULL DEFAULT 0 COMMENT 'Item owner', MODIFY `author-id` int unsigned NOT NULL DEFAULT 0 COMMENT 'Item author', ADD `post-type` tinyint unsigned NOT NULL DEFAULT 0 COMMENT 'Post type (personal note, bookmark, ...)', MODIFY `bookmark` boolean COMMENT ''; <br />
Errors encountered performing database changes: ALTER TABLE `user-item` ADD `ignored` boolean COMMENT 'Ignore this thread if set', COMMENT = 'User specific item data'; <br />

####

sudo -u 'www-data' ./bin/console.php dbstructure update
ALTER TABLE `item` DROP INDEX `contactid_allowcid_allowpid_denycid_denygid`, DROP INDEX `uid_authorlink`, DROP INDEX `uid_ownerlink`, DROP INDEX `uid_type_changed`, DROP INDEX `contactid_verb`, MODIFY `guid` varchar(255) NOT NULL DEFAULT '' COMMENT 'A unique identifier for this item', ADD `uri-id` int unsigned COMMENT 'Id of the item-uri table entry that contains the item uri', ADD `uri-hash` varchar(80) NOT NULL DEFAULT '' COMMENT 'RIPEMD-128 hash from uri', MODIFY `parent` int unsigned NOT NULL DEFAULT 0 COMMENT 'item.id of the parent to this item if it is a reply of some form; otherwise this must be set to the id of this item', MODIFY `parent-uri` varchar(255) NOT NULL DEFAULT '' COMMENT 'uri of the parent to this item', ADD `parent-uri-id` int unsigned COMMENT 'Id of the item-uri table that contains the parent uri', MODIFY `thr-parent` varchar(255) NOT NULL DEFAULT '' COMMENT 'If the parent of this item is not the top-level item in the conversation, the uri of the immediate parent; otherwise set to parent-uri', ADD `thr-parent-id` int unsigned COMMENT 'Id of the item-uri table that contains the thread parent uri', MODIFY `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Creation timestamp.', MODIFY `edited` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Date of last edit (default is created)', MODIFY `commented` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Date of last comment/reply to this item', MODIFY `received` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'datetime', MODIFY `changed` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Date that something in the conversation changed, indicating clients should fetch the conversation again', MODIFY `network` char(4) NOT NULL DEFAULT '' COMMENT 'Network from where the item comes from', MODIFY `owner-id` int unsigned NOT NULL DEFAULT 0 COMMENT 'Link to the contact table with uid=0 of the owner of this item', MODIFY `author-id` int unsigned NOT NULL DEFAULT 0 COMMENT 'Link to the contact table with uid=0 of the author of this item', ADD `icid` int unsigned COMMENT 'Id of the item-content table entry that contains the whole item content', ADD `iaid` int unsigned COMMENT 'Id of the item-activity table entry that contains the activity data', ADD `post-type` tinyint unsigned NOT NULL DEFAULT 0 COMMENT 'Post type (personal note, bookmark, ...)', MODIFY `private` boolean NOT NULL DEFAULT '0' COMMENT 'distribution is restricted', MODIFY `deleted` boolean NOT NULL DEFAULT '0' COMMENT 'item has been deleted', MODIFY `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Owner id which owns this copy of the item', MODIFY `contact-id` int unsigned NOT NULL DEFAULT 0 COMMENT 'contact.id', MODIFY `wall` boolean NOT NULL DEFAULT '0' COMMENT 'This item was posted to the wall of uid', MODIFY `origin` boolean NOT NULL DEFAULT '0' COMMENT 'item originated at this site', MODIFY `starred` boolean NOT NULL DEFAULT '0' COMMENT 'item has been favourited', MODIFY `unseen` boolean NOT NULL DEFAULT '1' COMMENT 'item has not been seen', MODIFY `mention` boolean NOT NULL DEFAULT '0' COMMENT 'The owner of this item was mentioned in it', ADD `psid` int unsigned COMMENT 'ID of the permission set of this post', MODIFY `resource-id` varchar(32) NOT NULL DEFAULT '' COMMENT 'Used to link other tables to items, it identifies the linked resource (e.g. photo) and if set must also set resource_type', MODIFY `event-id` int unsigned NOT NULL DEFAULT 0 COMMENT 'Used to link to the event.id', MODIFY `attach` mediumtext COMMENT 'JSON structure representing attachments to this item', MODIFY `allow_cid` mediumtext COMMENT 'Deprecated', MODIFY `allow_gid` mediumtext COMMENT 'Deprecated', MODIFY `deny_cid` mediumtext COMMENT 'Deprecated', MODIFY `deny_gid` mediumtext COMMENT 'Deprecated', MODIFY `postopts` text COMMENT 'Deprecated', MODIFY `inform` mediumtext COMMENT 'Deprecated', MODIFY `type` varchar(20) COMMENT 'Deprecated', MODIFY `bookmark` boolean COMMENT 'Deprecated', MODIFY `file` mediumtext COMMENT 'Deprecated', MODIFY `location` varchar(255) COMMENT 'Deprecated', MODIFY `coord` varchar(255) COMMENT 'Deprecated', MODIFY `tag` mediumtext COMMENT 'Deprecated', MODIFY `plink` varchar(255) COMMENT 'Deprecated', MODIFY `title` varchar(255) COMMENT 'Deprecated', MODIFY `content-warning` varchar(255) COMMENT 'Deprecated', MODIFY `body` mediumtext COMMENT 'Deprecated', MODIFY `app` varchar(255) COMMENT 'Deprecated', MODIFY `verb` varchar(100) COMMENT 'Deprecated', MODIFY `object-type` varchar(100) COMMENT 'Deprecated', MODIFY `object` text COMMENT 'Deprecated', MODIFY `target-type` varchar(100) COMMENT 'Deprecated', MODIFY `target` text COMMENT 'Deprecated', MODIFY `author-name` varchar(255) COMMENT 'Deprecated', MODIFY `author-link` varchar(255) COMMENT 'Deprecated', MODIFY `author-avatar` varchar(255) COMMENT 'Deprecated', MODIFY `owner-name` varchar(255) COMMENT 'Deprecated', MODIFY `owner-link` varchar(255) COMMENT 'Deprecated', MODIFY `owner-avatar` varchar(255) COMMENT 'Deprecated', MODIFY `rendered-hash` varchar(32) COMMENT 'Deprecated', MODIFY `rendered-html` mediumtext COMMENT 'Deprecated', ADD INDEX `icid` (`icid`), ADD INDEX `iaid` (`iaid`), ADD INDEX `psid_wall` (`psid`,`wall`), COMMENT = 'Structure for all posts';

Error 1799 occurred during database update:
Creating index 'PRIMARY' required more than 'innodb_online_alter_log_max_size' bytes of modification log. Please try again.
Errors encountered performing database changes: ALTER TABLE `item` DROP INDEX `contactid_allowcid_allowpid_denycid_denygid`, DROP INDEX `uid_authorlink`, DROP INDEX `uid_ownerlink`, DROP INDEX `uid_type_changed`, DROP INDEX `contactid_verb`, MODIFY `guid` varchar(255) NOT NULL DEFAULT '' COMMENT 'A unique identifier for this item', ADD `uri-id` int unsigned COMMENT 'Id of the item-uri table entry that contains the item uri', ADD `uri-hash` varchar(80) NOT NULL DEFAULT '' COMMENT 'RIPEMD-128 hash from uri', MODIFY `parent` int unsigned NOT NULL DEFAULT 0 COMMENT 'item.id of the parent to this item if it is a reply of some form; otherwise this must be set to the id of this item', MODIFY `parent-uri` varchar(255) NOT NULL DEFAULT '' COMMENT 'uri of the parent to this item', ADD `parent-uri-id` int unsigned COMMENT 'Id of the item-uri table that contains the parent uri', MODIFY `thr-parent` varchar(255) NOT NULL DEFAULT '' COMMENT 'If the parent of this item is not the top-level item in the conversation, the uri of the immediate parent; otherwise set to parent-uri', ADD `thr-parent-id` int unsigned COMMENT 'Id of the item-uri table that contains the thread parent uri', MODIFY `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Creation timestamp.', MODIFY `edited` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Date of last edit (default is created)', MODIFY `commented` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Date of last comment/reply to this item', MODIFY `received` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'datetime', MODIFY `changed` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Date that something in the conversation changed, indicating clients should fetch the conversation again', MODIFY `network` char(4) NOT NULL DEFAULT '' COMMENT 'Network from where the item comes from', MODIFY `owner-id` int unsigned NOT NULL DEFAULT 0 COMMENT 'Link to the contact table with uid=0 of the owner of this item', MODIFY `author-id` int unsigned NOT NULL DEFAULT 0 COMMENT 'Link to the contact table with uid=0 of the author of this item', ADD `icid` int unsigned COMMENT 'Id of the item-content table entry that contains the whole item content', ADD `iaid` int unsigned COMMENT 'Id of the item-activity table entry that contains the activity data', ADD `post-type` tinyint unsigned NOT NULL DEFAULT 0 COMMENT 'Post type (personal note, bookmark, ...)', MODIFY `private` boolean NOT NULL DEFAULT '0' COMMENT 'distribution is restricted', MODIFY `deleted` boolean NOT NULL DEFAULT '0' COMMENT 'item has been deleted', MODIFY `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Owner id which owns this copy of the item', MODIFY `contact-id` int unsigned NOT NULL DEFAULT 0 COMMENT 'contact.id', MODIFY `wall` boolean NOT NULL DEFAULT '0' COMMENT 'This item was posted to the wall of uid', MODIFY `origin` boolean NOT NULL DEFAULT '0' COMMENT 'item originated at this site', MODIFY `starred` boolean NOT NULL DEFAULT '0' COMMENT 'item has been favourited', MODIFY `unseen` boolean NOT NULL DEFAULT '1' COMMENT 'item has not been seen', MODIFY `mention` boolean NOT NULL DEFAULT '0' COMMENT 'The owner of this item was mentioned in it', ADD `psid` int unsigned COMMENT 'ID of the permission set of this post', MODIFY `resource-id` varchar(32) NOT NULL DEFAULT '' COMMENT 'Used to link other tables to items, it identifies the linked resource (e.g. photo) and if set must also set resource_type', MODIFY `event-id` int unsigned NOT NULL DEFAULT 0 COMMENT 'Used to link to the event.id', MODIFY `attach` mediumtext COMMENT 'JSON structure representing attachments to this item', MODIFY `allow_cid` mediumtext COMMENT 'Deprecated', MODIFY `allow_gid` mediumtext COMMENT 'Deprecated', MODIFY `deny_cid` mediumtext COMMENT 'Deprecated', MODIFY `deny_gid` mediumtext COMMENT 'Deprecated', MODIFY `postopts` text COMMENT 'Deprecated', MODIFY `inform` mediumtext COMMENT 'Deprecated', MODIFY `type` varchar(20) COMMENT 'Deprecated', MODIFY `bookmark` boolean COMMENT 'Deprecated', MODIFY `file` mediumtext COMMENT 'Deprecated', MODIFY `location` varchar(255) COMMENT 'Deprecated', MODIFY `coord` varchar(255) COMMENT 'Deprecated', MODIFY `tag` mediumtext COMMENT 'Deprecated', MODIFY `plink` varchar(255) COMMENT 'Deprecated', MODIFY `title` varchar(255) COMMENT 'Deprecated', MODIFY `content-warning` varchar(255) COMMENT 'Deprecated', MODIFY `body` mediumtext COMMENT 'Deprecated', MODIFY `app` varchar(255) COMMENT 'Deprecated', MODIFY `verb` varchar(100) COMMENT 'Deprecated', MODIFY `object-type` varchar(100) COMMENT 'Deprecated', MODIFY `object` text COMMENT 'Deprecated', MODIFY `target-type` varchar(100) COMMENT 'Deprecated', MODIFY `target` text COMMENT 'Deprecated', MODIFY `author-name` varchar(255) COMMENT 'Deprecated', MODIFY `author-link` varchar(255) COMMENT 'Deprecated', MODIFY `author-avatar` varchar(255) COMMENT 'Deprecated', MODIFY `owner-name` varchar(255) COMMENT 'Deprecated', MODIFY `owner-link` varchar(255) COMMENT 'Deprecated', MODIFY `owner-avatar` varchar(255) COMMENT 'Deprecated', MODIFY `rendered-hash` varchar(32) COMMENT 'Deprecated', MODIFY `rendered-html` mediumtext COMMENT 'Deprecated', ADD INDEX `icid` (`icid`), ADD INDEX `iaid` (`iaid`), ADD INDEX `psid_wall` (`psid`,`wall`), COMMENT = 'Structure for all posts'; <br />

####

mysql> show variables like 'innodb_online_alter_log_max_size';
+----------------------------------+-----------+
| Variable_name                    | Value     |
+----------------------------------+-----------+
| innodb_online_alter_log_max_size | 134217728 |
+----------------------------------+-----------+
1 row in set (0.01 sec)

mysql> set global innodb_online_alter_log_max_size=268435456;
Query OK, 0 rows affected (0.01 sec)

mysql> show variables like 'innodb_online_alter_log_max_size';
+----------------------------------+-----------+
| Variable_name                    | Value     |
+----------------------------------+-----------+
| innodb_online_alter_log_max_size | 268435456 |
+----------------------------------+-----------+
1 row in set (0.02 sec)

####

sudo -u 'www-data' ./bin/console.php dbstructure update
ALTER TABLE `item` DROP INDEX `contactid_allowcid_allowpid_denycid_denygid`, DROP INDEX `uid_authorlink`, DROP INDEX `uid_ownerlink`, DROP INDEX `uid_type_changed`, DROP INDEX `contactid_verb`, MODIFY `guid` varchar(255) NOT NULL DEFAULT '' COMMENT 'A unique identifier for this item', ADD `uri-id` int unsigned COMMENT 'Id of the item-uri table entry that contains the item uri', ADD `uri-hash` varchar(80) NOT NULL DEFAULT '' COMMENT 'RIPEMD-128 hash from uri', MODIFY `parent` int unsigned NOT NULL DEFAULT 0 COMMENT 'item.id of the parent to this item if it is a reply of some form; otherwise this must be set to the id of this item', MODIFY `parent-uri` varchar(255) NOT NULL DEFAULT '' COMMENT 'uri of the parent to this item', ADD `parent-uri-id` int unsigned COMMENT 'Id of the item-uri table that contains the parent uri', MODIFY `thr-parent` varchar(255) NOT NULL DEFAULT '' COMMENT 'If the parent of this item is not the top-level item in the conversation, the uri of the immediate parent; otherwise set to parent-uri', ADD `thr-parent-id` int unsigned COMMENT 'Id of the item-uri table that contains the thread parent uri', MODIFY `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Creation timestamp.', MODIFY `edited` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Date of last edit (default is created)', MODIFY `commented` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Date of last comment/reply to this item', MODIFY `received` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'datetime', MODIFY `changed` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Date that something in the conversation changed, indicating clients should fetch the conversation again', MODIFY `network` char(4) NOT NULL DEFAULT '' COMMENT 'Network from where the item comes from', MODIFY `owner-id` int unsigned NOT NULL DEFAULT 0 COMMENT 'Link to the contact table with uid=0 of the owner of this item', MODIFY `author-id` int unsigned NOT NULL DEFAULT 0 COMMENT 'Link to the contact table with uid=0 of the author of this item', ADD `icid` int unsigned COMMENT 'Id of the item-content table entry that contains the whole item content', ADD `iaid` int unsigned COMMENT 'Id of the item-activity table entry that contains the activity data', ADD `post-type` tinyint unsigned NOT NULL DEFAULT 0 COMMENT 'Post type (personal note, bookmark, ...)', MODIFY `private` boolean NOT NULL DEFAULT '0' COMMENT 'distribution is restricted', MODIFY `deleted` boolean NOT NULL DEFAULT '0' COMMENT 'item has been deleted', MODIFY `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Owner id which owns this copy of the item', MODIFY `contact-id` int unsigned NOT NULL DEFAULT 0 COMMENT 'contact.id', MODIFY `wall` boolean NOT NULL DEFAULT '0' COMMENT 'This item was posted to the wall of uid', MODIFY `origin` boolean NOT NULL DEFAULT '0' COMMENT 'item originated at this site', MODIFY `starred` boolean NOT NULL DEFAULT '0' COMMENT 'item has been favourited', MODIFY `unseen` boolean NOT NULL DEFAULT '1' COMMENT 'item has not been seen', MODIFY `mention` boolean NOT NULL DEFAULT '0' COMMENT 'The owner of this item was mentioned in it', ADD `psid` int unsigned COMMENT 'ID of the permission set of this post', MODIFY `resource-id` varchar(32) NOT NULL DEFAULT '' COMMENT 'Used to link other tables to items, it identifies the linked resource (e.g. photo) and if set must also set resource_type', MODIFY `event-id` int unsigned NOT NULL DEFAULT 0 COMMENT 'Used to link to the event.id', MODIFY `attach` mediumtext COMMENT 'JSON structure representing attachments to this item', MODIFY `allow_cid` mediumtext COMMENT 'Deprecated', MODIFY `allow_gid` mediumtext COMMENT 'Deprecated', MODIFY `deny_cid` mediumtext COMMENT 'Deprecated', MODIFY `deny_gid` mediumtext COMMENT 'Deprecated', MODIFY `postopts` text COMMENT 'Deprecated', MODIFY `inform` mediumtext COMMENT 'Deprecated', MODIFY `type` varchar(20) COMMENT 'Deprecated', MODIFY `bookmark` boolean COMMENT 'Deprecated', MODIFY `file` mediumtext COMMENT 'Deprecated', MODIFY `location` varchar(255) COMMENT 'Deprecated', MODIFY `coord` varchar(255) COMMENT 'Deprecated', MODIFY `tag` mediumtext COMMENT 'Deprecated', MODIFY `plink` varchar(255) COMMENT 'Deprecated', MODIFY `title` varchar(255) COMMENT 'Deprecated', MODIFY `content-warning` varchar(255) COMMENT 'Deprecated', MODIFY `body` mediumtext COMMENT 'Deprecated', MODIFY `app` varchar(255) COMMENT 'Deprecated', MODIFY `verb` varchar(100) COMMENT 'Deprecated', MODIFY `object-type` varchar(100) COMMENT 'Deprecated', MODIFY `object` text COMMENT 'Deprecated', MODIFY `target-type` varchar(100) COMMENT 'Deprecated', MODIFY `target` text COMMENT 'Deprecated', MODIFY `author-name` varchar(255) COMMENT 'Deprecated', MODIFY `author-link` varchar(255) COMMENT 'Deprecated', MODIFY `author-avatar` varchar(255) COMMENT 'Deprecated', MODIFY `owner-name` varchar(255) COMMENT 'Deprecated', MODIFY `owner-link` varchar(255) COMMENT 'Deprecated', MODIFY `owner-avatar` varchar(255) COMMENT 'Deprecated', MODIFY `rendered-hash` varchar(32) COMMENT 'Deprecated', MODIFY `rendered-html` mediumtext COMMENT 'Deprecated', ADD INDEX `icid` (`icid`), ADD INDEX `iaid` (`iaid`), ADD INDEX `psid_wall` (`psid`,`wall`), COMMENT = 'Structure for all posts';

####

sudo -u 'www-data' ./bin/console.php dbstructure update


####

sudo -u 'www-data' ./bin/console.php postupdate
Execute pending post updates.

All pending post updates are done.
@Alkarex

This comment has been minimized.

Alkarex commented Aug 28, 2018

Latest Friendica logs (warning level):

2018-08-28T11:00:22Z@log5b852b46e73561.85892451	[NORMAL]:api.php:306:api_call	API parameters: Array
(
    [pagename] => api/statusnet/version.json
)

2018-08-28T11:00:23Z@log5b852b4704e507.91610208	[NORMAL]:api.php:305:api_call	API call for : api/statusnet/config.json
2018-08-28T11:00:23Z@log5b852b4704e507.91610208	[NORMAL]:api.php:306:api_call	API parameters: Array
(
    [pagename] => api/statusnet/config.json
)

2018-08-28T11:00:26Z@wrk5b852b348175d6.87916405	[NORMAL]:DiscoverPoCo.php:191:discoverUsers	Check profile https://aus.social/@ryan
2018-08-28T11:00:26Z@wrk5b852b348175d6.87916405	[NORMAL]:DiscoverPoCo.php:191:discoverUsers	Check profile https://loma.ml/profile/horald
2018-08-28T11:00:28Z@log5b852b35e6e248.00471109	[NORMAL]:Worker.php:388:execFunction	Process 24367 - Prio 40 - ID 1243645: CronJobs - done in 21.218 seconds. Process PID: wrk5b852b374b6c56.54727338
2018-08-28T11:00:28Z@log5b852b35e6e248.00471109	[NORMAL]:Worker.php:318:execFunction	Process 24367 - Prio 40 - ID 1243653: DiscoverPoCo ["DiscoverPoCo","check_profile","https:\/\/framapiaf.org\/@nooe"] - Process PID: wrk5b852b4ca95d40.75412085
2018-08-28T11:00:28Z@wrk5b852b4ca95d40.75412085	[NORMAL]:DiscoverPoCo.php:58:execute	start 
2018-08-28T11:00:31Z@wrk5b852b4ca95d40.75412085	[NORMAL]:DiscoverPoCo.php:109:execute	end 
2018-08-28T11:00:31Z@log5b852b35e6e248.00471109	[NORMAL]:Worker.php:388:execFunction	Process 24367 - Prio 40 - ID 1243653: DiscoverPoCo - done in 2.615 seconds. Process PID: wrk5b852b4ca95d40.75412085
2018-08-28T11:00:31Z@log5b852b35e6e248.00471109	[NORMAL]:Worker.php:318:execFunction	Process 24367 - Prio 40 - ID 1243654: DiscoverPoCo ["DiscoverPoCo","check_profile","https:\/\/joindiaspora.com\/u\/haraldk"] - Process PID: wrk5b852b4f908c76.34593408
2018-08-28T11:00:31Z@wrk5b852b4f908c76.34593408	[NORMAL]:DiscoverPoCo.php:58:execute	start 
2018-08-28T11:00:33Z@wrk5b852b348175d6.87916405	[NORMAL]:DiscoverPoCo.php:191:discoverUsers	Check profile https://friendica.hasecom.at/profile/gerhard
2018-08-28T11:00:33Z@wrk5b852b348175d6.87916405	[NORMAL]:DiscoverPoCo.php:109:execute	end 
2018-08-28T11:00:33Z@log5b852b338209c8.38555277	[NORMAL]:Worker.php:388:execFunction	Process 24335 - Prio 40 - ID 1243641: DiscoverPoCo - done in 29.169 seconds. Process PID: wrk5b852b348175d6.87916405
2018-08-28T11:00:34Z@log5b852b338209c8.38555277	[NORMAL]:Worker.php:318:execFunction	Process 24335 - Prio 40 - ID 1243655: DiscoverPoCo ["DiscoverPoCo","check_profile","https:\/\/aus.social\/@ryan"] - Process PID: wrk5b852b5205f120.19432529
2018-08-28T11:00:34Z@wrk5b852b5205f120.19432529	[NORMAL]:DiscoverPoCo.php:58:execute	start 
2018-08-28T11:00:42Z@wrk5b852b4f908c76.34593408	[NORMAL]:DiscoverPoCo.php:109:execute	end 
2018-08-28T11:00:42Z@log5b852b35e6e248.00471109	[NORMAL]:Worker.php:388:execFunction	Process 24367 - Prio 40 - ID 1243654: DiscoverPoCo - done in 10.749 seconds. Process PID: wrk5b852b4f908c76.34593408
2018-08-28T11:00:42Z@log5b852b35e6e248.00471109	[NORMAL]:Worker.php:318:execFunction	Process 24367 - Prio 40 - ID 1243656: DiscoverPoCo ["DiscoverPoCo","check_profile","https:\/\/loma.ml\/profile\/horald"] - Process PID: wrk5b852b5a8cb636.81301910
2018-08-28T11:00:42Z@wrk5b852b5a8cb636.81301910	[NORMAL]:DiscoverPoCo.php:58:execute	start 
2018-08-28T11:00:52Z@wrk5b852b42901ab1.31738644	[NORMAL]:DiscoverPoCo.php:109:execute	end 
2018-08-28T11:00:52Z@log5b852b38425559.85595448	[NORMAL]:Worker.php:388:execFunction	Process 24396 - Prio 40 - ID 1243652: DiscoverPoCo - done in 34.339 seconds. Process PID: wrk5b852b42901ab1.31738644
2018-08-28T11:00:53Z@wrk5b852b5205f120.19432529	[NORMAL]:DiscoverPoCo.php:109:execute	end 
2018-08-28T11:00:53Z@log5b852b338209c8.38555277	[NORMAL]:Worker.php:388:execFunction	Process 24335 - Prio 40 - ID 1243655: DiscoverPoCo - done in 19.097 seconds. Process PID: wrk5b852b5205f120.19432529
2018-08-28T11:00:53Z@log5b852b38425559.85595448	[NORMAL]:Worker.php:318:execFunction	Process 24396 - Prio 40 - ID 1243657: DiscoverPoCo ["DiscoverPoCo","check_profile","https:\/\/friendica.hasecom.at\/profile\/gerhard"] - Process PID: wrk5b852b651e64a8.63621250
2018-08-28T11:00:53Z@wrk5b852b651e64a8.63621250	[NORMAL]:DiscoverPoCo.php:58:execute	start 
2018-08-28T11:00:53Z@log5b852b338209c8.38555277	[NORMAL]:Worker.php:318:execFunction	Process 24335 - Prio 40 - ID 1243658: GProbe ["GProbe","https:\/\/aus.social\/@ryan"] - Process PID: wrk5b852b654bc6e4.49015841
2018-08-28T11:00:58Z@wrk5b852b651e64a8.63621250	[NORMAL]:DiscoverPoCo.php:109:execute	end 
2018-08-28T11:00:58Z@log5b852b38425559.85595448	[NORMAL]:Worker.php:388:execFunction	Process 24396 - Prio 40 - ID 1243657: DiscoverPoCo - done in 5.116 seconds. Process PID: wrk5b852b651e64a8.63621250
2018-08-28T11:01:10Z@wrk5b852b5a8cb636.81301910	[NORMAL]:DiscoverPoCo.php:109:execute	end 
2018-08-28T11:01:10Z@log5b852b35e6e248.00471109	[NORMAL]:Worker.php:388:execFunction	Process 24367 - Prio 40 - ID 1243656: DiscoverPoCo - done in 27.784 seconds. Process PID: wrk5b852b5a8cb636.81301910
2018-08-28T11:01:11Z@log5b852b338209c8.38555277	[NORMAL]:Worker.php:388:execFunction	Process 24335 - Prio 40 - ID 1243658: GProbe - done in 18.512 seconds. Process PID: wrk5b852b654bc6e4.49015841
2018-08-28T11:04:12Z@log5b852c2c430270.24932852	[NORMAL]:pubsub.php:89:pubsub_post	Feed arrived from 94.130.181.153 for pubsub/alkarex/2425 with user-agent: http.rb/3.2.0 (Mastodon/2.4.4; +https://diaspodon.fr/)
2018-08-28T11:04:12Z@log5b852c2c430270.24932852	[NORMAL]:pubsub.php:127:pubsub_post	Import item for alkarex from dada (2425)
2018-08-28T11:04:13Z@log5b852c2c430270.24932852	[NORMAL]:Item.php:831:insert	created item 294855
2018-08-28T11:04:13Z@log5b852c2c430270.24932852	[NORMAL]:Item.php:831:insert	created item 294856
2018-08-28T11:04:13Z@log5b852c2c430270.24932852	[NORMAL]:OStatus.php:518:process	Item with uri https://diaspodon.fr/users/dada/statuses/100627529843892115 for user 1 stored. Return value: 294855
2018-08-28T11:07:45Z@log5b852d0185abc4.74125607	[NORMAL]:api.php:409:api_call	API call not implemented: api/v1/instance
2018-08-28T11:07:45Z@log5b852d01a1b647.36609116	[NORMAL]:api.php:409:api_call	API call not implemented: api/v1/instance
2018-08-28T11:10:02Z@log5b852d898307e0.28577853	[NORMAL]:Worker.php:318:execFunction	Process 25701 - Prio 20 - ID 1243659: SpoolPost ["SpoolPost"] - Process PID: wrk5b852d8a0556c4.58936824
2018-08-28T11:10:02Z@log5b852d898307e0.28577853	[NORMAL]:Worker.php:388:execFunction	Process 25701 - Prio 20 - ID 1243659: SpoolPost - done in 0.012 seconds. Process PID: wrk5b852d8a0556c4.58936824
2018-08-28T11:10:02Z@log5b852d898307e0.28577853	[NORMAL]:Worker.php:318:execFunction	Process 25701 - Prio 30 - ID 1243660: Cron ["Cron"] - Process PID: wrk5b852d8a321d44.08467647
2018-08-28T11:10:02Z@wrk5b852d8a321d44.08467647	[NORMAL]:Cron.php:36:execute	cron intervall not reached
2018-08-28T11:10:02Z@log5b852d898307e0.28577853	[NORMAL]:Worker.php:388:execFunction	Process 25701 - Prio 30 - ID 1243660: Cron - done in 0.003 seconds. Process PID: wrk5b852d8a321d44.08467647
2018-08-28T11:10:38Z@log5b852dae659a23.58116270	[NORMAL]:pubsub.php:89:pubsub_post	Feed arrived from 94.130.181.153 for pubsub/alkarex/2425 with user-agent: http.rb/3.2.0 (Mastodon/2.4.4; +https://diaspodon.fr/)
2018-08-28T11:10:38Z@log5b852dae659a23.58116270	[NORMAL]:pubsub.php:127:pubsub_post	Import item for alkarex from dada (2425)
2018-08-28T11:10:41Z@log5b852dae659a23.58116270	[NORMAL]:Item.php:831:insert	created item 294857
2018-08-28T11:10:41Z@log5b852dae659a23.58116270	[NORMAL]:Item.php:831:insert	created item 294858
2018-08-28T11:10:41Z@log5b852dae659a23.58116270	[NORMAL]:OStatus.php:518:process	Item with uri https://hostux.social/users/xakan/statuses/100627538770619172 for user 1 stored. Return value: 294857
2018-08-28T11:10:41Z@log5b852dae659a23.58116270	[NORMAL]:Item.php:831:insert	created item 294859
2018-08-28T11:10:41Z@log5b852dae659a23.58116270	[NORMAL]:Item.php:831:insert	created item 294860
2018-08-28T11:10:41Z@log5b852dae659a23.58116270	[NORMAL]:OStatus.php:518:process	Item with uri https://diaspodon.fr/users/dada/statuses/100627555159657690 for user 1 stored. Return value: 294859
@Alkarex

This comment has been minimized.

Alkarex commented Aug 28, 2018

It looks like the text of the items is still in the DB, but for some reason not shown. Help appreciated.

https://f.a80.fr/display/bda90b95485b8294088a27d485893202

mysql> select * from `item` where `guid` = 'bda90b95485b8294088a27d485893202';
+--------+----------------------------------+--------------------------------------------------------+-----+------------+-------------+--------+------+---------+--------+--------------------------------------------------------+-------+--------------------------------------------------------+---------------------+---------------------+---------------------+---------------------+---------------------+----------+------------+----------------------------------+-----------------------------------------------------------------------------+-----------+-------------+----------------------------------+-----------------------------------------------------------------------------+------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-----------------------------------------+---------------------------------------------+--------+-------------+--------+----------+-----------------------------------------------------------+-------------+----------+-------------------------------------------------------------------+--------+--------+------+----------+-------+-----------+-----------+----------+----------+---------+---------+-----------+---------+------+---------+----------+--------+---------+--------+------------+------------+---------+---------+----------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+-----------------+--------+------------------------------------------+---------------+---------------+------+------+-----------+------+
| id     | guid                             | uri                                                    | uid | contact-id | gcontact-id | type   | wall | gravity | parent | parent-uri                                             | extid | thr-parent                                             | created             | edited              | commented           | received            | changed             | owner-id | owner-name | owner-link                       | owner-avatar                                                                | author-id | author-name | author-link                      | author-avatar                                                               | title                                          | body                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      | app  | verb                                    | object-type                                 | object | target-type | target | postopts | plink                                                     | resource-id | event-id | tag                                                               | attach | inform | file | location | coord | allow_cid | allow_gid | deny_cid | deny_gid | private | pubmail | moderated | visible | spam | starred | bookmark | unseen | deleted | origin | forum_mode | last-child | mention | network | rendered-hash                    | rendered-html                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | global | content-warning | uri-id | uri-hash                                 | parent-uri-id | thr-parent-id | icid | iaid | post-type | psid |
+--------+----------------------------------+--------------------------------------------------------+-----+------------+-------------+--------+------+---------+--------+--------------------------------------------------------+-------+--------------------------------------------------------+---------------------+---------------------+---------------------+---------------------+---------------------+----------+------------+----------------------------------+-----------------------------------------------------------------------------+-----------+-------------+----------------------------------+-----------------------------------------------------------------------------+------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-----------------------------------------+---------------------------------------------+--------+-------------+--------+----------+-----------------------------------------------------------+-------------+----------+-------------------------------------------------------------------+--------+--------+------+----------+-------+-----------+-----------+----------+----------+---------+---------+-----------+---------+------+---------+----------+--------+---------+--------+------------+------------+---------+---------+----------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+-----------------+--------+------------------------------------------+---------------+---------------+------+------+-----------+------+
| 292354 | bda90b95485b8294088a27d485893202 | urn:X-dfrn:f.a80.fr:1:bda90b95485b8294088a27d485893202 |   1 |          1 |           0 | wall   |    1 |       0 | 292354 | urn:X-dfrn:f.a80.fr:1:bda90b95485b8294088a27d485893202 |       | urn:X-dfrn:f.a80.fr:1:bda90b95485b8294088a27d485893202 | 2018-08-26 11:50:32 | 2018-08-26 11:50:32 | 2018-08-28 04:20:29 | 2018-08-26 11:50:32 | 2018-08-28 04:20:29 |        5 | Alkarex    | https://f.a80.fr/profile/alkarex | https://f.a80.fr/photo/18702223465afdc85448102778805617-5.jpg?ts=1535194258 |         5 | Alkarex     | https://f.a80.fr/profile/alkarex | https://f.a80.fr/photo/18702223465afdc85448102778805617-5.jpg?ts=1535194258 | Episodes 18-19-20 of Pepper & Carrot in Danish | My daughter's translation of #[url=https://f.a80.fr/search?tag=peppercarrot]peppercarrot[/url] from French to Danish is progressing well, and 3 new episodes (18, 19, 20) are now available. We are only 6 episodes in late :-)

[attachment type='link' url='https://www.peppercarrot.com/da/article383/episode-19-pollution' title='Episode 19: Forurening' image='https://www.peppercarrot.com/0_sources/ep19_Pollution/low-res/da_Pepper-and-Carrot_by-David-Revoy_E19.jpg']Pepper&amp;Carrot - Episode 19: Forurening[/attachment] |      | http://activitystrea.ms/schema/1.0/post | http://activitystrea.ms/schema/1.0/bookmark | NULL   |             | NULL   | NULL     | https://f.a80.fr/display/bda90b95485b8294088a27d485893202 |             |        0 | #[url=https://f.a80.fr/search?tag=peppercarrot]peppercarrot[/url] |        | NULL   | NULL |          |       | NULL      | NULL      | NULL     | NULL     |       0 |       0 |         0 |       1 |    0 |       0 |        1 |      0 |       0 |      1 |          0 |          1 |       0 | dfrn    | 0d4aee13f12cf3374b4be7be4bd72bd3 | My daughter's translation of #<a href="https://f.a80.fr/search?tag=peppercarrot" class="tag" title="peppercarrot">peppercarrot</a> from French to Danish is progressing well, and 3 new episodes (18, 19, 20) are now available. We are only 6 episodes in late <img class="smiley" src="https://f.a80.fr/images/smiley-smile.gif" alt=":-)" title=":-)" /> <div class="type-link"><a href="https://www.peppercarrot.com/da/article383/episode-19-pollution" target="_blank"><img src="https://f.a80.fr/proxy/37/aHR0cHM6Ly93d3cucGVwcGVyY2Fycm90LmNvbS8wX3NvdXJjZXMvZXAxOV9Qb2xsdXRpb24vbG93LXJlcy9kYV9QZXBwZXItYW5kLUNhcnJvdF9ieS1EYXZpZC1SZXZveV9FMTkuanBn.jpg" alt="" title="Episode 19: Forurening" class="attachment-image"></a><br><h4><a href="https://www.peppercarrot.com/da/article383/episode-19-pollution">Episode 19: Forurening</a></h4><blockquote>Pepper&amp;Carrot - Episode 19: Forurening</blockquote><sup><a href="https://www.peppercarrot.com/da/article383/episode-19-pollution">www.peppercarrot.com</a></sup></div> |      1 |                 |   NULL | 1535277070efb503305f76b8bc0b90754b45a795 |          NULL |          NULL |   65 | NULL |         0 | NULL |
| 292355 | bda90b95485b8294088a27d485893202 | urn:X-dfrn:f.a80.fr:1:bda90b95485b8294088a27d485893202 |   0 |          5 |           0 | remote |    0 |       0 | 292355 | urn:X-dfrn:f.a80.fr:1:bda90b95485b8294088a27d485893202 |       | urn:X-dfrn:f.a80.fr:1:bda90b95485b8294088a27d485893202 | 2018-08-26 11:50:32 | 2018-08-26 11:50:32 | 2018-08-28 04:20:28 | 2018-08-26 11:50:32 | 2018-08-28 04:20:28 |        5 | Alkarex    | https://f.a80.fr/profile/alkarex | https://f.a80.fr/photo/18702223465afdc85448102778805617-5.jpg?ts=1535194258 |         5 | Alkarex     | https://f.a80.fr/profile/alkarex | https://f.a80.fr/photo/18702223465afdc85448102778805617-5.jpg?ts=1535194258 | Episodes 18-19-20 of Pepper & Carrot in Danish | My daughter's translation of #[url=https://f.a80.fr/search?tag=peppercarrot]peppercarrot[/url] from French to Danish is progressing well, and 3 new episodes (18, 19, 20) are now available. We are only 6 episodes in late :-)

[attachment type='link' url='https://www.peppercarrot.com/da/article383/episode-19-pollution' title='Episode 19: Forurening' image='https://www.peppercarrot.com/0_sources/ep19_Pollution/low-res/da_Pepper-and-Carrot_by-David-Revoy_E19.jpg']Pepper&amp;Carrot - Episode 19: Forurening[/attachment] |      | http://activitystrea.ms/schema/1.0/post | http://activitystrea.ms/schema/1.0/bookmark | NULL   |             | NULL   | NULL     | https://f.a80.fr/display/bda90b95485b8294088a27d485893202 |             |        0 | #[url=https://f.a80.fr/search?tag=peppercarrot]peppercarrot[/url] |        | NULL   | NULL |          |       | NULL      | NULL      | NULL     | NULL     |       0 |       0 |         0 |       1 |    0 |       0 |        1 |      1 |       0 |      0 |          0 |          1 |       0 | dfrn    | 0d4aee13f12cf3374b4be7be4bd72bd3 | My daughter's translation of #<a href="https://f.a80.fr/search?tag=peppercarrot" class="tag" title="peppercarrot">peppercarrot</a> from French to Danish is progressing well, and 3 new episodes (18, 19, 20) are now available. We are only 6 episodes in late <img class="smiley" src="https://f.a80.fr/images/smiley-smile.gif" alt=":-)" title=":-)" /> <div class="type-link"><a href="https://www.peppercarrot.com/da/article383/episode-19-pollution" target="_blank"><img src="https://f.a80.fr/proxy/37/aHR0cHM6Ly93d3cucGVwcGVyY2Fycm90LmNvbS8wX3NvdXJjZXMvZXAxOV9Qb2xsdXRpb24vbG93LXJlcy9kYV9QZXBwZXItYW5kLUNhcnJvdF9ieS1EYXZpZC1SZXZveV9FMTkuanBn.jpg" alt="" title="Episode 19: Forurening" class="attachment-image"></a><br><h4><a href="https://www.peppercarrot.com/da/article383/episode-19-pollution">Episode 19: Forurening</a></h4><blockquote>Pepper&amp;Carrot - Episode 19: Forurening</blockquote><sup><a href="https://www.peppercarrot.com/da/article383/episode-19-pollution">www.peppercarrot.com</a></sup></div> |      1 |                 |   NULL | 1535277070efb503305f76b8bc0b90754b45a795 |          NULL |          NULL |   65 | NULL |         0 | NULL |
+--------+----------------------------------+--------------------------------------------------------+-----+------------+-------------+--------+------+---------+--------+--------------------------------------------------------+-------+--------------------------------------------------------+---------------------+---------------------+---------------------+---------------------+---------------------+----------+------------+----------------------------------+-----------------------------------------------------------------------------+-----------+-------------+----------------------------------+-----------------------------------------------------------------------------+------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-----------------------------------------+---------------------------------------------+--------+-------------+--------+----------+-----------------------------------------------------------+-------------+----------+-------------------------------------------------------------------+--------+--------+------+----------+-------+-----------+-----------+----------+----------+---------+---------+-----------+---------+------+---------+----------+--------+---------+--------+------------+------------+---------+---------+----------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+-----------------+--------+------------------------------------------+---------------+---------------+------+------+-----------+------+
2 rows in set (0.00 sec)
@Alkarex

This comment has been minimized.

Alkarex commented Aug 28, 2018

Ah, I can see item.body is deprecated. It looks like item-content.body is its replacement, but the data was not copied there.

select * from `item-content` where id = 65;
+----+------+--------+------------------------------------------+-------+-----------------+------+----------+-------+----------+-----+----------------------------------+---------------+-------------+--------+-------------+--------+-------+------+
| id | uri  | uri-id | uri-plink-hash                           | title | content-warning | body | location | coord | language | app | rendered-hash                    | rendered-html | object-type | object | target-type | target | plink | verb |
+----+------+--------+------------------------------------------+-------+-----------------+------+----------+-------+----------+-----+----------------------------------+---------------+-------------+--------+-------------+--------+-------+------+
| 65 | NULL |   NULL | 1535277070efb503305f76b8bc0b90754b45a795 |       |                 | NULL |          |       | NULL     |     | d41d8cd98f00b204e9800998ecf8427e |               |             | NULL   |             | NULL   |       |      |
+----+------+--------+------------------------------------------+-------+-----------------+------+----------+-------+----------+-----+----------------------------------+---------------+-------------+--------+-------------+--------+-------+------+
1 row in set (0.00 sec)
@Alkarex

This comment has been minimized.

Alkarex commented Aug 28, 2018

The commands below repaired my wall. Other posts and comments are still broken though. I cannot immediately see if item-content.title and item-content.body should be HTML-encoded compared to the original values in the item table.

UPDATE `item-content` itc, `item` it
SET itc.title = it.title
WHERE itc.id = it.icid
AND (it.title != '' AND it.title IS NOT NULL) AND (itc.title IS NULL OR itc.title = '')
AND it.wall = 1 AND it.`owner-name` = 'Alkarex';

UPDATE `item-content` itc, `item` it
SET itc.body = it.body
WHERE itc.id = it.icid
AND (it.body != '' AND it.body IS NOT NULL) AND (itc.body IS NULL OR itc.body = '')
AND it.wall = 1 AND it.`owner-name` = 'Alkarex';

The next step would be to try the same commands without the filters (AND it.wall = 1 AND it.owner-name = 'Alkarex') but I hope someone can provide a better procedure.

SELECT COUNT(*) FROM `item-content` itc, `item` it WHERE itc.id = it.icid AND (it.body != '' AND it.body IS NOT NULL) AND (itc.body IS NULL OR itc.body = '');
+----------+
| COUNT(*) |
+----------+
|      793 |
+----------+
1 row in set (3.62 sec)

@tobiasd tobiasd added this to the 2018.08 milestone Aug 28, 2018

@annando

This comment has been minimized.

Collaborator

annando commented Aug 28, 2018

Please execute this command in your mysql console:
update config set v=1278 where k="post_update_version";

After this please execute the command bin/console postupdate

This should last for some time (hours).

@Alkarex

This comment has been minimized.

Alkarex commented Aug 29, 2018

@annando Thanks, this seems to have fixed the problems, indeed after leaving it working for the night.
Maybe those instructions could be added to the blog post, along with a warning about the minimal size of innodb_online_alter_log_max_size (in my case, it was the default value, which was not enough).

@Alkarex Alkarex closed this Aug 29, 2018

@annando

This comment has been minimized.

Collaborator

annando commented Aug 29, 2018

Question is what index exactly created the problem on your side. Do you know this? Then we possibly could reduce the size. I will add some command to reset the post update value. But also yesterday I added some coding that should prevent your yesterday problems.

@Alkarex

This comment has been minimized.

Alkarex commented Aug 29, 2018

See #5687 (comment) , the first instance of the problem seems to have been from one of these:

ALTER TABLE `item` ... ADD INDEX `icid` (`icid`), ADD INDEX `iaid` (`iaid`), ADD INDEX `psid_wall` (`psid`,`wall`),`
@annando

This comment has been minimized.

Collaborator

annando commented Aug 29, 2018

Weird enough these hadn't been large indexes.

@tobiasd

This comment has been minimized.

Collaborator

tobiasd commented Aug 29, 2018

I've updated the announcement with this problem. Thanks for testing and using MySQL!

@annando

This comment has been minimized.

Collaborator

annando commented Aug 29, 2018

@tobiasd Please have a look at the PR #5692

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment