Skip to content
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

Database upgrade row size error on table piwik_log_visit #16959

Closed
hahayidu opened this issue Dec 15, 2020 · 1 comment
Closed

Database upgrade row size error on table piwik_log_visit #16959

hahayidu opened this issue Dec 15, 2020 · 1 comment
Labels
answered For when a question was asked and we referred to forum or answered it.

Comments

@hahayidu
Copy link

Hi,

When upgrade to > Matomo database will be upgraded from version 3.14.1 to the new version 4.0.5.

I've seen an error in error log [mariadb]

2020-12-15 2:31:19 344 [ERROR] InnoDB: Cannot add field custom_var_k4 in table piwik.piwik_log_visit because after adding it, the row size is 8671 which is greater than maximum allowed size (8126 bytes) for a record on index leaf page.

It is look like no problem with any visit record or reporting. core:update also successfully finished.

I'am not database expert but also I run following command for check db

mariadb-check piwik -c

It's show all table OK

MariaDB [(none)]> SELECT VERSION();
+---------------------------+
| VERSION()                 |
+---------------------------+
| 10.3.27-MariaDB-0+deb10u1 |
+---------------------------+

My version is not affected following bug.

https://jira.mariadb.org/browse/MDEV-19292

I wanted to avoid problems in the future and to share information if anyone is affected.

This my test environment I can share more information for future analysis.

Thanks in advance for your support.

@tsteur
Copy link
Member

tsteur commented Dec 16, 2020

@tsteur tsteur closed this as completed Dec 16, 2020
@tsteur tsteur added the answered For when a question was asked and we referred to forum or answered it. label Dec 16, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
answered For when a question was asked and we referred to forum or answered it.
Projects
None yet
Development

No branches or pull requests

2 participants