Announcement

#1 2014-04-20 22:32:25

piwiLaborer
Member
2013-07-30
33

after upgrade (hangs), table piwigo_config is hosed and not repairable

Hello/Hi/Greetings,

After auto upgrade to latest, piwigo fails totally.

Auto-Upgrade from piwigo does not give  completion message and seems to hang.

Redo with piwigo-netinstall.php, issue is same, there is no completion message either and:

on web, accessing piwigo:

Warning:  [mysql error 144] Table './Piwigo/piwigo_config' is marked as crashed and last (automatic?) repair failed

SELECT param, value
FROM piwigo_config

; in ..../htdocs/pics/include/dblayer/functions_mysqli.inc.php on line 798


Notice: Trying to get property of non-object in .../htdocs/pics/include/dblayer/functions_mysqli.inc.php on line 171

Fatal error: Call to a member function fetch_assoc() on a non-object in ..../htdocs/pics/include/dblayer/functions_mysqli.inc.php on line 181

---------
trying to fix table in mysql:

mysql> repair table piwigo_config ;
+----------------------+--------+----------+-------------------------------------------------------------------------------------------+
| Table                | Op     | Msg_type | Msg_text                                                                                  |
+----------------------+--------+----------+-------------------------------------------------------------------------------------------+
| Piwigo.piwigo_config | repair | error    | 1 when fixing table                                                                       |
| Piwigo.piwigo_config | repair | Error    | Can't change ownership of the file '/var/lib/mysql/Piwigo/piwigo_config.MYD' (Errcode: 1) |
| Piwigo.piwigo_config | repair | status   | Operation failed                                                                          |
+----------------------+--------+----------+-------------------------------------------------------------------------------------------+

--------

checking permissions:

# l /var/lib/mysql/Piwigo/piwigo_config.MYD
-rw-rw---- 1 mysql mysql 7472 Apr 20 09:48 /var/lib/mysql/Piwigo/piwigo_config.MYD

current and parent:

l -a /var/lib/mysql/Piwigo | head
total 48488
drwx------ 2 mysql mysql     8192 Apr 20 09:48 .
drwx------ 8 mysql mysql     4096 Apr 17 11:18 ..
-rw-rw---- 1 mysql mysql       65 Jul 29  2013 db.opt
-rw-rw---- 1 mysql mysql     8608 Jul 29  2013 piwigo_caddie.frm

Any ideas how to get this fxed?


Piwigo version: 2.6.2 in upgrade mode
PHP version: 5.5.5-1
MySQL version: Ver 14.14
Piwigo URL: http://samartha.net/pics

Offline

 

#2 2014-04-21 09:46:28

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13573

Re: after upgrade (hangs), table piwigo_config is hosed and not repairable

Hi piwiLaborer,

This is the first time I see this MySQL error (it does not seem to be related to Piwigo actually).

Try to drop the table then restore it from your last backup. If you don't have any backup, you can use install/config.sql

Offline

 

#3 2014-04-21 14:43:23

piwiLaborer
Member
2013-07-30
33

Re: after upgrade (hangs), table piwigo_config is hosed and not repairable

Hello plg,

I'll have to look how to go about it, I don't habe much time right now....

What's interesting though on first look at the Piwigo mysql files after this failed upgrade is the group permissions.

On last full backup on April 1, there were only 6 files with ftp group permissions:

-rw-rw---- 1 mysql ftp    13290 Mar  2 19:55 piwigo_categories.frm
-rw-rw---- 1 mysql ftp     6576 Mar 27 21:16 piwigo_categories.MYD
-rw-rw---- 1 mysql ftp     4096 Mar 27 21:16 piwigo_categories.MYI
-rw-rw---- 1 mysql ftp     8977 Mar  2 19:55 piwigo_community_permissions.frm
-rw-rw---- 1 mysql ftp       36 Mar  2 19:55 piwigo_community_permissions.MYD
-rw-rw---- 1 mysql ftp     2048 Mar  2 19:55 piwigo_community_permissions.MYI

and now it's 40, amongst those is also a piwigo_config.TMD:

