On 27 April 2011 16:20, Govind Songara <[log in to unmask]> wrote:
> Hi Sam,
>
> I run the the command and it did thorw errors
> ERROR 1040 (08004): Too many connections
>
>
> While running yaim  also throw these erros
> ERROR 1040 (08004): Too many connections
> ERROR 1040 (08004): Too many connections
>
>
> restarting mysql, make the changes
> [root@se2 ~]# mysql --skip-column-names -s -h se2.ppgrid1.rhul.ac.uk -u
> dpmmgr --pass="xxxxxxxxxxxxx" -e "use dpm_db; select * from
> schema_version_dpm;"
> 3       2       0
>
> After this yaim runs fine,  so i think yaim should also restart mysql
> service before running config_DPM_upgrade_mysql or some otherway to drop all
> existing connections.
>

...you shouldn't have too many connection errors when trying to use
the database! Apart from anything else, this means that your DPM is
probably also having problems keeping enough connections open to the
database to service all its requests, which may be causing failures or
performance issues for you.
(See http://dev.mysql.com/doc/refman/5.5/en/too-many-connections.html etc)

You need to increase the number of maximum connections in your my.cnf
to some reasonably larger number (at least equal to the number of
concurrent DPM threads you support).

Sam

>
>
> Thanks
> Govind
>
>
>
> On Wed, Apr 27, 2011 at 3:18 PM, Sam Skipsey <[log in to unmask]>
> wrote:
>>
>> On 27 April 2011 14:59, Govind Songara <[log in to unmask]> wrote:
>> > Hi,
>> >
>> > I have updated the headnode from DPM 1.7.3 to DPM 1.8.0.1.
>> > While running yaim it give error for mysql config.
>> >
>> > /opt/glite/yaim/bin/yaim -r -d 6 -s  site-info.def -n glite-SE_dpm_mysql
>> > -f
>> > config_DPM_upgrade_mysql
>> >
>> >    INFO: Executing function: config_DPM_upgrade_mysql_check
>> >    DEBUG: Skipping function: config_DPM_upgrade_mysql_setenv because it
>> > is
>> > not defined
>> >    INFO: Executing function: config_DPM_upgrade_mysql
>> >    INFO: Checking for database schema version...
>> >    ERROR: No DPM database schema version information found. Exiting.
>> >    ERROR: Error during the execution of function:
>> > config_DPM_upgrade_mysql
>> >    ERROR: Error during the
>> > configuration.Exiting.                              [FAILED]
>> >    ERROR: One of the functions returned with error without specifying
>> > it's
>> > nature !
>> >
>>
>> ...that's exceptionally interesting.
>> The function that is failing is trying to do this:
>>
>> mysql --skip-column-names -s -h ${DPM_DB_HOST} -u ${DPM_DB_USER}
>> --pass="${DPM_DB_PASSWORD}" -e "use ${DPM_DB}; select * from
>> schema_version_dpm;" 2> /dev/null
>>
>> and apparently failing. Unfortunately, we don't get any useful
>> reporting of the error message from the mysql command, so it's hard to
>> tell which way it is breaking.
>>
>> So, try running that command on your SE, substituting the values of
>> the $DPM_DB_HOST, DPM_DB_USER and PASSWORD appropriately and see what
>> happens.
>>
>> (Possibilities: your configuration as specified in your yaim config is
>> wrong, so it can't access the db; there's something wrong with the
>> schema_version_dpm table in your DPM database; your mysql server isn't
>> running.)
>>
>> Sam
>>
>> > Can you please suggest how to move further from here
>> >
>> > Thanks
>> > Govind
>> >
>
>