startdaemons fail with DB Error

Submitted by Fabián Bonetti on Fri, 09/30/2011 - 17:14

Issue ID:	3449
Issue Category:	bug
Component:	plugin
Priority:	normal
Status:	invalid
Assigned:	Unassigned
Version:	1.0
Keywords:	common.php, DB.php, lib, PEAR.php, synctwitterfriends.php, twitterstatusfetcher.php, xmppmanager.php

upgrade 0.9.9 - 1.0.0

PHP Fatal error: Uncaught PEAR_Exception: DB Error: no database selected in unknown on line unknown
DB_Error: DB Error: no database selected in unknown on line unknown
#0 [internal function]: PEAR_ErrorToPEAR_Exception(Object(DB_Error))
#1 /media/Disco160/www/legadolibre.com.ar/extlib/PEAR.php(890): call_user_func('PEAR_ErrorToPEA...', Object(DB_Error))
#2 /media/Disco160/www/legadolibre.com.ar/extlib/DB.php(966): PEAR_Error->PEAR_Error('DB Error: no da...', -14, 16, 'PEAR_ErrorToPEA...', 'SELECT * ? FROM...')
#3 /media/Disco160/www/legadolibre.com.ar/extlib/PEAR.php(531): DB_Error->DB_Error(-14, 16, 'PEAR_ErrorToPEA...', 'SELECT * ? FROM...')
#4 /media/Disco160/www/legadolibre.com.ar/extlib/DB/common.php(1908): PEAR->raiseError(NULL, -14, NULL, NULL, 'SELECT * ? FROM...', 'DB_Error', true)
#5 /media/Disco160/www/legadolibre.com.ar/extlib/DB/mysqli.php(928): DB_common->raiseError(-14, NULL, NULL, NULL, '2006 ** MySQL s...')
#6 /media/Disco160/www/legadolibre.com.ar/extlib/DB/mysqli.php(387): DB_mysqli->mysqliRaiseError(-14)
in /media/Disco160/www/legadolibre.com.ar/lib/framework.php on line 163
DONE.
mama@zeuza:/media/Disco160/www/legadolibre.com.ar$ PHP Fatal error: Call to undefined function common_broadcast_notice() in /media/Disco160/www/legadolibre.com.ar/lib/xmppmanager.php on line 422

Attachment	Size
statusnet.txt	29.31 KB

Updates

#1

Submitted by Fabián Bonetti on Fri, 09/30/2011 - 17:24.

sudo bash ./scripts/startdaemons.sh

Attachment	Size
statusnet2.txt	15.76 KB

#2

Submitted by Tovok7 on Sat, 10/15/2011 - 11:04.

Title:	startdaemons fail	» startdaemons fail with DB Error
Component:	core	» plugin
Keywords:		+synctwitterfriends.php, +twitterstatusfetcher.php

I have the same problem:
PHP Fatal error: Uncaught PEAR_Exception: DB Error: no database selected in unknown on line unknown

In my case synctwitterfriends.php and twitterstatusfetcher.php fail

#3

Submitted by Tovok7 on Sat, 10/15/2011 - 12:58.

problem also happens with 1.0.1

in the log file the following happens:

PEAR Error: DB Error: no database selected (SELECT *
FROM foreign_link

WHERE ( foreign_link.service = 1 )

ORDER BY last_noticesync
[nativecode=2006 ** MySQL server has gone away])

But the MySQL server is up and working.

#4

Submitted by Tovok7 on Mon, 10/24/2011 - 17:53.

Some more info to narrow this down:

I executed php ./checkschema.php with no success and I am running Debian stable with the only config file in /etc/statusnet/${HOSTNAME}.php which creates some trouble sometimes when I don't provide the -c parameter.

#5

Submitted by rohieb on Mon, 10/24/2011 - 20:50.

Same for me, using v1.0.1 (after update from 0.9.9) on Debian stable.

#6

Submitted by Tovok7 on Sat, 01/07/2012 - 17:09.

changing $config['db']['database'] from 'mysqli://' to 'mysql://' seems to help :)

#7

Submitted by tony baldwin on Thu, 01/12/2012 - 04:34.

in /etc/php5/apache2/php.ini
and/or
/etc/php5/cli/php5.ini
check
mysqli.reconnect = On

(likely it is "Off", and this is causing the error)

#8

Submitted by Tovok7 on Thu, 01/12/2012 - 07:02.

Status:

active

» invalid

thx tony, that is exactly the problem. Fixed now. :)

Unfortunately, the error message was not very meaningful. Maybe that can be improved? mysqli.reconnect = Off was the default in my debian installation