🌍
English
Announcement
- [2024-09-05] Piwigo 15.0.0beta3
- [2024-08-23] The rebirth of Piwigo documentation
- [2024-07-31] Piwigo 15.0.0beta2
- [2024-07-15] Piwigo 14.5.0
- [2024-07-02] Piwigo 15.0.0beta1
Pages: 1 2
- » How-To and Troubleshooting
- » after upgrade (hangs), table piwigo_config is hosed and not repairable
#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
- 13820
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
- 13820
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
Pages: 1 2
- » How-To and Troubleshooting
- » after upgrade (hangs), table piwigo_config is hosed and not repairable