Crash of Postgresql on Windows - Mailing list pgsql-general
From | Emilie Laffray |
---|---|
Subject | Crash of Postgresql on Windows |
Date | |
Msg-id | 7e9dfabf0902040418o37427f03v348d24c86a7c298e@mail.gmail.com Whole thread Raw |
Responses |
Re: Crash of Postgresql on Windows
Re: Crash of Postgresql on Windows |
List | pgsql-general |
Hello, I am sending this email since I am hitting a snag with postgresql. I am currently running the following version of postgresql: Postgresql 8.3.5 on Windows XP Pro 32bits I am getting a crash whenever I try to perform an update on some rows. More precisely, I have recently imported a dataset and managed to work through it easily. However, when performing one update I am getting the following error: GMT PANIC: could not write to log file 40, segment 44 at offset 8929280, length 1744896: Invalid argument This application has requested the Runtime to terminate it in an unusual way. Please contact the application's support team for more information. 2009-02-04 12:02:34 GMT LOG: WAL writer process (PID 2916) exited with exit code 3 2009-02-04 12:02:34 GMT LOG: terminating any other active server processes 2009-02-04 12:02:34 GMT WARNING: terminating connection because of crash of another server process 2009-02-04 12:02:34 GMT DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 2009-02-04 12:02:34 GMT HINT: In a moment you should be able to reconnect to the database and repeat your command. 2009-02-04 12:02:34 GMT WARNING: terminating connection because of crash of another server process 2009-02-04 12:02:34 GMT DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 2009-02-04 12:02:34 GMT HINT: In a moment you should be able to reconnect to the database and repeat your command. 2009-02-04 12:02:34 GMT WARNING: terminating connection because of crash of another server process 2009-02-04 12:02:34 GMT DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 2009-02-04 12:02:34 GMT HINT: In a moment you should be able to reconnect to the database and repeat your command. 2009-02-04 12:02:34 GMT LOG: all server processes terminated; reinitializing 2009-02-04 12:02:35 GMT FATAL: pre-existing shared memory block is still in use 2009-02-04 12:02:35 GMT HINT: Check if there are any old server processes still running, and terminate them. I am a bit lost on what to do next. I have tried running the query several times even changing the parameters to make sure if it wasn't something in the sql. UPDATE gtable AS g SET code = '00' -- 04 WHERE g.code = '04' AND g.cc = 'TW'; UPDATE gtable AS g SET code = '00' -- 04 WHERE g.d IN (6724652, 1673813); Those two queries do exactly the same thing but they both crash with the same information, except for the length between the two queries. What should I do? Emilie Laffray
pgsql-general by date: