Restoring from a Backup gives blank screen

nnhubbard · July 26, 2012, 2:28am

I am trying to restore from a backup file, but after doing so I just get a blank browser window when trying to load the site. Here is what I have done (after a normal full fresh Matrix install):

Un-tarred the backup

dropdb -U postgres squiz_matrix

createdb -U postgres -O matrix -E UTF8 squiz_matrix

createlang -U postgres plpgsql squiz_matrix

psql -U postgres -f squiz_matrix-2012-07-25_16-55.dump

Then I get errors along with tons of successful DB stuff:

    psql:squiz_matrix-2012-07-25_16-55.dump:72: ERROR:  language "plpgsql" does not exist
    HINT:  Use CREATE LANGUAGE to load the language into the database.
    psql:squiz_matrix-2012-07-25_16-55.dump:75: ERROR:  function public.asset_link_treeid_convert(bytea, character, integer, integer) does not exist
    psql:squiz_matrix-2012-07-25_16-55.dump:89: ERROR:  language "plpgsql" does not exist
    HINT:  Use CREATE LANGUAGE to load the language into the database.
    psql:squiz_matrix-2012-07-25_16-55.dump:92: ERROR:  function public.atoi(character varying) does not exist
    psql:squiz_matrix-2012-07-25_16-55.dump:125: ERROR:  language "plpgsql" does not exist
    HINT:  Use CREATE LANGUAGE to load the language into the database.
    psql:squiz_matrix-2012-07-25_16-55.dump:128: ERROR:  function public.sq_get_lineage_from_url(character varying) does not exist
    psql:squiz_matrix-2012-07-25_16-55.dump:196: ERROR:  language "plpgsql" does not exist
    HINT:  Use CREATE LANGUAGE to load the language into the database.
    psql:squiz_matrix-2012-07-25_16-55.dump:199: ERROR:  function public.sq_get_lineage_treeids(character varying, integer, timestamp without time zone, integer) does not exist
    psql:squiz_matrix-2012-07-25_16-55.dump:216: ERROR:  language "plpgsql" does not exist
    HINT:  Use CREATE LANGUAGE to load the language into the database.
    psql:squiz_matrix-2012-07-25_16-55.dump:219: ERROR:  function public.sq_get_lineage_treeids(character varying, integer) does not exist
    psql:squiz_matrix-2012-07-25_16-55.dump:273: ERROR:  language "plpgsql" does not exist
    HINT:  Use CREATE LANGUAGE to load the language into the database.
    psql:squiz_matrix-2012-07-25_16-55.dump:276: ERROR:  function public.sq_get_parent_treeids(character varying, integer, timestamp without time zone) does not exist
    psql:squiz_matrix-2012-07-25_16-55.dump:293: ERROR:  language "plpgsql" does not exist
    HINT:  Use CREATE LANGUAGE to load the language into the database.
    psql:squiz_matrix-2012-07-25_16-55.dump:296: ERROR:  function public.sq_get_parent_treeids(character varying, integer) does not exist
    psql:squiz_matrix-2012-07-25_16-55.dump:316: ERROR:  language "plpgsql" does not exist
    HINT:  Use CREATE LANGUAGE to load the language into the database.
    psql:squiz_matrix-2012-07-25_16-55.dump:319: ERROR:  function public.sq_get_rollback_timestamp() does not exist
    psql:squiz_matrix-2012-07-25_16-55.dump:340: ERROR:  language "plpgsql" does not exist
    HINT:  Use CREATE LANGUAGE to load the language into the database.
    psql:squiz_matrix-2012-07-25_16-55.dump:343: ERROR:  function public.sq_grant_access(character varying) does not exist
    psql:squiz_matrix-2012-07-25_16-55.dump:365: ERROR:  language "plpgsql" does not exist
    HINT:  Use CREATE LANGUAGE to load the language into the database.
    psql:squiz_matrix-2012-07-25_16-55.dump:368: ERROR:  function public.sq_grant_access(character varying, character varying) does not exist
    psql:squiz_matrix-2012-07-25_16-55.dump:387: ERROR:  language "plpgsql" does not exist
    HINT:  Use CREATE LANGUAGE to load the language into the database.
    psql:squiz_matrix-2012-07-25_16-55.dump:390: ERROR:  function public.sq_rb_get_lineage_treeids(character varying, integer, timestamp without time zone, integer) does not exist
    psql:squiz_matrix-2012-07-25_16-55.dump:409: ERROR:  language "plpgsql" does not exist
    HINT:  Use CREATE LANGUAGE to load the language into the database.
    psql:squiz_matrix-2012-07-25_16-55.dump:412: ERROR:  function public.sq_rb_get_parent_treeids(character varying, integer) does not exist
    psql:squiz_matrix-2012-07-25_16-55.dump:452: ERROR:  language "plpgsql" does not exist
    HINT:  Use CREATE LANGUAGE to load the language into the database.
    psql:squiz_matrix-2012-07-25_16-55.dump:455: ERROR:  function public.sq_set_rollback_timestamp(timestamp without time zone) does not exist
    psql:squiz_matrix-2012-07-25_16-55.dump:469: ERROR:  language "plpgsql" does not exist
    HINT:  Use CREATE LANGUAGE to load the language into the database.
    psql:squiz_matrix-2012-07-25_16-55.dump:472: ERROR:  function public.sq_set_rollback_timestamp() does not exist