:/var/lib/mysql/Piwigo# l | grep ftp
-rw-rw---- 1 mysql ftp          0 Apr 20 09:48 piwigo_caddie.TMD
-rw-rw---- 1 mysql ftp       6844 Apr 20 09:48 piwigo_categories.TMD
-rw-rw---- 1 mysql ftp          0 Apr 20 09:48 piwigo_comments.TMD
-rw-rw---- 1 mysql ftp        720 Apr 20 09:48 piwigo_community_pendings.TMD
-rw-rw---- 1 mysql ftp         36 Apr 20 09:48 piwigo_community_permissions.TMD
-rw-rw---- 1 mysql ftp       7468 Apr 20 13:56 piwigo_config.TMD
-rw-rw---- 1 mysql ftp          0 Apr 20 09:48 piwigo_favorites.TMD
-rw-rw---- 1 mysql ftp          0 Apr 20 09:48 piwigo_group_access.TMD
-rw-rw---- 1 mysql ftp         24 Apr 20 09:48 piwigo_groups.TMD
-rw-rw---- 1 mysql ftp          0 Apr 20 09:48 piwigo_history_summary.TMD
-rw-rw---- 1 mysql ftp    6232332 Apr 20 09:48 piwigo_history.TMD
-rw-rw---- 1 mysql ftp          0 Apr 20 09:48 piwigo_image_category.TMD
-rw-rw---- 1 mysql ftp      13582 Apr 20 09:48 piwigo_images.frm
-rw-rw---- 1 mysql ftp     147852 Apr 20 09:48 piwigo_images.MYD
-rw-rw---- 1 mysql ftp      76800 Apr 20 09:48 piwigo_images.MYI
-rw-rw---- 1 mysql ftp          0 Apr 20 09:48 piwigo_image_tag.TMD
-rw-rw---- 1 mysql ftp       2004 Apr 20 09:48 piwigo_languages.TMD
-rw-rw---- 1 mysql ftp          0 Apr 20 09:48 piwigo_old_permalinks.TMD
-rw-rw---- 1 mysql ftp        180 Apr 20 09:48 piwigo_plugins.TMD
-rw-rw---- 1 mysql ftp         24 Apr 20 09:48 piwigo_rate.TMD
-rw-rw---- 1 mysql ftp        252 Apr 20 09:48 piwigo_search.TMD
-rw-rw---- 1 mysql ftp       5180 Apr 20 09:48 piwigo_sessions.TMD
-rw-rw---- 1 mysql ftp         20 Apr 20 09:48 piwigo_sites.TMD
-rw-rw---- 1 mysql ftp          0 Apr 20 09:48 piwigo_tags.TMD
-rw-rw---- 1 mysql ftp        132 Apr 20 09:48 piwigo_themes.TMD
-rw-rw---- 1 mysql ftp       4272 Apr 20 13:03 piwigo_upgrade.TMD
-rw-rw---- 1 mysql ftp          0 Apr 20 09:48 piwigo_user_access.TMD
-rw-rw---- 1 mysql ftp       8958 Apr 20 09:48 piwigo_user_cache_categories.frm
-rw-rw---- 1 mysql ftp          0 Apr 20 09:48 piwigo_user_cache_categories.MYD
-rw-rw---- 1 mysql ftp       1024 Apr 20 09:48 piwigo_user_cache_categories.MYI
-rw-rw---- 1 mysql ftp       9089 Apr 20 09:48 piwigo_user_cache.frm
-rw-rw---- 1 mysql ftp          0 Apr 20 09:48 piwigo_user_cache.MYD
-rw-rw---- 1 mysql ftp       1024 Apr 20 09:48 piwigo_user_cache.MYI
-rw-rw---- 1 mysql ftp       1280 Apr 20 09:48 piwigo_user_feed.TMD
-rw-rw---- 1 mysql ftp          0 Apr 20 09:48 piwigo_user_group.TMD
-rw-rw---- 1 mysql ftp       9136 Apr 20 09:48 piwigo_user_infos.frm
-rw-rw---- 1 mysql ftp        396 Apr 20 09:48 piwigo_user_infos.MYD
-rw-rw---- 1 mysql ftp       2048 Apr 20 09:48 piwigo_user_infos.MYI
-rw-rw---- 1 mysql ftp         56 Apr 20 09:48 piwigo_user_mail_notification.TMD
-rw-rw---- 1 mysql ftp        684 Apr 20 09:48 piwigo_users.TMD

so - trying to:

# chgrp mysql piwigo_config.TMD

and

mysql> use Piwigo ;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> repair table piwigo_config ;
+----------------------+--------+----------+----------+
| Table                | Op     | Msg_type | Msg_text |
+----------------------+--------+----------+----------+
| Piwigo.piwigo_config | repair | status   | OK       |
+----------------------+--------+----------+----------+
1 row in set (0.00 sec)

