I've got a pretty fresh install of Beta3 (some configuration, no content). I've turned on logging, caching, and some other modules (these can be provided if they are important to understanding the issue.)

I had just added an OpenID reference to my user account (which is the administrative account). I went to log out to test the impact of making the connection and received the following errors on logging out (names changed to protect the innocent):

Warning: pg_query() [function.pg-query]: Query failed: ERROR: value too long for type character varying(128) in /var/www/bcom/includes/database.pgsql.inc on line 155

Warning: ERROR: value too long for type character varying(128) query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:"%error";s:7:"warning";s:8:"%message";s:132:"pg_query() [function.pg-query]: Query failed: ERROR: value too long for type character varying(128)";s:5:"%file";s:41:"/var/www/bcom/includes/database.pgsql.inc";s:5:"%line";i:155;}', 3, '', 'http://XXXXXXX.com/logout', 'http://XXXXXXX.com/user/1/openid?openid.mode=id_res&openid.identity=http... in /var/www/bcom/includes/database.pgsql.inc on line 176

Warning: pg_query() [function.pg-query]: Query failed: ERROR: value too long for type character varying(128) in /var/www/bcom/includes/database.pgsql.inc on line 155

Warning: ERROR: value too long for type character varying(128) query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:"%error";s:12:"user warning";s:8:"%message";s:867:"ERROR: value too long for type character varying(128) query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'user', 'Session closed for %name.', 'a:1:{s:5:"%name";s:11:"sXXXXXXX";}', 5, '', 'http://XXXXXXX.com/logout', 'http://XXXXXXX.com/user/1/openid?openid.mode=id_res&openid.identity=http... in /var/www/bcom/includes/database.pgsql.inc on line 176

Warning: pg_query() [function.pg-query]: Query failed: ERROR: value too long for type character varying(128) in /var/www/bcom/includes/database.pgsql.inc on line 155

Warning: ERROR: value too long for type character varying(128) query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:"%error";s:7:"warning";s:8:"%message";s:124:"Cannot modify header information - headers already sent by (output started at /var/www/bcom/includes/database.pgsql.inc:155)";s:5:"%file";s:33:"/var/www/bcom/includes/common.inc";s:5:"%line";i:320;}', 3, '', 'http://XXXXXXX.com/logout', 'http://XXXXXXX.com/user/1/openid?openid.mode=id_res&openid.identity=http... in /var/www/bcom/includes/database.pgsql.inc on line 176

Hard to tell exactly but looks like the 'location' varchar overruns the designated length on insert and then a subsequent error that could either be symptomatic of the root cause or an unrelated issue. I've not been able to duplicate the issue after the fact with other logout behaviors. I noticed I couldn't login with the OpenID in maintenance mode enabled, so this might have predisposed my tests to failure. Sorry that this isn't the most complete report, please let me know if there's something more specific I could do to help (versions, etc).

Thanks,
Steve

Comments

Dave Reid’s picture

Status: Active » Fixed

This should be fixed in 6.x. Location is now a text field.

Anonymous’s picture

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.