problems with default install

[jeff]

I had this running, but I couldn't work out what the admin password was. So, as it was a new install rather than reset the password I decided to dropped the zotonic database and then did

CREATE DATABASE zotonic WITH OWNER = zotonic ENCODING = 'UTF8' template template0;
GRANT ALL ON DATABASE zotonic TO zotonic;
\c zotonic
CREATE LANGUAGE "plpgsql";
\q

then I attempt to start zotonic it appears to add the tables, but it doesn't. Start up looks as show below. Any suggestions of what's wrong?

$ ./start.sh
Erlang R13B01 (erts-5.7.2) [source] [64-bit] [rq:1] [async-threads:0] [kernel-poll:true]

** Found 0 name clashes in code paths
Eshell V5.7.2  (abort with ^G)
(zotonic8894@draugr)1> ** Found 0 name clashes in code paths
** Found 0 name clashes in code paths

=INFO REPORT==== 28-Jul-2010::17:57:10 ===
Installing database "zotonic"@"127.0.0.1":5432 "zotonic"
=CRASH REPORT==== 28-Jul-2010::17:57:15 ===
  crasher:
    initial call: z_sites_manager:init/1
    pid: <0.102.0>
    registered_name: []
    exception exit: {timeout,
                        {gen_server,call,[<0.103.0>,{start_child,default}]}}
      in function  gen_server:init_it/6
    ancestors: [zotonic_sup,<0.63.0>]
    messages: []
    links: [<0.85.0>,<0.103.0>]
    dictionary: []
    trap_exit: false
    status: running
    heap_size: 1597
    stack_size: 24
    reductions: 5499
  neighbours:

=SUPERVISOR REPORT==== 28-Jul-2010::17:57:15 ===
     Supervisor: {local,zotonic_sup}
     Context:    start_error
     Reason:     {timeout,{gen_server,call,[<0.103.0>,{start_child,default}]}}
     Offender:   [{pid,undefined},
                  {name,z_sites_manager},
                  {mfa,{z_sites_manager,start_link,[]}},
                  {restart_type,permanent},
                  {shutdown,5000},
                  {child_type,worker}]


=INFO REPORT==== 28-Jul-2010::17:57:15 ===
    application: zotonic
    exited: {shutdown,{zotonic_app,start,[normal,[]]}}
    type: temporary

=INFO REPORT==== 28-Jul-2010::17:57:15 ===
DEBUG: z_install_data:47  "Inserting config keys"

=INFO REPORT==== 28-Jul-2010::17:57:15 ===
DEBUG: z_install_data:59  "Inserting modules"

=INFO REPORT==== 28-Jul-2010::17:57:15 ===
DEBUG: z_install_data:100  "Inserting categories"

=INFO REPORT==== 28-Jul-2010::17:57:15 ===
DEBUG: z_install_data:260  "Sorting the category hierarchy"

=INFO REPORT==== 28-Jul-2010::17:57:15 ===
DEBUG: z_install_data:179  "Inserting base resources (admin, etc.)"

=INFO REPORT==== 28-Jul-2010::17:57:15 ===
DEBUG: z_install_data:196  "Inserting username for the admin"

=INFO REPORT==== 28-Jul-2010::17:57:15 ===
Exception in transaction: "exit,{noproc,{gen_server,call,[z_ids,{id,10}]}}"
=SUPERVISOR REPORT==== 28-Jul-2010::17:57:15 ===
     Supervisor: {<0.107.0>,z_site_sup}
     Context:    start_error
     Reason:     {'EXIT',
                     {{badmatch,
                          {rollback,
                              {noproc,{gen_server,call,[z_ids,{id,10}]}}}},
                      [{z_install,install,1},
                       {z_installer,start_link,1},
                       {supervisor,do_start_child,2},
                       {supervisor,start_children,3},
                       {supervisor,init_children,2},
                       {gen_server,init_it,6},
                       {proc_lib,init_p_do_apply,3}]}}
     Offender:   [{pid,undefined},
                  {name,z_installer},
                  {mfa,
                      {z_installer,start_link,
                          [[
                            %%%%% config removed %%%%%
                           ]]}},
                  {restart_type,permanent},
                  {shutdown,1},
                  {child_type,worker}]


=CRASH REPORT==== 28-Jul-2010::17:57:15 ===
  crasher:
    initial call: supervisor:z_site_sup/1
    pid: <0.126.0>
    registered_name: []
    exception exit: {noproc,{gen_server,call,[z_config,{get,dbhost}]}}
      in function  gen_server:init_it/6
    ancestors: [<0.103.0>,z_sites_manager,zotonic_sup,<0.63.0>]
    messages: []
    links: [<0.103.0>]
    dictionary: []
    trap_exit: true
    status: running
    heap_size: 2584
    stack_size: 24
    reductions: 2864
  neighbours:

%% output trimmed

Jeff.

[Michael Connors]

Could the database be stuck in a transaction somehow?

Maybe you could restart PostgreSQL and see if it works.

--
Michael Connors
Alencon,
France

[jm]

Michael Connors wrote:
> Could the database be stuck in a transaction somehow?
>
> Maybe you could restart PostgreSQL and see if it works.
>
>
>

Thanks for the suggestion. Tried it and get the same errors.

Should have mentioned in case it's not obvious from the errors that the
tables aren't being created.

Jeff.

[jeff]

I don't know why this fix the situation. I moved the zotonic directory
to zotonic-old and grabbed the mecurial repository again. Didn't bother
dropping the databases or anything on the postgres side. Stepped through
the procedure for setting up the default site again. Ran ./start.sh and
everything seems to be happy again.

Jeff.

[Arjan Scherpenisse]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I'll have a look at it later today. Seems indeed that something goes
wrong while initializing the database...

Arjan

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAkxSiOcACgkQigE4AbflYepOLQCcD3BztLmyvUu8T8Mx9xhMBFmD
oxQAnj3xp93wnNbuEZ40OTvJElfINFYl
=LmGa
-----END PGP SIGNATURE-----