which gives now on accessing over web:

Warning:  [mysql error 144] Table './Piwigo/piwigo_sessions' is marked as crashed and last (automatic?) repair failed

SELECT data
  FROM piwigo_sessions
  WHERE id = 'C0A8mgl6lqdbpjqls426up7271kmt2'
; in /mnt/c1d0p1/www/samartha/htdocs/pics/include/dblayer/functions_mysqli.inc.php on line 798

with more tables needing fixes.


So, changing all the ftp groups there to mysql groups:

/var/lib/mysql/Piwigo# for i in `l | grep ftp | awk '{print $9}'` ; do chgrp mysql $i; done

and try again  with piwigo_sessions which shows a whole lot of errors, like

| Piwigo.piwigo_sessions | repair | info     | Found block that points outside data file at 331                                                                                                                                                                                                                     10700                         |
| Piwigo.piwigo_sessions | repair | status   | OK   

and then OK but....

mysql> repair table piwigo_sessions;
+------------------------+--------+----------+---------------------------------------------------------------------------------------------+
| Table                  | Op     | Msg_type | Msg_text                                                                                    |
+------------------------+--------+----------+---------------------------------------------------------------------------------------------+
| Piwigo.piwigo_sessions | repair | error    | 1 when fixing table                                                                         |
| Piwigo.piwigo_sessions | repair | Error    | Can't change ownership of the file '/var/lib/mysql/Piwigo/piwigo_sessions.MYD' (Errcode: 1) |
| Piwigo.piwigo_sessions | repair | status   | Operation failed                                                                            |
+------------------------+--------+----------+---------------------------------------------------------------------------------------------+
3 rows in set (0.01 sec)


still not fixed...

Maybe this applies:

http://www.buildcube.com/tech_blog/2014 … errcode-1/

?

gotta run..

Offline

 

#4 2014-04-21 14:58:42

piwiLaborer
Member
2013-07-30
33

Re: after upgrade (hangs), table piwigo_config is hosed and not repairable

cont:

seems that

# l | grep ftp
-rw-rw---- 1 mysql ftp      5180 Apr 21 06:36 piwigo_sessions.TMD

happend...

so:


mysql> repair table piwigo_sessions;
+------------------------+--------+----------+----------+
| Table                  | Op     | Msg_type | Msg_text |
+------------------------+--------+----------+----------+
| Piwigo.piwigo_sessions | repair | status   | OK       |
+------------------------+--------+----------+----------+
1 row in set (0.00 sec)

and after that, doing all the tables showing crashed on web interface, one by one:

mysql> repair table piwigo_plugins ;
mysql> repair table piwigo_sessions;
mysql> repair table piwigo_sessions;
mysql> repair table piwigo_users ;
mysql> repair table piwigo_themes ;
mysql> repair table piwigo_categories ;
mysql> repair table piwigo_user_access;
mysql> repair table piwigo_user_group ;
mysql> repair table piwigo_group_access ;
mysql> repair table piwigo_image_category ;
mysql> repair table piwigo_image_tag ;
mysql> repair table piwigo_comments ;
mysql> repair table piwigo_languages ;


and it works again!

Why the ftp group permissions showed up may be a question to answer...

Offline

 

#5 2014-04-21 15:07:43

piwiLaborer
Member
2013-07-30
33

Re: after upgrade (hangs), table piwigo_config is hosed and not repairable

cont..
Still crashed tables lurking around - piwigo_tags was one.

Is there a script to run through all piwigo tables and fix them?

Offline

 

#6 2014-04-22 07:30:14

piwiLaborer
Member
2013-07-30
33

Re: after upgrade (hangs), table piwigo_config is hosed and not repairable

It's far from fixed. Going through some pictures brings up errors again and again.

So,

