~ crashes backend
In the current build on the anon cvs server, if I try to \d a table from
psql, the backend comes down. I played with the query a bit and
discovered any query using '~' operator in the where clause on any table
(catalog or otherwise) causes an immediate backend crash.
Can anybody confirm that this is not happening on a win32/non-win32
build? (I had to change a couple of things to compile, just want to make
sure I didn't break anything).
I did a make clean and a brand new initdb just to be safe.
Merlin
LOG: statement: select * from pg_catalog.pg_class where relname ~
'test';
LOG: server process (PID 4544) was terminated by signal 5
LOG: terminating any other active server processes
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back
the current transaction and exit, because another server proc
ess exited abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
FATAL: the database system is in recovery mode
LOG: all server processes terminated; reinitializing
LOG: database system was interrupted at 2004-05-21 11:22:35 Eastern
Daylight Time
LOG: checkpoint record is at 0/EEC050
LOG: redo record is at 0/EEC050; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 7678; next OID: 33592
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: record with zero length at 0/EEC090
LOG: redo is not required
LOG: database system is ready
LOG: statement: select * from chevy.cusfil limit 1;
LOG: statement: select * from chevy.cusfil where cust_addr1 ~ 'test';
LOG: server process (PID 5500) was terminated by signal 5
LOG: terminating any other active server processes
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back
the current transaction and exit, because another server proc
ess exited abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
I have binary install from snapshot from the other night on WINDOWS 2000
PRO and had same problem.
|---------+---------------------------------->
| | "Merlin Moncure" |
| | <merlin.moncure@rcsonli|
| | ne.com> |
| | Sent by: |
| | pgsql-hackers-owner@pos|
| | tgresql.org |
| | |
| | |
| | 05/21/2004 10:28 AM |
| | |
|---------+---------------------------------->
------------------------------------------------------------------------------------------------------------------------------|
| |
| To: <pgsql-hackers-win32@postgresql.org> |
| cc: <pgsql-hackers@postgresql.org> |
| Subject: [HACKERS] ~ crashes backend |
------------------------------------------------------------------------------------------------------------------------------|
In the current build on the anon cvs server, if I try to \d a table from
psql, the backend comes down. I played with the query a bit and
discovered any query using '~' operator in the where clause on any table
(catalog or otherwise) causes an immediate backend crash.
Can anybody confirm that this is not happening on a win32/non-win32
build? (I had to change a couple of things to compile, just want to make
sure I didn't break anything).
I did a make clean and a brand new initdb just to be safe.
Merlin
LOG: statement: select * from pg_catalog.pg_class where relname ~
'test';
LOG: server process (PID 4544) was terminated by signal 5
LOG: terminating any other active server processes
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back
the current transaction and exit, because another server proc
ess exited abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
FATAL: the database system is in recovery mode
LOG: all server processes terminated; reinitializing
LOG: database system was interrupted at 2004-05-21 11:22:35 Eastern
Daylight Time
LOG: checkpoint record is at 0/EEC050
LOG: redo record is at 0/EEC050; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 7678; next OID: 33592
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: record with zero length at 0/EEC090
LOG: redo is not required
LOG: database system is ready
LOG: statement: select * from chevy.cusfil limit 1;
LOG: statement: select * from chevy.cusfil where cust_addr1 ~ 'test';
LOG: server process (PID 5500) was terminated by signal 5
LOG: terminating any other active server processes
WARNING: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back
the current transaction and exit, because another server proc
ess exited abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
*************************************************************************
PRIVILEGED AND CONFIDENTIAL: This communication, including attachments, is for the exclusive use of addressee and may contain proprietary, confidential and/or privileged information. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this communication and destroy all copies.
*************************************************************************
Import Notes
Resolved by subject fallback
I have binary install from snapshot from the other night on WINDOWS
2000
PRO and had same problem.
well, I'm the one compiling the snapshot :), so I trying to confirm that
I have not busted anything...when did you download the snapshot, though?
I switched to gcc 3.4 yesterday, was it earlier than that?
Merlin
Import Notes
Resolved by subject fallback
I downloaded it this morning around 8:00 AM CENTRAL TIME. Thanks for the
builds by the way!
|---------+------------------------------>
| | "Merlin Moncure" |
| | <merlin.moncure@rcs|
| | online.com> |
| | |
| | 05/21/2004 10:39 AM|
| | |
|---------+------------------------------>
------------------------------------------------------------------------------------------------------------------------------|
| |
| To: <Bob.Henkel@hartfordlife.com> |
| cc: <pgsql-hackers@postgresql.org>, <pgsql-hackers-win32@postgresql.org> |
| Subject: RE: [HACKERS] ~ crashes backend |
------------------------------------------------------------------------------------------------------------------------------|
I have binary install from snapshot from the other night on WINDOWS
2000
PRO and had same problem.
well, I'm the one compiling the snapshot :), so I trying to confirm that
I have not busted anything...when did you download the snapshot, though?
I switched to gcc 3.4 yesterday, was it earlier than that?
Merlin
*************************************************************************
PRIVILEGED AND CONFIDENTIAL: This communication, including attachments, is for the exclusive use of addressee and may contain proprietary, confidential and/or privileged information. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this communication and destroy all copies.
*************************************************************************
Import Notes
Resolved by subject fallback
"Merlin Moncure" <merlin.moncure@rcsonline.com> writes:
In the current build on the anon cvs server, if I try to \d a table from
psql, the backend comes down. I played with the query a bit and
discovered any query using '~' operator in the where clause on any table
(catalog or otherwise) causes an immediate backend crash.
Can anybody confirm that this is not happening on a win32/non-win32
build?
CVS tip works fine for me on HPUX and Linux.
regards, tom lane
"Merlin Moncure" <merlin.moncure@rcsonline.com> writes:
In the current build on the anon cvs server, if I try to \d a table
from
psql, the backend comes down. I played with the query a bit and
discovered any query using '~' operator in the where clause on any
table
(catalog or otherwise) causes an immediate backend crash.
Can anybody confirm that this is not happening on a win32/non-win32
build?CVS tip works fine for me on HPUX and Linux.
The problem was gcc 3.4 for mingw. I reverted back to 3.3 and it works
ok now. No more pre-compiled headers, oh well :( This is probably not
a problem with gcc, but with mingw.
I updated the binary build with the corrected version.
Merlin
Import Notes
Resolved by subject fallback