526025 - [AMO] Run a script on preview

Status: RESOLVED FIXED

(mozilla.org Graveyard :: Server Operations, task)

Description

[Wil Clouser [:clouserw]]

We need to run a script for bug 343573.  This needs to be run on preview.amo:

$ cd bin
$ php -f run_once/seed_purified_translations.php

It took about 12 minutes for me. Thanks.

Comment 1

[Shyam Mani [:fox2mike]]

[root@mradm02 bin]# time php -f run_once/seed_purified_translations.php 
Now running:
        SELECT autoid,localized_string FROM translations where id IN (SELECT description FROM addons)
PHP Warning:  Base directory /mnt/netapp_amo/addons.mozilla.org-preview/shared_storage/HTMLPurifier does not exist,
                    please create or change using %Cache.SerializerPath in /data/amo/www/addons.mozilla.org-preview/site/vendors/htmlpurifier/library/HTMLPurifier/DefinitionCache/Serializer.php on line 117
PHP Warning:  Base directory /mnt/netapp_amo/addons.mozilla.org-preview/shared_storage/HTMLPurifier does not exist,
                    please create or change using %Cache.SerializerPath in /data/amo/www/addons.mozilla.org-preview/site/vendors/htmlpurifier/library/HTMLPurifier/DefinitionCache/Serializer.php on line 117
PHP Warning:  Base directory /mnt/netapp_amo/addons.mozilla.org-preview/shared_storage/HTMLPurifier does not exist,
                    please create or change using %Cache.SerializerPath in /data/amo/www/addons.mozilla.org-preview/site/vendors/htmlpurifier/library/HTMLPurifier/DefinitionCache/Serializer.php on line 117
PHP Warning:  Base directory /mnt/netapp_amo/addons.mozilla.org-preview/shared_storage/HTMLPurifier does not exist,
                    please create or change using %Cache.SerializerPath in /data/amo/www/addons.mozilla.org-preview/site/vendors/htmlpurifier/library/HTMLPurifier/DefinitionCache/Serializer.php on line 117
PHP Warning:  Base directory /mnt/netapp_amo/addons.mozilla.org-preview/shared_storage/HTMLPurifier does not exist,
                    please create or change using %Cache.SerializerPath in /data/amo/www/addons.mozilla.org-preview/site/vendors/htmlpurifier/library/HTMLPurifier/DefinitionCache/Serializer.php on line 117
PHP Warning:  Base directory /mnt/netapp_amo/addons.mozilla.org-preview/shared_storage/HTMLPurifier does not exist,
                    please create or change using %Cache.SerializerPath in /data/amo/www/addons.mozilla.org-preview/site/vendors/htmlpurifier/library/HTMLPurifier/DefinitionCache/Serializer.php on line 117
Now running:
        SELECT autoid,localized_string FROM translations where id IN (SELECT developercomments FROM addons)
Now running:
        SELECT autoid,localized_string FROM translations where id IN (SELECT releasenotes FROM versions)
Now running:
        SELECT autoid,localized_string FROM translations where id IN (SELECT bio FROM users)
Now running:
        SELECT autoid,localized_string FROM translations where id IN (SELECT summary FROM addons)
PHP Warning:  Base directory /mnt/netapp_amo/addons.mozilla.org-preview/shared_storage/HTMLPurifier does not exist,
                    please create or change using %Cache.SerializerPath in /data/amo/www/addons.mozilla.org-preview/site/vendors/htmlpurifier/library/HTMLPurifier/DefinitionCache/Serializer.php on line 117
PHP Warning:  Base directory /mnt/netapp_amo/addons.mozilla.org-preview/shared_storage/HTMLPurifier does not exist,
                    please create or change using %Cache.SerializerPath in /data/amo/www/addons.mozilla.org-preview/site/vendors/htmlpurifier/library/HTMLPurifier/DefinitionCache/Serializer.php on line 117
PHP Warning:  Base directory /mnt/netapp_amo/addons.mozilla.org-preview/shared_storage/HTMLPurifier does not exist,
                    please create or change using %Cache.SerializerPath in /data/amo/www/addons.mozilla.org-preview/site/vendors/htmlpurifier/library/HTMLPurifier/DefinitionCache/Serializer.php on line 117
PHP Warning:  Base directory /mnt/netapp_amo/addons.mozilla.org-preview/shared_storage/HTMLPurifier does not exist,
                    please create or change using %Cache.SerializerPath in /data/amo/www/addons.mozilla.org-preview/site/vendors/htmlpurifier/library/HTMLPurifier/DefinitionCache/Serializer.php on line 117
PHP Warning:  Base directory /mnt/netapp_amo/addons.mozilla.org-preview/shared_storage/HTMLPurifier does not exist,
                    please create or change using %Cache.SerializerPath in /data/amo/www/addons.mozilla.org-preview/site/vendors/htmlpurifier/library/HTMLPurifier/DefinitionCache/Serializer.php on line 117
PHP Warning:  Base directory /mnt/netapp_amo/addons.mozilla.org-preview/shared_storage/HTMLPurifier does not exist,
                    please create or change using %Cache.SerializerPath in /data/amo/www/addons.mozilla.org-preview/site/vendors/htmlpurifier/library/HTMLPurifier/DefinitionCache/Serializer.php on line 117
Now running:
        SELECT autoid,localized_string FROM translations where id IN (SELECT description FROM collections)

real    11m2.292s
user    3m21.765s
sys     0m2.950s

Comment 2

[Wil Clouser [:clouserw]]

It worked, the errors are it complaining about not having a writable cache directory.  If you could create and make that directory writable (/mnt/netapp_amo/addons.mozilla.org-preview/shared_storage/HTMLPurifier) it would save us a bug.  Otherwise I'll file another one in the morning.

Thanks.

Comment 3

[Shyam Mani [:fox2mike]]

Done and chown'd.