mysql> show tables ;
+-------------------------------+
| Tables_in_Piwigo              |
+-------------------------------+
| piwigo_caddie                 |
| piwigo_categories             |
| piwigo_comments               |
| piwigo_community_pendings     |
| piwigo_community_permissions  |
| piwigo_config                 |
| piwigo_favorites              |
| piwigo_group_access           |
| piwigo_groups                 |
| piwigo_history                |
| piwigo_history_summary        |
| piwigo_image_category         |
| piwigo_image_tag              |
| piwigo_images                 |
| piwigo_languages              |
| piwigo_old_permalinks         |
| piwigo_plugins                |
| piwigo_rate                   |
| piwigo_search                 |
| piwigo_sessions               |
| piwigo_sites                  |
| piwigo_tags                   |
| piwigo_themes                 |
| piwigo_upgrade                |
| piwigo_user_access            |
| piwigo_user_cache             |
| piwigo_user_cache_categories  |
| piwigo_user_feed              |
| piwigo_user_group             |
| piwigo_user_infos             |
| piwigo_user_mail_notification |
| piwigo_users                  |
+-------------------------------+
32 rows in set (0.00 sec)

Checking all tables:

# mysqlcheck -rp Piwigo
Enter password:

OK are 7:

Piwigo.piwigo_community_pendings                   OK
Piwigo.piwigo_community_permissions                OK
Piwigo.piwigo_old_permalinks                       OK
Piwigo.piwigo_search                               OK
Piwigo.piwigo_upgrade                              OK
Piwigo.piwigo_user_feed                            OK
Piwigo.piwigo_user_mail_notification               OK

All others (25) fail with Errcode 1

File permissions:

-rw-rw---- 1 mysql mysql 0 Apr 21 06:53 /var/lib/mysql/Piwigo/piwigo_comments.MYD
-rw-rw---- 1 mysql mysql 0 Apr 21 06:53 /var/lib/mysql/Piwigo/piwigo_image_tag.MYD
-rw-rw---- 1 mysql mysql 0 Apr 21 07:00 /var/lib/mysql/Piwigo/piwigo_tags.MYD
-rw-rw---- 1 mysql mysql 0 Apr 21 07:09 /var/lib/mysql/Piwigo/piwigo_caddie.MYD
-rw-rw---- 1 mysql mysql 0 Apr 21 21:45 /var/lib/mysql/Piwigo/piwigo_favorites.MYD
-rw-rw---- 1 mysql mysql 1008 Apr 21 06:51 /var/lib/mysql/Piwigo/piwigo_user_access.MYD
-rw-rw---- 1 mysql mysql 132 Apr 21 06:50 /var/lib/mysql/Piwigo/piwigo_themes.MYD
-rw-rw---- 1 mysql mysql 147852 Apr 21 21:46 /var/lib/mysql/Piwigo/piwigo_images.MYD
-rw-rw---- 1 mysql mysql 14 Apr 21 06:51 /var/lib/mysql/Piwigo/piwigo_user_group.MYD
-rw-rw---- 1 mysql mysql 180 Apr 21 07:10 /var/lib/mysql/Piwigo/piwigo_plugins.MYD
-rw-rw---- 1 mysql mysql 2004 Apr 21 06:54 /var/lib/mysql/Piwigo/piwigo_languages.MYD
-rw-rw---- 1 mysql mysql 20 Apr 21 07:10 /var/lib/mysql/Piwigo/piwigo_sites.MYD
-rw-rw---- 1 mysql mysql 24400 Apr 21 07:11 /var/lib/mysql/Piwigo/piwigo_history_summary.MYD
-rw-rw---- 1 mysql mysql 24 Apr 21 07:09 /var/lib/mysql/Piwigo/piwigo_groups.MYD
-rw-rw---- 1 mysql mysql 24 Apr 21 07:09 /var/lib/mysql/Piwigo/piwigo_rate.MYD
-rw-rw---- 1 mysql mysql 396 Apr 20 09:48 /var/lib/mysql/Piwigo/piwigo_user_infos.MYD
-rw-rw---- 1 mysql mysql 4356 Apr 21 21:46 /var/lib/mysql/Piwigo/piwigo_user_cache_categories.MYD
-rw-rw---- 1 mysql mysql 5508 Apr 21 21:47 /var/lib/mysql/Piwigo/piwigo_sessions.MYD
-rw-rw---- 1 mysql mysql 6232476 Apr 21 07:53 /var/lib/mysql/Piwigo/piwigo_history.MYD
-rw-rw---- 1 mysql mysql 6844 Apr 21 06:50 /var/lib/mysql/Piwigo/piwigo_categories.MYD
-rw-rw---- 1 mysql mysql 684 Apr 21 06:49 /var/lib/mysql/Piwigo/piwigo_users.MYD
-rw-rw---- 1 mysql mysql 7592 Apr 21 07:10 /var/lib/mysql/Piwigo/piwigo_config.MYD
-rw-rw---- 1 mysql mysql 760 Apr 21 07:51 /var/lib/mysql/Piwigo/piwigo_user_cache.MYD
-rw-rw---- 1 mysql mysql 8739 Apr 21 06:52 /var/lib/mysql/Piwigo/piwigo_image_category.MYD
-rw-rw---- 1 mysql mysql 91 Apr 21 06:52 /var/lib/mysql/Piwigo/piwigo_group_access.MYD

