Getting "warning: pg_query() [function.pg-query]: Query failed: ERROR: value too long for type character varying(32)" [#895692]

After installing the deploy and services modules into an existing drupal installation, I tried to add a user and received the following errors:

warning: pg_query() [function.pg-query]: Query failed: ERROR: value too long for type character varying(32) in /var/www/stdrupal/includes/database.pgsql.inc on line 139.
user warning: query: INSERT INTO node_uuid (nid, uuid) values (320, '14443314674c76d2c540d899.61453918') in /var/www/stdrupal/modules/deploy/modules/deploy_uuid/deploy_uuid.install on line 144.

Looks like a column in the table node_uuid is too short for the values being submitted to it. Has anyone encountered this problem before? Is there a workaround available? What happens if I turn off the UUID module?

Thanks for any assistance,

Presley

Comment	File	Size	Author
#4	deploy-895692.patch	650 bytes	ahtih

Comments

Comment #1

ringleader commented 14 October 2010 at 18:26

Assigned:	Unassigned	» ringleader
Status:	Active	» Fixed

We solved this by altering the guilty column in postgress phppgadmin.

Comment #2

28 October 2010 at 18:30

Status:

Fixed

» Closed (fixed)

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

Comment #3

ahtih commented 13 November 2010 at 15:20

Assigned:	ringleader	» Unassigned
Status:	Closed (fixed)	» Active

It definitely still happens:

warning: pg_query(): Query failed: ERROR: value too long for type character varying(32) in /usr/share/drupal/includes/database.pgsql.inc on line 139.
user warning: query: INSERT INTO node_uuid (nid, uuid) values (98531, '16007811294cdeac05e17d21.00282134') in /etc/drupal/all/modules/deploy/modules/deploy_uuid/deploy_uuid.install on line 144.

I have lots of nodes (10000+) so perhaps that triggers it.

Comment #4

ahtih commented 13 November 2010 at 15:34

Status	File	Size
new	deploy-895692.patch	650 bytes

The reason seems obvious: UUIDs are generated with uniqid(rand(),TRUE), which means its maximum length is 10+23 = 33 chars. At the same time, deploy_uuid_get_field_definition() specifies field max length of 32.

Here is a patch which changes field definition to 33 chars. I'm not sure if we need to have an update hook as well, to change it in existing installations? Perhaps not, as existing installations (at least on PostgreSQL) probably do not work anyway due to this bug?