Error when add variables of data sources

[mutolisp]

Dear deims developers,

When I try to add variables of data sources (everything works well without add variables), it showed the following error messages:

PDOException: SQLSTATE[22003]: Numeric value out of range: 7 ERROR: setval: value 0 is out of
bounds for sequence "field_data_field_variables_field_variables_id_seq" (1..9223372036854775807):
SELECT setval('field_data_field_variables_field_variables_id_seq',
GREATEST(MAX(field_variables_id), :serial_value)) FROM {field_data_field_variables}; Array (
[:serial_value] => 0 ) in field_sql_storage_field_storage_write() (line 494 of
/usr/local/www/deims/modules/field/modules/field_sql_storage/field_sql_storage.module).

I am just wondering if it is the postgres or the php-pdo_pgsql problem.

I used DEIMS-7.x-1.x with PostgreSQL 9.3, php5-pdo_pgsql-5.4.35

thank you!

[isangil]

Hi,

Thanks for posting this issue. It looks like this issue surfaces when using the DEIMS with Postgres as part of the stack, as we do not see this on MySQL or MariaDB.

Judging by the error message, I'd say the "sequence" likes to start at '1', but Drupal tries to start it at zero, which is not in the allowed values (allowed values from 1 to a very large integer). It might be a problem that transcends DEIMS, as the error is triggered on field_sql_storage. Let me see what I can find on the Drupal issue queues that looks the same.

[isangil]

seems this surfaces also elsewhere.. https://www.drupal.org/node/2164261

[mutolisp]

Hi isangil,

Thanks for your reply. Maybe it’s the problem due to the drupal-postgresql issue. I also installed MySQL and it works without any problem. I will try to trace the code to find where is the problem.

thank you!

[isangil]

Hi mutolisp,

After a quick google lookup, I see three or four issues quite similar on several modules, (eck, users). Seems postgres specific, and should be addressed. It does not seem a deep bug, a quick check on the appropriate call serves as workaround on the reported issues. In DEIMS, some call in the 'variables' custom module is incurring in this unintentional fault (try to insert a zero where we need at least a 1 - avoiding the insert would do). Tracing and patching should not be a big deal. However..

Our colleagues from France reported other postgres specific issues on an install that involved also the windows internet server and post-gres as backend for DEIMS. Such instabilities, and the lack of a dedicated postgres person made us recommend MySQL or MariaDB in a LAMP stack as the officially supported backend until a dedicated postgres champion can thoroughly debug all problems that arise when using DEIMS with the postgres DB backend. Or until a brave person deals with the quirks of such install.

It seems that you can work with MySQL, and Im happy that is working for you.

[mutolisp]

Hi isangil,

Thanks for your explanation!