Another look again at permissions in the database directory:

/var/lib/mysql/Piwigo# l | grep ftp
-rw-rw---- 1 mysql ftp         0 Apr 21 21:59 piwigo_caddie.TMD
-rw-rw---- 1 mysql ftp      6844 Apr 21 21:59 piwigo_categories.TMD
-rw-rw---- 1 mysql ftp         0 Apr 21 21:59 piwigo_comments.TMD
-rw-rw---- 1 mysql ftp      7592 Apr 21 21:59 piwigo_config.TMD
-rw-rw---- 1 mysql ftp         0 Apr 21 21:59 piwigo_favorites.TMD
-rw-rw---- 1 mysql ftp         0 Apr 21 21:59 piwigo_group_access.TMD
-rw-rw---- 1 mysql ftp        24 Apr 21 21:59 piwigo_groups.TMD
-rw-rw---- 1 mysql ftp         0 Apr 21 21:59 piwigo_history_summary.TMD
-rw-rw---- 1 mysql ftp   6232476 Apr 21 21:59 piwigo_history.TMD
-rw-rw---- 1 mysql ftp         0 Apr 21 21:59 piwigo_image_category.TMD
-rw-rw---- 1 mysql ftp    147852 Apr 21 21:59 piwigo_images.TMD
-rw-rw---- 1 mysql ftp         0 Apr 21 21:59 piwigo_image_tag.TMD
-rw-rw---- 1 mysql ftp      2004 Apr 21 21:59 piwigo_languages.TMD
-rw-rw---- 1 mysql ftp       180 Apr 21 21:59 piwigo_plugins.TMD
-rw-rw---- 1 mysql ftp        24 Apr 21 21:59 piwigo_rate.TMD
-rw-rw---- 1 mysql ftp      2824 Apr 21 21:59 piwigo_sessions.TMD
-rw-rw---- 1 mysql ftp        20 Apr 21 21:59 piwigo_sites.TMD
-rw-rw---- 1 mysql ftp         0 Apr 21 21:59 piwigo_tags.TMD
-rw-rw---- 1 mysql ftp       132 Apr 21 21:59 piwigo_themes.TMD
-rw-rw---- 1 mysql ftp         0 Apr 21 21:59 piwigo_user_access.TMD
-rw-rw---- 1 mysql ftp         0 Apr 21 21:59 piwigo_user_cache_categories.TMD
-rw-rw---- 1 mysql ftp       760 Apr 21 21:59 piwigo_user_cache.TMD
-rw-rw---- 1 mysql ftp         0 Apr 21 21:59 piwigo_user_group.TMD
-rw-rw---- 1 mysql ftp       396 Apr 21 21:59 piwigo_user_infos.TMD
-rw-rw---- 1 mysql ftp       684 Apr 21 21:59 piwigo_users.TMD
root@wolpertinger:/var/lib/mysql/Piwigo# l | grep ftp | wc
     25     225    1668


So, change those back again:

/var/lib/mysql/Piwigo# for i in `l | grep ftp | awk '{print $9}'` ; do chgrp mysql $i; done

and run # mysqlcheck  again,

we get now

# grep OK  fixup-02.txt  | wc
     25      57    1070
# grep Errcode  fixup-02.txt  | wc
      7      77     762
# l | grep ftp
-rw-rw---- 1 mysql ftp       720 Apr 21 22:35 piwigo_community_pendings.TMD
-rw-rw---- 1 mysql ftp        36 Apr 21 22:35 piwigo_community_permissions.TMD
-rw-rw---- 1 mysql ftp         0 Apr 21 22:35 piwigo_old_permalinks.TMD
-rw-rw---- 1 mysql ftp       252 Apr 21 22:35 piwigo_search.TMD
-rw-rw---- 1 mysql ftp      4272 Apr 21 22:35 piwigo_upgrade.TMD
-rw-rw---- 1 mysql ftp      1280 Apr 21 22:35 piwigo_user_feed.TMD
-rw-rw---- 1 mysql ftp        56 Apr 21 22:35 piwigo_user_mail_notification.TMD

