In this blog post, let’s learn about the error message “263 Could not lock row for UPDATE.” in Hydra and the description of the error.
Error Message
263 Could not lock row for UPDATE.
Error Details
In general, the database server cannot create the file that will represent this table. Check the accompanying ISAM error code for more information. The file would be created in the database.dbs directory (unless you supplied an IN pathname clause) with INFORMIX-SE. Its filename would begin with the first few letters of table-name, followed by a 3-digit number and the suffix .dat, or .idx. With INFORMIX-SE, a problem might exist with file permissions, or possibly the disk is full.
Informix Dynamic Server, INFORMIX-Universal Server, and INFORMIX-OnLine Dynamic Server allow table fragmentation, which might involve extensive use of dbspaces. You need to check the dbspace that was specified for the table. If no dbspace was specified, then the dbspace in which the database was created is used. For database creation, if no dbspace is specified, then the rootdbs is used. The specified dbspace might not exist, or the disk might be full.