From: | Matt Gibbins <matt_gibbins(at)fastmail(dot)com(dot)au> |
---|---|
To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Segmentation fault when running queries in sequence |
Date: | 2023-09-23 10:53:08 |
Message-ID: | 728d1797-efdd-4298-8ab2-042a28ddaae2@fastmail.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I am running postgresql through an SSH tunnel to process a collection of
files on the server loading them into the database.
Specifically GTFS files
The process is as follows.
find ../Database\ management/SQL/Create\ tables/Landing -type f -name
'Bus *.sql' | sort -n | while read -r f;
do
echo "$f";
./Query\ to\ server "$f";
./Query\ to\ server "../Database management/SQL/Create
tables/AllServices/Insert landing - bus.sql";
done
The 'Query to server' script initiates an SSL session with the following
statement where postgresql_tcanalysis initiates an SSH tunnel to the
database on the remote server which I have SSH connection to.
postgresql_tcanalysis < "$1"
There is no problem with the SSH connection and running individual queries.
The issue occurs when stepping through the queries.
The find statement results in 19 queries. It is necessary to have
individual queries as the content of the GTFS files are not consistent
with regard to fields.
Attached is the STDOUT messages showing the progress of the the process
to segmentation fault.
Running the individual queries where the segfault occurs does not occur
for the individual query. The segfault only occurs when doing the bulk
process.
Also attached is the section from
/var/log/postgresql/postgresql-15-main.log relating to the segfault
occurence.
Any suggestions for identifying the cause appreciated.
Regards
Matt.
Attachment | Content-Type | Size |
---|---|---|
messages.txt | text/plain | 8.9 KB |
postgresql-15-main-segfault.log | text/x-log | 6.5 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | abbas alizadeh | 2023-09-23 11:38:17 | Re: Segmentation fault when running queries in sequence |
Previous Message | Holger Jakobs | 2023-09-23 09:34:24 | Re: Corruption issue |