So, something is changing group permissions to ftp on the fly from 7 to 25 and 25 to 7... and it's only .TMD files

Who does that?

Offline

 

#7 2014-04-22 07:50:35

flop25
Piwigo Team
2006-07-06
7037

Re: after upgrade (hangs), table piwigo_config is hosed and not repairable

Hello
All of your issues relies on mysql and not Piwigo. You should check and ask on mysql specific forums


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#8 2014-04-22 08:19:29

piwiLaborer
Member
2013-07-30
33

Re: after upgrade (hangs), table piwigo_config is hosed and not repairable

I hightly question this. Piwigo was fine until the last upgrade then it got totally hosed. The only thing which caused change was this Piwigo auto-update over the web. There was no other update on that system.

I documented in the beginning what files with the old version had .ftp groups on April 1st with last FS backup. Now it's playing games like coming directly from hell.

You can think what you want. I'll keep playing with it as time allows. We'll see....

Offline

 

#9 2014-04-22 08:24:24

flop25
Piwigo Team
2006-07-06
7037

Re: after upgrade (hangs), table piwigo_config is hosed and not repairable

We thank you for sharing all that. That's just we can't help too much about that and having mysql 'specialist' opinion might be better for you


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#10 2014-10-10 22:30:58

piwiLaborer
Member
2013-07-30
33

Re: after upgrade (hangs), table piwigo_config is hosed and not repairable

Finally got around to fix this.


The ftp group switching back and forth thing was coming up in another database as well - mysql !

What eventually fixed it was this:

# /etc/init.d/mysql stop

/var/lib/mysql#  myisamchk -rf mysql/*.MYI

/var/lib/mysql#  myisamchk -rf Piwigo/*.MYI

# /etc/init.d/mysql start

and Piwigo was happy again.

I suspect, there must have been some weird corruption going on in the mysql database.

Offline

 

#11 2014-10-10 22:58:56

piwiLaborer
Member
2013-07-30
33

Re: after upgrade (hangs), table piwigo_config is hosed and not repairable

Short life of happyness!
Upgraded to 2.7 and....

Warning:  [mysql error 144] Table './Piwigo/piwigo_config' is marked as crashed and last (automatic?) repair failed

SELECT param, value
FROM piwigo_config

; in /mnt/c1d0p1/www/samartha/htdocs/pics/include/dblayer/functions_mysqli.inc.php on line 830


Notice: Trying to get property of non-object in /mnt/c1d0p1/www/samartha/htdocs/pics/include/dblayer/functions_mysqli.inc.php on line 201

Fatal error: Call to a member function fetch_assoc() on a non-object in /mnt/c1d0p1/www/samartha/htdocs/pics/include/dblayer/functions_mysqli.inc.php on line 211

The ftp group setting is back in full!

