utzer [Friendica]

3 years ago from Fediverse •

utzer [Friendica]
3 years ago from Fediverse •

I files a #MariaDB bug, hat happens on my #Friendica server. Didn't really beliefe it is a bug in MariaDB, but there is a first comment seeming to be positive about my filed bug.

See here: https://jira.mariadb.org/browse/MDEV-25031

Anyone else having this problem?

!Friendica Support

Roland Häder likes this.

Friendica Support reshared this.

utzer [Friendica]

3 years ago from Fediverse •

@Michael Vogel so I should look into switching it maybe...

@Michael Vogel

utzer [Friendica]

3 years ago from Fediverse •

@Michael Vogel I think I never ran this, as the setup it quite new and was innodb from the the start. You think I can run it to have it just do that conversion to dynamic? What if this crashes?

@Michael Vogel

utzer [Friendica]

3 years ago from Fediverse •

@Michael Vogel yeah, doing a dump now, should be finished in a minute.

@Michael Vogel

utzer [Friendica]

3 years ago from Fediverse •

@Michael Vogel got to redo the backup as there was packet bigger than 67 MB, which was the allowed maximum size, maybe that setting was bigger before.

@Michael Vogel

utzer [Friendica]

3 years ago from Fediverse •

@Michael Vogel ok, something is still wrong.

I get this:

mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' when dumping table `storage` at row: 95922                  <=>                                                                                                            ]
mysqldump: Couldn't execute 'ROLLBACK TO SAVEPOINT sp': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SELECT engine, table_type FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = DATABASE() AND table_name = 'tag'': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEM
A`.`COLUMNS` WHERE TABLE_SCHEMA = 'ylms_friendica'

@Michael Vogel ok, something is still wrong.

I get this:

mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' when dumping table `storage` at row: 95922                  <=>                                                                                                            ]
mysqldump: Couldn't execute 'ROLLBACK TO SAVEPOINT sp': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SELECT engine, table_type FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = DATABASE() AND table_name = 'tag'': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEM
A`.`COLUMNS` WHERE TABLE_SCHEMA = 'ylms_friendica' AND TABLE_NAME = 'tag'': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'ROLLBACK TO SAVEPOINT sp': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SELECT engine, table_type FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = DATABASE() AND table_name = 'tag-search-view'': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'ylms_friendica' AND TABLE_NAME = 'tag-search-view'': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'ROLLBACK TO SAVEPOINT sp': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SELECT engine, table_type FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = DATABASE() AND table_name = 'tag-view'': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'ylms_friendica' AND TABLE_NAME = 'tag-view'': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'ylms_friendica' AND TABLE_NAME = 'tag-view'': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'ROLLBACK TO SAVEPOINT sp': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SELECT engine, table_type FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = DATABASE() AND table_name = 'tokens'': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'ylms_friendica' AND TABLE_NAME = 'tokens'': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'ROLLBACK TO SAVEPOINT sp': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SELECT engine, table_type FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = DATABASE() AND table_name = 'unique_contacts'': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'ylms_friendica' AND TABLE_NAME = 'unique_contacts'': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'ROLLBACK TO SAVEPOINT sp': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SELECT engine, table_type FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = DATABASE() AND table_name = 'user'': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'ylms_friendica' AND TABLE_NAME = 'user'': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'ROLLBACK TO SAVEPOINT sp': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SELECT engine, table_type FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = DATABASE() AND table_name = 'user-contact'': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'ylms_friendica' AND TABLE_NAME = 'user-contact'': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'ROLLBACK TO SAVEPOINT sp': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SELECT engine, table_type FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = DATABASE() AND table_name = 'userd'': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'ylms_friendica' AND TABLE_NAME = 'userd'': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'ROLLBACK TO SAVEPOINT sp': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SELECT engine, table_type FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = DATABASE() AND table_name = 'verb'': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'ylms_friendica' AND TABLE_NAME = 'verb'': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'ROLLBACK TO SAVEPOINT sp': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SELECT engine, table_type FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = DATABASE() AND table_name = 'worker-ipc'': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'ylms_friendica' AND TABLE_NAME = 'worker-ipc'': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'ROLLBACK TO SAVEPOINT sp': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SELECT engine, table_type FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = DATABASE() AND table_name = 'workerqueue'': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'ylms_friendica' AND TABLE_NAME = 'workerqueue'': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'ROLLBACK TO SAVEPOINT sp': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SELECT engine, table_type FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = DATABASE() AND table_name = 'workerqueue-view'': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'ylms_friendica' AND TABLE_NAME = 'workerqueue-view'': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'ROLLBACK TO SAVEPOINT sp': MySQL server has gone away (2006)
mysqldump: Couldn't execute 'RELEASE SAVEPOINT sp': MySQL server has gone away (2006)

when I run

mysqldump -qf --databases ylms_friendica --routines --single-transaction --skip-lock-tables |pv|pigz > ~/social.yl.ms_friendica.sql.gz

, can you tell me how to figure out the size of this packet in the first line?

@Michael Vogel

@Michael Vogel finally did, I think it is because of the dash, so the "-" breaks the syntax, but I changed it to back ticks.

Let's see what happens now, it converted all the tables listed, but that is not all tables... the worker-ipc, that I must not change, is not in that list. Not sure why at the moment.

@Michael Vogel

⇧