[Bug 60031] 1.22.1 orphan files regression with postgresql

2014-01-14 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=60031

Laurent Wandrebeck l.wandreb...@quelquesmots.fr changed:

   What|Removed |Added

Summary|1.22.1 orphan files |1.22.1 orphan files
   |regression with postgressql |regression with postgresql

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 60031] 1.22.1 orphan files regression with postgresql

2014-01-14 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=60031

--- Comment #1 from Laurent Wandrebeck l.wandreb...@quelquesmots.fr ---
Same regression pops up for several categories in special pages:
 2014-01-14 09:02:52.565 CET INSTRUCTION :  SELECT /*
UncategorizedImagesPage::reallyDoQuery Low */  page_namespace AS
namespace,page_title AS title,page_title AS value  FROM categorylinks   WHERE
(cl_from IS NULL) AND page_namespace = '6' AND page_is_redirect = '0'  ORDER BY
value LIMIT 51  
 2014-01-14 09:02:56.881 CET ERROR:  column « tl_namespace » doesn’t exist at
character 54
 2014-01-14 09:02:56.881 CET INSTRUCTION :  SELECT /*
WantedTemplatesPage::reallyDoQuery Low */  tl_namespace AS namespace,tl_title
AS title,COUNT(*) AS value  FROM page   WHERE (page_title IS NULL) AND
tl_namespace = '10'  GROUP BY tl_namespace,tl_title ORDER BY value DESC LIMIT
51  
 2014-01-14 09:03:02.828 CET ERROR:  column « page_namespace » doesn’t exist
at character 54
 2014-01-14 09:03:02.828 CET INSTRUCTION :  SELECT /*
UnusedtemplatesPage::reallyDoQuery Low */  page_namespace AS
namespace,page_title AS title,page_title AS value  FROM templatelinks   WHERE
page_namespace = '10' AND (tl_from IS NULL) AND page_is_redirect = '0'  ORDER
BY value LIMIT 51  
 2014-01-14 09:09:07.225 CET ERROR:  column « page_namespace » doesn’t exist
at character 61

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 60031] 1.22.1 orphan files regression with postgresql

2014-01-14 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=60031

--- Comment #2 from Laurent Wandrebeck l.wandreb...@quelquesmots.fr ---
OK, I’ve checked every links in special pages, here’s the whole error log (in
french sorry, but meaning is obvious).
 2014-01-14 08:47:08.118 CET ERREUR:  la colonne « img_name » n'existe pas au
caractère 66
 2014-01-14 08:47:08.118 CET INSTRUCTION :  SELECT /*
UnusedimagesPage::reallyDoQuery Low */  6 AS namespace,img_name AS
title,img_timestamp AS value,img_user,img_user_text,img_description  FROM
imagelinks   WHERE (il_to IS NULL)  ORDER BY value LIMIT 51  
 2014-01-14 08:47:26.556 CET ERREUR:  la colonne « img_name » n'existe pas au
caractère 66
 2014-01-14 08:47:26.556 CET INSTRUCTION :  SELECT /*
UnusedimagesPage::reallyDoQuery Low */  6 AS namespace,img_name AS
title,img_timestamp AS value,img_user,img_user_text,img_description  FROM
imagelinks   WHERE (il_to IS NULL)  ORDER BY value LIMIT 51  
 2014-01-14 09:02:52.565 CET ERREUR:  la colonne « page_namespace » n'existe
pas au caractère 58
 2014-01-14 09:02:52.565 CET INSTRUCTION :  SELECT /*
UncategorizedImagesPage::reallyDoQuery Low */  page_namespace AS
namespace,page_title AS title,page_title AS value  FROM categorylinks   WHERE
(cl_from IS NULL) AND page_namespace = '6' AND page_is_redirect = '0'  ORDER BY
value LIMIT 51  
 2014-01-14 09:02:56.881 CET ERREUR:  la colonne « tl_namespace » n'existe
pas au caractère 54
 2014-01-14 09:02:56.881 CET INSTRUCTION :  SELECT /*
WantedTemplatesPage::reallyDoQuery Low */  tl_namespace AS namespace,tl_title
AS title,COUNT(*) AS value  FROM page   WHERE (page_title IS NULL) AND
tl_namespace = '10'  GROUP BY tl_namespace,tl_title ORDER BY value DESC LIMIT
51  
 2014-01-14 09:03:02.828 CET ERREUR:  la colonne « page_namespace » n'existe