/var/lib/mysql/Piwigo# l | grep ftp
-rw-rw---- 1 mysql ftp      8608 Oct 10 14:37 piwigo_caddie.frm
-rw-rw---- 1 mysql ftp         0 Oct 10 14:37 piwigo_caddie.MYD
-rw-rw---- 1 mysql ftp      1024 Oct 10 14:37 piwigo_caddie.MYI
-rw-rw---- 1 mysql ftp     13336 Oct 10 14:37 piwigo_categories.frm
-rw-rw---- 1 mysql ftp      7188 Oct 10 14:37 piwigo_categories.MYD
-rw-rw---- 1 mysql ftp      5120 Oct 10 14:37 piwigo_categories.MYI
-rw-rw---- 1 mysql ftp      8961 Oct 10 14:37 piwigo_comments.frm
-rw-rw---- 1 mysql ftp         0 Oct 10 14:37 piwigo_comments.MYD
-rw-rw---- 1 mysql ftp      1024 Oct 10 14:37 piwigo_comments.MYI
-rw-rw---- 1 mysql ftp       720 Oct 10 14:37 piwigo_community_pendings.TMD
-rw-rw---- 1 mysql ftp        36 Oct 10 14:37 piwigo_community_permissions.TMD
-rw-rw---- 1 mysql ftp      7628 Oct 10 14:37 piwigo_config.TMD
-rw-rw---- 1 mysql ftp      8604 Oct 10 14:37 piwigo_favorites.frm
-rw-rw---- 1 mysql ftp         0 Oct 10 14:37 piwigo_favorites.MYD
-rw-rw---- 1 mysql ftp      1024 Oct 10 14:37 piwigo_favorites.MYI
-rw-rw---- 1 mysql ftp         0 Oct 10 14:37 piwigo_group_access.TMD
-rw-rw---- 1 mysql ftp      8687 Oct 10 14:36 piwigo_groups.frm
-rw-rw---- 1 mysql ftp        28 Oct 10 14:37 piwigo_groups.MYD
-rw-rw---- 1 mysql ftp     10240 Oct 10 14:37 piwigo_groups.MYI
-rw-rw---- 1 mysql ftp      9038 Oct 10 14:37 piwigo_history.frm
-rw-rw---- 1 mysql ftp   6384536 Oct 10 14:37 piwigo_history.MYD
-rw-rw---- 1 mysql ftp   3064832 Oct 10 14:37 piwigo_history.MYI
-rw-rw---- 1 mysql ftp         0 Oct 10 14:37 piwigo_history_summary.TMD
-rw-rw---- 1 mysql ftp         0 Oct 10 14:37 piwigo_image_category.TMD
-rw-rw---- 1 mysql ftp     13628 Oct 10 14:37 piwigo_images.frm
-rw-rw---- 1 mysql ftp    152628 Oct 10 14:37 piwigo_images.MYD
-rw-rw---- 1 mysql ftp     88064 Oct 10 14:37 piwigo_images.MYI
-rw-rw---- 1 mysql ftp         0 Oct 10 14:37 piwigo_image_tag.TMD
-rw-rw---- 1 mysql ftp      2004 Oct 10 14:37 piwigo_languages.TMD
-rw-rw---- 1 mysql ftp         0 Oct 10 14:37 piwigo_old_permalinks.TMD
-rw-rw---- 1 mysql ftp       200 Oct 10 14:37 piwigo_plugins.TMD
-rw-rw---- 1 mysql ftp      8714 Oct 10 14:37 piwigo_rate.frm
-rw-rw---- 1 mysql ftp        24 Oct 10 14:37 piwigo_rate.MYD
-rw-rw---- 1 mysql ftp      2048 Oct 10 14:37 piwigo_rate.MYI
-rw-rw---- 1 mysql ftp       252 Oct 10 14:37 piwigo_search.TMD
-rw-rw---- 1 mysql ftp       488 Oct 10 14:37 piwigo_sessions.TMD
-rw-rw---- 1 mysql ftp        20 Oct 10 14:37 piwigo_sites.TMD
-rw-rw---- 1 mysql ftp      8670 Oct 10 14:37 piwigo_tags.frm
-rw-rw---- 1 mysql ftp         0 Oct 10 14:37 piwigo_tags.MYD
-rw-rw---- 1 mysql ftp      4096 Oct 10 14:37 piwigo_tags.MYI
-rw-rw---- 1 mysql ftp       132 Oct 10 14:37 piwigo_themes.TMD
-rw-rw---- 1 mysql ftp      4732 Oct 10 14:37 piwigo_upgrade.TMD
-rw-rw---- 1 mysql ftp      8600 Oct 10 14:37 piwigo_user_access.frm
-rw-rw---- 1 mysql ftp      1008 Oct 10 14:37 piwigo_user_access.MYD
-rw-rw---- 1 mysql ftp      4096 Oct 10 14:37 piwigo_user_access.MYI
-rw-rw---- 1 mysql ftp      8958 Oct 10 14:37 piwigo_user_cache_categories.frm
-rw-rw---- 1 mysql ftp         0 Oct 10 14:37 piwigo_user_cache_categories.MYD
-rw-rw---- 1 mysql ftp      1024 Oct 10 14:37 piwigo_user_cache_categories.MYI
-rw-rw---- 1 mysql ftp      9089 Oct 10 14:37 piwigo_user_cache.frm
-rw-rw---- 1 mysql ftp         0 Oct 10 14:37 piwigo_user_cache.MYD
-rw-rw---- 1 mysql ftp      1024 Oct 10 14:37 piwigo_user_cache.MYI
-rw-rw---- 1 mysql ftp      8634 Oct 10 14:37 piwigo_user_feed.frm
-rw-rw---- 1 mysql ftp      1280 Oct 10 14:37 piwigo_user_feed.MYD
-rw-rw---- 1 mysql ftp      4096 Oct 10 14:37 piwigo_user_feed.MYI
-rw-rw---- 1 mysql ftp      8604 Oct 10 14:37 piwigo_user_group.frm
-rw-rw---- 1 mysql ftp        14 Oct 10 14:37 piwigo_user_group.MYD
-rw-rw---- 1 mysql ftp      2048 Oct 10 14:37 piwigo_user_group.MYI
-rw-rw---- 1 mysql ftp      9246 Oct 10 14:37 piwigo_user_infos.frm
-rw-rw---- 1 mysql ftp       436 Oct 10 14:37 piwigo_user_infos.MYD
-rw-rw---- 1 mysql ftp      3072 Oct 10 14:37 piwigo_user_infos.MYI
-rw-rw---- 1 mysql ftp      8695 Oct 10 14:37 piwigo_user_mail_notification.frm
-rw-rw---- 1 mysql ftp        56 Oct 10 14:37 piwigo_user_mail_notification.MYD
-rw-rw---- 1 mysql ftp      3072 Oct 10 14:37 piwigo_user_mail_notification.MYI
-rw-rw---- 1 mysql ftp      8678 Oct 10 14:37 piwigo_users.frm
-rw-rw---- 1 mysql ftp       696 Oct 10 14:37 piwigo_users.MYD
-rw-rw---- 1 mysql ftp      5120 Oct 10 14:37 piwigo_users.MYI