Also, tons more errors. What have I done wrong?

Matrix 4.4.1

dschoen · July 26, 2012, 3:08am

I think this is where the issue happened:

[quote]

[…]

createlang -U postgres plpgsql squiz_matrix

psql -U postgres -f squiz_matrix-2012-07-25_16-55.dump

[…]

[/quote]You have created a db called "squiz_matrix" with plpgsql enabled and then imported the dump in to the "postgres" db.

The final command should be this:

    
    psql -U postgres -f squiz_matrix-2012-07-25_16-55.dump squiz_matrix

... well hopefully :)

nnhubbard · July 26, 2012, 3:16am

[quote]
I think this is where the issue happened:

You have created a db called "squiz_matrix" with plpgsql enabled and then imported the dump in to the "postgres" db.

The final command should be this:

    
    psql -U postgres -f squiz_matrix-2012-07-25_16-55.dump squiz_matrix

... well hopefully :)
[/quote]

Well, no errors that time, but still a blank screen. Seems like something else is missing...

Any way to debug this?

Ashish_Karelia · July 26, 2012, 5:15am

[quote]
Well, no errors that time, but still a blank screen. Seems like something else is missing…

Any way to debug this?

[/quote]

Whats the Matrix memory limit (web) set to ? I have seen blank screen if the Matrix is running out of memory before it gets started. At time there is no mention of this in error.log too.

Is the request reaching Matrix is what you need to find out I think. Execution path (points) to check in order of :

core/web/index.php
core/include/init.inc
core/include/mysource.inc::start()

Ash

nnhubbard · July 26, 2012, 5:21am

[quote]
Whats the Matrix memory limit (web) set to ? I have seen blank screen if the Matrix is running out of memory before it gets started. At time there is no mention of this in error.log too.

Is the request reaching Matrix is what you need to find out I think. Execution path (points) to check in order of :

core/web/index.php
core/include/init.inc
core/include/mysource.inc::start()

Ash

[/quote]

It is set to 128. The entire squiz_matrix folder got moved over with my backup (used the backup.sh script on my other server) so I assumed everything would be fine.

I am actually getting this error in the error.log:

    [2012-07-25 22:19:49][7:Public User][1024:mysource notice][R] (/core/include/locale_manager.inc:547) - URL "http://66.175.221.249" not found [SYS0218]
    [2012-07-25 22:19:53][7:Public User][1024:mysource notice][R] (/core/include/locale_manager.inc:547) - URL "http://66.175.221.249/_admin" not found [SYS0218]

Strange, because I did add 66.175.221.249 to the main.inc file.

nnhubbard · July 26, 2012, 5:27am

Ok, I figured it out. Everything is working now.