pas au caractère 54
 2014-01-14 09:03:02.828 CET INSTRUCTION :  SELECT /*
UnusedtemplatesPage::reallyDoQuery Low */  page_namespace AS
namespace,page_title AS title,page_title AS value  FROM templatelinks   WHERE
page_namespace = '10' AND (tl_from IS NULL) AND page_is_redirect = '0'  ORDER
BY value LIMIT 51  
 2014-01-14 09:09:07.225 CET ERREUR:  la colonne « page_namespace » n'existe
pas au caractère 61
 2014-01-14 09:09:07.225 CET INSTRUCTION :  SELECT /*
UncategorizedTemplatesPage::reallyDoQuery Low */  page_namespace AS
namespace,page_title AS title,page_title AS value  FROM categorylinks   WHERE
(cl_from IS NULL) AND page_namespace = '10' AND page_is_redirect = '0'  ORDER
BY page_title LIMIT 51  
 2014-01-14 09:23:52.778 CET ERREUR:  la relation « pg2 » n'existe pas au
caractère 118
 2014-01-14 09:23:52.778 CET INSTRUCTION :  SELECT /*
WantedPagesPage::reallyDoQuery Low */  pl_namespace AS namespace,pl_title AS
title,COUNT(*) AS value  FROM pg2   WHERE (pg1.page_namespace IS NULL) AND
(pl_namespace NOT IN ( '2', '3' )) AND (pg2.page_namespace != '8')  GROUP BY
pl_namespace,pl_title HAVING COUNT(*)  0 ORDER BY value DESC LIMIT 51  
 2014-01-14 09:27:08.785 CET ERREUR:  la colonne « page_namespace » n'existe
pas au caractère 53
 2014-01-14 09:27:08.785 CET INSTRUCTION :  SELECT /*
UnwatchedpagesPage::reallyDoQuery Low */  page_namespace AS
namespace,page_title AS title,page_namespace AS value  FROM watchlist   WHERE
(wl_title IS NULL) AND page_is_redirect = '0' AND (page_namespace != '8') 
ORDER BY page_namespace,page_title LIMIT 51  
 2014-01-14 09:29:31.165 CET ERREUR:  la colonne « page_namespace » n'existe
pas au caractère 50
 2014-01-14 09:29:31.165 CET INSTRUCTION :  SELECT /*
LonelyPagesPage::reallyDoQuery Low */  page_namespace AS namespace,page_title
AS title,page_title AS value  FROM templatelinks   WHERE (pl_namespace IS
NULL) AND page_namespace = '0' AND page_is_redirect = '0' AND (tl_namespace IS
NULL)  ORDER BY page_title LIMIT 51  
 2014-01-14 09:29:40.511 CET ERREUR:  la colonne « page_namespace » n'existe
pas au caractère 57
 2014-01-14 09:29:40.511 CET INSTRUCTION :  SELECT /*
UncategorizedPagesPage::reallyDoQuery Low */  page_namespace AS
namespace,page_title AS title,page_title AS value  FROM categorylinks   WHERE
(cl_from IS NULL) AND page_namespace = '0' AND page_is_redirect = '0'  ORDER BY
page_title LIMIT 51  
 2014-01-14 09:29:44.301 CET ERREUR:  la colonne « page_namespace » n'existe
pas au caractère 55
 2014-01-14 09:29:44.301 CET INSTRUCTION :  SELECT /*
WithoutInterwikiPage::reallyDoQuery Low */  page_namespace AS
namespace,page_title AS title,page_title AS value  FROM langlinks   WHERE
(ll_title IS NULL) AND page_namespace = '0' AND page_is_redirect = '0'  ORDER
BY page_namespace,page_title LIMIT 51  
 2014-01-14 09:29:48.105 CET ERREUR:  la relation « p2 » n'existe pas au
caractère 159
 2014-01-14 09:29:48.105 CET INSTRUCTION :  SELECT /*
BrokenRedirectsPage::reallyDoQuery Low */  p1.page_namespace AS
namespace,p1.page_title AS title,p1.page_title AS value,rd_namespace,rd_title 
FROM p2   WHERE (rd_namespace = 0) AND (rd_interwiki IS NULL OR rd_interwiki
= '') AND (p2.page_namespace IS NULL)  ORDER BY