--------------------------------
We know the drill now:

# /etc/init.d/mysql stop
/var/lib/mysql# myisamchk -rf mysql/*.MYI
/var/lib/mysql# myisamchk -rf Piwigo/*.MYI
# /etc/init.d/mysql start

...and Piwigo database is happy again on upgraded Piwigo 2.7.0
l
It looks to me that there is a crash during update with all the ftp groups from web download still active and this causes access errors on database files hosing everything.

Offline

 

#12 2014-10-11 20:23:41

flop25
Piwigo Team
2006-07-06
7037

Re: after upgrade (hangs), table piwigo_config is hosed and not repairable

this is linked to your server config. What's you mysql version (full one), OS etc


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#13 2014-10-11 21:14:29

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13573

Re: after upgrade (hangs), table piwigo_config is hosed and not repairable

When upgrading, we call our function do_maintenance_all_tables(); and this function do:

* REPAIR TABLE
* ALTER TABLE ... ORDER BY id;
* OPTIMIZE TABLE

Maybe this is related to your problem.

Offline

 

#14 2014-10-11 21:16:10

flop25
Piwigo Team
2006-07-06
7037

Re: after upgrade (hangs), table piwigo_config is hosed and not repairable

so your mysql has something wrong with auto repair?!


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#15 2014-10-11 22:18:01

piwiLaborer
Member
2013-07-30
33

Re: after upgrade (hangs), table piwigo_config is hosed and not repairable

Of cause...

mysql  Ver 14.14 Distrib 5.5.37, for debian-linux-gnu (x86_64) using readline 6.2
Linux 3.10-3-amd64 #1 SMP Debian 3.10.11-1 (2013-09-10) x86_64 GNU/Linux
PHP 5.5.5-1 (cli) (built: Oct 19 2013 18:17:15)
Copyright (c) 1997-2013 The PHP Group
Zend Engine v2.5.0, Copyright (c) 1998-2013 Zend Technologies
    with Zend OPcache v7.0.3-dev, Copyright (c) 1999-2013, by Zend Technologies

Browser: Chrome 37.0.2062.124

mysql was resently upgraded during this debunk, the "myisamchk -rf mysql/*.MYI" did not show any errors/fixes after upgrade to Piwigo 2.7, but the piwigo tables with the ftp groups of cause did.

It also was fine after the first fix as described.

If there is an install log which can be used to debunk this, please point me to it.

The events are clear:
Upgrade hangs with errors shown, piwigo tables and related files there have ftp group ownership and need repairs as described, then it works again.

In this error condition, autorepair (stop/start mysql) fails due to incorrect group ownership. If group ownership is ftp, mysql server process cannot access and repair database files.

Manually changing group to mysql and running repairs on one table works but creates other files with ftp group ownership in this error condition with the 2.6 upgrade failure.

Besides, posting to the mysql forum as suggested here and presenting this issue did not give any result, no one replied and the 1-post "thread" was closed for replies, all in all a waste of effort.

Here, if you know of a debug feature on install/upgrade or location of install logs, it may help now if still present or on another upgrade if it becomes available.

Offline

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2022 · Contact