SQLSTATE[53100]: Disk full: 7 ERROR: could not access status of transaction 0
DETAIL: Could not write to file "pg_subtrans/0018" at offset 114688: No space left on device.
The SQL being executed was: INSERT INTO "session" ("data", "id", "expire") VALUES ('__flash|a:0:{}filter|a:4:{s:4:"beds";N;s:10:"max_people";N;s:9:"date_from";N;s:7:"date_to";N;}', 'plmt4j6rkfcoldh77vfngqmb85', 1695671627)

Error Info: Array ( [0] => 53100 [1] => 7 [2] => ERROR: could not access status of transaction 0 DETAIL: Could not write to file "pg_subtrans/0018" at offset 114688: No space left on device. )

↵

Caused by: PDOException

SQLSTATE[53100]: Disk full: 7 ERROR: could not access status of transaction 0
DETAIL: Could not write to file "pg_subtrans/0018" at offset 114688: No space left on device.

in /var/www/islandhouse/data/www/islandhouseforrent-yii2/vendor/yiisoft/yii2/db/Command.php at line 994

1. in /var/www/islandhouse/data/www/islandhouseforrent-yii2/vendor/yiisoft/yii2/db/Schema.php at line 595

586587588589590591592593594595596597598599600601602603604

 
        $exceptionClass = '\yii\db\Exception';
        foreach ($this->exceptionMap as $error => $class) {
            if (strpos($e->getMessage(), $error) !== false) {
                $exceptionClass = $class;
            }
        }
        $message = $e->getMessage() . "\nThe SQL being executed was: $rawSql";
        $errorInfo = $e instanceof \PDOException ? $e->errorInfo : null;
        return new $exceptionClass($message, $errorInfo, (int) $e->getCode(), $e);
    }
 
    /**
     * Returns a value indicating whether a SQL statement is for read purpose.
     * @param string $sql the SQL statement
     * @return bool whether a SQL statement is for read purpose.
     */
    public function isReadQuery($sql)
    {

2. in /var/www/islandhouse/data/www/islandhouseforrent-yii2/vendor/yiisoft/yii2/db/Command.php at line 1004 – yii\db\Schema::convertException(PDOException, 'INSERT INTO "session" ("data", "...')

99899910001001100210031004100510061007100810091010

 
            $this->refreshTableSchema();
 
            return $n;
        } catch (\Exception $e) {
            $profile and Yii::endProfile($rawSql, __METHOD__);
            throw $this->db->getSchema()->convertException($e, $rawSql ?: $this->getRawSql());
        }
    }
 
    /**
     * Logs the current database query if query logging is enabled and returns
     * the profiling token if profiling is enabled.

3. in /var/www/islandhouse/data/www/islandhouseforrent-yii2/vendor/yiisoft/yii2/web/DbSession.php at line 179 – yii\db\Command::execute()

173174175176177178179180181182183184185

                ->queryScalar();
            $fields = $this->composeFields($id, $data);
            $fields = $this->typecastFields($fields);
            if ($exists === false) {
                $this->db->createCommand()
                    ->insert($this->sessionTable, $fields)
                    ->execute();
            } else {
                unset($fields['id']);
                $this->db->createCommand()
                    ->update($this->sessionTable, $fields, ['id' => $id])
                    ->execute();
            }

4. yii\web\DbSession::writeSession('plmt4j6rkfcoldh77vfngqmb85', '__flash|a:0:{}filter|a:4:{s:4:"b...')

5. in /var/www/islandhouse/data/www/islandhouseforrent-yii2/vendor/yiisoft/yii2/web/Session.php at line 187 – session_write_close()

181182183184185186187188189190191192193

    /**
     * Ends the current session and store session data.
     */
    public function close()
    {
        if ($this->getIsActive()) {
            YII_DEBUG ? session_write_close() : @session_write_close();
        }
    }
 
    /**
     * Frees all session variables and destroys all data registered to a session.
     *

6. yii\web\Session::close()

$_GET = [ 'district' => 'bo-put', 'buildingTypeOrIslandAlias' => 'samui', 'page' => null, ]; $_SESSION = [ '__flash' => [], 'filter' => [ 'beds' => null, 'max_people' => null, 'date_from' => null, 'date_to' => null, ], ];

Real estate in Thailand

Database Exception – yii\db\Exception

Caused by: PDOException

SQLSTATE[53100]: Disk full: 7 ERROR: could not access status of transaction 0
DETAIL: Could not write to file "pg_subtrans/0018" at offset 114688: No space left on device.

Real estate in Thailand

Database Exception – yii\db\Exception

Caused by: PDOException

SQLSTATE[53100]: Disk full: 7 ERROR: could not access status of transaction 0 DETAIL: Could not write to file "pg_subtrans/0018" at offset 114688: No space left on device.

SQLSTATE[53100]: Disk full: 7 ERROR: could not access status of transaction 0
DETAIL: Could not write to file "pg_subtrans/0018" at offset 114688: No space left on device.